DBA Data[Home] [Help]

APPS.ZX_TAX_RECOVERY_PKG dependencies on FND_FLEX_EXT

Line 130: l_passed_segs_array fnd_flex_ext.SegmentArray;

126: p_chart_of_accts IN VARCHAR2) return NUMBER IS
127:
128:
129: l_nsegs number;
130: l_passed_segs_array fnd_flex_ext.SegmentArray;
131: l_db_segs_array_low fnd_flex_ext.SegmentArray;
132: l_db_segs_array_high fnd_flex_ext.SegmentArray;
133: i number;
134: -- 1 stands for account in the range, 0 stands for account NOT in range.

Line 131: l_db_segs_array_low fnd_flex_ext.SegmentArray;

127:
128:
129: l_nsegs number;
130: l_passed_segs_array fnd_flex_ext.SegmentArray;
131: l_db_segs_array_low fnd_flex_ext.SegmentArray;
132: l_db_segs_array_high fnd_flex_ext.SegmentArray;
133: i number;
134: -- 1 stands for account in the range, 0 stands for account NOT in range.
135: in_range number := 1;

Line 132: l_db_segs_array_high fnd_flex_ext.SegmentArray;

128:
129: l_nsegs number;
130: l_passed_segs_array fnd_flex_ext.SegmentArray;
131: l_db_segs_array_low fnd_flex_ext.SegmentArray;
132: l_db_segs_array_high fnd_flex_ext.SegmentArray;
133: i number;
134: -- 1 stands for account in the range, 0 stands for account NOT in range.
135: in_range number := 1;
136:

Line 149: -- Call fnd_flex_ext.breakup_segments to break up segments

145: -- Bugfix 1798261
146: --AP_LOGGING_PKG.AP_End_Block(debug_loc);
147: --AP_LOGGING_PKG.AP_End_Log;
148:
149: -- Call fnd_flex_ext.breakup_segments to break up segments
150: l_nsegs := fnd_flex_ext.breakup_segments
151: (concatenated_segs => p_passed_concat_segs,
152: delimiter => g_delimiter,
153: segments => l_passed_segs_array);

Line 150: l_nsegs := fnd_flex_ext.breakup_segments

146: --AP_LOGGING_PKG.AP_End_Block(debug_loc);
147: --AP_LOGGING_PKG.AP_End_Log;
148:
149: -- Call fnd_flex_ext.breakup_segments to break up segments
150: l_nsegs := fnd_flex_ext.breakup_segments
151: (concatenated_segs => p_passed_concat_segs,
152: delimiter => g_delimiter,
153: segments => l_passed_segs_array);
154:

Line 163: l_nsegs := fnd_flex_ext.breakup_segments

159: in_range := 0;
160: RETURN in_range; -- Bug#14166406 : Moved the Return statement inside IF
161: END IF;
162:
163: l_nsegs := fnd_flex_ext.breakup_segments
164: (concatenated_segs => p_db_concat_segs_low,
165: delimiter => g_delimiter,
166: segments => l_db_segs_array_low);
167:

Line 168: l_nsegs := fnd_flex_ext.breakup_segments

164: (concatenated_segs => p_db_concat_segs_low,
165: delimiter => g_delimiter,
166: segments => l_db_segs_array_low);
167:
168: l_nsegs := fnd_flex_ext.breakup_segments
169: (concatenated_segs => p_db_concat_segs_high,
170: delimiter => g_delimiter,
171: segments => l_db_segs_array_high);
172:

Line 298: l_form_segs_array_low fnd_flex_ext.SegmentArray;

294:
295: l_chart_of_accts gl_sets_of_books.chart_of_accounts_id%TYPE;
296: l_delimiter varchar2(1);
297: l_nsegs number;
298: l_form_segs_array_low fnd_flex_ext.SegmentArray;
299: l_form_segs_array_high fnd_flex_ext.SegmentArray;
300: l_db_segs_array_low fnd_flex_ext.SegmentArray;
301: l_db_segs_array_high fnd_flex_ext.SegmentArray;
302: i number;

Line 299: l_form_segs_array_high fnd_flex_ext.SegmentArray;

295: l_chart_of_accts gl_sets_of_books.chart_of_accounts_id%TYPE;
296: l_delimiter varchar2(1);
297: l_nsegs number;
298: l_form_segs_array_low fnd_flex_ext.SegmentArray;
299: l_form_segs_array_high fnd_flex_ext.SegmentArray;
300: l_db_segs_array_low fnd_flex_ext.SegmentArray;
301: l_db_segs_array_high fnd_flex_ext.SegmentArray;
302: i number;
303: -- 1 stands for overlapping, 0 stands for NOT overlapping

Line 300: l_db_segs_array_low fnd_flex_ext.SegmentArray;

296: l_delimiter varchar2(1);
297: l_nsegs number;
298: l_form_segs_array_low fnd_flex_ext.SegmentArray;
299: l_form_segs_array_high fnd_flex_ext.SegmentArray;
300: l_db_segs_array_low fnd_flex_ext.SegmentArray;
301: l_db_segs_array_high fnd_flex_ext.SegmentArray;
302: i number;
303: -- 1 stands for overlapping, 0 stands for NOT overlapping
304: account_overlap number :=1;

Line 301: l_db_segs_array_high fnd_flex_ext.SegmentArray;

297: l_nsegs number;
298: l_form_segs_array_low fnd_flex_ext.SegmentArray;
299: l_form_segs_array_high fnd_flex_ext.SegmentArray;
300: l_db_segs_array_low fnd_flex_ext.SegmentArray;
301: l_db_segs_array_high fnd_flex_ext.SegmentArray;
302: i number;
303: -- 1 stands for overlapping, 0 stands for NOT overlapping
304: account_overlap number :=1;
305:

Line 323: -- Call fnd_flex_ext.get_delimiter to get delimiter

319: FROM gl_sets_of_books,ap_system_parameters_all
320: WHERE gl_sets_of_books.set_of_books_id = ap_system_parameters_all.set_of_books_id;
321:
322:
323: -- Call fnd_flex_ext.get_delimiter to get delimiter
324:
325:
326: l_delimiter := fnd_flex_ext.get_delimiter
327: (application_short_name => 'SQLGL',

Line 326: l_delimiter := fnd_flex_ext.get_delimiter

322:
323: -- Call fnd_flex_ext.get_delimiter to get delimiter
324:
325:
326: l_delimiter := fnd_flex_ext.get_delimiter
327: (application_short_name => 'SQLGL',
328: key_flex_code => 'GL#',
329: structure_number => l_chart_of_accts);
330:

Line 332: -- Call fnd_flex_ext.breakup_segments to break up segments

328: key_flex_code => 'GL#',
329: structure_number => l_chart_of_accts);
330:
331:
332: -- Call fnd_flex_ext.breakup_segments to break up segments
333:
334:
335: l_nsegs := fnd_flex_ext.breakup_segments
336: (concatenated_segs => p_form_concat_segs_low,

Line 335: l_nsegs := fnd_flex_ext.breakup_segments

331:
332: -- Call fnd_flex_ext.breakup_segments to break up segments
333:
334:
335: l_nsegs := fnd_flex_ext.breakup_segments
336: (concatenated_segs => p_form_concat_segs_low,
337: delimiter => l_delimiter,
338: segments => l_form_segs_array_low);
339:

Line 341: l_nsegs := fnd_flex_ext.breakup_segments

337: delimiter => l_delimiter,
338: segments => l_form_segs_array_low);
339:
340:
341: l_nsegs := fnd_flex_ext.breakup_segments
342: (concatenated_segs => p_form_concat_segs_high,
343: delimiter => l_delimiter,
344: segments => l_form_segs_array_high);
345:

Line 349: l_nsegs := fnd_flex_ext.breakup_segments

345:
346:
347:
348:
349: l_nsegs := fnd_flex_ext.breakup_segments
350: (concatenated_segs => p_db_concat_segs_low,
351: delimiter => l_delimiter,
352: segments => l_db_segs_array_low);
353:

Line 355: l_nsegs := fnd_flex_ext.breakup_segments

351: delimiter => l_delimiter,
352: segments => l_db_segs_array_low);
353:
354:
355: l_nsegs := fnd_flex_ext.breakup_segments
356: (concatenated_segs => p_db_concat_segs_high,
357: delimiter => l_delimiter,
358: segments => l_db_segs_array_high);
359:

Line 739: -- Call fnd_flex_ext.get_delimiter to get delimiter

735:
736: -- initialize;
737: g_chart_of_accts := p_chart_of_accounts_id;
738:
739: -- Call fnd_flex_ext.get_delimiter to get delimiter
740:
741: g_delimiter := fnd_flex_ext.get_delimiter
742: (application_short_name => 'SQLGL',
743: key_flex_code => 'GL#',

Line 741: g_delimiter := fnd_flex_ext.get_delimiter

737: g_chart_of_accts := p_chart_of_accounts_id;
738:
739: -- Call fnd_flex_ext.get_delimiter to get delimiter
740:
741: g_delimiter := fnd_flex_ext.get_delimiter
742: (application_short_name => 'SQLGL',
743: key_flex_code => 'GL#',
744: structure_number => g_chart_of_accts);
745:

Line 776: lp_concatenate := fnd_flex_ext.get_segs

772: FETCH c_get_match_on_tax_flag into l_match_on_tax_flag;
773: CLOSE c_get_match_on_tax_flag;
774: == */
775:
776: lp_concatenate := fnd_flex_ext.get_segs
777: ('SQLGL','GL#', g_chart_of_accts, p_code_combination_id);
778:
779: IF lp_concatenate is null then
780: lp_concatenate := p_concatenated_segments;

Line 835: -- Call fnd_flex_ext.get_delimiter to get delimiter

831: OPEN c_chart_of_accts;
832: FETCH c_chart_of_accts INTO g_chart_of_accts;
833: CLOSE c_chart_of_accts;
834:
835: -- Call fnd_flex_ext.get_delimiter to get delimiter
836:
837: g_delimiter := fnd_flex_ext.get_delimiter
838: (application_short_name => 'SQLGL',
839: key_flex_code => 'GL#',

Line 837: g_delimiter := fnd_flex_ext.get_delimiter

833: CLOSE c_chart_of_accts;
834:
835: -- Call fnd_flex_ext.get_delimiter to get delimiter
836:
837: g_delimiter := fnd_flex_ext.get_delimiter
838: (application_short_name => 'SQLGL',
839: key_flex_code => 'GL#',
840: structure_number => g_chart_of_accts);
841: