APPS.AMS_WEB_RULES_PKG dependencies on AMS_WEB_RULES_B

Line 36: cursor C is select ROWID from AMS_WEB_RULES_B

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from AMS_WEB_RULES_B
37: where RULE_ID = X_RULE_ID;
38: begin
39: insert into AMS_WEB_RULES_B (
40: RULE_ID,

Line 39: insert into AMS_WEB_RULES_B (

35: ) is
36: cursor C is select ROWID from AMS_WEB_RULES_B
37: where RULE_ID = X_RULE_ID;
38: begin
39: insert into AMS_WEB_RULES_B (
40: RULE_ID,
41: ACTIVITY_RULE_ID,
42: RULE_PRIORITY,
43: RELATIONSHIP_CODE,

Line 192: from AMS_WEB_RULES_B

188: ATTRIBUTE12,
189: ATTRIBUTE13,
190: ATTRIBUTE14,
191: ATTRIBUTE15
192: from AMS_WEB_RULES_B
193: where RULE_ID = X_RULE_ID
194: for update of RULE_ID nowait;
195: recinfo c%rowtype;
196:

Line 308: update AMS_WEB_RULES_B set

304: X_LAST_UPDATED_BY in NUMBER,
305: X_LAST_UPDATE_LOGIN in NUMBER
306: ) is
307: begin
308: update AMS_WEB_RULES_B set
309: ACTIVITY_RULE_ID = X_ACTIVITY_RULE_ID,
310: RULE_PRIORITY = X_RULE_PRIORITY,
311: RELATIONSHIP_CODE = X_RELATIONSHIP_CODE,
312: CONTEXT_TYPE_CODE = X_CONTEXT_TYPE_CODE,

Line 366: delete from AMS_WEB_RULES_B

362: if (sql%notfound) then
363: raise no_data_found;
364: end if;
365:
366: delete from AMS_WEB_RULES_B
367: where RULE_ID = X_RULE_ID;
368:
369: if (sql%notfound) then
370: raise no_data_found;

Line 380: from AMS_WEB_RULES_B B

376: begin
377: delete from AMS_WEB_RULES_TL T
378: where not exists
379: (select NULL
380: from AMS_WEB_RULES_B B
381: where B.RULE_ID = T.RULE_ID
382: );
383:
384: update AMS_WEB_RULES_TL T set (