DBA Data[Home] [Help]

APPS.IEX_GAR_PUB dependencies on FND_CONCURRENT

Line 121: FROM fnd_concurrent_requests

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

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

282: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || SQLERRM );
283: errbuf := SQLERRM;
284: retcode := SQLCODE;
285: --retcode := FND_API.G_RET_STS_UNEXP_ERROR;
286: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
287: END Generate_Access_Records;
288:
289: /*-------------------------------------------------------------------------*
290: | PRIVATE ROUTINE

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

376: IF px_terr_globals.request_id = 0 OR px_terr_globals.request_id IS NULL
377: THEN
378: -- Get concurrent sequence
379: IEX_TERR_WINNERS_PUB.Print_Debug('request_id is 0, get from sequence');
380: SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;
381: END IF;
382:
383: -- Get the profile option for AS_ENABLE_DUPS_RS_DELETION
384: -- OS: Enable Duplicate Resource Deletion

Line 510: FROM fnd_concurrent_requests

506: l_worker_id := p_terr_globals.worker_id;
507: l_transaction_type := p_terr_globals.transaction_type;
508:
509: SELECT count(*) into l_total_num_gar_workers
510: FROM fnd_concurrent_requests
511: WHERE parent_request_id = l_ata_request_id;
512:
513: WF_EVENT.AddParameterToList(
514: p_name => 'RUN_MODE',