APPS.DEFCONDNRULE_PKG dependencies on OE_DEF_ATTR_CONDNS

Line 36: CURSOR C IS SELECT rowid from OE_DEF_attr_condns

32: ,p_attribute14 in varchar2
33: ,p_attribute15 in varchar2
34: ) IS
35:
36: CURSOR C IS SELECT rowid from OE_DEF_attr_condns
37: WHERE attr_def_condition_id = p_attr_def_condition_id;
38:
39: BEGIN
40:

Line 41: INSERT INTO OE_DEF_ATTR_CONDNS(

37: WHERE attr_def_condition_id = p_attr_def_condition_id;
38:
39: BEGIN
40:
41: INSERT INTO OE_DEF_ATTR_CONDNS(
42: condition_id,
43: attr_def_condition_id,
44: precedence,
45: database_object_name,

Line 146: UPDATE OE_DEF_ATTR_CONDNS

142: ) IS
143:
144: BEGIN
145:
146: UPDATE OE_DEF_ATTR_CONDNS
147: SET precedence = p_precedence
148: ,condition_id = p_condition_id
149: ,enabled_flag = p_enabled_flag
150: ,created_by = p_created_by

Line 184: DELETE FROM OE_DEF_ATTR_CONDNS

180: PROCEDURE Delete_Row(p_Rowid VARCHAR2,
181: p_attr_def_condition_id NUMBER) IS
182: BEGIN
183:
184: DELETE FROM OE_DEF_ATTR_CONDNS
185: WHERE rowid = p_rowid;
186:
187: if (SQL%NOTFOUND) then
188: Raise NO_DATA_FOUND;

Line 227: SELECT * FROM OE_DEF_ATTR_CONDNS

223: ,p_attribute15 in varchar2
224: ) IS
225:
226: CURSOR C IS
227: SELECT * FROM OE_DEF_ATTR_CONDNS
228: WHERE rowid = p_Rowid
229: FOR UPDATE OF attr_def_condition_id ;
230:
231: Recinfo C%ROWTYPE;

Line 341: FROM OE_DEF_ATTR_CONDNS

337: BEGIN
338:
339: SELECT COUNT(1)
340: INTO dummy
341: FROM OE_DEF_ATTR_CONDNS
342: WHERE condition_id = p_condition_id
343: AND database_object_name=p_database_object_name
344: AND attribute_code = p_attribute_code
345: AND ((p_rowid IS NULL) OR (ROWID <> p_rowid));