132: l_vendor_id ap_suppliers.vendor_id%TYPE;
133: l_vendor_type ap_suppliers.vendor_type_lookup_code%TYPE;
134: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
135: l_offset_flag varchar2(1);
136: l_acc_dist_tbl Fnd_Flex_Ext.segmentarray;
137: l_fv_low_tbl Fnd_Flex_Ext.segmentarray;
138: l_fv_high_tbl Fnd_Flex_Ext.segmentarray;
139: l_breakup_seg NUMBER;
140: l_segment_nos NUMBER;
133: l_vendor_type ap_suppliers.vendor_type_lookup_code%TYPE;
134: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
135: l_offset_flag varchar2(1);
136: l_acc_dist_tbl Fnd_Flex_Ext.segmentarray;
137: l_fv_low_tbl Fnd_Flex_Ext.segmentarray;
138: l_fv_high_tbl Fnd_Flex_Ext.segmentarray;
139: l_breakup_seg NUMBER;
140: l_segment_nos NUMBER;
141: l_get_segments_flag BOOLEAN;
134: l_vendor_site_id ap_invoices_all.vendor_site_id%TYPE;
135: l_offset_flag varchar2(1);
136: l_acc_dist_tbl Fnd_Flex_Ext.segmentarray;
137: l_fv_low_tbl Fnd_Flex_Ext.segmentarray;
138: l_fv_high_tbl Fnd_Flex_Ext.segmentarray;
139: l_breakup_seg NUMBER;
140: l_segment_nos NUMBER;
141: l_get_segments_flag BOOLEAN;
142: l_ctr NUMBER;
217: from gl_ledgers
218: where ledger_id = l_ledger_id;
219:
220:
221: l_delimiter := fnd_flex_ext.get_delimiter('SQLGL'
222: ,'GL#'
223: ,l_coa);
224:
225:
266:
267:
268: /*Determining the segment values and storing in a pl/sql table
269: l_acc_dist_tbl*/
270: l_get_segments_flag := fnd_flex_ext.get_segments
271: (application_short_name =>'SQLGL'
272: ,key_flex_code => 'GL#'
273: ,structure_number => l_coa
274: ,combination_id =>
283: /*Determining the segment values and storing in a pl/sql table
284: l_fv_low_tbl , l_fv_high_tbl based on the value in
285: CONCATENATED_SEGMENTS_LOW , CONCATENATED_SEGMENTS_HIGH */
286:
287: l_breakup_seg := fnd_flex_ext.breakup_segments
288: (accounts_criteria_rec.CONCATENATED_SEGMENTS_LOW
289: ,l_delimiter
290: ,l_fv_low_tbl ) ;
291: l_breakup_seg := fnd_flex_ext.breakup_segments
287: l_breakup_seg := fnd_flex_ext.breakup_segments
288: (accounts_criteria_rec.CONCATENATED_SEGMENTS_LOW
289: ,l_delimiter
290: ,l_fv_low_tbl ) ;
291: l_breakup_seg := fnd_flex_ext.breakup_segments
292: (accounts_criteria_rec.CONCATENATED_SEGMENTS_HIGH
293: ,l_delimiter
294: ,l_fv_high_tbl ) ;
295: l_ctr := 0 ;