DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_FUNDS_PVT

Line 103: l_fund_rec ozf_funds_pvt.fund_rec_type;

99: l_return_status VARCHAR2 (1);
100: l_utilization_rec utilization_rec_type := p_utilization_rec;
101: l_object_version_number NUMBER := 1;
102: l_utilization_check VARCHAR2 (10);
103: l_fund_rec ozf_funds_pvt.fund_rec_type;
104: l_utilized_amt NUMBER;
105: l_earned_amt NUMBER;
106: l_gl_rec ozf_gl_interface_pvt.gl_interface_rec_type;
107: l_event_id NUMBER;

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

863: --l_utilization_rec.gl_posted_flag := NULL; --could have value for adjustment.
864: /* yzhao: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table
865: IF p_utilization_rec.utilization_type NOT IN ('TRANSFER', 'REQUEST') THEN
866: */
867: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
868:
869: -- R12: yzhao ozf_object_fund_summary
870: l_objfundsum_rec := NULL;
871: OPEN c_get_objfundsum_rec(l_utilization_rec.component_type

Line 1706: ozf_funds_pvt.update_fund (

1702: l_fund_rec.exchange_rate_date := l_utilization_rec.exchange_rate_date;
1703: l_fund_rec.description := l_utilization_rec.adjustment_desc;
1704: END IF;
1705:
1706: ozf_funds_pvt.update_fund (
1707: p_api_version=> l_api_version
1708: ,p_init_msg_list=> fnd_api.g_false
1709: ,p_commit=> fnd_api.g_false
1710: ,p_validation_level=> p_validation_level

Line 2115: l_fund_rec ozf_funds_pvt.fund_rec_type;

2111: l_utilization_rec utilization_rec_type;
2112: l_mode VARCHAR2 (30);
2113: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
2114: l_obj_num NUMBER := 1;
2115: l_fund_rec ozf_funds_pvt.fund_rec_type;
2116: l_utilized_amt NUMBER;
2117: l_old_util_amt NUMBER;
2118: l_plan_curr_amount NUMBER;
2119: l_plan_curr_amount_remaining NUMBER;

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

2410: OPEN c_old_util_amt (l_utilization_rec.utilization_id);
2411: FETCH c_old_util_amt INTO l_old_util_amt;
2412: CLOSE c_old_util_amt;
2413: -------------------------update master fund table-------------------
2414: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
2415: -- new utilzed amount = fund_utilized_amount - old_util_Amount + new util amount
2416: l_fund_rec.utilized_amt :=
2417: NVL (l_utilized_amt, 0)
2418: - NVL (l_old_util_amt, 0)

Line 2422: ozf_funds_pvt.update_fund (

2418: - NVL (l_old_util_amt, 0)
2419: + NVL (l_utilization_rec.amount, 0);
2420: l_fund_rec.fund_id := l_utilization_rec.fund_id;
2421: l_fund_rec.object_version_number := l_obj_num;
2422: ozf_funds_pvt.update_fund (
2423: p_api_version=> l_api_version
2424: ,p_init_msg_list=> fnd_api.g_false
2425: ,p_commit=> fnd_api.g_false
2426: ,p_validation_level=> p_validation_level