DBA Data[Home] [Help]

APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_FUND_UTILIZED_PVT

Line 840: ,p_utilization_rec IN ozf_fund_utilized_pvt.utilization_rec_type

836: x_return_status OUT NOCOPY VARCHAR2
837: ,x_msg_count OUT NOCOPY NUMBER
838: ,x_msg_data OUT NOCOPY VARCHAR2
839: ,x_utilization_id OUT NOCOPY NUMBER
840: ,p_utilization_rec IN ozf_fund_utilized_pvt.utilization_rec_type
841: ) IS
842: l_api_name CONSTANT VARCHAR2 (30) := 'create_utilized_rec';
843: l_full_name CONSTANT VARCHAR2 (60) := g_pkg_name || '.' || l_api_name;
844: l_return_status VARCHAR2 (1);

Line 845: l_utilization_rec ozf_fund_utilized_pvt.utilization_rec_type := p_utilization_rec;

841: ) IS
842: l_api_name CONSTANT VARCHAR2 (30) := 'create_utilized_rec';
843: l_full_name CONSTANT VARCHAR2 (60) := g_pkg_name || '.' || l_api_name;
844: l_return_status VARCHAR2 (1);
845: l_utilization_rec ozf_fund_utilized_pvt.utilization_rec_type := p_utilization_rec;
846: l_earned_amt NUMBER;
847: l_obj_num NUMBER;
848: l_fund_type VARCHAR2 (30);
849: l_parent_fund_id NUMBER;

Line 2201: p_act_util_rec IN ozf_fund_utilized_pvt.utilization_rec_type,

2197: -- Purpose
2198: -- This procedure will create utiliation records for the order accruals
2199: -----------------------------------------------------------------------------------
2200: PROCEDURE create_fund_utilization (
2201: p_act_util_rec IN ozf_fund_utilized_pvt.utilization_rec_type,
2202: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
2203: x_utilization_id OUT NOCOPY NUMBER,
2204: x_return_status OUT NOCOPY VARCHAR2,
2205: x_msg_count OUT NOCOPY NUMBER,

Line 2212: l_act_util_rec ozf_fund_utilized_pvt.utilization_rec_type := p_act_util_rec;

2208: l_api_version NUMBER := 1.0;
2209: l_api_name VARCHAR2 (60) := 'create_fund_utilization';
2210: l_act_budget_id NUMBER;
2211: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
2212: l_act_util_rec ozf_fund_utilized_pvt.utilization_rec_type := p_act_util_rec;
2213: l_activity_id NUMBER;
2214: l_obj_ver_num NUMBER;
2215: l_old_approved_amount NUMBER;
2216: l_old_parent_src_amt NUMBER;

Line 2407: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;

2403: l_rate NUMBER;
2404: l_converted_adj_amount NUMBER;
2405: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
2406: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2407: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;
2408: l_fund_amt_tbl ozf_fund_amt_tbl_type;
2409: l_cust_account_id NUMBER;
2410: l_adjustment_date DATE;
2411: l_bill_to_site_use_id NUMBER;

Line 2809: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;

2805: l_line_category_code VARCHAR2(30);
2806: l_range_break NUMBER;
2807: l_operation VARCHAR2(30);
2808: l_product_id NUMBER;
2809: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;
2810: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2811: l_gl_posted_flag VARCHAR2 (1);
2812: l_utilization_id NUMBER;
2813: l_gl_date DATE;

Line 3778: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;

3774: l_earned_amount NUMBER;
3775: l_old_earned_amount NUMBER;
3776: l_header_id NUMBER; -- order or invoice id
3777: l_line_id NUMBER; -- order or invoice id
3778: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;
3779: l_empty_util_rec ozf_fund_utilized_pvt.utilization_rec_type;
3780: l_util_id NUMBER;
3781: l_util_curr VARCHAR2 (30);
3782: l_adj_amount NUMBER;

Line 3779: l_empty_util_rec ozf_fund_utilized_pvt.utilization_rec_type;

3775: l_old_earned_amount NUMBER;
3776: l_header_id NUMBER; -- order or invoice id
3777: l_line_id NUMBER; -- order or invoice id
3778: l_util_rec ozf_fund_utilized_pvt.utilization_rec_type;
3779: l_empty_util_rec ozf_fund_utilized_pvt.utilization_rec_type;
3780: l_util_id NUMBER;
3781: l_util_curr VARCHAR2 (30);
3782: l_adj_amount NUMBER;
3783: l_converted_adj_amount NUMBER;