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_FUNDS_PVT dependencies on OZF_FUNDS_ALL_B

Line 216: FROM ozf_funds_all_b

212: CURSOR c_child_count(
213: p_fund_id IN NUMBER)
214: IS
215: SELECT COUNT(fund_id)
216: FROM ozf_funds_all_b
217: WHERE parent_fund_id = p_fund_id;
218:
219: CURSOR c_parent_number(
220: p_fund_id IN NUMBER)

Line 223: FROM ozf_funds_all_b

219: CURSOR c_parent_number(
220: p_fund_id IN NUMBER)
221: IS
222: SELECT fund_number
223: FROM ozf_funds_all_b
224: WHERE fund_id = p_fund_id;
225: BEGIN
226: x_return_status := fnd_api.g_ret_sts_success;
227: OPEN c_child_count(p_parent_fund_id);

Line 246: WHILE ozf_utility_pvt.check_uniqueness('ozf_funds_all_b'

242:
243: x_code := SUBSTRB(l_par_number || l_count, 1, 30);
244:
245: --asylvia Fixed bug 5073532
246: WHILE ozf_utility_pvt.check_uniqueness('ozf_funds_all_b'
247: ,'fund_number = ''' || x_code || '''') =
248: fnd_api.g_false LOOP
249: l_count := l_count + 1 ;
250: x_code :=SUBSTRB(l_par_number || l_count, 1, 30);

Line 267: SELECT fund_type FROM ozf_funds_all_b

263:
264: PROCEDURE raise_business_event(p_object_id IN NUMBER,p_event_type IN VARCHAR2)
265: IS
266: CURSOR c_fund_type(p_fund_id NUMBER) IS
267: SELECT fund_type FROM ozf_funds_all_b
268: WHERE fund_id = p_fund_id;
269:
270: l_fund_type varchar2(30);
271: l_item_key varchar2(30);

Line 390: FROM ozf_funds_all_b

386: CURSOR c_fund_count(
387: cv_fund_id IN NUMBER)
388: IS
389: SELECT COUNT(fund_id)
390: FROM ozf_funds_all_b
391: WHERE fund_id = cv_fund_id;
392:
393:
394: CURSOR c_prog_fund_number (cl_fund_number IN VARCHAR2)

Line 396: SELECT count(fund_id) from ozf_funds_all_b

392:
393:
394: CURSOR c_prog_fund_number (cl_fund_number IN VARCHAR2)
395: IS
396: SELECT count(fund_id) from ozf_funds_all_b
397: WHERE fund_number = cl_fund_number;
398:
399: BEGIN
400: --------------------- initialize -----------------------

Line 610: INSERT INTO ozf_funds_all_b

606: END IF;
607:
608: END IF;
609:
610: INSERT INTO ozf_funds_all_b
611: (
612: fund_id,
613: last_update_date,
614: last_updated_by,

Line 1213: FROM ozf_funds_all_b

1209: ozf_utility_pvt.debug_message(l_full_name || ': delete');
1210: END IF;
1211:
1212: DELETE
1213: FROM ozf_funds_all_b
1214: WHERE fund_id = p_fund_id
1215: AND object_version_number = p_object_version;
1216:
1217: IF (SQL%NOTFOUND) THEN

Line 1306: FROM ozf_funds_all_b

1302:
1303: CURSOR c_fund_b
1304: IS
1305: SELECT fund_id
1306: FROM ozf_funds_all_b
1307: WHERE fund_id = p_fund_id
1308: AND object_version_number = p_object_version
1309: FOR UPDATE OF fund_id NOWAIT;
1310:

Line 1478: FROM ozf_funds_all_b

1474: IS
1475: SELECT status_code
1476: ,parent_fund_id
1477: ,user_status_id
1478: FROM ozf_funds_all_b
1479: WHERE fund_id = cv_fund_id;
1480:
1481: l_old_status VARCHAR2(30);
1482: l_old_parent_fund_id NUMBER;

Line 1490: FROM ozf_funds_all_b

1486: CURSOR c_par_fund_owner(
1487: par_fund_id IN NUMBER)
1488: IS
1489: SELECT owner
1490: FROM ozf_funds_all_b
1491: WHERE fund_id = par_fund_id;
1492:
1493: /* R12: yzhao bug 4669269 - obsolete ozf_mc_transactions
1494: CURSOR c_mc_record(

Line 1533: FROM ozf_funds_all_b

1529: CURSOR c_old_curr(
1530: cv_fund_id IN NUMBER)
1531: IS
1532: SELECT currency_code_tc , owner
1533: FROM ozf_funds_all_b
1534: WHERE fund_id = cv_fund_id;
1535:
1536: l_old_curr VARCHAR2(30);
1537: l_rate NUMBER;

Line 1547: FROM ozf_funds_all_b

1543: earned_amt,paid_amt,transfered_in_amt
1544: ,transfered_out_amt,original_budget
1545: ,recal_committed,holdback_amt
1546: ,utilized_amt -- yzhao: 11.5.10
1547: FROM ozf_funds_all_b
1548: WHERE fund_id = p_fund_rec.fund_id;
1549:
1550: CURSOR c_rollup_amt IS
1551: SELECT rollup_planned_amt,rollup_committed_amt

Line 1556: FROM ozf_funds_all_b

1552: ,rollup_earned_amt,rollup_paid_amt,rollup_transfered_in_amt
1553: ,rollup_transfered_out_amt,rollup_original_budget
1554: ,rollup_recal_committed,rollup_holdback_amt
1555: ,rollup_utilized_amt -- yzhao: 11.5.10
1556: FROM ozf_funds_all_b
1557: WHERE fund_id = p_fund_rec.fund_id;
1558:
1559: /* kdass - R12 MOAC changes
1560: CURSOR c_get_org_id IS

Line 1562: FROM ozf_funds_all_b

1558:
1559: /* kdass - R12 MOAC changes
1560: CURSOR c_get_org_id IS
1561: SELECT org_id
1562: FROM ozf_funds_all_b
1563: WHERE fund_id = p_fund_rec.fund_id;
1564: */
1565:
1566: l_original_budget NUMBER;

Line 2379: UPDATE ozf_funds_all_b

2375: l_fund_rec.status_date := SYSDATE;
2376: END IF;
2377:
2378:
2379: UPDATE ozf_funds_all_b
2380: SET last_update_date = SYSDATE
2381: ,last_updated_by = NVL(fnd_global.user_id, -1)
2382: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2383: ,created_from = NULL

Line 3206: SELECT 1 from ozf_funds_all_b

3202:
3203: -- Added for Bug #3498826
3204: CURSOR c_prog_fund_number_create
3205: IS
3206: SELECT 1 from ozf_funds_all_b
3207: WHERE fund_number = p_fund_rec.fund_number;
3208:
3209: CURSOR c_prog_fund_number_update
3210: IS

Line 3211: SELECT 1 from ozf_funds_all_b

3207: WHERE fund_number = p_fund_rec.fund_number;
3208:
3209: CURSOR c_prog_fund_number_update
3210: IS
3211: SELECT 1 from ozf_funds_all_b
3212: WHERE fund_number = p_fund_rec.fund_number
3213: AND fund_id <> p_fund_rec.fund_id;
3214:
3215:

Line 3580: FROM ozf_funds_all_b

3576: CURSOR c_old_status(
3577: cv_fund_id IN NUMBER)
3578: IS
3579: SELECT status_code, original_budget
3580: FROM ozf_funds_all_b
3581: WHERE fund_id = cv_fund_id;
3582:
3583: CURSOR c_offer_org(p_list_header_id IN NUMBER)
3584: IS

Line 5360: FROM ozf_funds_all_b

5356: ,rollup_utilized_amt -- yzhao: 11.5.10
5357: ,rollup_earned_amt
5358: ,rollup_paid_amt
5359: ,rollup_recal_committed
5360: FROM ozf_funds_all_b
5361: connect by prior parent_fund_id =fund_id
5362: start with fund_id = p_fund_rec.fund_id;
5363:
5364: BEGIN

Line 5391: UPDATE ozf_funds_all_b

5387: FOR fund IN c_parent
5388: LOOP
5389: IF fund.fund_id <> p_fund_rec.fund_id THEN
5390:
5391: UPDATE ozf_funds_all_b
5392: SET object_version_number = fund.object_version_number + 1
5393: ,rollup_original_budget = NVL(fund.rollup_original_budget,0) + NVL(p_fund_rec.rollup_original_budget,0)
5394: ,rollup_transfered_in_amt = NVL(fund.rollup_transfered_in_amt,0) + NVL(p_fund_rec.rollup_transfered_in_amt,0)
5395: ,rollup_transfered_out_amt = NVL(fund.rollup_transfered_out_amt,0) + NVL(p_fund_rec.rollup_transfered_out_amt,0)

Line 5490: FROM ozf_funds_all_b

5486: --Get all of parent fund through bottom up tree walking.
5487: CURSOR c_parent
5488: IS
5489: SELECT fund_id,owner
5490: FROM ozf_funds_all_b
5491: connect by prior parent_fund_id =fund_id
5492: start with fund_id = p_fund_rec.fund_id;
5493:
5494: CURSOR c_fund_access(