APPS.AR_BPA_RULE_TEMPLATES_PKG dependencies on AR_BPA_RULE_TEMPLATES

Line 1: package body AR_BPA_RULE_TEMPLATES_PKG as

1: package body AR_BPA_RULE_TEMPLATES_PKG as
2: /* $Header: ARBPRTMB.pls 120.1 2004/12/03 01:45:16 orashid noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_RULE_TEMPLATE_ID in NUMBER,

Line 17: cursor C is select ROWID from AR_BPA_RULE_TEMPLATES

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from AR_BPA_RULE_TEMPLATES
18: where RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID
19: ;
20: begin
21: insert into AR_BPA_RULE_TEMPLATES (

Line 21: insert into AR_BPA_RULE_TEMPLATES (

17: cursor C is select ROWID from AR_BPA_RULE_TEMPLATES
18: where RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID
19: ;
20: begin
21: insert into AR_BPA_RULE_TEMPLATES (
22: RULE_TEMPLATE_ID,
23: TEMPLATE_ID,
24: RULE_ID,
25: EFFECTIVE_FROM_DATE,

Line 72: from AR_BPA_RULE_TEMPLATES

68: RULE_ID,
69: EFFECTIVE_FROM_DATE,
70: EFFECTIVE_TO_DATE,
71: ASSIGNED_TEMPLATE_PURPOSE
72: from AR_BPA_RULE_TEMPLATES
73: where RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID
74: for update of RULE_TEMPLATE_ID nowait;
75: recinfo c%rowtype;
76:

Line 115: update AR_BPA_RULE_TEMPLATES set

111: X_LAST_UPDATED_BY in NUMBER,
112: X_LAST_UPDATE_LOGIN in NUMBER
113: ) is
114: begin
115: update AR_BPA_RULE_TEMPLATES set
116: RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID,
117: TEMPLATE_ID = X_TEMPLATE_ID,
118: RULE_ID = X_RULE_ID,
119: EFFECTIVE_FROM_DATE = X_EFFECTIVE_FROM_DATE,

Line 136: delete from AR_BPA_RULE_TEMPLATES

132: procedure DELETE_ROW (
133: X_RULE_TEMPLATE_ID in NUMBER
134: ) is
135: begin
136: delete from AR_BPA_RULE_TEMPLATES
137: where RULE_TEMPLATE_ID = X_RULE_TEMPLATE_ID;
138:
139: if (sql%notfound) then
140: raise no_data_found;

Line 163: AR_BPA_RULE_TEMPLATES_PKG.UPDATE_ROW (

159: if (X_OWNER = 'SEED') then
160: user_id := 1;
161: end if;
162:
163: AR_BPA_RULE_TEMPLATES_PKG.UPDATE_ROW (
164: X_RULE_TEMPLATE_ID => X_RULE_TEMPLATE_ID,
165: X_TEMPLATE_ID => X_TEMPLATE_ID,
166: X_RULE_ID => X_RULE_ID,
167: X_EFFECTIVE_FROM_DATE => X_EFFECTIVE_FROM_DATE,

Line 175: AR_BPA_RULE_TEMPLATES_PKG.INSERT_ROW (

171: X_LAST_UPDATED_BY => user_id,
172: X_LAST_UPDATE_LOGIN => 0);
173: exception
174: when NO_DATA_FOUND then
175: AR_BPA_RULE_TEMPLATES_PKG.INSERT_ROW (
176: X_ROWID => row_id,
177: X_RULE_TEMPLATE_ID => X_RULE_TEMPLATE_ID,
178: X_TEMPLATE_ID => X_TEMPLATE_ID,
179: X_RULE_ID => X_RULE_ID,

Line 191: end AR_BPA_RULE_TEMPLATES_PKG;

187: X_LAST_UPDATE_LOGIN => 0);
188: end;
189: end LOAD_ROW;
190:
191: end AR_BPA_RULE_TEMPLATES_PKG;