eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ACTBUDGETS_PVT dependencies on OZF_OBJFUNDSUM_PVT

Line 1957: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;

1953: l_rate NUMBER;
1954: l_old_parent_src_amt NUMBER;
1955: l_check_validation VARCHAR2(50) := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
1956: l_offer_status VARCHAR2(30);
1957: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;
1958: l_univ_amount NUMBER;
1959: l_objfundsum_id NUMBER;
1960: l_ledger_id NUMBER;
1961: l_ledger_name VARCHAR2(30);

Line 2309: ozf_objfundsum_pvt.update_objfundsum(

2305: l_objfundsum_rec.planned_amt := NVL(l_objfundsum_rec.planned_amt, 0) + NVL (l_fund_rec.planned_amt, 0);
2306: l_objfundsum_rec.plan_curr_planned_amt := NVL(l_objfundsum_rec.plan_curr_planned_amt, 0)
2307: + NVL(l_act_budgets_rec.request_amount, 0);
2308: l_objfundsum_rec.univ_curr_planned_amt := NVL(l_objfundsum_rec.univ_curr_planned_amt, 0) + NVL(l_univ_amount, 0);
2309: ozf_objfundsum_pvt.update_objfundsum(
2310: p_api_version => 1.0,
2311: p_init_msg_list => Fnd_Api.G_FALSE,
2312: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
2313: p_objfundsum_rec => l_objfundsum_rec,

Line 2468: ozf_objfundsum_pvt.create_objfundsum(

2464: l_objfundsum_rec.plan_curr_planned_amt := NVL(l_objfundsum_rec.plan_curr_planned_amt, 0)
2465: + NVL(l_act_budgets_rec.request_amount, 0);
2466: l_objfundsum_rec.univ_curr_planned_amt := NVL(l_objfundsum_rec.univ_curr_planned_amt, 0) + NVL(l_univ_amount, 0);
2467: IF l_objfundsum_rec.objfundsum_id IS NULL THEN
2468: ozf_objfundsum_pvt.create_objfundsum(
2469: p_api_version => 1.0,
2470: p_init_msg_list => Fnd_Api.G_FALSE,
2471: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
2472: p_objfundsum_rec => l_objfundsum_rec,

Line 2481: ozf_objfundsum_pvt.update_objfundsum(

2477: );
2478: ELSE
2479:
2480: IF p_use_fund_staging_tables <> 'T' THEN
2481: ozf_objfundsum_pvt.update_objfundsum(
2482: p_api_version => 1.0,
2483: p_init_msg_list => Fnd_Api.G_FALSE,
2484: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
2485: p_objfundsum_rec => l_objfundsum_rec,

Line 5536: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;

5532: l_fund_transfer_flag VARCHAR2 (1) := fnd_api.g_false;
5533: l_fund_recal_committed_amount NUMBER;
5534: l_univ_planned_amount NUMBER;
5535: l_univ_committed_amount NUMBER;
5536: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;
5537: l_objfundsum_id NUMBER;
5538:
5539: l_fund_reconc_msg VARCHAR2(4000);
5540: l_act_bud_cst_msg VARCHAR2(4000);

Line 6214: ozf_objfundsum_pvt.create_objfundsum(

6210: l_objfundsum_rec.reference_object_type := 'EVEH';
6211: END IF;
6212: END IF;
6213:
6214: ozf_objfundsum_pvt.create_objfundsum(
6215: p_api_version => 1.0,
6216: p_init_msg_list => Fnd_Api.G_FALSE,
6217: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
6218: p_objfundsum_rec => l_objfundsum_rec,

Line 6237: ozf_objfundsum_pvt.update_objfundsum(

6233:
6234: /* Obj_fundsum changes */
6235: IF p_use_fund_staging_tables <> 'T' THEN
6236:
6237: ozf_objfundsum_pvt.update_objfundsum(
6238: p_api_version => 1.0,
6239: p_init_msg_list => Fnd_Api.G_FALSE,
6240: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
6241: p_objfundsum_rec => l_objfundsum_rec,

Line 6271: ozf_objfundsum_pvt.update_objfundsum(

6267: x_msg_count => x_msg_count,
6268: x_msg_data => x_msg_data
6269: );
6270: ELSE
6271: ozf_objfundsum_pvt.update_objfundsum(
6272: p_api_version => 1.0,
6273: p_init_msg_list => Fnd_Api.G_FALSE,
6274: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
6275: p_objfundsum_rec => l_objfundsum_rec,

Line 6333: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;

6329: l_fund_object_version_number NUMBER;
6330: l_fund_currency_tc VARCHAR2 (15); -- a fund's transactional currency code
6331: l_fund_planned_amount NUMBER;
6332: l_univ_planned_amount NUMBER;
6333: l_objfundsum_rec ozf_objfundsum_pvt.objfundsum_rec_type := NULL;
6334:
6335: CURSOR c_fund (l_fund_id IN NUMBER) IS
6336: SELECT object_version_number, currency_code_tc, planned_amt
6337: FROM ozf_funds_all_b

Line 6438: ozf_objfundsum_pvt.update_objfundsum(

6434: l_objfundsum_rec.plan_curr_planned_amt := NVL(l_objfundsum_rec.plan_curr_planned_amt, 0)
6435: - NVL(l_temp_rec.request_amount, 0);
6436: l_objfundsum_rec.univ_curr_planned_amt := NVL(l_objfundsum_rec.univ_curr_planned_amt, 0)
6437: - NVL(l_univ_planned_amount, 0);
6438: ozf_objfundsum_pvt.update_objfundsum(
6439: p_api_version => 1.0,
6440: p_init_msg_list => Fnd_Api.G_FALSE,
6441: p_validation_level => Fnd_Api.G_VALID_LEVEL_NONE,
6442: p_objfundsum_rec => l_objfundsum_rec,

Line 6876: p_objfundsum_rec IN OZF_OBJFUNDSUM_PVT.objfundsum_rec_type,

6872: PROCEDURE update_reconcile_objfundsum (
6873: p_api_version IN NUMBER,
6874: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
6875: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
6876: p_objfundsum_rec IN OZF_OBJFUNDSUM_PVT.objfundsum_rec_type,
6877: p_conv_date IN DATE,
6878: x_return_status OUT NOCOPY VARCHAR2,
6879: x_msg_count OUT NOCOPY NUMBER,
6880: x_msg_data OUT NOCOPY VARCHAR2

Line 6889: l_objfundsum_rec OZF_OBJFUNDSUM_PVT.objfundsum_rec_type := p_objfundsum_rec;

6885: L_API_NAME CONSTANT VARCHAR2(30) := 'update_reconcile_objfundsum';
6886: L_FULL_NAME CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
6887:
6888: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6889: l_objfundsum_rec OZF_OBJFUNDSUM_PVT.objfundsum_rec_type := p_objfundsum_rec;
6890: l_amount_1 NUMBER;
6891: l_amount_2 NUMBER;
6892: l_amount_3 NUMBER;
6893:

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

6921: ozf_utility_pvt.debug_message(l_full_name ||': validate');
6922: END IF;
6923:
6924: -- replace g_miss_char/num/date with current column values
6925: OZF_OBJFUNDSUM_PVT.Complete_objfundsum_Rec(p_objfundsum_rec, l_objfundsum_rec);
6926:
6927: -- currency conversion for planned amount
6928: complete_amount_fields (
6929: p_currency_1 => l_objfundsum_rec.object_currency,

Line 7082: OZF_OBJFUNDSUM_PVT.Validate_objfundsum (

7078: l_objfundsum_rec.paid_amt := l_amount_2;
7079: l_objfundsum_rec.univ_curr_paid_amt := l_amount_3;
7080:
7081: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
7082: OZF_OBJFUNDSUM_PVT.Validate_objfundsum (
7083: p_api_version => l_api_version,
7084: p_init_msg_list => p_init_msg_list,
7085: p_validation_level => p_validation_level,
7086: p_objfundsum_rec => l_objfundsum_rec,