DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on FND_FLEX_EXT

Line 590: l_segments fnd_flex_ext.SegmentArray;

586: display_type in varchar2,
587: document in out NOCOPY varchar2,
588: document_type in out NOCOPY varchar2) IS
589: nsegments number;
590: l_segments fnd_flex_ext.SegmentArray;
591: l_cost_center VARCHAR2(200);
592: l_segment_num number;
593: l_column_name VARCHAR2(20);
594: l_link_url varchar2(4000);

Line 914: if fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) then

910: loop
911: fetch ccId_csr into cc_Id;
912: exit when ccid_csr%notfound;
913:
914: if fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) then
915: l_cost_center := l_segments(l_segment_num);
916: else
917: l_cost_center := '';
918: end if;

Line 933: if fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) then

929: end loop;
930: close ccId_csr;
931:
932: if l_cost_center <> multiple_cost_center then
933: if fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) then
934: l_cost_center := l_segments(l_segment_num);
935: else
936: l_cost_center := '';
937: end if;

Line 1101: l_segments fnd_flex_ext.SegmentArray;

1097: display_type in varchar2,
1098: document in out NOCOPY varchar2,
1099: document_type in out NOCOPY varchar2) IS
1100: nsegments number;
1101: l_segments fnd_flex_ext.SegmentArray;
1102: l_cost_center VARCHAR2(200);
1103: l_segment_num number;
1104: l_column_name VARCHAR2(20);
1105:

Line 1423: if fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) then

1419: loop
1420: fetch ccId_csr into cc_Id;
1421: exit when ccid_csr%notfound;
1422:
1423: if fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) then
1424: l_cost_center := l_segments(l_segment_num);
1425: else
1426: l_cost_center := '';
1427: end if;

Line 1442: if fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) then

1438: end loop;
1439: close ccId_csr;
1440:
1441: if l_cost_center <> multiple_cost_center then
1442: if fnd_flex_ext.get_segments( 'SQLGL','GL#', l_account_id,cc_id,nsegments,l_segments) then
1443: l_cost_center := l_segments(l_segment_num);
1444: else
1445: l_cost_center := '';
1446: end if;