APPS.OZF_FUNDS_PVT dependencies on OZF_FUNDS_ALL_TL

Line 49: -- 08/29/2000 mchang insert org_id value into OZF_FUNDS_ALL_TL when creating a fund.

45: -- Available budget-- This is always a calculated amount and the formula is
46: -- (OB (Original)-HB (Holback)) +(TI(Transfer in) - TO(Transfer out))
47: -- Total Budget -- This is always a calculated amount and the formula is
48: -- (AB (Available) + HB (Holback))
49: -- 08/29/2000 mchang insert org_id value into OZF_FUNDS_ALL_TL when creating a fund.
50: -- 09/12/2000 mpande added code to facilitate team and other user update access
51: -- 09/26/2000 mpande added code to facilitate user_status
52: -- 11/30/2000 mpande BUG#1494231
53: --------------major changes for 11.5.5----------------------------------------------------------------

Line 841: INSERT INTO ozf_funds_all_tl

837: ,l_fund_rec.product_spread_time_id
838: ,l_fund_rec.ledger_id
839: );
840:
841: INSERT INTO ozf_funds_all_tl
842: (fund_id,
843: last_update_date,
844: last_updated_by,
845: last_update_login,

Line 878: FROM ozf_funds_all_tl t

874: ,l_fund_rec.org_id -- kdass - R12 MOAC changes
875: FROM fnd_languages l
876: WHERE l.installed_flag IN('I', 'B')
877: AND NOT EXISTS(SELECT NULL
878: FROM ozf_funds_all_tl t
879: WHERE t.fund_id = l_fund_rec.fund_id
880: AND t.language = l.language_code);
881:
882: ------------------------- finish -------------------------------

Line 1236: FROM ozf_funds_all_tl

1232: RAISE fnd_api.g_exc_error;
1233: END IF;
1234:
1235: DELETE
1236: FROM ozf_funds_all_tl
1237: WHERE fund_id = p_fund_id;
1238:
1239: IF (SQL%NOTFOUND) THEN
1240: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 1323: FROM ozf_funds_all_tl

1319:
1320: CURSOR c_fund_tl
1321: IS
1322: SELECT fund_id
1323: FROM ozf_funds_all_tl
1324: WHERE fund_id = p_fund_id
1325: AND USERENV('LANG') IN(language, source_lang)
1326: FOR UPDATE OF fund_id NOWAIT;
1327: BEGIN

Line 2602: UPDATE ozf_funds_all_tl

2598: -- the main table.
2599: If l_use_fund_staging_tables <> 'T' then
2600:
2601:
2602: UPDATE ozf_funds_all_tl
2603: SET last_update_date = SYSDATE
2604: ,last_updated_by = NVL(fnd_global.user_id, -1)
2605: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2606: ,created_from = NULL