DBA Data[Home] [Help]

APPS.CST_XLA_PVT dependencies on PJM_ORG_PARAMETERS

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

284: l_event_type_id RCV_ACCOUNTING_EVENTS.EVENT_TYPE_ID%TYPE;
285:
286: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
287: l_parent_rcv_txn_id NUMBER;
288: /*l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;*/
289:
290:
291: /* Budgetary Control */
292: l_bc_status VARCHAR2(2000);

Line 348: FROM PJM_ORG_PARAMETERS

344: l_stmt_num := 5;
345: BEGIN
346: SELECT NVL(PA_POSTING_FLAG, 'N')
347: INTO l_pjm_blueprint
348: FROM PJM_ORG_PARAMETERS
349: WHERE ORGANIZATION_ID = p_trx_info.inv_organization_id;
350: EXCEPTION
351: WHEN NO_DATA_FOUND THEN
352: l_pjm_blueprint := 'N';

Line 752: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

748: l_events CST_XLA_PVT.t_cst_inv_events;
749: l_event_id NUMBER;
750: l_index pls_integer;
751: l_txfr_process_flag MTL_PARAMETERS.PROCESS_ENABLED_FLAG%TYPE;
752: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
753:
754: /* Budgetary Control */
755: l_bc_status VARCHAR2(2000);
756: l_bc_event_id NUMBER;

Line 831: FROM PJM_ORG_PARAMETERS

827: drop shipment.
828: */
829: SELECT NVL(PA_POSTING_FLAG, 'N')
830: INTO l_pjm_blueprint
831: FROM PJM_ORG_PARAMETERS
832: WHERE ORGANIZATION_ID = p_trx_info.txn_organization_id
833: AND EXISTS ( SELECT 'X'
834: FROM MTL_MATERIAL_TRANSACTIONS MMT
835: WHERE MMT.TRANSACTION_ID = p_trx_info.transaction_id

Line 1413: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

1409: l_msg_count NUMBER := 0;
1410: l_msg_data VARCHAR2(8000);
1411: l_stmt_num NUMBER := 0;
1412: l_api_message VARCHAR2(1000);
1413: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
1414:
1415: -- SLA Data Structures
1416: l_source_data XLA_EVENTS_PUB_PKG.t_event_source_info;
1417: l_reference_data XLA_EVENTS_PUB_PKG.t_event_reference_info;

Line 1470: FROM PJM_ORG_PARAMETERS

1466: l_stmt_num := 5;
1467: BEGIN
1468: SELECT NVL(PA_POSTING_FLAG, 'N')
1469: INTO l_pjm_blueprint
1470: FROM PJM_ORG_PARAMETERS
1471: WHERE ORGANIZATION_ID = p_trx_info.inv_organization_id;
1472: EXCEPTION
1473: WHEN NO_DATA_FOUND THEN
1474: l_pjm_blueprint := 'N';

Line 1651: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

1647:
1648: l_ledger_id NUMBER;
1649: l_operating_unit NUMBER;
1650: l_index NUMBER;
1651: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
1652:
1653:
1654: /* FND Logging */
1655: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;

Line 1693: FROM PJM_ORG_PARAMETERS

1689: l_stmt_num := 5;
1690: BEGIN
1691: SELECT NVL(PA_POSTING_FLAG, 'N')
1692: INTO l_pjm_blueprint
1693: FROM PJM_ORG_PARAMETERS
1694: WHERE ORGANIZATION_ID = p_organization_id;
1695: EXCEPTION
1696: WHEN NO_DATA_FOUND THEN
1697: l_pjm_blueprint := 'N';

Line 1895: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

1891:
1892: l_ledger_id NUMBER;
1893: l_operating_unit NUMBER;
1894: l_index NUMBER;
1895: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
1896:
1897:
1898: /* FND Logging */
1899: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;

Line 1936: FROM PJM_ORG_PARAMETERS

1932: l_stmt_num := 5;
1933: BEGIN
1934: SELECT NVL(PA_POSTING_FLAG, 'N')
1935: INTO l_pjm_blueprint
1936: FROM PJM_ORG_PARAMETERS
1937: WHERE ORGANIZATION_ID = p_organization_id;
1938: EXCEPTION
1939: WHEN NO_DATA_FOUND THEN
1940: l_pjm_blueprint := 'N';

Line 2120: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;

2116: l_ledger_id NUMBER;
2117: l_operating_unit NUMBER;
2118: l_index NUMBER;
2119:
2120: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
2121:
2122: /* FND Logging */
2123: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2124: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 2160: FROM PJM_ORG_PARAMETERS

2156: l_stmt_num := 5;
2157: BEGIN
2158: SELECT NVL(PA_POSTING_FLAG, 'N')
2159: INTO l_pjm_blueprint
2160: FROM PJM_ORG_PARAMETERS
2161: WHERE ORGANIZATION_ID = p_organization_id;
2162: EXCEPTION
2163: WHEN NO_DATA_FOUND THEN
2164: l_pjm_blueprint := 'N';