APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_TL

Line 1928: INSERT INTO ozf_funds_utilized_all_tl

1924: ,l_utilization_rec.year_id--Fix for Bug 11793070
1925: ,l_utilization_rec.list_line_id
1926: );
1927:
1928: INSERT INTO ozf_funds_utilized_all_tl
1929: (utilization_id
1930: ,last_update_date
1931: ,last_updated_by
1932: ,last_update_login

Line 1963: FROM ozf_funds_utilized_all_tl t

1959: ,l_utilization_rec.org_id -- fix for 3640740
1960: FROM fnd_languages l
1961: WHERE l.installed_flag IN ('I', 'B')
1962: AND NOT EXISTS ( SELECT NULL
1963: FROM ozf_funds_utilized_all_tl t
1964: WHERE t.utilization_id = l_utilization_rec.utilization_id
1965: AND t.language = l.language_code);
1966:
1967:

Line 2347: DELETE FROM ozf_funds_utilized_all_tl

2343:
2344: RAISE fnd_api.g_exc_error;
2345: END IF;
2346:
2347: DELETE FROM ozf_funds_utilized_all_tl
2348: WHERE utilization_id = p_utilization_id;
2349:
2350: IF (SQL%NOTFOUND) THEN
2351: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 2441: FROM ozf_funds_utilized_all_tl

2437: FOR UPDATE OF utilization_id NOWAIT;
2438:
2439: CURSOR c_utilization_tl IS
2440: SELECT utilization_id
2441: FROM ozf_funds_utilized_all_tl
2442: WHERE utilization_id = p_utilization_id
2443: AND USERENV ('LANG') IN (language, source_lang)
2444: FOR UPDATE OF utilization_id NOWAIT;
2445: BEGIN

Line 2834: UPDATE ozf_funds_utilized_all_tl

2830:
2831: RAISE fnd_api.g_exc_error;
2832: END IF;
2833:
2834: UPDATE ozf_funds_utilized_all_tl
2835: SET last_update_date = SYSDATE
2836: ,last_updated_by = NVL (fnd_global.user_id, -1)
2837: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2838: ,created_from = l_utilization_rec.created_from