APPS.EGO_USER_RULES_PKG dependencies on EGO_USER_RULES_TL

Line 59: insert into EGO_USER_RULES_TL (

55: X_LAST_UPDATED_BY,
56: X_LAST_UPDATE_LOGIN
57: );
58:
59: insert into EGO_USER_RULES_TL (
60: RULE_ID,
61: DESCRIPTION,
62: USER_EXPLANATION_MESSAGE,
63: LAST_UPDATE_DATE,

Line 85: from EGO_USER_RULES_TL T

81: from FND_LANGUAGES L
82: where L.INSTALLED_FLAG in ('I', 'B')
83: and not exists
84: (select NULL
85: from EGO_USER_RULES_TL T
86: where T.RULE_ID = X_RULE_ID
87: and T.LANGUAGE = L.LANGUAGE_CODE);
88:
89: open c;

Line 130: from EGO_USER_RULES_TL

126: cursor c1 is select
127: DESCRIPTION,
128: USER_EXPLANATION_MESSAGE,
129: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
130: from EGO_USER_RULES_TL
131: where RULE_ID = X_RULE_ID
132: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
133: for update of RULE_ID nowait;
134: begin

Line 214: update EGO_USER_RULES_TL set

210: if (sql%notfound) then
211: raise no_data_found;
212: end if;
213:
214: update EGO_USER_RULES_TL set
215: DESCRIPTION = X_DESCRIPTION,
216: USER_EXPLANATION_MESSAGE = X_USER_EXPLANATION_MESSAGE,
217: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
218: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 233: delete from EGO_USER_RULES_TL

229: procedure DELETE_ROW (
230: X_RULE_ID in NUMBER
231: ) is
232: begin
233: delete from EGO_USER_RULES_TL
234: where RULE_ID = X_RULE_ID;
235:
236: if (sql%notfound) then
237: raise no_data_found;

Line 251: delete from EGO_USER_RULES_TL T

247:
248: procedure ADD_LANGUAGE
249: is
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

Line 258: update EGO_USER_RULES_TL T set (

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 (
259: DESCRIPTION,
260: USER_EXPLANATION_MESSAGE
261: ) = (select
262: B.DESCRIPTION,

Line 264: from EGO_USER_RULES_TL B

260: USER_EXPLANATION_MESSAGE
261: ) = (select
262: B.DESCRIPTION,
263: B.USER_EXPLANATION_MESSAGE
264: from EGO_USER_RULES_TL B
265: where B.RULE_ID = T.RULE_ID
266: and B.LANGUAGE = T.SOURCE_LANG)
267: where (
268: T.RULE_ID,

Line 273: from EGO_USER_RULES_TL SUBB, EGO_USER_RULES_TL SUBT

269: T.LANGUAGE
270: ) in (select
271: SUBT.RULE_ID,
272: SUBT.LANGUAGE
273: from EGO_USER_RULES_TL SUBB, EGO_USER_RULES_TL SUBT
274: where SUBB.RULE_ID = SUBT.RULE_ID
275: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
276: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
277: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 284: insert into EGO_USER_RULES_TL (

280: or (SUBB.USER_EXPLANATION_MESSAGE is null and SUBT.USER_EXPLANATION_MESSAGE is not null)
281: or (SUBB.USER_EXPLANATION_MESSAGE is not null and SUBT.USER_EXPLANATION_MESSAGE is null)
282: ));
283:
284: insert into EGO_USER_RULES_TL (
285: RULE_ID,
286: DESCRIPTION,
287: USER_EXPLANATION_MESSAGE,
288: LAST_UPDATE_DATE,

Line 306: from EGO_USER_RULES_TL B, FND_LANGUAGES L

302: B.CREATED_BY,
303: B.LAST_UPDATE_LOGIN,
304: L.LANGUAGE_CODE,
305: B.SOURCE_LANG
306: from EGO_USER_RULES_TL B, FND_LANGUAGES L
307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL

Line 311: from EGO_USER_RULES_TL T

307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL
311: from EGO_USER_RULES_TL T
312: where T.RULE_ID = B.RULE_ID
313: and T.LANGUAGE = L.LANGUAGE_CODE);
314: end ADD_LANGUAGE;
315:

Line 323: update EGO_USER_RULES_TL set

319: X_DESCRIPTION in VARCHAR2,
320: X_OWNER in VARCHAR2
321: ) is
322: begin
323: update EGO_USER_RULES_TL set
324: USER_EXPLANATION_MESSAGE = X_USER_EXPLANATION_MESSAGE,
325: DESCRIPTION = X_DESCRIPTION,
326: LAST_UPDATE_DATE = sysdate,
327: LAST_UPDATED_BY = decode(x_owner, 'ORACLE', 1, 0),