APPS.OE_PARAMETERS_DEF_UTIL dependencies on OE_SYS_PARAMETER_DEF_B

Line 7: -- Description : Inserts record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table

3:
4: -- Start of comments
5: -- API name : Insert_Row
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: --

Line 19: --- Inserting row to OE_SYS_PARAMETER_DEF_B table

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 (
21: parameter_code,
22: creation_date,
23: created_by,

Line 20: INSERT INTO oe_sys_parameter_def_b (

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 (
21: parameter_code,
22: creation_date,
23: created_by,
24: last_update_date,

Line 79: -- Description : Delete Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table

75:
76: -- Start of comments
77: -- API name : Delete_Row
78: -- Type : Public
79: -- Description : Delete Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table
80: -- Parameters :
81: -- IN : p_parameter_code IN VARCHAR2 Required
82: --
83: -- End of Comments

Line 97: DELETE FROM oe_sys_parameter_def_b

93: IF (sql%notfound) THEN
94: RAISE no_data_found;
95: END IF;
96:
97: DELETE FROM oe_sys_parameter_def_b
98: WHERE parameter_code = p_parameter_code;
99: IF (sql%notfound) THEN
100: RAISE no_data_found;
101: END IF;

Line 107: -- Description : Update Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table

103:
104: -- Start of comments
105: -- API name : Update_Row
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: --

Line 119: UPDATE oe_sys_parameter_def_b

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,
121: last_updated_by = p_sys_param_def_rec.last_updated_by,
122: last_update_login = p_sys_param_def_rec.last_update_login,
123: category_code = p_sys_param_def_rec.category_code,

Line 150: -- Description : Lock Parameter definition record in oe_sys_parameter_def_b and oe_sys_parameter_def_tl table

146:
147: -- Start of comments
148: -- API name : Lock_Row
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: --

Line 164: FROM oe_sys_parameter_def_b

160: category_code,
161: value_set_id,
162: open_orders_check_flag,
163: enabled_flag
164: FROM oe_sys_parameter_def_b
165: WHERE parameter_code = p_parameter_code
166: FOR UPDATE OF value_set_id NOWAIT;
167:
168: CURSOR param_tl IS

Line 409: FROM oe_sys_parameter_def_b b

405: BEGIN
406: DELETE FROM oe_sys_parameter_def_tl t
407: WHERE NOT EXISTS
408: (SELECT null
409: FROM oe_sys_parameter_def_b b
410: where b.parameter_code = t.parameter_code);
411:
412: UPDATE oe_sys_parameter_def_tl t
413: SET