APPS.FA_CHK_BOOKSTS_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 944: from fnd_concurrent_requests

940: h_message VARCHAR2(2000):= NULL;
941: h_count number;
942: cursor c_parent_request(p_request_id NUMBER) is
943: select parent_request_id
944: from fnd_concurrent_requests
945: where request_id = p_request_id;
946:
947: BEGIN
948:

Line 996: from fnd_concurrent_requests

992: into h_count
993: from v$session a
994: where a.audsid in
995: (select ORACLE_SESSION_ID
996: from fnd_concurrent_requests
997: where request_id = h_mass_req_id
998: or parent_request_id = h_mass_req_id);
999:
1000: if (h_count = 0) then

Line 1076: from fnd_concurrent_requests

1072: into h_count
1073: from v$session a
1074: where a.audsid in
1075: (select ORACLE_SESSION_ID
1076: from fnd_concurrent_requests
1077: where request_id = h_ca_req_id
1078: or parent_request_id = h_ca_req_id);
1079:
1080: if (h_count = 0) then

Line 1226: from fnd_concurrent_requests re

1222: -- process is ruuning,inactive,pending status
1223:
1224: select re.concurrent_program_id
1225: into h_conc_program_id
1226: from fnd_concurrent_requests re
1227: where re.request_id = h_request_id
1228: and re.program_application_id = 140;
1229:
1230: select decode(pr.concurrent_program_name,