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 181: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

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

Line 324: ozf_actbudgets_pvt.create_act_budgets (

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

Line 344: ozf_actbudgets_pvt.update_act_budgets (

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

Line 357: p_act_util_rec =>ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC,

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

Line 611: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

607: -- 02/28/02 feliu Added condition for manual adjustment.
608: ---------------------------------------------------------------------
609:
610: PROCEDURE create_fund_utilization (
611: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
612: ,x_return_status OUT NOCOPY VARCHAR2
613: ,x_msg_count OUT NOCOPY NUMBER
614: ,x_msg_data OUT NOCOPY VARCHAR2
615: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

Line 615: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

611: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
612: ,x_return_status OUT NOCOPY VARCHAR2
613: ,x_msg_count OUT NOCOPY NUMBER
614: ,x_msg_data OUT NOCOPY VARCHAR2
615: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
616: := ozf_actbudgets_pvt.g_miss_act_util_rec
617: ) IS
618: l_utilized_amount NUMBER;
619: BEGIN

Line 616: := ozf_actbudgets_pvt.g_miss_act_util_rec

612: ,x_return_status OUT NOCOPY VARCHAR2
613: ,x_msg_count OUT NOCOPY NUMBER
614: ,x_msg_data OUT NOCOPY VARCHAR2
615: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
616: := ozf_actbudgets_pvt.g_miss_act_util_rec
617: ) IS
618: l_utilized_amount NUMBER;
619: BEGIN
620: create_fund_utilization (

Line 644: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

640: -- For TPA Parallel Execution ER - 9614703.
641: ---------------------------------------------------------------------
642:
643: PROCEDURE create_fund_utilization (
644: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
645: ,x_return_status OUT NOCOPY VARCHAR2
646: ,x_msg_count OUT NOCOPY NUMBER
647: ,x_msg_data OUT NOCOPY VARCHAR2
648: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

Line 648: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

644: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
645: ,x_return_status OUT NOCOPY VARCHAR2
646: ,x_msg_count OUT NOCOPY NUMBER
647: ,x_msg_data OUT NOCOPY VARCHAR2
648: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
649: := ozf_actbudgets_pvt.g_miss_act_util_rec
650: ,x_utilized_amount OUT NOCOPY NUMBER
651: ) IS
652: l_use_fund_staging_tables VARCHAR2(1):= 'F';

Line 649: := ozf_actbudgets_pvt.g_miss_act_util_rec

645: ,x_return_status OUT NOCOPY VARCHAR2
646: ,x_msg_count OUT NOCOPY NUMBER
647: ,x_msg_data OUT NOCOPY VARCHAR2
648: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
649: := ozf_actbudgets_pvt.g_miss_act_util_rec
650: ,x_utilized_amount OUT NOCOPY NUMBER
651: ) IS
652: l_use_fund_staging_tables VARCHAR2(1):= 'F';
653: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;

Line 674: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

670: );
671: END create_fund_utilization;
672:
673: PROCEDURE create_fund_utilization (
674: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
675: ,x_return_status OUT NOCOPY VARCHAR2
676: ,x_msg_count OUT NOCOPY NUMBER
677: ,x_msg_data OUT NOCOPY VARCHAR2
678: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

Line 678: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

674: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
675: ,x_return_status OUT NOCOPY VARCHAR2
676: ,x_msg_count OUT NOCOPY NUMBER
677: ,x_msg_data OUT NOCOPY VARCHAR2
678: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
679: := ozf_actbudgets_pvt.g_miss_act_util_rec
680: ,x_utilized_amount OUT NOCOPY NUMBER
681: ,x_utilization_id OUT NOCOPY NUMBER
682: ) IS

Line 679: := ozf_actbudgets_pvt.g_miss_act_util_rec

675: ,x_return_status OUT NOCOPY VARCHAR2
676: ,x_msg_count OUT NOCOPY NUMBER
677: ,x_msg_data OUT NOCOPY VARCHAR2
678: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
679: := ozf_actbudgets_pvt.g_miss_act_util_rec
680: ,x_utilized_amount OUT NOCOPY NUMBER
681: ,x_utilization_id OUT NOCOPY NUMBER
682: ) IS
683: l_use_fund_staging_tables VARCHAR2(1):= 'F';

Line 706: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

702: );
703: END create_fund_utilization;
704:
705: PROCEDURE create_fund_utilization (
706: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
707: ,x_return_status OUT NOCOPY VARCHAR2
708: ,x_msg_count OUT NOCOPY NUMBER
709: ,x_msg_data OUT NOCOPY VARCHAR2
710: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

Line 710: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

706: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
707: ,x_return_status OUT NOCOPY VARCHAR2
708: ,x_msg_count OUT NOCOPY NUMBER
709: ,x_msg_data OUT NOCOPY VARCHAR2
710: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
711: := ozf_actbudgets_pvt.g_miss_act_util_rec
712: ,x_utilized_amount OUT NOCOPY NUMBER
713: ,p_batch_type IN VARCHAR2
714: ,p_use_fund_staging_tables IN VARCHAR2

Line 711: := ozf_actbudgets_pvt.g_miss_act_util_rec

707: ,x_return_status OUT NOCOPY VARCHAR2
708: ,x_msg_count OUT NOCOPY NUMBER
709: ,x_msg_data OUT NOCOPY VARCHAR2
710: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
711: := ozf_actbudgets_pvt.g_miss_act_util_rec
712: ,x_utilized_amount OUT NOCOPY NUMBER
713: ,p_batch_type IN VARCHAR2
714: ,p_use_fund_staging_tables IN VARCHAR2
715: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

Line 759: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

755: -- for TPA Parallel Execution ERBug#9614703.
756: ---------------------------------------------------------------------
757:
758: PROCEDURE create_fund_utilization (
759: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
760: ,x_return_status OUT NOCOPY VARCHAR2
761: ,x_msg_count OUT NOCOPY NUMBER
762: ,x_msg_data OUT NOCOPY VARCHAR2
763: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

Line 763: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type

759: p_act_budget_rec IN ozf_actbudgets_pvt.act_budgets_rec_type
760: ,x_return_status OUT NOCOPY VARCHAR2
761: ,x_msg_count OUT NOCOPY NUMBER
762: ,x_msg_data OUT NOCOPY VARCHAR2
763: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
764: := ozf_actbudgets_pvt.g_miss_act_util_rec
765: ,x_utilized_amount OUT NOCOPY NUMBER
766: ,p_batch_type IN VARCHAR2
767: ,p_use_fund_staging_tables IN VARCHAR2

Line 764: := ozf_actbudgets_pvt.g_miss_act_util_rec

760: ,x_return_status OUT NOCOPY VARCHAR2
761: ,x_msg_count OUT NOCOPY NUMBER
762: ,x_msg_data OUT NOCOPY VARCHAR2
763: ,p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type
764: := ozf_actbudgets_pvt.g_miss_act_util_rec
765: ,x_utilized_amount OUT NOCOPY NUMBER
766: ,p_batch_type IN VARCHAR2
767: ,p_use_fund_staging_tables IN VARCHAR2
768: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

Line 1744: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

1740: PROCEDURE process_act_budgets (
1741: x_return_status OUT NOCOPY VARCHAR2,
1742: x_msg_count OUT NOCOPY NUMBER,
1743: x_msg_data OUT NOCOPY VARCHAR2,
1744: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1745: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
1746: x_act_budget_id OUT NOCOPY NUMBER,
1747: x_utilized_amount OUT NOCOPY NUMBER, -- added yzhao Jun 21, 2004
1748: p_batch_type IN VARCHAR2,

Line 1745: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

1741: x_return_status OUT NOCOPY VARCHAR2,
1742: x_msg_count OUT NOCOPY NUMBER,
1743: x_msg_data OUT NOCOPY VARCHAR2,
1744: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1745: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
1746: x_act_budget_id OUT NOCOPY NUMBER,
1747: x_utilized_amount OUT NOCOPY NUMBER, -- added yzhao Jun 21, 2004
1748: p_batch_type IN VARCHAR2,
1749: p_use_fund_staging_tables IN VARCHAR2,

Line 1779: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

1775: PROCEDURE process_act_budgets (
1776: x_return_status OUT NOCOPY VARCHAR2,
1777: x_msg_count OUT NOCOPY NUMBER,
1778: x_msg_data OUT NOCOPY VARCHAR2,
1779: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1780: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
1781: x_act_budget_id OUT NOCOPY NUMBER,
1782: x_utilized_amount OUT NOCOPY NUMBER, -- added yzhao Jun 21, 2004
1783: p_batch_type IN VARCHAR2,

Line 1780: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

1776: x_return_status OUT NOCOPY VARCHAR2,
1777: x_msg_count OUT NOCOPY NUMBER,
1778: x_msg_data OUT NOCOPY VARCHAR2,
1779: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
1780: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
1781: x_act_budget_id OUT NOCOPY NUMBER,
1782: x_utilized_amount OUT NOCOPY NUMBER, -- added yzhao Jun 21, 2004
1783: p_batch_type IN VARCHAR2,
1784: p_use_fund_staging_tables IN VARCHAR2,

Line 1813: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type:=p_Act_budgets_rec;

1809: l_api_name VARCHAR2 (60) := 'process_act_budget';
1810: l_full_name VARCHAR2 (100) := g_pkg_name||'.'||l_api_name;
1811: l_act_budget_id NUMBER;
1812: l_utilized_amount NUMBER;
1813: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type:=p_Act_budgets_rec;
1814: l_old_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1815: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
1816: l_api_version NUMBER := 1;
1817: l_budget_request_rec ozf_actbudgets_pvt.act_budgets_rec_type := NULL;

Line 1814: l_old_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1810: l_full_name VARCHAR2 (100) := g_pkg_name||'.'||l_api_name;
1811: l_act_budget_id NUMBER;
1812: l_utilized_amount NUMBER;
1813: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type:=p_Act_budgets_rec;
1814: l_old_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1815: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
1816: l_api_version NUMBER := 1;
1817: l_budget_request_rec ozf_actbudgets_pvt.act_budgets_rec_type := NULL;
1818: l_plan_currency VARCHAR2(150);

Line 1815: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;

1811: l_act_budget_id NUMBER;
1812: l_utilized_amount NUMBER;
1813: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type:=p_Act_budgets_rec;
1814: l_old_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1815: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
1816: l_api_version NUMBER := 1;
1817: l_budget_request_rec ozf_actbudgets_pvt.act_budgets_rec_type := NULL;
1818: l_plan_currency VARCHAR2(150);
1819: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR ;

Line 1817: l_budget_request_rec ozf_actbudgets_pvt.act_budgets_rec_type := NULL;

1813: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type:=p_Act_budgets_rec;
1814: l_old_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1815: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
1816: l_api_version NUMBER := 1;
1817: l_budget_request_rec ozf_actbudgets_pvt.act_budgets_rec_type := NULL;
1818: l_plan_currency VARCHAR2(150);
1819: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR ;
1820: l_rate NUMBER;
1821: --l_utilized_amount NUMBER;

Line 1885: ozf_actbudgets_pvt.create_Act_Budgets (

1881: -- and px_ozf_funds_old_rectype for taking the funds old values
1882: -- For TPA Parallel Execution ERBug#9614703
1883: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
1884:
1885: ozf_actbudgets_pvt.create_Act_Budgets (
1886: p_api_version => 1.0,
1887: p_init_msg_list => Fnd_Api.G_FALSE,
1888: p_commit => Fnd_Api.G_FALSE,
1889: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 1894: p_act_util_rec => ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC,

1890: x_return_status => x_return_status,
1891: x_msg_count => x_msg_count,
1892: x_msg_data => x_msg_data,
1893: p_act_Budgets_rec => l_budget_request_rec,
1894: p_act_util_rec => ozf_actbudgets_pvt.G_MISS_ACT_UTIL_REC,
1895: p_approval_flag => fnd_api.g_true, -- auto approved
1896: x_act_budget_id => l_act_budget_id,
1897: x_utilized_amount => l_utilized_amount,
1898: p_resale_batch_id => l_act_util_rec.reference_id,

Line 1942: /*ozf_actbudgets_pvt.create_act_budgets (

1938:
1939: IF l_activity_id IS NULL THEN
1940: --l_act_budgets_rec.approved_amount := l_util_amount;
1941: --l_act_budgets_rec.parent_src_apprvd_amt := l_parent_source_rec.total_amount;
1942: /*ozf_actbudgets_pvt.create_act_budgets (
1943: p_api_version=> l_api_version,
1944: x_return_status=> x_return_status,
1945: x_msg_count=> x_msg_count,
1946: x_msg_data=> x_msg_data,

Line 1957: ozf_actbudgets_pvt.create_act_budgets (

1953: /* Bug#9614703 update to ozf_funds_all_tl table was happening during creation of act_budget
1954: records. So we need to send p_use_fund_staging_tables flag and px_ozf_act_budgets_tbl rec
1955: in this flow as well. Hence used the overloaded procedure.
1956: */
1957: ozf_actbudgets_pvt.create_act_budgets (
1958: p_api_version=> l_api_version,
1959: p_init_msg_list => Fnd_Api.G_FALSE,
1960: p_commit => Fnd_Api.G_FALSE,
1961: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 2071: ozf_actbudgets_pvt.update_act_budgets (

2067: l_old_act_budgets_rec.parent_src_apprvd_amt := l_parent_src_apprvd_amt;
2068: l_old_act_budgets_rec.src_curr_request_amt := l_src_curr_request_amt;
2069:
2070: /*
2071: ozf_actbudgets_pvt.update_act_budgets (
2072: p_api_version=> l_api_version,
2073: x_return_status=> x_return_status,
2074: x_msg_count=> x_msg_count,
2075: x_msg_data=> x_msg_data,

Line 2091: ozf_actbudgets_pvt.update_act_budgets (

2087: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
2088:
2089:
2090:
2091: ozf_actbudgets_pvt.update_act_budgets (
2092: p_api_version=> l_api_version,
2093: x_return_status=> x_return_status,
2094: x_msg_count=> x_msg_count,
2095: x_msg_data=> x_msg_data,

Line 2187: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

2183: PROCEDURE process_act_budgets (
2184: x_return_status OUT NOCOPY VARCHAR2,
2185: x_msg_count OUT NOCOPY NUMBER,
2186: x_msg_data OUT NOCOPY VARCHAR2,
2187: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
2188: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
2189: x_act_budget_id OUT NOCOPY NUMBER
2190: ) IS
2191: l_utilized_amount NUMBER;

Line 2188: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

2184: x_return_status OUT NOCOPY VARCHAR2,
2185: x_msg_count OUT NOCOPY NUMBER,
2186: x_msg_data OUT NOCOPY VARCHAR2,
2187: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
2188: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
2189: x_act_budget_id OUT NOCOPY NUMBER
2190: ) IS
2191: l_utilized_amount NUMBER;
2192: BEGIN

Line 2228: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

2224: PROCEDURE process_act_budgets (
2225: x_return_status OUT NOCOPY VARCHAR2,
2226: x_msg_count OUT NOCOPY NUMBER,
2227: x_msg_data OUT NOCOPY VARCHAR2,
2228: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
2229: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
2230: x_act_budget_id OUT NOCOPY NUMBER,
2231: x_utilized_amount OUT NOCOPY NUMBER
2232: ) IS

Line 2229: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

2225: x_return_status OUT NOCOPY VARCHAR2,
2226: x_msg_count OUT NOCOPY NUMBER,
2227: x_msg_data OUT NOCOPY VARCHAR2,
2228: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
2229: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
2230: x_act_budget_id OUT NOCOPY NUMBER,
2231: x_utilized_amount OUT NOCOPY NUMBER
2232: ) IS
2233: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;

Line 2258: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,

2254: PROCEDURE process_act_budgets (
2255: x_return_status OUT NOCOPY VARCHAR2,
2256: x_msg_count OUT NOCOPY NUMBER,
2257: x_msg_data OUT NOCOPY VARCHAR2,
2258: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
2259: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
2260: x_act_budget_id OUT NOCOPY NUMBER,
2261: x_utilized_amount OUT NOCOPY NUMBER,
2262: x_utilization_id OUT NOCOPY NUMBER

Line 2259: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

2255: x_return_status OUT NOCOPY VARCHAR2,
2256: x_msg_count OUT NOCOPY NUMBER,
2257: x_msg_data OUT NOCOPY VARCHAR2,
2258: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type,
2259: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
2260: x_act_budget_id OUT NOCOPY NUMBER,
2261: x_utilized_amount OUT NOCOPY NUMBER,
2262: x_utilization_id OUT NOCOPY NUMBER
2263: ) IS

Line 2328: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2324: || l_api_name;
2325: l_product_id NUMBER;
2326: l_offer_start_date DATE;
2327: l_act_budget_id NUMBER;
2328: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2329: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
2330: l_amount NUMBER := 0;
2331: l_converted_amt NUMBER;
2332: l_perform_util VARCHAR2 (1);

Line 2329: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

2325: l_product_id NUMBER;
2326: l_offer_start_date DATE;
2327: l_act_budget_id NUMBER;
2328: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2329: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
2330: l_amount NUMBER := 0;
2331: l_converted_amt NUMBER;
2332: l_perform_util VARCHAR2 (1);
2333: l_level_type_code VARCHAR2 (30);

Line 2752: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

2748: l_fund_id NUMBER;
2749: l_offer_start_date DATE;
2750: l_offer_end_date DATE;
2751: l_act_budget_id NUMBER;
2752: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2753: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
2754: l_amount NUMBER := 0;
2755: l_converted_amt NUMBER;
2756: l_perform_util VARCHAR2 (1);

Line 2753: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

2749: l_offer_start_date DATE;
2750: l_offer_end_date DATE;
2751: l_act_budget_id NUMBER;
2752: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
2753: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
2754: l_amount NUMBER := 0;
2755: l_converted_amt NUMBER;
2756: l_perform_util VARCHAR2 (1);
2757: l_offer_total_amount NUMBER;

Line 3547: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

3543: l_available_amt NUMBER;
3544: l_offer_currency_code VARCHAR2 (30);
3545: l_product_id NUMBER;
3546: l_level_type_code VARCHAR2 (30);
3547: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
3548: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
3549: l_converted_amt NUMBER;
3550: l_budget_currency_code VARCHAR2 (30);
3551: l_act_budget_id NUMBER;

Line 3548: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

3544: l_offer_currency_code VARCHAR2 (30);
3545: l_product_id NUMBER;
3546: l_level_type_code VARCHAR2 (30);
3547: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
3548: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
3549: l_converted_amt NUMBER;
3550: l_budget_currency_code VARCHAR2 (30);
3551: l_act_budget_id NUMBER;
3552: l_source_from_parent VARCHAR2 (1);

Line 3769: ozf_actbudgets_pvt.create_act_budgets (

3765: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3766: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3767:
3768:
3769: ozf_actbudgets_pvt.create_act_budgets (
3770: p_api_version=> l_api_version
3771: ,x_return_status=> l_return_status
3772: ,x_msg_count=> l_msg_count
3773: ,x_msg_data=> l_msg_data

Line 4101: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

4097: l_offer_id NUMBER := p_offer_id;
4098: l_media_id NUMBER;
4099: l_fund_id NUMBER;
4100: l_act_budget_id NUMBER;
4101: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
4102: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
4103: l_amount NUMBER := 0;
4104: l_converted_amt NUMBER;
4105: l_level_type_code VARCHAR2 (30);

Line 4102: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

4098: l_media_id NUMBER;
4099: l_fund_id NUMBER;
4100: l_act_budget_id NUMBER;
4101: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
4102: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
4103: l_amount NUMBER := 0;
4104: l_converted_amt NUMBER;
4105: l_level_type_code VARCHAR2 (30);
4106: l_currency_code VARCHAR2 (30);