APPS.FA_CHK_BOOKSTS_PKG dependencies on FND_CONCURRENT

Line 844: if (fnd_concurrent.get_request_status

840: return(TRUE);
841:
842: elsif (h_deprn_stat = 'S' or h_deprn_stat = 'R') then
843: -- stat is submitted or running
844: if (fnd_concurrent.get_request_status
845: (h_deprn_req_id,NULL,NULL,h_phase,
846: h_status,h_dev_phase,h_dev_status,h_message)) then
847: if (h_dev_phase = 'PENDING' OR
848: h_dev_phase = 'INACTIVE' OR

Line 972: from fnd_concurrent_requests

968: h_count number;
969:
970: cursor c_parent_request(p_request_id NUMBER) is
971: select parent_request_id
972: from fnd_concurrent_requests
973: where request_id = p_request_id;
974:
975: BEGIN
976:

Line 1007: elsif (fnd_concurrent.get_request_status

1003: -- can be sure it's the same request. For pl/sql
1004: -- programs, it would be -1 from sql*plus
1005: X_request_id := 0;
1006:
1007: elsif (fnd_concurrent.get_request_status
1008: (h_mass_req_id,NULL,NULL,h_phase,h_status,
1009: h_dev_phase, h_dev_status, h_message)) then
1010:
1011: if (h_dev_phase = 'PENDING' OR

Line 1024: from fnd_concurrent_requests

1020: into h_count
1021: from v$session a
1022: where a.audsid in
1023: (select ORACLE_SESSION_ID
1024: from fnd_concurrent_requests
1025: where request_id = h_mass_req_id
1026: or parent_request_id = h_mass_req_id);
1027:
1028: if (h_count = 0) then

Line 1091: if (fnd_concurrent.get_request_status

1087:
1088: -- check for status of this mass request id
1089: -- get the parent request if applicable
1090:
1091: if (fnd_concurrent.get_request_status
1092: (h_ca_req_id,NULL,NULL,h_phase,h_status,
1093: h_dev_phase, h_dev_status, h_message)) then
1094:
1095: if (h_dev_phase = 'PENDING' OR

Line 1108: from fnd_concurrent_requests

1104: into h_count
1105: from v$session a
1106: where a.audsid in
1107: (select ORACLE_SESSION_ID
1108: from fnd_concurrent_requests
1109: where request_id = h_ca_req_id
1110: or parent_request_id = h_ca_req_id);
1111:
1112: if (h_count = 0) then

Line 1263: from fnd_concurrent_requests re

1259: -- process is ruuning,inactive,pending status
1260:
1261: select re.concurrent_program_id
1262: into h_conc_program_id
1263: from fnd_concurrent_requests re
1264: where re.request_id = h_request_id
1265: and re.program_application_id = 140;
1266:
1267: select decode(pr.concurrent_program_name,

Line 1275: from fnd_concurrent_programs pr

1271: 'FAMRCL', 1,
1272: 'FAPPT', 1,
1273: 0)
1274: into h_conflict
1275: from fnd_concurrent_programs pr
1276: where pr.concurrent_program_id = h_conc_program_id
1277: and pr.application_id = 140;
1278:
1279: if (p_log_level_rec.statement_level) then