DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_PVT dependencies on OKL_SUBSIDY_POOL_PVT

Line 1: PACKAGE BODY OKL_SUBSIDY_POOL_PVT AS

1: PACKAGE BODY OKL_SUBSIDY_POOL_PVT AS
2: /* $Header: OKLRSIPB.pls 120.2 2005/09/12 23:45:28 cklee noship $ */
3:
4: G_WF_EVT_SUBSIDY_POOL_PENDING CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_pending_approval';
5: G_WF_EVT_SUBSIDY_POOL_APPROVED CONSTANT wf_events.name%TYPE DEFAULT 'oracle.apps.okl.subsidy_pool.pool_approved';

Line 120: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.CREATE_SUB_POOL';

116:
117: ---------------------------
118: -- DECLARE Local Variables
119: ---------------------------
120: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.CREATE_SUB_POOL';
121: L_DEBUG_ENABLED VARCHAR2(10);
122: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
123: IS_DEBUG_PROCEDURE_ON BOOLEAN;
124: l_sub_pool_rec subsidy_pool_rec ;

Line 279: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUB_POOL';

275: ) IS
276: ---------------------------
277: -- DECLARE Local Variables
278: ---------------------------
279: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUB_POOL';
280: L_DEBUG_ENABLED VARCHAR2(10);
281: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
282: IS_DEBUG_PROCEDURE_ON BOOLEAN;
283: l_sub_pool_rec subsidy_pool_rec ;

Line 514: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.EXPIRE_SUB_POOL';

510: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE) IS
511: ---------------------------
512: -- DECLARE Local Variables
513: ---------------------------
514: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.EXPIRE_SUB_POOL';
515: L_DEBUG_ENABLED VARCHAR2(10);
516: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
517: IS_DEBUG_PROCEDURE_ON BOOLEAN;
518: l_sub_pool_rec subsidy_pool_rec;

Line 665: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_TOTAL_BUDGET';

661: p_total_budget_amt IN okl_subsidy_pools_b.total_budgets%TYPE ) IS
662: ---------------------------
663: -- DECLARE Local Variables
664: ---------------------------
665: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_TOTAL_BUDGET';
666: L_DEBUG_ENABLED VARCHAR2(10);
667: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
668: IS_DEBUG_PROCEDURE_ON BOOLEAN;
669: l_sub_pool_rec subsidy_pool_rec;

Line 811: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUBSIDY_AMOUNT';

807:
808: ---------------------------
809: -- DECLARE Local Variables
810: ---------------------------
811: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUBSIDY_AMOUNT';
812: L_DEBUG_ENABLED VARCHAR2(10);
813: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
814: IS_DEBUG_PROCEDURE_ON BOOLEAN;
815: l_sub_pool_rec subsidy_pool_rec;

Line 956: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.SET_DECISION_STATUS_CODE';

952:
953: ---------------------------
954: -- DECLARE Local Variables
955: ---------------------------
956: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.SET_DECISION_STATUS_CODE';
957: L_DEBUG_ENABLED VARCHAR2(10);
958: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
959: IS_DEBUG_PROCEDURE_ON BOOLEAN;
960: l_sub_pool_rec subsidy_pool_rec;

Line 1126: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.VALIDATE_SUB_POOL';

1122:
1123: ---------------------------
1124: -- DECLARE Local Variables
1125: ---------------------------
1126: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.VALIDATE_SUB_POOL';
1127: L_DEBUG_ENABLED VARCHAR2(10);
1128: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
1129: IS_DEBUG_PROCEDURE_ON BOOLEAN;
1130: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_SUBSIDY_POOL';

Line 1224: END OKL_SUBSIDY_POOL_PVT;

1220: x_msg_data => x_msg_data,
1221: p_api_type => g_api_type);
1222: END validate_sub_pool;
1223:
1224: END OKL_SUBSIDY_POOL_PVT;