APPS.AHL_MC_RULES_PKG dependencies on AHL_MC_RULES_B

Line 35: cursor C is select ROWID from AHL_MC_RULES_B

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

Line 39: insert into AHL_MC_RULES_B (

35: cursor C is select ROWID from AHL_MC_RULES_B
36: where RULE_ID = X_RULE_ID
37: ;
38: begin
39: insert into AHL_MC_RULES_B (
40: ATTRIBUTE3,
41: ATTRIBUTE4,
42: ATTRIBUTE5,
43: ATTRIBUTE6,

Line 186: from AHL_MC_RULES_B

182: ACTIVE_START_DATE,
183: ACTIVE_END_DATE,
184: ATTRIBUTE_CATEGORY,
185: OBJECT_VERSION_NUMBER
186: from AHL_MC_RULES_B
187: where RULE_ID = X_RULE_ID
188: for update of RULE_ID nowait;
189: recinfo c%rowtype;
190:

Line 299: update AHL_MC_RULES_B set

295: X_LAST_UPDATED_BY in NUMBER,
296: X_LAST_UPDATE_LOGIN in NUMBER
297: ) is
298: begin
299: update AHL_MC_RULES_B set
300: ATTRIBUTE3 = X_ATTRIBUTE3,
301: ATTRIBUTE4 = X_ATTRIBUTE4,
302: ATTRIBUTE5 = X_ATTRIBUTE5,
303: ATTRIBUTE6 = X_ATTRIBUTE6,

Line 356: delete from AHL_MC_RULES_B

352: if (sql%notfound) then
353: raise no_data_found;
354: end if;
355:
356: delete from AHL_MC_RULES_B
357: where RULE_ID = X_RULE_ID;
358:
359: if (sql%notfound) then
360: raise no_data_found;

Line 370: from AHL_MC_RULES_B B

366: begin
367: delete from AHL_MC_RULES_TL T
368: where not exists
369: (select NULL
370: from AHL_MC_RULES_B B
371: where B.RULE_ID = T.RULE_ID
372: );
373:
374: update AHL_MC_RULES_TL T set (