APPS.EGO_RULE_SETS_PKG dependencies on EGO_RULE_SETS_TL

Line 52: insert into EGO_RULE_SETS_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into EGO_RULE_SETS_TL (
53: RULESET_ID,
54: RULESET_DISPLAY_NAME,
55: DESCRIPTION,
56: LAST_UPDATE_DATE,

Line 78: from EGO_RULE_SETS_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from EGO_RULE_SETS_TL T
79: where T.RULESET_ID = X_RULESET_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from EGO_RULE_SETS_TL

115: cursor c1 is select
116: RULESET_DISPLAY_NAME,
117: DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from EGO_RULE_SETS_TL
120: where RULESET_ID = X_RULESET_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of RULESET_ID nowait;
123: begin

Line 196: update EGO_RULE_SETS_TL set

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195:
196: update EGO_RULE_SETS_TL set
197: RULESET_DISPLAY_NAME = X_RULESET_DISPLAY_NAME,
198: DESCRIPTION = X_DESCRIPTION,
199: LAST_UPDATE_DATE = Nvl(X_LAST_UPDATE_DATE,SYSDATE),
200: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 215: delete from EGO_RULE_SETS_TL

211: procedure DELETE_ROW (
212: X_RULESET_ID in NUMBER
213: ) is
214: begin
215: delete from EGO_RULE_SETS_TL
216: where RULESET_ID = X_RULESET_ID;
217:
218: if (sql%notfound) then
219: raise no_data_found;

Line 233: delete from EGO_RULE_SETS_TL T

229:
230: procedure ADD_LANGUAGE
231: is
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

Line 240: update EGO_RULE_SETS_TL T set (

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 (
241: RULESET_DISPLAY_NAME,
242: DESCRIPTION
243: ) = (select
244: B.RULESET_DISPLAY_NAME,

Line 246: from EGO_RULE_SETS_TL B

242: DESCRIPTION
243: ) = (select
244: B.RULESET_DISPLAY_NAME,
245: B.DESCRIPTION
246: from EGO_RULE_SETS_TL B
247: where B.RULESET_ID = T.RULESET_ID
248: and B.LANGUAGE = T.SOURCE_LANG)
249: where (
250: T.RULESET_ID,

Line 255: from EGO_RULE_SETS_TL SUBB, EGO_RULE_SETS_TL SUBT

251: T.LANGUAGE
252: ) in (select
253: SUBT.RULESET_ID,
254: SUBT.LANGUAGE
255: from EGO_RULE_SETS_TL SUBB, EGO_RULE_SETS_TL SUBT
256: where SUBB.RULESET_ID = SUBT.RULESET_ID
257: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
258: and (SUBB.RULESET_DISPLAY_NAME <> SUBT.RULESET_DISPLAY_NAME
259: or (SUBB.RULESET_DISPLAY_NAME is null and SUBT.RULESET_DISPLAY_NAME is not null)

Line 266: insert into EGO_RULE_SETS_TL (

262: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
263: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
264: ));
265:
266: insert into EGO_RULE_SETS_TL (
267: RULESET_ID,
268: RULESET_DISPLAY_NAME,
269: DESCRIPTION,
270: LAST_UPDATE_DATE,

Line 288: from EGO_RULE_SETS_TL B, FND_LANGUAGES L

284: B.CREATED_BY,
285: B.LAST_UPDATE_LOGIN,
286: L.LANGUAGE_CODE,
287: B.SOURCE_LANG
288: from EGO_RULE_SETS_TL B, FND_LANGUAGES L
289: where L.INSTALLED_FLAG in ('I', 'B')
290: and B.LANGUAGE = userenv('LANG')
291: and not exists
292: (select NULL

Line 293: from EGO_RULE_SETS_TL T

289: where L.INSTALLED_FLAG in ('I', 'B')
290: and B.LANGUAGE = userenv('LANG')
291: and not exists
292: (select NULL
293: from EGO_RULE_SETS_TL T
294: where T.RULESET_ID = B.RULESET_ID
295: and T.LANGUAGE = L.LANGUAGE_CODE);
296: end ADD_LANGUAGE;
297:

Line 305: update EGO_RULE_SETS_TL set

301: X_DESCRIPTION in VARCHAR2,
302: X_OWNER in VARCHAR2
303: ) is
304: begin
305: update EGO_RULE_SETS_TL set
306: RULESET_DISPLAY_NAME = X_RULESET_DISPLAY_NAME,
307: DESCRIPTION = X_DESCRIPTION,
308: LAST_UPDATE_DATE = sysdate,
309: LAST_UPDATED_BY = decode(x_owner, 'ORACLE', 1, 0),