APPS.PSA_BC_XML_REPORT_PUB dependencies on FND_FLEX_EXT

Line 556: l_segments fnd_flex_ext.SegmentArray;

552: l_result BOOLEAN;
553: l_fund_value VARCHAR2(30);
554: l_treasury_symbol VARCHAR2(100);
555: l_no_of_segments NUMBER;
556: l_segments fnd_flex_ext.SegmentArray;
557: begin
558: l_api_name := g_full_path||'get_treasury_symbol';
559: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid ='||p_ccid);
560:

Line 566: l_result := fnd_flex_ext.get_segments

562: psa_utils.debug_other_string(g_state_level,l_api_name,'p_ccid IS NULL. Return NULL.');
563: return NULL;
564: END IF;
565:
566: l_result := fnd_flex_ext.get_segments
567: (
568: application_short_name => 'SQLGL',
569: key_flex_code => 'GL#',
570: structure_number => l_coaid,

Line 879: FND_FLEX_EXT.GET_SEGS('SQLGL',

875: NULL VENDOR_NAME,
876: NULL VENDOR_SITE_NAME,
877: NULL PAYMENT_FORECAST_LINE_NUMBER,
878: NULL PA_FLAG,
879: FND_FLEX_EXT.GET_SEGS('SQLGL',
880: 'GL#', l_coaid,
881: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
882: 'N' SUMMARY_ACCOUNT_INDICATOR,
883: NULL PO_LINE_NUMBER,

Line 1014: FND_FLEX_EXT.GET_SEGS('SQLGL',

1010: PV.VENDOR_NAME VENDOR_NAME,
1011: PVS.VENDOR_SITE_CODE VENDOR_SITE_NAME,
1012: NULL PAYMENT_FORECAST_LINE_NUMBER,
1013: NULL PA_FLAG,
1014: FND_FLEX_EXT.GET_SEGS('SQLGL',
1015: 'GL#',l_coaid,
1016: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
1017: 'N' SUMMARY_ACCOUNT_INDICATOR,
1018: NULL PO_LINE_NUMBER,

Line 1172: FND_FLEX_EXT.GET_SEGS('SQLGL',

1168: PV.VENDOR_NAME VENDOR_NAME,
1169: PVS.VENDOR_SITE_CODE VENDOR_SITE_NAME,
1170: NULL PAYMENT_FORECAST_LINE_NUMBER,
1171: NULL PA_FLAG,
1172: FND_FLEX_EXT.GET_SEGS('SQLGL',
1173: 'GL#', l_coaid,
1174: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
1175: 'N' SUMMARY_ACCOUNT_INDICATOR,
1176: NULL PO_LINE_NUMBER,

Line 1342: FND_FLEX_EXT.GET_SEGS('SQLGL',

1338: PV.VENDOR_NAME VENDOR_NAME,
1339: PVS.VENDOR_SITE_CODE VENDOR_SITE_NAME,
1340: NULL PAYMENT_FORECAST_LINE_NUMBER,
1341: NULL PA_FLAG,
1342: FND_FLEX_EXT.GET_SEGS('SQLGL',
1343: 'GL#', l_coaid,
1344: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
1345: 'N' SUMMARY_ACCOUNT_INDICATOR,
1346: PL.LINE_NUM PO_LINE_NUMBER,

Line 1502: FND_FLEX_EXT.GET_SEGS('SQLGL',

1498: PV.VENDOR_NAME VENDOR_NAME,
1499: PVS.VENDOR_SITE_CODE VENDOR_SITE_NAME,
1500: NULL PAYMENT_FORECAST_LINE_NUMBER,
1501: NULL PA_FLAG,
1502: FND_FLEX_EXT.GET_SEGS('SQLGL',
1503: 'GL#', l_coaid,
1504: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
1505: 'N' SUMMARY_ACCOUNT_INDICATOR,
1506: NULL PO_LINE_NUMBER,

Line 1666: FND_FLEX_EXT.GET_SEGS('SQLGL',

1662: PV.VENDOR_NAME VENDOR_NAME,
1663: PVS.VENDOR_SITE_CODE VENDOR_SITE_NAME,
1664: NULL PAYMENT_FORECAST_LINE_NUMBER,
1665: NULL PA_FLAG,
1666: FND_FLEX_EXT.GET_SEGS('SQLGL',
1667: 'GL#', l_coaid,
1668: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
1669: 'N' SUMMARY_ACCOUNT_INDICATOR,
1670: NULL PO_LINE_NUMBER,

Line 1960: FND_FLEX_EXT.GET_SEGS('SQLGL',

1956: NULL VENDOR_NAME,
1957: NULL VENDOR_SITE_NAME,
1958: NULL PAYMENT_FORECAST_LINE_NUMBER,
1959: NULL PA_FLAG,
1960: FND_FLEX_EXT.GET_SEGS('SQLGL',
1961: 'GL#', l_coaid,
1962: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
1963: 'N' SUMMARY_ACCOUNT_INDICATOR,
1964: NULL PO_LINE_NUMBER,

Line 2109: FND_FLEX_EXT.GET_SEGS('SQLGL',

2105: NULL VENDOR_NAME,
2106: NULL VENDOR_SITE_NAME,
2107: NULL PAYMENT_FORECAST_LINE_NUMBER,
2108: NULL PA_FLAG,
2109: FND_FLEX_EXT.GET_SEGS('SQLGL',
2110: 'GL#', l_coaid,
2111: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
2112: DECODE(PBRV.TEMPLATE_ID,
2113: NULL, 'N', 'Y') SUMMARY_ACCOUNT_INDICATOR,

Line 2235: FND_FLEX_EXT.GET_SEGS('SQLGL',

2231: NULL VENDOR_NAME,
2232: NULL VENDOR_SITE_NAME,
2233: NULL PAYMENT_FORECAST_LINE_NUMBER,
2234: NULL PA_FLAG,
2235: FND_FLEX_EXT.GET_SEGS('SQLGL',
2236: 'GL#', l_coaid,
2237: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
2238: DECODE(PBRV.TEMPLATE_ID,
2239: NULL, 'N', 'Y') SUMMARY_ACCOUNT_INDICATOR,

Line 2400: FND_FLEX_EXT.GET_SEGS('SQLGL',

2396: NULL VENDOR_NAME,
2397: NULL VENDOR_SITE_NAME,
2398: NULL PAYMENT_FORECAST_LINE_NUMBER,
2399: NULL PA_FLAG,
2400: FND_FLEX_EXT.GET_SEGS('SQLGL',
2401: 'GL#', l_coaid,
2402: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
2403: 'N' SUMMARY_ACCOUNT_INDICATOR,
2404: NULL PO_LINE_NUMBER,

Line 2523: FND_FLEX_EXT.GET_SEGS('SQLGL',

2519: NULL VENDOR_NAME,
2520: NULL VENDOR_SITE_NAME,
2521: NULL PAYMENT_FORECAST_LINE_NUMBER,
2522: NULL PA_FLAG,
2523: FND_FLEX_EXT.GET_SEGS('SQLGL',
2524: 'GL#', l_coaid,
2525: PBRV.code_combination_id) ACCOUNTING_FLEXFIELD,
2526: 'N' SUMMARY_ACCOUNT_INDICATOR,
2527: NULL PO_LINE_NUMBER,

Line 2695: MIN(FND_FLEX_EXT.GET_SEGS('SQLGL', 'GL#', l_coaid, pbrv.code_combination_id)),

2691: PBRG.VENDOR_NAME,
2692: PBRG.VENDOR_SITE_NAME,
2693: NULL,
2694: MIN(PBRG.PA_FLAG),
2695: MIN(FND_FLEX_EXT.GET_SEGS('SQLGL', 'GL#', l_coaid, pbrv.code_combination_id)),
2696: 'Y',
2697: NULL,
2698: NULL,
2699: NULL,