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_ACT_BUDGETS

Line 93: -- 10/5/2011 nepanda Fix for bug 12911854 : rounded the amount values in ozf_act_budgets table

89: -- 2/17/2010 nepanda Bug 9131648 : multi currency changes
90: -- 5/5/2010 nepanda Bug 9625995 : Transaction currency value in Recalculated commited page is not getting converted.
91: -- 04/01/2011 muthsubr Fix for bug#8867381 - IDSM BATCH PAYMENT INITIALIZATION ERROR
92: -- 04/01/2011 muthsubr For TPA Parallel Execution ER Bug#9614703.
93: -- 10/5/2011 nepanda Fix for bug 12911854 : rounded the amount values in ozf_act_budgets table
94: -- 10/17/2012 nepanda Fix for Bug 14724414 - tst1213:getting error while approving accrual offer [changes made on ver 120.21.12010000.16]
95: -- Note
96: -- Please refer the spec for validation rules in this table
97: -- The following is the mapping of the currency Columns

Line 347: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;

343: ) IS
344: l_utilized_amount NUMBER;
345: l_resale_batch_id NUMBER;
346: l_use_fund_staging_tables VARCHAR2(1) := 'F';
347: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
348: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
349: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
350: l_batch_type VARCHAR2(30);
351: BEGIN

Line 370: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl

366: ,x_utilized_amount => x_utilized_amount
367: ,p_resale_batch_id => l_resale_batch_id
368: ,p_batch_type => l_batch_type
369: ,p_use_fund_staging_tables => l_use_fund_staging_tables
370: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl
371: ,px_ozf_funds_old_rectype => lx_ozf_funds_old_rectype
372: ,px_ozf_funds_new_tbl => lx_ozf_funds_new_tbl -- For TPA Parallel Execution ER - 9614703
373: );
374: END create_act_budgets;

Line 395: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;

391: ) IS
392: l_utilized_amount NUMBER;
393: l_resale_batch_id NUMBER;
394: l_use_fund_staging_tables VARCHAR2(1) := 'F';
395: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
396: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
397: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
398: l_batch_type VARCHAR2(30);
399: BEGIN

Line 416: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl

412: ,x_utilized_amount => l_utilized_amount
413: ,p_resale_batch_id => l_resale_batch_id
414: ,p_batch_type => l_batch_type
415: ,p_use_fund_staging_tables => l_use_fund_staging_tables
416: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl
417: ,px_ozf_funds_old_rectype => lx_ozf_funds_old_rectype
418: ,px_ozf_funds_new_tbl => lx_ozf_funds_new_tbl -- For TPA Parallel Execution ER - 9614703
419: ,x_utilization_id => x_utilization_id
420: );

Line 463: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

459: ,x_utilized_amount OUT NOCOPY NUMBER -- yzhao: 06/21/2004 added for chargeback
460: ,p_resale_batch_id IN NUMBER
461: ,p_batch_type IN VARCHAR2
462: ,p_use_fund_staging_tables IN VARCHAR2
463: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
464: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
465: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
466: ) IS
467: l_utilization_id NUMBER;

Line 486: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl

482: ,x_utilized_amount => x_utilized_amount
483: ,p_resale_batch_id => p_resale_batch_id
484: ,p_batch_type => p_batch_type
485: ,p_use_fund_staging_tables => p_use_fund_staging_tables
486: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl
487: ,px_ozf_funds_old_rectype => px_ozf_funds_old_rectype
488: ,px_ozf_funds_new_tbl => px_ozf_funds_new_tbl -- For TPA Parallel Execution ER - 9614703
489: ,x_utilization_id => l_utilization_id
490: );

Line 509: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

505: ,x_utilized_amount OUT NOCOPY NUMBER -- yzhao: 06/21/2004 added for chargeback
506: ,p_resale_batch_id IN NUMBER
507: ,p_batch_type IN VARCHAR2
508: ,p_use_fund_staging_tables IN VARCHAR2
509: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
510: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
511: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
512: ,x_utilization_id OUT NOCOPY NUMBER --nirprasa added for bug 9383565
513: ) IS

Line 539: SELECT ozf_act_budgets_s.NEXTVAL

535: FROM ozf_offers
536: WHERE qp_list_header_id = p_object_id;
537:
538: CURSOR c_act_budget_id IS
539: SELECT ozf_act_budgets_s.NEXTVAL
540: FROM DUAL;
541:
542: CURSOR c_id_exists (p_id IN NUMBER) IS
543: SELECT 1

Line 544: FROM ozf_act_budgets

540: FROM DUAL;
541:
542: CURSOR c_id_exists (p_id IN NUMBER) IS
543: SELECT 1
544: FROM ozf_act_budgets
545: WHERE activity_budget_id = p_id;
546:
547: CURSOR c_check_quota (p_type IN VARCHAR2, p_fund_id IN NUMBER) IS
548: SELECT 1

Line 1181: INSERT INTO ozf_act_budgets

1177: if l_act_budgets_rec.request_currency is not null then
1178: l_act_budgets_rec.request_amount := ozf_utility_pvt.currround(l_act_budgets_rec.request_amount, l_act_budgets_rec.request_currency);
1179: end if;
1180:
1181: INSERT INTO ozf_act_budgets
1182: (activity_budget_id, -- standard who columns
1183: last_update_date
1184: , last_updated_by
1185: , creation_date

Line 1341: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

1337: AND l_act_budgets_rec.budget_source_type <> 'PTNR' THEN
1338: --added by feliu on 08/03/2005. only created utilization for UTILIZED.
1339: IF l_act_budgets_rec.transfer_type = 'UTILIZED' THEN
1340: -- For Bug#8867381, introduced p_use_fund_staging_tables for staging table impln of chargeback flow
1341: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
1342: -- and px_ozf_funds_old_rectype for taking the funds old values
1343: -- For TPA Parallel Execution ER Bug#9614703
1344: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
1345:

Line 1355: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl

1351: ,p_act_util_rec => l_act_util_rec
1352: ,x_utilized_amount => x_utilized_amount
1353: ,p_batch_type => p_batch_type
1354: ,p_use_fund_staging_tables => p_use_fund_staging_tables
1355: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl
1356: ,px_ozf_funds_old_rectype => px_ozf_funds_old_rectype
1357: ,px_ozf_funds_new_tbl => px_ozf_funds_new_tbl -- For TPA Parallel Execution ER Bug#9614703
1358: ,x_utilization_id => x_utilization_id --nirprasa - added for Bug 9383565
1359: );

Line 1637: -- Function : Update a row in OZF_ACT_Budgets table

1633: -- Start of Comments
1634: --
1635: -- API name : Update_Act_Budgets
1636: -- Type : Private
1637: -- Function : Update a row in OZF_ACT_Budgets table
1638: -- Note : This overloaded procedure is to be called from
1639: -- Workflow to maintain the context.
1640: ---- 29-JUNE-2004 feliu added.
1641: -- End Of Comments

Line 1753: l_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;

1749: ,x_utilization_id OUT NOCOPY NUMBER ) IS
1750:
1751: l_old_act_budgets_rec act_budgets_rec_type;
1752: l_use_fund_staging_tables VARCHAR2(1) := 'F';
1753: l_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
1754: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
1755: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
1756: l_batch_type VARCHAR2(30);
1757:

Line 1781: ,px_ozf_act_budgets_tbl => l_ozf_act_budgets_tbl

1777: ,p_act_util_rec => p_act_util_rec
1778: ,x_utilized_amount => x_utilized_amount
1779: ,p_batch_type => l_batch_type
1780: ,p_use_fund_staging_tables => l_use_fund_staging_tables
1781: ,px_ozf_act_budgets_tbl => l_ozf_act_budgets_tbl
1782: ,px_ozf_funds_old_rectype => lx_ozf_funds_old_rectype
1783: ,px_ozf_funds_new_tbl => lx_ozf_funds_new_tbl -- For TPA Parallel Execution ER - 9614703
1784: ,x_utilization_id => x_utilization_id
1785: );

Line 1794: -- Function : Update a row in OZF_ACT_Budgets table

1790: -- Start of Comments
1791: --
1792: -- API name : Update_Act_Budgets
1793: -- Type : Private
1794: -- Function : Update a row in OZF_ACT_Budgets table
1795: -- Note : This overloaded procedure is to be called from
1796: -- Workflow to maintain the context.
1797: ---- 22-Feb-2001 mpande Modified for Hornet changes.
1798: -- 05/22/2001 mpande Signature changes for fund child approval

Line 1800: -- 27/10/2009 muthsubr Added px_ozf_act_budgets_tbl, p_use_fund_staging_tables

1796: -- Workflow to maintain the context.
1797: ---- 22-Feb-2001 mpande Modified for Hornet changes.
1798: -- 05/22/2001 mpande Signature changes for fund child approval
1799: -- 08/26/2002 feliu added status of "PENDING_VALIDATION"
1800: -- 27/10/2009 muthsubr Added px_ozf_act_budgets_tbl, p_use_fund_staging_tables
1801: -- px_ozf_funds_old_rectype, px_ozf_funds_new_rectype
1802: -- for bug#8867381.
1803: -- 29/11/2010 muthsubr Altered px_ozf_funds_new_rectype to px_ozf_funds_new_tbl
1804: -- for TPA Parallel Execution ER Bug#9614703.

Line 1828: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

1824: ,p_act_util_rec IN act_util_rec_type -- For Bug#8867381 removed ':= NULL'
1825: ,x_utilized_amount OUT NOCOPY NUMBER -- yzhao: 06/21/2004 added to return actual utilized amount
1826: ,p_batch_type IN VARCHAR2
1827: ,p_use_fund_staging_tables IN VARCHAR2
1828: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
1829: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
1830: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
1831: ) IS
1832: l_utilization_id NUMBER; --nirprasa - added for Bug 9383565

Line 1855: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl

1851: ,p_act_util_rec => p_act_util_rec
1852: ,x_utilized_amount => x_utilized_amount
1853: ,p_batch_type => p_batch_type
1854: ,p_use_fund_staging_tables => p_use_fund_staging_tables
1855: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl
1856: ,px_ozf_funds_old_rectype => px_ozf_funds_old_rectype
1857: ,px_ozf_funds_new_tbl => px_ozf_funds_new_tbl -- For TPA Parallel Execution ER - 9614703
1858: ,x_utilization_id => l_utilization_id
1859: );

Line 1883: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

1879: ,p_act_util_rec IN act_util_rec_type -- For Bug#8867381 removed ':= NULL'
1880: ,x_utilized_amount OUT NOCOPY NUMBER -- yzhao: 06/21/2004 added to return actual utilized amount
1881: ,p_batch_type IN VARCHAR2
1882: ,p_use_fund_staging_tables IN VARCHAR2
1883: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
1884: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
1885: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
1886: ,x_utilization_id OUT NOCOPY NUMBER --nirprasa - added for Bug 9383565
1887: ) IS

Line 1925: FROM ozf_act_budgets

1921: l_operation VARCHAR2(6);
1922:
1923: CURSOR c_current_status IS
1924: SELECT status_code, approved_amount, parent_src_apprvd_amt
1925: FROM ozf_act_budgets
1926: WHERE activity_budget_id = p_act_budgets_rec.activity_budget_id;
1927:
1928: --
1929: -- the planned_amt will be used in approval submission,

Line 2925: -- plsql tables and pass it on to OZF_RESALE_COMMON_PVT.UPDATE_OZF_ACT_BUDGETS procedure for updating

2921: END IF;
2922:
2923: -- For BUG#8867381(+)
2924: -- l_use_fund_staging_tables flag is set only for chargeback flow and will insert the records into
2925: -- plsql tables and pass it on to OZF_RESALE_COMMON_PVT.UPDATE_OZF_ACT_BUDGETS procedure for updating
2926: -- the main table.
2927:
2928: IF l_use_fund_staging_tables <> 'T' then
2929:

Line 2936: UPDATE ozf_act_budgets

2932: ozf_utility_pvt.debug_message('request_amount :'|| l_act_budgets_rec.request_amount );
2933: END IF;
2934:
2935: -- Perform the database operation
2936: UPDATE ozf_act_budgets
2937: SET last_update_date = SYSDATE
2938: ,last_updated_by = fnd_global.user_id
2939: ,last_update_login = fnd_global.conc_login_id
2940: ,object_version_number = l_act_budgets_rec.object_version_number

Line 3084: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN

3080: l_budget_count := 0;
3081: l_operation := 'INSERT';
3082:
3083: --13-DEC-2010 kdass - TPA Parallel Execution ER - 9614703
3084: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
3085: FOR i IN 1 .. px_ozf_act_budgets_tbl.COUNT
3086: LOOP
3087: IF l_act_budgets_rec.activity_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
3088: AND l_resale_batch_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN

Line 3085: FOR i IN 1 .. px_ozf_act_budgets_tbl.COUNT

3081: l_operation := 'INSERT';
3082:
3083: --13-DEC-2010 kdass - TPA Parallel Execution ER - 9614703
3084: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
3085: FOR i IN 1 .. px_ozf_act_budgets_tbl.COUNT
3086: LOOP
3087: IF l_act_budgets_rec.activity_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
3088: AND l_resale_batch_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN
3089: l_operation := 'UPDATE';

Line 3087: IF l_act_budgets_rec.activity_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID

3083: --13-DEC-2010 kdass - TPA Parallel Execution ER - 9614703
3084: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
3085: FOR i IN 1 .. px_ozf_act_budgets_tbl.COUNT
3086: LOOP
3087: IF l_act_budgets_rec.activity_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
3088: AND l_resale_batch_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN
3089: l_operation := 'UPDATE';
3090: l_budget_count := i;
3091: GOTO START_OPERATION;

Line 3088: AND l_resale_batch_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN

3084: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
3085: FOR i IN 1 .. px_ozf_act_budgets_tbl.COUNT
3086: LOOP
3087: IF l_act_budgets_rec.activity_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
3088: AND l_resale_batch_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN
3089: l_operation := 'UPDATE';
3090: l_budget_count := i;
3091: GOTO START_OPERATION;
3092: END IF;

Line 3099: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;

3095:
3096: <>
3097: IF l_operation = 'UPDATE' THEN
3098:
3099: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;
3100: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3101: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)
3102: + NVL(l_act_budgets_rec.request_amount,0)
3103: - NVL(l_old_act_budgets_rec.request_amount,0);

Line 3100: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;

3096: <>
3097: IF l_operation = 'UPDATE' THEN
3098:
3099: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;
3100: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3101: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)
3102: + NVL(l_act_budgets_rec.request_amount,0)
3103: - NVL(l_old_act_budgets_rec.request_amount,0);
3104: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)

Line 3101: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)

3097: IF l_operation = 'UPDATE' THEN
3098:
3099: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;
3100: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3101: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)
3102: + NVL(l_act_budgets_rec.request_amount,0)
3103: - NVL(l_old_act_budgets_rec.request_amount,0);
3104: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)
3105: + NVL(l_act_budgets_rec.approved_amount,0)

Line 3104: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)

3100: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3101: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)
3102: + NVL(l_act_budgets_rec.request_amount,0)
3103: - NVL(l_old_act_budgets_rec.request_amount,0);
3104: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)
3105: + NVL(l_act_budgets_rec.approved_amount,0)
3106: - NVL(l_old_act_budgets_rec.approved_amount,0);
3107: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT,0)
3108: + NVL(l_act_budgets_rec.approved_original_amount,0)

Line 3107: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT,0)

3103: - NVL(l_old_act_budgets_rec.request_amount,0);
3104: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)
3105: + NVL(l_act_budgets_rec.approved_amount,0)
3106: - NVL(l_old_act_budgets_rec.approved_amount,0);
3107: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT,0)
3108: + NVL(l_act_budgets_rec.approved_original_amount,0)
3109: - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3110: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)
3111: + NVL(l_fc_amount,0)

Line 3110: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)

3106: - NVL(l_old_act_budgets_rec.approved_amount,0);
3107: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT,0)
3108: + NVL(l_act_budgets_rec.approved_original_amount,0)
3109: - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3110: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)
3111: + NVL(l_fc_amount,0)
3112: - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3113: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3114: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT,0)

Line 3113: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;

3109: - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3110: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)
3111: + NVL(l_fc_amount,0)
3112: - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3113: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3114: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT,0)
3115: + NVL(l_src_curr_request_amt,0)
3116: - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3117: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;

Line 3114: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT,0)

3110: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)
3111: + NVL(l_fc_amount,0)
3112: - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3113: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3114: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT,0)
3115: + NVL(l_src_curr_request_amt,0)
3116: - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3117: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
3118: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;

Line 3117: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;

3113: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3114: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT,0)
3115: + NVL(l_src_curr_request_amt,0)
3116: - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3117: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
3118: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;
3119:
3120: ELSIF l_operation = 'INSERT' THEN
3121:

Line 3118: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;

3114: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT,0)
3115: + NVL(l_src_curr_request_amt,0)
3116: - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3117: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
3118: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;
3119:
3120: ELSIF l_operation = 'INSERT' THEN
3121:
3122: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;

Line 3122: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;

3118: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;
3119:
3120: ELSIF l_operation = 'INSERT' THEN
3121:
3122: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
3123: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;
3124: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3125: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(l_act_budgets_rec.request_amount,0) - NVL(l_old_act_budgets_rec.request_amount,0);
3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);

Line 3123: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;

3119:
3120: ELSIF l_operation = 'INSERT' THEN
3121:
3122: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
3123: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;
3124: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3125: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(l_act_budgets_rec.request_amount,0) - NVL(l_old_act_budgets_rec.request_amount,0);
3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);
3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);

Line 3124: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;

3120: ELSIF l_operation = 'INSERT' THEN
3121:
3122: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
3123: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;
3124: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3125: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(l_act_budgets_rec.request_amount,0) - NVL(l_old_act_budgets_rec.request_amount,0);
3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);
3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);

Line 3125: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(l_act_budgets_rec.request_amount,0) - NVL(l_old_act_budgets_rec.request_amount,0);

3121:
3122: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
3123: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;
3124: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3125: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(l_act_budgets_rec.request_amount,0) - NVL(l_old_act_budgets_rec.request_amount,0);
3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);
3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3129: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;

Line 3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);

3122: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
3123: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;
3124: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3125: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(l_act_budgets_rec.request_amount,0) - NVL(l_old_act_budgets_rec.request_amount,0);
3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);
3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3129: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3130: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(l_src_curr_request_amt,0) - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);

Line 3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);

3123: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_resale_batch_id;
3124: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3125: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(l_act_budgets_rec.request_amount,0) - NVL(l_old_act_budgets_rec.request_amount,0);
3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);
3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3129: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3130: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(l_src_curr_request_amt,0) - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3131: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;

Line 3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);

3124: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budgets_rec.activity_budget_id;
3125: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(l_act_budgets_rec.request_amount,0) - NVL(l_old_act_budgets_rec.request_amount,0);
3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);
3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3129: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3130: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(l_src_curr_request_amt,0) - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3131: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
3132: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;

Line 3129: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;

3125: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(l_act_budgets_rec.request_amount,0) - NVL(l_old_act_budgets_rec.request_amount,0);
3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);
3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3129: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3130: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(l_src_curr_request_amt,0) - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3131: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
3132: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;
3133:

Line 3130: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(l_src_curr_request_amt,0) - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);

3126: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(l_act_budgets_rec.approved_amount,0) - NVL(l_old_act_budgets_rec.approved_amount,0);
3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3129: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3130: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(l_src_curr_request_amt,0) - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3131: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
3132: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;
3133:
3134: END IF;

Line 3131: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;

3127: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(l_act_budgets_rec.approved_original_amount,0) - NVL(l_old_act_budgets_rec.approved_original_amount,0);
3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3129: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3130: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(l_src_curr_request_amt,0) - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3131: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
3132: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;
3133:
3134: END IF;
3135:

Line 3132: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;

3128: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(l_fc_amount,0) - NVL(l_old_act_budgets_rec.approved_amount_fc,0);
3129: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
3130: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := NVL(l_src_curr_request_amt,0) - NVL(l_old_act_budgets_rec.src_curr_request_amt,0);
3131: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
3132: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_req_id;
3133:
3134: END IF;
3135:
3136:

Line 3235: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.

3231: l_act_util_rec.plan_curr_amount := p_act_util_rec.plan_curr_amount;
3232: l_act_util_rec.plan_curr_amount_remaining := p_act_util_rec.plan_curr_amount_remaining;
3233: l_act_util_rec.plan_currency_code := p_act_util_rec.plan_currency_code;
3234: -- For Bug#8867381, introduced p_use_fund_staging_tables for staging table impln of chargeback flow
3235: -- and px_ozf_act_budgets_tbl for PLSQL table impln of storing budgets value.
3236: -- and px_ozf_funds_old_rectype for taking the funds old values
3237: -- For TPA Parallel Execution ER Bug#9614703
3238: -- and changed px_ozf_funds_new_rectype to px_ozf_funds_new_tbl.
3239:

Line 3250: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl

3246: ,p_act_util_rec => l_act_util_rec
3247: ,x_utilized_amount => x_utilized_amount -- yzhao: 06/21/2004 added to return actual utilized amount
3248: ,p_batch_type => p_batch_type
3249: ,p_use_fund_staging_tables => p_use_fund_staging_tables
3250: ,px_ozf_act_budgets_tbl => px_ozf_act_budgets_tbl
3251: ,px_ozf_funds_old_rectype => px_ozf_funds_old_rectype
3252: ,px_ozf_funds_new_tbl => px_ozf_funds_new_tbl -- For TPA Parallel Execution ER Bug#9614703
3253: ,x_utilization_id => x_utilization_id --nirprasa - added for Bug 9383565
3254: );

Line 3415: FROM ozf_act_budgets

3411: l_status_code VARCHAR2 (30);
3412:
3413: CURSOR c_status (p_act_budget_id IN NUMBER) IS
3414: SELECT status_code
3415: FROM ozf_act_budgets
3416: WHERE activity_budget_id = p_act_budget_id;
3417: BEGIN
3418: -- Standard Start of API savepoint
3419: SAVEPOINT delete_act_budgets_pvt;

Line 3452: DELETE FROM ozf_act_budgets

3448: END IF;
3449:
3450: -- Perform the database operation
3451: -- Delete header data
3452: DELETE FROM ozf_act_budgets
3453: WHERE activity_budget_id = l_act_budget_id
3454: AND object_version_number = p_object_version;
3455:
3456: IF SQL%NOTFOUND THEN

Line 3546: FROM ozf_act_budgets

3542: l_status_code VARCHAR2 (30);
3543:
3544: CURSOR c_act_budget IS
3545: SELECT status_code
3546: FROM ozf_act_budgets
3547: WHERE activity_budget_id = p_act_budget_id
3548: AND object_version_number = p_object_version
3549: FOR UPDATE OF activity_budget_id NOWAIT;
3550: BEGIN

Line 3881: 'ozf_Act_budgets'

3877: -- Validate uniqueness
3878: IF p_validation_mode = jtf_plsql_api.g_create
3879: AND p_act_budgets_rec.activity_budget_id IS NOT NULL THEN
3880: IF ozf_utility_pvt.check_uniqueness (
3881: 'ozf_Act_budgets'
3882: , 'ACTIVITY_BUDGET_ID = '
3883: || p_act_budgets_rec.activity_budget_id
3884: ) = fnd_api.g_false THEN
3885: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 4158: FROM ozf_act_budgets

4154: l_dummy VARCHAR2(3);
4155: l_exc_util_check VARCHAR2(1):= 'F';
4156: CURSOR c_current_amount IS
4157: SELECT approved_amount
4158: FROM ozf_act_budgets
4159: WHERE activity_budget_id = p_act_budgets_rec.activity_budget_id;
4160:
4161: -- Bug Fix 4030115.
4162: -- An offer not autogenerated from a budget should not be allow to make a negative request from a fully accrued budget.

Line 4470: FROM ozf_act_budgets

4466: ,x_act_budgets_rec OUT NOCOPY act_budgets_rec_type
4467: ) IS
4468: CURSOR c_budget IS
4469: SELECT *
4470: FROM ozf_act_budgets
4471: WHERE activity_budget_id = p_act_budgets_rec.activity_budget_id;
4472:
4473: l_act_budgets_rec c_budget%ROWTYPE;
4474: BEGIN