APPS.OE_ATT_RULE_ELEMENTS_PKG dependencies on OE_ATTACHMENT_RULE_ELEMENTS

Line 32: cursor C is select ROWID from OE_ATTACHMENT_RULE_ELEMENTS

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from OE_ATTACHMENT_RULE_ELEMENTS
33: where RULE_ELEMENT_ID = X_RULE_ELEMENT_ID
34: ;
35: begin
36: insert into OE_ATTACHMENT_RULE_ELEMENTS (

Line 36: insert into OE_ATTACHMENT_RULE_ELEMENTS (

32: cursor C is select ROWID from OE_ATTACHMENT_RULE_ELEMENTS
33: where RULE_ELEMENT_ID = X_RULE_ELEMENT_ID
34: ;
35: begin
36: insert into OE_ATTACHMENT_RULE_ELEMENTS (
37: RULE_ELEMENT_ID,
38: RULE_ID,
39: GROUP_NUMBER,
40: ATTRIBUTE_CODE,

Line 146: from OE_ATTACHMENT_RULE_ELEMENTS

142: ATTRIBUTE12,
143: ATTRIBUTE13,
144: ATTRIBUTE14,
145: ATTRIBUTE15
146: from OE_ATTACHMENT_RULE_ELEMENTS
147: where RULE_ELEMENT_ID = X_RULE_ELEMENT_ID
148: for update of RULE_ELEMENT_ID nowait;
149: recinfo c%rowtype;
150:

Line 232: update OE_ATTACHMENT_RULE_ELEMENTS set

228: X_LAST_UPDATED_BY in NUMBER,
229: X_LAST_UPDATE_LOGIN in NUMBER
230: ) is
231: begin
232: update OE_ATTACHMENT_RULE_ELEMENTS set
233: RULE_ID = X_RULE_ID,
234: GROUP_NUMBER = X_GROUP_NUMBER,
235: ATTRIBUTE_CODE = X_ATTRIBUTE_CODE,
236: ATTRIBUTE_VALUE = X_ATTRIBUTE_VALUE,

Line 269: delete from OE_ATTACHMENT_RULE_ELEMENTS

265: X_RULE_ELEMENT_ID in NUMBER
266: ) is
267: begin
268:
269: delete from OE_ATTACHMENT_RULE_ELEMENTS
270: where RULE_ELEMENT_ID = X_RULE_ELEMENT_ID;
271:
272: if (sql%notfound) then
273: raise no_data_found;