DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on FND_PROFILE

Line 96: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');

92:
93: g_package_name CONSTANT VARCHAR2 (30) := 'OZF_ACTBUDGETS_PVT';
94: g_file_name CONSTANT VARCHAR2 (12) := 'ozfvbdgb.pls';
95: g_cons_fund_mode CONSTANT VARCHAR2 (30) := 'ADJUST';
96: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
97: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
98: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
99: /*****************************************************************************************/
100: -- Start of Comments

Line 97: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');

93: g_package_name CONSTANT VARCHAR2 (30) := 'OZF_ACTBUDGETS_PVT';
94: g_file_name CONSTANT VARCHAR2 (12) := 'ozfvbdgb.pls';
95: g_cons_fund_mode CONSTANT VARCHAR2 (30) := 'ADJUST';
96: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
97: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
98: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
99: /*****************************************************************************************/
100: -- Start of Comments
101: --

Line 376: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');

372: -- mpande for changed checkbook view 12/17/2001
373: l_src_curr_request_amt NUMBER;
374: l_src_currency VARCHAR2(150);
375: l_rate NUMBER;
376: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
377: l_ledger_id NUMBER;
378: l_ledger_name VARCHAR2(30);
379: l_is_quota NUMBER := NULL;
380:

Line 1366: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');

1362: l_start_flow_flag VARCHAR2 (1) := 'N';
1363: l_new_status_id NUMBER;
1364: l_reject_status_id NUMBER;
1365: l_exceed_flag VARCHAR2 (1)
1366: := NVL (fnd_profile.VALUE ('OZF_COMM_BUDGET_EXCEED'), 'N');
1367:
1368: CURSOR c_current_status IS
1369: SELECT status_code, approved_amount, parent_src_apprvd_amt
1370: FROM ozf_act_budgets

Line 1400: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');

1396: l_src_curr_request_amt NUMBER;
1397: l_src_currency VARCHAR2(150);
1398: l_rate NUMBER;
1399: l_old_parent_src_amt NUMBER;
1400: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
1401: l_offer_status VARCHAR2(30);
1402: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;
1403: l_univ_amount NUMBER;
1404: l_objfundsum_id NUMBER;

Line 4114: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');

4110: l_is_requestor_owner VARCHAR2 (2) ; -- changed 09/07/2001 mpande
4111: l_allocation_flag VARCHAR2 (2) ; -- changed 09/07/2001 mpande
4112: l_approval_for_id NUMBER;
4113: l_approval_fm_id NUMBER;
4114: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
4115: l_act_budget_rec act_budgets_rec_type := x_act_budget_rec ;
4116: l_temp_act_rec act_budgets_rec_type;
4117: l_start_flow_flag VARCHAR2(1) := 'N';
4118: l_custom_setup_id NUMBER;