APPS.IEX_GAR_PUB dependencies on FND_CONCURRENT

Line 120: FROM fnd_concurrent_requests

116: g_debug_flag := p_debug_mode;
117: IEX_TERR_WINNERS_PUB.g_debug_flag := p_debug_mode;
118: BEGIN
119: SELECT org_id INTO L_ORG_ID
120: FROM fnd_concurrent_requests
121: WHERE request_id=p_prev_request_id;
122: EXCEPTION WHEN OTHERS THEN
123: l_org_id := NULL;
124: END;

Line 274: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

270: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || SQLERRM );
271: errbuf := SQLERRM;
272: retcode := SQLCODE;
273: --retcode := FND_API.G_RET_STS_UNEXP_ERROR;
274: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
275: END Generate_Access_Records;
276:
277: /*-------------------------------------------------------------------------*
278: | PRIVATE ROUTINE

Line 368: SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;

364: IF px_terr_globals.request_id = 0 OR px_terr_globals.request_id IS NULL
365: THEN
366: -- Get concurrent sequence
367: IEX_TERR_WINNERS_PUB.Print_Debug('request_id is 0, get from sequence');
368: SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;
369: END IF;
370:
371: -- Get the profile option for AS_ENABLE_DUPS_RS_DELETION
372: -- OS: Enable Duplicate Resource Deletion

Line 498: FROM fnd_concurrent_requests

494: l_worker_id := p_terr_globals.worker_id;
495: l_transaction_type := p_terr_globals.transaction_type;
496:
497: SELECT count(*) into l_total_num_gar_workers
498: FROM fnd_concurrent_requests
499: WHERE parent_request_id = l_ata_request_id;
500:
501: WF_EVENT.AddParameterToList(
502: p_name => 'RUN_MODE',