APPS.CST_XLA_PVT dependencies on PJM_ORG_PARAMETERS

Line 379: /*l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;*/

375: l_event_type_id RCV_ACCOUNTING_EVENTS.EVENT_TYPE_ID%TYPE;
376:
377: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
378: l_parent_rcv_txn_id NUMBER;
379: /*l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;*/
380:
381:
382: /* Budgetary Control */
383: l_bc_status VARCHAR2(2000);

Line 439: FROM PJM_ORG_PARAMETERS

435: l_stmt_num := 5;
436: BEGIN
437: SELECT NVL(PA_POSTING_FLAG, 'N')
438: INTO l_pjm_blueprint
439: FROM PJM_ORG_PARAMETERS
440: WHERE ORGANIZATION_ID = p_trx_info.inv_organization_id;
441: EXCEPTION
442: WHEN NO_DATA_FOUND THEN
443: l_pjm_blueprint := 'N';

Line 882: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

878: l_events CST_XLA_PVT.t_cst_inv_events;
879: l_event_id NUMBER;
880: l_index pls_integer;
881: l_txfr_process_flag MTL_PARAMETERS.PROCESS_ENABLED_FLAG%TYPE;
882: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
883:
884: /* Budgetary Control */
885: l_bc_status VARCHAR2(2000);
886: l_bc_event_id NUMBER;

Line 963: FROM PJM_ORG_PARAMETERS

959: drop shipment.
960: */
961: SELECT NVL(PA_POSTING_FLAG, 'N')
962: INTO l_pjm_blueprint
963: FROM PJM_ORG_PARAMETERS
964: WHERE ORGANIZATION_ID = p_trx_info.txn_organization_id
965: AND EXISTS ( SELECT 'X'
966: FROM MTL_MATERIAL_TRANSACTIONS MMT
967: WHERE MMT.TRANSACTION_ID = p_trx_info.transaction_id

Line 1601: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

1597: l_msg_count NUMBER := 0;
1598: l_msg_data VARCHAR2(8000);
1599: l_stmt_num NUMBER := 0;
1600: l_api_message VARCHAR2(1000);
1601: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
1602:
1603: -- SLA Data Structures
1604: l_source_data XLA_EVENTS_PUB_PKG.t_event_source_info;
1605: l_reference_data XLA_EVENTS_PUB_PKG.t_event_reference_info;

Line 1661: FROM PJM_ORG_PARAMETERS

1657: l_stmt_num := 5;
1658: BEGIN
1659: SELECT NVL(PA_POSTING_FLAG, 'N')
1660: INTO l_pjm_blueprint
1661: FROM PJM_ORG_PARAMETERS
1662: WHERE ORGANIZATION_ID = p_trx_info.inv_organization_id;
1663: EXCEPTION
1664: WHEN NO_DATA_FOUND THEN
1665: l_pjm_blueprint := 'N';

Line 1878: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

1874:
1875: l_ledger_id NUMBER;
1876: l_operating_unit NUMBER;
1877: l_index NUMBER;
1878: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
1879:
1880:
1881: /* FND Logging */
1882: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;

Line 1920: FROM PJM_ORG_PARAMETERS

1916: l_stmt_num := 5;
1917: BEGIN
1918: SELECT NVL(PA_POSTING_FLAG, 'N')
1919: INTO l_pjm_blueprint
1920: FROM PJM_ORG_PARAMETERS
1921: WHERE ORGANIZATION_ID = p_organization_id;
1922: EXCEPTION
1923: WHEN NO_DATA_FOUND THEN
1924: l_pjm_blueprint := 'N';

Line 2143: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

2139:
2140: l_ledger_id NUMBER;
2141: l_operating_unit NUMBER;
2142: l_index NUMBER;
2143: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
2144:
2145:
2146: /* FND Logging */
2147: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;

Line 2184: FROM PJM_ORG_PARAMETERS

2180: l_stmt_num := 5;
2181: BEGIN
2182: SELECT NVL(PA_POSTING_FLAG, 'N')
2183: INTO l_pjm_blueprint
2184: FROM PJM_ORG_PARAMETERS
2185: WHERE ORGANIZATION_ID = p_organization_id;
2186: EXCEPTION
2187: WHEN NO_DATA_FOUND THEN
2188: l_pjm_blueprint := 'N';

Line 2375: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

2371: l_ledger_id NUMBER;
2372: l_operating_unit NUMBER;
2373: l_index NUMBER;
2374:
2375: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
2376:
2377: /* FND Logging */
2378: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2379: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 2415: FROM PJM_ORG_PARAMETERS

2411: l_stmt_num := 5;
2412: BEGIN
2413: SELECT NVL(PA_POSTING_FLAG, 'N')
2414: INTO l_pjm_blueprint
2415: FROM PJM_ORG_PARAMETERS
2416: WHERE ORGANIZATION_ID = p_organization_id;
2417: EXCEPTION
2418: WHEN NO_DATA_FOUND THEN
2419: l_pjm_blueprint := 'N';