DBA Data[Home] [Help]

APPS.OKC_EURO_CONV_PUB dependencies on DUAL

Line 484: from dual;*/

480: /* select decode(p_update_mode_yn,'Y',decode(l_return_status,'S','Successful','N',
481: 'No change ','Failed'),decode(l_return_status,'U','Incomplete CVN Rule',
482: 'A','No CVN rule','N','No change required'))
483: into l_upgrade_status
484: from dual;*/
485:
486: select decode(p_update_mode_yn,'Y',decode(l_return_status,'S','Successful','N',
487: 'No change ','Failed'),decode(l_return_status,'U','Incomplete Conversion data',
488: 'A','No Conversion data ','N','No change required'))

Line 490: from dual;

486: select decode(p_update_mode_yn,'Y',decode(l_return_status,'S','Successful','N',
487: 'No change ','Failed'),decode(l_return_status,'U','Incomplete Conversion data',
488: 'A','No Conversion data ','N','No change required'))
489: into l_upgrade_status
490: from dual;
491:
492: fnd_file.put_line(FND_FILE.OUTPUT,rpad(contracts_rec.contract_number,30)||
493: substr(rpad(nvl(contracts_rec.contract_number_modifier,'X'),21),2)||
494: rpad(contracts_rec.currency_code,15)||