1 PACKAGE jai_cmn_mtax_pkg AUTHID CURRENT_USER AS
2 /* $Header: jai_cmn_mtax.pls 120.5 2011/03/17 07:09:07 zhhou ship $ */
3
4 gn_commit_interval CONSTANT NUMBER DEFAULT 50 ; --Added global variable gn_commit_interval in package spec. by rpokkula for File.Sql.35
5
6 /*START, Added the following procedures by Bgowrava for the forward porting Bug#5724855 */
7
8 procedure route_request
9 (
10 p_err_buf OUT NOCOPY VARCHAR2
11 ,p_ret_code OUT NOCOPY VARCHAR2
12 ,p_org_id IN NUMBER --1
13 ,p_document_type IN VARCHAR2 default null --2
14 ,p_from_date IN varchar2 default null --3
15 ,p_to_date IN varchar2 default null --4
16 ,p_supplier_id IN NUMBER default null --5
17 ,p_supplier_site_id IN NUMBER default null --6
18 ,p_customer_id IN NUMBER default null --7
19 ,p_customer_site_id IN NUMBER default null --8
20 ,p_old_tax_category IN NUMBER --9
21 ,p_new_tax_category IN NUMBER --10
22 ,p_document_no IN VARCHAR2 default null --11
23 ,p_release_no IN NUMBER default null --12
24 ,p_document_line_no IN NUMBER default null --13
25 ,p_shipment_no IN NUMBER default null --14
26 ,p_override_manual_taxes IN CHAR default 'N'--15
27 ,p_commit_interval IN NUMBER default 50 --16
28 ,p_process_partial IN CHAR default 'N' --17
29 ,p_debug IN CHAR default 'N' --18
30 ,p_trace IN CHAR default 'N' --19
31 ,p_dbms_output IN CHAR default 'N' -- this can be used when developer tests this from backened to get dbms output at important points
32 ,p_called_from IN VARCHAR2 default null
33 ,p_source_id IN NUMBER default null -- this can be used to pass identifier based on which routing can be done
34 );
35
36 procedure process_tax_cat_update
37 (
38 p_err_buf OUT NOCOPY VARCHAR2
39 ,p_ret_code OUT NOCOPY VARCHAR2
40 ,p_org_id IN NUMBER --1
41 ,p_document_type IN VARCHAR2 default null --2
42 ,p_from_date IN DATE --3
43 ,p_to_date IN DATE --4
44 ,p_supplier_id IN NUMBER --5
45 ,p_supplier_site_id IN NUMBER --6
46 ,p_customer_id IN NUMBER --7
47 ,p_customer_site_id IN NUMBER --8
48 ,p_old_tax_category IN NUMBER --9
49 ,p_new_tax_category IN NUMBER --10
50 ,p_document_no IN VARCHAR2 --11
51 ,p_release_no IN NUMBER --12
52 ,p_document_line_no IN NUMBER --13
53 ,p_shipment_no IN NUMBER --14
54 ,p_override_manual_taxes IN CHAR DEFAULT 'N'--15
55 ,p_commit_interval IN NUMBER DEFAULT 50 --16
56 ,p_process_partial IN CHAR DEFAULT 'N' --17
57 ,p_debug IN CHAR DEFAULT 'N' --18
58 ,p_trace IN CHAR DEFAULT 'N' --19
59 ,p_dbms_output IN CHAR DEFAULT 'N'
60 ,p_tax_cat_update_id IN jai_cmn_taxctg_updates.tax_category_update_id%type
61 );
62
63
64 /*END, by Bgowrava for the forward porting Bug#5724855*/
65
66
67
68 PROCEDURE do_tax_redefaultation
69 (
70 p_err_buf OUT NOCOPY VARCHAR2,
71 p_ret_code OUT NOCOPY VARCHAR2,
72 p_org_id IN NUMBER, --1
73 p_document_type IN VARCHAR2, --2
74 pv_from_date IN VARCHAR2, --3 rpokkula for bug# 4336482 changed from DATE to VARCHAR2
75 pv_to_date IN VARCHAR2, --4 rpokkula for bug# 4336482 changed from DATE to VARCHAR2
76 p_supplier_id IN NUMBER, --5
77 p_supplier_site_id IN NUMBER, --6
78 p_customer_id IN NUMBER, --7
79 p_customer_site_id IN NUMBER, --8
80 p_old_tax_category IN NUMBER, --9
81 p_new_tax_category IN NUMBER, --10
82 p_document_no IN VARCHAR2, --11
83 p_release_no IN NUMBER, --12
84 p_document_line_no IN NUMBER, --13
85 p_shipment_no IN NUMBER, --14
86 pv_override_manual_taxes IN VARCHAR2, -- DEFAULT 'N',--15 -- Use jai_constants.no in the call of this procedure. rpokkula for for File.Sql.35
87 pn_commit_interval IN NUMBER, -- DEFAULT 50, --16 -- Added global variable gn_commit_interval in package spec. by rpokkula for File.Sql.35
88 pv_process_partial IN VARCHAR2, -- DEFAULT 'N', --17 -- Use jai_constants.no in the call of this procedure. rpokkula for for File.Sql.35
89 pv_debug IN VARCHAR2, -- DEFAULT 'N', --18 -- Use jai_constants.no in the call of this procedure. rpokkula for for File.Sql.35
90 pv_trace IN VARCHAR2 -- DEFAULT 'N' --19 -- Use jai_constants.no in the call of this procedure. rpokkula for for File.Sql.35
91 );
92
93 PROCEDURE del_taxes_after_validate
94 (
95 p_document_type IN VARCHAR2, -- eg. PO, SO, REQUISITION
96 p_line_focus_id IN NUMBER, -- IF 'PO' this should contain JAI_PO_LINE_LOCATIONS.line_focus_id and
97 p_line_location_id IN NUMBER,
98 p_line_id IN NUMBER, -- if 'SO' then this should contain JAI_OM_OE_SO_LINES.line_id
99 p_success OUT NOCOPY NUMBER,
100 p_message OUT NOCOPY VARCHAR2
101 );
102
103 --Added by zhiwei for BOE ER 11684111 begin
104 ---------------------------------------------------
105 function chk_boe_tax
106 (
107 pv_tax_type varchar2
108
109 )return number ;
110 ---------------------------------------------------
111 --Added by zhiwei for BOE ER 11684111 end
112
113 END jai_cmn_mtax_pkg;