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_UTILIZED_PVT dependencies on OZF_ACT_BUDGETS

Line 63: -- Created Subroutines to create committed amount record in ozf_act_budgets

59: -- Requirements for 11.5.5- hornet
60: -- 02/08/2001 Mumu Pande Updated for 11.5.5 requirements
61: -- 02/23/2001 Mumu Pande Updated for Hornet requirements
62: -- 02/09/2001 Mumu Pande Added validation routine for adjsutment_type_id
63: -- Created Subroutines to create committed amount record in ozf_act_budgets
64: -- 08/28/2001 Mumu Pande Bug#1950117
65: -- 09/05/2001 Mumu Pande Bug#1970359
66: -- 02/28/2002 Feliu Added create_act_utilization procedure and remove
67: -- recal_comm_flag. Modify create_utilzation.

Line 97: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;

93: ,p_create_gl_entry IN VARCHAR2 := fnd_api.g_false
94: ,p_utilization_rec IN utilization_rec_type
95: ,x_utilization_id OUT NOCOPY NUMBER
96: ) IS
97: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
98: l_use_fund_staging_tables VARCHAR2(1):= 'F';
99: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
100: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
101: l_batch_type VARCHAR2(30);

Line 116: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl

112: ,p_utilization_rec => p_utilization_rec
113: ,x_utilization_id => x_utilization_id
114: ,p_batch_type => l_batch_type
115: ,p_use_fund_staging_tables => l_use_fund_staging_tables
116: ,px_ozf_act_budgets_tbl => lx_ozf_act_budgets_tbl
117: ,px_ozf_funds_old_rectype => lx_ozf_funds_old_rectype
118: ,px_ozf_funds_new_tbl => lx_ozf_funds_new_tbl -- For TPA Parallel Execution ER- 9614703
119: );
120: END;

Line 134: -- Created Subroutines to create committed amount record in ozf_act_budgets

130: -- Requirements for 11.5.5- hornet
131: -- 02/08/2001 Mumu Pande Updated for 11.5.5 requirements
132: -- 02/23/2001 Mumu Pande Updated for Hornet requirements
133: -- 02/09/2001 Mumu Pande Added validation routine for adjsutment_type_id
134: -- Created Subroutines to create committed amount record in ozf_act_budgets
135: -- 08/28/2001 Mumu Pande Bug#1950117
136: -- 09/05/2001 Mumu Pande Bug#1970359
137: -- 02/28/2002 Feliu Added create_act_utilization procedure and remove
138: -- recal_comm_flag. Modify create_utilzation.

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

146: -- customer accrual without liability: no gl posting, do not update earned amount
147: -- use constant ozf_accrual_engine.G_GL_FLAG_* for gl_posted_flag
148: -- 14-NOV-2008 ateotia Bug # 7129397 fixed.
149: -- Added a condition for Chargeback Batch using Fully Accrued, Accrue To - Sales budget.
150: -- 27/10/2009 muthsubr Added px_ozf_act_budgets_tbl, p_use_fund_staging_tables
151: -- px_ozf_funds_old_rectype, px_ozf_funds_new_rectype
152: -- for bug#8867381.
153: -- 29/11/2010 muthsubr Altered px_ozf_funds_new_rectype to px_ozf_funds_new_tbl for TPA Parallel Execution ER Bug#9614703.
154: ---------------------------------------------------------------------

Line 169: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

165: ,p_utilization_rec IN utilization_rec_type
166: ,x_utilization_id OUT NOCOPY NUMBER
167: ,p_batch_type IN VARCHAR2
168: ,p_use_fund_staging_tables IN VARCHAR2
169: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
170: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
171: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
172: ) IS
173: l_api_version CONSTANT NUMBER := 1.0;

Line 280: update ozf_act_budgets REQUEST between fully accrual budget and its offer when accrual happens

276: FROM ozf_claim_types_all_b
277: WHERE claim_type_id = p_adj_type_id;
278:
279: /* 10/20/2003 yzhao Fix TEVA bug - customer fully accrual budget committed amount is always 0 when third party accrual happens
280: update ozf_act_budgets REQUEST between fully accrual budget and its offer when accrual happens
281: */
282: CURSOR c_accrual_budget_reqeust(p_fund_id IN NUMBER, p_plan_id IN NUMBER) IS
283: SELECT activity_budget_id
284: , object_version_number

Line 285: FROM ozf_act_budgets

281: */
282: CURSOR c_accrual_budget_reqeust(p_fund_id IN NUMBER, p_plan_id IN NUMBER) IS
283: SELECT activity_budget_id
284: , object_version_number
285: FROM ozf_act_budgets
286: WHERE arc_act_budget_used_by = 'OFFR'
287: AND act_budget_used_by_id = p_plan_id
288: AND budget_source_type = 'FUND'
289: AND budget_source_id = p_fund_id

Line 565: -- we go and create a debit record for that amount in Ozf_ACT_budgets

561: END IF;
562:
563:
564: -- Here we should check for adjustment_type , if the adjustment_type is DECREASE_COMMITTMENT or DECREASE_EARNED_COMMITTED
565: -- we go and create a debit record for that amount in Ozf_ACT_budgets
566: /* IF NVL (l_utilization_rec.adjustment_type, 'STANDARD') <> ('DECREASE_COMMITTED')
567: -- this is a temporary fix have to fix it from the UI
568: OR l_utilization_rec.utilization_type = 'TRANSFER'
569: --OR NVL (l_utilization_rec.recal_comm_flag, 'N') = 'Y'

Line 1157: -- 10/14/2003 update ozf_act_budgets REQUEST between fully accrual budget and its offer when accrual happens

1153: l_objfundsum_rec.univ_curr_recal_committed_amt := NVL(l_objfundsum_rec.univ_curr_recal_committed_amt, 0)
1154: + NVL(l_univ_curr_amount, 0);
1155: -- R12: yzhao END ozf_object_fund_summary update
1156:
1157: -- 10/14/2003 update ozf_act_budgets REQUEST between fully accrual budget and its offer when accrual happens
1158: OPEN c_accrual_budget_reqeust(l_utilization_rec.fund_id, l_plan_id);
1159: FETCH c_accrual_budget_reqeust INTO l_act_budget_id, l_act_budget_objver;
1160: IF (c_accrual_budget_reqeust%NOTFOUND) THEN
1161: CLOSE c_accrual_budget_reqeust;

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

1168: CLOSE c_accrual_budget_reqeust;
1169:
1170: -- For BUG#8867381(+)
1171: -- l_use_fund_staging_tables flag is set only for chargeback flow and will insert the records into
1172: -- plsql tables and pass it on to OZF_RESALE_COMMON_PVT.UPDATE_OZF_ACT_BUDGETS procedure for updating
1173: -- the main table.
1174: IF l_use_fund_staging_tables <> 'T' then
1175:
1176: IF G_DEBUG THEN

Line 1180: UPDATE ozf_act_budgets

1176: IF G_DEBUG THEN
1177: ozf_utility_pvt.debug_message('Going to update mode as l_use_fund_staging_tables is :'||l_use_fund_staging_tables );
1178: END IF;
1179:
1180: UPDATE ozf_act_budgets
1181: SET request_amount = NVL(request_amount, 0) + l_plan_curr_amount
1182: , src_curr_request_amt = NVL(src_curr_request_amt, 0) + l_utilization_rec.amount
1183: , approved_amount = NVL(approved_amount, 0) + l_plan_curr_amount
1184: , approved_original_amount = NVL(approved_original_amount, 0) + l_utilization_rec.amount

Line 1201: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN

1197: l_budget_count := 0;
1198: l_operation := 'INSERT';
1199:
1200: --13-DEC-2010 kdass - TPA Parallel Execution ER - 9614703
1201: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
1202: FOR i IN 1 .. px_ozf_act_budgets_tbl.COUNT
1203: LOOP
1204: IF l_act_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
1205: AND l_utilization_rec.reference_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN

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

1198: l_operation := 'INSERT';
1199:
1200: --13-DEC-2010 kdass - TPA Parallel Execution ER - 9614703
1201: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
1202: FOR i IN 1 .. px_ozf_act_budgets_tbl.COUNT
1203: LOOP
1204: IF l_act_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
1205: AND l_utilization_rec.reference_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN
1206: l_operation := 'UPDATE';

Line 1204: IF l_act_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID

1200: --13-DEC-2010 kdass - TPA Parallel Execution ER - 9614703
1201: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
1202: FOR i IN 1 .. px_ozf_act_budgets_tbl.COUNT
1203: LOOP
1204: IF l_act_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
1205: AND l_utilization_rec.reference_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN
1206: l_operation := 'UPDATE';
1207: l_budget_count := i;
1208: GOTO START_OPERATION;

Line 1205: AND l_utilization_rec.reference_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN

1201: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
1202: FOR i IN 1 .. px_ozf_act_budgets_tbl.COUNT
1203: LOOP
1204: IF l_act_budget_id = px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID
1205: AND l_utilization_rec.reference_id = px_ozf_act_budgets_tbl(i).RESALE_BATCH_ID THEN
1206: l_operation := 'UPDATE';
1207: l_budget_count := i;
1208: GOTO START_OPERATION;
1209: END IF;

Line 1216: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;

1212:
1213: <>
1214: IF l_operation = 'UPDATE' THEN
1215:
1216: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1217: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1218: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)
1219: + NVL(l_plan_curr_amount,0);
1220: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)

Line 1217: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;

1213: <>
1214: IF l_operation = 'UPDATE' THEN
1215:
1216: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1217: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1218: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)
1219: + NVL(l_plan_curr_amount,0);
1220: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)
1221: + NVL(l_plan_curr_amount,0);

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

1214: IF l_operation = 'UPDATE' THEN
1215:
1216: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1217: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1218: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)
1219: + NVL(l_plan_curr_amount,0);
1220: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)
1221: + NVL(l_plan_curr_amount,0);
1222: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT,0)

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

1216: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1217: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1218: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)
1219: + NVL(l_plan_curr_amount,0);
1220: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)
1221: + NVL(l_plan_curr_amount,0);
1222: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT,0)
1223: + NVL(l_utilization_rec.amount,0);
1224: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)

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

1218: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT,0)
1219: + NVL(l_plan_curr_amount,0);
1220: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)
1221: + NVL(l_plan_curr_amount,0);
1222: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT,0)
1223: + NVL(l_utilization_rec.amount,0);
1224: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)
1225: + NVL(l_utilization_rec.acctd_amount,0);
1226: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;

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

1220: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT,0)
1221: + NVL(l_plan_curr_amount,0);
1222: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT,0)
1223: + NVL(l_utilization_rec.amount,0);
1224: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)
1225: + NVL(l_utilization_rec.acctd_amount,0);
1226: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1227: 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)
1228: + NVL(l_utilization_rec.amount,0);

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

1222: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT,0)
1223: + NVL(l_utilization_rec.amount,0);
1224: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)
1225: + NVL(l_utilization_rec.acctd_amount,0);
1226: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1227: 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)
1228: + NVL(l_utilization_rec.amount,0);
1229: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;
1230: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;

Line 1227: 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)

1223: + NVL(l_utilization_rec.amount,0);
1224: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := NVL(px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC,0)
1225: + NVL(l_utilization_rec.acctd_amount,0);
1226: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1227: 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)
1228: + NVL(l_utilization_rec.amount,0);
1229: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;
1230: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
1231:

Line 1229: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;

1225: + NVL(l_utilization_rec.acctd_amount,0);
1226: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1227: 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)
1228: + NVL(l_utilization_rec.amount,0);
1229: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;
1230: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
1231:
1232: ELSIF l_operation = 'INSERT' THEN
1233:

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

1226: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1227: 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)
1228: + NVL(l_utilization_rec.amount,0);
1229: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;
1230: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
1231:
1232: ELSIF l_operation = 'INSERT' THEN
1233:
1234: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;

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

1230: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
1231:
1232: ELSIF l_operation = 'INSERT' THEN
1233:
1234: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
1235: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1236: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1237: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := l_plan_curr_amount;
1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;

Line 1235: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;

1231:
1232: ELSIF l_operation = 'INSERT' THEN
1233:
1234: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
1235: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1236: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1237: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := l_plan_curr_amount;
1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;
1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;

Line 1236: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;

1232: ELSIF l_operation = 'INSERT' THEN
1233:
1234: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
1235: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1236: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1237: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := l_plan_curr_amount;
1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;
1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;
1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;

Line 1237: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := l_plan_curr_amount;

1233:
1234: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
1235: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1236: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1237: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := l_plan_curr_amount;
1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;
1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;
1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;
1241: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;

Line 1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;

1234: l_budget_count := px_ozf_act_budgets_tbl.COUNT + 1;
1235: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1236: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1237: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := l_plan_curr_amount;
1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;
1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;
1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;
1241: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1242: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := l_utilization_rec.amount;

Line 1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;

1235: px_ozf_act_budgets_tbl(l_budget_count).RESALE_BATCH_ID := l_utilization_rec.reference_id;
1236: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1237: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := l_plan_curr_amount;
1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;
1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;
1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;
1241: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1242: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := l_utilization_rec.amount;
1243: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;

Line 1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;

1236: px_ozf_act_budgets_tbl(l_budget_count).ACTIVITY_BUDGET_ID := l_act_budget_id;
1237: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := l_plan_curr_amount;
1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;
1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;
1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;
1241: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1242: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := l_utilization_rec.amount;
1243: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;
1244: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;

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

1237: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_AMOUNT := l_plan_curr_amount;
1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;
1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;
1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;
1241: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1242: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := l_utilization_rec.amount;
1243: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;
1244: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
1245: END IF;

Line 1242: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := l_utilization_rec.amount;

1238: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT := l_plan_curr_amount;
1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;
1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;
1241: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1242: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := l_utilization_rec.amount;
1243: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;
1244: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
1245: END IF;
1246:

Line 1243: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;

1239: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_ORIGINAL_AMOUNT := l_utilization_rec.amount;
1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;
1241: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1242: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := l_utilization_rec.amount;
1243: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;
1244: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
1245: END IF;
1246:
1247: END IF;

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

1240: px_ozf_act_budgets_tbl(l_budget_count).APPROVED_AMOUNT_FC := l_utilization_rec.acctd_amount;
1241: px_ozf_act_budgets_tbl(l_budget_count).PARENT_SRC_APPRVD_AMT := 0;
1242: px_ozf_act_budgets_tbl(l_budget_count).SRC_CURR_REQUEST_AMT := l_utilization_rec.amount;
1243: px_ozf_act_budgets_tbl(l_budget_count).REQUEST_ID := l_request_id;
1244: px_ozf_act_budgets_tbl(l_budget_count).BATCH_TYPE := p_batch_type;
1245: END IF;
1246:
1247: END IF;
1248: -- For BUG#8867381(-)

Line 4328: FROM ozf_act_budgets

4324: ,p_used_by_type IN VARCHAR2
4325: ,p_parent_src_id IN NUMBER
4326: ) IS
4327: SELECT activity_budget_id, object_version_number,request_amount,parent_src_apprvd_amt
4328: FROM ozf_act_budgets
4329: WHERE act_budget_used_by_id = p_used_by_id
4330: AND arc_act_budget_used_by = p_used_by_type
4331: AND parent_source_id = p_parent_src_id
4332: AND transfer_type = 'UTILIZED';