APPS.FND_SET dependencies on DUAL

Line 397: from sys.dual;

393:
394:
395: select fnd_concurrent_programs_s.nextval
396: into program_id
397: from sys.dual;
398:
399: if (stage_id is not null) then
400: fnd_message.set_name('FND', 'SRS-Request Set Stage');
401: request_set_text := fnd_message.get;

Line 786: select fnd_request_sets_s.nextval into set_id from sys.dual;

782:
783:
784: set_appl_id := application_id_f(application);
785:
786: select fnd_request_sets_s.nextval into set_id from sys.dual;
787:
788: if (owner is not null) then
789: BEGIN
790: select user_id

Line 938: from sys.dual;

934: set_id := request_set_id_f(set_appl_id, request_set);
935:
936: select fnd_request_set_stages_s.nextval
937: into stage_id
938: from sys.dual;
939:
940: if (upper(incompatibilities_allowed) = 'Y') then
941: select user_request_set_name
942: into set_name

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

2398: created_by := created_by_f;
2399: last_update_login := last_update_login_f;
2400: application_id := application_id_f(application);
2401:
2402: select fnd_executables_s.nextval into executable_id from sys.dual;
2403:
2404: insert into FND_EXECUTABLES (
2405: APPLICATION_ID, EXECUTABLE_ID, EXECUTABLE_NAME,
2406: EXECUTION_METHOD_CODE, EXECUTION_FILE_NAME, SUBROUTINE_NAME,

Line 2514: from sys.dual

2510:
2511: -- Can't delete an executable if it is in use
2512: BEGIN
2513: select 'x' into dummy
2514: from sys.dual
2515: where not exists
2516: (select 1
2517: from fnd_request_set_stages
2518: where function_application_id = exec_application_id

Line 2764: select fnd_stage_fn_parameters_s.nextval into param_id from sys.dual;

2760: last_update_login := last_update_login_f;
2761: fn_appl_id := application_id_f(application);
2762: fn_id := function_id_f(fn_appl_id, function_short_name);
2763:
2764: select fnd_stage_fn_parameters_s.nextval into param_id from sys.dual;
2765:
2766: insert into FND_STAGE_FN_PARAMETERS_TL (
2767: APPLICATION_ID, FUNCTION_ID, PARAMETER_ID, CREATION_DATE,
2768: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,