APPS.OE_PARAMETERS_DEF_UTIL dependencies on OE_PARAMETERS_DEF_UTIL

Line 1: PACKAGE BODY OE_PARAMETERS_DEF_UTIL AS

1: PACKAGE BODY OE_PARAMETERS_DEF_UTIL AS
2: /* $Header: OEXUPADB.pls 120.1 2005/10/20 00:22:29 ppnair noship $ */
3:
4: -- Start of comments
5: -- API name : Insert_Row

Line 10: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required

6: -- Type : Public
7: -- Description : Inserts record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table
8: -- Parameters :
9: -- IN : p_sys_param_def_rec IN
10: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required
11: --
12: -- End of Comments
13: PROCEDURE Insert_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type)
14: IS

Line 13: PROCEDURE Insert_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type)

9: -- IN : p_sys_param_def_rec IN
10: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required
11: --
12: -- End of Comments
13: PROCEDURE Insert_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type)
14: IS
15: --
16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
17: --

Line 110: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required

106: -- Type : Public
107: -- Description : Update Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table
108: -- Parameters :
109: -- IN : p_sys_param_def_rec IN
110: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required
111: --
112: -- End of Comments
113: PROCEDURE Update_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type)
114: IS

Line 113: PROCEDURE Update_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type)

109: -- IN : p_sys_param_def_rec IN
110: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required
111: --
112: -- End of Comments
113: PROCEDURE Update_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type)
114: IS
115: --
116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
117: --

Line 153: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required

149: -- Type : Public
150: -- Description : Lock Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table
151: -- Parameters :
152: -- IN : p_sys_param_def_rec IN
153: -- OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type Required
154: --
155: -- End of Comments
156: PROCEDURE Lock_Row(p_parameter_code IN VARCHAR2)
157: IS

Line 336: l_sys_param_def_rec OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type;

332: FROM oe_lookups
333: WHERE lookup_type ='OM_PARAMETER_CATEGORY'
334: AND lookup_code =p_category_code;
335:
336: l_sys_param_def_rec OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type;
337: l_value_set_id NUMBER;
338: l_category VARCHAR2(30);
339: l_last_upd_by NUMBER;
340: l_last_upd_dt DATE;

Line 480: END OE_PARAMETERS_DEF_UTIL;

476: WHERE t.parameter_code = b.parameter_code
477: AND t.language = l.language_code);
478: END Add_Language;
479:
480: END OE_PARAMETERS_DEF_UTIL;