APPS.AMS_WEB_RULES_PKG dependencies on AMS_WEB_RULES_TL

Line 101: insert into AMS_WEB_RULES_TL (

97: X_LAST_UPDATED_BY,
98: X_LAST_UPDATE_LOGIN
99: );
100:
101: insert into AMS_WEB_RULES_TL (
102: OBJECT_VERSION_NUMBER,
103: CREATED_BY,
104: CREATION_DATE,
105: LAST_UPDATED_BY,

Line 127: from AMS_WEB_RULES_TL T

123: from FND_LANGUAGES L
124: where L.INSTALLED_FLAG in ('I', 'B')
125: and not exists
126: (select NULL
127: from AMS_WEB_RULES_TL T
128: where T.RULE_ID = X_RULE_ID
129: and T.LANGUAGE = L.LANGUAGE_CODE);
130:
131: open c;

Line 200: from AMS_WEB_RULES_TL

196:
197: cursor c1 is select
198: RULE_NAME,
199: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
200: from AMS_WEB_RULES_TL
201: where RULE_ID = X_RULE_ID
202: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
203: for update of RULE_ID nowait;
204: begin

Line 341: update AMS_WEB_RULES_TL set

337: if (sql%notfound) then
338: raise no_data_found;
339: end if;
340:
341: update AMS_WEB_RULES_TL set
342: RULE_NAME = X_RULE_NAME,
343: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
344: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
345: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 359: delete from AMS_WEB_RULES_TL

355: procedure DELETE_ROW (
356: X_RULE_ID in NUMBER
357: ) is
358: begin
359: delete from AMS_WEB_RULES_TL
360: where RULE_ID = X_RULE_ID;
361:
362: if (sql%notfound) then
363: raise no_data_found;

Line 377: delete from AMS_WEB_RULES_TL T

373:
374: procedure ADD_LANGUAGE
375: is
376: begin
377: delete from AMS_WEB_RULES_TL T
378: where not exists
379: (select NULL
380: from AMS_WEB_RULES_B B
381: where B.RULE_ID = T.RULE_ID

Line 384: update AMS_WEB_RULES_TL T set (

380: from AMS_WEB_RULES_B B
381: where B.RULE_ID = T.RULE_ID
382: );
383:
384: update AMS_WEB_RULES_TL T set (
385: RULE_NAME
386: ) = (select
387: B.RULE_NAME
388: from AMS_WEB_RULES_TL B

Line 388: from AMS_WEB_RULES_TL B

384: update AMS_WEB_RULES_TL T set (
385: RULE_NAME
386: ) = (select
387: B.RULE_NAME
388: from AMS_WEB_RULES_TL B
389: where B.RULE_ID = T.RULE_ID
390: and B.LANGUAGE = T.SOURCE_LANG)
391: where (
392: T.RULE_ID,

Line 397: from AMS_WEB_RULES_TL SUBB, AMS_WEB_RULES_TL SUBT

393: T.LANGUAGE
394: ) in (select
395: SUBT.RULE_ID,
396: SUBT.LANGUAGE
397: from AMS_WEB_RULES_TL SUBB, AMS_WEB_RULES_TL SUBT
398: where SUBB.RULE_ID = SUBT.RULE_ID
399: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
400: and (SUBB.RULE_NAME <> SUBT.RULE_NAME
401: or (SUBB.RULE_NAME is null and SUBT.RULE_NAME is not null)

Line 405: insert into AMS_WEB_RULES_TL (

401: or (SUBB.RULE_NAME is null and SUBT.RULE_NAME is not null)
402: or (SUBB.RULE_NAME is not null and SUBT.RULE_NAME is null)
403: ));
404:
405: insert into AMS_WEB_RULES_TL (
406: OBJECT_VERSION_NUMBER,
407: CREATED_BY,
408: CREATION_DATE,
409: LAST_UPDATED_BY,

Line 427: from AMS_WEB_RULES_TL B, FND_LANGUAGES L

423: B.RULE_ID,
424: B.RULE_NAME,
425: L.LANGUAGE_CODE,
426: B.SOURCE_LANG
427: from AMS_WEB_RULES_TL B, FND_LANGUAGES L
428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL

Line 432: from AMS_WEB_RULES_TL T

428: where L.INSTALLED_FLAG in ('I', 'B')
429: and B.LANGUAGE = userenv('LANG')
430: and not exists
431: (select NULL
432: from AMS_WEB_RULES_TL T
433: where T.RULE_ID = B.RULE_ID
434: and T.LANGUAGE = L.LANGUAGE_CODE);
435: end ADD_LANGUAGE;
436: