1: PACKAGE BODY fnd_program AS
2: /* $Header: AFCPRCPB.pls 115.23 2003/09/30 20:29:01 pferguso ship $ */
3:
4:
5: /* START_PUBLIC */
1234: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1235: LAST_UPDATE_LOGIN, USER_EXECUTABLE_NAME, DESCRIPTION,
1236: LANGUAGE, SOURCE_LANG
1237: ) select
1238: application_id, executable_id, fnd_program.executable.creation_date,
1239: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1240: fnd_program.executable.last_updated_by,
1241: fnd_program.executable.last_update_login, executable,
1242: fnd_program.executable.description,
1235: LAST_UPDATE_LOGIN, USER_EXECUTABLE_NAME, DESCRIPTION,
1236: LANGUAGE, SOURCE_LANG
1237: ) select
1238: application_id, executable_id, fnd_program.executable.creation_date,
1239: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1240: fnd_program.executable.last_updated_by,
1241: fnd_program.executable.last_update_login, executable,
1242: fnd_program.executable.description,
1243: l.language_code, fnd_program.executable.language_code
1236: LANGUAGE, SOURCE_LANG
1237: ) select
1238: application_id, executable_id, fnd_program.executable.creation_date,
1239: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1240: fnd_program.executable.last_updated_by,
1241: fnd_program.executable.last_update_login, executable,
1242: fnd_program.executable.description,
1243: l.language_code, fnd_program.executable.language_code
1244: from FND_LANGUAGES L
1237: ) select
1238: application_id, executable_id, fnd_program.executable.creation_date,
1239: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1240: fnd_program.executable.last_updated_by,
1241: fnd_program.executable.last_update_login, executable,
1242: fnd_program.executable.description,
1243: l.language_code, fnd_program.executable.language_code
1244: from FND_LANGUAGES L
1245: where L.INSTALLED_FLAG in ('I', 'B');
1238: application_id, executable_id, fnd_program.executable.creation_date,
1239: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1240: fnd_program.executable.last_updated_by,
1241: fnd_program.executable.last_update_login, executable,
1242: fnd_program.executable.description,
1243: l.language_code, fnd_program.executable.language_code
1244: from FND_LANGUAGES L
1245: where L.INSTALLED_FLAG in ('I', 'B');
1246:
1239: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1240: fnd_program.executable.last_updated_by,
1241: fnd_program.executable.last_update_login, executable,
1242: fnd_program.executable.description,
1243: l.language_code, fnd_program.executable.language_code
1244: from FND_LANGUAGES L
1245: where L.INSTALLED_FLAG in ('I', 'B');
1246:
1247: println('created executable for:'|| executable);
1981: AND concurrent_program_name = upper(short_name);
1982:
1983: EXCEPTION
1984: when no_data_found THEN
1985: message('fnd_program.enable_program: Program Not Found');
1986: RAISE bad_parameter;
1987: when others then
1988: message('fnd_program.enable_program: '||SQLERRM);
1989: RETURN;
1984: when no_data_found THEN
1985: message('fnd_program.enable_program: Program Not Found');
1986: RAISE bad_parameter;
1987: when others then
1988: message('fnd_program.enable_program: '||SQLERRM);
1989: RETURN;
1990: END;
1991:
1992: /* Now go and update the concurrent program table */
2423:
2424:
2425: /* END_PUBLIC */
2426:
2427: END fnd_program; /* end package */