APPS.OZF_SYS_PARAMETERS_PVT dependencies on OZF_SYS_PARAMETERS

Line 1: PACKAGE BODY OZF_SYS_PARAMETERS_PVT AS

1: PACKAGE BODY OZF_SYS_PARAMETERS_PVT AS
2: /* $Header: ozfvsysb.pls 120.17 2012/01/03 17:15:49 nirprasa ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):='OZF_Sys_Parameters_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30):='OZF_Sys_Parameters_PVT';

1: PACKAGE BODY OZF_SYS_PARAMETERS_PVT AS
2: /* $Header: ozfvsysb.pls 120.17 2012/01/03 17:15:49 nirprasa ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):='OZF_Sys_Parameters_PVT';
5:
6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7:
8:

Line 156: FROM ozf_sys_parameters;

152:
153: -- Cursor to validate the uniqueness of the set_of_books_id
154: CURSOR c_books_id_count(cv_org_id IN NUMBER) IS
155: SELECT COUNT(set_of_books_id)
156: FROM ozf_sys_parameters;
157: --WHERE org_id = cv_org_id;
158: --WHERE set_of_books_id = cv_books_id;
159:
160: BEGIN

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

Line 1647: FROM ozf_sys_parameters;

1643: --For SSD Default Adjustment Types
1644: ssd_inc_adj_type_id,
1645: ssd_dec_adj_type_id,
1646: ssd_imd_claim_flag
1647: FROM ozf_sys_parameters;
1648:
1649:
1650: l_sys_parameters_rec c_sys_para%ROWTYPE;
1651:

Line 2289: END OZF_Sys_Parameters_PVT;

2285:
2286:
2287: END Complete_Sys_Parameters_Rec;
2288:
2289: END OZF_Sys_Parameters_PVT;