1 package OZF_SD_UTIL_PVT AUTHID CURRENT_USER as
2 /* $Header: ozfvsdus.pls 120.7.12010000.5 2009/12/09 09:40:33 annsrini ship $ */
3
4 -- Start of Comments
5 -- Package name : OZF_SD_UTIL_PVT
6 -- Purpose :
7 -- History : 07-DEC-2009 - ANNSRINI - changes w.r.t multicurrency
8 -- NOTE :
9 -- End of Comments
10
11
12 --G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_SD_UTIL_PVT';
13 --G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvsdus.pls';
14
15 -- Author : MBHATT
16 -- Created : 11/16/2007 2:39:16 PM
17 -- Purpose :
18
19
20 -- Public function and procedure declarations
21
22
23 ---------------------------------------------------------------------
24 -- FUNCTION
25 -- SD_CONVERT_CURRENCY
26 --
27 -- PURPOSE
28 -- Gets converted currncy amount from request currency to plan currency
29 -- PARAMETERS
30 -- a) p_batch_line_id : batch line Id
31 -- b) p_amount number : amount in request currency
32 --
33 -- NOTES
34 --
35 -------------------------------------------------------------------------
36
37 function SD_CONVERT_CURRENCY(p_batch_line_id number,p_amount number) return number;
38
39 -------------------------------------------------------------------------
40 -- FUNCTION
41 -- GET_CONVERTED_CURRENCY
42 --
43 -- PURPOSE
44 -- This API does currency conversion in 1 or 2 steps
45 -- based on the difference in the plan,batch and functional currencies
46 --
47 -- PARAMETERS
48 -- p_plan_currency
49 -- p_batch_currency
50 -- p_functional_curr
51 -- p_exchange_rate_type - Exchange Rate Type
52 -- p_date - Exchange Rate Date of Accrual
53 -- p_amount - Amount to be converted
54 --
55 -- NOTES
56 --
57 ----------------------------------------------------------------------
58
59 function GET_CONVERTED_CURRENCY(p_plan_currency varchar2,p_batch_currency varchar2,p_functional_curr varchar2,p_exchange_rate_type varchar2,p_conv_rate number,p_date DATE,p_amount number) return number;
60
61
62 ---------------------------------------------------------------------
63 -- PROCEDURE
64 -- SD_AMOUNT_POSTBACK
65 --
66 -- PURPOSE
67 -- Updates OZF_FUNDS_UTILIZED_ALL_B for amount postback
68 -- PARAMETERS
69 -- a) p_batch_line_id : batch line Id
70 -- b) p_amount number : amount in request currency
71 --
72 -- NOTES
73 --
74 ----------------------------------------------------------------------
75
76 PROCEDURE SD_AMOUNT_POSTBACK(p_batch_line_id number, x_return_status OUT NOCOPY VARCHAR2, x_meaning OUT NOCOPY VARCHAR2);
77 PROCEDURE CONVERT_TO_RN_DATE(
78 p_server_date IN DATE,
79 x_rn_date OUT NOCOPY VARCHAR2);
80
81 PROCEDURE CONVERT_TO_DB_DATE(
82 p_rn_date IN VARCHAR2,
83 x_db_date OUT NOCOPY DATE);
84
85
86 ---------------------------------------------------------------------
87 -- PROCEDURE
88 -- UPDATE_SD_REQ_PRICES
89 --
90 -- PURPOSE
91 -- Updates the Ship and Debit price interface table with correct request line iD
92 -- PARAMETERS
93 -- a) p_request_number : The SD Request Number for transaction
94 -- b) p_request_line_id : Correct request line Id
95 --
96 -- NOTES
97 --
98 ----------------------------------------------------------------------
99 PROCEDURE UPDATE_SD_REQ_PRICES(p_request_number IN VARCHAR2,p_request_line_id IN NUMBER);
100
101
102 ---------------------------------------------------------------------
103 -- PROCEDURE
104 -- PROCESS_SD_RESPONSE
105 --
106 -- PURPOSE
107 -- Updates the Ship and Debit header and base tables for the inbound data
108 -- only when the business validation(s) are passed
109 -- The business validation involved are
110 -- a)
111 -- PARAMETERS
112 -- a) p_request_number : The SD Request Number
113 -- b) x_return_status : Return status for the processing
114 -- c) x_msg_data : Error message if the validation errored out
115 -- NOTES
116 --
117 ----------------------------------------------------------------------
118 PROCEDURE PROCESS_SD_RESPONSE(p_request_number IN VARCHAR2
119 , x_return_status OUT nocopy VARCHAR2
120 , x_msg_data OUT nocopy VARCHAR2
121 );
122
123 PROCEDURE CONVERT_TO_RN_TIMEZONE(
124 p_input_date IN DATE,
125 x_utc_date OUT NOCOPY DATE );
126
127
128 PROCEDURE CONVERT_TO_RN_DATETIME(
129 p_server_date IN DATE,
130 x_rn_datetime OUT NOCOPY VARCHAR2);
131
132 ---------------------------------------------------------------------
133 -- PROCEDURE
134 -- UPDATE_SD_REQ_STALE_DATA
135 --
136 -- PURPOSE
137 -- Updates the Ship and Debit interface tables for any stale data
138 --
139 -- PARAMETERS
140 -- a) p_request_number : The SD Request Number
141 -- NOTES
142 --
143 ----------------------------------------------------------------------
144 PROCEDURE UPDATE_SD_REQ_STALE_DATA(p_request_number IN VARCHAR2);
145
146 ---------------------------------------------------------------------
147 -- PROCEDURE
148 -- SD_RAISE_EVENT
149 --
150 -- PURPOSE
151 -- This procedure raises a Business Event based on batch action.
152 --
153 -- PARAMETERS
154 -- a) Batch ID
155 -- b) Batch Action - can be EXPORT,CREATE, RESPONSE and CLAIM.
156 -- NOTES
157 --
158 ----------------------------------------------------------------------
159 PROCEDURE SD_RAISE_EVENT(P_BATCH_ID IN NUMBER,
160 P_BATCH_ACTION IN VARCHAR2,
161 x_return_status OUT NOCOPY VARCHAR2);
162
163
164 ---------------------------------------------------------------------
165 -- PROCEDURE
166 -- PROCESS_BATCH_ADJUST_CLAIM
167 --
168 -- PURPOSE
169 -- This procedure is to process the submitted batch for claim and adjustment
170 -- This will be called from the batch UI in Close and Export
171 --
172 -- PARAMETERS
173 -- a) p_batch_header_id - Batch header Id
174 --
175 -- NOTES
176 --
177 ----------------------------------------------------------------------
178 PROCEDURE PROCESS_BATCH_ADJUST_CLAIM( p_batch_header_id NUMBER,
179 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
180 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2) ;
184
185
186 ---------------------------------------------------------------------
187 -- PROCEDURE
188 -- CREATE_ADJUSTMENT
189 --
190 -- PURPOSE
191 -- This procedure is to create adjustment for submitted batch
192 --
193 -- PARAMETERS
194 -- a) p_batch_header_id - Batch header Id
195 --
196 -- NOTES
197 --
198 ----------------------------------------------------------------------
199 PROCEDURE CREATE_ADJUSTMENT( p_batch_header_id NUMBER,
200 p_comp_wrt_off IN VARCHAR2 := fnd_api.g_false,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2) ;
204
205
206
207 -- Start of comments
208 -- API name : PROCESS_SD_PEN_CLOSE_BATCHES
209 -- Type : Private
210 -- Pre-reqs : Batch Status should be Pending Close
211 -- Function : Executable target for concurrent program
212 -- : Executable Name "OZFSDPBPEX"
213 -- : Processes the batch for Adjustment and Claim
214 -- Parameters :
215 -- IN : p_batch_id IN NUMBER
216
217 -- End of comments
218
219 PROCEDURE PROCESS_SD_PEN_CLOSE_BATCHES(errbuf OUT nocopy VARCHAR2,
220 retcode OUT nocopy NUMBER,
221 p_batch_id NUMBER) ;
222
223
224
225 -- Start of comments
226 -- API name : SET_COMPLETE_FLAGS
227 -- Type : Private
228 -- Purpose : Mark the line status to complete
229 -- IN : p_batch_id IN NUMBER
230
231 -- End of comments
232
233 PROCEDURE SET_COMPLETE_FLAGS( p_batch_header_id NUMBER,
234 x_return_status OUT NOCOPY VARCHAR2) ;
235
236
237
238 -- Start of comments
239 -- API name : PROCESS_SD_PEN_CLOSE_BATCHES
240 -- Type : Private
241 -- Purpose : Check if few lines have complete not set
242 -- Parameters :
243 -- IN : p_batch_id IN NUMBER
244
245 -- End of comments
246 PROCEDURE CHECK_COMPLETE_FLAGS( p_batch_header_id NUMBER,
247 x_return_status OUT NOCOPY VARCHAR2) ;
248
249
250 end OZF_SD_UTIL_PVT;
251
252