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.XLA_POST_ACCT_PROGS_F_PKG dependencies on XLA_POST_ACCT_PROGS_TL

Line 123: INSERT INTO xla_post_acct_progs_tl

119: ,x_last_updated_by
120: ,x_last_update_login)
121: ;
122:
123: INSERT INTO xla_post_acct_progs_tl
124: (creation_date
125: ,program_code
126: ,program_owner_code
127: ,name

Line 151: FROM xla_post_acct_progs_tl t

147: FROM fnd_languages l
148: WHERE l.installed_flag IN ('I', 'B')
149: AND NOT EXISTS
150: (SELECT NULL
151: FROM xla_post_acct_progs_tl t
152: WHERE t.program_code = x_program_code
153: AND t.program_owner_code = x_program_owner_code
154: AND t.language = l.language_code);
155:

Line 201: FROM xla_post_acct_progs_tl

197: SELECT source_lang
198: ,name
199: ,description
200: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
201: FROM xla_post_acct_progs_tl
202: WHERE program_code = X_program_code
203: AND program_owner_code = X_program_owner_code
204: AND USERENV('LANG') IN (language ,source_lang)
205: FOR UPDATE OF program_code NOWAIT;

Line 306: UPDATE xla_post_acct_progs_tl

302: IF (SQL%NOTFOUND) THEN
303: RAISE NO_DATA_FOUND;
304: END IF;
305:
306: UPDATE xla_post_acct_progs_tl
307: SET
308: last_update_date = x_last_update_date
309: ,name = X_name
310: ,description = X_description

Line 354: DELETE FROM xla_post_acct_progs_tl

350: p_module => l_log_module,
351: p_level => C_LEVEL_PROCEDURE);
352: END IF;
353:
354: DELETE FROM xla_post_acct_progs_tl
355: WHERE program_code = x_program_code
356: AND program_owner_code = x_program_owner_code;
357:
358:

Line 400: DELETE FROM xla_post_acct_progs_tl T

396: p_module => l_log_module,
397: p_level => C_LEVEL_PROCEDURE);
398: END IF;
399:
400: DELETE FROM xla_post_acct_progs_tl T
401: WHERE NOT EXISTS
402: (SELECT NULL
403: FROM xla_post_acct_progs_b b
404: WHERE b.program_code = t.program_code

Line 407: UPDATE xla_post_acct_progs_tl t

403: FROM xla_post_acct_progs_b b
404: WHERE b.program_code = t.program_code
405: AND b.program_owner_code = t.program_owner_code);
406:
407: UPDATE xla_post_acct_progs_tl t
408: SET (name
409: ,description)
410: = (SELECT b.name
411: ,b.description

Line 412: FROM xla_post_acct_progs_tl b

408: SET (name
409: ,description)
410: = (SELECT b.name
411: ,b.description
412: FROM xla_post_acct_progs_tl b
413: WHERE b.program_code = t.program_code
414: AND b.program_owner_code = t.program_owner_code
415: AND b.language = t.source_lang)
416: WHERE (t.program_code

Line 422: FROM xla_post_acct_progs_tl subb

418: ,t.language)
419: IN (SELECT subt.program_code
420: ,subt.program_owner_code
421: ,subt.language
422: FROM xla_post_acct_progs_tl subb
423: ,xla_post_acct_progs_tl subt
424: WHERE subb.program_code = subt.program_code
425: AND subb.program_owner_code = subt.program_owner_code
426: AND subb.language = subt.source_lang

Line 423: ,xla_post_acct_progs_tl subt

419: IN (SELECT subt.program_code
420: ,subt.program_owner_code
421: ,subt.language
422: FROM xla_post_acct_progs_tl subb
423: ,xla_post_acct_progs_tl subt
424: WHERE subb.program_code = subt.program_code
425: AND subb.program_owner_code = subt.program_owner_code
426: AND subb.language = subt.source_lang
427: AND (SUBB.name <> SUBT.name

Line 436: INSERT INTO xla_post_acct_progs_tl

432: AND subt.description IS NULL)
433: ))
434: ;
435:
436: INSERT INTO xla_post_acct_progs_tl
437: (creation_date
438: ,program_code
439: ,program_owner_code
440: ,name

Line 460: FROM xla_post_acct_progs_tl b

456: ,b.last_update_login
457: ,b.created_by
458: ,l.language_code
459: ,b.source_lang
460: FROM xla_post_acct_progs_tl b
461: ,fnd_languages l
462: WHERE l.installed_flag IN ('I', 'B')
463: AND b.language = userenv('LANG')
464: AND NOT EXISTS

Line 466: FROM xla_post_acct_progs_tl t

462: WHERE l.installed_flag IN ('I', 'B')
463: AND b.language = userenv('LANG')
464: AND NOT EXISTS
465: (SELECT NULL
466: FROM xla_post_acct_progs_tl t
467: WHERE t.program_code = b.program_code
468: AND t.program_owner_code = b.program_owner_code
469: AND t.language = l.language_code);
470:

Line 626: FROM xla_post_acct_progs_tl

622:
623: BEGIN
624: SELECT last_updated_by, last_update_date
625: INTO db_luby, db_ludate
626: FROM xla_post_acct_progs_tl
627: WHERE program_code = p_program_code
628: AND program_owner_code = p_program_owner_code
629: AND language = userenv('LANG');
630:

Line 633: UPDATE xla_post_acct_progs_tl

629: AND language = userenv('LANG');
630:
631: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
632: db_ludate, p_custom_mode)) then
633: UPDATE xla_post_acct_progs_tl
634: SET name = p_name
635: ,description = p_description
636: ,last_update_date = f_ludate
637: ,last_updated_by = f_luby