[Home] [Help]
548:
549: Cursor c_match_tax_lines (p_invoice_id number) is /*Added by nprashar for bug # 12832424*/
550: select invoice_id, po_distribution_id, invoice_distribution_id, rcv_transaction_id,invoice_line_number,
551: parent_invoice_distribution_id
552: from jai_ap_match_inv_taxes
553: where line_type_lookup_code = 'MISCELLANEOUS'
554: and invoice_id = p_invoice_id
555: and parent_invoice_line_number = pn_invoice_line_number
556: and po_distribution_id = po_dist_id;
1250:
1251: ln_lines_to_insert number;
1252: ln_nrec_tax_amt number;
1253: ln_rec_tax_amt number;
1254: lv_modvat_flag jai_ap_match_inv_taxes.recoverable_flag%type;
1255:
1256: lv_excise_costing_flag varchar2 (1);
1257:
1258: lv_tax_type varchar2(5); --added by eric for inclusive tax
1555: cursor c_get_orig_tax_line
1556: (p_orig_invoice_id number, p_orig_invoice_dist_id number, p_tax_id number) is
1557: -- 5763527 , Added SUM as there can be two tax lines against the same tax_id because of partialy recoverable taxes
1558: select sum(jam.tax_amount) tax_amount-- project costing fwd porting
1559: from JAI_AP_MATCH_INV_TAXES jam,jai_cmn_taxes_all jct
1560: where p_orig_invoice_id = p_orig_invoice_id
1561: and parent_invoice_distribution_id = p_orig_invoice_dist_id
1562: and jam.tax_id = p_tax_id
1563: --start additions for bug#10167393
1762: This issue happens only during receipt matching.
1763:
1764: 18. 07/04/2003 Aparajita for bug # 2851123. Version # 615.10
1765: The assets_tracking_flag in ap_invoice_distributions_all,
1766: JAI_AP_MATCH_INV_TAXES and JAI_CMN_FA_INV_DIST_ALL should
1767: be set as 'N' if the tax line against which the line is being generated
1768: is excise type of tax and is modvatable. By default this flag gets the value
1769: from the corresponding item line for which the tax is attached.
1770:
2011: instead these will be populated in the global attribute columns. So the code changes are
2012: made accordingly.
2013:
2014: 46 10-Jun-2005 rallamse for bug# Version 116.2
2015: All inserts into JAI_AP_MATCH_INV_TAXES table now include legal_entity_id as
2016: part of R12 LE Initiative. The legal_entity_id is selected from ap_invoices_all in
2017: cursor get_ven_info.
2018:
2019: 47 23-Jun-2005 Brathod for Bug# 4445989, Version 120.0
2025: invoice_id and invoice_line_number as unique combination
2026: - invoice line record is created in ap_invoice_lines_all where ever previously
2027: distribution was created
2028: - Obsoleted JAI_CMN_FA_INV_DIST_ALL
2029: - Modified structure of JAI_AP_MATCH_INV_TAXES to incorporate invoice lines
2030: and also the fields from JAI_CMN_FA_INV_DIST_ALL
2031: - Code modfied to insert appropriate fields in JAI_AP_MATCH_INV_TAXES
2032:
2033: 48. 06-Jul-2005 Sanjikum for Bug#4474501
2027: distribution was created
2028: - Obsoleted JAI_CMN_FA_INV_DIST_ALL
2029: - Modified structure of JAI_AP_MATCH_INV_TAXES to incorporate invoice lines
2030: and also the fields from JAI_CMN_FA_INV_DIST_ALL
2031: - Code modfied to insert appropriate fields in JAI_AP_MATCH_INV_TAXES
2032:
2033: 48. 06-Jul-2005 Sanjikum for Bug#4474501
2034: 1) Commented the cursor - for_acct_id and corresponding open/fetch/close for the same.
2035: 2) Commented the call to function - jai_general_pkg.get_accounting_method
2087:
2088: -------------------------------------------------------------------------------------------------------
2089: Version Bug Dependencies (including other objects like files if any)
2090: --------------------------------------------------------------------------------------------------------
2091: 616.1 3038566 ALTER Script JAI_AP_MATCH_INV_TAXES Table is altered.
2092:
2093: 115.3 3752887 Dependency on function jai_ap_interface_pkg.get_apportion_factor which is also added
2094: in this patch. So no pre - req.
2095:
3541: -----------------------------------------------------------------
3542: --added by Eric for inclusive tax on 20-dec-2007,end
3543:
3544:
3545: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
3546:
3547: --added by Eric for inclusive tax on 20-dec-2007,begin
3548: -----------------------------------------------------------------
3549: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
3558: --For inclusive tax, should ln_inv_line_num here to ensure the column invoice_line_number
3559: --is the same as line number of ap_invoice_lines_all.
3560: --Added by Qinglei on 10-Feb-2012 for bug#13589613 end
3561:
3562: INSERT INTO JAI_AP_MATCH_INV_TAXES
3563: (
3564: tax_distribution_id,
3565:
3566: assets_tracking_flag,
3601: )
3602: -- End Bug# 4445989
3603: VALUES
3604: (
3605: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
3606:
3607: v_assets_tracking_flag, -- 'N', Commented by Aparajita for bug # 2851123
3608: inv_id,
3609: cur_items_rec.po_header_id,
3790: IF inclu_Serv_line =2 THEN
3791: ln_inv_line_num := ln_inv_line_num + 1;
3792: END IF;
3793: --For inclusive tax recoverable part, the positive invoice line should use invoice_line_number
3794: --when insert jai_ap_match_inv_taxes used; for the negative line, will use ln_inv_line_num + 1 as
3795: --line number.
3796: --Modified by Qinglei on 10-Feb-2012 for bug#13589613 end
3797: Fnd_File.put_line(Fnd_File.LOG,'Before inserting Inclusive Service tax lines for POT into ap_invoice_lines_all for line no :'|| ln_inv_line_num ||' tax amount = '||lv_tax_line_amount);
3798:
3995: );
3996:
3997: --Added by Qiong for bug13579239 begin
3998: --------------------------------
3999: UPDATE JAI_AP_MATCH_INV_TAXES jat
4000: SET jat.invoice_distribution_id = v_invoice_distribution_id
4001: WHERE jat.invoice_id = inv_id
4002: AND jat.po_header_id = cur_items_rec.po_header_id
4003: AND jat.po_line_id = cur_items_rec.po_line_id
4789: END IF; --( NVL(lv_ap_line_to_inst_flag,'N')='Y')
4790: ------------------------------------------------------
4791: --added by Eric for inclusive tax on 20-dec-2007,end
4792:
4793: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
4794: INSERT INTO JAI_AP_MATCH_INV_TAXES
4795: (
4796: tax_distribution_id,
4797: exchange_rate_variance,
4790: ------------------------------------------------------
4791: --added by Eric for inclusive tax on 20-dec-2007,end
4792:
4793: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
4794: INSERT INTO JAI_AP_MATCH_INV_TAXES
4795: (
4796: tax_distribution_id,
4797: exchange_rate_variance,
4798: assets_tracking_flag,
4835: ,line_no -- Bug 5553150, 5593895
4836: )
4837: VALUES
4838: (
4839: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
4840: null,--kunkumar for forward porting to R12
4841: v_assets_tracking_flag, -- 'N', bug # 2851123
4842: inv_id,
4843: cur_items_rec.po_header_id,
5679: ----------------------------------------------------------------
5680: --added by Eric for inclusive tax on 20-dec-2007,end
5681:
5682:
5683: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
5684:
5685: --added by Eric for inclusive tax on 20-dec-2007,begin
5686: -----------------------------------------------------------------
5687: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
5688: THEN
5689: -----------------------------------------------------------------
5690: --added by Eric for inclusive tax on 20-dec-2007,end
5691:
5692: INSERT INTO JAI_AP_MATCH_INV_TAXES
5693: (
5694: tax_distribution_id,
5695: exchange_rate_variance,
5696: assets_tracking_flag,
5735: ,line_no -- Bug 5553150, 5593895
5736: )
5737: VALUES
5738: (
5739: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
5740: null,--kunkumar for forward porting to R12
5741: v_assets_tracking_flag, -- 'N', bug # 2851123
5742: inv_id,
5743: cur_items_rec.po_header_id,
6698: IF NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'Y' AND NVL(lv_modvat_flag,'N') = 'Y' THEN
6699: ln_inv_line_num := ln_inv_line_num + 1;
6700: END IF;
6701: --Added by Qinglei on 10-Feb-2012 for bug#13589613 end
6702: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
6703: INSERT INTO JAI_AP_MATCH_INV_TAXES
6704: (
6705: tax_distribution_id,
6706: --shipment_line_id,
6699: ln_inv_line_num := ln_inv_line_num + 1;
6700: END IF;
6701: --Added by Qinglei on 10-Feb-2012 for bug#13589613 end
6702: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
6703: INSERT INTO JAI_AP_MATCH_INV_TAXES
6704: (
6705: tax_distribution_id,
6706: --shipment_line_id,
6707: exchange_rate_variance,
6748: )
6749:
6750: VALUES
6751: (
6752: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
6753: null,--kunkumar for forward porting to R12
6754: v_assets_tracking_flag, -- 'N', bug # 2851123
6755: inv_id,
6756: cur_items_rec.po_header_id, /* All references to r_cur_items_rec have been replaced by cur_items_rec */
7126: );
7127:
7128: --Added by Qiong for bug13579239 begin
7129: --------------------------------
7130: UPDATE JAI_AP_MATCH_INV_TAXES jat
7131: SET jat.invoice_distribution_id = v_invoice_distribution_id
7132: WHERE jat.invoice_id = inv_id
7133: AND jat.po_header_id = cur_items_rec.po_header_id
7134: AND jat.po_line_id = cur_items_rec.po_line_id
7553:
7554: ln_lines_to_insert number;
7555: ln_nrec_tax_amt number;
7556: ln_rec_tax_amt number;
7557: lv_modvat_flag jai_ap_match_inv_taxes.recoverable_flag%type;
7558:
7559: lv_excise_costing_flag varchar2 (1);
7560: lv_tax_type varchar2(5); --added by eric for inclusive tax
7561: lv_tax_line_amount NUMBER := 0; --added by eric for inclusive tax
7866: from_line_location_taxes to conside such tax lines for propagation into AP.
7867:
7868: 11. 15/03/2003 Aparajita for bug # 2851123. Version # 615.9
7869: The assets_tracking_flag in ap_invoice_distributions_all,
7870: JAI_AP_MATCH_INV_TAXES and JAI_CMN_FA_INV_DIST_ALL should be set as 'N'
7871: if the tax line against which the line is being generated is excise type of
7872: tax and is modvatable. By default this flag gets the value from the
7873: corresponding item line for which the tax is attached.
7874:
8100: instead these will be populated in the global attribute columns. So the code changes are
8101: made accordingly.
8102:
8103: 43. 10-Jun-2005 rallamse for bug# Version 116.2
8104: All inserts into JAI_AP_MATCH_INV_TAXES table now include legal_entity_id as
8105: part of R12 LE Initiative. The legal_entity_id is selected from ap_invoices_all in
8106: cursor get_ven_info.
8107:
8108: 44 23-Jun-2005 Brathod for Bug# 4445989, Version 120.0
8114: invoice_id and invoice_line_number as unique combination
8115: - invoice line record is created in ap_invoice_lines_all where ever previously
8116: distribution was created
8117: - Obsoleted JAI_CMN_FA_INV_DIST_ALL
8118: - Modified structure of JAI_AP_MATCH_INV_TAXES to incorporate invoice lines
8119: and also the fields from JAI_CMN_FA_INV_DIST_ALL
8120: - Code modfied to insert appropriate fields in JAI_AP_MATCH_INV_TAXES
8121:
8122: 45. 06-Jul-2005 Sanjikum for Bug#4474501
8116: distribution was created
8117: - Obsoleted JAI_CMN_FA_INV_DIST_ALL
8118: - Modified structure of JAI_AP_MATCH_INV_TAXES to incorporate invoice lines
8119: and also the fields from JAI_CMN_FA_INV_DIST_ALL
8120: - Code modfied to insert appropriate fields in JAI_AP_MATCH_INV_TAXES
8121:
8122: 45. 06-Jul-2005 Sanjikum for Bug#4474501
8123: 1) Commented the cursor - for_acct_id and corresponding open/fetch/close for the same.
8124: 2) Commented the call to function - jai_general_pkg.get_accounting_method
8149:
8150: ------------------------------------------------------------------------------------------------------
8151: Version Bug Dependencies (including other objects like files if any)
8152: -------------------------------------------------------------------------------------------------------
8153: 616.1 3038566 ALTER Script JAI_AP_MATCH_INV_TAXES Table is altered.
8154:
8155: 115.1 3752887 Dependency on function jai_ap_interface_pkg.get_apportion_factor which is also added
8156: in this patch. So no pre - req.
8157:
9025: THEN
9026: -----------------------------------------------------------------
9027: --added by Eric for inclusive tax on 20-dec-2007,end
9028:
9029: INSERT INTO JAI_AP_MATCH_INV_TAXES
9030: (
9031: tax_distribution_id,
9032: exchange_rate_variance,
9033: assets_tracking_flag,
9069:
9070: )
9071: VALUES
9072: (
9073: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
9074: null,--kunkumar for forward porting to R12
9075: v_assets_tracking_flag , -- 'N', bug#2851123
9076: inv_id,
9077: cur_items_rec.po_header_id,
9890: THEN
9891: -----------------------------------------------------------------
9892: --added by Eric for inclusive tax on 20-dec-2007,end
9893:
9894: INSERT INTO JAI_AP_MATCH_INV_TAXES
9895: (
9896: tax_distribution_id,
9897: exchange_rate_variance,
9898: assets_tracking_flag,
9935: /* End 5763527 */
9936: )
9937: VALUES
9938: (
9939: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
9940: null,--kunkumar for forward porting to R12
9941: v_assets_tracking_flag , -- 'N', bug#2851123
9942: inv_id,
9943: cur_items_rec.po_header_id,
10745: --added by Eric for inclusive tax on 20-dec-2007,end
10746:
10747:
10748: Fnd_File.put_line(Fnd_File.LOG,
10749: 'Before inserting into JAI_AP_MATCH_INV_TAXES tax id ' || i.tax_id );
10750: --added by Eric for inclusive tax on 20-dec-2007,begin
10751: -----------------------------------------------------------------
10752: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
10753: THEN
10752: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
10753: THEN
10754: -----------------------------------------------------------------
10755: --added by Eric for inclusive tax on 20-dec-2007,end
10756: INSERT INTO JAI_AP_MATCH_INV_TAXES
10757: (
10758: tax_distribution_id,
10759: exchange_rate_variance,
10760: assets_tracking_flag,
10793: ,line_no -- added, Harshita for Bug 5553150
10794: )
10795: VALUES
10796: (
10797: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
10798: null,--kunkumar for forward porting to R12
10799: v_assets_tracking_flag , -- 'N', bug#2851123
10800: inv_id,
10801: cur_items_rec.po_header_id,