APPS.OZF_BUDGETAPPROVAL_PVT dependencies on FND_PROFILE

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

2290: BEGIN
2291:
2292: SAVEPOINT validate_object_budget;
2293:
2294: l_check_validation := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
2295:
2296: IF G_DEBUG THEN
2297: ozf_utility_pvt.debug_message(' profile value:' || l_check_validation);
2298: END IF;

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

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

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

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

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

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

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

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