APPS.OZF_ACTBUDGETS_PVT dependencies on OZF_OBJFUNDSUM_PVT

Line 1402: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;

1398: l_rate NUMBER;
1399: l_old_parent_src_amt NUMBER;
1400: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
1401: l_offer_status VARCHAR2(30);
1402: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;
1403: l_univ_amount NUMBER;
1404: l_objfundsum_id NUMBER;
1405: l_ledger_id NUMBER;
1406: l_ledger_name VARCHAR2(30);

Line 1692: ozf_objfundsum_pvt.update_objfundsum(

1688: l_objfundsum_rec.planned_amt := NVL(l_objfundsum_rec.planned_amt, 0) + NVL (l_fund_rec.planned_amt, 0);
1689: l_objfundsum_rec.plan_curr_planned_amt := NVL(l_objfundsum_rec.plan_curr_planned_amt, 0)
1690: + NVL(l_act_budgets_rec.request_amount, 0);
1691: l_objfundsum_rec.univ_curr_planned_amt := NVL(l_objfundsum_rec.univ_curr_planned_amt, 0) + NVL(l_univ_amount, 0);
1692: ozf_objfundsum_pvt.update_objfundsum(
1693: p_api_version => 1.0,
1694: p_init_msg_list => Fnd_Api.G_FALSE,
1695: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
1696: p_objfundsum_rec => l_objfundsum_rec,

Line 1849: ozf_objfundsum_pvt.create_objfundsum(

1845: l_objfundsum_rec.plan_curr_planned_amt := NVL(l_objfundsum_rec.plan_curr_planned_amt, 0)
1846: + NVL(l_act_budgets_rec.request_amount, 0);
1847: l_objfundsum_rec.univ_curr_planned_amt := NVL(l_objfundsum_rec.univ_curr_planned_amt, 0) + NVL(l_univ_amount, 0);
1848: IF l_objfundsum_rec.objfundsum_id IS NULL THEN
1849: ozf_objfundsum_pvt.create_objfundsum(
1850: p_api_version => 1.0,
1851: p_init_msg_list => Fnd_Api.G_FALSE,
1852: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
1853: p_objfundsum_rec => l_objfundsum_rec,

Line 1860: ozf_objfundsum_pvt.update_objfundsum(

1856: x_msg_data => x_msg_data,
1857: x_objfundsum_id => l_objfundsum_id
1858: );
1859: ELSE
1860: ozf_objfundsum_pvt.update_objfundsum(
1861: p_api_version => 1.0,
1862: p_init_msg_list => Fnd_Api.G_FALSE,
1863: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
1864: p_objfundsum_rec => l_objfundsum_rec,

Line 4660: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;

4656: l_fund_transfer_flag VARCHAR2 (1) := fnd_api.g_false;
4657: l_fund_recal_committed_amount NUMBER;
4658: l_univ_planned_amount NUMBER;
4659: l_univ_committed_amount NUMBER;
4660: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;
4661: l_objfundsum_id NUMBER;
4662:
4663: l_fund_reconc_msg VARCHAR2(4000);
4664: l_act_bud_cst_msg VARCHAR2(4000);

Line 5234: ozf_objfundsum_pvt.create_objfundsum(

5230: l_objfundsum_rec.reference_object_type := 'EVEH';
5231: END IF;
5232: END IF;
5233:
5234: ozf_objfundsum_pvt.create_objfundsum(
5235: p_api_version => 1.0,
5236: p_init_msg_list => Fnd_Api.G_FALSE,
5237: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
5238: p_objfundsum_rec => l_objfundsum_rec,

Line 5265: ozf_objfundsum_pvt.update_objfundsum(

5261: x_msg_count => x_msg_count,
5262: x_msg_data => x_msg_data
5263: );
5264: ELSE
5265: ozf_objfundsum_pvt.update_objfundsum(
5266: p_api_version => 1.0,
5267: p_init_msg_list => Fnd_Api.G_FALSE,
5268: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
5269: p_objfundsum_rec => l_objfundsum_rec,

Line 5325: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;

5321: l_fund_object_version_number NUMBER;
5322: l_fund_currency_tc VARCHAR2 (15); -- a fund's transactional currency code
5323: l_fund_planned_amount NUMBER;
5324: l_univ_planned_amount NUMBER;
5325: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;
5326:
5327: CURSOR c_fund (l_fund_id IN NUMBER) IS
5328: SELECT object_version_number, currency_code_tc, planned_amt
5329: FROM ozf_funds_all_b

Line 5427: ozf_objfundsum_pvt.update_objfundsum(

5423: l_objfundsum_rec.plan_curr_planned_amt := NVL(l_objfundsum_rec.plan_curr_planned_amt, 0)
5424: - NVL(l_temp_rec.request_amount, 0);
5425: l_objfundsum_rec.univ_curr_planned_amt := NVL(l_objfundsum_rec.univ_curr_planned_amt, 0)
5426: - NVL(l_univ_planned_amount, 0);
5427: ozf_objfundsum_pvt.update_objfundsum(
5428: p_api_version => 1.0,
5429: p_init_msg_list => Fnd_Api.G_FALSE,
5430: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
5431: p_objfundsum_rec => l_objfundsum_rec,

Line 5856: p_objfundsum_rec IN OZF_OBJFUNDSUM_PVT.objfundsum_rec_type,

5852: PROCEDURE update_reconcile_objfundsum (
5853: p_api_version IN NUMBER,
5854: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
5855: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
5856: p_objfundsum_rec IN OZF_OBJFUNDSUM_PVT.objfundsum_rec_type,
5857: p_conv_date IN DATE,
5858: x_return_status OUT NOCOPY VARCHAR2,
5859: x_msg_count OUT NOCOPY NUMBER,
5860: x_msg_data OUT NOCOPY VARCHAR2

Line 5869: l_objfundsum_rec OZF_OBJFUNDSUM_PVT.objfundsum_rec_type := p_objfundsum_rec;

5865: L_API_NAME CONSTANT VARCHAR2(30) := 'update_reconcile_objfundsum';
5866: L_FULL_NAME CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
5867:
5868: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5869: l_objfundsum_rec OZF_OBJFUNDSUM_PVT.objfundsum_rec_type := p_objfundsum_rec;
5870: l_amount_1 NUMBER;
5871: l_amount_2 NUMBER;
5872: l_amount_3 NUMBER;
5873:

Line 5905: OZF_OBJFUNDSUM_PVT.Complete_objfundsum_Rec(p_objfundsum_rec, l_objfundsum_rec);

5901: ozf_utility_pvt.debug_message(l_full_name ||': validate');
5902: END IF;
5903:
5904: -- replace g_miss_char/num/date with current column values
5905: OZF_OBJFUNDSUM_PVT.Complete_objfundsum_Rec(p_objfundsum_rec, l_objfundsum_rec);
5906:
5907: -- currency conversion for planned amount
5908: complete_amount_fields (
5909: p_currency_1 => l_objfundsum_rec.object_currency,

Line 6062: OZF_OBJFUNDSUM_PVT.Validate_objfundsum (

6058: l_objfundsum_rec.paid_amt := l_amount_2;
6059: l_objfundsum_rec.univ_curr_paid_amt := l_amount_3;
6060:
6061: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
6062: OZF_OBJFUNDSUM_PVT.Validate_objfundsum (
6063: p_api_version => l_api_version,
6064: p_init_msg_list => p_init_msg_list,
6065: p_validation_level => p_validation_level,
6066: p_objfundsum_rec => l_objfundsum_rec,