[Home] [Help]
PACKAGE: APPS.JAI_PO_HOOK_PKG
Source
1 PACKAGE JAI_PO_HOOK_PKG AUTHID CURRENT_USER AS
2 /* $Header: jai_po_hook_pkg.pls 120.5.12010000.2 2009/04/03 09:14:33 srjayara ship $ */
3
4 -- Declare global variable for package name
5 GV_MODULE_PREFIX VARCHAR2(50) :='jai.plsql.JAI_PO_HOOK_PKG';
6
7 PROCEDURE calc_taxes
8 (
9 p_document_type IN VARCHAR2,
10 p_header_id IN NUMBER,
11 p_line_id IN NUMBER,
12 Errbuf OUT NOCOPY VARCHAR2,
13 RetCode OUT NOCOPY VARCHAR2
14 );
15
16 PROCEDURE PROCESS_RECEIPT
17 (
18 p_shipment_header_id IN NUMBER,
19 p_transaction_id IN NUMBER DEFAULT NULL,
20 p_process_Action IN VARCHAR2 DEFAULT NULL,
21 errbuf OUT NOCOPY VARCHAR2,
22 retcode OUT NOCOPY VARCHAR2
23 );
24
25 PROCEDURE UPDATE_RCV_TXN
26 (
27 P_transaction_id IN NUMBER,
28 p_invoice_num IN VARCHAR2,
29 P_invoice_date IN VARCHAR2,
30 errbuf OUT NOCOPY VARCHAR2,
31 retcode OUT NOCOPY VARCHAR2
32 );
33
34 FUNCTION gettax
35 (
36 p_document_type IN VARCHAR2,
37 p_header_id IN NUMBER,
38 p_line_id IN NUMBER
39 ) RETURN NUMBER;
40
41 FUNCTION get_taxes_inr
42 (
43 p_document_id IN VARCHAR2,
44 p_header_id IN NUMBER,
45 p_line_id IN NUMBER
46 ) RETURN NUMBER;
47
48 FUNCTION gettax
49 (
50 p_document_type IN VARCHAR2,
51 p_header_id IN NUMBER,
52 p_line_id IN NUMBER,
53 p_shipment_line_num IN NUMBER
54 ) RETURN NUMBER;
55
56 FUNCTION get_profile_value(cp_profile_name VARCHAR2) RETURN VARCHAR2;
57
58 PROCEDURE populate_cmn_taxes
59 (
60 p_po_header_id IN NUMBER,
61 p_line_location_id IN NUMBER,
62 p_hdr_intf_id IN NUMBER,
63 p_cmn_line_id IN NUMBER,
64 p_quantity IN NUMBER,
65 p_tot_quantity IN NUMBER
66 );
67
68 PROCEDURE Populate_cmn_lines
69 (
70 p_hdr_intf_id IN NUMBER,
71 p_invoice_num IN VARCHAR2,
72 p_invoice_date IN DATE,
73 errbuf OUT NOCOPY VARCHAR2,
74 retcode OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE update_cmn_lines
78 (
79 p_shipment_num IN VARCHAR2,
80 p_ex_inv_num IN VARCHAR2,
81 p_ex_inv_date IN DATE,
82 p_header_interface_id IN NUMBER DEFAULT NULL, /*bug 8400813*/
83 errbuf OUT NOCOPY VARCHAR2,
84 retcode OUT NOCOPY VARCHAR2
85 );
86
87 PROCEDURE UPDATE_ASBN_MODE
88 (
89 p_shipment_num IN VARCHAR2,
90 p_mode IN VARCHAR2,
91 p_header_interface_id IN NUMBER DEFAULT NULL, /*bug 8400813*/
92 errbuf OUT NOCOPY VARCHAR2,
93 retcode OUT NOCOPY VARCHAR2
94 );
95
96 PROCEDURE Populate_cmn_lines_on_upload
97 (
98 p_hdr_intf_id IN NUMBER,
99 errbuf OUT NOCOPY VARCHAR2,
100 retcode OUT NOCOPY VARCHAR2
101 );
102
103 FUNCTION gettaxisp
104 (
105 p_document_type IN VARCHAR2,
106 p_header_id IN NUMBER,
107 p_line_id IN NUMBER,
108 p_release_id IN NUMBER
109 ) RETURN NUMBER;
110
111 --==========================================================================
112 -- PROCEDURE NAME:
113 --
114 -- Get_InAndEx_Tax_Total Public
115 --
116 -- DESCRIPTION:
117 --
118 -- to calculate the inclusive and exclusive tax amount
119 --
120 -- PARAMETERS:
121 -- In: pv_document_type document type
122 -- pn_header_id header id
123 -- pn_line_id line id
124 -- pv_inclusive_tax_flag inclusive tax flag
125 --
126 -- DESIGN REFERENCES:
127 -- Inclusive Tax Technical Design.doc
128 --
129 -- CHANGE HISTORY:
130 --
131 -- 20-NOV-2007 Jason Liu created
132 FUNCTION Get_InAndEx_Tax_Total
133 ( pv_document_type IN VARCHAR2
134 , pn_header_id IN NUMBER
135 , pn_line_id IN NUMBER
136 , pv_inclusive_tax_flag IN VARCHAR2
137 )
138 RETURN NUMBER;
139
140 --==========================================================================
141 -- PROCEDURE NAME:
142 --
143 -- Get_Isp_InAndEx_Tax_Total Public
144 --
145 -- DESCRIPTION:
146 --
147 -- to calculate the inclusive and exclusive tax amount
148 --
149 -- PARAMETERS:
150 -- In: pv_document_type document type
151 -- pn_header_id header id
152 -- pn_line_id line id
153 -- pn_release_id release id
154 -- pv_inclusive_tax_flag inclusive tax flag
155 --
156 -- DESIGN REFERENCES:
157 -- Inclusive Tax Technical Design.doc
158 --
159 -- CHANGE HISTORY:
160 --
161 -- 20-NOV-2007 Jason Liu created
162 FUNCTION Get_Isp_InAndEx_Tax_Total
163 ( pv_document_type IN VARCHAR2
164 , pn_header_id IN NUMBER
165 , pn_line_id IN NUMBER
166 , pn_release_id IN NUMBER
167 , pv_inclusive_tax_flag IN VARCHAR2
168 )
169 RETURN NUMBER;
170
171 END JAI_PO_HOOK_PKG;