1 PACKAGE OZF_RESALE_PVT AS
2 /* $Header: ozfvrsss.pls 120.2 2006/01/09 08:04:00 sangara noship $ */
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 --
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_start_date IN DATE
137 ,p_end_date IN DATE
138 ,p_partner_cust_account_id IN NUMBER
139 ,x_return_status OUT NOCOPY VARCHAR2
140 ,x_msg_data OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 );
143
144 ---------------------------------------------------------------------
145 -- PROCEDURE
146 -- Start_Process_Resale
147 --
148 -- PURPOSE
149 -- This procedure starts to process batches from interface table.
150 --
151 -- PARAMETERS
152 --
153 --
154 -- NOTES
155 ---------------------------------------------------------------------
156 PROCEDURE Start_Process_Resale (
157 ERRBUF OUT NOCOPY VARCHAR2
158 ,RETCODE OUT NOCOPY NUMBER
159 ,p_resale_batch_id IN NUMBER
160 ,p_start_date IN DATE
161 ,p_end_date IN DATE
162 ,p_partner_cust_account_id IN NUMBER
163 );
164
165 ---------------------------------------------------------------------
166 -- PROCEDURE
167 -- Purge
168 --
169 -- PURPOSE
170 -- This procedure removes processed data from the interface table.
171 --
172 -- PARAMETERS
173 --
174 --
175 -- NOTES
176 ---------------------------------------------------------------------
177 PROCEDURE Purge (
178 p_api_version IN NUMBER
179 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
180 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
181 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
182 ,p_data_source_code IN VARCHAR2 := NULL
183 ,p_resale_batch_id IN NUMBER := NULL
184 ,x_return_status OUT NOCOPY VARCHAR2
185 ,x_msg_data OUT NOCOPY VARCHAR2
186 ,x_msg_count OUT NOCOPY NUMBER
187 );
188
189 ---------------------------------------------------------------------
190 -- PROCEDURE
191 -- Start_Purge
192 --
193 -- PURPOSE
194 -- This procedure starts to remove processed data from the interface table.
195 --
196 -- PARAMETERS
197 --
198 --
199 -- NOTES
200 ---------------------------------------------------------------------
201 PROCEDURE Start_Purge (
202 ERRBUF OUT NOCOPY VARCHAR2
203 ,RETCODE OUT NOCOPY NUMBER
204 ,p_data_source_code IN VARCHAR2 :=null
205 ,p_resale_batch_id IN NUMBER := NULL
206 );
207
208 END OZF_RESALE_PVT;
[Home] [Help]