DBA Data[Home] [Help]

APPS.OZF_SYS_PARAMETERS_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 227: INSERT INTO ozf_sys_parameters_all (

223: IF g_debug THEN
224: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
225: END IF;
226:
227: INSERT INTO ozf_sys_parameters_all (
228: set_of_books_id
229: ,object_version_number
230: ,last_update_date
231: ,last_updated_by

Line 520: DELETE FROM ozf_sys_parameters_all

516: IF g_debug THEN
517: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
518: END IF;
519:
520: DELETE FROM ozf_sys_parameters_all
521: WHERE set_of_books_id = p_set_of_books_id
522: AND object_version_number = p_object_version
523: AND org_id = l_org_id; -- R12 Enhancements
524:

Line 612: FROM ozf_sys_parameters_all

608: l_set_of_books_id NUMBER;
609:
610: CURSOR c_sys_para IS
611: SELECT set_of_books_id
612: FROM ozf_sys_parameters_all
613: WHERE set_of_books_id = p_set_of_books_id
614: AND object_version_number = p_object_version
615: FOR UPDATE OF set_of_books_id NOWAIT;
616:

Line 850: UPDATE ozf_sys_parameters_all SET

846: -------------------------- update --------------------
847: IF g_debug THEN
848: OZF_Utility_PVT.debug_message(l_full_name ||': update');
849: END IF;
850: UPDATE ozf_sys_parameters_all SET
851: set_of_books_id = l_sys_parameters_rec.set_of_books_id
852: ,object_version_number = l_object_version_number
853: ,last_update_date = SYSDATE
854: ,last_updated_by = l_last_updated_by