1 PACKAGE CSTPPACQ AUTHID CURRENT_USER AS
2 /* $Header: CSTPACQS.pls 120.1.12010000.2 2010/05/01 11:30:48 lchevala ship $ */
3
4 PROCEDURE acq_cost_processor(
5 i_period IN NUMBER,
6 i_start_date IN DATE,
7 i_end_date IN DATE,
8 i_cost_type_id IN NUMBER,
9 i_cost_group_id IN NUMBER,
10 i_user_id IN NUMBER,
11 i_login_id IN NUMBER,
12 i_req_id IN NUMBER,
13 i_prog_id IN NUMBER,
14 i_prog_appl_id IN NUMBER,
15 o_err_num OUT NOCOPY NUMBER,
16 o_err_code OUT NOCOPY VARCHAR2,
17 o_err_msg OUT NOCOPY VARCHAR2,
18 i_source_flag IN NUMBER DEFAULT 1,
19 i_receipt_no IN NUMBER DEFAULT NULL,
20 i_invoice_no IN NUMBER DEFAULT NULL,
21 i_adj_account IN NUMBER DEFAULT NULL);
22
23 FUNCTION get_nqr(
24 i_transaction_id IN NUMBER,
25 i_source_flag IN NUMBER,
26 i_start_date IN DATE,
27 i_end_date IN DATE,
28 i_res_flag IN NUMBER,
29 o_err_num OUT NOCOPY NUMBER) RETURN NUMBER;
30
31 PROCEDURE get_charge_allocs (
32 i_hdr IN NUMBER,
33 i_item_dist IN NUMBER,
34 i_start_date IN DATE,
35 i_end_date IN DATE,
36 i_res_flag IN NUMBER,
37 i_user_id IN NUMBER,
38 i_login_id IN NUMBER,
39 i_req_id IN NUMBER,
40 i_prog_id IN NUMBER,
41 i_prog_appl_id IN NUMBER,
42 o_err_num OUT NOCOPY NUMBER,
43 o_err_code OUT NOCOPY VARCHAR2,
44 o_err_msg OUT NOCOPY VARCHAR2);
45
46 Procedure get_charge_allocs_for_acqadj(
47 i_hdr IN NUMBER,
48 i_item_dist IN NUMBER,
49 l_start_date IN DATE,
50 l_end_date IN DATE,
51 i_user_id IN NUMBER,
52 i_login_id IN NUMBER,
53 i_req_id IN NUMBER,
54 i_prog_id IN NUMBER,
55 i_prog_appl_id IN NUMBER,
56 o_err_num OUT NOCOPY NUMBER,
57 o_err_code OUT NOCOPY VARCHAR2,
58 o_err_msg OUT NOCOPY VARCHAR2);
59
60
61 PROCEDURE compute_acq_cost (
62 i_header IN NUMBER,
63 i_nqr IN NUMBER,
64 i_po_line_loc IN NUMBER,
65 i_po_price IN NUMBER,
66 i_primary_uom IN VARCHAR2,
67 i_rate IN NUMBER,
68 i_po_uom IN VARCHAR2,
69 i_item IN NUMBER,
70 i_user_id IN NUMBER,
71 i_login_id IN NUMBER,
72 i_req_id IN NUMBER,
73 i_prog_id IN NUMBER,
74 i_prog_appl_id IN NUMBER,
75 o_err_num OUT NOCOPY NUMBER,
76 o_err_code OUT NOCOPY VARCHAR2,
77 o_err_msg OUT NOCOPY VARCHAR2);
78
79 Procedure compute_acq_cost_acqadj(
80 i_header IN NUMBER,
81 i_nqr IN NUMBER,
82 i_po_line_loc IN NUMBER,
83 i_po_price IN NUMBER,
84 i_primary_uom IN VARCHAR2,
85 i_rate IN NUMBER,
86 i_po_uom IN VARCHAR2,
87 i_item IN NUMBER,
88 i_pac_period_id IN NUMBER,
89 i_cost_group_id IN NUMBER,
90 i_org_id IN NUMBER,
91 i_cost_type_id IN NUMBER,
92 i_adj_account IN NUMBER,
93 i_user_id IN NUMBER,
94 i_login_id IN NUMBER,
95 i_req_id IN NUMBER,
96 i_prog_id IN NUMBER,
97 i_prog_appl_id IN NUMBER,
98 o_err_num OUT NOCOPY NUMBER,
99 o_err_code OUT NOCOPY VARCHAR2,
100 o_err_msg OUT NOCOPY VARCHAR2);
101
102
103 PROCEDURE get_acq_cost (
104 i_cost_group_id IN NUMBER,
105 i_txn_id IN NUMBER,
106 i_cost_type_id IN NUMBER,
107 i_wip_inv_flag IN VARCHAR2,
108 o_acq_cost OUT NOCOPY NUMBER,
109 o_err_num OUT NOCOPY NUMBER,
110 o_err_code OUT NOCOPY VARCHAR2,
111 o_err_msg OUT NOCOPY VARCHAR2);
112
113 FUNCTION get_rcv_tax (
114 i_rcv_txn_id IN NUMBER)
115 RETURN NUMBER ;
116
117 FUNCTION get_po_rate (
118 i_rcv_txn_id IN NUMBER)
119 RETURN NUMBER ;
120
121 /*BUG9495449*/
122 FUNCTION get_rcv_rate (
123 i_rcv_txn_id IN NUMBER)
124 RETURN NUMBER ;
125
126 FUNCTION get_net_undel_qty(
127 i_transaction_id IN NUMBER,
128 i_end_date IN DATE)
129 RETURN NUMBER;
130
131 Procedure Insert_into_acqhdr_tables(
132 i_header_id IN NUMBER,
133 i_cost_group_id IN NUMBER,
134 i_cost_type_id IN NUMBER,
135 i_period_id IN NUMBER,
136 i_rcv_transaction_id IN NUMBER,
137 i_net_quantity_received IN NUMBER,
138 i_total_quantity_invoiced IN NUMBER,
139 i_quantity_at_po_price IN NUMBER,
140 i_total_invoice_amount IN NUMBER,
141 i_amount_at_po_price IN NUMBER,
142 i_total_amount IN NUMBER,
143 i_costed_quantity IN NUMBER,
144 i_acquisition_cost IN NUMBER,
145 i_po_line_location_id IN NUMBER,
146 i_po_unit_price IN NUMBER,
147 i_primary_uom IN VARCHAR2,
148 i_rec_exchg_rate IN NUMBER,
149 i_last_update_date IN DATE,
150 i_last_updated_by IN NUMBER,
151 i_creation_date IN DATE,
152 i_created_by IN NUMBER,
153 i_request_id IN NUMBER,
154 i_program_application_id IN NUMBER,
155 i_program_id IN NUMBER,
156 i_program_update_date IN DATE,
157 i_last_update_login IN NUMBER,
158 i_source_flag IN NUMBER,
159 o_err_num OUT NOCOPY NUMBER,
160 o_err_msg OUT NOCOPY VARCHAR2 );
161
162 Procedure Insert_into_acqdtls_tables (
163 i_header_id IN NUMBER,
164 i_detail_id IN NUMBER,
165 i_source_type IN VARCHAR2,
166 i_po_line_location_id IN NUMBER,
167 i_parent_distribution_id IN NUMBER,
168 i_distribution_num IN NUMBER,
169 i_level_num IN NUMBER,
170 i_invoice_distribution_id IN NUMBER,
171 i_parent_inv_distribution_id IN NUMBER,
172 i_allocated_amount IN NUMBER,
173 i_parent_amount IN NUMBER,
174 i_amount IN NUMBER,
175 i_quantity IN NUMBER,
176 i_price IN NUMBER,
177 i_line_type IN VARCHAR2,
178 i_last_update_date IN DATE,
179 i_last_updated_by IN NUMBER,
180 i_creation_date IN DATE,
181 i_created_by IN NUMBER,
182 i_request_id IN NUMBER,
183 i_program_application_id IN NUMBER,
184 i_program_id IN NUMBER,
185 i_program_update_date IN DATE,
186 i_last_update_login IN NUMBER,
187 i_source_flag IN NUMBER,
188 o_err_num OUT NOCOPY NUMBER,
189 o_err_msg OUT NOCOPY VARCHAR2);
190
191 Procedure Acquisition_cost_adj_processor(
192 ERRBUF OUT NOCOPY VARCHAR2,
193 RETCODE OUT NOCOPY NUMBER,
194 i_legal_entity IN NUMBER,
195 i_cost_type_id IN NUMBER,
196 i_period IN NUMBER,
197 i_end_date IN VARCHAR2,
198 i_cost_group_id IN NUMBER,
199 i_source_flag IN NUMBER,
200 i_run_option IN NUMBER,
201 i_receipt_dummy IN VARCHAR2,
202 i_receipt_no IN NUMBER,
203 i_invoice_dummy IN VARCHAR2,
204 i_invoice_no IN NUMBER,
205 i_chart_of_ac_id IN NUMBER,
206 i_adj_account_dummy IN NUMBER,
207 i_adj_account IN NUMBER
208 );
209
210
211 --pragma restrict_references(get_rcv_tax, WNDS, WNPS, RNPS);
212 --pragma restrict_references(get_po_rate, WNDS, WNPS, RNPS);
213
214 END CSTPPACQ;