2: /* $Header: CSTVXLAB.pls 120.60 2010/06/15 09:05:44 mpuranik ship $ */
3:
4: /* FND Logging Constants */
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_XLA_PVT';
6: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;
8: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:
10: /* Global Constants */
18: G_IPV_TRANSFER_EVENT CONSTANT VARCHAR2(30) := 'IPV_TRANSFER_WO';
19: G_COGS_REC_EVENT CONSTANT VARCHAR2(30) := 'COGS_RECOGNITION';
20: G_COGS_REC_ADJ_EVENT CONSTANT VARCHAR2(30) := 'COGS_RECOGNITION_ADJ';
21:
22: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
23:
24: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'cst.plsql.cst_security_policy_pkg';
25: C_DEFAULT_PREDICAT CONSTANT VARCHAR2(240) := ' 1=1 ';
26:
535:
536:
537:
538:
539: FND_PROFILE.get('CST_RCV_ACCT_OPTION', l_accounting_option);
540:
541:
542:
543: --
720: -- 'UNPROCESSED' );
721:
722: -- l_stmt_num := 60;
723:
724: -- FND_PROFILE.get('USER_ID', l_user_id);
725: -- FND_PROFILE.get('RESP_ID', l_resp_id);
726: -- FND_PROFILE.get('RESP_APPL_ID', l_resp_appl_id);
727:
728:
721:
722: -- l_stmt_num := 60;
723:
724: -- FND_PROFILE.get('USER_ID', l_user_id);
725: -- FND_PROFILE.get('RESP_ID', l_resp_id);
726: -- FND_PROFILE.get('RESP_APPL_ID', l_resp_appl_id);
727:
728:
729: -- PSA_BC_XLA_PUB.Budgetary_Control (
722: -- l_stmt_num := 60;
723:
724: -- FND_PROFILE.get('USER_ID', l_user_id);
725: -- FND_PROFILE.get('RESP_ID', l_resp_id);
726: -- FND_PROFILE.get('RESP_APPL_ID', l_resp_appl_id);
727:
728:
729: -- PSA_BC_XLA_PUB.Budgetary_Control (
730: -- p_api_version => 1.0,
1484: --{BUG#6125007
1485: -- AND l_psa_ins_flag = 'Y' )
1486: -- THEN
1487:
1488: -- FND_PROFILE.get('USER_ID', l_user_id);
1489: -- FND_PROFILE.get('RESP_ID', l_resp_id);
1490: -- FND_PROFILE.get('RESP_APPL_ID', l_resp_appl_id);
1491:
1492: -- l_stmt_num := 150;
1485: -- AND l_psa_ins_flag = 'Y' )
1486: -- THEN
1487:
1488: -- FND_PROFILE.get('USER_ID', l_user_id);
1489: -- FND_PROFILE.get('RESP_ID', l_resp_id);
1490: -- FND_PROFILE.get('RESP_APPL_ID', l_resp_appl_id);
1491:
1492: -- l_stmt_num := 150;
1493: -- PSA_BC_XLA_PUB.Budgetary_Control (
1486: -- THEN
1487:
1488: -- FND_PROFILE.get('USER_ID', l_user_id);
1489: -- FND_PROFILE.get('RESP_ID', l_resp_id);
1490: -- FND_PROFILE.get('RESP_APPL_ID', l_resp_appl_id);
1491:
1492: -- l_stmt_num := 150;
1493: -- PSA_BC_XLA_PUB.Budgetary_Control (
1494: -- p_api_version => 1.0,