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 187: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 5000); --Added 5000 buffer size for bug#6647362

183: ) IS
184:
185: BEGIN
186:
187: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 5000); --Added 5000 buffer size for bug#6647362
188:
189: v_utl_file_dir := p_directory;
190: v_utl_file_name := p_filename;
191:

Line 189: v_utl_file_dir := p_directory;

185: BEGIN
186:
187: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 5000); --Added 5000 buffer size for bug#6647362
188:
189: v_utl_file_dir := p_directory;
190: v_utl_file_name := p_filename;
191:
192: END openFile;
193:

Line 190: v_utl_file_name := p_filename;

186:
187: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 5000); --Added 5000 buffer size for bug#6647362
188:
189: v_utl_file_dir := p_directory;
190: v_utl_file_name := p_filename;
191:
192: END openFile;
193:
194: PROCEDURE closeFile IS

Line 196: UTL_FILE.fclose(v_filehandle);

192: END openFile;
193:
194: PROCEDURE closeFile IS
195: BEGIN
196: UTL_FILE.fclose(v_filehandle);
197: END closeFile;
198:
199: PROCEDURE populate_details(
200: p_batch_id IN NUMBER,

Line 795: UTL_FILE.PUT_LINE(v_filehandle,

791: ) IS
792:
793: BEGIN
794:
795: UTL_FILE.PUT_LINE(v_filehandle,
796: LPAD(p_line_number, s_line_number, v_pad_number)
797: ||v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
798: ||v_debug_pad_char||RPAD(p_file_type, s_file_type, v_pad_char)
799: ||v_debug_pad_char||RPAD(p_upload_type, s_upload_type, v_pad_char)

Line 847: UTL_FILE.PUT_LINE(v_filehandle,

843: ) IS
844:
845: BEGIN
846:
847: UTL_FILE.PUT_LINE(v_filehandle,
848: LPAD(p_line_number, s_line_number, v_pad_number)
849: ||v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
850: ||v_debug_pad_char||LPAD(p_batch_number, s_batch_number, v_pad_number)
851: ||v_debug_pad_char||LPAD(p_challan_count, s_challan_count, v_pad_number)

Line 904: UTL_FILE.PUT_LINE(v_filehandle,

900:
901: BEGIN
902: -- Bug 6796765. Added by Lakshmi Gopalsami
903: -- Added upper for both p_challan_section and Sec.()
904: UTL_FILE.PUT_LINE(v_filehandle,
905: LPAD(p_line_number, s_line_number, v_pad_number)
906: ||v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
907: ||v_debug_pad_char||LPAD(p_batch_number, s_batch_number, v_pad_number)
908: ||v_debug_pad_char||LPAD(nvl(p_challan_slno,0), s_challan_slno, v_pad_number)

Line 957: UTL_FILE.PUT_LINE(v_filehandle,

953:
954: -- Bug 6796765. Added by Lakshmi Gopalsami
955: -- Added upper for both p_deductee_section and Sec.()
956:
957: UTL_FILE.PUT_LINE(v_filehandle,
958: LPAD(p_line_number, s_line_number, v_pad_number)
959: ||v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
960: ||v_debug_pad_char||LPAD(p_batch_number, s_batch_number, v_pad_number)
961: ||v_debug_pad_char||LPAD(nvl(p_deductee_slno,0), s_deductee_slno, v_pad_number)

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

993:
994: -- File Header
995: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
996:
997: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
998: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
999: UTL_FILE.PUT_LINE(v_filehandle,
1000: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

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

994: -- File Header
995: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
996:
997: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
998: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
999: UTL_FILE.PUT_LINE(v_filehandle,
1000: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)

Line 999: UTL_FILE.PUT_LINE(v_filehandle,

995: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
996:
997: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
998: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
999: UTL_FILE.PUT_LINE(v_filehandle,
1000: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1001: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1002: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
1003: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

Line 1022: UTL_FILE.PUT_LINE(v_filehandle,

1018: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1019: );
1020:
1021:
1022: UTL_FILE.PUT_LINE(v_filehandle,
1023: LPAD('LineNo', s_line_number, v_pad_char)
1024: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1025: ||v_pad_char||RPAD('FT', s_file_type, v_pad_char)
1026: ||v_pad_char||RPAD('UT', s_upload_type, v_pad_char)

Line 1032: UTL_FILE.PUT_LINE(v_filehandle,

1028: ||v_pad_char||LPAD('FSeqNo', s_file_sequence_number, v_pad_char)
1029: ||v_pad_char||RPAD('Org Tan', s_deductor_tan, v_pad_char)
1030: ||v_pad_char||LPAD('NoOfBatches', s_number_of_batches, v_pad_char)
1031: );
1032: UTL_FILE.PUT_LINE(v_filehandle,
1033: LPAD(v_underline_char, s_line_number, v_underline_char)
1034: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
1035: ||v_pad_char||RPAD(v_underline_char, s_file_type, v_underline_char)
1036: ||v_pad_char||RPAD(v_underline_char, s_upload_type, v_underline_char)

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

1059: v_req JAI_AP_ETDS_REQUESTS%rowtype;
1060: BEGIN
1061: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
1062:
1063: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
1064: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
1065: UTL_FILE.PUT_LINE(v_filehandle,
1066: ' batch_id ->'||v_req.batch_id||v_chr10
1067: ||' request_id ->'||v_req.request_id||v_chr10

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

1060: BEGIN
1061: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
1062:
1063: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
1064: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
1065: UTL_FILE.PUT_LINE(v_filehandle,
1066: ' batch_id ->'||v_req.batch_id||v_chr10
1067: ||' request_id ->'||v_req.request_id||v_chr10
1068: ||' legal_entity_id ->'||v_req.legal_entity_id||v_chr10

Line 1065: UTL_FILE.PUT_LINE(v_filehandle,

1061: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
1062:
1063: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
1064: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
1065: UTL_FILE.PUT_LINE(v_filehandle,
1066: ' batch_id ->'||v_req.batch_id||v_chr10
1067: ||' request_id ->'||v_req.request_id||v_chr10
1068: ||' legal_entity_id ->'||v_req.legal_entity_id||v_chr10
1069: ||' operating_unit_id ->'||v_req.operating_unit_id||v_chr10

Line 1099: UTL_FILE.PUT_LINE(v_filehandle,

1095: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||v_chr10
1096: );
1097:
1098:
1099: UTL_FILE.PUT_LINE(v_filehandle,
1100: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
1101: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
1102: LPAD('FT', sq_len_4, v_quart_pad) || v_pad_char ||
1103: LPAD('UT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 1117: UTL_FILE.PUT_LINE(v_filehandle,

1113: LPAD('SH', sq_len_2, v_quart_pad) || v_pad_char ||
1114: LPAD('SV', sq_len_2, v_quart_pad) || v_pad_char ||
1115: LPAD('SH', sq_len_2, v_quart_pad) );
1116:
1117: UTL_FILE.PUT_LINE(v_filehandle,
1118: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
1119: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
1120: LPAD(v_underline_char, sq_len_4, v_underline_char) || v_pad_char ||
1121: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||

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

1137: PROCEDURE create_bh IS
1138: BEGIN
1139:
1140: -- Batch Header
1141: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
1142: UTL_FILE.PUT_LINE(v_filehandle,
1143: LPAD('LineNo', s_line_number, v_pad_char)
1144: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1145: ||v_pad_char||LPAD('BNo', s_batch_number, v_pad_char)

Line 1142: UTL_FILE.PUT_LINE(v_filehandle,

1138: BEGIN
1139:
1140: -- Batch Header
1141: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
1142: UTL_FILE.PUT_LINE(v_filehandle,
1143: LPAD('LineNo', s_line_number, v_pad_char)
1144: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1145: ||v_pad_char||LPAD('BNo', s_batch_number, v_pad_char)
1146: ||v_pad_char||LPAD('Ch.Cnt', s_challan_count, v_pad_char)

Line 1171: UTL_FILE.PUT_LINE(v_filehandle,

1167: ||v_pad_char||RPAD('PersonDesignation', s_pers_designation, v_pad_char)
1168: ||v_pad_char||LPAD('TotChallanTax', s_tot_tax_dedected_challan, v_pad_char)
1169: ||v_pad_char||LPAD('TotDeducteeTax', s_tot_tax_dedected_deductee, v_pad_char)
1170: );
1171: UTL_FILE.PUT_LINE(v_filehandle,
1172: LPAD(v_underline_char, s_line_number, v_underline_char)
1173: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
1174: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
1175: ||v_pad_char||LPAD(v_underline_char, s_challan_count, v_underline_char)

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

1200: END create_bh;
1201:
1202: PROCEDURE create_quarterly_bh IS
1203: BEGIN
1204: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
1205:
1206: UTL_FILE.PUT_LINE(v_filehandle,
1207: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
1208: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 1206: UTL_FILE.PUT_LINE(v_filehandle,

1202: PROCEDURE create_quarterly_bh IS
1203: BEGIN
1204: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
1205:
1206: UTL_FILE.PUT_LINE(v_filehandle,
1207: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
1208: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
1209: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||
1210: LPAD('ChallCnt', sq_len_9, v_quart_pad) || v_pad_char ||

Line 1262: UTL_FILE.PUT_LINE(v_filehandle,

1258: LPAD('AO Approval No', sq_len_15, v_quart_pad) || v_pad_char ||
1259: LPAD('RH', sq_len_2, v_quart_pad)
1260: );
1261:
1262: UTL_FILE.PUT_LINE(v_filehandle,
1263: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
1264: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
1265: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
1266: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||

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

1318: END create_quarterly_bh;
1319:
1320: PROCEDURE create_quarterly_cd IS
1321: BEGIN
1322: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
1323: UTL_FILE.PUT_LINE(v_filehandle,
1324: LPAD('Line No', sq_len_9 , v_quart_pad) || v_pad_char ||
1325: LPAD('RT', sq_len_2 , v_quart_pad) || v_pad_char ||
1326: LPAD('Batch No', sq_len_9 , v_quart_pad) || v_pad_char ||

Line 1323: UTL_FILE.PUT_LINE(v_filehandle,

1319:
1320: PROCEDURE create_quarterly_cd IS
1321: BEGIN
1322: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
1323: UTL_FILE.PUT_LINE(v_filehandle,
1324: LPAD('Line No', sq_len_9 , v_quart_pad) || v_pad_char ||
1325: LPAD('RT', sq_len_2 , v_quart_pad) || v_pad_char ||
1326: LPAD('Batch No', sq_len_9 , v_quart_pad) || v_pad_char ||
1327: LPAD('Chall No', sq_len_9 , v_quart_pad) || v_pad_char ||

Line 1365: UTL_FILE.PUT_LINE(v_filehandle,

1361: LPAD('Remarks', sq_len_14 , v_quart_pad) || v_pad_char ||
1362: LPAD('RH', sq_len_2 , v_quart_pad)
1363: );
1364:
1365: UTL_FILE.PUT_LINE(v_filehandle,
1366: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
1367: LPAD(v_underline_char , sq_len_2 , v_underline_char) || v_pad_char ||
1368: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
1369: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||

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

1407: END create_quarterly_cd;
1408:
1409: PROCEDURE create_quarterly_dd IS
1410: BEGIN
1411: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
1412: UTL_FILE.PUT_LINE(v_filehandle,
1413: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
1414: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
1415: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||

Line 1412: UTL_FILE.PUT_LINE(v_filehandle,

1408:
1409: PROCEDURE create_quarterly_dd IS
1410: BEGIN
1411: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
1412: UTL_FILE.PUT_LINE(v_filehandle,
1413: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
1414: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
1415: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||
1416: LPAD('ChallNo', sq_len_9, v_quart_pad) || v_pad_char ||

Line 1448: UTL_FILE.PUT_LINE(v_filehandle,

1444: LPAD('Remarks 3', sq_len_14, v_quart_pad) || v_pad_char ||
1445: LPAD('RH', sq_len_2, v_quart_pad)
1446: );
1447:
1448: UTL_FILE.PUT_LINE(v_filehandle,
1449: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
1450: LPAD(v_underline_char , sq_len_2 , v_underline_char) || v_pad_char ||
1451: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
1452: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||

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

1487: PROCEDURE create_cd IS
1488: BEGIN
1489:
1490: -- Challan Detail
1491: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
1492: UTL_FILE.PUT_LINE(v_filehandle,
1493: LPAD('LineNo', s_line_number, v_pad_char)
1494: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1495: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)

Line 1492: UTL_FILE.PUT_LINE(v_filehandle,

1488: BEGIN
1489:
1490: -- Challan Detail
1491: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
1492: UTL_FILE.PUT_LINE(v_filehandle,
1493: LPAD('LineNo', s_line_number, v_pad_char)
1494: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1495: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)
1496: ||v_pad_char||LPAD('CSlNo', s_challan_slno, v_pad_char)

Line 1503: UTL_FILE.PUT_LINE(v_filehandle,

1499: ||v_pad_char||RPAD('Ch.Num.', s_challan_num, v_pad_char)
1500: ||v_pad_char||LPAD('Ch.Date', s_date, v_pad_char)
1501: ||v_pad_char||RPAD('BankBrCode', s_bank_branch_code, v_pad_char)
1502: );
1503: UTL_FILE.PUT_LINE(v_filehandle,
1504: LPAD(v_underline_char, s_line_number, v_underline_char)
1505: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
1506: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
1507: ||v_pad_char||LPAD(v_underline_char, s_challan_slno, v_underline_char)

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

1520: p_grossing_up_factor Obsoleted via bug # 4353842
1521: */
1522:
1523: -- Deductee Detail
1524: UTL_FILE.PUT_LINE(v_filehandle, v_chr10 );
1525: UTL_FILE.PUT_LINE(v_filehandle,
1526: LPAD('LineNo', s_line_number, v_pad_char)
1527: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1528: ||v_pad_char||LPAD('B.No.', s_batch_number, v_pad_char)

Line 1525: UTL_FILE.PUT_LINE(v_filehandle,

1521: */
1522:
1523: -- Deductee Detail
1524: UTL_FILE.PUT_LINE(v_filehandle, v_chr10 );
1525: UTL_FILE.PUT_LINE(v_filehandle,
1526: LPAD('LineNo', s_line_number, v_pad_char)
1527: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1528: ||v_pad_char||LPAD('B.No.', s_batch_number, v_pad_char)
1529: ||v_pad_char||LPAD('DSlNo', s_deductee_slno, v_pad_char)

Line 1562: UTL_FILE.PUT_LINE(v_filehandle,

1558: /* Bug 4353842. Added by Lakshmi Gopalsami
1559: p_grossing_up_factor Obsoleted via bug # 4353842
1560: */
1561:
1562: UTL_FILE.PUT_LINE(v_filehandle,
1563: LPAD(v_underline_char, s_line_number, v_underline_char)
1564: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
1565: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
1566: ||v_pad_char||LPAD(v_underline_char, s_deductee_slno, v_underline_char)

Line 1625: UTL_FILE.PUT_LINE(v_filehandle,

1621: IS
1622: BEGIN
1623: IF p_generate_headers = 'N' THEN
1624:
1625: UTL_FILE.PUT_LINE(v_filehandle,
1626: p_line_number || v_delimeter||
1627: p_record_type || v_delimeter||
1628: p_file_type || v_delimeter||
1629: p_upload_type || v_delimeter||

Line 1643: UTL_FILE.PUT_LINE(v_filehandle,

1639: p_fh_samHash || v_delimeter||
1640: p_fh_scmVersion || v_delimeter||
1641: p_fh_scmHash);
1642: ELSE
1643: UTL_FILE.PUT_LINE(v_filehandle,
1644: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
1645: LPAD(p_record_type , sq_len_2, v_quart_pad) || v_pad_char ||
1646: LPAD(p_file_type , sq_len_4, v_quart_pad) || v_pad_char ||
1647: LPAD(p_upload_type , sq_len_2, v_quart_pad) || v_pad_char ||

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

1722: )
1723: IS
1724: BEGIN
1725: IF p_generate_headers = 'N' THEN
1726: UTL_FILE.PUT_LINE( v_filehandle, p_line_number || v_delimeter||
1727: p_record_type || v_delimeter||
1728: p_batch_number || v_delimeter||
1729: p_challan_count || v_delimeter||
1730: p_form_number || v_delimeter||

Line 1782: UTL_FILE.PUT_LINE( v_filehandle,

1778: p_recHash ) ;
1779:
1780:
1781: ELSE
1782: UTL_FILE.PUT_LINE( v_filehandle,
1783: LPAD(p_line_number, sq_len_9 , v_quart_pad) || v_pad_char ||
1784: LPAD(p_record_type , sq_len_2 , v_quart_pad) || v_pad_char ||
1785: LPAD(p_batch_number, sq_len_9 , v_quart_pad) || v_pad_char ||
1786: LPAD(p_challan_count, sq_len_9 , v_quart_pad) || v_pad_char ||

Line 1943: UTL_FILE.PUT_LINE(

1939:
1940: -- Bug 6796765. Added by Lakshmi Gopalsami
1941: -- Changed from getsectioncode to lv_output_string
1942:
1943: UTL_FILE.PUT_LINE(
1944: v_filehandle,p_line_number || v_delimeter||
1945: p_record_type || v_delimeter||
1946: p_batch_number || v_delimeter||
1947: p_challan_dtl_slno || v_delimeter||

Line 1988: UTL_FILE.PUT_LINE( v_filehandle,

1984: ELSE
1985: -- Bug 6796765. Added by Lakshmi Gopalsami
1986: -- Changed from getsectioncode to lv_output_string
1987:
1988: UTL_FILE.PUT_LINE( v_filehandle,
1989: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
1990: LPAD(p_record_type , sq_len_2, v_quart_pad) || v_pad_char ||
1991: LPAD(p_batch_number , sq_len_9, v_quart_pad) || v_pad_char ||
1992: LPAD(p_challan_dtl_slno , sq_len_9, v_quart_pad) || v_pad_char ||

Line 2073: UTL_FILE.PUT_LINE( v_filehandle,

2069: )
2070: IS
2071: BEGIN
2072: IF p_generate_headers = 'N' THEN
2073: UTL_FILE.PUT_LINE( v_filehandle,
2074: p_line_number || v_delimeter ||
2075: p_record_type || v_delimeter ||
2076: p_batch_number || v_delimeter ||
2077: p_dh_challan_recNo || v_delimeter ||

Line 2111: UTL_FILE.PUT_LINE( v_filehandle,

2107: p_remarks3 || v_delimeter ||
2108: p_dh_recHash
2109: );
2110: ELSE
2111: UTL_FILE.PUT_LINE( v_filehandle,
2112: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
2113: LPAD(p_record_type , sq_len_2, v_quart_pad) || v_pad_char ||
2114: LPAD(p_batch_number , sq_len_9, v_quart_pad) || v_pad_char ||
2115: LPAD(p_dh_challan_recNo , sq_len_9, v_quart_pad) || v_pad_char ||