[Home] [Help]
953:
954: ln_lines_to_insert number;
955: ln_nrec_tax_amt number;
956: ln_rec_tax_amt number;
957: lv_modvat_flag jai_ap_match_inv_taxes.recoverable_flag%type;
958:
959: lv_excise_costing_flag varchar2 (1);
960:
961: lv_tax_type varchar2(5); --added by eric for inclusive tax
1236: cursor c_get_orig_tax_line
1237: (p_orig_invoice_id number, p_orig_invoice_dist_id number, p_tax_id number) is
1238: -- 5763527 , Added SUM as there can be two tax lines against the same tax_id because of partialy recoverable taxes
1239: select sum(tax_amount) tax_amount-- project costing fwd porting
1240: from JAI_AP_MATCH_INV_TAXES
1241: where p_orig_invoice_id = p_orig_invoice_id
1242: and parent_invoice_distribution_id = p_orig_invoice_dist_id
1243: and tax_id = p_tax_id;
1244:
1435: This issue happens only during receipt matching.
1436:
1437: 18. 07/04/2003 Aparajita for bug # 2851123. Version # 615.10
1438: The assets_tracking_flag in ap_invoice_distributions_all,
1439: JAI_AP_MATCH_INV_TAXES and JAI_CMN_FA_INV_DIST_ALL should
1440: be set as 'N' if the tax line against which the line is being generated
1441: is excise type of tax and is modvatable. By default this flag gets the value
1442: from the corresponding item line for which the tax is attached.
1443:
1684: instead these will be populated in the global attribute columns. So the code changes are
1685: made accordingly.
1686:
1687: 46 10-Jun-2005 rallamse for bug# Version 116.2
1688: All inserts into JAI_AP_MATCH_INV_TAXES table now include legal_entity_id as
1689: part of R12 LE Initiative. The legal_entity_id is selected from ap_invoices_all in
1690: cursor get_ven_info.
1691:
1692: 47 23-Jun-2005 Brathod for Bug# 4445989, Version 120.0
1698: invoice_id and invoice_line_number as unique combination
1699: - invoice line record is created in ap_invoice_lines_all where ever previously
1700: distribution was created
1701: - Obsoleted JAI_CMN_FA_INV_DIST_ALL
1702: - Modified structure of JAI_AP_MATCH_INV_TAXES to incorporate invoice lines
1703: and also the fields from JAI_CMN_FA_INV_DIST_ALL
1704: - Code modfied to insert appropriate fields in JAI_AP_MATCH_INV_TAXES
1705:
1706: 48. 06-Jul-2005 Sanjikum for Bug#4474501
1700: distribution was created
1701: - Obsoleted JAI_CMN_FA_INV_DIST_ALL
1702: - Modified structure of JAI_AP_MATCH_INV_TAXES to incorporate invoice lines
1703: and also the fields from JAI_CMN_FA_INV_DIST_ALL
1704: - Code modfied to insert appropriate fields in JAI_AP_MATCH_INV_TAXES
1705:
1706: 48. 06-Jul-2005 Sanjikum for Bug#4474501
1707: 1) Commented the cursor - for_acct_id and corresponding open/fetch/close for the same.
1708: 2) Commented the call to function - jai_general_pkg.get_accounting_method
1747:
1748: -------------------------------------------------------------------------------------------------------
1749: Version Bug Dependencies (including other objects like files if any)
1750: --------------------------------------------------------------------------------------------------------
1751: 616.1 3038566 ALTER Script JAI_AP_MATCH_INV_TAXES Table is altered.
1752:
1753: 115.3 3752887 Dependency on function jai_ap_interface_pkg.get_apportion_factor which is also added
1754: in this patch. So no pre - req.
1755:
2808: -----------------------------------------------------------------
2809: --added by Eric for inclusive tax on 20-dec-2007,end
2810:
2811:
2812: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
2813:
2814: --added by Eric for inclusive tax on 20-dec-2007,begin
2815: -----------------------------------------------------------------
2816: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
2816: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
2817: THEN
2818: -----------------------------------------------------------------
2819: --added by Eric for inclusive tax on 20-dec-2007,end
2820: INSERT INTO JAI_AP_MATCH_INV_TAXES
2821: (
2822: tax_distribution_id,
2823:
2824: assets_tracking_flag,
2859: )
2860: -- End Bug# 4445989
2861: VALUES
2862: (
2863: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
2864:
2865: v_assets_tracking_flag, -- 'N', Commented by Aparajita for bug # 2851123
2866: inv_id,
2867: cur_items_rec.po_header_id,
3659: END IF; --( NVL(lv_ap_line_to_inst_flag,'N')='Y')
3660: ------------------------------------------------------
3661: --added by Eric for inclusive tax on 20-dec-2007,end
3662:
3663: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
3664: INSERT INTO JAI_AP_MATCH_INV_TAXES
3665: (
3666: tax_distribution_id,
3667: exchange_rate_variance,
3660: ------------------------------------------------------
3661: --added by Eric for inclusive tax on 20-dec-2007,end
3662:
3663: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
3664: INSERT INTO JAI_AP_MATCH_INV_TAXES
3665: (
3666: tax_distribution_id,
3667: exchange_rate_variance,
3668: assets_tracking_flag,
3705: ,line_no -- Bug 5553150, 5593895
3706: )
3707: VALUES
3708: (
3709: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
3710: null,--kunkumar for forward porting to R12
3711: v_assets_tracking_flag, -- 'N', bug # 2851123
3712: inv_id,
3713: cur_items_rec.po_header_id,
4515: ----------------------------------------------------------------
4516: --added by Eric for inclusive tax on 20-dec-2007,end
4517:
4518:
4519: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
4520:
4521: --added by Eric for inclusive tax on 20-dec-2007,begin
4522: -----------------------------------------------------------------
4523: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
4524: THEN
4525: -----------------------------------------------------------------
4526: --added by Eric for inclusive tax on 20-dec-2007,end
4527:
4528: INSERT INTO JAI_AP_MATCH_INV_TAXES
4529: (
4530: tax_distribution_id,
4531: exchange_rate_variance,
4532: assets_tracking_flag,
4571: ,line_no -- Bug 5553150, 5593895
4572: )
4573: VALUES
4574: (
4575: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
4576: null,--kunkumar for forward porting to R12
4577: v_assets_tracking_flag, -- 'N', bug # 2851123
4578: inv_id,
4579: cur_items_rec.po_header_id,
5462: THEN
5463: -----------------------------------------------------------------
5464: --added by Eric for inclusive tax on 20-dec-2007,end
5465:
5466: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
5467: INSERT INTO JAI_AP_MATCH_INV_TAXES
5468: (
5469: tax_distribution_id,
5470: --shipment_line_id,
5463: -----------------------------------------------------------------
5464: --added by Eric for inclusive tax on 20-dec-2007,end
5465:
5466: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
5467: INSERT INTO JAI_AP_MATCH_INV_TAXES
5468: (
5469: tax_distribution_id,
5470: --shipment_line_id,
5471: exchange_rate_variance,
5512: )
5513:
5514: VALUES
5515: (
5516: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
5517: null,--kunkumar for forward porting to R12
5518: v_assets_tracking_flag, -- 'N', bug # 2851123
5519: inv_id,
5520: cur_items_rec.po_header_id, /* All references to r_cur_items_rec have been replaced by cur_items_rec */
6002:
6003: ln_lines_to_insert number;
6004: ln_nrec_tax_amt number;
6005: ln_rec_tax_amt number;
6006: lv_modvat_flag jai_ap_match_inv_taxes.recoverable_flag%type;
6007:
6008: lv_excise_costing_flag varchar2 (1);
6009: lv_tax_type varchar2(5); --added by eric for inclusive tax
6010: lv_tax_line_amount NUMBER := 0; --added by eric for inclusive tax
6312: from_line_location_taxes to conside such tax lines for propagation into AP.
6313:
6314: 11. 15/03/2003 Aparajita for bug # 2851123. Version # 615.9
6315: The assets_tracking_flag in ap_invoice_distributions_all,
6316: JAI_AP_MATCH_INV_TAXES and JAI_CMN_FA_INV_DIST_ALL should be set as 'N'
6317: if the tax line against which the line is being generated is excise type of
6318: tax and is modvatable. By default this flag gets the value from the
6319: corresponding item line for which the tax is attached.
6320:
6546: instead these will be populated in the global attribute columns. So the code changes are
6547: made accordingly.
6548:
6549: 43. 10-Jun-2005 rallamse for bug# Version 116.2
6550: All inserts into JAI_AP_MATCH_INV_TAXES table now include legal_entity_id as
6551: part of R12 LE Initiative. The legal_entity_id is selected from ap_invoices_all in
6552: cursor get_ven_info.
6553:
6554: 44 23-Jun-2005 Brathod for Bug# 4445989, Version 120.0
6560: invoice_id and invoice_line_number as unique combination
6561: - invoice line record is created in ap_invoice_lines_all where ever previously
6562: distribution was created
6563: - Obsoleted JAI_CMN_FA_INV_DIST_ALL
6564: - Modified structure of JAI_AP_MATCH_INV_TAXES to incorporate invoice lines
6565: and also the fields from JAI_CMN_FA_INV_DIST_ALL
6566: - Code modfied to insert appropriate fields in JAI_AP_MATCH_INV_TAXES
6567:
6568: 45. 06-Jul-2005 Sanjikum for Bug#4474501
6562: distribution was created
6563: - Obsoleted JAI_CMN_FA_INV_DIST_ALL
6564: - Modified structure of JAI_AP_MATCH_INV_TAXES to incorporate invoice lines
6565: and also the fields from JAI_CMN_FA_INV_DIST_ALL
6566: - Code modfied to insert appropriate fields in JAI_AP_MATCH_INV_TAXES
6567:
6568: 45. 06-Jul-2005 Sanjikum for Bug#4474501
6569: 1) Commented the cursor - for_acct_id and corresponding open/fetch/close for the same.
6570: 2) Commented the call to function - jai_general_pkg.get_accounting_method
6595:
6596: ------------------------------------------------------------------------------------------------------
6597: Version Bug Dependencies (including other objects like files if any)
6598: -------------------------------------------------------------------------------------------------------
6599: 616.1 3038566 ALTER Script JAI_AP_MATCH_INV_TAXES Table is altered.
6600:
6601: 115.1 3752887 Dependency on function jai_ap_interface_pkg.get_apportion_factor which is also added
6602: in this patch. So no pre - req.
6603:
7465: THEN
7466: -----------------------------------------------------------------
7467: --added by Eric for inclusive tax on 20-dec-2007,end
7468:
7469: INSERT INTO JAI_AP_MATCH_INV_TAXES
7470: (
7471: tax_distribution_id,
7472: exchange_rate_variance,
7473: assets_tracking_flag,
7509:
7510: )
7511: VALUES
7512: (
7513: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
7514: null,--kunkumar for forward porting to R12
7515: v_assets_tracking_flag , -- 'N', bug#2851123
7516: inv_id,
7517: cur_items_rec.po_header_id,
8316: THEN
8317: -----------------------------------------------------------------
8318: --added by Eric for inclusive tax on 20-dec-2007,end
8319:
8320: INSERT INTO JAI_AP_MATCH_INV_TAXES
8321: (
8322: tax_distribution_id,
8323: exchange_rate_variance,
8324: assets_tracking_flag,
8361: /* End 5763527 */
8362: )
8363: VALUES
8364: (
8365: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
8366: null,--kunkumar for forward porting to R12
8367: v_assets_tracking_flag , -- 'N', bug#2851123
8368: inv_id,
8369: cur_items_rec.po_header_id,
9154: --added by Eric for inclusive tax on 20-dec-2007,end
9155:
9156:
9157: Fnd_File.put_line(Fnd_File.LOG,
9158: 'Before inserting into JAI_AP_MATCH_INV_TAXES tax id ' || i.tax_id );
9159: --added by Eric for inclusive tax on 20-dec-2007,begin
9160: -----------------------------------------------------------------
9161: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
9162: THEN
9161: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
9162: THEN
9163: -----------------------------------------------------------------
9164: --added by Eric for inclusive tax on 20-dec-2007,end
9165: INSERT INTO JAI_AP_MATCH_INV_TAXES
9166: (
9167: tax_distribution_id,
9168: exchange_rate_variance,
9169: assets_tracking_flag,
9202: ,line_no -- added, Harshita for Bug 5553150
9203: )
9204: VALUES
9205: (
9206: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
9207: null,--kunkumar for forward porting to R12
9208: v_assets_tracking_flag , -- 'N', bug#2851123
9209: inv_id,
9210: cur_items_rec.po_header_id,