DBA Data[Home] [Help]

APPS.OZF_SYS_PARAMETERS_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 262: INSERT INTO ozf_sys_parameters_all (

258: IF g_debug THEN
259: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
260: END IF;
261:
262: INSERT INTO ozf_sys_parameters_all (
263: set_of_books_id
264: ,object_version_number
265: ,last_update_date
266: ,last_updated_by

Line 578: DELETE FROM ozf_sys_parameters_all

574: IF g_debug THEN
575: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
576: END IF;
577:
578: DELETE FROM ozf_sys_parameters_all
579: WHERE set_of_books_id = p_set_of_books_id
580: AND object_version_number = p_object_version
581: AND org_id = l_org_id; -- R12 Enhancements
582:

Line 670: FROM ozf_sys_parameters_all

666: l_set_of_books_id NUMBER;
667:
668: CURSOR c_sys_para IS
669: SELECT set_of_books_id
670: FROM ozf_sys_parameters_all
671: WHERE set_of_books_id = p_set_of_books_id
672: AND object_version_number = p_object_version
673: FOR UPDATE OF set_of_books_id NOWAIT;
674:

Line 908: UPDATE ozf_sys_parameters_all SET

904: -------------------------- update --------------------
905: IF g_debug THEN
906: OZF_Utility_PVT.debug_message(l_full_name ||': update');
907: END IF;
908: UPDATE ozf_sys_parameters_all SET
909: set_of_books_id = l_sys_parameters_rec.set_of_books_id
910: ,object_version_number = l_object_version_number
911: ,last_update_date = SYSDATE
912: ,last_updated_by = l_last_updated_by