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_MATCH_TAX_PROC_PKG dependencies on JAI_AP_MATCH_TAX_PROC_PKG

Line 1: PACKAGE BODY jai_ap_match_tax_proc_pkg AS

1: PACKAGE BODY jai_ap_match_tax_proc_pkg AS
2: --$Header: jai_ap_match_tax_proc.plb 120.0.12020000.3 2013/03/21 09:26:31 wenzhou noship $
3: --|+======================================================================+
4: --| Copyright (c) 2007 Oracle Corporation Redwood Shores, California, USA |
5: --| All rights reserved. |

Line 24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'jai_ap_match_tax_proc_pkg';

20: --+======================================================================*/
21:
22: --==========================================================================
23:
24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'jai_ap_match_tax_proc_pkg';
25: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
26: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
27: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
28: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 32: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'JAI.PLSQL.jai_ap_match_tax_proc_pkg.';

28: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
29: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
30: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
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:

Line 1023: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_tax);

1019: lr_ap_inv_line_tax.product_table := G_MATCH_PRODUCT_TABLE;
1020: lr_ap_inv_line_tax.reference_key1 := p_tax_line_rec.tax_id;
1021: lr_ap_inv_line_tax.reference_key2 := pr_ap_inv_line_item.line_number;
1022: END IF;
1023: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_tax);
1024:
1025:
1026: END IF;
1027:

Line 1123: v_invoice_distribution_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lr_ap_inv_dist_tax);

1119: lr_ap_inv_dist_tax.expenditure_organization_id := ln_exp_organization_id;
1120: lr_ap_inv_dist_tax.project_accounting_context := lv_project_accounting_context;
1121: lr_ap_inv_dist_tax.pa_addition_flag := lv_pa_addition_flag;
1122:
1123: v_invoice_distribution_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lr_ap_inv_dist_tax);
1124:
1125:
1126:
1127: IF p_tax_line_rec.reverse_charge_flag = 'Y' THEN

Line 1186: jai_ap_match_tax_proc_pkg.insert_jai_ap_match(lr_jai_ap_match_taxes);

1182: lr_jai_ap_match_taxes.RCV_TRANSACTION_ID := pr_ap_inv_line_item.RCV_TRANSACTION_ID;
1183: lr_jai_ap_match_taxes.LINE_TYPE_LOOKUP_CODE := lv_misc;
1184: lr_jai_ap_match_taxes.recoverable_flag := lv_modvat_flag;
1185: lr_jai_ap_match_taxes.line_no := p_tax_line_rec.tax_line_no ;
1186: jai_ap_match_tax_proc_pkg.insert_jai_ap_match(lr_jai_ap_match_taxes);
1187:
1188: END IF;--(NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
1189:
1190: v_distribution_no := v_distribution_no +1;

Line 1231: v_invoice_distribution_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lr_ap_inv_dist_tax);

1227: lr_ap_inv_dist_tax.expenditure_organization_id := ln_exp_organization_id;
1228: lr_ap_inv_dist_tax.project_accounting_context := lv_project_accounting_context;
1229: lr_ap_inv_dist_tax.pa_addition_flag := lv_pa_addition_flag;
1230:
1231: v_invoice_distribution_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lr_ap_inv_dist_tax);
1232:
1233:
1234:
1235: IF p_tax_line_rec.reverse_charge_flag = 'Y' THEN

Line 1292: jai_ap_match_tax_proc_pkg.insert_jai_ap_match(lr_jai_ap_match_taxes);

1288: lr_jai_ap_match_taxes.LINE_TYPE_LOOKUP_CODE := lv_misc;
1289: lr_jai_ap_match_taxes.recoverable_flag := lv_modvat_flag;
1290: lr_jai_ap_match_taxes.line_no := p_tax_line_rec.tax_line_no ;
1291:
1292: jai_ap_match_tax_proc_pkg.insert_jai_ap_match(lr_jai_ap_match_taxes);
1293: END IF;--(NVL(lv_tax_line_to_inst_flag,'N') = 'Y')
1294:
1295: END IF;
1296:

Line 1392: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_incl_tax);

1388: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Before inserting
1389: Inclusive Service tax lines for POT into ap_line ');
1390: END IF;
1391:
1392: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_incl_tax);
1393:
1394: lr_ap_inv_dist_incl_tax := pr_ap_inv_dist_tax;
1395: lr_ap_inv_dist_incl_tax.assets_tracking_flag := nvl(v_assets_tracking_flag,pr_ap_inv_dist_tax.assets_tracking_flag);
1396: lr_ap_inv_dist_incl_tax.invoice_id := ln_invoice_id;

Line 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);

1415: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Before inserting
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

Line 1444: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_liability);

1440: IF p_tax_line_rec.reverse_charge_flag = 'Y' THEN
1441: ln_inv_line_num := ln_inv_line_num + 1;
1442: lr_ap_inv_line_liability.amount := -abs(lr_ap_inv_line_liability.amount);
1443: lr_ap_inv_line_liability.LINE_NUMBER := ln_inv_line_num;
1444: jai_ap_match_tax_proc_pkg.insert_ap_inv_line( p_ap_invoice_lines_all_rec => lr_ap_inv_line_liability);
1445:
1446: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1447: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'insert_ap_inv_line liability line for reverse charge with amt:'||lr_ap_inv_line_liability.amount);
1448: END IF;

Line 1450: v_liability_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lr_ap_inv_dist_liability);

1446: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1447: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'insert_ap_inv_line liability line for reverse charge with amt:'||lr_ap_inv_line_liability.amount);
1448: END IF;
1449: lr_ap_inv_dist_liability.INVOICE_LINE_NUMBER := ln_inv_line_num;
1450: v_liability_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lr_ap_inv_dist_liability);
1451: END IF;
1452:
1453:
1454: if (pv_source = 'ISP') then

Line 3760: ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);

3756: lc_inv_dist.program_id := -1;
3757: lc_inv_dist.program_update_date := sysdate;
3758: lc_inv_dist.quantity_invoiced := null;
3759:
3760: ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);
3761: End Loop;
3762:
3763: --Update ap_invoice_lines_all
3764: jai_ap_match_tax_proc_pkg.update_ap_inv_line(ident_rec.invoice_id,

Line 3764: jai_ap_match_tax_proc_pkg.update_ap_inv_line(ident_rec.invoice_id,

3760: ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);
3761: End Loop;
3762:
3763: --Update ap_invoice_lines_all
3764: jai_ap_match_tax_proc_pkg.update_ap_inv_line(ident_rec.invoice_id,
3765: ident_rec.invoice_line_number);
3766: Commit;
3767: End Loop;
3768: Elsif lv_discard_flag = 'Y' and lv_source = 'ERS' Then

Line 3827: ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);

3823: lc_inv_dist.program_id := -1;
3824: lc_inv_dist.program_update_date := sysdate;
3825: lc_inv_dist.quantity_invoiced := null;
3826:
3827: ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);
3828: --Update ap_invoice_lines_all
3829: jai_ap_match_tax_proc_pkg.update_ap_inv_line(ins_reverse_dist_lines_ers.invoice_id,
3830: ins_reverse_dist_lines_ers.invoice_line_number);
3831: Commit;

Line 3829: jai_ap_match_tax_proc_pkg.update_ap_inv_line(ins_reverse_dist_lines_ers.invoice_id,

3825: lc_inv_dist.quantity_invoiced := null;
3826:
3827: ln_inv_dist_id := jai_ap_match_tax_proc_pkg.insert_ap_inv_dist(lc_inv_dist);
3828: --Update ap_invoice_lines_all
3829: jai_ap_match_tax_proc_pkg.update_ap_inv_line(ins_reverse_dist_lines_ers.invoice_id,
3830: ins_reverse_dist_lines_ers.invoice_line_number);
3831: Commit;
3832: End Loop;
3833: END IF;

Line 3871: 'jai_ap_match_tax_proc_pkg.tax_check_at_inv_validate',

3867: ln_inv_tax_count number;
3868: begin
3869: p_codepath := jai_general_pkg.plot_codepath(1,
3870: p_codepath,
3871: 'jai_ap_match_tax_proc_pkg.tax_check_at_inv_validate',
3872: 'START');
3873: open c_po_tax_num(p_invoice_id);
3874: fetch c_po_tax_num
3875: into ln_po_tax_count;

Line 3896: P_process_message := 'jai_ap_match_tax_proc_pkg.tax_check_at_inv_validate :' ||

3892: end if;
3893: exception
3894: when others then
3895: p_process_flag := 'E';
3896: P_process_message := 'jai_ap_match_tax_proc_pkg.tax_check_at_inv_validate :' ||
3897: sqlerrm;
3898:
3899: end tax_check_at_inv_validate;
3900:

Line 3908: jai_ap_match_tax_proc_pkg.get_match_type(pn_invoice_id,

3904: lv_receipt_code VARCHAR2(20);
3905: ln_shipment_line_id NUMBER;
3906: ln_shipment_header_id NUMBER;
3907: begin
3908: jai_ap_match_tax_proc_pkg.get_match_type(pn_invoice_id,
3909: pn_invoice_line_num,
3910: lv_match_type,
3911: lv_receipt_code,
3912: ln_shipment_line_id,

Line 3975: END jai_ap_match_tax_proc_pkg;

3971: end loop;
3972: return lv_enable_menu;
3973: end enable_match_details_menu;
3974:
3975: END jai_ap_match_tax_proc_pkg;