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_ETCS_PKG dependencies on UTL_FILE

Line 75: jai_ap_tds_etds_pkg.v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W');

71: ) IS
72:
73: BEGIN
74:
75: jai_ap_tds_etds_pkg.v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W');
76: jai_ap_tds_etds_pkg.v_utl_file_dir := p_directory;
77: jai_ap_tds_etds_pkg.v_utl_file_name := p_filename;
78:
79: END openFile;

Line 76: jai_ap_tds_etds_pkg.v_utl_file_dir := p_directory;

72:
73: BEGIN
74:
75: jai_ap_tds_etds_pkg.v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W');
76: jai_ap_tds_etds_pkg.v_utl_file_dir := p_directory;
77: jai_ap_tds_etds_pkg.v_utl_file_name := p_filename;
78:
79: END openFile;
80:

Line 77: jai_ap_tds_etds_pkg.v_utl_file_name := p_filename;

73: BEGIN
74:
75: jai_ap_tds_etds_pkg.v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W');
76: jai_ap_tds_etds_pkg.v_utl_file_dir := p_directory;
77: jai_ap_tds_etds_pkg.v_utl_file_name := p_filename;
78:
79: END openFile;
80:
81: PROCEDURE closeFile IS

Line 83: UTL_FILE.fclose(jai_ap_tds_etds_pkg.v_filehandle);

79: END openFile;
80:
81: PROCEDURE closeFile IS
82: BEGIN
83: UTL_FILE.fclose(jai_ap_tds_etds_pkg.v_filehandle);
84: END closeFile;
85:
86: -- Date Population procedures for ETCS Quarterly Returns
87: PROCEDURE create_quarterly_fh(

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

95: v_req JAI_AP_ETDS_REQUESTS%rowtype;
96: BEGIN
97:
98: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
99: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
100: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
101: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
102: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
103: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

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

96: BEGIN
97:
98: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
99: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
100: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
101: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
102: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
103: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
104: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

Line 101: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

97:
98: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
99: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
100: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
101: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
102: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
103: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
104: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
105: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

Line 127: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

123: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
124: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
125: );
126:
127: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
128: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
129: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
130: LPAD('FT', sq_len_4, v_quart_pad) || v_pad_char ||
131: LPAD('UT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 145: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

141: LPAD('SH', sq_len_2, v_quart_pad) || v_pad_char ||
142: LPAD('SV', sq_len_2, v_quart_pad) || v_pad_char ||
143: LPAD('SH', sq_len_2, v_quart_pad) );
144:
145: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
146: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
147: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
148: LPAD(v_underline_char, sq_len_4, v_underline_char) || v_pad_char ||
149: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||

Line 168: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;

164:
165: PROCEDURE create_quarterly_bh
166: IS
167: BEGIN
168: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
169: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
170: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
171: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
172: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||

Line 169: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

165: PROCEDURE create_quarterly_bh
166: IS
167: BEGIN
168: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
169: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
170: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
171: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
172: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||
173: LPAD('ChallCnt', sq_len_9, v_quart_pad) || v_pad_char ||

Line 224: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

220: LPAD('A', sq_len_1, v_quart_pad) || v_pad_char ||
221: LPAD('AO Approval No', sq_len_15, v_quart_pad) || v_pad_char ||
222: LPAD('RH', sq_len_2, v_quart_pad) );
223:
224: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
225: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
226: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
227: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
228: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||

Line 284: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;

280:
281: PROCEDURE create_quarterly_cd
282: IS
283: BEGIN
284: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
285: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
286: LPAD('Line No', sq_len_9 , v_quart_pad) || v_pad_char ||
287: LPAD('RT', sq_len_2 , v_quart_pad) || v_pad_char ||
288: LPAD('Batch No', sq_len_9 , v_quart_pad) || v_pad_char ||

Line 285: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

281: PROCEDURE create_quarterly_cd
282: IS
283: BEGIN
284: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
285: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
286: LPAD('Line No', sq_len_9 , v_quart_pad) || v_pad_char ||
287: LPAD('RT', sq_len_2 , v_quart_pad) || v_pad_char ||
288: LPAD('Batch No', sq_len_9 , v_quart_pad) || v_pad_char ||
289: LPAD('Chall No', sq_len_9 , v_quart_pad) || v_pad_char ||

Line 327: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

323: LPAD('Remarks', sq_len_14 , v_quart_pad) || v_pad_char ||
324: LPAD('RH', sq_len_2 , v_quart_pad)
325: );
326:
327: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
328: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
329: LPAD(v_underline_char , sq_len_2 , v_underline_char) || v_pad_char ||
330: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
331: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||

Line 373: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;

369: END create_quarterly_cd;
370:
371: PROCEDURE create_quarterly_dd IS
372: BEGIN
373: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
374: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
375: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
376: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
377: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||

Line 374: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

370:
371: PROCEDURE create_quarterly_dd IS
372: BEGIN
373: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
374: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
375: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
376: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
377: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||
378: LPAD('ChallNo', sq_len_9, v_quart_pad) || v_pad_char ||

Line 410: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

406: LPAD('Remarks 3', sq_len_14, v_quart_pad) || v_pad_char ||
407: LPAD('RH', sq_len_2, v_quart_pad)
408: );
409:
410: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
411: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
412: LPAD(v_underline_char , sq_len_2 , v_underline_char) || v_pad_char ||
413: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
414: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||

Line 639: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,

635: )
636: IS
637: BEGIN
638: IF p_generate_headers = 'N' THEN
639: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,
640: p_line_number || v_delimeter ||
641: upper(p_record_type) || v_delimeter ||
642: p_batch_number || v_delimeter ||
643: p_dh_challan_recNo || v_delimeter ||

Line 675: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

671: p_remarks3 || v_delimeter ||
672: p_dh_recHash
673: );
674: ELSE
675: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
676: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
677: LPAD(upper(p_record_type) , sq_len_2, v_quart_pad) || v_pad_char ||
678: LPAD(p_batch_number , sq_len_9, v_quart_pad) || v_pad_char ||
679: LPAD(p_dh_challan_recNo , sq_len_9, v_quart_pad) || v_pad_char ||

Line 871: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

867: ) IS
868: BEGIN
869: IF p_generate_headers = 'N' THEN
870:
871: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
872: p_line_number || v_delimeter||
873: upper(p_record_type) || v_delimeter||
874: upper(p_file_type) || v_delimeter||
875: upper(p_upload_type) || v_delimeter||

Line 889: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

885: p_fh_samHash || v_delimeter||
886: p_fh_scmVersion || v_delimeter||
887: p_fh_scmHash);
888: ELSE
889: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
890: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
891: LPAD( upper(p_record_type) , sq_len_2, v_quart_pad) || v_pad_char ||
892: LPAD(upper(p_file_type) , sq_len_4, v_quart_pad) || v_pad_char ||
893: LPAD(upper(p_upload_type) , sq_len_2, v_quart_pad) || v_pad_char ||

Line 1147: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle, p_line_number || v_delimeter||

1143: IS
1144: BEGIN
1145:
1146: IF p_generate_headers = 'N' THEN
1147: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle, p_line_number || v_delimeter||
1148: upper(p_record_type) || v_delimeter||
1149: p_batch_number || v_delimeter||
1150: p_challan_count || v_delimeter||
1151: upper(p_form_number) || v_delimeter||

Line 1201: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,

1197: upper(p_ao_approval) || v_delimeter||
1198: p_ao_approval_number || v_delimeter||
1199: p_recHash ) ;
1200: ELSE
1201: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,
1202: LPAD(p_line_number, sq_len_9 , v_quart_pad) || v_pad_char ||
1203: LPAD(upper(p_record_type) , sq_len_2 , v_quart_pad) || v_pad_char ||
1204: LPAD(p_batch_number, sq_len_9 , v_quart_pad) || v_pad_char ||
1205: LPAD(p_challan_count, sq_len_9 , v_quart_pad) || v_pad_char ||

Line 1483: UTL_FILE.PUT_LINE(

1479: )
1480: IS
1481: BEGIN
1482: IF p_generate_headers = 'N' THEN
1483: UTL_FILE.PUT_LINE(
1484: jai_ap_tds_etds_pkg.v_filehandle,p_line_number || v_delimeter||
1485: upper(p_record_type) || v_delimeter||
1486: p_batch_number || v_delimeter||
1487: p_challan_dtl_slno || v_delimeter||

Line 1524: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,

1520: p_book_entry || v_delimeter||
1521: p_remarks || v_delimeter||
1522: p_ch_recHash ) ;
1523: ELSE
1524: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,
1525: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
1526: LPAD(upper(p_record_type) , sq_len_2, v_quart_pad) || v_pad_char ||
1527: LPAD(p_batch_number , sq_len_9, v_quart_pad) || v_pad_char ||
1528: LPAD(p_challan_dtl_slno , sq_len_9, v_quart_pad) || v_pad_char ||

Line 1584: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1580: ) IS
1581:
1582: BEGIN
1583:
1584: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1585: LPAD(p_line_number, s_line_number, v_pad_number)
1586: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
1587: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_file_type, s_file_type, v_pad_char)
1588: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_upload_type, s_upload_type, v_pad_char)

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

1596: PROCEDURE create_dd IS
1597: BEGIN
1598:
1599: -- Deductee Detail
1600: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
1601: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1602: LPAD('LineNo', s_line_number, v_pad_char)
1603: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1604: ||v_pad_char||LPAD('B.No.', s_batch_number, v_pad_char)

Line 1601: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1597: BEGIN
1598:
1599: -- Deductee Detail
1600: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
1601: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1602: LPAD('LineNo', s_line_number, v_pad_char)
1603: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1604: ||v_pad_char||LPAD('B.No.', s_batch_number, v_pad_char)
1605: ||v_pad_char||LPAD('DSlNo', s_deductee_slno, v_pad_char)

Line 1634: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1630: ||v_pad_char||LPAD('Filler5', s_filler, v_pad_char)
1631: );
1632:
1633:
1634: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1635: LPAD(v_underline_char, s_line_number, v_underline_char)
1636: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
1637: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
1638: ||v_pad_char||LPAD(v_underline_char, s_deductee_slno, v_underline_char)

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

1672:
1673: -- File Header
1674: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
1675:
1676: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
1677: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
1678: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1679: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1680: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

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

1673: -- File Header
1674: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
1675:
1676: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
1677: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
1678: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1679: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1680: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1681: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

Line 1678: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1674: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
1675:
1676: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
1677: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
1678: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1679: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1680: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1681: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1682: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

Line 1700: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1696: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1697: );
1698:
1699:
1700: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1701: LPAD('LineNo', s_line_number, v_pad_char)
1702: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1703: ||v_pad_char||RPAD('FT', s_file_type, v_pad_char)
1704: ||v_pad_char||RPAD('UT', s_upload_type, v_pad_char)

Line 1710: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1706: ||v_pad_char||LPAD('FSeqNo', s_file_sequence_number, v_pad_char)
1707: ||v_pad_char||RPAD('Org Tan', s_deductor_tan, v_pad_char)
1708: ||v_pad_char||LPAD('NoOfBatches', s_number_of_batches, v_pad_char)
1709: );
1710: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1711: LPAD(v_underline_char, s_line_number, v_underline_char)
1712: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
1713: ||v_pad_char||RPAD(v_underline_char, s_file_type, v_underline_char)
1714: ||v_pad_char||RPAD(v_underline_char, s_upload_type, v_underline_char)

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

1722: PROCEDURE create_cd IS
1723: BEGIN
1724:
1725: -- Challan Detail
1726: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
1727: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1728: LPAD('LineNo', s_line_number, v_pad_char)
1729: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1730: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)

Line 1727: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1723: BEGIN
1724:
1725: -- Challan Detail
1726: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
1727: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1728: LPAD('LineNo', s_line_number, v_pad_char)
1729: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1730: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)
1731: ||v_pad_char||LPAD('CSlNo', s_challan_slno, v_pad_char)

Line 1746: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1742: ||v_pad_char||RPAD('Chal.Num.', s_challan_no, v_pad_char)
1743: ||v_pad_char||RPAD('TBE ', s_tds_dep_book_ent , v_pad_char)
1744: ||v_pad_char||RPAD('C', s_filler4 , v_pad_char)
1745: );
1746: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1747: LPAD(v_underline_char, s_line_number, v_underline_char)
1748: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
1749: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
1750: ||v_pad_char||LPAD(v_underline_char, s_challan_slno, v_underline_char)

Line 1801: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1797: ) IS
1798:
1799: BEGIN
1800:
1801: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1802: LPAD(p_line_number, s_line_number, v_pad_number)
1803: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
1804: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_batch_number, s_batch_number, v_pad_number)
1805: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_slno,0), s_deductee_slno, v_pad_number)