APPS.DEFRULE_PKG dependencies on OE_DEF_ATTR_DEF_RULES

Line 49: CURSOR C IS SELECT rowid from OE_DEF_attr_def_rules

45: ,p_attribute14 in varchar2
46: ,p_attribute15 in varchar2
47: ) IS
48:
49: CURSOR C IS SELECT rowid from OE_DEF_attr_def_rules
50: WHERE attr_def_rule_id = p_attr_def_rule_id;
51:
52: BEGIN
53:

Line 54: INSERT INTO OE_DEF_ATTR_DEF_RULES(

50: WHERE attr_def_rule_id = p_attr_def_rule_id;
51:
52: BEGIN
53:
54: INSERT INTO OE_DEF_ATTR_DEF_RULES(
55: attr_def_condition_id,
56: attr_def_rule_id,
57: sequence_no,
58: database_object_name,

Line 164: UPDATE OE_DEF_ATTR_DEF_RULES

160: ) IS
161:
162: BEGIN
163:
164: UPDATE OE_DEF_ATTR_DEF_RULES
165: set sequence_no = p_sequence_no,
166: database_object_name = p_database_object_name,
167: attribute_code=p_attribute_code,
168: src_type = p_src_type,

Line 194: DELETE FROM OE_DEF_ATTR_DEF_RULES

190: p_system_flag varchar2,
191: p_permanent_flag varchar2) IS
192: BEGIN
193:
194: DELETE FROM OE_DEF_ATTR_DEF_RULES
195: WHERE rowid = p_rowid;
196:
197:
198: if (SQL%NOTFOUND) then

Line 251: SELECT * FROM OE_DEF_ATTR_DEF_RULES

247: )
248: IS
249:
250: CURSOR C IS
251: SELECT * FROM OE_DEF_ATTR_DEF_RULES
252: WHERE rowid = p_Rowid
253: FOR UPDATE OF attr_def_rule_id ;
254:
255: Recinfo C%ROWTYPE;