1 PACKAGE jai_ap_match_tax_proc_pkg AUTHID CURRENT_USER AS
2 --$Header: jai_ap_match_tax_proc.pls 120.0.12020000.2 2013/03/19 01:04:25 vkaranam noship $
3 TYPE l_tax_line_rec_type IS RECORD(
4 tax_id NUMBER
5 ,tax_line_no NUMBER
6 ,tax_type VARCHAR2(30)
7 ,tax_amount NUMBER
8 ,tax_name JAI_CMN_TAXES_ALL.tax_name%TYPE
9 ,rounding_factor NUMBER
10 ,modvat_flag VARCHAR2(1)
11 ,inc_tax_flag VARCHAR2(1)
12 ,reverse_charge_flag VARCHAR2(1)
13 ,mod_cr_percentage NUMBER);
14
15 TYPE l_tax_line_tbl_type IS TABLE OF l_tax_line_rec_type INDEX BY BINARY_INTEGER;
16 TYPE l_tax_dist_tbl_type IS TABLE OF ap_invoice_distributions_all%ROWTYPE INDEX BY BINARY_INTEGER;
17 procedure copy_tax_from_po_rcv
18 (
19 Pn_invoice_id NUMBER
20 ,pn_invoice_line_num NUMBER
21 ,p_tax_line_tbl l_tax_line_tbl_type
22 ,pv_rematch VARCHAR2
23 ,pn_shipment_hdr_id NUMBER
24 ,pn_shipment_line_id NUMBER
25 );
26 PROCEDURE populate_tax_to_ap
27 (
28 pr_ap_inv_line_item IN ap_invoice_lines%ROWTYPE
29 ,pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE
30 ,pr_ap_inv_dist_tax IN ap_invoice_distributions_all%ROWTYPE
31 ,p_tax_line_rec IN l_tax_line_rec_type
32 ,pv_rematch IN VARCHAR2
33 ,pv_source IN VARCHAR2
34 ,pn_lines_to_insert IN NUMBER
35 ,pv_is_item_an_expense IN VARCHAR2
36 ,pv_accrue_on_receipt_flag VARCHAR2
37 ,pv_tax_type IN VARCHAR2
38 ,pn_rec_tax_amt IN NUMBER
39 ,pn_nrec_tax_amt NUMBER
40 ,pn_inclurec_tax_amt NUMBER
41 ,pn_rvs_charge_liability_acct NUMBER DEFAULT NULL
42 ,pn_incls_acct_id IN NUMBER
43 ,pn_currency_precision IN NUMBER
44 ) ;
45
46 PROCEDURE prepare_copy_tax(pr_ap_inv_line_item IN ap_invoice_lines%ROWTYPE
47 ,pr_ap_inv_dist_item IN ap_invoice_distributions_all%ROWTYPE
48 ,pr_tax_line_rec IN OUT NOCOPY l_tax_line_rec_type
49 ,pv_rematch IN VARCHAR2
50 ,pn_shipment_hdr_id IN NUMBER
51 ,pn_shipment_line_id IN NUMBER
52 ,pn_lines_to_insert OUT NOCOPY NUMBER
53 ,pv_accrue_on_receipt_flag OUT NOCOPY VARCHAR2
54 ,pv_is_item_an_expense OUT NOCOPY VARCHAR2
55 ,pv_tax_type OUT NOCOPY VARCHAR2
56 ,pn_rec_tax_amt OUT NOCOPY NUMBER
57 ,pn_nrec_tax_amt OUT NOCOPY NUMBER
58 ,pn_inclurec_tax_amt OUT NOCOPY NUMBER
59 ,pn_currency_precision OUT NOCOPY NUMBER
60 ,pn_rvs_charge_liability_acct OUT NOCOPY NUMBER
61 ,pn_incls_acct_id OUT NOCOPY NUMBER
62 ,pr_ap_inv_dist_tax OUT NOCOPY ap_invoice_distributions_all%ROWTYPE
63 );
64 FUNCTION tax_apportion_convert
65 (
66 pn_invoice_id NUMBER
67 ,pn_invoice_line_num NUMBER
68 ,pv_adhoc_flag VARCHAR2
69 ,pv_vat_flag VARCHAR2
70 ,pv_tax_type VARCHAR2
71 ,pn_tax_id NUMBER
72 ,pn_tax_amount NUMBER
73 ) RETURN NUMBER;
74 PROCEDURE insert_jai_ap_match(p_jai_ap_match_taxes_rec IN jai_ap_match_inv_taxes%ROWTYPE);
75 FUNCTION insert_ap_inv_dist(
76 p_ap_invoice_dist_all_rec IN ap_invoice_distributions_all%ROWTYPE
77 )RETURN NUMBER ;
78
79 PROCEDURE insert_ap_inv_line(p_ap_invoice_lines_all_rec IN ap_invoice_lines_all%ROWTYPE);
80 PROCEDURE get_match_type
81 (
82 pn_invoice_id IN NUMBER
83 ,pn_invoice_line_num IN NUMBER
84 ,pv_match_type OUT NOCOPY VARCHAR2
85 ,pv_receipt_code OUT NOCOPY VARCHAR2
86 ,pn_shipment_line_id OUT NOCOPY NUMBER
87 ,pn_shipment_header_id OUT NOCOPY NUMBER
88 );
89 PROCEDURE get_org_loc_id
90 (
91 pn_rcv_trx_id IN NUMBER
92 ,pn_po_dist_id IN NUMBER
93 ,pv_match_type IN VARCHAR2
94 ,pn_organization_id OUT NOCOPY NUMBER
95 ,pn_location_id OUT NOCOPY NUMBER
96 );
97
98 PROCEDURE process_discard(pr_ap_invoice_line_rec AP_INVOICE_LINES_ALL%rowtype);
99
100 procedure tax_check_at_inv_validate(p_invoice_id in number,
101 p_invoice_line_number in number default null,
102 p_process_flag out nocopy varchar2,
103 p_process_message out nocopy varchar2,
104 p_codepath in out nocopy varchar2);
105
106 FUNCTION enable_match_details_menu(pn_invoice_id NUMBER) RETURN VARCHAR2;
107 FUNCTION get_match_type(pn_invoice_id IN NUMBER,
108 pn_invoice_line_num IN NUMBER) RETURN VARCHAR2;
109 END jai_ap_match_tax_proc_pkg;