DBA Data[Home] [Help]

APPS.FND_PROGRAM dependencies on DUAL

Line 667: FROM sys.dual;

663: srs2_i := upper(allow_disabled_values);
664:
665: SELECT fnd_concurrent_programs_s.NEXTVAL /* get next cp id */
666: INTO concurrent_program_id_i
667: FROM sys.dual;
668:
669: application_id_i := application_id_f(application);
670: appl_short_name := application_short_name_f(application);
671:

Line 775: from sys.dual

771: /* Check printer */
772: if (printer is not null) then
773: BEGIN
774: select 'x' into dummy
775: from sys.dual
776: where printer in
777: (select distinct printer_name
778: from fnd_printer p
779: where (output_print_style_i is not null

Line 1221: select fnd_executables_s.nextval into executable_id from sys.dual;

1217: RAISE bad_parameter;
1218: end if;
1219:
1220:
1221: select fnd_executables_s.nextval into executable_id from sys.dual;
1222:
1223: insert into FND_EXECUTABLES (
1224: APPLICATION_ID, EXECUTABLE_ID, EXECUTABLE_NAME,
1225: EXECUTION_METHOD_CODE, EXECUTION_FILE_NAME, SUBROUTINE_NAME,

Line 1780: from sys.dual

1776:
1777: -- Can't delete an executable if it is in use
1778: BEGIN
1779: select 'x' into dummy
1780: from sys.dual
1781: where not exists
1782: (select 1
1783: from fnd_concurrent_programs
1784: where executable_application_id = exec_application_id