[Home] [Help]
418: x_return_status OUT NOCOPY VARCHAR2
419: ,x_msg_count OUT NOCOPY NUMBER
420: ,x_msg_data OUT NOCOPY VARCHAR2
421: ,x_act_budget_id OUT NOCOPY NUMBER
422: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
423: ,p_ledger_id IN NUMBER
424: ,p_org_id IN NUMBER DEFAULT NULL -- added for bug 7030415
425: ) IS
426: l_api_name CONSTANT VARCHAR2 (30) := 'create_actbudgets_rec';
427: l_full_name CONSTANT VARCHAR2 (60) := g_pkg_name
428: || '.'
429: || l_api_name;
430: l_return_status VARCHAR2 (1); -- Return value from procedures
431: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
432: l_requester_id NUMBER;
433: l_activity_id NUMBER;
434: l_obj_ver_num NUMBER;
435: l_old_approved_amount NUMBER;
1789: -- This procedure will create utiliation records for the order accruals
1790: -----------------------------------------------------------------------------------
1791: PROCEDURE create_fund_utilization (
1792: p_act_util_rec IN ozf_fund_utilized_pvt.utilization_rec_type,
1793: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1794: x_utilization_id OUT NOCOPY NUMBER,
1795: x_return_status OUT NOCOPY VARCHAR2,
1796: x_msg_count OUT NOCOPY NUMBER,
1797: x_msg_data OUT NOCOPY VARCHAR2
1798: ) IS
1799: l_api_version NUMBER := 1.0;
1800: l_api_name VARCHAR2 (60) := 'create_fund_utilization';
1801: l_act_budget_id NUMBER;
1802: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
1803: l_act_util_rec ozf_fund_utilized_pvt.utilization_rec_type := p_act_util_rec;
1804: l_activity_id NUMBER;
1805: l_obj_ver_num NUMBER;
1806: l_old_approved_amount NUMBER;
1972: l_adj_amount NUMBER;
1973: l_remaining_amount NUMBER;
1974: l_rate NUMBER;
1975: l_converted_adj_amount NUMBER;
1976: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1977: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1978: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;
1979: l_fund_amt_tbl ozf_fund_amt_tbl_type;
1980: l_cust_account_id NUMBER;
1973: l_remaining_amount NUMBER;
1974: l_rate NUMBER;
1975: l_converted_adj_amount NUMBER;
1976: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1977: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1978: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;
1979: l_fund_amt_tbl ozf_fund_amt_tbl_type;
1980: l_cust_account_id NUMBER;
1981: l_adjustment_date DATE;
2321: l_range_break NUMBER;
2322: l_operation VARCHAR2(30);
2323: l_product_id NUMBER;
2324: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;
2325: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2326: l_gl_posted_flag VARCHAR2 (1);
2327: l_utilization_id NUMBER;
2328: l_gl_date DATE;
2329: l_object_version_number NUMBER;
2932: l_cancelled_quantity NUMBER;
2933: l_modifier_level_code VARCHAR2 (30);
2934: l_line_status VARCHAR2 (30);
2935: l_new_adjustment_amount NUMBER;
2936: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2937: l_empty_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2938: l_order_number NUMBER;
2939: l_gl_posted_flag VARCHAR2 (1);
2940: l_orig_adj_amount NUMBER;
2933: l_modifier_level_code VARCHAR2 (30);
2934: l_line_status VARCHAR2 (30);
2935: l_new_adjustment_amount NUMBER;
2936: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2937: l_empty_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2938: l_order_number NUMBER;
2939: l_gl_posted_flag VARCHAR2 (1);
2940: l_orig_adj_amount NUMBER;
2941: l_rate NUMBER;