APPS.EGO_RULE_SETS_PKG dependencies on EGO_RULE_SETS_B

Line 20: cursor C is select ROWID from EGO_RULE_SETS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from EGO_RULE_SETS_B
21: where RULESET_ID = X_RULESET_ID
22: ;
23: begin
24: insert into EGO_RULE_SETS_B (

Line 24: insert into EGO_RULE_SETS_B (

20: cursor C is select ROWID from EGO_RULE_SETS_B
21: where RULESET_ID = X_RULESET_ID
22: ;
23: begin
24: insert into EGO_RULE_SETS_B (
25: ATTR_GROUP_TYPE,
26: RULESET_ID,
27: RULESET_NAME,
28: RULESET_TYPE,

Line 110: from EGO_RULE_SETS_B

106: RULESET_TYPE,
107: COMPOSITE,
108: ITEM_CATALOG_CATEGORY,
109: ATTR_GROUP_NAME
110: from EGO_RULE_SETS_B
111: where RULESET_ID = X_RULESET_ID
112: for update of RULESET_ID nowait;
113: recinfo c%rowtype;
114:

Line 180: update EGO_RULE_SETS_B set

176: X_LAST_UPDATED_BY in NUMBER,
177: X_LAST_UPDATE_LOGIN in NUMBER
178: ) is
179: begin
180: update EGO_RULE_SETS_B set
181: ATTR_GROUP_TYPE = X_ATTR_GROUP_TYPE,
182: RULESET_NAME = X_RULESET_NAME,
183: RULESET_TYPE = X_RULESET_TYPE,
184: COMPOSITE = X_COMPOSITE,

Line 222: delete from EGO_RULE_SETS_B

218: if (sql%notfound) then
219: raise no_data_found;
220: end if;
221:
222: delete from EGO_RULE_SETS_B
223: where RULESET_ID = X_RULESET_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;

Line 236: from EGO_RULE_SETS_B B

232: begin
233: delete from EGO_RULE_SETS_TL T
234: where not exists
235: (select NULL
236: from EGO_RULE_SETS_B B
237: where B.RULESET_ID = T.RULESET_ID
238: );
239:
240: update EGO_RULE_SETS_TL T set (

Line 338: from EGO_RULE_SETS_B

334: l_ruleset_id number := 0;
335:
336: begin
337: select RULESET_ID into l_ruleset_id
338: from EGO_RULE_SETS_B
339: where RULESET_NAME = X_RULESET_NAME;
340:
341: EGO_RULE_SETS_PKG.UPDATE_ROW(
342: X_RULESET_ID => l_ruleset_id,