APPS.OZF_BUDGETAPPROVAL_PVT dependencies on FND_PROFILE

Line 2298: l_check_validation := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');

2294: BEGIN
2295:
2296: SAVEPOINT validate_object_budget;
2297:
2298: l_check_validation := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
2299:
2300: IF G_DEBUG THEN
2301: ozf_utility_pvt.debug_message(' profile value:' || l_check_validation);
2302: END IF;

Line 2453: l_check_validation := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');

2449: WHERE qp_list_header_id = p_object_id;
2450:
2451: BEGIN
2452:
2453: l_check_validation := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
2454:
2455: IF (NVL(l_check_validation, 'NO') = 'NO') OR (l_check_validation = 'PRODUCT_STRICT_CUSTOMER_STRICT') THEN
2456: -- return success if profile value is NO or PRODUCT_STRICT_CUSTOMER_STRICT
2457: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 2804: l_percent := NVL(Fnd_Profile.Value('AMS_APPROVAL_CUTOFF_PERCENT'),0)/100;

2800:
2801: BEGIN
2802:
2803: x_return_status := fnd_api.g_ret_sts_success;
2804: l_percent := NVL(Fnd_Profile.Value('AMS_APPROVAL_CUTOFF_PERCENT'),0)/100;
2805:
2806: IF l_percent = 0 THEN -- if profile value is set to zero, x_new_status is 'ACTIVE'
2807: x_new_status := 'ACTIVE';
2808: ELSE

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

3462: WHERE qp_list_header_id = p_object_id;
3463:
3464: l_act_budget_id NUMBER;
3465: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type ;
3466: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
3467: l_request_id NUMBER;
3468: l_status_code VARCHAR2(50):= 'APPROVED';
3469: l_total_budget NUMBER;
3470: l_recal_flag VARCHAR2(1):= NVL (fnd_profile.VALUE ('AMS_BUDGET_ADJ_ALLOW_RECAL'), 'N');

Line 3470: l_recal_flag VARCHAR2(1):= NVL (fnd_profile.VALUE ('AMS_BUDGET_ADJ_ALLOW_RECAL'), 'N');

3466: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
3467: l_request_id NUMBER;
3468: l_status_code VARCHAR2(50):= 'APPROVED';
3469: l_total_budget NUMBER;
3470: l_recal_flag VARCHAR2(1):= NVL (fnd_profile.VALUE ('AMS_BUDGET_ADJ_ALLOW_RECAL'), 'N');
3471: l_offer_amount NUMBER;
3472: l_notify_message VARCHAR2(50);
3473: l_owner_id NUMBER;
3474: l_budget_req_flag VARCHAR2(1);