[Home] [Help]
5325:
5326: l_ae_line_rec ar_ae_alloc_rec_gt%ROWTYPE ;
5327: l_ctr BINARY_INTEGER ;
5328: l_actual_account ar_distributions.code_combination_id%TYPE ;
5329: l_source_type ar_distributions.source_type%TYPE ;
5330:
5331: --PL/SQL table object,this collection is used for bulk processing of inserts
5332: TYPE ae_alloc_rec_gt_tab IS TABLE OF ar_ae_alloc_rec_gt%ROWTYPE INDEX BY BINARY_INTEGER;
5333: l_ae_alloc_rec_gt_tab ae_alloc_rec_gt_tab;
5835: l_org_inv_loc_seg_id ar_distributions.location_segment_id%TYPE ;
5836: l_taxable_amt NUMBER;
5837: l_taxable_acctd_amt NUMBER;
5838:
5839: l_source_type_secondary ar_distributions.source_type_secondary%TYPE;
5840:
5841: --PL/SQL table object,this collection is used for bulk processing of inserts
5842: TYPE ae_alloc_rec_gt_tab IS TABLE OF ar_ae_alloc_rec_gt%ROWTYPE INDEX BY BINARY_INTEGER;
5843: l_ae_alloc_rec_gt_tab ae_alloc_rec_gt_tab;
7737: activity_bucket,
7738: ref_dist_ccid,
7739: ref_mf_dist_flag
7740: )
7741: SELECT ar_distributions_s.nextval,
7742: al.ae_source_id,
7743: al.ae_source_table,
7744: al.ae_line_type,
7745: al.ae_line_type_secondary,
8401: -- arp_standard.debug('source type = ' || l_ae_line_rec.source_type);
8402: -- if (l_ae_line_rec.source_type = 'EXCH_GAIN' or
8403: -- l_ae_line_rec.source_type = 'EXCH_LOSS' or
8404: -- l_ae_line_rec.source_type = 'CURR_ROUND' ) THEN
8405: -- select ar_distributions_s.nextval
8406: -- into l_ae_line_rec.line_id
8407: -- from dual;
8408: -- ELSE
8409: -- BEGIN
8423: -- and code_combination_id = l_ae_line_rec.code_combination_id;
8424: -- EXCEPTION
8425: -- WHEN OTHERS THEN
8426: -- arp_standard.debug('Can not determine Line id so created new one');
8427: -- select ar_distributions_s.nextval
8428: -- into l_ae_line_rec.line_id
8429: -- from dual;
8430: -- END;
8431: -- arp_standard.debug('line id = ' || to_char(l_ae_line_rec.line_id));