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_FUND_ADJUSTMENT_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 179: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

175: l_api_version NUMBER := 1.0;
176: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
177: l_api_name VARCHAR2 (60) := 'create_budget_amount_utilized';
178: l_act_budget_id NUMBER;
179: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
180: l_util_amount NUMBER := 0;
181: l_amount_remaining NUMBER := 0;
182: l_full_name CONSTANT VARCHAR2 (90) := g_pkg_name
183: || '.'

Line 322: ozf_actbudgets_pvt.create_act_budgets (

318:
319: IF l_activity_id IS NULL THEN
320: l_act_budgets_rec.approved_amount := l_util_amount;
321: l_act_budgets_rec.parent_src_apprvd_amt := l_parent_source_rec.total_amount;
322: ozf_actbudgets_pvt.create_act_budgets (
323: p_api_version=> l_api_version
324: ,x_return_status=> l_return_status
325: ,x_msg_count=> x_msg_count
326: ,x_msg_data=> x_msg_data

Line 342: ozf_actbudgets_pvt.update_act_budgets (

338: + l_util_amount;
339: l_act_budgets_rec.parent_src_apprvd_amt := l_parent_source_rec.total_amount + l_old_parent_src_amt;
340: l_act_budgets_rec.activity_budget_id := l_activity_id;
341: l_act_budgets_rec.object_version_number := l_obj_ver_num;
342: ozf_actbudgets_pvt.update_act_budgets (
343: p_api_version=> l_api_version
344: ,x_return_status=> l_return_status
345: ,x_msg_count=> x_msg_count
346: ,x_msg_data=> x_msg_data

Line 355: p_act_util_rec =>ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC,

351: process_act_budgets (x_return_status => l_return_status,
352: x_msg_count => x_msg_count,
353: x_msg_data => x_msg_data,
354: p_act_budgets_rec => l_act_budgets_rec,
355: p_act_util_rec =>ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC,
356: x_act_budget_id => l_act_budget_id,
357: x_utilized_amount => l_utilized_amount
358: ) ;
359:

Line 602: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

598: -- 02/28/02 feliu Added condition for manual adjustment.
599: ---------------------------------------------------------------------
600:
601: PROCEDURE create_fund_utilization (
602: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
603: ,x_return_status OUT NOCOPY VARCHAR2
604: ,x_msg_count OUT NOCOPY NUMBER
605: ,x_msg_data OUT NOCOPY VARCHAR2
606: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

Line 606: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

602: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
603: ,x_return_status OUT NOCOPY VARCHAR2
604: ,x_msg_count OUT NOCOPY NUMBER
605: ,x_msg_data OUT NOCOPY VARCHAR2
606: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
607: := ozf_actbudgets_pvt.g_miss_act_util_rec
608: ) IS
609: l_utilized_amount NUMBER;
610: BEGIN

Line 607: := ozf_actbudgets_pvt.g_miss_act_util_rec

603: ,x_return_status OUT NOCOPY VARCHAR2
604: ,x_msg_count OUT NOCOPY NUMBER
605: ,x_msg_data OUT NOCOPY VARCHAR2
606: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
607: := ozf_actbudgets_pvt.g_miss_act_util_rec
608: ) IS
609: l_utilized_amount NUMBER;
610: BEGIN
611: create_fund_utilization (

Line 634: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

630: -- 06/21/2004 yzhao Added x_utilized_amount to return actual utilized amount
631: ---------------------------------------------------------------------
632:
633: PROCEDURE create_fund_utilization (
634: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
635: ,x_return_status OUT NOCOPY VARCHAR2
636: ,x_msg_count OUT NOCOPY NUMBER
637: ,x_msg_data OUT NOCOPY VARCHAR2
638: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

Line 638: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

634: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
635: ,x_return_status OUT NOCOPY VARCHAR2
636: ,x_msg_count OUT NOCOPY NUMBER
637: ,x_msg_data OUT NOCOPY VARCHAR2
638: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
639: := ozf_actbudgets_pvt.g_miss_act_util_rec
640: ,x_utilized_amount OUT NOCOPY NUMBER
641: ) IS
642: l_api_version CONSTANT NUMBER := 1.0;

Line 639: := ozf_actbudgets_pvt.g_miss_act_util_rec

635: ,x_return_status OUT NOCOPY VARCHAR2
636: ,x_msg_count OUT NOCOPY NUMBER
637: ,x_msg_data OUT NOCOPY VARCHAR2
638: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
639: := ozf_actbudgets_pvt.g_miss_act_util_rec
640: ,x_utilized_amount OUT NOCOPY NUMBER
641: ) IS
642: l_api_version CONSTANT NUMBER := 1.0;
643: l_api_name CONSTANT VARCHAR2 (30) := 'create_fund_utilization';

Line 1521: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

1517: PROCEDURE process_act_budgets (
1518: x_return_status OUT NOCOPY VARCHAR2,
1519: x_msg_count OUT NOCOPY NUMBER,
1520: x_msg_data OUT NOCOPY VARCHAR2,
1521: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1522: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
1523: x_act_budget_id OUT NOCOPY NUMBER,
1524: x_utilized_amount OUT NOCOPY NUMBER -- added yzhao Jun 21, 2004
1525: ) IS

Line 1522: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

1518: x_return_status OUT NOCOPY VARCHAR2,
1519: x_msg_count OUT NOCOPY NUMBER,
1520: x_msg_data OUT NOCOPY VARCHAR2,
1521: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1522: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
1523: x_act_budget_id OUT NOCOPY NUMBER,
1524: x_utilized_amount OUT NOCOPY NUMBER -- added yzhao Jun 21, 2004
1525: ) IS
1526: CURSOR c_act_util_rec (p_used_by_id IN NUMBER, p_used_by_type IN VARCHAR2) IS

Line 1540: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type:=p_Act_budgets_rec;

1536: --l_return_status VARCHAR2 (20);
1537: l_api_name VARCHAR2 (60) := 'process_act_budget';
1538: l_full_name VARCHAR2 (100) := g_pkg_name||'.'||l_api_name;
1539: l_act_budget_id NUMBER;
1540: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type:=p_Act_budgets_rec;
1541: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
1542: l_api_version NUMBER := 1;
1543: l_budget_request_rec ozf_actbudgets_pvt.act_budgets_rec_type := NULL;
1544:

Line 1541: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;

1537: l_api_name VARCHAR2 (60) := 'process_act_budget';
1538: l_full_name VARCHAR2 (100) := g_pkg_name||'.'||l_api_name;
1539: l_act_budget_id NUMBER;
1540: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type:=p_Act_budgets_rec;
1541: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
1542: l_api_version NUMBER := 1;
1543: l_budget_request_rec ozf_actbudgets_pvt.act_budgets_rec_type := NULL;
1544:
1545: BEGIN

Line 1543: l_budget_request_rec ozf_actbudgets_pvt.act_budgets_rec_type := NULL;

1539: l_act_budget_id NUMBER;
1540: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type:=p_Act_budgets_rec;
1541: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
1542: l_api_version NUMBER := 1;
1543: l_budget_request_rec ozf_actbudgets_pvt.act_budgets_rec_type := NULL;
1544:
1545: BEGIN
1546: x_return_status := fnd_api.g_ret_sts_success;
1547: IF G_DEBUG THEN

Line 1585: ozf_actbudgets_pvt.create_Act_Budgets (

1581: l_budget_request_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1582: END IF;
1583:
1584:
1585: ozf_actbudgets_pvt.create_Act_Budgets (
1586: p_api_version => 1.0,
1587: p_init_msg_list => Fnd_Api.G_FALSE,
1588: p_commit => Fnd_Api.G_FALSE,
1589: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 1594: p_act_util_rec => ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC,

1590: x_return_status => x_return_status,
1591: x_msg_count => x_msg_count,
1592: x_msg_data => x_msg_data,
1593: p_act_Budgets_rec => l_budget_request_rec,
1594: p_act_util_rec => ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC,
1595: p_approval_flag => fnd_api.g_true, -- auto approved
1596: x_act_budget_id => l_act_budget_id);
1597: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1598: RAISE fnd_api.g_exc_unexpected_error;

Line 1619: ozf_actbudgets_pvt.create_act_budgets (

1615:
1616: IF l_activity_id IS NULL THEN
1617: --l_act_budgets_rec.approved_amount := l_util_amount;
1618: --l_act_budgets_rec.parent_src_apprvd_amt := l_parent_source_rec.total_amount;
1619: ozf_actbudgets_pvt.create_act_budgets (
1620: p_api_version=> l_api_version,
1621: x_return_status=> x_return_status,
1622: x_msg_count=> x_msg_count,
1623: x_msg_data=> x_msg_data,

Line 1663: ozf_actbudgets_pvt.update_act_budgets (

1659: l_act_budgets_rec.parent_src_apprvd_amt :=
1660: l_act_budgets_rec.parent_src_apprvd_amt;
1661: l_act_budgets_rec.activity_budget_id := l_activity_id;
1662: l_act_budgets_rec.object_version_number := l_obj_ver_num;
1663: ozf_actbudgets_pvt.update_act_budgets (
1664: p_api_version=> l_api_version,
1665: x_return_status=> x_return_status,
1666: x_msg_count=> x_msg_count,
1667: x_msg_data=> x_msg_data,

Line 1745: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

1741: PROCEDURE process_act_budgets (
1742: x_return_status OUT NOCOPY VARCHAR2,
1743: x_msg_count OUT NOCOPY NUMBER,
1744: x_msg_data OUT NOCOPY VARCHAR2,
1745: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1746: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
1747: x_act_budget_id OUT NOCOPY NUMBER
1748: ) IS
1749: l_utilized_amount NUMBER;

Line 1746: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

1742: x_return_status OUT NOCOPY VARCHAR2,
1743: x_msg_count OUT NOCOPY NUMBER,
1744: x_msg_data OUT NOCOPY VARCHAR2,
1745: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1746: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
1747: x_act_budget_id OUT NOCOPY NUMBER
1748: ) IS
1749: l_utilized_amount NUMBER;
1750: BEGIN

Line 1806: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1802: || l_api_name;
1803: l_product_id NUMBER;
1804: l_offer_start_date DATE;
1805: l_act_budget_id NUMBER;
1806: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1807: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
1808: l_amount NUMBER := 0;
1809: l_converted_amt NUMBER;
1810: l_perform_util VARCHAR2 (1);

Line 1807: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

1803: l_product_id NUMBER;
1804: l_offer_start_date DATE;
1805: l_act_budget_id NUMBER;
1806: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1807: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
1808: l_amount NUMBER := 0;
1809: l_converted_amt NUMBER;
1810: l_perform_util VARCHAR2 (1);
1811: l_level_type_code VARCHAR2 (30);

Line 2225: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2221: l_fund_id NUMBER;
2222: l_offer_start_date DATE;
2223: l_offer_end_date DATE;
2224: l_act_budget_id NUMBER;
2225: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2226: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
2227: l_amount NUMBER := 0;
2228: l_converted_amt NUMBER;
2229: l_perform_util VARCHAR2 (1);

Line 2226: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

2222: l_offer_start_date DATE;
2223: l_offer_end_date DATE;
2224: l_act_budget_id NUMBER;
2225: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2226: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
2227: l_amount NUMBER := 0;
2228: l_converted_amt NUMBER;
2229: l_perform_util VARCHAR2 (1);
2230: l_offer_total_amount NUMBER;

Line 2872: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2868: l_available_amt NUMBER;
2869: l_offer_currency_code VARCHAR2 (30);
2870: l_product_id NUMBER;
2871: l_level_type_code VARCHAR2 (30);
2872: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2873: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
2874: l_converted_amt NUMBER;
2875: l_budget_currency_code VARCHAR2 (30);
2876: l_act_budget_id NUMBER;

Line 2873: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

2869: l_offer_currency_code VARCHAR2 (30);
2870: l_product_id NUMBER;
2871: l_level_type_code VARCHAR2 (30);
2872: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2873: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
2874: l_converted_amt NUMBER;
2875: l_budget_currency_code VARCHAR2 (30);
2876: l_act_budget_id NUMBER;
2877: l_source_from_parent VARCHAR2 (1);

Line 3093: ozf_actbudgets_pvt.create_act_budgets (

3089: l_act_budgets_rec.approval_date := SYSDATE;
3090: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3091: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3092:
3093: ozf_actbudgets_pvt.create_act_budgets (
3094: p_api_version=> l_api_version
3095: ,x_return_status=> l_return_status
3096: ,x_msg_count=> l_msg_count
3097: ,x_msg_data=> l_msg_data

Line 3423: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

3419: l_offer_id NUMBER := p_offer_id;
3420: l_media_id NUMBER;
3421: l_fund_id NUMBER;
3422: l_act_budget_id NUMBER;
3423: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
3424: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
3425: l_amount NUMBER := 0;
3426: l_converted_amt NUMBER;
3427: l_level_type_code VARCHAR2 (30);

Line 3424: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

3420: l_media_id NUMBER;
3421: l_fund_id NUMBER;
3422: l_act_budget_id NUMBER;
3423: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
3424: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
3425: l_amount NUMBER := 0;
3426: l_converted_amt NUMBER;
3427: l_level_type_code VARCHAR2 (30);
3428: l_currency_code VARCHAR2 (30);