DBA Data[Home] [Help]

APPS.AR_BPA_PRINT_TRX dependencies on FND_CONCURRENT_REQUESTS

Line 155: ,fnd_concurrent_requests fcr

151: ,fcp.concurrent_program_id
152: INTO ln_conc_prog_code
153: ,ln_conc_prog_id
154: FROM fnd_concurrent_programs fcp
155: ,fnd_concurrent_requests fcr
156: WHERE fcp.concurrent_program_id = fcr.concurrent_program_id
157: AND fcr.request_id = p_parent_request_id;
158:
159: lb_options_ok := FND_REQUEST.set_options(implicit => 'NO'

Line 169: UPDATE fnd_concurrent_requests

165:
166: IF ln_conc_prog_code='ARBPAIPMP_IL' THEN
167: IF p_choice ='NEW' THEN
168:
169: UPDATE fnd_concurrent_requests
170: SET save_output_flag='N'
171: ,number_of_copies=1
172: WHERE request_id = p_parent_request_id
173: AND concurrent_program_id = ln_conc_prog_id;

Line 175: UPDATE fnd_concurrent_requests

171: ,number_of_copies=1
172: WHERE request_id = p_parent_request_id
173: AND concurrent_program_id = ln_conc_prog_id;
174: ELSE
175: UPDATE fnd_concurrent_requests
176: SET save_output_flag='Y'
177: WHERE request_id = p_parent_request_id
178: AND concurrent_program_id = ln_conc_prog_id;
179: END IF;

Line 760: FROM fnd_concurrent_requests fcr

756: DECLARE
757: CURSOR child_request_cur(p_request_id IN NUMBER) IS
758: SELECT fcr.request_id
759: ,fcr.status_code
760: FROM fnd_concurrent_requests fcr
761: WHERE fcr.parent_request_id = p_request_id;
762: BEGIN
763: FOR child_request_rec IN child_request_cur(ln_m_request_id)
764: LOOP