DBA Data[Home] [Help]

APPS.IEX_PROCESS_ACCOUNT_WINNERS dependencies on DUAL

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

253:
254:
255: BEGIN
256:
257: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
258: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
259: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Party Level Collector Assignment ***');
260: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Party Level Collector Assignment ***');
261:

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

468:
469:
470: BEGIN
471:
472: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
473: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
474: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Account Level Collector Assignment ***');
475: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Account Level Collector Assignment ***');
476: -- l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

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

731: l_Status BOOLEAN;
732: -------------------------------------------------------------------------------
733:
734: BEGIN
735: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
736: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
737: IEX_TERR_WINNERS_PUB.Print_Debug('*** Started Site Level Collector Assignment ***');
738: FND_FILE.PUT_LINE(FND_FILE.LOG,'*** Started Site Level Collector Assignment ***');
739: