I would like to ask for a little enhancement concerning beatifying record value assignments. The betifier works fine, as long as you just have a single record to be filled. But in the case of an PLSQL-Table it fails.
GOOD!
p_r_process_line.chr_id := p_r_process.chr_id;
p_r_process_line.dnz_chr_id := p_r_process.chr_id;
p_r_process_line.inventory_item_id := p_r_process.bus_process_id1;
p_r_process_line.organization_id := p_r_process.bus_process_id2;
p_r_process_line.item_source := 'OKX_BUSIPROC';
p_r_process_line.lse_id := 3;
p_r_process_line.currency_code := p_r_process.currency_code;
p_r_process_line.start_date := p_r_process.start_date;
p_r_process_line.end_date := p_r_process.end_date;
BAD!
p_clev_tbl(1).cle_id := p_r_process.cov_id;
p_clev_tbl(1).id := p_r_process.pro_id;
p_clev_tbl(1).lse_id := p_r_process_line.lse_id;
p_clev_tbl(1).dnz_chr_id := p_r_process.chr_id;
p_clev_tbl(1).object_version_number := p_r_process.object_version_number;
p_clev_tbl(1).display_sequence := 1;
p_clev_tbl(1).exception_yn := 'N';
p_clev_tbl(1).sts_code := p_r_process.sts_code;
p_clev_tbl(1).currency_code := p_r_process.currency_code;
I would appreciate to see this on your list of enhancement requests.
Thanks in advance
Holger