APPS.IEX_ATA_PUB dependencies on DUAL

Line 132: from dual;

128: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
129:
130: select iex_utilities.validate_running_level(decode(P_STR_LEVEL,'PARTY','CUSTOMER','ACCOUNT','ACCOUNT','BILLTOSITE','BILL_TO','BILL_TO'))
131: into l_str_status
132: from dual;
133:
134: If l_str_level_count > 1 then
135: If P_STR_LEVEL is null then
136: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Multiple Strategy Levels being used.');

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

264: l_target_type := 'TOTAL';
265:
266: BEGIN
267: IEX_DEBUG('Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
268: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
271:
272: JTY_ASSIGN_BULK_PUB.collect_trans_data(

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

286: ERRBUF => lx_errbuf,
287: RETCODE => lx_retcode);
288: IEX_DEBUG('Completed JTY_ASSIGN_BULK_PUB.collect_trans_data with status ' || l_return_status);
289: IEX_DEBUG('Message from JTY_ASSIGN_BULK_PUB.collect_trans_data ' ||lx_msg_data);
290: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
291: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');
293: EXCEPTION WHEN OTHERS THEN
294: IEX_DEBUG('Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);

Line 486: FROM dual;

482: l_retvalue VARCHAR2(20);
483:
484: CURSOR c_get_conseq_cur IS
485: SELECT fnd_concurrent_requests_s.nextval
486: FROM dual;
487: BEGIN
488:
489:
490: -- get profile option - USER_ID

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

541:
542: BEGIN
543: IF g_debug_flag = 'Y'
544: THEN
545: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
546: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
547:
548: -- chop the message to 255 long
549: l_length := length(msg);