[Home] [Help]
102: -- 120.24 12-DEC-2006 PMADDULA Bug 5674047 - In Procedure JEITPSSR,
103: -- added a new column assessable_value to
104: -- the cursor 'c_italian_vat' in JEITPSSR procedure.
105: -- Populated the column 'jg_ingo_n11' of table
106: -- jg_zz_vat_trx_gt with the value obtained.
107: -- This is to display correct taxable amount
108: -- when the tax type code of the transaction
109: -- is eitther 'Custom Bill' or 'Self Invoice'.
110: -- 120.26 20-DEC-2006 RJREDDY Bug 5718147: Changed the c_belgian_vat cursor query in JEBEVA06 procedure,
331: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');
332: END;
333:
334:
335: INSERT INTO jg_zz_vat_trx_gt
336: (
337: jg_info_n1
338: ,jg_info_v1
339: ,jg_info_v2
724: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
725: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
726: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
727: END IF;
728: INSERT INTO jg_zz_vat_trx_gt
729: (
730: jg_info_n1
731: , jg_info_v1
732: , jg_info_v2
764: );
765:
766: END LOOP;
767:
768: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
769: IF p_debug_flag = 'Y' THEN
770: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
771: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
772: END IF;
766: END LOOP;
767:
768: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
769: IF p_debug_flag = 'Y' THEN
770: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
771: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
772: END IF;
773: EXCEPTION
774: WHEN OTHERS THEN
946: fnd_file.put_line(fnd_file.log,'-----------------------------------');
947: END IF;
948:
949: IF v_box_amounts.EXISTS(i) and i <= 1000 THEN
950: INSERT INTO jg_zz_vat_trx_gt ( jg_info_n1
951: ,jg_info_n2
952: ,jg_info_n3
953: ,jg_info_n4
954: ,jg_info_v1
960: v_box_amounts(i).tot_box_num,
961: v_box_amounts(i).box_type
962: );
963: ELSIF v_box_amounts.EXISTS(i) and i > 1000 THEN --This must be a tax box
964: INSERT INTO jg_zz_vat_trx_gt ( jg_info_n1
965: ,jg_info_n2
966: ,jg_info_n3
967: ,jg_info_n5
968: ,jg_info_v1
977: END IF;
978: END LOOP;
979: END IF;
980:
981: select count(*) into l_count from jg_zz_vat_trx_gt ;
982: IF p_debug_flag = 'Y' THEN
983: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table :' || l_count );
984: END IF ;
985: EXCEPTION
979: END IF;
980:
981: select count(*) into l_count from jg_zz_vat_trx_gt ;
982: IF p_debug_flag = 'Y' THEN
983: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table :' || l_count );
984: END IF ;
985: EXCEPTION
986: WHEN OTHERS THEN
987: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));
1130: IF l_data_found = 'Y' THEN
1131: FOR i in v_box_amounts.FIRST .. v_box_amounts.LAST LOOP
1132:
1133: IF v_box_amounts.EXISTS(i) THEN
1134: INSERT INTO jg_zz_vat_trx_gt(
1135: jg_info_n1,
1136: jg_info_n2,
1137: jg_info_n3,
1138: jg_info_n4,
1148: END IF;
1149: END LOOP;
1150: END IF;
1151:
1152: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1153: IF p_debug_flag = 'Y' THEN
1154: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1155: END IF ;
1156:
1150: END IF;
1151:
1152: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1153: IF p_debug_flag = 'Y' THEN
1154: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1155: END IF ;
1156:
1157: EXCEPTION
1158: WHEN OTHERS THEN
1226: l_count NUMBER := 0 ;
1227: BEGIN
1228:
1229: FOR l_it_vat IN c_italian_vat LOOP
1230: INSERT INTO jg_zz_vat_trx_gt
1231: (
1232: jg_info_v1
1233: ,jg_info_v2
1234: ,jg_info_n1
1290: ,l_it_vat.assessable_value
1291: );
1292: END LOOP;
1293:
1294: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1295: IF p_debug_flag = 'Y' THEN
1296: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1297: END IF ;
1298:
1292: END LOOP;
1293:
1294: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1295: IF p_debug_flag = 'Y' THEN
1296: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1297: END IF ;
1298:
1299: EXCEPTION
1300: WHEN OTHERS THEN
1536: AND ROWNUM = 1;
1537: Bug:8237932*/
1538:
1539: CURSOR c_get_period_start_date IS
1540: SELECT jg_info_d2 FROM jg_zz_vat_trx_gt WHERE jg_info_v30 = 'H';
1541:
1542: /*Added three new cursors:
1543: c_get_last_process_date ,c_get_balance,c_get_flag*/
1544: --Bug:8237932