1: PACKAGE BODY fnd_program AS
2: /* $Header: AFCPRCPB.pls 120.1.12020000.2 2012/11/07 22:05:47 ckclark ship $ */
3:
4:
5: /* START_PUBLIC */
1237: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1238: LAST_UPDATE_LOGIN, USER_EXECUTABLE_NAME, DESCRIPTION,
1239: LANGUAGE, SOURCE_LANG
1240: ) select
1241: application_id, executable_id, fnd_program.executable.creation_date,
1242: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1243: fnd_program.executable.last_updated_by,
1244: fnd_program.executable.last_update_login, executable,
1245: fnd_program.executable.description,
1238: LAST_UPDATE_LOGIN, USER_EXECUTABLE_NAME, DESCRIPTION,
1239: LANGUAGE, SOURCE_LANG
1240: ) select
1241: application_id, executable_id, fnd_program.executable.creation_date,
1242: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1243: fnd_program.executable.last_updated_by,
1244: fnd_program.executable.last_update_login, executable,
1245: fnd_program.executable.description,
1246: l.language_code, fnd_program.executable.language_code
1239: LANGUAGE, SOURCE_LANG
1240: ) select
1241: application_id, executable_id, fnd_program.executable.creation_date,
1242: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1243: fnd_program.executable.last_updated_by,
1244: fnd_program.executable.last_update_login, executable,
1245: fnd_program.executable.description,
1246: l.language_code, fnd_program.executable.language_code
1247: from FND_LANGUAGES L
1240: ) select
1241: application_id, executable_id, fnd_program.executable.creation_date,
1242: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1243: fnd_program.executable.last_updated_by,
1244: fnd_program.executable.last_update_login, executable,
1245: fnd_program.executable.description,
1246: l.language_code, fnd_program.executable.language_code
1247: from FND_LANGUAGES L
1248: where L.INSTALLED_FLAG in ('I', 'B');
1241: application_id, executable_id, fnd_program.executable.creation_date,
1242: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1243: fnd_program.executable.last_updated_by,
1244: fnd_program.executable.last_update_login, executable,
1245: fnd_program.executable.description,
1246: l.language_code, fnd_program.executable.language_code
1247: from FND_LANGUAGES L
1248: where L.INSTALLED_FLAG in ('I', 'B');
1249:
1242: fnd_program.executable.created_by, fnd_program.executable.last_update_date,
1243: fnd_program.executable.last_updated_by,
1244: fnd_program.executable.last_update_login, executable,
1245: fnd_program.executable.description,
1246: l.language_code, fnd_program.executable.language_code
1247: from FND_LANGUAGES L
1248: where L.INSTALLED_FLAG in ('I', 'B');
1249:
1250: println('created executable for:'|| executable);
1984: AND concurrent_program_name = upper(short_name);
1985:
1986: EXCEPTION
1987: when no_data_found THEN
1988: message('fnd_program.enable_program: Program Not Found');
1989: RAISE bad_parameter;
1990: when others then
1991: message('fnd_program.enable_program: '||SQLERRM);
1992: RETURN;
1987: when no_data_found THEN
1988: message('fnd_program.enable_program: Program Not Found');
1989: RAISE bad_parameter;
1990: when others then
1991: message('fnd_program.enable_program: '||SQLERRM);
1992: RETURN;
1993: END;
1994:
1995: /* Now go and update the concurrent program table */
2465: END program_is_mls;
2466:
2467: /* END_PUBLIC */
2468:
2469: END fnd_program; /* end package */