DBA Data[Home] [Help]

APPS.FND_CONCURRENT_PROGRAMS_PKG dependencies on FND_APPLICATION

Line 593: from fnd_application

589: db_luby number; -- entity owner in db
590: db_ludate date; -- entity update date in db
591: begin
592: select application_id into app_id
593: from fnd_application
594: where application_short_name = x_application_short_name;
595:
596: begin
597: select CONCURRENT_PROGRAM_ID into key_id

Line 864: from FND_APPLICATION

860: -- Translate char last_update_date to date
861: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
862:
863: select APPLICATION_ID into app_id
864: from FND_APPLICATION
865: where APPLICATION_SHORT_NAME = x_application_short_name;
866:
867:
868: begin

Line 887: FROM FND_EXECUTABLES ex, FND_APPLICATION exa,

883: select ex.APPLICATION_ID, ex.EXECUTABLE_ID,
884: cl.APPLICATION_ID, cl.REQUEST_CLASS_ID,
885: ml.APPLICATION_ID, ml.EXECUTABLE_ID
886: into ex_app, ex_id, cl_app, cl_id, ml_app, ml_id
887: FROM FND_EXECUTABLES ex, FND_APPLICATION exa,
888: FND_CONCURRENT_REQUEST_CLASS cl, FND_APPLICATION cla,
889: FND_EXECUTABLES ml, FND_APPLICATION mla
890: WHERE ex.EXECUTABLE_NAME = x_exec_executable_name
891: and ex.APPLICATION_ID = exa.APPLICATION_ID

Line 888: FND_CONCURRENT_REQUEST_CLASS cl, FND_APPLICATION cla,

884: cl.APPLICATION_ID, cl.REQUEST_CLASS_ID,
885: ml.APPLICATION_ID, ml.EXECUTABLE_ID
886: into ex_app, ex_id, cl_app, cl_id, ml_app, ml_id
887: FROM FND_EXECUTABLES ex, FND_APPLICATION exa,
888: FND_CONCURRENT_REQUEST_CLASS cl, FND_APPLICATION cla,
889: FND_EXECUTABLES ml, FND_APPLICATION mla
890: WHERE ex.EXECUTABLE_NAME = x_exec_executable_name
891: and ex.APPLICATION_ID = exa.APPLICATION_ID
892: and exa.APPLICATION_SHORT_NAME = x_exec_application_short_name

Line 889: FND_EXECUTABLES ml, FND_APPLICATION mla

885: ml.APPLICATION_ID, ml.EXECUTABLE_ID
886: into ex_app, ex_id, cl_app, cl_id, ml_app, ml_id
887: FROM FND_EXECUTABLES ex, FND_APPLICATION exa,
888: FND_CONCURRENT_REQUEST_CLASS cl, FND_APPLICATION cla,
889: FND_EXECUTABLES ml, FND_APPLICATION mla
890: WHERE ex.EXECUTABLE_NAME = x_exec_executable_name
891: and ex.APPLICATION_ID = exa.APPLICATION_ID
892: and exa.APPLICATION_SHORT_NAME = x_exec_application_short_name
893: and cl.REQUEST_CLASS_NAME (+) = x_concurrent_class_name