APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 1308: PROCEDURE log_exception(p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

1304: RETURN l_return_value;
1305: --
1306: END get_pv_accrual_amount;
1307:
1308: PROCEDURE log_exception(p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1309: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)
1310: IS
1311: CURSOR c_na_conc_exception_id IS
1312: SELECT ozf_na_conc_exceptions_s.NEXTVAL

Line 1309: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)

1305: --
1306: END get_pv_accrual_amount;
1307:
1308: PROCEDURE log_exception(p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1309: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)
1310: IS
1311: CURSOR c_na_conc_exception_id IS
1312: SELECT ozf_na_conc_exceptions_s.NEXTVAL
1313: FROM DUAL;

Line 1405: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1401: CURSOR c_exception_rec IS
1402: SELECT *
1403: FROM ozf_na_conc_exceptions;
1404:
1405: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1406: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1407: l_return_status VARCHAR2(1);
1408: l_msg_count NUMBER;
1409: l_msg_data VARCHAR2(2000);

Line 1406: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1402: SELECT *
1403: FROM ozf_na_conc_exceptions;
1404:
1405: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1406: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1407: l_return_status VARCHAR2(1);
1408: l_msg_count NUMBER;
1409: l_msg_data VARCHAR2(2000);
1410: l_act_budget_id NUMBER;

Line 2091: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2087: l_org_id NUMBER; -- Inventory Org
2088: l_offer_org_id NUMBER; -- Org in Which the offer was created
2089: l_is_prm_offer BOOLEAN; -- nepanda : bug # 14277687
2090:
2091: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2092: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2093: l_act_budget_id NUMBER;
2094: l_referral_id NUMBER;
2095: l_beneficiary_id NUMBER;

Line 2092: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

2088: l_offer_org_id NUMBER; -- Org in Which the offer was created
2089: l_is_prm_offer BOOLEAN; -- nepanda : bug # 14277687
2090:
2091: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2092: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2093: l_act_budget_id NUMBER;
2094: l_referral_id NUMBER;
2095: l_beneficiary_id NUMBER;
2096: l_utilization_type VARCHAR2(30);

Line 2133: TYPE act_budgets_rec_tbl_type IS TABLE OF ozf_actbudgets_pvt.act_budgets_rec_type INDEX BY BINARY_INTEGER;

2129: -- Bug 11889816
2130: l_tot_products NUMBER;
2131: l_tot_customers NUMBER;
2132:
2133: TYPE act_budgets_rec_tbl_type IS TABLE OF ozf_actbudgets_pvt.act_budgets_rec_type INDEX BY BINARY_INTEGER;
2134: l_act_budgets_rec_tbl act_budgets_rec_tbl_type;
2135:
2136: TYPE act_util_rec_tbl_type IS TABLE OF ozf_actbudgets_pvt.act_util_rec_type INDEX BY BINARY_INTEGER;
2137: l_act_util_rec_tbl act_util_rec_tbl_type;

Line 2136: TYPE act_util_rec_tbl_type IS TABLE OF ozf_actbudgets_pvt.act_util_rec_type INDEX BY BINARY_INTEGER;

2132:
2133: TYPE act_budgets_rec_tbl_type IS TABLE OF ozf_actbudgets_pvt.act_budgets_rec_type INDEX BY BINARY_INTEGER;
2134: l_act_budgets_rec_tbl act_budgets_rec_tbl_type;
2135:
2136: TYPE act_util_rec_tbl_type IS TABLE OF ozf_actbudgets_pvt.act_util_rec_type INDEX BY BINARY_INTEGER;
2137: l_act_util_rec_tbl act_util_rec_tbl_type;
2138:
2139: -- Used to Validate country code for PRM Net Accrual Offer
2140: