APPS.AR_BPA_RULES_PKG dependencies on AR_BPA_RULES_B

Line 26: cursor C is select ROWID from AR_BPA_RULES_B

22: X_LAST_UPDATE_DATE in DATE,
23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER
25: ) is
26: cursor C is select ROWID from AR_BPA_RULES_B
27: where RULE_ID = X_RULE_ID
28: ;
29: begin
30: insert into AR_BPA_RULES_B (

Line 30: insert into AR_BPA_RULES_B (

26: cursor C is select ROWID from AR_BPA_RULES_B
27: where RULE_ID = X_RULE_ID
28: ;
29: begin
30: insert into AR_BPA_RULES_B (
31: SAME_PRINTING_TEMPLATE_FLAG,
32: PRINT_RULE_SEARCH_ORDER,
33: RULE_ID,
34: PRIMARY_APP_ID,

Line 140: from AR_BPA_RULES_B

136: DM_SAME_PRT_TMPLT_FLAG,
137: CB_SAME_PRT_TMPLT_FLAG,
138: DEP_SAME_PRT_TMPLT_FLAG,
139: GUAR_SAME_PRT_TMPLT_FLAG
140: from AR_BPA_RULES_B
141: where RULE_ID = X_RULE_ID
142: for update of RULE_ID nowait;
143: recinfo c%rowtype;
144:

Line 229: update AR_BPA_RULES_B set

225: X_LAST_UPDATED_BY in NUMBER,
226: X_LAST_UPDATE_LOGIN in NUMBER
227: ) is
228: begin
229: update AR_BPA_RULES_B set
230: SAME_PRINTING_TEMPLATE_FLAG = X_SAME_PRINTING_TEMPLATE_FLAG,
231: PRINT_RULE_SEARCH_ORDER = X_PRINT_RULE_SEARCH_ORDER,
232: PRIMARY_APP_ID = X_PRIMARY_APP_ID,
233: SECONDARY_APP_ID = X_SECONDARY_APP_ID,

Line 277: delete from AR_BPA_RULES_B

273: if (sql%notfound) then
274: raise no_data_found;
275: end if;
276:
277: delete from AR_BPA_RULES_B
278: where RULE_ID = X_RULE_ID;
279:
280: if (sql%notfound) then
281: raise no_data_found;

Line 291: from AR_BPA_RULES_B B

287: begin
288: delete from AR_BPA_RULES_TL T
289: where not exists
290: (select NULL
291: from AR_BPA_RULES_B B
292: where B.RULE_ID = T.RULE_ID
293: );
294:
295: update AR_BPA_RULES_TL T set (