eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PO_DRAFTS_PVT

Source


4 g_ACCEPT_ALL CONSTANT VARCHAR2(10) := 'ACCEPT_ALL';
1 PACKAGE PO_DRAFTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: PO_DRAFTS_PVT.pls 120.30.12020000.5 2013/03/25 08:24:27 mabaig ship $ */
3 
5 g_REJECT_ALL CONSTANT VARCHAR2(10) := 'REJECT_ALL';
6 g_LINE_DISP  CONSTANT VARCHAR2(10) := 'LINE_DISP';
7 
8 g_status_DRAFT           CONSTANT PO_DRAFTS.status%TYPE := 'DRAFT';
9 g_status_IN_PROCESS      CONSTANT PO_DRAFTS.status%TYPE := 'IN PROCESS';
10 g_status_PDOI_PROCESSING CONSTANT PO_DRAFTS.status%TYPE := 'PDOI PROCESSING';
11 g_status_PDOI_ERROR      CONSTANT PO_DRAFTS.status%TYPE := 'PDOI ERROR';
12 g_status_COMPLETED       CONSTANT PO_DRAFTS.status%TYPE := 'COMPLETED';
13 g_status_WITHDRAWN       CONSTANT PO_DRAFTS.status%TYPE := 'WITHDRAWN';
14 
15 g_call_mod_HTML_UI   CONSTANT VARCHAR2(30) := 'HTML UI';
16 g_call_mod_PDOI      CONSTANT VARCHAR2(30) := 'PDOI';
17 g_call_mod_API       CONSTANT VARCHAR2(30) := 'API';
18 g_call_mod_FORM      CONSTANT VARCHAR2(30) := 'FORM';
19 g_call_mod_UNKNOWN   CONSTANT VARCHAR2(30) := 'UNKNOWN';
20 g_call_mod_FORMS_PO_SUMMARY   CONSTANT VARCHAR2(30) := 'FORMS PO SUMMARY'; --<Bug#4382472>
21 g_call_mod_HTML_UI_SAVE   CONSTANT VARCHAR2(30) := 'HTML UI SAVE';
22 
23 g_upload_status_PENDING CONSTANT VARCHAR2(10) := 'PENDING';
24 g_upload_status_RUNNING CONSTANT VARCHAR2(10) := 'RUNNING';
25 g_upload_status_ERROR   CONSTANT VARCHAR2(10) := 'ERROR';
26 
27 g_chg_accepted_flag_ACCEPT CONSTANT VARCHAR2(1) := 'Y';
28 g_chg_accepted_flag_REJECT CONSTANT VARCHAR2(1) := 'N';
29 g_chg_accepted_flag_NOTIFY CONSTANT VARCHAR2(1) := 'I'; -- bug5149827
30 
31 g_draft_type_MOD CONSTANT PO_DRAFTS.draft_type%TYPE := 'MOD'; -- <Mod Project>
32 g_draft_type_PAR CONSTANT PO_DRAFTS.draft_type%TYPE := 'PAR'; -- <PAR Project>
33 g_draft_type_DOC_CHANGE CONSTANT PO_DRAFTS.draft_type%TYPE := 'DOC_CHANGE';
34 
35 -- <Conc Mods Project START>
36 G_LOCK_HEADER_ENTITY CONSTANT VARCHAR2(30) := 'PO_HEADER';
37 G_LOCK_LINE_ENTITY CONSTANT VARCHAR2(30) := 'PO_LINE';
38 G_LOCK_SHIPMENT_ENTITY CONSTANT VARCHAR2(30) := 'PO_LINE_LOCATION';
39 G_LOCK_DIST_ENTITY CONSTANT VARCHAR2(30) := 'PO_DISTRIBUTION';
40 G_LOCK_ADDRESS_ENTITY CONSTANT VARCHAR2(30) := 'PO_UDA_ADDRESS';
41 -- Elins project
42 G_LOCK_EXHIBIT_ENTITY CONSTANT VARCHAR2(30) := 'PO_EXHIBIT';
43 
44 G_CHANGED_ENTTIES_ID CONSTANT VARCHAR2(30) := 'po_changed_entities';
45 G_LOCKS_REQUIRED_ID CONSTANT VARCHAR2(30) := 'po_locks_required';
46 
47 G_DRAFT_ID_MINUS_1 CONSTANT VARCHAR2(2) := '-1';
48 G_NULL_CHAR CONSTANT VARCHAR(1) := FND_API.G_NULL_CHAR;
49 G_NULL_NUM  CONSTANT NUMBER     := FND_API.G_NULL_NUM;
50 G_NULL_DATE CONSTANT DATE       := FND_API.G_NULL_DATE;
51 -- <Conc Mods Project END>
52 
53 --Bug 13938456<Conc Mods Attachment>
54 G_LOCK_HEADER_ATTACH_ENTITY CONSTANT VARCHAR2(30) := 'PO_HEADER_ATTACH';
55 G_LOCK_LINE_ATTACH_ENTITY CONSTANT VARCHAR2(30) := 'PO_LINE_ATTACH';
56 G_LOCK_SHIPMENT_ATTACH_ENTITY CONSTANT VARCHAR2(30) := 'PO_LINE_LOCATION_ATTACH';
57 
58 TYPE DRAFT_INFO_REC_TYPE IS RECORD
59 ( draft_id                      PO_DRAFTS.draft_id%TYPE,
60   po_header_id                  PO_HEADERS_ALL.po_header_id%TYPE,
61   doc_type                      PO_DOCUMENT_TYPES.document_type_code%TYPE,
65   headers_changed               VARCHAR2(1),
62   doc_subtype                   PO_DOCUMENT_TYPES.document_subtype%TYPE,
63   ga_flag                       PO_HEADERS_ALL.global_agreement_flag%TYPE,
64   new_document                  VARCHAR2(1),
66   lines_changed                 VARCHAR2(1),
67   line_locations_changed        VARCHAR2(1),
68   distributions_changed         VARCHAR2(1),
69   ga_org_assign_changed         VARCHAR2(1),
70   price_diff_changed            VARCHAR2(1),
71   notification_ctrl_changed     VARCHAR2(1),
72   attr_values_changed           VARCHAR2(1),
73   attr_values_tlp_changed       VARCHAR2(1),
74   price_adj_changed             VARCHAR2(1), --Enhanced Pricing
75   exhibits_changed              VARCHAR2(1), -- Elins project
76   draft_type                    PO_DRAFTS.draft_type%TYPE -- <Mod Project>
77 );
78 
79 
80 FUNCTION draft_id_nextval RETURN NUMBER;
81 
82 PROCEDURE populate_draft_info
83 ( p_draft_id IN NUMBER,
84   p_po_header_id IN NUMBER,
85   x_draft_info OUT NOCOPY DRAFT_INFO_REC_TYPE
86 );
87 
88 -- Bug 14277142 : Adding new parameter p_caller with default NULL
89 PROCEDURE transfer_draft_to_txn
90 ( p_api_version IN NUMBER,
91   p_init_msg_list IN VARCHAR2,
92   p_draft_id IN NUMBER,
93   p_po_header_id IN NUMBER,
94   p_delete_processed_draft IN VARCHAR2,
95   p_acceptance_action IN VARCHAR2,
96   x_return_status OUT NOCOPY VARCHAR2,
97   p_caller IN VARCHAR2 DEFAULT NULL
98 );
99 PROCEDURE remove_draft_changes
100 ( p_draft_id IN NUMBER,
101   p_exclude_ctrl_tbl IN VARCHAR2,
102   x_return_status OUT NOCOPY VARCHAR2
103 );
104 
105 PROCEDURE apply_changes
106 ( p_draft_info IN DRAFT_INFO_REC_TYPE
107 );
108 
109 PROCEDURE find_draft
110 ( p_po_header_id IN NUMBER,
111   x_draft_id OUT NOCOPY NUMBER,
112   x_draft_status OUT NOCOPY VARCHAR2,
113   x_draft_owner_role OUT NOCOPY VARCHAR2
114 );
115 
116 PROCEDURE find_draft
117 ( p_po_header_id IN NUMBER,
118   x_draft_id OUT NOCOPY NUMBER
119 );
120 
121 PROCEDURE get_request_id
122 ( p_draft_id IN NUMBER,
123   x_request_id OUT NOCOPY NUMBER
124 );
125 
126 PROCEDURE get_lock_owner_info
127 ( p_po_header_id IN NUMBER,
128   x_lock_owner_role OUT NOCOPY VARCHAR2,
129   x_lock_owner_user_id OUT NOCOPY NUMBER
130 );
131 
132 PROCEDURE set_lock_owner_info
133 ( p_po_header_id IN NUMBER,
134   p_role IN VARCHAR2,
135   p_role_user_id IN NUMBER
136 );
137 
138 PROCEDURE update_permission_check
139 ( p_calling_module IN VARCHAR2,
140   p_po_header_id IN NUMBER,
141   p_role IN VARCHAR2,
142   p_skip_cat_upload_chk IN VARCHAR2 := NULL,
143   x_update_allowed OUT NOCOPY VARCHAR2,
144   x_locking_applicable OUT NOCOPY VARCHAR2,
145   x_unlock_required OUT NOCOPY VARCHAR2,
146   x_message OUT NOCOPY VARCHAR2
147 );
148 
149 PROCEDURE update_permission_check
150 ( p_calling_module IN VARCHAR2,
151   p_po_header_id IN NUMBER,
152   p_role IN VARCHAR2,
153   p_skip_cat_upload_chk IN VARCHAR2 := NULL,
154   x_update_allowed OUT NOCOPY VARCHAR2,
155   x_locking_applicable OUT NOCOPY VARCHAR2,
156   x_unlock_required OUT NOCOPY VARCHAR2,
157   x_message OUT NOCOPY VARCHAR2,
158   x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
159   x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
160 );
161 
162 PROCEDURE update_permission_check
163 ( p_calling_module IN VARCHAR2,
167   x_update_allowed OUT NOCOPY VARCHAR2,
164   p_po_header_id IN NUMBER,
165   p_role IN VARCHAR2,
166   p_skip_cat_upload_chk IN VARCHAR2 := NULL,
168   x_locking_applicable OUT NOCOPY VARCHAR2,
169   x_unlock_required OUT NOCOPY VARCHAR2,
170   x_message OUT NOCOPY VARCHAR2,
171   x_message_text OUT NOCOPY VARCHAR2
172 );
173 
174 PROCEDURE unlock_document
175 ( p_po_header_id IN NUMBER
176 );
177 
178 PROCEDURE lock_document
179 ( p_po_header_id IN NUMBER,
180   p_role IN VARCHAR2,
181   p_role_user_id IN NUMBER,
182   p_unlock_current IN VARCHAR2
183 );
184 
185 FUNCTION is_locking_applicable
186 ( p_po_header_id IN NUMBER,
187   p_role IN VARCHAR2
188 ) RETURN VARCHAR2;
189 
190 FUNCTION is_draft_applicable
191 ( p_po_header_id IN NUMBER,
192   p_role IN VARCHAR2
193 ) RETURN VARCHAR2;
194 
195 PROCEDURE lock_document_with_validate
196 ( p_calling_module IN VARCHAR2,
197   p_po_header_id IN NUMBER,
198   p_role IN VARCHAR2,
199   p_role_user_id IN NUMBER,
200   x_locking_allowed OUT NOCOPY VARCHAR2,
201   x_message OUT NOCOPY VARCHAR2,
202   x_message_text OUT NOCOPY VARCHAR2
203 );
204 
205 PROCEDURE update_draft_status
206 ( p_draft_id IN NUMBER,
207   p_new_status IN VARCHAR2
208 );
209 
210 FUNCTION pending_changes_exist
211 ( p_po_header_id IN NUMBER
212 ) RETURN VARCHAR2;
213 
214 FUNCTION changes_exist_for_draft
215 ( p_draft_id_tbl PO_TBL_NUMBER
216 ) RETURN PO_TBL_VARCHAR1;
217 
218 FUNCTION lock_merge_view_records
219 ( p_view_name   IN VARCHAR2,
220   p_entity_id     IN NUMBER,
221   p_draft_id      IN NUMBER
222 ) RETURN VARCHAR2;
223 
224 FUNCTION is_pending_buyer_acceptance
225 ( p_po_header_id IN NUMBER
226 ) RETURN VARCHAR2;
227 
228 FUNCTION get_supplier_auth_enabled_flag
229 (p_po_header_id IN NUMBER
230  ) RETURN VARCHAR2;
231 
232 FUNCTION set_supplier_auth_enabled_flag
233 (p_po_header_id IN NUMBER,
234  p_supplier_auth_enabled_flag IN VARCHAR2
235  ) RETURN VARCHAR2;
236 
237 FUNCTION get_cat_admin_auth_enable_flag
238 (p_po_header_id IN NUMBER
239  ) RETURN VARCHAR2;
240 
241 FUNCTION set_cat_admin_auth_enable_flag
242 (p_po_header_id IN NUMBER,
243  p_cat_admin_auth_enable_flag IN VARCHAR2
244  ) RETURN VARCHAR2;
245 
246 -- bug 5014131 START
247 PROCEDURE get_upload_status_info
248 ( p_po_header_id IN NUMBER,
249   p_role IN VARCHAR2,
250   x_upload_status_code OUT NOCOPY VARCHAR2,
251   x_upload_requestor_role_id OUT NOCOPY NUMBER,
252   x_upload_job_number OUT NOCOPY NUMBER,
253   x_upload_status_display OUT NOCOPY VARCHAR2,
254   x_upload_is_error OUT NOCOPY NUMBER
255 );
256 
257 PROCEDURE get_in_process_upload_info
258 ( p_po_header_id IN NUMBER,
259   x_upload_in_progress OUT NOCOPY VARCHAR2,
260   x_upload_status_code OUT NOCOPY VARCHAR2,
261   x_upload_requestor_role OUT NOCOPY VARCHAR2,
262   x_upload_requestor_role_id OUT NOCOPY NUMBER,
263   x_upload_job_number OUT NOCOPY NUMBER,
264   x_upload_status_display OUT NOCOPY VARCHAR2
265 );
266 -- bug 5014131 START
267 
268 -- bug5090429 START
269 PROCEDURE unlock_document_and_send_notif
270 ( p_commit       IN VARCHAR2 := FND_API.G_FALSE,
271   p_po_header_id IN NUMBER
272 );
273 -- bug5090429 END
274 
275 --<Bug#4382472 Start>
276 PROCEDURE unlock_document_and_send_notif
277 ( p_commit       IN VARCHAR2 := FND_API.G_FALSE,
278   p_po_header_id IN NUMBER,
279   p_org_id       IN NUMBER,
280   p_segment1     IN VARCHAR2,
281   p_revision_num IN NUMBER
282 );
283 
284 --<Bug#4382472 End>
285 
286 --<Mod Project>
287 FUNCTION is_draft_exist
288 ( p_po_header_id IN NUMBER
289 ) RETURN VARCHAR2;
290 
291 -- <<Mod Commercialization>>
292 FUNCTION is_mod_enabled
293 (p_po_header_id IN NUMBER
294 ) RETURN VARCHAR2;
295 
296 -- <Conc Mods Project>
297 FUNCTION is_open_mod_exist
298 ( p_style_id IN NUMBER
299 ) RETURN VARCHAR2 ;
300 
301 PROCEDURE lock_entities(
302   p_entity_name_tbl IN PO_TBL_VARCHAR30,
303   p_draft_id        IN NUMBER,
304   p_pk1_tbl         IN PO_TBL_VARCHAR240,
305   p_pk2_tbl         IN PO_TBL_VARCHAR240,
306   p_pk3_tbl         IN PO_TBL_VARCHAR240,
307   p_pk4_tbl         IN PO_TBL_VARCHAR240,
308   x_return_status  OUT NOCOPY VARCHAR2,
309   x_results        OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
310 );
311 
315 p_draft_id IN NUMBER,
312 --Revert Changes of conc mod
313 PROCEDURE revert_header_action(
314 p_po_header_id IN NUMBER,
316 x_return_status OUT NOCOPY VARCHAR2
317 );
318 
319 PROCEDURE revert_dist_action(
320 p_po_draft_id        IN NUMBER,
321 po_dest_line_ids_tbl IN PO_TBL_NUMBER,
322 x_return_status OUT NOCOPY VARCHAR2 );
323 
324 PROCEDURE revert_shipment_action(
325 p_po_draft_id         IN NUMBER,
326 po_ship_ids_tbl IN PO_TBL_NUMBER,
327 x_return_status OUT NOCOPY VARCHAR2 );
328 
329 PROCEDURE revert_line_action(
330 p_po_draft_id         IN NUMBER,
331 po_line_ids_tbl IN PO_TBL_NUMBER,
332 x_return_status OUT NOCOPY VARCHAR2 );
333 
334 
335 PROCEDURE delete_marked_lines(
336 p_draft_id  IN  NUMBER
337 );
338 
339 PROCEDURE delete_marked_shipments(
340 p_draft_id  IN  NUMBER
341 );
342 
343 PROCEDURE delete_marked_distributions(
344 p_draft_id  IN  NUMBER
345 );
346 
347 --<Conc Mod Project>
348 PROCEDURE update_revnum_headers_ext
349 (p_draft_id        IN NUMBER,
350 p_po_header_id        IN NUMBER
351 );
352 
353 --<Conc Mod Project>
354 PROCEDURE delete_marked_entities(
355 p_draft_id  IN  NUMBER
356 );
357 
358 --Bug 13006217
359 PROCEDURE clean_up_extra_uda(
360 p_po_header_id  IN NUMBER,
361 p_draft_id     IN NUMBER
362 );
363 
364 --Bug 13938456- Conc Mods Attachement
365 FUNCTION get_attachment_count_for_mod(
366 p_po_header_id  IN NUMBER,
367 p_po_draft_id     IN NUMBER,
368 p_entity_name IN VARCHAR2
369 ) RETURN NUMBER;
370 
371 
372 --Bug 13938456<Attachment Project>
373 PROCEDURE copy_attachment(
374 p_lock_entity_name  IN VARCHAR2,
375 p_lock_entity_pk1  IN VARCHAR2,--it is the same as x_from_pk1_value
376 p_lock_entity_pk3 IN VARCHAR2 DEFAULT NULL,
377 p_lock_entity_pk4 IN VARCHAR2 DEFAULT NULL,
378 p_lock_by_draft_id IN NUMBER,
379 p_lock_type IN VARCHAR2,
383 
380 p_from_entity_name IN VARCHAR2,
381 p_to_entity_name   IN VARCHAR2,
382 p_orig_attach_doc_id IN NUMBER);
384 -- CLM Phase 4 - Elins project
385 PROCEDURE modify_exhibit_details (
386 p_po_header_id  IN NUMBER,
387 p_draft_id      IN NUMBER,
388 p_revision_num  IN NUMBER);
389 
390 
391 
392 -- <PAR Project>
393 FUNCTION is_par_exist
394 ( p_style_id IN NUMBER
395 ) RETURN VARCHAR2 ;
396 
397 --UCA Revert Action Changes Begin.
398 PROCEDURE delete_line_ucas(
399 p_po_draft_id         IN NUMBER,
400 po_line_ids_tbl IN PO_TBL_NUMBER);
401 --UCA Revert Action Changes End
402 END PO_DRAFTS_PVT;