APPS.IEX_GAR_PUB dependencies on DUAL

Line 172: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;

168: BEGIN
169:
170: IEX_TERR_WINNERS_PUB.Print_Debug('Starting JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id);
171:
172: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
173: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.get_winners...');
175:
176: JTY_ASSIGN_BULK_PUB.get_winners(

Line 198: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;

194:
195: IEX_TERR_WINNERS_PUB.Print_Debug('Message from JTY_ASSIGN_BULK_PUB.get_winners for worker ' ||
196: l_msg_data);
197:
198: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
199: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
200: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.get_winners...');
201:
202: COMMIT;

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

541: p_parameterlist => l_param_list);
542:
543: begin
544:
545: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;
546:
547: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
548: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
549: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);