APPS.FA_CHK_BOOKSTS_PKG dependencies on FND_CONCURRENT

Line 820: if (fnd_concurrent.get_request_status

816: return(TRUE);
817:
818: elsif (h_deprn_stat = 'S' or h_deprn_stat = 'R') then
819: -- stat is submitted or running
820: if (fnd_concurrent.get_request_status
821: (h_deprn_req_id,NULL,NULL,h_phase,
822: h_status,h_dev_phase,h_dev_status,h_message)) then
823: if (h_dev_phase = 'PENDING' OR
824: h_dev_phase = 'INACTIVE' OR

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 979: elsif (fnd_concurrent.get_request_status

975: -- can be sure it's the same request. For pl/sql
976: -- programs, it would be -1 from sql*plus
977: X_request_id := 0;
978:
979: elsif (fnd_concurrent.get_request_status
980: (h_mass_req_id,NULL,NULL,h_phase,h_status,
981: h_dev_phase, h_dev_status, h_message)) then
982:
983: if (h_dev_phase = 'PENDING' OR

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 1059: if (fnd_concurrent.get_request_status

1055:
1056: -- check for status of this mass request id
1057: -- get the parent request if applicable
1058:
1059: if (fnd_concurrent.get_request_status
1060: (h_ca_req_id,NULL,NULL,h_phase,h_status,
1061: h_dev_phase, h_dev_status, h_message)) then
1062:
1063: if (h_dev_phase = 'PENDING' OR

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,

Line 1238: from fnd_concurrent_programs pr

1234: 'FAMRCL', 1,
1235: 'FAPPT', 1,
1236: 0)
1237: into h_conflict
1238: from fnd_concurrent_programs pr
1239: where pr.concurrent_program_id = h_conc_program_id
1240: and pr.application_id = 140;
1241:
1242: if (p_log_level_rec.statement_level) then