APPS.HZ_BATCH_DUPLICATE dependencies on FND_CONCURRENT_REQUESTS

Line 87: l_sub FND_CONCURRENT.REQUESTS_TAB_TYPE;

83: l_conc_dev_status VARCHAR2(30);
84: l_message VARCHAR2(240);
85: call_status boolean;
86: dup_workers_completed boolean;
87: l_sub FND_CONCURRENT.REQUESTS_TAB_TYPE;
88:
89: l_owner VARCHAR2(30);
90: l_automerge_flag VARCHAR2(1);
91: l_req_id NUMBER;

Line 235: from fnd_concurrent_requests a

231: -- SDIB that may be running, with the hard coded concurrent program id
232: -- from seed data
233: FOR req_cur in
234: (select request_id
235: from fnd_concurrent_requests a
236: where concurrent_program_id = 44445
237: and phase_code = 'R'
238: and substr(argument_text, 1, instr(argument_text,',') -1 )
239: in ( select match_rule_id from hz_match_rules_vl where rule_purpose = 'Q')

Line 376: from Fnd_Concurrent_Requests R

372: -- assume that all concurrent dup workers completed normally, unless found otherwise
373: dup_workers_completed := TRUE;
374:
375: Select request_id BULK COLLECT into l_sub_requests
376: from Fnd_Concurrent_Requests R
377: Where Parent_Request_Id = FND_GLOBAL.conc_request_id
378: and (phase_code<>'C' or status_code<>'C');
379:
380: IF l_sub_requests.count>0 THEN