APPS.AR_BPA_RULE_ATTRIBUTES_PKG dependencies on AR_BPA_RULE_ATTRIBUTES_B

Line 16: cursor C is select ROWID from AR_BPA_RULE_ATTRIBUTES_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from AR_BPA_RULE_ATTRIBUTES_B
17: where RULE_ATTRIBUTE_ID = X_RULE_ATTRIBUTE_ID
18: ;
19: begin
20: insert into AR_BPA_RULE_ATTRIBUTES_B (

Line 20: insert into AR_BPA_RULE_ATTRIBUTES_B (

16: cursor C is select ROWID from AR_BPA_RULE_ATTRIBUTES_B
17: where RULE_ATTRIBUTE_ID = X_RULE_ATTRIBUTE_ID
18: ;
19: begin
20: insert into AR_BPA_RULE_ATTRIBUTES_B (
21: RULE_ATTRIBUTE_ID,
22: RULE_ID,
23: ITEM_ID,
24: MATCH_CONDITION,

Line 91: from AR_BPA_RULE_ATTRIBUTES_B

87: cursor c is select
88: RULE_ID,
89: ITEM_ID,
90: MATCH_CONDITION
91: from AR_BPA_RULE_ATTRIBUTES_B
92: where RULE_ATTRIBUTE_ID = X_RULE_ATTRIBUTE_ID
93: for update of RULE_ATTRIBUTE_ID nowait;
94: recinfo c%rowtype;
95:

Line 148: update AR_BPA_RULE_ATTRIBUTES_B set

144: X_LAST_UPDATED_BY in NUMBER,
145: X_LAST_UPDATE_LOGIN in NUMBER
146: ) is
147: begin
148: update AR_BPA_RULE_ATTRIBUTES_B set
149: RULE_ID = X_RULE_ID,
150: ITEM_ID = X_ITEM_ID,
151: MATCH_CONDITION = X_MATCH_CONDITION,
152: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 186: delete from AR_BPA_RULE_ATTRIBUTES_B

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: delete from AR_BPA_RULE_ATTRIBUTES_B
187: where RULE_ATTRIBUTE_ID = X_RULE_ATTRIBUTE_ID;
188:
189: if (sql%notfound) then
190: raise no_data_found;

Line 200: from AR_BPA_RULE_ATTRIBUTES_B B

196: begin
197: delete from AR_BPA_RULE_ATTRIBUTES_TL T
198: where not exists
199: (select NULL
200: from AR_BPA_RULE_ATTRIBUTES_B B
201: where B.RULE_ATTRIBUTE_ID = T.RULE_ATTRIBUTE_ID
202: );
203:
204: update AR_BPA_RULE_ATTRIBUTES_TL T set (