DBA Data[Home] [Help]

APPS.PO_WF_PO_RULE_ACC dependencies on FND_FLEX_EXT

Line 262: l_segment_array FND_FLEX_EXT.SegmentArray;

258: IS
259: l_progress varchar2(100);
260: l_segments_number_sob NUMBER :=0;
261: l_get_result varchar2(25) := NULL;
262: l_segment_array FND_FLEX_EXT.SegmentArray;
263: l_delimiter VARCHAR2(10);
264: l_chart_of_accounts_id NUMBER;
265: l_concat_segs VARCHAR2(2000);
266: l_ccId NUMBER;

Line 401: -- Use the FND_FLEX_EXT pacakge to concatenate the segments

397:
398: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 07';
399:
400: --
401: -- Use the FND_FLEX_EXT pacakge to concatenate the segments
402: --
403: l_delimiter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#', l_chart_of_accounts_id);
404:
405: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 08';

Line 403: l_delimiter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#', l_chart_of_accounts_id);

399:
400: --
401: -- Use the FND_FLEX_EXT pacakge to concatenate the segments
402: --
403: l_delimiter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#', l_chart_of_accounts_id);
404:
405: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 08';
406:
407: IF (l_delimiter is not null) THEN

Line 409: l_concat_segs := fnd_flex_ext.concatenate_segments(l_segment_table.count,l_segment_array, l_delimiter);

405: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 08';
406:
407: IF (l_delimiter is not null) THEN
408:
409: l_concat_segs := fnd_flex_ext.concatenate_segments(l_segment_table.count,l_segment_array, l_delimiter);
410:
411: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 09';
412:
413: l_ccId := fnd_flex_ext.get_ccid('SQLGL','GL#',l_chart_of_accounts_id, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),l_concat_segs);

Line 413: l_ccId := fnd_flex_ext.get_ccid('SQLGL','GL#',l_chart_of_accounts_id, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),l_concat_segs);

409: l_concat_segs := fnd_flex_ext.concatenate_segments(l_segment_table.count,l_segment_array, l_delimiter);
410:
411: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 09';
412:
413: l_ccId := fnd_flex_ext.get_ccid('SQLGL','GL#',l_chart_of_accounts_id, to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),l_concat_segs);
414:
415: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 10';
416:
417: if l_ccId is not null then