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 229: from fnd_concurrent_requests a

225: -- SDIB that may be running, with the hard coded concurrent program id
226: -- from seed data
227: FOR req_cur in
228: (select request_id
229: from fnd_concurrent_requests a
230: where concurrent_program_id = 44445
231: and phase_code = 'R'
232: and substr(argument_text, 1, instr(argument_text,',') -1 )
233: in ( select match_rule_id from hz_match_rules_vl where rule_purpose = 'Q')

Line 370: from Fnd_Concurrent_Requests R

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