APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on UTL_FILE

Line 3327: WHERE name = 'utl_file_dir';

3323: SELECT decode(substr(value,1,instr(value,',') -1),
3324: null ,value ,
3325: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3326: FROM v$parameter
3327: WHERE name = 'utl_file_dir';
3328:
3329:
3330: log_file (lv_filename , '============================================================================================================================================================================================================================');
3331: 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 3504: v_myfilehandle UTL_FILE.FILE_TYPE;

3500: IS
3501:
3502: l_api_name CONSTANT VARCHAR2(30) := 'LOG_FILE';
3503: lv_utl_location VARCHAR2(40);
3504: v_myfilehandle UTL_FILE.FILE_TYPE;
3505:
3506: BEGIN
3507:
3508: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3518: WHERE name = 'utl_file_dir';

3514: SELECT decode(substr (value,1,instr(value,',') -1) ,
3515: null ,value ,
3516: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3517: FROM v$parameter
3518: WHERE name = 'utl_file_dir';
3519:
3520: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3521: utl_file.put_line(v_myfilehandle,text_to_write);
3522: utl_file.fclose(v_myfilehandle);

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

3516: substr (value,1,instr(value,',') -1)) INTO lv_utl_location
3517: FROM v$parameter
3518: WHERE name = 'utl_file_dir';
3519:
3520: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3521: utl_file.put_line(v_myfilehandle,text_to_write);
3522: utl_file.fclose(v_myfilehandle);
3523:
3524: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

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

3517: FROM v$parameter
3518: WHERE name = 'utl_file_dir';
3519:
3520: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3521: utl_file.put_line(v_myfilehandle,text_to_write);
3522: utl_file.fclose(v_myfilehandle);
3523:
3524: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3525: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

Line 3522: utl_file.fclose(v_myfilehandle);

3518: WHERE name = 'utl_file_dir';
3519:
3520: v_myfilehandle := utl_file.fopen(lv_utl_location,filename,'A');
3521: utl_file.put_line(v_myfilehandle,text_to_write);
3522: utl_file.fclose(v_myfilehandle);
3523:
3524: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3525: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3526: G_PKG_NAME||': ' || l_api_name||'()-');