DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_FUNDS_PVT

Line 182: l_fund_rec ozf_funds_pvt.fund_rec_type;

178: l_return_status VARCHAR2 (1);
179: l_utilization_rec utilization_rec_type := p_utilization_rec;
180: l_object_version_number NUMBER := 1;
181: l_utilization_check VARCHAR2 (10);
182: l_fund_rec ozf_funds_pvt.fund_rec_type;
183: l_utilized_amt NUMBER;
184: l_earned_amt NUMBER;
185: l_gl_rec ozf_gl_interface_pvt.gl_interface_rec_type;
186: l_event_id NUMBER;

Line 1074: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);

1070: --l_utilization_rec.gl_posted_flag := NULL; --could have value for adjustment.
1071: /* yzhao: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table
1072: IF p_utilization_rec.utilization_type NOT IN ('TRANSFER', 'REQUEST') THEN
1073: */
1074: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
1075:
1076: -- R12: yzhao ozf_object_fund_summary
1077: l_objfundsum_rec := NULL;
1078: OPEN c_get_objfundsum_rec(l_utilization_rec.component_type

Line 2144: ozf_funds_pvt.update_fund (

2140: -- and px_ozf_funds_old_rectype for taking the funds old values
2141: -- For TPA Parallel Execution ER Bug#9614703
2142: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
2143:
2144: ozf_funds_pvt.update_fund (
2145: p_api_version=> l_api_version
2146: ,p_init_msg_list=> fnd_api.g_false
2147: ,p_commit=> fnd_api.g_false
2148: ,p_validation_level=> p_validation_level

Line 2567: l_fund_rec ozf_funds_pvt.fund_rec_type;

2563: l_utilization_rec utilization_rec_type;
2564: l_mode VARCHAR2 (30);
2565: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
2566: l_obj_num NUMBER := 1;
2567: l_fund_rec ozf_funds_pvt.fund_rec_type;
2568: l_utilized_amt NUMBER;
2569: l_committed_amt NUMBER;
2570: l_old_util_amt NUMBER;
2571: l_plan_curr_amount NUMBER;

Line 2876: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);

2872: OPEN c_old_util_amt (l_utilization_rec.utilization_id);
2873: FETCH c_old_util_amt INTO l_old_util_amt;
2874: CLOSE c_old_util_amt;
2875: -------------------------update master fund table-------------------
2876: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
2877: -- new utilzed amount = fund_utilized_amount - old_util_Amount + new util amount
2878: l_fund_rec.utilized_amt :=
2879: NVL (l_utilized_amt, 0)
2880: - NVL (l_old_util_amt, 0)

Line 2884: ozf_funds_pvt.update_fund (

2880: - NVL (l_old_util_amt, 0)
2881: + NVL (l_utilization_rec.amount, 0);
2882: l_fund_rec.fund_id := l_utilization_rec.fund_id;
2883: l_fund_rec.object_version_number := l_obj_num;
2884: ozf_funds_pvt.update_fund (
2885: p_api_version=> l_api_version
2886: ,p_init_msg_list=> fnd_api.g_false
2887: ,p_commit=> fnd_api.g_false
2888: ,p_validation_level=> p_validation_level