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.FND_EXECUTABLES_PKG dependencies on FND_EXECUTABLES

Line 1: package body FND_EXECUTABLES_PKG as

1: package body FND_EXECUTABLES_PKG as
2: /* $Header: AFCPMPEB.pls 120.2 2005/08/19 20:05:53 tkamiya ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 21: cursor C is select ROWID from FND_EXECUTABLES

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from FND_EXECUTABLES
22: where APPLICATION_ID = X_APPLICATION_ID
23: and EXECUTABLE_ID = X_EXECUTABLE_ID
24: ;
25: begin

Line 26: insert into FND_EXECUTABLES (

22: where APPLICATION_ID = X_APPLICATION_ID
23: and EXECUTABLE_ID = X_EXECUTABLE_ID
24: ;
25: begin
26: insert into FND_EXECUTABLES (
27: APPLICATION_ID,
28: EXECUTABLE_ID,
29: EXECUTABLE_NAME,
30: EXECUTION_METHOD_CODE,

Line 54: insert into FND_EXECUTABLES_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into FND_EXECUTABLES_TL (
55: APPLICATION_ID,
56: EXECUTABLE_ID,
57: CREATION_DATE,
58: CREATED_BY,

Line 82: from FND_EXECUTABLES_TL T

78: from FND_LANGUAGES L
79: where L.INSTALLED_FLAG in ('I', 'B')
80: and not exists
81: (select NULL
82: from FND_EXECUTABLES_TL T
83: where T.APPLICATION_ID = X_APPLICATION_ID
84: and T.EXECUTABLE_ID = X_EXECUTABLE_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:

Line 114: from FND_EXECUTABLES

110: EXECUTION_METHOD_CODE,
111: EXECUTION_FILE_NAME,
112: SUBROUTINE_NAME,
113: EXECUTION_FILE_PATH
114: from FND_EXECUTABLES
115: where APPLICATION_ID = X_APPLICATION_ID
116: and EXECUTABLE_ID = X_EXECUTABLE_ID
117: for update of APPLICATION_ID nowait;
118: recinfo c%rowtype;

Line 123: from FND_EXECUTABLES_TL

119:
120: cursor c1 is select
121: USER_EXECUTABLE_NAME,
122: DESCRIPTION
123: from FND_EXECUTABLES_TL
124: where APPLICATION_ID = X_APPLICATION_ID
125: and EXECUTABLE_ID = X_EXECUTABLE_ID
126: and LANGUAGE = userenv('LANG')
127: for update of APPLICATION_ID nowait;

Line 189: update FND_EXECUTABLES set

185: X_LAST_UPDATED_BY in NUMBER,
186: X_LAST_UPDATE_LOGIN in NUMBER
187: ) is
188: begin
189: update FND_EXECUTABLES set
190: EXECUTABLE_NAME = X_EXECUTABLE_NAME,
191: EXECUTION_METHOD_CODE = X_EXECUTION_METHOD_CODE,
192: EXECUTION_FILE_NAME = X_EXECUTION_FILE_NAME,
193: SUBROUTINE_NAME = X_SUBROUTINE_NAME,

Line 205: update FND_EXECUTABLES_TL set

201: if (sql%notfound) then
202: raise no_data_found;
203: end if;
204:
205: update FND_EXECUTABLES_TL set
206: USER_EXECUTABLE_NAME = nvl(X_USER_EXECUTABLE_NAME, USER_EXECUTABLE_NAME),
207: DESCRIPTION = nvl(X_DESCRIPTION, DESCRIPTION),
208: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
209: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 231: fnd_executables_pkg.translate_row(

227: x_user_executable_name in varchar2,
228: x_description in varchar2)
229: is
230: begin
231: fnd_executables_pkg.translate_row(
232: x_executable_name => x_executable_name,
233: x_application_short_name => x_application_short_name,
234: x_owner => x_owner,
235: x_user_executable_name => x_user_executable_name,

Line 272: from fnd_executables

268: from fnd_application
269: where APPLICATION_SHORT_NAME = x_application_short_name;
270:
271: select EXECUTABLE_ID into key_id
272: from fnd_executables
273: where EXECUTABLE_NAME = x_executable_name
274: and APPLICATION_ID = app_id;
275:
276: select LAST_UPDATED_BY, LAST_UPDATE_DATE

Line 278: from FND_EXECUTABLES_TL

274: and APPLICATION_ID = app_id;
275:
276: select LAST_UPDATED_BY, LAST_UPDATE_DATE
277: into db_luby, db_ludate
278: from FND_EXECUTABLES_TL
279: where APPLICATION_ID = app_id
280: and EXECUTABLE_ID = key_id
281: and LANGUAGE = userenv('LANG');
282: -- Update record, honoring customization mode.

Line 294: update FND_EXECUTABLES_TL set

290: p_db_id => db_luby,
291: p_db_lud => db_ludate,
292: p_custom_mode => x_custom_mode))
293: then
294: update FND_EXECUTABLES_TL set
295: USER_EXECUTABLE_NAME = nvl(x_user_executable_name,
296: USER_EXECUTABLE_NAME),
297: DESCRIPTION = nvl(x_description, DESCRIPTION),
298: SOURCE_LANG = userenv('LANG'),

Line 325: fnd_executables_pkg.load_row(

321: x_user_executable_name in varchar2,
322: x_description in varchar2)
323: is
324: begin
325: fnd_executables_pkg.load_row(
326: x_executable_name => x_executable_name,
327: x_application_short_name => x_application_short_name,
328: x_owner => x_owner,
329: x_execution_method_code => x_execution_method_code,

Line 376: from fnd_executables

372: where APPLICATION_SHORT_NAME = x_application_short_name;
373:
374: select EXECUTABLE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
375: into key_id, db_luby, db_ludate
376: from fnd_executables
377: where EXECUTABLE_NAME = x_executable_name
378: and APPLICATION_ID = app_id;
379:
380: -- Update record, honoring customization mode.

Line 392: fnd_executables_pkg.update_row(

388: p_db_id => db_luby,
389: p_db_lud => db_ludate,
390: p_custom_mode => x_custom_mode))
391: then
392: fnd_executables_pkg.update_row(
393: x_application_id => app_id,
394: x_executable_id => key_id,
395: x_executable_name => x_executable_name,
396: x_execution_method_code => x_execution_method_code,

Line 434: fnd_message.set_token('ROUTINE', 'FND_EXECUTABLES_PKG.LOAD_ROW');

430: execution_file_path => x_execution_file_path);
431: exception
432: when DUP_VAL_ON_INDEX then
433: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
434: fnd_message.set_token('ROUTINE', 'FND_EXECUTABLES_PKG.LOAD_ROW');
435: fnd_message.set_token('ERRNO', SQLCODE);
436: fnd_message.set_token('REASON', SQLERRM);
437: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
438: fnd_log.message(FND_LOG.LEVEL_EVENT,

Line 439: 'fnd.plsql.fnd_executables_pkg.load_row.exception', FALSE);

435: fnd_message.set_token('ERRNO', SQLCODE);
436: fnd_message.set_token('REASON', SQLERRM);
437: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
438: fnd_log.message(FND_LOG.LEVEL_EVENT,
439: 'fnd.plsql.fnd_executables_pkg.load_row.exception', FALSE);
440: end if;
441: when others then
442: fnd_message.set_name('FND','GENERIC-INTERNAL ERROR');
443: fnd_message.set_token('REASON',fnd_program.message);

Line 454: delete from FND_EXECUTABLES

450: X_APPLICATION_ID in NUMBER,
451: X_EXECUTABLE_ID in NUMBER
452: ) is
453: begin
454: delete from FND_EXECUTABLES
455: where APPLICATION_ID = X_APPLICATION_ID
456: and EXECUTABLE_ID = X_EXECUTABLE_ID;
457:
458: if (sql%notfound) then

Line 462: delete from FND_EXECUTABLES_TL

458: if (sql%notfound) then
459: raise no_data_found;
460: end if;
461:
462: delete from FND_EXECUTABLES_TL
463: where APPLICATION_ID = X_APPLICATION_ID
464: and EXECUTABLE_ID = X_EXECUTABLE_ID;
465:
466: if (sql%notfound) then

Line 482: delete from FND_EXECUTABLES_TL T

478: /* as a quick workaround to fix the time-consuming table handler issue */
479: /* Eventually we'll need to turn them into a separate fix_language procedure */
480: /*
481:
482: delete from FND_EXECUTABLES_TL T
483: where not exists
484: (select NULL
485: from FND_EXECUTABLES B
486: where B.APPLICATION_ID = T.APPLICATION_ID

Line 485: from FND_EXECUTABLES B

481:
482: delete from FND_EXECUTABLES_TL T
483: where not exists
484: (select NULL
485: from FND_EXECUTABLES B
486: where B.APPLICATION_ID = T.APPLICATION_ID
487: and B.EXECUTABLE_ID = T.EXECUTABLE_ID
488: );
489:

Line 490: update FND_EXECUTABLES_TL T set (

486: where B.APPLICATION_ID = T.APPLICATION_ID
487: and B.EXECUTABLE_ID = T.EXECUTABLE_ID
488: );
489:
490: update FND_EXECUTABLES_TL T set (
491: USER_EXECUTABLE_NAME,
492: DESCRIPTION
493: ) = (select
494: B.USER_EXECUTABLE_NAME,

Line 496: from FND_EXECUTABLES_TL B

492: DESCRIPTION
493: ) = (select
494: B.USER_EXECUTABLE_NAME,
495: B.DESCRIPTION
496: from FND_EXECUTABLES_TL B
497: where B.APPLICATION_ID = T.APPLICATION_ID
498: and B.EXECUTABLE_ID = T.EXECUTABLE_ID
499: and B.LANGUAGE = T.SOURCE_LANG)
500: where (

Line 508: from FND_EXECUTABLES_TL SUBB, FND_EXECUTABLES_TL SUBT

504: ) in (select
505: SUBT.APPLICATION_ID,
506: SUBT.EXECUTABLE_ID,
507: SUBT.LANGUAGE
508: from FND_EXECUTABLES_TL SUBB, FND_EXECUTABLES_TL SUBT
509: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
510: and SUBB.EXECUTABLE_ID = SUBT.EXECUTABLE_ID
511: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
512: and (SUBB.USER_EXECUTABLE_NAME <> SUBT.USER_EXECUTABLE_NAME

Line 519: insert into FND_EXECUTABLES_TL (

515: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
516: ));
517: */
518:
519: insert into FND_EXECUTABLES_TL (
520: APPLICATION_ID,
521: EXECUTABLE_ID,
522: CREATION_DATE,
523: CREATED_BY,

Line 543: from FND_EXECUTABLES_TL B, FND_LANGUAGES L

539: B.USER_EXECUTABLE_NAME,
540: B.DESCRIPTION,
541: L.LANGUAGE_CODE,
542: B.SOURCE_LANG
543: from FND_EXECUTABLES_TL B, FND_LANGUAGES L
544: where L.INSTALLED_FLAG in ('I', 'B')
545: and B.LANGUAGE = userenv('LANG')
546: and not exists
547: (select NULL

Line 548: from FND_EXECUTABLES_TL T

544: where L.INSTALLED_FLAG in ('I', 'B')
545: and B.LANGUAGE = userenv('LANG')
546: and not exists
547: (select NULL
548: from FND_EXECUTABLES_TL T
549: where T.APPLICATION_ID = B.APPLICATION_ID
550: and T.EXECUTABLE_ID = B.EXECUTABLE_ID
551: and T.LANGUAGE = L.LANGUAGE_CODE);
552: end ADD_LANGUAGE;

Line 554: end FND_EXECUTABLES_PKG;

550: and T.EXECUTABLE_ID = B.EXECUTABLE_ID
551: and T.LANGUAGE = L.LANGUAGE_CODE);
552: end ADD_LANGUAGE;
553:
554: end FND_EXECUTABLES_PKG;