APPS.PO_WF_PO_RULE_ACC dependencies on FND_FLEX_EXT

Line 356: l_segment_array FND_FLEX_EXT.SegmentArray;

352: IS
353: l_progress varchar2(100);
354: l_segments_number_sob NUMBER :=0;
355: l_get_result varchar2(25) := NULL;
356: l_segment_array FND_FLEX_EXT.SegmentArray;
357: l_delimiter VARCHAR2(10);
358: l_chart_of_accounts_id NUMBER;
359: l_concat_segs VARCHAR2(2000);
360: l_ccId NUMBER;

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

491:
492: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 07';
493:
494: --
495: -- Use the FND_FLEX_EXT pacakge to concatenate the segments
496: --
497: l_delimiter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#', l_chart_of_accounts_id);
498:
499: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 08';

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

493:
494: --
495: -- Use the FND_FLEX_EXT pacakge to concatenate the segments
496: --
497: l_delimiter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#', l_chart_of_accounts_id);
498:
499: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 08';
500:
501: IF (l_delimiter is not null) THEN

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

499: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 08';
500:
501: IF (l_delimiter is not null) THEN
502:
503: l_concat_segs := fnd_flex_ext.concatenate_segments(l_segment_table.count,l_segment_array, l_delimiter);
504:
505: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 09';
506:
507: 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 507: 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);

503: l_concat_segs := fnd_flex_ext.concatenate_segments(l_segment_table.count,l_segment_array, l_delimiter);
504:
505: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 09';
506:
507: 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);
508:
509: l_progress := 'PO_WF_PO_RULE_ACC.IF_RULE_EXIST_FOR_ALL_SEGMENTS: 10';
510:
511: if l_ccId is not null then