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 143: FROM ozf_funds_utilized_all_b

139:
140: -- Cursor to validate the uniqueness of the utilization_id
141: CURSOR c_utilization_count (cv_utilization_id IN NUMBER) IS
142: SELECT 'X'
143: FROM ozf_funds_utilized_all_b
144: WHERE utilization_id = cv_utilization_id;
145:
146: -- Cursor to get original utilization gl_posted_flag
147: CURSOR c_get_orig_gl_flag (p_utilization_id IN NUMBER) IS

Line 149: FROM ozf_funds_utilized_all_b

145:
146: -- Cursor to get original utilization gl_posted_flag
147: CURSOR c_get_orig_gl_flag (p_utilization_id IN NUMBER) IS
148: SELECT gl_posted_flag
149: FROM ozf_funds_utilized_all_b
150: WHERE utilization_id = p_utilization_id;
151:
152: -- Cursor to get fund earned amount and object_version_number
153: CURSOR c_fund_b (p_fund_id IN NUMBER) IS

Line 192: FROM ozf_funds_utilized_all_b

188: /* yzhao: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table
189: CURSOR c_budget_request_utilrec(p_fund_id IN NUMBER, p_plan_id IN NUMBER, p_actbudget_id IN NUMBER) IS
190: SELECT utilization_id
191: , object_version_number
192: FROM ozf_funds_utilized_all_b
193: WHERE utilization_type = 'REQUEST'
194: AND fund_id = p_fund_id
195: AND plan_type = 'FUND'
196: AND plan_id = p_fund_id

Line 368: FROM ozf_funds_utilized_all_b

364:
365:
366: CURSOR c_plan_curr_amount (p_utilization_id IN NUMBER) IS
367: SELECT plan_curr_amount,plan_curr_amount_remaining
368: FROM ozf_funds_utilized_all_b
369: WHERE utilization_id = p_utilization_id;
370:
371: CURSOR c_plan_curr_amount_remaining (p_utilization_id IN NUMBER) IS
372: SELECT plan_curr_amount_remaining

Line 373: FROM ozf_funds_utilized_all_b

369: WHERE utilization_id = p_utilization_id;
370:
371: CURSOR c_plan_curr_amount_remaining (p_utilization_id IN NUMBER) IS
372: SELECT plan_curr_amount_remaining
373: FROM ozf_funds_utilized_all_b
374: WHERE utilization_id = p_utilization_id;
375:
376: l_org_id NUMBER;
377: l_qlf_type VARCHAR2 (30);

Line 989: -- populate request amount in ozf_funds_utilized_all_b record

985: RAISE fnd_api.g_exc_error;
986: END IF;
987: CLOSE c_budget_request_utilrec;
988:
989: -- populate request amount in ozf_funds_utilized_all_b record
990: UPDATE ozf_funds_utilized_all_b
991: SET amount = NVL(amount, 0) + NVL(l_utilization_rec.amount, 0)
992: , plan_curr_amount = NVL(plan_curr_amount, 0) + NVL(l_plan_curr_amount, 0)
993: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_univ_curr_amount, 0)

Line 990: UPDATE ozf_funds_utilized_all_b

986: END IF;
987: CLOSE c_budget_request_utilrec;
988:
989: -- populate request amount in ozf_funds_utilized_all_b record
990: UPDATE ozf_funds_utilized_all_b
991: SET amount = NVL(amount, 0) + NVL(l_utilization_rec.amount, 0)
992: , plan_curr_amount = NVL(plan_curr_amount, 0) + NVL(l_plan_curr_amount, 0)
993: , univ_curr_amount = NVL(univ_curr_amount, 0) + NVL(l_univ_curr_amount, 0)
994: , acctd_amount = NVL(acctd_amount, 0) + NVL(l_utilization_rec.acctd_amount, 0)

Line 1359: INSERT INTO ozf_funds_utilized_all_b

1355: l_utilization_rec.univ_curr_amount := 0;
1356: END IF;
1357: */
1358:
1359: INSERT INTO ozf_funds_utilized_all_b
1360: (utilization_id
1361: ,last_update_date
1362: ,last_updated_by
1363: ,last_update_login

Line 1684: UPDATE ozf_funds_utilized_all_b

1680: END IF;
1681: END IF;
1682: END IF; -- END IF
1683:
1684: UPDATE ozf_funds_utilized_all_b
1685: SET last_update_date = SYSDATE
1686: , last_updated_by = NVL (fnd_global.user_id, -1)
1687: , last_update_login = NVL (fnd_global.conc_login_id, -1)
1688: , gl_posted_flag = l_gl_posted_flag

Line 1882: DELETE FROM ozf_funds_utilized_all_b

1878: ozf_utility_pvt.debug_message ( l_full_name
1879: || ': delete');
1880: END IF;
1881:
1882: DELETE FROM ozf_funds_utilized_all_b
1883: WHERE utilization_id = p_utilization_id
1884: AND object_version_number = p_object_version;
1885:
1886: IF (SQL%NOTFOUND) THEN

Line 1982: FROM ozf_funds_utilized_all_b

1978: l_utilization_id NUMBER;
1979:
1980: CURSOR c_utilization_b IS
1981: SELECT utilization_id
1982: FROM ozf_funds_utilized_all_b
1983: WHERE utilization_id = p_utilization_id
1984: AND object_version_number = p_object_version
1985: FOR UPDATE OF utilization_id NOWAIT;
1986:

Line 2133: FROM ozf_funds_utilized_all_b

2129: WHERE fund_id = p_fund_id;
2130:
2131: CURSOR c_old_util_amt (p_util_id IN NUMBER) IS
2132: SELECT amount
2133: FROM ozf_funds_utilized_all_b
2134: WHERE utilization_id = p_util_id;
2135: BEGIN
2136: -------------------- initialize -------------------------
2137: SAVEPOINT update_utilization;

Line 2285: UPDATE ozf_funds_utilized_all_b

2281: END IF;
2282: END IF;
2283: END IF;
2284:
2285: UPDATE ozf_funds_utilized_all_b
2286: SET last_update_date = SYSDATE
2287: ,last_updated_by = NVL (fnd_global.user_id, -1)
2288: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2289: ,created_from = l_utilization_rec.created_from

Line 2702: 'ozf_funds_UTILIZED_all_b'

2698: -- check if this utilization_id is unique.
2699: IF p_validation_mode = jtf_plsql_api.g_create
2700: AND p_utilization_rec.utilization_id IS NOT NULL THEN
2701: IF ozf_utility_pvt.check_uniqueness (
2702: 'ozf_funds_UTILIZED_all_b'
2703: , 'utilization_id = '
2704: || p_utilization_rec.utilization_id
2705: ) = fnd_api.g_false THEN
2706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 2955: FROM ozf_funds_utilized_all_b a1

2951: FROM (SELECT parent_source
2952: ,SUM (amount) total_amount
2953: FROM (SELECT a1.fund_id parent_source
2954: ,NVL (SUM (a1.amount), 0) amount
2955: FROM ozf_funds_utilized_all_b a1
2956: WHERE a1.component_id = p_object_id
2957: AND a1.component_type = p_object_type
2958: AND a1.utilization_type IN ('TRANSFER', 'REQUEST')
2959: GROUP BY a1.fund_id

Line 2963: FROM ozf_funds_utilized_all_b a2

2959: GROUP BY a1.fund_id
2960: UNION
2961: SELECT a2.fund_id parent_source
2962: ,-NVL (SUM (a2.amount), 0) amount
2963: FROM ozf_funds_utilized_all_b a2
2964: WHERE a2.plan_id = p_object_id
2965: AND a2.plan_type = p_object_type
2966: AND a2.utilization_type NOT IN ('TRANSFER', 'REQUEST')
2967: GROUP BY a2.fund_id)

Line 3068: FROM ozf_funds_utilized_all_b

3064: l_amount NUMBER;
3065:
3066: CURSOR c_budget_earn_rec (p_act_id IN NUMBER, p_act_type IN VARCHAR2, p_fund_id IN NUMBER) IS
3067: SELECT SUM (amount)
3068: FROM ozf_funds_utilized_all_b
3069: WHERE fund_id = p_fund_id
3070: AND plan_type = p_act_type
3071: AND plan_id = p_act_id
3072: -- AND utilization_type NOT IN ('REQUEST', 'TRANSFER') R12 no REQUEST/TRANSFER in util table

Line 3078: FROM ozf_funds_utilized_all_b

3074:
3075: /*
3076: CURSOR c_budget_off_earn_rec (p_offer_id IN NUMBER) IS
3077: SELECT SUM (amount)
3078: FROM ozf_funds_utilized_all_b
3079: WHERE fund_id = p_fund_id
3080: AND component_type = 'OFFR'
3081: AND component_id = p_offer_id
3082: AND utilization_type NOT IN ('REQUEST', 'TRANSFER');