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_PKG dependencies on AMS_CLIK_THRU_ACTIONS_TL

Line 31: cursor ctl is select ROWID from AMS_CLIK_THRU_ACTIONS_TL

27: ) is
28: cursor c is select ROWID from AMS_CLIK_THRU_ACTIONS_B
29: where ACTION_ID = X_ACTION_ID
30: ;
31: cursor ctl is select ROWID from AMS_CLIK_THRU_ACTIONS_TL
32: where ACTION_ID = X_ACTION_ID
33: ;
34: begin
35: insert into AMS_CLIK_THRU_ACTIONS_B (

Line 87: insert into AMS_CLIK_THRU_ACTIONS_TL (

83: raise no_data_found;
84: end if;
85: close c;
86:
87: insert into AMS_CLIK_THRU_ACTIONS_TL (
88: ACTION_ID
89: ,ACTION_CODE_MEANING
90: ,DESCRIPTION
91: ,LANGUAGE

Line 114: FROM AMS_CLIK_THRU_ACTIONS_TL T

110: FROM fnd_languages l
111: WHERE l.installed_flag IN ('I', 'B')
112: AND NOT EXISTS
113: (SELECT NULL
114: FROM AMS_CLIK_THRU_ACTIONS_TL T
115: WHERE T.ACTION_ID = X_ACTION_ID
116: AND T.LANGUAGE = l.language_code);
117:
118: open ctl;

Line 184: from AMS_CLIK_THRU_ACTIONS_TL

180: ,LAST_UPDATED_BY
181: ,CREATION_DATE
182: ,CREATED_BY
183: ,LAST_UPDATE_LOGIN
184: from AMS_CLIK_THRU_ACTIONS_TL
185: where ACTION_ID = X_ACTION_ID
186: for update of ACTION_ID nowait;
187: tlrecinfo ctl%rowtype;
188: */

Line 194: FROM AMS_CLIK_THRU_ACTIONS_TL

190: CURSOR ctl IS SELECT
191: ACTION_CODE_MEANING,
192: DESCRIPTION,
193: DECODE(LANGUAGE, USERENV('lang'), 'y', 'n') baselang
194: FROM AMS_CLIK_THRU_ACTIONS_TL
195: WHERE ACTION_ID = X_ACTION_ID
196: AND USERENV('lang') IN (LANGUAGE, source_lang)
197: FOR UPDATE OF ACTION_ID NOWAIT;
198:

Line 307: update AMS_CLIK_THRU_ACTIONS_TL set

303: if (sql%notfound) then
304: raise no_data_found;
305: end if;
306:
307: update AMS_CLIK_THRU_ACTIONS_TL set
308: ACTION_CODE_MEANING = X_ACTION_CODE_MEANING,
309: DESCRIPTION = X_DESCRIPTION,
310: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
311: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 327: delete from AMS_CLIK_THRU_ACTIONS_TL

323: procedure DELETE_ROW (
324: X_ACTION_ID in NUMBER
325: ) is
326: begin
327: delete from AMS_CLIK_THRU_ACTIONS_TL
328: where ACTION_ID = X_ACTION_ID;
329:
330: if (sql%notfound) then
331: raise no_data_found;

Line 383: from AMS_CLIK_THRU_ACTIONS_TL

379: where ACTION_ID = X_ACTION_ID;
380:
381: cursor ctl_chk_cta_exists is
382: select 'x'
383: from AMS_CLIK_THRU_ACTIONS_TL
384: where ACTION_ID = X_ACTION_ID;
385:
386: BEGIN
387:

Line 474: from AMS_CLIK_THRU_ACTIONS_TL

470: , X_CUSTOM_MODE IN VARCHAR2
471: ) IS
472: cursor c_last_updated_by is
473: select last_updated_by
474: from AMS_CLIK_THRU_ACTIONS_TL
475: where ACTION_ID = X_ACTION_ID
476: and USERENV('LANG') = LANGUAGE;
477:
478: l_last_updated_by number;

Line 491: UPDATE AMS_CLIK_THRU_ACTIONS_TL

487: if (l_last_updated_by in (1,2,0) OR
488: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
489: -- Only update rows which have not been altered by user
490:
491: UPDATE AMS_CLIK_THRU_ACTIONS_TL
492: SET description = X_DESCRIPTION,
493: action_code_meaning = X_ACTION_CODE_MEANING,
494: source_lang = USERENV('LANG'),
495: last_update_date = SYSDATE,

Line 510: DELETE FROM AMS_CLIK_THRU_ACTIONS_TL T

506:
507: PROCEDURE add_language
508: IS
509: BEGIN
510: DELETE FROM AMS_CLIK_THRU_ACTIONS_TL T
511: WHERE NOT EXISTS
512: (SELECT NULL
513: FROM AMS_CLIK_THRU_ACTIONS_B B
514: WHERE B.ACTION_ID = T.ACTION_ID

Line 517: UPDATE AMS_CLIK_THRU_ACTIONS_TL T SET (

513: FROM AMS_CLIK_THRU_ACTIONS_B B
514: WHERE B.ACTION_ID = T.ACTION_ID
515: );
516:
517: UPDATE AMS_CLIK_THRU_ACTIONS_TL T SET (
518: ACTION_CODE_MEANING,
519: DESCRIPTION
520: ) =
521: (SELECT

Line 524: FROM AMS_CLIK_THRU_ACTIONS_TL T1

520: ) =
521: (SELECT
522: T1.ACTION_CODE_MEANING,
523: T1.DESCRIPTION
524: FROM AMS_CLIK_THRU_ACTIONS_TL T1
525: WHERE T1.ACTION_ID = T.ACTION_ID
526: AND T1.LANGUAGE = T.SOURCE_LANG)
527: WHERE (
528: T.ACTION_ID,

Line 534: FROM AMS_CLIK_THRU_ACTIONS_TL subb, AMS_CLIK_THRU_ACTIONS_TL subt

530: ) IN
531: (SELECT
532: subt.ACTION_ID,
533: subt.LANGUAGE
534: FROM AMS_CLIK_THRU_ACTIONS_TL subb, AMS_CLIK_THRU_ACTIONS_TL subt
535: WHERE subb.ACTION_ID = subt.ACTION_ID
536: AND subb.LANGUAGE = subt.SOURCE_LANG
537: AND (subb.ACTION_CODE_MEANING <> subt.ACTION_CODE_MEANING
538: OR subb.DESCRIPTION <> subt.DESCRIPTION

Line 543: INSERT INTO AMS_CLIK_THRU_ACTIONS_TL (

539: OR (subb.DESCRIPTION IS NULL AND subt.DESCRIPTION IS NOT NULL)
540: OR (subb.DESCRIPTION IS NOT NULL AND subt.DESCRIPTION IS NULL)
541: ));
542:
543: INSERT INTO AMS_CLIK_THRU_ACTIONS_TL (
544: action_id,
545: action_code_meaning,
546: description,
547: created_by,

Line 565: FROM ams_clik_thru_actions_tl b, fnd_languages l

561: b.last_update_date,
562: b.last_update_login,
563: l.language_code,
564: b.source_lang
565: FROM ams_clik_thru_actions_tl b, fnd_languages l
566: WHERE l.installed_flag IN ('I', 'B')
567: AND b.LANGUAGE = USERENV('lang')
568: AND NOT EXISTS
569: (SELECT NULL

Line 570: FROM ams_clik_thru_actions_tl T

566: WHERE l.installed_flag IN ('I', 'B')
567: AND b.LANGUAGE = USERENV('lang')
568: AND NOT EXISTS
569: (SELECT NULL
570: FROM ams_clik_thru_actions_tl T
571: WHERE T.action_id = b.action_id
572: AND T.LANGUAGE = l.language_code);
573: END add_language;
574: