APPS.OE_ATTACHMENT_RULES_PKG dependencies on OE_ATTACHMENT_RULES

Line 1: package body OE_ATTACHMENT_RULES_PKG as

1: package body OE_ATTACHMENT_RULES_PKG as
2: /* $Header: OEXVARLB.pls 120.0 2005/06/01 00:47:22 appldev noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 31: cursor C is select ROWID from OE_ATTACHMENT_RULES

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from OE_ATTACHMENT_RULES
32: where RULE_ID = X_RULE_ID
33: ;
34: begin
35:

Line 36: insert into OE_ATTACHMENT_RULES (

32: where RULE_ID = X_RULE_ID
33: ;
34: begin
35:
36: insert into OE_ATTACHMENT_RULES (
37: DATABASE_OBJECT_NAME,
38: RULE_ID,
39: DOCUMENT_ID,
40: CONTEXT,

Line 138: from OE_ATTACHMENT_RULES

134: ATTRIBUTE12,
135: ATTRIBUTE13,
136: ATTRIBUTE14,
137: ATTRIBUTE15
138: from OE_ATTACHMENT_RULES
139: where RULE_ID = X_RULE_ID
140: for update of RULE_ID nowait;
141: recinfo c%rowtype;
142:

Line 221: update OE_ATTACHMENT_RULES set

217: X_LAST_UPDATED_BY in NUMBER,
218: X_LAST_UPDATE_LOGIN in NUMBER
219: ) is
220: begin
221: update OE_ATTACHMENT_RULES set
222: DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME,
223: DOCUMENT_ID = X_DOCUMENT_ID,
224: CONTEXT = X_CONTEXT,
225: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 259: delete from OE_ATTACHMENT_RULES

255:
256: delete from OE_ATTACHMENT_RULE_ELEMENTS
257: where RULE_ID = X_RULE_ID;
258:
259: delete from OE_ATTACHMENT_RULES
260: where RULE_ID = X_RULE_ID;
261:
262: if (sql%notfound) then
263: raise no_data_found;

Line 268: end OE_ATTACHMENT_RULES_PKG;

264: end if;
265:
266: end DELETE_ROW;
267:
268: end OE_ATTACHMENT_RULES_PKG;