APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on UTL_FILE

Line 3508: WHERE name = 'utl_file_dir';

3504: SELECT decode(substr(value,1,instr(value,',') -1),
3505: null ,value ,
3506: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3507: FROM v$parameter
3508: WHERE name = 'utl_file_dir';
3509:
3510:
3511: log_file (lv_filename , '============================================================================================================================================================================================================================');
3512: log_file(lv_filename,'REPORTING_IDENTIFIER VAT_TRANSACTION_ID ORGANIZATION_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE TRX_ID TRX_LINE_ID TAX_LINE_ID TRX_NUMBER TAX_INVOICE_DATE REPORTING_STATUS_ID VAT_REP_ENTITY_ID FINAL_REPORTING_ID');

Line 3685: v_myfilehandle UTL_FILE.FILE_TYPE;

3681: IS
3682:
3683: l_api_name CONSTANT VARCHAR2(30) := 'LOG_FILE';
3684: lv_utl_location VARCHAR2(1000);
3685: v_myfilehandle UTL_FILE.FILE_TYPE;
3686:
3687: BEGIN
3688:
3689: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3699: WHERE name = 'utl_file_dir';

3695: SELECT decode(substr (value,1,instr(value,',') -1) ,
3696: null ,value ,
3697: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3698: FROM v$parameter
3699: WHERE name = 'utl_file_dir';
3700:
3701: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3702: utl_file.put_line(v_myfilehandle,text_to_write);
3703: utl_file.fclose(v_myfilehandle);

Line 3701: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');

3697: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3698: FROM v$parameter
3699: WHERE name = 'utl_file_dir';
3700:
3701: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3702: utl_file.put_line(v_myfilehandle,text_to_write);
3703: utl_file.fclose(v_myfilehandle);
3704:
3705: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3702: utl_file.put_line(v_myfilehandle,text_to_write);

3698: FROM v$parameter
3699: WHERE name = 'utl_file_dir';
3700:
3701: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3702: utl_file.put_line(v_myfilehandle,text_to_write);
3703: utl_file.fclose(v_myfilehandle);
3704:
3705: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3706: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

Line 3703: utl_file.fclose(v_myfilehandle);

3699: WHERE name = 'utl_file_dir';
3700:
3701: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3702: utl_file.put_line(v_myfilehandle,text_to_write);
3703: utl_file.fclose(v_myfilehandle);
3704:
3705: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3706: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3707: G_PKG_NAME||': ' || l_api_name||'()-');