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.13 2007/12/21 07:47:54 gdeepika 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.13 2007/12/21 07:47:54 gdeepika 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 121: FROM ozf_sys_parameters;

117:
118: -- Cursor to validate the uniqueness of the set_of_books_id
119: CURSOR c_books_id_count(cv_org_id IN NUMBER) IS
120: SELECT COUNT(set_of_books_id)
121: FROM ozf_sys_parameters;
122: --WHERE org_id = cv_org_id;
123: --WHERE set_of_books_id = cv_books_id;
124:
125: BEGIN

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

Line 1563: FROM ozf_sys_parameters;

1559: prorate_earnings_flag,
1560: sales_credit_default_type,
1561: net_amt_for_mass_settle_flag,
1562: claim_tax_incl_flag
1563: FROM ozf_sys_parameters;
1564:
1565:
1566: l_sys_parameters_rec c_sys_para%ROWTYPE;
1567:

Line 2135: END OZF_Sys_Parameters_PVT;

2131: END IF;
2132:
2133: END Complete_Sys_Parameters_Rec;
2134:
2135: END OZF_Sys_Parameters_PVT;