DBA Data[Home] [Help]

APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_ACTBUDGETS_PVT

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

1207: RETURN l_return_value;
1208: --
1209: END get_pv_accrual_amount;
1210:
1211: PROCEDURE log_exception(p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1212: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)
1213: IS
1214: CURSOR c_na_conc_exception_id IS
1215: SELECT ozf_na_conc_exceptions_s.NEXTVAL

Line 1212: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)

1208: --
1209: END get_pv_accrual_amount;
1210:
1211: PROCEDURE log_exception(p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1212: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type)
1213: IS
1214: CURSOR c_na_conc_exception_id IS
1215: SELECT ozf_na_conc_exceptions_s.NEXTVAL
1216: FROM DUAL;

Line 1308: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1304: CURSOR c_exception_rec IS
1305: SELECT *
1306: FROM ozf_na_conc_exceptions;
1307:
1308: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1309: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1310: l_return_status VARCHAR2(1);
1311: l_msg_count NUMBER;
1312: l_msg_data VARCHAR2(2000);

Line 1309: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1305: SELECT *
1306: FROM ozf_na_conc_exceptions;
1307:
1308: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1309: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1310: l_return_status VARCHAR2(1);
1311: l_msg_count NUMBER;
1312: l_msg_data VARCHAR2(2000);
1313: l_act_budget_id NUMBER;

Line 1672: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1668: l_order_curr_code VARCHAR2(30);
1669: l_org_id NUMBER; -- Inventory Org
1670: l_offer_org_id NUMBER; -- Org in Which the offer was created
1671:
1672: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1673: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1674: l_act_budget_id NUMBER;
1675: l_referral_id NUMBER;
1676: l_beneficiary_id NUMBER;

Line 1673: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1669: l_org_id NUMBER; -- Inventory Org
1670: l_offer_org_id NUMBER; -- Org in Which the offer was created
1671:
1672: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1673: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1674: l_act_budget_id NUMBER;
1675: l_referral_id NUMBER;
1676: l_beneficiary_id NUMBER;
1677: l_utilization_type VARCHAR2(30);