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_ASSIGNMENT_DEFNS_F_PKG dependencies on XLA_ASSIGNMENT_DEFNS_TL

Line 133: INSERT INTO xla_assignment_defns_tl

129: ,x_last_updated_by
130: ,x_last_update_login)
131: ;
132:
133: INSERT INTO xla_assignment_defns_tl
134: (creation_date
135: ,program_code
136: ,program_owner_code
137: ,assignment_code

Line 163: FROM xla_assignment_defns_tl t

159: FROM fnd_languages l
160: WHERE l.installed_flag IN ('I', 'B')
161: AND NOT EXISTS
162: (SELECT NULL
163: FROM xla_assignment_defns_tl t
164: WHERE t.program_code = x_program_code
165: AND t.program_owner_code = x_program_owner_code
166: AND t.assignment_code = x_assignment_code
167: AND t.assignment_owner_code = x_assignment_owner_code

Line 218: FROM xla_assignment_defns_tl

214: CURSOR c1 IS
215: SELECT source_lang
216: ,name
217: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
218: FROM xla_assignment_defns_tl
219: WHERE program_code = X_program_code
220: AND program_owner_code = X_program_owner_code
221: AND assignment_code = x_assignment_code
222: AND assignment_owner_code = x_assignment_owner_code

Line 330: UPDATE xla_assignment_defns_tl

326: IF (SQL%NOTFOUND) THEN
327: RAISE NO_DATA_FOUND;
328: END IF;
329:
330: UPDATE xla_assignment_defns_tl
331: SET
332: last_update_date = x_last_update_date
333: ,name = X_name
334: ,last_updated_by = x_last_updated_by

Line 381: DELETE FROM xla_assignment_defns_tl

377: p_module => l_log_module,
378: p_level => C_LEVEL_PROCEDURE);
379: END IF;
380:
381: DELETE FROM xla_assignment_defns_tl
382: WHERE program_code = x_program_code
383: AND program_owner_code = x_program_owner_code
384: AND assignment_code = x_assignment_code
385: AND assignment_owner_code = x_assignment_owner_code;

Line 431: DELETE FROM xla_assignment_defns_tl T

427: p_module => l_log_module,
428: p_level => C_LEVEL_PROCEDURE);
429: END IF;
430:
431: DELETE FROM xla_assignment_defns_tl T
432: WHERE NOT EXISTS
433: (SELECT NULL
434: FROM xla_assignment_defns_b b
435: WHERE b.program_code = t.program_code

Line 440: UPDATE xla_assignment_defns_tl t

436: AND b.program_owner_code = t.program_owner_code
437: AND b.assignment_code = t.assignment_code
438: AND b.assignment_owner_code = t.assignment_owner_code);
439:
440: UPDATE xla_assignment_defns_tl t
441: SET (name)
442: = (SELECT b.name
443: FROM xla_assignment_defns_tl b
444: WHERE b.program_code = t.program_code

Line 443: FROM xla_assignment_defns_tl b

439:
440: UPDATE xla_assignment_defns_tl t
441: SET (name)
442: = (SELECT b.name
443: FROM xla_assignment_defns_tl b
444: WHERE b.program_code = t.program_code
445: AND b.program_owner_code = t.program_owner_code
446: AND b.assignment_code = t.assignment_code
447: AND b.assignment_owner_code = t.assignment_owner_code

Line 459: FROM xla_assignment_defns_tl subb

455: ,subt.program_owner_code
456: ,subt.assignment_code
457: ,subt.assignment_owner_code
458: ,subt.language
459: FROM xla_assignment_defns_tl subb
460: ,xla_assignment_defns_tl subt
461: WHERE subb.program_code = subt.program_code
462: AND subb.program_owner_code = subt.program_owner_code
463: AND subb.assignment_code = subt.assignment_code

Line 460: ,xla_assignment_defns_tl subt

456: ,subt.assignment_code
457: ,subt.assignment_owner_code
458: ,subt.language
459: FROM xla_assignment_defns_tl subb
460: ,xla_assignment_defns_tl subt
461: WHERE subb.program_code = subt.program_code
462: AND subb.program_owner_code = subt.program_owner_code
463: AND subb.assignment_code = subt.assignment_code
464: AND subb.assignment_owner_code = subt.assignment_owner_code

Line 470: INSERT INTO xla_assignment_defns_tl

466: AND (SUBB.name <> SUBT.name
467: ))
468: ;
469:
470: INSERT INTO xla_assignment_defns_tl
471: (creation_date
472: ,program_code
473: ,program_owner_code
474: ,assignment_code

Line 496: FROM xla_assignment_defns_tl b

492: ,b.last_update_login
493: ,b.created_by
494: ,l.language_code
495: ,b.source_lang
496: FROM xla_assignment_defns_tl b
497: ,fnd_languages l
498: WHERE l.installed_flag IN ('I', 'B')
499: AND b.language = userenv('LANG')
500: AND NOT EXISTS

Line 502: FROM xla_assignment_defns_tl t

498: WHERE l.installed_flag IN ('I', 'B')
499: AND b.language = userenv('LANG')
500: AND NOT EXISTS
501: (SELECT NULL
502: FROM xla_assignment_defns_tl t
503: WHERE t.program_code = b.program_code
504: AND t.program_owner_code = b.program_owner_code
505: AND t.assignment_code = b.assignment_code
506: AND t.assignment_owner_code = b.assignment_owner_code

Line 677: FROM xla_assignment_defns_tl

673: -- post accounting program has multiple assignments.
674: BEGIN
675: SELECT last_updated_by, last_update_date
676: INTO db_luby, db_ludate
677: FROM xla_assignment_defns_tl
678: WHERE program_code = p_program_code
679: AND program_owner_code = p_program_owner_code
680: AND assignment_code = p_assignment_code -- changed to parameter 14074384
681: AND assignment_owner_code = p_assignment_owner_code -- changed to parameter 14074384

Line 686: UPDATE xla_assignment_defns_tl

682: AND language = userenv('LANG');
683:
684: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
685: db_ludate, p_custom_mode)) then
686: UPDATE xla_assignment_defns_tl
687: SET name = p_name
688: ,last_update_date = f_ludate
689: ,last_updated_by = f_luby
690: ,last_update_login = 0