APPS.EGO_USER_RULES_PKG dependencies on EGO_USER_RULES_B

Line 23: cursor C is select ROWID from EGO_USER_RULES_B

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from EGO_USER_RULES_B
24: where RULE_ID = X_RULE_ID
25: ;
26: begin
27: insert into EGO_USER_RULES_B (

Line 27: insert into EGO_USER_RULES_B (

23: cursor C is select ROWID from EGO_USER_RULES_B
24: where RULE_ID = X_RULE_ID
25: ;
26: begin
27: insert into EGO_USER_RULES_B (
28: RULE_ID,
29: RULESET_ID,
30: SEQUENCE,
31: RULE_NAME,

Line 121: from EGO_USER_RULES_B

117: ATTR_GROUP_NAME,
118: ATTR_NAME,
119: SEVERITY,
120: RULE_XML
121: from EGO_USER_RULES_B
122: where RULE_ID = X_RULE_ID
123: for update of RULE_ID nowait;
124: recinfo c%rowtype;
125:

Line 196: update EGO_USER_RULES_B set

192: X_LAST_UPDATED_BY in NUMBER,
193: X_LAST_UPDATE_LOGIN in NUMBER
194: ) is
195: begin
196: update EGO_USER_RULES_B set
197: RULESET_ID = X_RULESET_ID,
198: SEQUENCE = X_SEQUENCE,
199: RULE_NAME = X_RULE_NAME,
200: ATTR_GROUP_TYPE = X_ATTR_GROUP_TYPE,

Line 240: delete from EGO_USER_RULES_B

236: if (sql%notfound) then
237: raise no_data_found;
238: end if;
239:
240: delete from EGO_USER_RULES_B
241: where RULE_ID = X_RULE_ID;
242:
243: if (sql%notfound) then
244: raise no_data_found;

Line 254: from EGO_USER_RULES_B B

250: begin
251: delete from EGO_USER_RULES_TL T
252: where not exists
253: (select NULL
254: from EGO_USER_RULES_B B
255: where B.RULE_ID = T.RULE_ID
256: );
257:
258: update EGO_USER_RULES_TL T set (