[Home] [Help]
31: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'JAI.PLSQL.jai_ap_match_tax_proc_pkg.';
33: G_JAI_APPLICATION_ID CONSTANT NUMBER := 7000;
34: G_PRODUCT_TABLE CONSTANT VARCHAR2(30) := 'JAI_CMN_DOCUMENT_TAXES';
35: G_MATCH_PRODUCT_TABLE CONSTANT VARCHAR2(30) := 'JAI_AP_MATCH_INV_TAXES';
36:
37:
38: /*----------------------------------------------------------------------------*
39: | PRIVATE FUNCTIONS/PROCEDURES |
507: lr_ap_inv_dist_liability ap_invoice_distributions_all%ROWTYPE;
508: lr_ap_inv_line_tax ap_invoice_lines%ROWTYPE;
509: lr_ap_inv_line_incl_tax ap_invoice_lines%ROWTYPE;
510: lr_ap_inv_line_liability ap_invoice_lines%ROWTYPE;
511: lr_jai_ap_match_taxes JAI_AP_MATCH_INV_TAXES%ROWTYPE;
512: ln_project_id ap_invoice_lines.project_id%TYPE;
513: ln_task_id ap_invoice_lines.task_id%TYPE;
514: lv_exp_type ap_invoice_lines.expenditure_type%TYPE;
515: ld_exp_item_date ap_invoice_lines.expenditure_item_date%TYPE;
1336: IF inclu_Serv_line =2 THEN
1337: ln_inv_line_num := ln_inv_line_num + 1;
1338: END IF;
1339: --For inclusive tax recoverable part, the positive invoice line should use invoice_line_number
1340: --when insert jai_ap_match_inv_taxes used; for the negative line, will use ln_inv_line_num + 1 as
1341: --line number.
1342:
1343:
1344: Fnd_File.put_line(Fnd_File.LOG,'Before inserting Inclusive Service tax lines for POT into ap_invoice_lines_all for line no :'
1417: Inclusive Service tax lines for POT into ap_dist ');
1418: END IF;
1419: v_invoice_distribution_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist( p_ap_invoice_dist_all_rec => lr_ap_inv_dist_incl_tax);
1420:
1421: UPDATE JAI_AP_MATCH_INV_TAXES jat
1422: SET jat.invoice_distribution_id = v_invoice_distribution_id
1423: , jat.INVOICE_LINE_NUMBER = ln_inv_line_num
1424: WHERE jat.invoice_id = ln_invoice_id
1425: AND jat.po_header_id = pr_ap_inv_line_item.po_header_id
1985:
1986: END prepare_copy_tax;
1987:
1988: PROCEDURE insert_jai_ap_match(
1989: p_jai_ap_match_taxes_rec IN JAI_AP_MATCH_INV_TAXES%ROWTYPE
1990: )IS
1991: l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_ap_match()';
1992: BEGIN
1993: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1995: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'invoice line num: '||p_jai_ap_match_taxes_rec.INVOICE_LINE_NUMBER);
1996:
1997: END IF;
1998:
1999: INSERT INTO JAI_AP_MATCH_INV_TAXES
2000: (
2001: tax_distribution_id,
2002: assets_tracking_flag,
2003: invoice_id,
2034: , line_no
2035: )
2036: VALUES
2037: (
2038: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
2039: p_jai_ap_match_taxes_rec.assets_tracking_flag,
2040: p_jai_ap_match_taxes_rec.invoice_id,
2041: p_jai_ap_match_taxes_rec.po_header_id,
2042: p_jai_ap_match_taxes_rec.po_line_id,
3069: WHERE transaction_id = v_rcv_trans_id;
3070:
3071: CURSOR fetch_tax_distribution(v_po_header_id NUMBER, v_po_line_id NUMBER, v_invoice_id NUMBER) IS
3072: SELECT COUNT(*)
3073: FROM JAI_AP_MATCH_INV_TAXES
3074: WHERE po_header_id = v_po_header_id
3075: AND po_line_id = v_po_line_id
3076: AND invoice_id = v_invoice_id;
3077:
3343: -- get the corresponding tax lin amount in the original invoice
3344: CURSOR c_get_orig_tax_line(p_orig_invoice_id NUMBER, p_orig_invoice_dist_id NUMBER, p_tax_id NUMBER) IS
3345:
3346: SELECT SUM(jam.tax_amount) tax_amount
3347: FROM jai_ap_match_inv_taxes jam, jai_cmn_taxes_all jct
3348: WHERE p_orig_invoice_id = p_orig_invoice_id AND
3349: parent_invoice_distribution_id = p_orig_invoice_dist_id AND
3350: jam.tax_id = p_tax_id
3351: AND jam.tax_id = jct.tax_id AND
3560: po_distribution_id,
3561: invoice_distribution_id,
3562: rcv_transaction_id,
3563: invoice_line_number
3564: from jai_ap_match_inv_taxes
3565: where line_type_lookup_code = 'MISCELLANEOUS'
3566: and invoice_id = p_invoice_id
3567: and parent_invoice_line_number = p_invoice_line_number
3568: and invoice_line_number <> p_invoice_line_number
3859: and la.rcv_transaction_id = lt.transaction_id);
3860:
3861: cursor c_inv_tax_num(cp_invoice_id number) is
3862: select count(1)
3863: from JAI_AP_MATCH_INV_TAXES
3864: where invoice_id = cp_invoice_id
3865: and PARENT_INVOICE_LINE_NUMBER = p_invoice_line_number;
3866: ln_po_tax_count number;
3867: ln_inv_tax_count number;