APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_TL

Line 1524: INSERT INTO ozf_funds_utilized_all_tl

1520: ,l_utilization_rec.univ_curr_amount
1521: ,l_utilization_rec.univ_curr_amount_remaining
1522: );
1523:
1524: INSERT INTO ozf_funds_utilized_all_tl
1525: (utilization_id
1526: ,last_update_date
1527: ,last_updated_by
1528: ,last_update_login

Line 1559: FROM ozf_funds_utilized_all_tl t

1555: ,l_utilization_rec.org_id -- fix for 3640740
1556: FROM fnd_languages l
1557: WHERE l.installed_flag IN ('I', 'B')
1558: AND NOT EXISTS ( SELECT NULL
1559: FROM ozf_funds_utilized_all_tl t
1560: WHERE t.utilization_id = l_utilization_rec.utilization_id
1561: AND t.language = l.language_code);
1562:
1563:

Line 1895: DELETE FROM ozf_funds_utilized_all_tl

1891:
1892: RAISE fnd_api.g_exc_error;
1893: END IF;
1894:
1895: DELETE FROM ozf_funds_utilized_all_tl
1896: WHERE utilization_id = p_utilization_id;
1897:
1898: IF (SQL%NOTFOUND) THEN
1899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 1989: FROM ozf_funds_utilized_all_tl

1985: FOR UPDATE OF utilization_id NOWAIT;
1986:
1987: CURSOR c_utilization_tl IS
1988: SELECT utilization_id
1989: FROM ozf_funds_utilized_all_tl
1990: WHERE utilization_id = p_utilization_id
1991: AND USERENV ('LANG') IN (language, source_lang)
1992: FOR UPDATE OF utilization_id NOWAIT;
1993: BEGIN

Line 2372: UPDATE ozf_funds_utilized_all_tl

2368:
2369: RAISE fnd_api.g_exc_error;
2370: END IF;
2371:
2372: UPDATE ozf_funds_utilized_all_tl
2373: SET last_update_date = SYSDATE
2374: ,last_updated_by = NVL (fnd_global.user_id, -1)
2375: ,last_update_login = NVL (fnd_global.conc_login_id, -1)
2376: ,created_from = l_utilization_rec.created_from