DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 9278: FROM fnd_concurrent_requests

9274: req_id NUMBER;
9275:
9276: CURSOR c_reprice_req(l_chr_id IN NUMBER,l_prog_appl_id IN NUMBER,l_prg_id IN NUMBER) IS
9277: SELECT max(request_id)
9278: FROM fnd_concurrent_requests
9279: WHERE program_application_id = l_prog_appl_id
9280: AND concurrent_program_id = l_prg_id
9281: AND argument2=to_char(l_chr_id)
9282: AND phase_code NOT IN ('C'); --- IN ('P','R'); SKUCHIMA

Line 9356: FROM fnd_concurrent_requests

9352: req_id NUMBER;
9353:
9354: CURSOR c_cascade_req(l_chr_id IN NUMBER,l_prog_appl_id IN NUMBER,l_prg_id IN NUMBER) IS
9355: SELECT max(request_id)
9356: FROM fnd_concurrent_requests
9357: WHERE program_application_id = l_prog_appl_id
9358: AND concurrent_program_id = l_prg_id
9359: AND argument1=to_char(l_chr_id)
9360: AND phase_code NOT IN ('C');

Line 9862: FROM fnd_concurrent_requests

9858: req_id NUMBER;
9859:
9860: CURSOR c_massupd_req(l_chr_id IN NUMBER,l_prog_appl_id IN NUMBER,l_prg_id IN NUMBER) IS
9861: SELECT max(request_id)
9862: FROM fnd_concurrent_requests
9863: WHERE program_application_id = l_prog_appl_id
9864: AND concurrent_program_id = l_prg_id
9865: AND argument1=to_char(l_chr_id)
9866: AND phase_code NOT IN ('C');