DBA Data[Home] [Help]

APPS.IEX_GAR_PUB dependencies on DUAL

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 533: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;

529: p_parameterlist => l_param_list);
530:
531: begin
532:
533: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;
534:
535: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
536: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
537: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);