eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_TDS_ETDS_PKG dependencies on UTL_FILE

Line 123: d) Changed the UTL_FILE.PUT_LINE parameter from getsectioncode to lv_output_string.

119: b) Declared variables to select the section truncation depending on the form name.
120: c) Added logic to get the section code as 194C, 194D, 195 etc. from SEC. 194(C) and then check whether it can be converted to a
121: number. If so, the value will be printed in flat file else extract the value from 2nd character in flat file.
122: hardcoded the values of 194BB, 194EE, 194LA as per the details provided in NSDL as separate logic cannot be derived.
123: d) Changed the UTL_FILE.PUT_LINE parameter from getsectioncode to lv_output_string.
124:
125: 20. 15/02/2008 JMEENA for bug#6647362 File Version 120.5.12000000.4
126: Added 5000 UTL_FILE buffer size for bug#6647362
127:

Line 126: Added 5000 UTL_FILE buffer size for bug#6647362

122: hardcoded the values of 194BB, 194EE, 194LA as per the details provided in NSDL as separate logic cannot be derived.
123: d) Changed the UTL_FILE.PUT_LINE parameter from getsectioncode to lv_output_string.
124:
125: 20. 15/02/2008 JMEENA for bug#6647362 File Version 120.5.12000000.4
126: Added 5000 UTL_FILE buffer size for bug#6647362
127:
128: 21. 20/02/2008 JMEENA for bug#4600778 File Version 120.5.12000000.5
129: Removed the cursor c_bank_branch_code and added column bsr_code in the cursor c_tds_payment_check_id and fetched the value in v_bank_branch_code.
130:

Line 424: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 5000); --Added 5000 buffer size for bug#6647362

420: ) IS
421:
422: BEGIN
423:
424: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 5000); --Added 5000 buffer size for bug#6647362
425:
426: v_utl_file_dir := p_directory;
427: v_utl_file_name := p_filename;
428:

Line 426: v_utl_file_dir := p_directory;

422: BEGIN
423:
424: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 5000); --Added 5000 buffer size for bug#6647362
425:
426: v_utl_file_dir := p_directory;
427: v_utl_file_name := p_filename;
428:
429: END openFile;
430:

Line 427: v_utl_file_name := p_filename;

423:
424: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 5000); --Added 5000 buffer size for bug#6647362
425:
426: v_utl_file_dir := p_directory;
427: v_utl_file_name := p_filename;
428:
429: END openFile;
430:
431: PROCEDURE closeFile IS

Line 433: UTL_FILE.fclose(v_filehandle);

429: END openFile;
430:
431: PROCEDURE closeFile IS
432: BEGIN
433: UTL_FILE.fclose(v_filehandle);
434: END closeFile;
435:
436: /* Commented by Chong for eTDS ER bug#16414088 Start
437: PROCEDURE populate_details(

Line 2428: UTL_FILE.PUT_LINE(v_filehandle,

2424: ) IS
2425:
2426: BEGIN
2427:
2428: UTL_FILE.PUT_LINE(v_filehandle,
2429: LPAD(p_line_number, s_line_number, v_pad_number)
2430: ||v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
2431: ||v_debug_pad_char||RPAD(p_file_type, s_file_type, v_pad_char)
2432: ||v_debug_pad_char||RPAD(p_upload_type, s_upload_type, v_pad_char)

Line 2480: UTL_FILE.PUT_LINE(v_filehandle,

2476: ) IS
2477:
2478: BEGIN
2479:
2480: UTL_FILE.PUT_LINE(v_filehandle,
2481: LPAD(p_line_number, s_line_number, v_pad_number)
2482: ||v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
2483: ||v_debug_pad_char||LPAD(p_batch_number, s_batch_number, v_pad_number)
2484: ||v_debug_pad_char||LPAD(p_challan_count, s_challan_count, v_pad_number)

Line 2537: UTL_FILE.PUT_LINE(v_filehandle,

2533:
2534: BEGIN
2535: -- Bug 6796765. Added by Lakshmi Gopalsami
2536: -- Added upper for both p_challan_section and Sec.()
2537: UTL_FILE.PUT_LINE(v_filehandle,
2538: LPAD(p_line_number, s_line_number, v_pad_number)
2539: ||v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
2540: ||v_debug_pad_char||LPAD(p_batch_number, s_batch_number, v_pad_number)
2541: ||v_debug_pad_char||LPAD(nvl(p_challan_slno,0), s_challan_slno, v_pad_number)

Line 2590: UTL_FILE.PUT_LINE(v_filehandle,

2586:
2587: -- Bug 6796765. Added by Lakshmi Gopalsami
2588: -- Added upper for both p_deductee_section and Sec.()
2589:
2590: UTL_FILE.PUT_LINE(v_filehandle,
2591: LPAD(p_line_number, s_line_number, v_pad_number)
2592: ||v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
2593: ||v_debug_pad_char||LPAD(p_batch_number, s_batch_number, v_pad_number)
2594: ||v_debug_pad_char||LPAD(nvl(p_deductee_slno,0), s_deductee_slno, v_pad_number)

Line 2630: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');

2626:
2627: -- File Header
2628: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2629:
2630: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2631: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2632: UTL_FILE.PUT_LINE(v_filehandle,
2633: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2634: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

Line 2631: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');

2627: -- File Header
2628: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2629:
2630: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2631: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2632: UTL_FILE.PUT_LINE(v_filehandle,
2633: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2634: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)

Line 2632: UTL_FILE.PUT_LINE(v_filehandle,

2628: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2629:
2630: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2631: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2632: UTL_FILE.PUT_LINE(v_filehandle,
2633: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2634: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2636: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

Line 2655: UTL_FILE.PUT_LINE(v_filehandle,

2651: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2652: );
2653:
2654:
2655: UTL_FILE.PUT_LINE(v_filehandle,
2656: LPAD('LineNo', s_line_number, v_pad_char)
2657: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
2658: ||v_pad_char||RPAD('FT', s_file_type, v_pad_char)
2659: ||v_pad_char||RPAD('UT', s_upload_type, v_pad_char)

Line 2665: UTL_FILE.PUT_LINE(v_filehandle,

2661: ||v_pad_char||LPAD('FSeqNo', s_file_sequence_number, v_pad_char)
2662: ||v_pad_char||RPAD('Org Tan', s_deductor_tan, v_pad_char)
2663: ||v_pad_char||LPAD('NoOfBatches', s_number_of_batches, v_pad_char)
2664: );
2665: UTL_FILE.PUT_LINE(v_filehandle,
2666: LPAD(v_underline_char, s_line_number, v_underline_char)
2667: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
2668: ||v_pad_char||RPAD(v_underline_char, s_file_type, v_underline_char)
2669: ||v_pad_char||RPAD(v_underline_char, s_upload_type, v_underline_char)

Line 2696: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');

2692: v_req JAI_AP_ETDS_REQUESTS%rowtype;
2693: BEGIN
2694: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2695:
2696: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2697: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2698: UTL_FILE.PUT_LINE(v_filehandle,
2699: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2700: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

Line 2697: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');

2693: BEGIN
2694: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2695:
2696: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2697: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2698: UTL_FILE.PUT_LINE(v_filehandle,
2699: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2700: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)

Line 2698: UTL_FILE.PUT_LINE(v_filehandle,

2694: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2695:
2696: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2697: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2698: UTL_FILE.PUT_LINE(v_filehandle,
2699: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2700: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2702: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

Line 2732: UTL_FILE.PUT_LINE(v_filehandle,

2728: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
2729: );
2730:
2731:
2732: UTL_FILE.PUT_LINE(v_filehandle,
2733: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
2734: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
2735: LPAD('FT', sq_len_4, v_quart_pad) || v_pad_char ||
2736: LPAD('UT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 2751: UTL_FILE.PUT_LINE(v_filehandle,

2747: LPAD('SH', sq_len_2, v_quart_pad) || v_pad_char ||
2748: LPAD('SV', sq_len_2, v_quart_pad) || v_pad_char ||
2749: LPAD('SH', sq_len_2, v_quart_pad) );
2750:
2751: UTL_FILE.PUT_LINE(v_filehandle,
2752: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
2753: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
2754: LPAD(v_underline_char, sq_len_4, v_underline_char) || v_pad_char ||
2755: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||

Line 2776: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );

2772: PROCEDURE create_bh IS
2773: BEGIN
2774:
2775: -- Batch Header
2776: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
2777: UTL_FILE.PUT_LINE(v_filehandle,
2778: LPAD('LineNo', s_line_number, v_pad_char)
2779: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
2780: ||v_pad_char||LPAD('BNo', s_batch_number, v_pad_char)

Line 2777: UTL_FILE.PUT_LINE(v_filehandle,

2773: BEGIN
2774:
2775: -- Batch Header
2776: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
2777: UTL_FILE.PUT_LINE(v_filehandle,
2778: LPAD('LineNo', s_line_number, v_pad_char)
2779: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
2780: ||v_pad_char||LPAD('BNo', s_batch_number, v_pad_char)
2781: ||v_pad_char||LPAD('Ch.Cnt', s_challan_count, v_pad_char)

Line 2806: UTL_FILE.PUT_LINE(v_filehandle,

2802: ||v_pad_char||RPAD('PersonDesignation', s_pers_designation, v_pad_char)
2803: ||v_pad_char||LPAD('TotChallanTax', s_tot_tax_dedected_challan, v_pad_char)
2804: ||v_pad_char||LPAD('TotDeducteeTax', s_tot_tax_dedected_deductee, v_pad_char)
2805: );
2806: UTL_FILE.PUT_LINE(v_filehandle,
2807: LPAD(v_underline_char, s_line_number, v_underline_char)
2808: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
2809: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
2810: ||v_pad_char||LPAD(v_underline_char, s_challan_count, v_underline_char)

Line 2839: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;

2835: END create_bh;
2836:
2837: PROCEDURE create_quarterly_bh IS
2838: BEGIN
2839: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
2840:
2841: UTL_FILE.PUT_LINE(v_filehandle,
2842: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
2843: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 2841: UTL_FILE.PUT_LINE(v_filehandle,

2837: PROCEDURE create_quarterly_bh IS
2838: BEGIN
2839: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
2840:
2841: UTL_FILE.PUT_LINE(v_filehandle,
2842: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
2843: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
2844: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||
2845: LPAD('ChallCnt', sq_len_9, v_quart_pad) || v_pad_char ||

Line 2908: UTL_FILE.PUT_LINE(v_filehandle,

2904: /*Bug 8880543 - Added for eTDS/eTCS FVU Changes - End*/
2905: LPAD('RH', sq_len_2, v_quart_pad)
2906: );
2907:
2908: UTL_FILE.PUT_LINE(v_filehandle,
2909: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
2910: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
2911: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
2912: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||

Line 2979: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;

2975: END create_quarterly_bh;
2976:
2977: PROCEDURE create_quarterly_cd IS
2978: BEGIN
2979: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
2980: UTL_FILE.PUT_LINE(v_filehandle,
2981: LPAD('Line No', sq_len_9 , v_quart_pad) || v_pad_char ||
2982: LPAD('RT', sq_len_2 , v_quart_pad) || v_pad_char ||
2983: LPAD('Batch No', sq_len_9 , v_quart_pad) || v_pad_char ||

Line 2980: UTL_FILE.PUT_LINE(v_filehandle,

2976:
2977: PROCEDURE create_quarterly_cd IS
2978: BEGIN
2979: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
2980: UTL_FILE.PUT_LINE(v_filehandle,
2981: LPAD('Line No', sq_len_9 , v_quart_pad) || v_pad_char ||
2982: LPAD('RT', sq_len_2 , v_quart_pad) || v_pad_char ||
2983: LPAD('Batch No', sq_len_9 , v_quart_pad) || v_pad_char ||
2984: LPAD('Chall No', sq_len_9 , v_quart_pad) || v_pad_char ||

Line 3022: UTL_FILE.PUT_LINE(v_filehandle,

3018: LPAD('Remarks', sq_len_14 , v_quart_pad) || v_pad_char ||
3019: LPAD('RH', sq_len_2 , v_quart_pad)
3020: );
3021:
3022: UTL_FILE.PUT_LINE(v_filehandle,
3023: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
3024: LPAD(v_underline_char , sq_len_2 , v_underline_char) || v_pad_char ||
3025: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
3026: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||

Line 3068: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;

3064: END create_quarterly_cd;
3065:
3066: PROCEDURE create_quarterly_dd IS
3067: BEGIN
3068: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
3069: UTL_FILE.PUT_LINE(v_filehandle,
3070: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
3071: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
3072: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||

Line 3069: UTL_FILE.PUT_LINE(v_filehandle,

3065:
3066: PROCEDURE create_quarterly_dd IS
3067: BEGIN
3068: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
3069: UTL_FILE.PUT_LINE(v_filehandle,
3070: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
3071: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
3072: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||
3073: LPAD('ChallNo', sq_len_9, v_quart_pad) || v_pad_char ||

Line 3105: UTL_FILE.PUT_LINE(v_filehandle,

3101: LPAD('Remarks 3', sq_len_14, v_quart_pad) || v_pad_char ||
3102: LPAD('RH', sq_len_2, v_quart_pad)
3103: );
3104:
3105: UTL_FILE.PUT_LINE(v_filehandle,
3106: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
3107: LPAD(v_underline_char , sq_len_2 , v_underline_char) || v_pad_char ||
3108: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
3109: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||

Line 3148: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );

3144: PROCEDURE create_cd IS
3145: BEGIN
3146:
3147: -- Challan Detail
3148: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
3149: UTL_FILE.PUT_LINE(v_filehandle,
3150: LPAD('LineNo', s_line_number, v_pad_char)
3151: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
3152: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)

Line 3149: UTL_FILE.PUT_LINE(v_filehandle,

3145: BEGIN
3146:
3147: -- Challan Detail
3148: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
3149: UTL_FILE.PUT_LINE(v_filehandle,
3150: LPAD('LineNo', s_line_number, v_pad_char)
3151: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
3152: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)
3153: ||v_pad_char||LPAD('CSlNo', s_challan_slno, v_pad_char)

Line 3160: UTL_FILE.PUT_LINE(v_filehandle,

3156: ||v_pad_char||RPAD('Ch.Num.', s_challan_num, v_pad_char)
3157: ||v_pad_char||LPAD('Ch.Date', s_date, v_pad_char)
3158: ||v_pad_char||RPAD('BankBrCode', s_bank_branch_code, v_pad_char)
3159: );
3160: UTL_FILE.PUT_LINE(v_filehandle,
3161: LPAD(v_underline_char, s_line_number, v_underline_char)
3162: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
3163: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
3164: ||v_pad_char||LPAD(v_underline_char, s_challan_slno, v_underline_char)

Line 3181: UTL_FILE.PUT_LINE(v_filehandle, v_chr10 );

3177: p_grossing_up_factor Obsoleted via bug # 4353842
3178: */
3179:
3180: -- Deductee Detail
3181: UTL_FILE.PUT_LINE(v_filehandle, v_chr10 );
3182: UTL_FILE.PUT_LINE(v_filehandle,
3183: LPAD('LineNo', s_line_number, v_pad_char)
3184: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
3185: ||v_pad_char||LPAD('B.No.', s_batch_number, v_pad_char)

Line 3182: UTL_FILE.PUT_LINE(v_filehandle,

3178: */
3179:
3180: -- Deductee Detail
3181: UTL_FILE.PUT_LINE(v_filehandle, v_chr10 );
3182: UTL_FILE.PUT_LINE(v_filehandle,
3183: LPAD('LineNo', s_line_number, v_pad_char)
3184: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
3185: ||v_pad_char||LPAD('B.No.', s_batch_number, v_pad_char)
3186: ||v_pad_char||LPAD('DSlNo', s_deductee_slno, v_pad_char)

Line 3219: UTL_FILE.PUT_LINE(v_filehandle,

3215: /* Bug 4353842. Added by Lakshmi Gopalsami
3216: p_grossing_up_factor Obsoleted via bug # 4353842
3217: */
3218:
3219: UTL_FILE.PUT_LINE(v_filehandle,
3220: LPAD(v_underline_char, s_line_number, v_underline_char)
3221: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
3222: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
3223: ||v_pad_char||LPAD(v_underline_char, s_deductee_slno, v_underline_char)

Line 3284: UTL_FILE.PUT_LINE(v_filehandle,

3280: IS
3281: BEGIN
3282: IF p_generate_headers = 'N' THEN
3283:
3284: UTL_FILE.PUT_LINE(v_filehandle,
3285: p_line_number || v_delimeter||
3286: p_record_type || v_delimeter||
3287: p_file_type || v_delimeter||
3288: p_upload_type || v_delimeter||

Line 3304: UTL_FILE.PUT_LINE(v_filehandle,

3300: p_fh_scmVersion || v_delimeter||
3301: p_fh_scmHash || v_delimeter||
3302: p_fh_consFileHash);/* ETDS FVU3.3 -Bug 13702172 */
3303: ELSE
3304: UTL_FILE.PUT_LINE(v_filehandle,
3305: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
3306: LPAD(p_record_type , sq_len_2, v_quart_pad) || v_pad_char ||
3307: LPAD(p_file_type , sq_len_4, v_quart_pad) || v_pad_char ||
3308: LPAD(p_upload_type , sq_len_2, v_quart_pad) || v_pad_char ||

Line 3402: UTL_FILE.PUT_LINE( v_filehandle, p_line_number || v_delimeter||

3398: )
3399: IS
3400: BEGIN
3401: IF p_generate_headers = 'N' THEN
3402: UTL_FILE.PUT_LINE( v_filehandle, p_line_number || v_delimeter||
3403: p_record_type || v_delimeter||
3404: p_batch_number || v_delimeter||
3405: p_challan_count || v_delimeter||
3406: p_form_number || v_delimeter||

Line 3471: UTL_FILE.PUT_LINE( v_filehandle,

3467: p_recHash ) ;
3468:
3469:
3470: ELSE
3471: UTL_FILE.PUT_LINE( v_filehandle,
3472: LPAD(p_line_number, sq_len_9 , v_quart_pad) || v_pad_char ||
3473: LPAD(p_record_type , sq_len_2 , v_quart_pad) || v_pad_char ||
3474: LPAD(p_batch_number, sq_len_9 , v_quart_pad) || v_pad_char ||
3475: LPAD(p_challan_count, sq_len_9 , v_quart_pad) || v_pad_char ||

Line 3694: UTL_FILE.PUT_LINE(

3690:
3691: -- Bug 6796765. Added by Lakshmi Gopalsami
3692: -- Changed from getsectioncode to lv_output_string
3693:
3694: UTL_FILE.PUT_LINE(
3695: v_filehandle,p_line_number || v_delimeter||
3696: p_record_type || v_delimeter||
3697: p_batch_number || v_delimeter||
3698: p_challan_dtl_slno || v_delimeter||

Line 3739: UTL_FILE.PUT_LINE( v_filehandle,

3735: ELSE
3736: -- Bug 6796765. Added by Lakshmi Gopalsami
3737: -- Changed from getsectioncode to lv_output_string
3738:
3739: UTL_FILE.PUT_LINE( v_filehandle,
3740: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
3741: LPAD(p_record_type , sq_len_2, v_quart_pad) || v_pad_char ||
3742: LPAD(p_batch_number , sq_len_9, v_quart_pad) || v_pad_char ||
3743: LPAD(p_challan_dtl_slno , sq_len_9, v_quart_pad) || v_pad_char ||

Line 3824: UTL_FILE.PUT_LINE( v_filehandle,

3820: )
3821: IS
3822: BEGIN
3823: IF p_generate_headers = 'N' THEN
3824: UTL_FILE.PUT_LINE( v_filehandle,
3825: p_line_number || v_delimeter ||
3826: p_record_type || v_delimeter ||
3827: p_batch_number || v_delimeter ||
3828: p_dh_challan_recNo || v_delimeter ||

Line 3862: UTL_FILE.PUT_LINE( v_filehandle,

3858: p_remarks3 || v_delimeter ||
3859: p_dh_recHash
3860: );
3861: ELSE
3862: UTL_FILE.PUT_LINE( v_filehandle,
3863: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
3864: LPAD(p_record_type , sq_len_2, v_quart_pad) || v_pad_char ||
3865: LPAD(p_batch_number , sq_len_9, v_quart_pad) || v_pad_char ||
3866: LPAD(p_dh_challan_recNo , sq_len_9, v_quart_pad) || v_pad_char ||