1 PACKAGE OZF_RESALE_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvrsss.pls 120.5.12020000.2 2012/08/03 08:42:18 nepanda ship $ */
3
4
5 -- Default number of records fetch per call
6 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
7
8 ---------------------------------------------------------------------
9 -- PROCEDURE
10 -- Initiate_Payment
11 --
12 -- PURPOSE
13 -- This procedure to initiate payment process for a batch.
14 --
15 -- PARAMETERS
16 --
17 --
18 -- NOTES
19 ---------------------------------------------------------------------
20 PROCEDURE Initiate_Payment (
21 p_api_version IN NUMBER
22 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
24 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25 ,p_resale_batch_id IN NUMBER
26 ,x_return_status OUT NOCOPY VARCHAR2
27 ,x_msg_data OUT NOCOPY VARCHAR2
28 ,x_msg_count OUT NOCOPY NUMBER
29 );
30
31 ---------------------------------------------------------------------
32 -- PROCEDURE
33 -- Initiate_Payment_WFL
34 --
35 -- PURPOSE
36 -- This procedure is called from a work flow to initiate payment process for a batch.
37 --
38 -- PARAMETERS
39 --
40 --
41 -- NOTES
42 ---------------------------------------------------------------------
43 PROCEDURE Initiate_Payment_WFL (
44 itemtype in varchar2,
45 itemkey in varchar2,
46 actid in number,
47 funcmode in varchar2,
48 resultout in OUT NOCOPY varchar2
49 );
50
51 ---------------------------------------------------------------------
52 -- PROCEDURE
53 -- Process_iface
54 --
55 -- PURPOSE
56 -- This procedure to initiate data process of records in resales interface table.
57 --
58 -- PARAMETERS
59 --
60 --
61 -- NOTES
62 ---------------------------------------------------------------------
63 PROCEDURE Process_iface (
64 p_api_version IN NUMBER
65 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
66 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
67 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
68 ,p_resale_batch_id IN NUMBER
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 );
73
74 ---------------------------------------------------------------------
75 -- PROCEDURE
76 -- Process_Iface_WFL
77 --
78 -- PURPOSE
79 -- This procedure allows user to start the data process
80 --
81 -- PARAMETERS
82 --
83 --
84 -- NOTES
85 ---------------------------------------------------------------------
86 PROCEDURE Process_Iface_WFL (
87 itemtype in varchar2,
88 itemkey in varchar2,
89 actid in number,
90 funcmode in varchar2,
91 resultout in OUT NOCOPY varchar2
92 );
93
94 ---------------------------------------------------------------------
95 -- PROCEDURE
96 -- Process_Resale
97 --
98 -- PURPOSE
99 -- This procedure to initiate data process of records in resales table.
100 -- only third party accrual is supported.
101 --
102 -- PARAMETERS
103 --
104 --
105 -- NOTES
106 ---------------------------------------------------------------------
107 PROCEDURE Process_Resale (
108 p_api_version IN NUMBER
109 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
110 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
112 ,p_resale_batch_id IN NUMBER
113 ,x_return_status OUT NOCOPY VARCHAR2
114 ,x_msg_data OUT NOCOPY VARCHAR2
115 ,x_msg_count OUT NOCOPY NUMBER
116 );
117
118 ---------------------------------------------------------------------
119 -- PROCEDURE
120 -- Process_Resale
121 --
122 -- PURPOSE
123 -- This procedure to initiate data process of records in resales table.
124 -- only third party accrual is supported.
125 --
126 -- PARAMETERS
127 -- For TPA Parallel Execution ER Bug#9614703
128 --
129 -- NOTES
130 ---------------------------------------------------------------------
131 PROCEDURE Process_Resale (
132 p_api_version IN NUMBER
133 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
134 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
135 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
136 ,p_resale_batch_id IN NUMBER
137 ,x_return_status OUT NOCOPY VARCHAR2
138 ,x_msg_data OUT NOCOPY VARCHAR2
139 ,x_msg_count OUT NOCOPY NUMBER
140 ,x_batch_status OUT NOCOPY VARCHAR2 -- Bug#9614703
141 );
142
143 ---------------------------------------------------------------------
144 -- PROCEDURE
145 -- Process_Resale
146 --
147 -- PURPOSE
148 -- This procedure to initiate data process of records in resales table.
149 -- only third party accrual is supported.
150 --
151 -- PARAMETERS
152 --
153 --
154 -- NOTES
155 ---------------------------------------------------------------------
156 PROCEDURE Process_Resale (
157 p_api_version IN NUMBER
158 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
159 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
160 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
161 ,p_start_date IN DATE
162 ,p_end_date IN DATE
163 ,p_partner_cust_account_id IN NUMBER
164 ,x_return_status OUT NOCOPY VARCHAR2
165 ,x_msg_data OUT NOCOPY VARCHAR2
166 ,x_msg_count OUT NOCOPY NUMBER
167 );
168
169 ---------------------------------------------------------------------
170 -- PROCEDURE
171 -- Start_Process_Resale
172 --
173 -- PURPOSE
174 -- This procedure starts to process batches from interface table.
175 --
176 -- PARAMETERS
177 --
178 --
179 -- NOTES
180 ---------------------------------------------------------------------
181 PROCEDURE Start_Process_Resale (
182 ERRBUF OUT NOCOPY VARCHAR2
183 ,RETCODE OUT NOCOPY NUMBER
184 ,p_resale_batch_id IN NUMBER
185 ,p_start_date IN VARCHAR2
186 ,p_end_date IN VARCHAR2
187 ,p_partner_cust_account_id IN NUMBER
188 ,p_run_mode IN VARCHAR2 := NULL -- Bug 14194884 - TPA In Draft Mode ER
189 );
190
191 ---------------------------------------------------------------------
192 -- PROCEDURE
193 -- Purge
194 --
195 -- PURPOSE
196 -- This procedure removes processed data from the interface table.
197 --
198 -- PARAMETERS
199 --
200 --
201 -- NOTES
202 ---------------------------------------------------------------------
203 PROCEDURE Purge (
204 p_api_version IN NUMBER
205 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
206 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
207 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
208 ,p_data_source_code IN VARCHAR2 := NULL
209 ,p_resale_batch_id IN NUMBER := NULL
210 ,x_return_status OUT NOCOPY VARCHAR2
211 ,x_msg_data OUT NOCOPY VARCHAR2
212 ,x_msg_count OUT NOCOPY NUMBER
213 );
214
215 ---------------------------------------------------------------------
216 -- PROCEDURE
217 -- Start_Purge
218 --
219 -- PURPOSE
220 -- This procedure starts to remove processed data from the interface table.
221 --
222 -- PARAMETERS
223 --
224 --
225 -- NOTES
226 ---------------------------------------------------------------------
227 PROCEDURE Start_Purge (
228 ERRBUF OUT NOCOPY VARCHAR2
229 ,RETCODE OUT NOCOPY NUMBER
230 ,p_data_source_code IN VARCHAR2 :=null
231 ,p_resale_batch_id IN NUMBER := NULL
232 );
233
234 END OZF_RESALE_PVT;