DBA Data[Home] [Help]

APPS.OE_PARAMETERS_DEF_UTIL dependencies on OE_DEBUG_PUB

Line 16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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: --
18: BEGIN
19: --- Inserting row to OE_SYS_PARAMETER_DEF_B table
20: INSERT INTO oe_sys_parameter_def_b (

Line 88: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

84:
85: PROCEDURE Delete_Row(p_parameter_code IN VARCHAR2)
86: IS
87: --
88: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
89: --
90: BEGIN
91: DELETE FROM oe_sys_parameter_def_tl
92: WHERE parameter_code = p_parameter_code;

Line 116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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: --
118: BEGIN
119: UPDATE oe_sys_parameter_def_b
120: SET last_update_date = p_sys_param_def_rec.last_update_date,

Line 180: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

176:
177: l_recinfo param_def%rowtype;
178: l_found VARCHAR2(1) := 'N';
179: --
180: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
181: --
182: BEGIN
183: OPEN param_def;
184: FETCH param_def INTO l_recinfo;