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 224: FROM ozf_funds_all_b

220: CURSOR c_child_count(
221: p_fund_id IN NUMBER)
222: IS
223: SELECT COUNT(fund_id)
224: FROM ozf_funds_all_b
225: WHERE parent_fund_id = p_fund_id;
226:
227: CURSOR c_parent_number(
228: p_fund_id IN NUMBER)

Line 231: FROM ozf_funds_all_b

227: CURSOR c_parent_number(
228: p_fund_id IN NUMBER)
229: IS
230: SELECT fund_number
231: FROM ozf_funds_all_b
232: WHERE fund_id = p_fund_id;
233: BEGIN
234: x_return_status := fnd_api.g_ret_sts_success;
235: OPEN c_child_count(p_parent_fund_id);

Line 254: WHILE ozf_utility_pvt.check_uniqueness('ozf_funds_all_b'

250:
251: x_code := SUBSTRB(l_par_number || l_count, 1, 30);
252:
253: --asylvia Fixed bug 5073532
254: WHILE ozf_utility_pvt.check_uniqueness('ozf_funds_all_b'
255: ,'fund_number = ''' || x_code || '''') =
256: fnd_api.g_false LOOP
257: l_count := l_count + 1 ;
258: x_code :=SUBSTRB(l_par_number || l_count, 1, 30);

Line 275: SELECT fund_type FROM ozf_funds_all_b

271:
272: PROCEDURE raise_business_event(p_object_id IN NUMBER,p_event_type IN VARCHAR2)
273: IS
274: CURSOR c_fund_type(p_fund_id NUMBER) IS
275: SELECT fund_type FROM ozf_funds_all_b
276: WHERE fund_id = p_fund_id;
277:
278: l_fund_type varchar2(30);
279: l_item_key varchar2(30);

Line 398: FROM ozf_funds_all_b

394: CURSOR c_fund_count(
395: cv_fund_id IN NUMBER)
396: IS
397: SELECT COUNT(fund_id)
398: FROM ozf_funds_all_b
399: WHERE fund_id = cv_fund_id;
400:
401:
402: CURSOR c_prog_fund_number (cl_fund_number IN VARCHAR2)

Line 404: SELECT count(fund_id) from ozf_funds_all_b

400:
401:
402: CURSOR c_prog_fund_number (cl_fund_number IN VARCHAR2)
403: IS
404: SELECT count(fund_id) from ozf_funds_all_b
405: WHERE fund_number = cl_fund_number;
406:
407: BEGIN
408: --------------------- initialize -----------------------

Line 618: INSERT INTO ozf_funds_all_b

614: END IF;
615:
616: END IF;
617:
618: INSERT INTO ozf_funds_all_b
619: (
620: fund_id,
621: last_update_date,
622: last_updated_by,

Line 1222: FROM ozf_funds_all_b

1218: ozf_utility_pvt.debug_message(l_full_name || ': delete');
1219: END IF;
1220:
1221: DELETE
1222: FROM ozf_funds_all_b
1223: WHERE fund_id = p_fund_id
1224: AND object_version_number = p_object_version;
1225:
1226: IF (SQL%NOTFOUND) THEN

Line 1315: FROM ozf_funds_all_b

1311:
1312: CURSOR c_fund_b
1313: IS
1314: SELECT fund_id
1315: FROM ozf_funds_all_b
1316: WHERE fund_id = p_fund_id
1317: AND object_version_number = p_object_version
1318: FOR UPDATE OF fund_id NOWAIT;
1319:

Line 1429: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

1425: )
1426: IS
1427: l_resale_batch_id NUMBER;
1428: l_use_fund_staging_tables VARCHAR2(1) := 'F';
1429: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
1430: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
1431: l_batch_type VARCHAR2(30);
1432: BEGIN
1433: update_fund(

Line 1490: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

1486: ,p_mode IN VARCHAR2 := jtf_plsql_api.g_update
1487: ,p_resale_batch_id IN NUMBER
1488: ,p_batch_type IN VARCHAR2
1489: ,p_use_fund_staging_tables IN VARCHAR2
1490: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
1491: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table
1492: )
1493: IS
1494: l_api_version CONSTANT NUMBER := 1.0;

Line 1543: FROM ozf_funds_all_b

1539: IS
1540: SELECT status_code
1541: ,parent_fund_id
1542: ,user_status_id
1543: FROM ozf_funds_all_b
1544: WHERE fund_id = cv_fund_id;
1545:
1546: l_old_status VARCHAR2(30);
1547: l_old_parent_fund_id NUMBER;

Line 1555: FROM ozf_funds_all_b

1551: CURSOR c_par_fund_owner(
1552: par_fund_id IN NUMBER)
1553: IS
1554: SELECT owner
1555: FROM ozf_funds_all_b
1556: WHERE fund_id = par_fund_id;
1557:
1558: /* R12: yzhao bug 4669269 - obsolete ozf_mc_transactions
1559: CURSOR c_mc_record(

Line 1598: FROM ozf_funds_all_b

1594: CURSOR c_old_curr(
1595: cv_fund_id IN NUMBER)
1596: IS
1597: SELECT currency_code_tc , owner
1598: FROM ozf_funds_all_b
1599: WHERE fund_id = cv_fund_id;
1600:
1601: l_old_curr VARCHAR2(30);
1602: l_rate NUMBER;

Line 1612: FROM ozf_funds_all_b

1608: earned_amt,paid_amt,transfered_in_amt
1609: ,transfered_out_amt,original_budget
1610: ,recal_committed,holdback_amt
1611: ,utilized_amt -- yzhao: 11.5.10
1612: FROM ozf_funds_all_b
1613: WHERE fund_id = p_fund_rec.fund_id;
1614:
1615: CURSOR c_rollup_amt IS
1616: SELECT rollup_planned_amt,rollup_committed_amt

Line 1621: FROM ozf_funds_all_b

1617: ,rollup_earned_amt,rollup_paid_amt,rollup_transfered_in_amt
1618: ,rollup_transfered_out_amt,rollup_original_budget
1619: ,rollup_recal_committed,rollup_holdback_amt
1620: ,rollup_utilized_amt -- yzhao: 11.5.10
1621: FROM ozf_funds_all_b
1622: WHERE fund_id = p_fund_rec.fund_id;
1623:
1624: /* kdass - R12 MOAC changes
1625: CURSOR c_get_org_id IS

Line 1627: FROM ozf_funds_all_b

1623:
1624: /* kdass - R12 MOAC changes
1625: CURSOR c_get_org_id IS
1626: SELECT org_id
1627: FROM ozf_funds_all_b
1628: WHERE fund_id = p_fund_rec.fund_id;
1629: */
1630:
1631: l_original_budget NUMBER;

Line 2597: -- new record type and pass it on to OZF_RESALE_COMMON_PVT.UPDATE_OZF_FUNDS_ALL_B procedure for updating

2593: ozf_utility_pvt.debug_message('l_use_fund_staging_tables: ' || l_use_fund_staging_tables );
2594: END IF;
2595: -- For BUG#8867381(+)
2596: -- l_use_fund_staging_tables flag is set only for chargeback flow and will insert the records into
2597: -- new record type and pass it on to OZF_RESALE_COMMON_PVT.UPDATE_OZF_FUNDS_ALL_B procedure for updating
2598: -- the main table.
2599: If l_use_fund_staging_tables <> 'T' then
2600:
2601:

Line 2617: UPDATE ozf_funds_all_b

2613: ,source_lang = USERENV('LANG')
2614: WHERE fund_id = l_fund_rec.fund_id
2615: AND USERENV('LANG') IN(language, source_lang);
2616:
2617: UPDATE ozf_funds_all_b
2618: SET last_update_date = SYSDATE
2619: ,last_updated_by = NVL(fnd_global.user_id, -1)
2620: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2621: ,created_from = NULL

Line 2951: -- chargeback flow it updates roll up amount in OZF_RESALE_COMMON_PVT.UPDATE_OZF_FUNDS_ALL_B procedure.

2947:
2948:
2949: -- For BUG#8867381(+)
2950: -- l_use_fund_staging_tables flag is set only for chargeback flow and for the
2951: -- chargeback flow it updates roll up amount in OZF_RESALE_COMMON_PVT.UPDATE_OZF_FUNDS_ALL_B procedure.
2952:
2953: If l_use_fund_staging_tables <> 'T' then
2954:
2955: IF G_DEBUG THEN

Line 3605: SELECT 1 from ozf_funds_all_b

3601:
3602: -- Added for Bug #3498826
3603: CURSOR c_prog_fund_number_create
3604: IS
3605: SELECT 1 from ozf_funds_all_b
3606: WHERE fund_number = p_fund_rec.fund_number;
3607:
3608: CURSOR c_prog_fund_number_update
3609: IS

Line 3610: SELECT 1 from ozf_funds_all_b

3606: WHERE fund_number = p_fund_rec.fund_number;
3607:
3608: CURSOR c_prog_fund_number_update
3609: IS
3610: SELECT 1 from ozf_funds_all_b
3611: WHERE fund_number = p_fund_rec.fund_number
3612: AND fund_id <> p_fund_rec.fund_id;
3613:
3614:

Line 3982: FROM ozf_funds_all_b

3978: CURSOR c_old_status(
3979: cv_fund_id IN NUMBER)
3980: IS
3981: SELECT status_code, original_budget
3982: FROM ozf_funds_all_b
3983: WHERE fund_id = cv_fund_id;
3984:
3985: CURSOR c_offer_org(p_list_header_id IN NUMBER)
3986: IS

Line 5788: FROM ozf_funds_all_b

5784: ,rollup_utilized_amt -- yzhao: 11.5.10
5785: ,rollup_earned_amt
5786: ,rollup_paid_amt
5787: ,rollup_recal_committed
5788: FROM ozf_funds_all_b
5789: connect by prior parent_fund_id =fund_id
5790: start with fund_id = p_fund_rec.fund_id;
5791:
5792: BEGIN

Line 5819: UPDATE ozf_funds_all_b

5815: FOR fund IN c_parent
5816: LOOP
5817: IF fund.fund_id <> p_fund_rec.fund_id THEN
5818:
5819: UPDATE ozf_funds_all_b
5820: SET object_version_number = fund.object_version_number + 1
5821: ,rollup_original_budget = NVL(fund.rollup_original_budget,0) + NVL(p_fund_rec.rollup_original_budget,0)
5822: ,rollup_transfered_in_amt = NVL(fund.rollup_transfered_in_amt,0) + NVL(p_fund_rec.rollup_transfered_in_amt,0)
5823: ,rollup_transfered_out_amt = NVL(fund.rollup_transfered_out_amt,0) + NVL(p_fund_rec.rollup_transfered_out_amt,0)

Line 5918: FROM ozf_funds_all_b

5914: --Get all of parent fund through bottom up tree walking.
5915: CURSOR c_parent
5916: IS
5917: SELECT fund_id,owner
5918: FROM ozf_funds_all_b
5919: connect by prior parent_fund_id =fund_id
5920: start with fund_id = p_fund_rec.fund_id;
5921:
5922: CURSOR c_fund_access(