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_FUNDS_UTILIZED_ALL_B

Line 226: FROM ozf_funds_utilized_all_b

222:
223: -- Cursor to validate the uniqueness of the utilization_id
224: CURSOR c_utilization_count (cv_utilization_id IN NUMBER) IS
225: SELECT 'X'
226: FROM ozf_funds_utilized_all_b
227: WHERE utilization_id = cv_utilization_id;
228:
229: -- Cursor to get original utilization gl_posted_flag
230: CURSOR c_get_orig_gl_flag (p_utilization_id IN NUMBER) IS

Line 232: FROM ozf_funds_utilized_all_b

228:
229: -- Cursor to get original utilization gl_posted_flag
230: CURSOR c_get_orig_gl_flag (p_utilization_id IN NUMBER) IS
231: SELECT gl_posted_flag
232: FROM ozf_funds_utilized_all_b
233: WHERE utilization_id = p_utilization_id;
234:
235: -- Cursor to get fund earned amount and object_version_number
236: CURSOR c_fund_b (p_fund_id IN NUMBER) IS

Line 297: FROM ozf_funds_utilized_all_b

293: /* yzhao: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table
294: CURSOR c_budget_request_utilrec(p_fund_id IN NUMBER, p_plan_id IN NUMBER, p_actbudget_id IN NUMBER) IS
295: SELECT utilization_id
296: , object_version_number
297: FROM ozf_funds_utilized_all_b
298: WHERE utilization_type = 'REQUEST'
299: AND fund_id = p_fund_id
300: AND plan_type = 'FUND'
301: AND plan_id = p_fund_id

Line 474: FROM ozf_funds_utilized_all_b

470: WHERE site_use_id = p_site_use_id;
471:
472: CURSOR c_plan_curr_amount (p_utilization_id IN NUMBER) IS
473: SELECT plan_curr_amount,plan_curr_amount_remaining
474: FROM ozf_funds_utilized_all_b
475: WHERE utilization_id = p_utilization_id;
476:
477: CURSOR c_plan_curr_amount_remaining (p_utilization_id IN NUMBER) IS
478: SELECT plan_curr_amount_remaining

Line 479: FROM ozf_funds_utilized_all_b

475: WHERE utilization_id = p_utilization_id;
476:
477: CURSOR c_plan_curr_amount_remaining (p_utilization_id IN NUMBER) IS
478: SELECT plan_curr_amount_remaining
479: FROM ozf_funds_utilized_all_b
480: WHERE utilization_id = p_utilization_id;
481:
482: --Fix for 11793070
483: CURSOR c_get_year_id(p_gl_date IN DATE) IS

Line 1264: -- populate request amount in ozf_funds_utilized_all_b record

1260: RAISE fnd_api.g_exc_error;
1261: END IF;
1262: CLOSE c_budget_request_utilrec;
1263:
1264: -- populate request amount in ozf_funds_utilized_all_b record
1265: UPDATE ozf_funds_utilized_all_b
1266: SET amount = NVL(amount, 0) + NVL(l_utilization_rec.amount, 0)
1267: , plan_curr_amount = NVL(plan_curr_amount, 0) + NVL(l_plan_curr_amount, 0)
1268: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_univ_curr_amount, 0)

Line 1265: UPDATE ozf_funds_utilized_all_b

1261: END IF;
1262: CLOSE c_budget_request_utilrec;
1263:
1264: -- populate request amount in ozf_funds_utilized_all_b record
1265: UPDATE ozf_funds_utilized_all_b
1266: SET amount = NVL(amount, 0) + NVL(l_utilization_rec.amount, 0)
1267: , plan_curr_amount = NVL(plan_curr_amount, 0) + NVL(l_plan_curr_amount, 0)
1268: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_univ_curr_amount, 0)
1269: , acctd_amount = NVL(acctd_amount, 0) + NVL(l_utilization_rec.acctd_amount, 0)

Line 1739: INSERT INTO ozf_funds_utilized_all_b

1735: OPEN c_get_year_id(l_utilization_rec.gl_date);
1736: FETCH c_get_year_id INTO l_utilization_rec.year_id;
1737: CLOSE c_get_year_id;
1738:
1739: INSERT INTO ozf_funds_utilized_all_b
1740: (utilization_id
1741: ,last_update_date
1742: ,last_updated_by
1743: ,last_update_login

Line 2106: UPDATE ozf_funds_utilized_all_b

2102: END IF;
2103: END IF;
2104: END IF; -- END IF
2105:
2106: UPDATE ozf_funds_utilized_all_b
2107: SET last_update_date = SYSDATE
2108: , last_updated_by = NVL (fnd_global.user_id, -1)
2109: , last_update_login = NVL (fnd_global.conc_login_id, -1)
2110: , request_id = l_request_id

Line 2334: DELETE FROM ozf_funds_utilized_all_b

2330: ozf_utility_pvt.debug_message ( l_full_name
2331: || ': delete');
2332: END IF;
2333:
2334: DELETE FROM ozf_funds_utilized_all_b
2335: WHERE utilization_id = p_utilization_id
2336: AND object_version_number = p_object_version;
2337:
2338: IF (SQL%NOTFOUND) THEN

Line 2434: FROM ozf_funds_utilized_all_b

2430: l_utilization_id NUMBER;
2431:
2432: CURSOR c_utilization_b IS
2433: SELECT utilization_id
2434: FROM ozf_funds_utilized_all_b
2435: WHERE utilization_id = p_utilization_id
2436: AND object_version_number = p_object_version
2437: FOR UPDATE OF utilization_id NOWAIT;
2438:

Line 2587: FROM ozf_funds_utilized_all_b

2583: WHERE fund_id = p_fund_id;
2584:
2585: CURSOR c_old_util_amt (p_util_id IN NUMBER) IS
2586: SELECT amount
2587: FROM ozf_funds_utilized_all_b
2588: WHERE utilization_id = p_util_id;
2589: BEGIN
2590: -------------------- initialize -------------------------
2591: SAVEPOINT update_utilization;

Line 2745: UPDATE ozf_funds_utilized_all_b

2741: IF NVL(l_request_id, -1) = -1 THEN
2742: l_request_id := OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID;
2743: END IF;
2744:
2745: UPDATE ozf_funds_utilized_all_b
2746: SET last_update_date = SYSDATE
2747: ,last_updated_by = NVL (fnd_global.user_id, -1)
2748: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2749: ,created_from = l_utilization_rec.created_from

Line 3164: 'ozf_funds_UTILIZED_all_b'

3160: -- check if this utilization_id is unique.
3161: IF p_validation_mode = jtf_plsql_api.g_create
3162: AND p_utilization_rec.utilization_id IS NOT NULL THEN
3163: IF ozf_utility_pvt.check_uniqueness (
3164: 'ozf_funds_UTILIZED_all_b'
3165: , 'utilization_id = '
3166: || p_utilization_rec.utilization_id
3167: ) = fnd_api.g_false THEN
3168: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 3417: FROM ozf_funds_utilized_all_b a1

3413: FROM (SELECT parent_source
3414: ,SUM (amount) total_amount
3415: FROM (SELECT a1.fund_id parent_source
3416: ,NVL (SUM (a1.amount), 0) amount
3417: FROM ozf_funds_utilized_all_b a1
3418: WHERE a1.component_id = p_object_id
3419: AND a1.component_type = p_object_type
3420: AND a1.utilization_type IN ('TRANSFER', 'REQUEST')
3421: GROUP BY a1.fund_id

Line 3425: FROM ozf_funds_utilized_all_b a2

3421: GROUP BY a1.fund_id
3422: UNION
3423: SELECT a2.fund_id parent_source
3424: ,-NVL (SUM (a2.amount), 0) amount
3425: FROM ozf_funds_utilized_all_b a2
3426: WHERE a2.plan_id = p_object_id
3427: AND a2.plan_type = p_object_type
3428: AND a2.utilization_type NOT IN ('TRANSFER', 'REQUEST')
3429: GROUP BY a2.fund_id)

Line 3530: FROM ozf_funds_utilized_all_b

3526: l_amount NUMBER;
3527:
3528: CURSOR c_budget_earn_rec (p_act_id IN NUMBER, p_act_type IN VARCHAR2, p_fund_id IN NUMBER) IS
3529: SELECT SUM (amount)
3530: FROM ozf_funds_utilized_all_b
3531: WHERE fund_id = p_fund_id
3532: AND plan_type = p_act_type
3533: AND plan_id = p_act_id
3534: -- AND utilization_type NOT IN ('REQUEST', 'TRANSFER') R12 no REQUEST/TRANSFER in util table

Line 3540: FROM ozf_funds_utilized_all_b

3536:
3537: /*
3538: CURSOR c_budget_off_earn_rec (p_offer_id IN NUMBER) IS
3539: SELECT SUM (amount)
3540: FROM ozf_funds_utilized_all_b
3541: WHERE fund_id = p_fund_id
3542: AND component_type = 'OFFR'
3543: AND component_id = p_offer_id
3544: AND utilization_type NOT IN ('REQUEST', 'TRANSFER');