APPS.POR_HISTORY_FEED_PKG dependencies on FND_FLEX_EXT

Line 1162: fnd_flex_ext.get_segs('SQLGL','GL#', GSB.CHART_OF_ACCOUNTS_ID, PD.CODE_COMBINATION_ID) ACCTNG_CODE,

1158: DECODE(PL.MATCHING_BASIS, 'AMOUNT', PD.AMOUNT_ORDERED, PD.QUANTITY_ORDERED) QTY, --detail
1159: DECODE(PL.MATCHING_BASIS, 'AMOUNT', 1,NVL(PD.RATE,1) * NVL(PLL.PRICE_OVERRIDE,PL.UNIT_PRICE)) UNIT_PRICE, --detail
1160: DECODE(PL.MATCHING_BASIS, 'AMOUNT', PD.AMOUNT_ORDERED, NVL(PD.RATE,1) * (PD.QUANTITY_ORDERED * NVL(PLL.PRICE_OVERRIDE,PL.UNIT_PRICE))) AMOUNT, --control, header
1161: GSB.CHART_OF_ACCOUNTS_ID CHART_ACCTS_ID, -- ref
1162: fnd_flex_ext.get_segs('SQLGL','GL#', GSB.CHART_OF_ACCOUNTS_ID, PD.CODE_COMBINATION_ID) ACCTNG_CODE,
1163: PH.AUTHORIZATION_STATUS APPR_STATUS, --for order status
1164: PH.APPROVED_DATE APPR_DATE, --for order status
1165: PH.CLOSED_CODE CONTROL_STATUS, --for order status
1166: PH.CANCEL_FLAG CANCEL_FLAG, --for order status

Line 1239: fnd_flex_ext.get_segs('SQLGL','GL#', GSB.CHART_OF_ACCOUNTS_ID, PD.CODE_COMBINATION_ID) ACCTNG_CODE,

1235: DECODE(PL.MATCHING_BASIS, 'AMOUNT', PD.AMOUNT_ORDERED,PD.QUANTITY_ORDERED) QTY, --detail
1236: DECODE(PL.MATCHING_BASIS, 'AMOUNT', 1,NVL(PD.RATE,1) * NVL(PLL.PRICE_OVERRIDE,PL.UNIT_PRICE)) UNIT_PRICE, --detail
1237: DECODE(PL.MATCHING_BASIS, 'AMOUNT', PD.AMOUNT_ORDERED,NVL(PD.RATE,1) * (PD.QUANTITY_ORDERED * NVL(PLL.PRICE_OVERRIDE,PL.UNIT_PRICE))) AMOUNT, --control, header
1238: GSB.CHART_OF_ACCOUNTS_ID CHART_ACCTS_ID, -- ref
1239: fnd_flex_ext.get_segs('SQLGL','GL#', GSB.CHART_OF_ACCOUNTS_ID, PD.CODE_COMBINATION_ID) ACCTNG_CODE,
1240: PH.AUTHORIZATION_STATUS APPR_STATUS, --for order status
1241: PH.APPROVED_DATE APPR_DATE, --for order status
1242: PH.CLOSED_CODE CONTROL_STATUS, --for order status
1243: PH.CANCEL_FLAG CANCEL_FLAG, --for order status

Line 1312: fnd_flex_ext.get_segs('SQLGL','GL#', GSB.CHART_OF_ACCOUNTS_ID, PD.CODE_COMBINATION_ID) ACCTNG_CODE,

1308: DECODE(PL.MATCHING_BASIS, 'AMOUNT', PD.AMOUNT_ORDERED, PD.QUANTITY_ORDERED) QTY, --detail
1309: DECODE(PL.MATCHING_BASIS, 'AMOUNT', 1, NVL(PD.RATE,1) * NVL(PLL.PRICE_OVERRIDE,PL.UNIT_PRICE)) UNIT_PRICE, --detail
1310: DECODE(PL.MATCHING_BASIS, 'AMOUNT', PD.AMOUNT_ORDERED, NVL(PD.RATE,1) * (PD.QUANTITY_ORDERED * NVL(PLL.PRICE_OVERRIDE,PL.UNIT_PRICE))) AMOUNT, --control, header
1311: GSB.CHART_OF_ACCOUNTS_ID CHART_ACCTS_ID, --ref
1312: fnd_flex_ext.get_segs('SQLGL','GL#', GSB.CHART_OF_ACCOUNTS_ID, PD.CODE_COMBINATION_ID) ACCTNG_CODE,
1313: PR.AUTHORIZATION_STATUS APPR_STATUS, --for order status
1314: PR.APPROVED_DATE APPR_DATE, --for order status
1315: PR.CLOSED_CODE CONTROL_STATUS, --for order status
1316: PR.CANCEL_FLAG CANCEL_FLAG, --for order status

Line 1388: fnd_flex_ext.get_segs('SQLGL','GL#', GSB.CHART_OF_ACCOUNTS_ID, PD.CODE_COMBINATION_ID) ACCTNG_CODE,

1384: DECODE(PL.MATCHING_BASIS, 'AMOUNT', PD.AMOUNT_ORDERED, PD.QUANTITY_ORDERED) QTY, --detail
1385: DECODE(PL.MATCHING_BASIS, 'AMOUNT', 1, NVL(PD.RATE,1) * NVL(PLL.PRICE_OVERRIDE,PL.UNIT_PRICE)) UNIT_PRICE, --detail
1386: DECODE(PL.MATCHING_BASIS, 'AMOUNT', PD.AMOUNT_ORDERED, NVL(PD.RATE,1) * (PD.QUANTITY_ORDERED * NVL(PLL.PRICE_OVERRIDE,PL.UNIT_PRICE))) AMOUNT, --control, header
1387: GSB.CHART_OF_ACCOUNTS_ID CHART_ACCTS_ID, -- ref
1388: fnd_flex_ext.get_segs('SQLGL','GL#', GSB.CHART_OF_ACCOUNTS_ID, PD.CODE_COMBINATION_ID) ACCTNG_CODE,
1389: PR.AUTHORIZATION_STATUS APPR_STATUS, --for order status
1390: PR.APPROVED_DATE APPR_DATE, --for order status
1391: PR.CLOSED_CODE CONTROL_STATUS, --for order status
1392: PR.CANCEL_FLAG CANCEL_FLAG, --for order status

Line 1887: g_delimiter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#', l_org_chart_of_accounts_id);

1883: AND fsp.org_id = g_org_id;
1884:
1885: l_progress := '300';
1886:
1887: g_delimiter := fnd_flex_ext.get_delimiter('SQLGL', 'GL#', l_org_chart_of_accounts_id);
1888:
1889: g_max_card_num_size := Get_Field_Size ('CARD_NUMBER','H');
1890: g_max_po_num_size := Get_Field_Size ('PO_NUMBER','H');
1891: