APPS.DEFELEMENTS_PKG dependencies on OE_DEF_CONDN_ELEMS

Line 39: CURSOR C IS SELECT rowid from OE_DEF_CONDN_ELEMS

35: ,x_rowid out nocopy varchar2
36:
37: ) IS
38:
39: CURSOR C IS SELECT rowid from OE_DEF_CONDN_ELEMS
40: WHERE condition_element_id = p_condition_element_id;
41:
42: --
43: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 47: INSERT INTO OE_DEF_CONDN_ELEMS(

43: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
44: --
45: BEGIN
46:
47: INSERT INTO OE_DEF_CONDN_ELEMS(
48: condition_element_id
49: ,condition_id
50: ,group_number
51: ,attribute_code

Line 163: UPDATE OE_DEF_CONDN_ELEMS

159: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
160: --
161: BEGIN
162:
163: UPDATE OE_DEF_CONDN_ELEMS
164: SET attribute_code = p_attribute_code,
165: value_op = p_value_op,
166: value_string = p_value_string,
167: group_number = p_group_number

Line 211: DELETE FROM OE_DEF_CONDN_ELEMS

207: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
208: --
209: BEGIN
210:
211: DELETE FROM OE_DEF_CONDN_ELEMS
212: WHERE rowid = p_rowid;
213:
214: UPDATE OE_DEF_CONDITIONS
215: set number_of_elements=number_of_elements-1

Line 260: SELECT * FROM OE_DEF_CONDN_ELEMS

256: )
257: IS
258:
259: CURSOR C IS
260: SELECT * FROM OE_DEF_CONDN_ELEMS
261: WHERE condition_element_id = p_condition_element_id
262: FOR UPDATE of condition_element_id NOWAIT;
263:
264: Recinfo C%ROWTYPE;