eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_CLIK_THRU_ACT_PARAM_PKG dependencies on AMS_CLIK_THRU_ACT_PARAMS_TL

Line 27: cursor ctl is select ROWID from AMS_CLIK_THRU_ACT_PARAMS_TL

23: is
24: cursor c is select ROWID from AMS_CLIK_THRU_ACT_PARAMS_B
25: where ACTION_PARAM_ID = X_ACTION_PARAM_ID
26: ;
27: cursor ctl is select ROWID from AMS_CLIK_THRU_ACT_PARAMS_TL
28: where ACTION_PARAM_ID = X_ACTION_PARAM_ID
29: ;
30: begin
31:

Line 74: insert into AMS_CLIK_THRU_ACT_PARAMS_TL (

70: raise no_data_found;
71: end if;
72: close c;
73:
74: insert into AMS_CLIK_THRU_ACT_PARAMS_TL (
75: ACTION_PARAM_ID
76: ,ACTION_PARAM_CODE_MEANING
77: ,DESCRIPTION
78: ,LANGUAGE

Line 101: FROM AMS_CLIK_THRU_ACT_PARAMS_TL T

97: FROM fnd_languages l
98: WHERE l.installed_flag IN ('I', 'B')
99: AND NOT EXISTS
100: (SELECT NULL
101: FROM AMS_CLIK_THRU_ACT_PARAMS_TL T
102: WHERE T.ACTION_PARAM_ID = X_ACTION_PARAM_ID
103: AND T.LANGUAGE = l.language_code);
104:
105: open ctl;

Line 154: FROM AMS_CLIK_THRU_ACT_PARAMS_TL

150: CURSOR ctl IS SELECT
151: ACTION_PARAM_CODE_MEANING,
152: DESCRIPTION,
153: DECODE(LANGUAGE, USERENV('lang'), 'y', 'n') baselang
154: FROM AMS_CLIK_THRU_ACT_PARAMS_TL
155: WHERE ACTION_PARAM_ID = X_ACTION_PARAM_ID
156: AND USERENV('lang') IN (LANGUAGE, source_lang)
157: FOR UPDATE OF ACTION_PARAM_ID NOWAIT;
158:

Line 254: update AMS_CLIK_THRU_ACT_PARAMS_TL set

250: if (sql%notfound) then
251: raise no_data_found;
252: end if;
253:
254: update AMS_CLIK_THRU_ACT_PARAMS_TL set
255: ACTION_PARAM_CODE_MEANING = X_ACTION_PARAM_CODE_MEANING,
256: DESCRIPTION = X_DESCRIPTION,
257: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
258: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 275: delete from AMS_CLIK_THRU_ACT_PARAMS_TL

271: X_ACTION_PARAM_ID in NUMBER
272: )
273: is
274: begin
275: delete from AMS_CLIK_THRU_ACT_PARAMS_TL
276: where ACTION_PARAM_ID = X_ACTION_PARAM_ID;
277:
278: if (sql%notfound) then
279: raise no_data_found;

Line 404: FROM AMS_CLIK_THRU_ACT_PARAMS_TL

400: )
401: IS
402: cursor c_last_updated_by is
403: select last_updated_by
404: FROM AMS_CLIK_THRU_ACT_PARAMS_TL
405: where ACTION_PARAM_ID = X_ACTION_PARAM_ID
406: and USERENV('LANG') = LANGUAGE;
407:
408: l_last_updated_by number;

Line 420: UPDATE AMS_CLIK_THRU_ACT_PARAMS_TL

416: if (l_last_updated_by in (1,2,0) OR
417: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
418:
419: -- Only update rows which have not been altered by user
420: UPDATE AMS_CLIK_THRU_ACT_PARAMS_TL
421: SET description = X_DESCRIPTION,
422: action_param_code_meaning = X_ACTION_PARAM_CODE_MEANING,
423: source_lang = USERENV('LANG'),
424: last_update_date = SYSDATE,

Line 439: DELETE FROM AMS_CLIK_THRU_ACT_PARAMS_TL T

435:
436: PROCEDURE ADD_LANGUAGE
437: IS
438: BEGIN
439: DELETE FROM AMS_CLIK_THRU_ACT_PARAMS_TL T
440: WHERE NOT EXISTS
441: (SELECT NULL
442: FROM AMS_CLIK_THRU_ACT_PARAMS_B B
443: WHERE B.ACTION_PARAM_ID = T.ACTION_PARAM_ID

Line 446: UPDATE AMS_CLIK_THRU_ACT_PARAMS_TL T SET (

442: FROM AMS_CLIK_THRU_ACT_PARAMS_B B
443: WHERE B.ACTION_PARAM_ID = T.ACTION_PARAM_ID
444: );
445:
446: UPDATE AMS_CLIK_THRU_ACT_PARAMS_TL T SET (
447: ACTION_PARAM_CODE_MEANING,
448: DESCRIPTION
449: ) =
450: (SELECT

Line 453: FROM AMS_CLIK_THRU_ACT_PARAMS_TL T1

449: ) =
450: (SELECT
451: T1.ACTION_PARAM_CODE_MEANING,
452: T1.DESCRIPTION
453: FROM AMS_CLIK_THRU_ACT_PARAMS_TL T1
454: WHERE T1.ACTION_PARAM_ID = T.ACTION_PARAM_ID
455: AND T1.LANGUAGE = T.SOURCE_LANG)
456: WHERE (
457: T.ACTION_PARAM_ID,

Line 463: FROM AMS_CLIK_THRU_ACT_PARAMS_TL subb, AMS_CLIK_THRU_ACT_PARAMS_TL subt

459: ) IN
460: (SELECT
461: subt.ACTION_PARAM_ID,
462: subt.LANGUAGE
463: FROM AMS_CLIK_THRU_ACT_PARAMS_TL subb, AMS_CLIK_THRU_ACT_PARAMS_TL subt
464: WHERE subb.ACTION_PARAM_ID = subt.ACTION_PARAM_ID
465: AND subb.LANGUAGE = subt.SOURCE_LANG
466: AND (subb.ACTION_PARAM_CODE_MEANING <> subt.ACTION_PARAM_CODE_MEANING
467: OR subb.DESCRIPTION <> subt.DESCRIPTION

Line 472: INSERT INTO AMS_CLIK_THRU_ACT_PARAMS_TL (

468: OR (subb.DESCRIPTION IS NULL AND subt.DESCRIPTION IS NOT NULL)
469: OR (subb.DESCRIPTION IS NOT NULL AND subt.DESCRIPTION IS NULL)
470: ));
471:
472: INSERT INTO AMS_CLIK_THRU_ACT_PARAMS_TL (
473: action_param_id,
474: action_param_code_meaning,
475: description,
476: created_by,

Line 494: FROM AMS_CLIK_THRU_ACT_PARAMS_TL b, fnd_languages l

490: b.last_update_date,
491: b.last_update_login,
492: l.language_code,
493: b.source_lang
494: FROM AMS_CLIK_THRU_ACT_PARAMS_TL b, fnd_languages l
495: WHERE l.installed_flag IN ('I', 'B')
496: AND b.LANGUAGE = USERENV('lang')
497: AND NOT EXISTS
498: (SELECT NULL

Line 499: FROM AMS_CLIK_THRU_ACT_PARAMS_TL T

495: WHERE l.installed_flag IN ('I', 'B')
496: AND b.LANGUAGE = USERENV('lang')
497: AND NOT EXISTS
498: (SELECT NULL
499: FROM AMS_CLIK_THRU_ACT_PARAMS_TL T
500: WHERE T.action_param_id = b.action_param_id
501: AND T.LANGUAGE = l.language_code);
502: END add_language;
503: