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 833: INSERT INTO ozf_funds_all_tl

829: ,l_fund_rec.product_spread_time_id
830: ,l_fund_rec.ledger_id
831: );
832:
833: INSERT INTO ozf_funds_all_tl
834: (fund_id,
835: last_update_date,
836: last_updated_by,
837: last_update_login,

Line 870: FROM ozf_funds_all_tl t

866: ,l_fund_rec.org_id -- kdass - R12 MOAC changes
867: FROM fnd_languages l
868: WHERE l.installed_flag IN('I', 'B')
869: AND NOT EXISTS(SELECT NULL
870: FROM ozf_funds_all_tl t
871: WHERE t.fund_id = l_fund_rec.fund_id
872: AND t.language = l.language_code);
873:
874: ------------------------- finish -------------------------------

Line 1227: FROM ozf_funds_all_tl

1223: RAISE fnd_api.g_exc_error;
1224: END IF;
1225:
1226: DELETE
1227: FROM ozf_funds_all_tl
1228: WHERE fund_id = p_fund_id;
1229:
1230: IF (SQL%NOTFOUND) THEN
1231: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 1314: FROM ozf_funds_all_tl

1310:
1311: CURSOR c_fund_tl
1312: IS
1313: SELECT fund_id
1314: FROM ozf_funds_all_tl
1315: WHERE fund_id = p_fund_id
1316: AND USERENV('LANG') IN(language, source_lang)
1317: FOR UPDATE OF fund_id NOWAIT;
1318: BEGIN

Line 2505: UPDATE ozf_funds_all_tl

2501:
2502: RAISE fnd_api.g_exc_error;
2503: END IF;
2504:
2505: UPDATE ozf_funds_all_tl
2506: SET last_update_date = SYSDATE
2507: ,last_updated_by = NVL(fnd_global.user_id, -1)
2508: ,last_update_login = NVL(fnd_global.conc_login_id, -1)
2509: ,created_from = NULL