DBA Data[Home] [Help]

APPS.AMW_ORG_HIERARCHY_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 8564: fnd_concurrent_requests

8560: BEGIN
8561: select
8562: request_id into p_request_id
8563: from
8564: fnd_concurrent_requests
8565: where
8566: CONCURRENT_PROGRAM_ID = concur_prog_id
8567: and last_update_date = (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = concur_prog_id)
8568: and phase_code<>'C';

Line 8567: and last_update_date = (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = concur_prog_id)

8563: from
8564: fnd_concurrent_requests
8565: where
8566: CONCURRENT_PROGRAM_ID = concur_prog_id
8567: and last_update_date = (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = concur_prog_id)
8568: and phase_code<>'C';
8569: return p_request_id;
8570: END get_latest_conc_request;
8571:

Line 8675: fnd_concurrent_requests

8671: cursor c_current_requests(prog_id number) IS
8672: select
8673: request_id, argument1, argument2, argument3, argument4
8674: from
8675: fnd_concurrent_requests
8676: where
8677: CONCURRENT_PROGRAM_ID = prog_id
8678: and last_update_date < (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = prog_id)
8679: and phase_code<>'C';

Line 8678: and last_update_date < (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = prog_id)

8674: from
8675: fnd_concurrent_requests
8676: where
8677: CONCURRENT_PROGRAM_ID = prog_id
8678: and last_update_date < (select max(last_update_date) from fnd_concurrent_requests where CONCURRENT_PROGRAM_ID = prog_id)
8679: and phase_code<>'C';
8680: v_concurrent_program_id integer;
8681: same_request_exception exception;
8682: prior_process_id number;