[Home] [Help]
PACKAGE: APPS.PO_ASL_API_PVT
Source
1 PACKAGE PO_ASL_API_PVT AUTHID CURRENT_USER AS
2 /* $Header: PO_ASL_API_PVT.pls 120.2.12020000.1 2013/02/11 10:30:30 vegajula noship $*/
3
4 g_STATUS_REJECTED CONSTANT VARCHAR2(20) := 'REJECTED';
5 g_STATUS_SUCCESS CONSTANT VARCHAR2(20) := 'SUCCESS';
6 g_STATUS_PENDING CONSTANT VARCHAR2(20) := 'PENDING';
7
8 --------------------------------------------------------------------------------
9 --Start of Comments
10
11 --Name: process
12
13 --Function:
14 -- This will create/update records in the base tables for non rejected
15 -- records in the gt tables.
16 -- Next it will try to default any null fields which are defaultable.
17 -- Call PO_ASL_API_PVT.reject_asl_record for which the id values remain null
18 -- and dsp values are not null after processing
19
20 --Parameters:
21
22 --IN:
23 -- p_session_key NUMBER
24
25 --OUT:
26 -- x_return_status VARCHAR2
27 -- x_return_msg VARCHAR2
28
29 --End of Comments
30 --------------------------------------------------------------------------------
31
32 PROCEDURE process(
33 p_session_key IN NUMBER
34 , x_return_status OUT NOCOPY VARCHAR2
35 , x_return_msg OUT NOCOPY VARCHAR2
36 );
37
38
39 --------------------------------------------------------------------------------
40 --Start of Comments
41
42 --Name: reject_asl_record
43
44 --Function:
45 -- Reject the record by mariking the column 'PROCESS_STATUS' to 'REJECT'.
46 -- bulk insert into po_asl_api_errors with the rejection_reason and user_key
47
48 --Parameters:
49
50 --IN:
51 -- p_user_key_tbl po_tbl_number,
52 -- p_rejection_reason po_tbl_varchar2000,
53 -- p_entity_name po_tbl_varchar30
54
55 --OUT:
56 -- x_return_status VARCHAR2
57 -- x_return_msg VARCHAR2
58
59 --End of Comments
60 --------------------------------------------------------------------------------
61
62 PROCEDURE reject_asl_record(
63 p_user_key_tbl IN po_tbl_number
64 , p_rejection_reason IN po_tbl_varchar2000
65 , p_entity_name IN po_tbl_varchar30
66 , p_session_key in NUMBER
67 , x_return_status OUT NOCOPY VARCHAR2
68 , x_return_msg OUT NOCOPY VARCHAR2
69 );
70
71
72 --------------------------------------------------------------------------------
73 --Start of Comments
74
75 --Name: log
76
77 --Function:
78 -- For logging messages
79
80 --Parameters:
81
82 --IN:
83 --p_log_message varchar2
84
85 --End of Comments
86 --------------------------------------------------------------------------------
87
88 PROCEDURE log(
89 p_log_message IN varchar2
90 );
91
92 --------------------------------------------------------------------------------
93 --Start of Comments
94
95 --Name: log
96
97 --Function:
98 -- For logging po_approved_supplier_list_rec records
99
100 --Parameters:
101
102 --IN:
103 --p_asl_rec po_approved_supplier_list_rec
104
105 --End of Comments
106 --------------------------------------------------------------------------------
107
108 PROCEDURE log(
109 p_asl_rec IN po_approved_supplier_list_rec
110 );
111
112 --------------------------------------------------------------------------------
113 --Start of Comments
114
115 --Name: log
116
117 --Function:
118 -- For logging po_asl_attributes_rec records
119
120 --Parameters:
121
122 --IN:
123 --p_attr_rec po_asl_attributes_rec
124
125 --End of Comments
126 --------------------------------------------------------------------------------
127
128 PROCEDURE log(
129 p_attr_rec IN po_asl_attributes_rec
130 );
131
132 --------------------------------------------------------------------------------
133 --Start of Comments
134
135 --Name: log
136
137 --Function:
138 -- For logging po_asl_documents_rec records
139
140 --Parameters:
141
142 --IN:
143 --p_doc_rec po_asl_documents_rec
144
145 --End of Comments
146 --------------------------------------------------------------------------------
147
148 PROCEDURE log(
149 p_doc_rec IN po_asl_documents_rec
150 );
151
152 --------------------------------------------------------------------------------
153 --Start of Comments
154
155 --Name: log
156
157 --Function:
158 -- For logging chv_authorizations_rec records
159
160 --Parameters:
161
162 --IN:
163 --p_chv_rec chv_authorizations_rec
164
165 --End of Comments
166 --------------------------------------------------------------------------------
167
168 PROCEDURE log(
169 p_chv_rec IN chv_authorizations_rec
170 );
171
172 --------------------------------------------------------------------------------
173 --Start of Comments
174
175 --Name: log
176
177 --Function:
178 -- For logging po_supplier_item_capacity_rec records
179
180 --Parameters:
181
182 --IN:
183 --p_cap_rec po_supplier_item_capacity_rec
184
185 --End of Comments
186 --------------------------------------------------------------------------------
187
188 PROCEDURE log(
189 p_cap_rec IN po_supplier_item_capacity_rec
190 );
191
192 --------------------------------------------------------------------------------
193 --Start of Comments
194
195 --Name: log
196
197 --Function:
198 -- For logging po_supplier_item_tolerance_rec records
199
200 --Parameters:
201
202 --IN:
203 --p_tol_rec po_supplier_item_tolerance_rec
204
205 --End of Comments
206 --------------------------------------------------------------------------------
207
208 PROCEDURE log(
209 p_tol_rec IN po_supplier_item_tolerance_rec
210 );
211
212 --------------------------------------------------------------------------------
213 --Start of Comments
214
215 --Name: log
216
217 --Function:
218 -- For logging po_tbl_number records
219
220 --Parameters:
221
222 --IN:
223 --tbl_number po_tbl_number
224
225 --End of Comments
226 --------------------------------------------------------------------------------
227
228 PROCEDURE log(
229 tbl_number IN po_tbl_number
230 );
231
232 --------------------------------------------------------------------------------
233 --Start of Comments
234
235 --Name: log
236
237 --Function:
238 -- For logging po_tbl_varchar2000 records
239
240 --Parameters:
241
242 --IN:
243 --tbl_varchar po_tbl_varchar2000
244
245 --End of Comments
246 --------------------------------------------------------------------------------
247
248 PROCEDURE log(
249 tbl_varchar IN po_tbl_varchar2000
250 );
251
252 --------------------------------------------------------------------------------
253 --Start of Comments
254
255 --Name: log
256
257 --Function:
258 -- For logging po_tbl_varchar30 records
259
260 --Parameters:
261
262 --IN:
263 --tbl_varchar po_tbl_varchar30
264
265 --End of Comments
266 --------------------------------------------------------------------------------
267
268 PROCEDURE log(
269 tbl_varchar IN po_tbl_varchar30
270 );
271
272 END PO_ASL_API_PVT;