[Home] [Help]
PACKAGE: APPS.JAI_PO_HOOK_PKG
Source
1 PACKAGE JAI_PO_HOOK_PKG AS
2 /* $Header: jai_po_hook_pkg.pls 120.5 2008/01/21 11:27:29 ssumaith noship $ */
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 errbuf OUT NOCOPY VARCHAR2,
83 retcode OUT NOCOPY VARCHAR2
84 );
85
86 PROCEDURE UPDATE_ASBN_MODE
87 (
88 p_shipment_num IN VARCHAR2,
89 p_mode IN VARCHAR2,
90 errbuf OUT NOCOPY VARCHAR2,
91 retcode OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE Populate_cmn_lines_on_upload
95 (
96 p_hdr_intf_id IN NUMBER,
97 errbuf OUT NOCOPY VARCHAR2,
98 retcode OUT NOCOPY VARCHAR2
99 );
100
101 FUNCTION gettaxisp
102 (
103 p_document_type IN VARCHAR2,
104 p_header_id IN NUMBER,
105 p_line_id IN NUMBER,
106 p_release_id IN NUMBER
107 ) RETURN NUMBER;
108
109 --==========================================================================
110 -- PROCEDURE NAME:
111 --
112 -- Get_InAndEx_Tax_Total Public
113 --
114 -- DESCRIPTION:
115 --
116 -- to calculate the inclusive and exclusive tax amount
117 --
118 -- PARAMETERS:
119 -- In: pv_document_type document type
120 -- pn_header_id header id
121 -- pn_line_id line id
122 -- pv_inclusive_tax_flag inclusive tax flag
123 --
124 -- DESIGN REFERENCES:
125 -- Inclusive Tax Technical Design.doc
126 --
127 -- CHANGE HISTORY:
128 --
129 -- 20-NOV-2007 Jason Liu created
130 FUNCTION Get_InAndEx_Tax_Total
131 ( pv_document_type IN VARCHAR2
132 , pn_header_id IN NUMBER
133 , pn_line_id IN NUMBER
134 , pv_inclusive_tax_flag IN VARCHAR2
135 )
136 RETURN NUMBER;
137
138 --==========================================================================
139 -- PROCEDURE NAME:
140 --
141 -- Get_Isp_InAndEx_Tax_Total Public
142 --
143 -- DESCRIPTION:
144 --
145 -- to calculate the inclusive and exclusive tax amount
146 --
147 -- PARAMETERS:
148 -- In: pv_document_type document type
149 -- pn_header_id header id
150 -- pn_line_id line id
151 -- pn_release_id release id
152 -- pv_inclusive_tax_flag inclusive tax flag
153 --
154 -- DESIGN REFERENCES:
155 -- Inclusive Tax Technical Design.doc
156 --
157 -- CHANGE HISTORY:
158 --
159 -- 20-NOV-2007 Jason Liu created
160 FUNCTION Get_Isp_InAndEx_Tax_Total
161 ( pv_document_type IN VARCHAR2
162 , pn_header_id IN NUMBER
163 , pn_line_id IN NUMBER
164 , pn_release_id IN NUMBER
165 , pv_inclusive_tax_flag IN VARCHAR2
166 )
167 RETURN NUMBER;
168
169 END JAI_PO_HOOK_PKG;