4 /*===========================================================================
1 PACKAGE PO_INQ_SV AUTHID CURRENT_USER as
2 /* $Header: POXPOVPS.pls 120.2.12020000.3 2013/02/10 20:53:44 vegajula ship $ */
3
5 PACKAGE NAME: PO_INQ_SV
6
7 DESCRIPTION: This package contains the server side PO Inquiry
8 Application Program Interfaces (APIs).
9
10 CLIENT/SERVER: Server
11
12 OWNER: Gopi Tummala
13
14 FUNCTION/PROCEDURE:
15 ===========================================================================*/
16
17 /*===========================================================================
18 PROCEDURE NAME: get_action_history_values ()
19
20 DESCRIPTION: This procedure will get the startup values for the
21 action history form. Several sql stmnts are included
25 PARAMETERS: Input paramters: document id
22 in here to save network roundtrips.
23
24
26 document type
27 document subtype -- comes in as null but
28 needed otherwise cannot
29 read its value in plsql.
30 Output parameters : document subtype
31 document preparer
32 security level
33 security_hierarchy_id
34
35 DESIGN REFERENCES: ../POXPOAH.dd
36
37 ALGORITHM:
38
39 NOTES:
40
41 OPEN ISSUES:
42
43 CLOSED ISSUES:
44
45 CHANGE HISTORY: Created 19-JUL-95 GTUMMALA
46 ===========================================================================*/
47 PROCEDURE get_action_history_values (x_object_id IN NUMBER,
48 x_object_type_code IN VARCHAR2,
49 x_subtype_code IN OUT NOCOPY VARCHAR2,
50 x_type_name OUT NOCOPY VARCHAR2,
51 x_document_number OUT NOCOPY VARCHAR2,
52 x_preparer_id OUT NOCOPY NUMBER,
53 x_security_level OUT NOCOPY VARCHAR2,
54 x_security_hierarchy_id OUT NOCOPY NUMBER);
55
56
57 /*===========================================================================
58 PROCEDURE NAME: get_po_doc_access_sec_level ()
59
60 DESCRIPTION: This procedure will get the access and secruity level
61 for each of the four types of Purchase Orders and two
62 Release types in addition to the security hierarchy.
63
64
65 PARAMETERS: No input parameters.
66 Output parameters are the security level
67 for each type of PO and Release in addition to the
68 security hierarchy.
69
70 DESIGN REFERENCES: ../POXPOVPO.dd
71
72 ALGORITHM:
73
74 NOTES:
75
76 OPEN ISSUES:
77
78 CLOSED ISSUES:
79
80 CHANGE HISTORY: Created 16-JUN-95 GTUMMALA
81 ===========================================================================*/
82 PROCEDURE get_po_doc_access_sec_level(x_standard_security OUT NOCOPY VARCHAR2,
83 x_blanket_security OUT NOCOPY VARCHAR2,
84 x_contract_security OUT NOCOPY VARCHAR2,
85 x_planned_security OUT NOCOPY VARCHAR2,
86 x_blanket_rel_security OUT NOCOPY VARCHAR2,
87 x_scheduled_rel_security OUT NOCOPY VARCHAR2,
88 x_security_hierarchy_id OUT NOCOPY NUMBER);
89
90
91 /*===========================================================================
92 FUNCTION NAME: get_active_enc_amount()
93
94 DESCRIPTION: This function returns the active encumbrance amount
95 of the given po_distribtuion
96
97 PARAMETERS: In: rate of the dist.
98 ecumbered amount of dist.
99 shipment_type of the line.
100 po_distribution_id of dist.
101
102 Out: active encumbrance amount for the dist.
103
104 DESIGN REFERENCES: ../POXPOVPO.dd
105
106 ALGORITHM:
107
108 NOTES:
109
110 OPEN ISSUES:
111
112 CLOSED ISSUES:
113
114 CHANGE HISTORY: Created 11-JUL-95 GTUMMALA
115 ===========================================================================*/
116 FUNCTION get_active_enc_amount(x_rate IN NUMBER,
117 x_enc_amount IN NUMBER,
118 x_shipment_type IN VARCHAR2,
119 x_po_distribution_id IN NUMBER )
120 RETURN NUMBER;
121 --pragma restrict_references (get_active_enc_amount,WNDS,RNPS,WNPS);
122
123
124 /*===========================================================================
125 FUNCTION NAME: get_dist_amount()
126
127 DESCRIPTION: This function returns the distribution amount
128 of the given po_distribtuion
129
130 PARAMETERS: In:
131 quantity ordered of dist.
132 unit price of the line.
133 po_distribution_id of dist.
134
135 Out: amount for the dist.
136
137 DESIGN REFERENCES: ../POXPOVPO.dd
138
139 ALGORITHM:
140
141 NOTES:
142
143 OPEN ISSUES:
144
145 CLOSED ISSUES:
146
147 CHANGE HISTORY: Created 11-JUL-95 GTUMMALA
148 ===========================================================================*/
149 /* Changed due to bug 601388
150 Removed IN parameter x_rate from the function as price is required in
151 foreign currency and not functional currency
152 */
153
154 FUNCTION get_dist_amount
155 ( p_quantity_ordered IN NUMBER -- <SERVICES FPJ>
156 , p_price_override IN NUMBER -- <SERVICES FPJ>
157 , p_amount_ordered IN NUMBER -- <SERVICES FPJ>
158 , p_po_line_loc_id IN NUMBER -- <Complex Work R12>
159 , p_po_distribution_id IN NUMBER --Bug 13440718
160 ) RETURN NUMBER;
161 -- pragma restrict_references (get_dist_amount,WNDS,RNPS,WNPS);
162
163 /*===========================================================================
164 PROCEDURE NAME: get_func_currency_attributes()
165
166 DESCRIPTION: This procedure returns the several attributes of the
167 functional currency from fnd_currencies.
168
169 PARAMETERS: In : None
170 Out: min_accountable_unit of the currency
171 precision of the currecny
172
173 DESIGN REFERENCES: ../POXPOVPO.dd
174
175 ALGORITHM:
176
177 NOTES:
178
179 OPEN ISSUES:
180
181 CLOSED ISSUES:
182
186 x_precision OUT NOCOPY NUMBER);
183 CHANGE HISTORY: Created 11-JUL-95 GTUMMALA
184 ===========================================================================*/
185 PROCEDURE get_func_currency_attributes(x_min_unit OUT NOCOPY NUMBER,
187
188 -- pragma restrict_references (get_func_currency_attributes,WNDS,RNPS,WNPS);
189
190
191 /*===========================================================================
192 FUNCTION NAME: get_person_name
193
194 DESCRIPTION: This procedure returns the full_name
195 of the person based on the id.
196
197 PARAMETERS: In : Id of the person
198 Out: Full name of the person
199
200
201 DESIGN REFERENCES: ../POXPOVPO.dd
202
203 ALGORITHM:
204
205 NOTES:
206
207 OPEN ISSUES:
208
209 CLOSED ISSUES:
210
211 CHANGE HISTORY: Created 11-JUL-95 GTUMMALA
212 ===========================================================================*/
213 FUNCTION get_person_name (x_person_id IN NUMBER)
214 RETURN VARCHAR2;
215
216 -- pragma restrict_references (get_person_name,WNDS,WNPS);
217
218 /* GK - removed RNPS for the package to compile; still need to
219 investigate the consequences */
220
221 /*===========================================================================
222 FUNCTION NAME: get_wip_operation_code
223
224 DESCRIPTION: THIS PROCEDURE RETURNS WIP_OPERATION_CODE
225 FOR THE PO DISTRIBUTION
226
227 PARAMETERS: IN : WIP_ENTITY_ID OF PO DISTRIBUTION
228 WIP_OPERATION_SEQ_NUM " " "
229 DESTINATION_ORGANIZATION_ID" " "
230 WIP_REPETITIVE_SCHEDULE_ID " " "
231
232 OUT: WIP_OPERATION_CODE
233
234
235 DESIGN REFERENCES: ../POXPOVPO.DD
236
237 ALGORITHM:
238
239 NOTES:
240
241 OPEN ISSUES:
242
243 CLOSED ISSUES:
244
245 CHANGE HISTORY: CREATED 11-JUL-95 GTUMMALA
246 ===========================================================================*/
247 FUNCTION GET_WIP_OPERATION_CODE(X_WIP_ENTITY_ID IN NUMBER,
248 X_WIP_OPERATION_SEQ_NUM IN NUMBER,
249 X_DESTINATION_ORG_ID IN NUMBER,
250 X_WIP_REP_SCHEDULE_ID IN NUMBER)
251 RETURN VARCHAR2;
252
253 -- PRAGMA RESTRICT_REFERENCES (GET_WIP_OPERATION_CODE,WNDS,RNPS,WNPS);
254
255 /*===========================================================================
256 FUNCTION NAME: GET_BOM_DEPARTMENT_CODE
257
258 DESCRIPTION: THIS PROCEDURE RETURNS BOM_DEPARTMENT_CODE
259 FOR THE PO DISTRIBUTION
260
261 PARAMETERS: IN : WIP_ENTITY_ID OF PO DISTRIBUTION
262 WIP_OPERATION_SEQ_NUM " " "
263 DESTINATION_ORGANIZATION_ID" " "
264 WIP_REPETITIVE_SCHEDULE_ID " " "
265
266 OUT: BOM_DEPARTMENT_CODE
267
268
269 DESIGN REFERENCES: ../POXPOVPO.DD
270
271 ALGORITHM:
272
273 NOTES:
274
275 OPEN ISSUES:
276
277 CLOSED ISSUES:
278
279 CHANGE HISTORY: CREATED 11-JUL-95 GTUMMALA
280 ===========================================================================*/
281 FUNCTION GET_BOM_DEPARTMENT_CODE(X_WIP_ENTITY_ID IN NUMBER,
282 X_WIP_OPERATION_SEQ_NUM IN NUMBER,
283 X_DESTINATION_ORG_ID IN NUMBER,
284 X_WIP_REP_SCHEDULE_ID IN NUMBER)
285 RETURN VARCHAR2;
286
287 -- PRAGMA RESTRICT_REFERENCES (GET_BOM_DEPARTMENT_CODE,WNDS,RNPS,WNPS);
288
289 /*===========================================================================
290 FUNCTION NAME: get_assembly_quantity
291
292 DESCRIPTION: This function returns the bom_department_code for
293 the distribution.
294
295 PARAMETERS: IN : item_id of po line
296 wip_entity_id of po distribution
297 wip_operation_seq_num " " "
298 wip_resource_seq_num " " "
299 Destination_organization_id" " "
303 Out: assembly quantity for the distribution
300 wip_repetitive_schedule_id " " "
301 quantity_ordered " " "
302
304
305
306 DESIGN REFERENCES: ../POXPOVPO.dd
307
308 ALGORITHM:
309
310 NOTES:
311
312 OPEN ISSUES:
313
314 CLOSED ISSUES:
315
316 CHANGE HISTORY: Created 11-JUL-95 GTUMMALA
317
318 ===========================================================================*/
319 FUNCTION get_assembly_quantity(x_item_id IN NUMBER,
320 x_wip_entity_id IN NUMBER,
321 x_wip_operation_seq_num IN NUMBER,
322 x_wip_resource_seq_num IN NUMBER,
323 x_destination_org_id IN NUMBER,
324 x_wip_rep_schedule_id IN NUMBER,
325 x_quantity_ordered IN NUMBER,
326 p_item_organization_id IN NUMBER DEFAULT NULL) -- <HTMLAC>
327 RETURN NUMBER;
328
329 -- pragma restrict_references (get_assembly_quantity,WNDS,RNPS,WNPS);
330
331
332 /*===========================================================================
333 FUNCTION NAME: get_resource_quantity
334
335 DESCRIPTION: This procedure returns bom_department_code
336 for the po distribution
337
338 PARAMETERS: In : item_id of po line
339 wip_entity_id of po distribution
340 wip_operation_seq_num " " "
341 wip_resource_seq_num " " "
342 destination_organization_id" " "
343 wip_repetitive_schedule_id " " "
344 quantity_ordered " " "
345
346 Out: resource quantity for the distribution
347
348
349 DESIGN REFERENCES: ../POXPOVPO.dd
350
351 ALGORITHM:
352
353 NOTES:
354
355 OPEN ISSUES:
356
357 CLOSED ISSUES:
358
359 CHANGE HISTORY: Created 11-JUL-95 GTUMMALA
360 ===========================================================================*/
361 FUNCTION get_resource_quantity(x_item_id IN NUMBER,
362 x_wip_entity_id IN NUMBER,
363 x_wip_operation_seq_num IN NUMBER,
364 x_wip_resource_seq_num IN NUMBER,
365 x_destination_org_id IN NUMBER,
366 x_wip_rep_schedule_id IN NUMBER,
367 x_quantity_ordered IN NUMBER,
368 p_item_organization_id IN NUMBER DEFAULT NULL) -- <HTMLAC>
369 RETURN NUMBER;
370
371 -- pragma restrict_references (get_resource_quantity,WNDS,RNPS,WNPS);
372
373
374 /*===========================================================================
375 FUNCTION NAME: get_po_number
376
377 DESCRIPTION: This procedure returns the po number that a
378 requisition line is on.
379
380 PARAMETERS: In : line_location_id
381
382 Out: po_number
383
384
385 DESIGN REFERENCES:
386
387 ALGORITHM:
388
389 NOTES:
390
391 OPEN ISSUES:
392
393 CLOSED ISSUES:
394
395 CHANGE HISTORY: Created 20-FEB-96 GTUMMALA
396 ===========================================================================*/
397 FUNCTION get_po_number (x_line_location_id IN NUMBER) RETURN VARCHAR2;
398
399
400 -- pragma restrict_references (get_po_number,WNDS,RNPS,WNPS);
401
402
403 /*===========================================================================
404 FUNCTION NAME: get_so_number
405
406 DESCRIPTION: This procedure returns the sales order number that a
407 requisition line is on.
408
409 PARAMETERS: In : segment1(req_num), --obsolete
410 line_num --obsolete
411
412 po_requisition_header_id
413 po_requisition_line_id
414
415 Out: so_number
416
417
418 DESIGN REFERENCES:
419
420 ALGORITHM:
421
422 NOTES:
423
424 OPEN ISSUES:
425
426 CLOSED ISSUES:
427
428 CHANGE HISTORY: Created 20-FEB-96 GTUMMALA
429 ===========================================================================*/
430
431 --Bug# 1392077
432 --Toju George 08/31/2000
433 --Modified the call to procedure to replace req_num and line_num with ids.
434
435 /*FUNCTION get_so_number (x_segment1 IN VARCHAR2,
436 x_line_num IN NUMBER) RETURN VARCHAR2;*/
437
438 FUNCTION get_so_number (x_requisition_header_id IN VARCHAR2,
439 x_requisition_line_id IN NUMBER) RETURN VARCHAR2;
440
441 /* pragma restrict_references (get_so_number,WNDS,RNPS,WNPS);*/
442
443 /*===========================================================================
444 FUNCTION NAME: shipment_from_req
445
446 DESCRIPTION: This function check whether a shipment is associated
447 with a requisition line.
448
449 PARAMETERS: In : line_location_id
450
451 Returns: TRUE OR FALSE
452
453
454 DESIGN REFERENCES:
455
456 ALGORITHM:
457
458 NOTES:
459
460 OPEN ISSUES:
461
462 CLOSED ISSUES:
463
464 CHANGE HISTORY: Created 28-FEB-96 CMOK
465 ===========================================================================*/
466
467 FUNCTION shipment_from_req (x_line_location_id IN NUMBER)
468 RETURN BOOLEAN ;
469
470 /*===========================================================================
471 FUNCTION NAME: get_po_total
472
473 DESCRIPTION: This function returns the total on a PO or Release.
477 po_header_id
474 It is called by the view PO_HEADERS_INQ_V
475
476 PARAMETERS: In : type_lookup_code
478 po_release_id
479
480 Returns: PO total
481
482
483 DESIGN REFERENCES:
484
485 ALGORITHM:
486
487 NOTES:
488
489 OPEN ISSUES:
490
491 CLOSED ISSUES:
492
493 CHANGE HISTORY: Created 28-FEB-96 CMOK
494 ===========================================================================*/
495
496 FUNCTION get_po_total (x_type_lookup_code IN VARCHAR2,
497 x_po_header_id IN NUMBER,
498 x_po_release_id IN NUMBER)
499 return NUMBER;
500
501 -- pragma restrict_references (get_po_total,WNDS);
502
503 /*===========================================================================
504 FUNCTION NAME: get_post_query_info
505
506 DESCRIPTION: This procedure is called in post-query for
507 the headers, lines and shipments folders. The purpose
508 of this procedure is to reduce the round-trips to
509 the server in the post-query.
510
511 PARAMETERS:
512
513 DESIGN REFERENCES:
514
515 ALGORITHM:
516
517 NOTES:
518
519 OPEN ISSUES:
520
521 CLOSED ISSUES:
522
523 CHANGE HISTORY: Created 28-OCT-96 CMOK
524 ===========================================================================*/
525
526 PROCEDURE get_post_query_info (
527 x_cancelled_by IN NUMBER,
528 x_closed_by IN NUMBER,
529 x_agent_id IN NUMBER,
530 x_type_lookup_code IN VARCHAR2,
531 x_po_header_id IN NUMBER,
532 x_po_release_id IN NUMBER,
533 x_po_line_id IN NUMBER,
534 x_line_location_id IN NUMBER,
535 x_agent_name IN OUT NOCOPY VARCHAR2,
536 x_closed_by_name IN OUT NOCOPY VARCHAR2,
537 x_cancelled_by_name IN OUT NOCOPY VARCHAR2,
538 x_base_currency IN OUT NOCOPY VARCHAR2,
539 x_amount IN OUT NOCOPY NUMBER);
540
541
542 /*===========================================================================
543 FUNCTION NAME: get_distribution_info
544
545 DESCRIPTION: This procedure is called in post-query for
546 the distribution folder. The purpose
547 of this procedure is to reduce the round-trips to
548 the server in the post-query.
549
550 PARAMETERS:
551
552 DESIGN REFERENCES:
553
554 ALGORITHM:
555
556 NOTES:
557
558 OPEN ISSUES:
559
560 CLOSED ISSUES:
561
562 CHANGE HISTORY: Created 28-OCT-96 CMOK
563 ===========================================================================*/
564
565 PROCEDURE get_distribution_info (
566 x_deliver_to_person_id IN NUMBER,
567 x_closed_by IN NUMBER,
568 x_agent_id IN NUMBER,
569 x_item_id IN NUMBER,
570 x_wip_entity_id IN NUMBER,
571 x_wip_operation_seq_num IN NUMBER,
572 x_wip_resource_seq_num IN NUMBER,
573 x_destination_org_id IN NUMBER,
574 x_wip_rep_schedule_id IN NUMBER,
575 x_quantity_ordered IN NUMBER,
576 x_rate IN NUMBER,
577 x_price_override IN NUMBER,
578 x_amount_ordered IN NUMBER, -- <SERVICES FPJ>
579 x_po_line_id IN NUMBER, -- <SERVICES FPJ>
580 x_line_location_id IN NUMBER,
581 x_encumbered_amount IN NUMBER,
582 x_shipment_type IN VARCHAR2,
583 x_po_distribution_id IN NUMBER,
584 x_deliver_to_person IN OUT NOCOPY VARCHAR2,
585 x_agent_name IN OUT NOCOPY VARCHAR2,
586 x_closed_by_name IN OUT NOCOPY VARCHAR2,
587 x_base_currency IN OUT NOCOPY VARCHAR2,
588 x_assembly_quantity IN OUT NOCOPY NUMBER,
589 x_resource_quantity IN OUT NOCOPY NUMBER,
590 x_wip_operation_code IN OUT NOCOPY VARCHAR2,
591 x_bom_department_code IN OUT NOCOPY VARCHAR2,
592 x_active_encumb_amount IN OUT NOCOPY NUMBER,
593 x_distribution_amount IN OUT NOCOPY NUMBER);
594
595
596 /*===========================================================================
597 FUNCTION NAME: get_org_info
598
599 DESCRIPTION: This procedure is called in get_dist_info_pq
600 to get the organization names corresponding
601 to the ids
602 bug 1338674
603
604 CHANGE HISTORY: Created 19-JUL-00 dreddy
605 ===========================================================================*/
606 PROCEDURE get_org_info(x_destination_org_id IN number,
607 x_expenditure_org_id IN number,
608 x_ship_to_org_id IN number ,
609 x_dest_org_name IN OUT NOCOPY varchar2,
610 x_exp_org_name IN OUT NOCOPY varchar2,
611 x_ship_to_org_name IN OUT NOCOPY varchar2) ;
612
613
614 /*===========================================================================
615 FUNCTION NAME: get_location_info
616
617 DESCRIPTION: This procedure is called in get_dist_info_pq
618 to get the location names corresponding
619 to the ids - bug 1338674
620
621 CHANGE HISTORY: Created 19-JUL-00 dreddy
622 ===========================================================================*/
623 PROCEDURE get_location_info(x_deliver_to_loc_id IN number,
627 x_bill_to_loc_code IN OUT NOCOPY varchar2,
624 x_bill_to_loc_id IN number,
625 x_ship_to_loc_id IN number ,
626 x_dest_location_code IN OUT NOCOPY varchar2,
628 x_ship_to_loc_code IN OUT NOCOPY varchar2);
629
630
631 /*===========================================================================
632 FUNCTION NAME: get_project_info
633
634 DESCRIPTION: This procedure is called in get_dist_info_pq
635 to get the project/task numbers corresponding
636 to the ids - bug 1338674
637
638 CHANGE HISTORY: Created 19-JUL-00 dreddy
639 ===========================================================================*/
640 PROCEDURE get_project_info(x_project_id IN number,
641 x_task_id IN number,
642 x_project_num IN OUT NOCOPY varchar2,
643 x_task_num IN OUT NOCOPY varchar2);
644
645
646 /*===========================================================================
647 FUNCTION NAME: get_wip_bom_info
648
649 DESCRIPTION: This procedure is called in get_dist_info_pq
650 to get the wip/bom information - bug 1338674
651
652 CHANGE HISTORY: Created 19-JUL-00 dreddy
653 ===========================================================================*/
654 PROCEDURE get_wip_bom_info(x_wip_entity_id IN number,
655 x_wip_line_id IN number ,
656 x_bom_resource_id IN number ,
657 x_destination_org_id IN number,
658 x_wip_entity_name IN OUT NOCOPY varchar2,
659 x_wip_line_code IN OUT NOCOPY varchar2,
660 x_bom_resource_code IN OUT NOCOPY varchar2,
661 x_bom_uom IN OUT NOCOPY varchar2);
662
663
664 /*===========================================================================
665 FUNCTION NAME: get_vendor_info
666
667 DESCRIPTION: This procedure is called in get_dist_info_pq
668 to get the vendor/vendor_site names corresponding
669 to the ids - bug 1338674
670
671 CHANGE HISTORY: Created 19-JUL-00 dreddy
672 ===========================================================================*/
673 PROCEDURE get_vendor_info(x_vendor_id IN number,
674 x_vendor_site_id IN number ,
675 x_vendor_name IN OUT NOCOPY varchar2,
676 x_vendor_site_code IN OUT NOCOPY varchar2);
677
678
679 /*===========================================================================
680 FUNCTION NAME: get_ap_terms
681
682 DESCRIPTION: This procedure is called in get_dist_info_pq
683 to get the ap terms name corresponding
684 to the termsid - bug 1338674
685
686 CHANGE HISTORY: Created 19-JUL-00 dreddy
687 ===========================================================================*/
688 PROCEDURE get_ap_terms(x_terms_id IN number,
689 x_ap_terms_name IN OUT NOCOPY varchar2);
690
691
692 /*===========================================================================
693 FUNCTION NAME: get_dist_info_pq
694
695 DESCRIPTION: This procedure is called in post-query for
696 the distribution folder. The purpose
697 of this procedure is to reduce the round-trips to
698 the server in the post-query and to get the info
699 removed from the view for performance reasons.
700 bug 1338674
701
702 CHANGE HISTORY: Created 19-JUL-00 dreddy
703 ===========================================================================*/
704 PROCEDURE get_dist_info_pq (x_po_header_id IN number,
705 x_po_line_location_id IN number,
706 x_deliver_to_loc_id IN number,
707 x_bill_to_loc_id IN number,
708 x_destination_org_id IN number,
709 x_expenditure_org_id IN number,
710 x_vendor_id IN number,
711 x_vendor_site_id IN number,
712 x_project_id IN number,
713 x_task_id IN number,
714 x_bom_resource_id IN number,
715 x_wip_entity_id IN number,
716 x_wip_line_id IN number,
717 x_dest_location_code IN OUT NOCOPY varchar2,
718 x_bill_to_loc_code IN OUT NOCOPY varchar2,
719 x_ship_to_loc_code IN OUT NOCOPY varchar2,
720 x_dest_org_name IN OUT NOCOPY varchar2,
721 x_exp_org_name IN OUT NOCOPY varchar2,
722 x_ship_to_org_name IN OUT NOCOPY varchar2,
723 x_project_num IN OUT NOCOPY varchar2,
724 x_task_num IN OUT NOCOPY varchar2,
725 x_wip_entity_name IN OUT NOCOPY varchar2,
726 x_wip_line_code IN OUT NOCOPY varchar2,
727 x_bom_resource_code IN OUT NOCOPY varchar2,
728 x_bom_uom IN OUT NOCOPY varchar2,
729 x_ap_terms_name IN OUT NOCOPY varchar2,
730 x_vendor_name IN OUT NOCOPY varchar2,
734 x_ship_to_ou_coa_id OUT NOCOPY NUMBER,
731 x_vendor_site_code IN OUT NOCOPY varchar2,
732 --< Shared Proc FPJ Start >
733 x_purchasing_ou_coa_id OUT NOCOPY NUMBER,
735 --< Shared Proc FPJ End >
736 --< Bug 3266689 Start >
737 x_type_lookup_code IN varchar2
738 --< Bug 3266689 End >
739 ) ;
740
741 /*===========================================================================
742 togeorge 06/14/2001
743 Bug# 1733951
744 This procedure fetches the lookup values removed from the view
745 po_line_locations_inq_v as part of the performance fix.
746
747 PROCEDURE NAME: get_shipments_pq_lookups
748
749 ===========================================================================*/
750 PROCEDURE get_shipments_pq_lookups(x_enforce_ship_to_loc_code IN varchar2,
751 x_receipt_days_excpt_code IN varchar2,
752 x_qty_rcv_excpt_code IN varchar2,
753 x_closed_code IN varchar2,
754 x_shipment_type IN varchar2,
755 x_authorization_status IN varchar2,
756 x_fob_code IN varchar2,
757 x_freight_terms_code IN varchar2,
758 x_enforce_ship_to_loc_dsp IN OUT NOCOPY varchar2,
759 x_receipt_days_excpt_dsp IN OUT NOCOPY varchar2,
760 x_qty_rcv_excpt_dsp IN OUT NOCOPY varchar2,
761 x_closed_code_dsp IN OUT NOCOPY varchar2,
762 x_shipment_type_dsp IN OUT NOCOPY varchar2,
763 x_authorization_status_dsp IN OUT NOCOPY varchar2,
764 x_fob_code_dsp IN OUT NOCOPY varchar2,
765 x_freight_terms_code_dsp IN OUT NOCOPY varchar2,
766 p_match_option IN VARCHAR2,--Bug 2947251
767 x_match_option_dsp OUT NOCOPY VARCHAR2 --Bug 2947251
768 );
769
770 /*===========================================================================
771 togeorge 08/27/2001
772 Bug# 1870283
773 This procedure fetches the lookup values removed from the view
774 po_distributions_inq_v as part of the performance fix.
775
776 PROCEDURE NAME: get_dist_pq_lookups
777
778 ===========================================================================*/
779 PROCEDURE get_dist_pq_lookups(
780 x_destination_type_code IN varchar2,
781 x_authorization_status IN varchar2,
782 x_shipment_type IN varchar2,
783 x_closed_code IN varchar2,
784 x_destination_type IN OUT NOCOPY varchar2,
785 x_authorization_status_dsp IN OUT NOCOPY varchar2,
786 x_shipment_type_dsp IN OUT NOCOPY varchar2,
787 x_closed_code_dsp IN OUT NOCOPY varchar2);
788
789 /*===========================================================================
790 togeorge 08/31/2001
791 Bug# 1870283
792 This procedure fetches the lookup values removed from the view
793 po_lines_inq_v as part of the performance fix.
794
795 PROCEDURE NAME: get_lines_pq_lookups
796
797 ===========================================================================*/
798 PROCEDURE get_lines_pq_lookups(
799 x_price_type_lookup_code IN varchar2,
800 x_transaction_reason_code IN varchar2,
801 x_price_break_lookup_code IN varchar2,
802 x_closed_code IN varchar2,
803 x_authorization_status IN varchar2,
804 x_fob_code IN varchar2,
805 x_freight_terms_code IN varchar2,
806 x_price_type IN OUT NOCOPY varchar2,
807 x_transaction_reason IN OUT NOCOPY varchar2,
808 x_price_break IN OUT NOCOPY varchar2,
809 x_closed_code_dsp IN OUT NOCOPY varchar2,
810 x_authorization_status_dsp IN OUT NOCOPY varchar2,
811 x_fob_code_dsp IN OUT NOCOPY varchar2,
812 x_freight_terms_code_dsp IN OUT NOCOPY varchar2);
813
814 /*===========================================================================
815 togeorge 11/19/2001
816 Bug# 2038811
817 This procedure fetches the lookup values removed from the view
818 po_headers_inq_v as part of the performance fix.
819
820 PROCEDURE NAME: get_headers_pq_lookups
821
822 ===========================================================================*/
823 PROCEDURE get_headers_pq_lookups(
824 x_authorization_status IN varchar2,
825 x_fob_code IN varchar2,
826 x_freight_terms_code IN varchar2,
827 x_closed_code IN varchar2,
828 x_authorization_status_dsp IN OUT NOCOPY varchar2,
829 x_fob_code_dsp IN OUT NOCOPY varchar2,
830 x_freight_terms_code_dsp IN OUT NOCOPY varchar2,
831 x_closed_code_dsp IN OUT NOCOPY varchar2,
832 p_shipping_control IN VARCHAR2, -- <INBOUND LOGISTICS FPJ>
833 x_shipping_control_dsp IN OUT NOCOPY VARCHAR2 -- <INBOUND LOGISTICS FPJ>
834 );
835
836 /*===========================================================================
837
838 PROCEDURE: get_source_info <GA FPI>
839
840 DESCRIPTION: Gets all source document-related information based on a
841 po_header_id.
842
843 ===========================================================================*/
844 PROCEDURE get_source_info
845 (
846 p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
847 x_segment1 OUT NOCOPY PO_HEADERS_ALL.segment1%TYPE,
848 x_type_lookup_code OUT NOCOPY PO_HEADERS_ALL.type_lookup_code%TYPE,
849 x_global_agreement_flag OUT NOCOPY PO_HEADERS_ALL.global_agreement_flag%TYPE,
850 x_owning_org_id OUT NOCOPY PO_HEADERS_ALL.org_id%TYPE,
851 x_quote_vendor_quote_number OUT NOCOPY PO_HEADERS_ALL.quote_vendor_quote_number%TYPE
852 );
853
854 /*===========================================================================
855
856 FUNCTION: get_type_name <GA FPI>
857
858 DESCRIPTION: Given the 'document_type_code' and 'document_subtype',
859 the function will return the 'document_type_name' from
860 PO_DOCUMENTS_TYPES_VL.
861
862 ===========================================================================*/
863 FUNCTION get_type_name
864 (
865 p_document_type_code PO_DOCUMENT_TYPES_VL.document_type_code%TYPE ,
866 p_document_subtype PO_DOCUMENT_TYPES_VL.document_subtype%TYPE
867 )
868 RETURN PO_DOCUMENT_TYPES_VL.type_name%TYPE;
869
870
871 /*===========================================================================
872
873 PROCEDURE: get_rate_type
874
875 DESCRIPTION: Given the po_header_id this function will return user_conversion_rate
876
877
878 ===========================================================================*/
879
880 PROCEDURE get_rate_type
881 (x_header_id IN NUMBER,
882 x_rate_type OUT NOCOPY varchar2);
883
884
885 /* Bug 2788683 start */
886 /*===========================================================================
887
888 PROCEDURE: get_vendor_name
889
890 DESCRIPTION: Get vendor real name based on log in name
891
892 ===========================================================================*/
893 PROCEDURE get_vendor_name
894 ( l_user_name IN fnd_user.user_name%TYPE,
895 x_vendor_name OUT NOCOPY hz_parties.party_name%TYPE
896 );
897 /* Bug 2788683 end */
898
899 --<HTML Agreement R12 Start>
900 ---------------------------------------------------------------------------
901 --Start of Comments
902 --Name: get_party_vendor_name
903 --Pre-reqs:
904 -- None.
905 --Modifies:
906 -- None
907 --Locks:
908 -- None.
909 --Function:
910 -- Retrieves the party name + vendor name for acceptance entries entered
911 -- by suppliers. The result is in the form of "party name(vendor name)",
912 -- e.g. "Maxwell Olden(Office Supplies, Inc.)".
913 -- This function is refactored from POXPOEAC.pld
914 --Parameters:
915 --IN:
916 -- p_user_id: user_id of the supplier party
917 --Returns:
918 -- "party name(vendor name)" of the given user_id
919 --Testing:
920 --End of Comments
921 ---------------------------------------------------------------------------
922 FUNCTION get_party_vendor_name (p_user_id IN NUMBER)
923 RETURN VARCHAR2;
924
925 ---------------------------------------------------------------------------
926 --Start of Comments
927 --Name: get_vendor_eamil
928 --Pre-reqs:
929 -- None.
930 --Modifies:
931 -- None
932 --Locks:
933 -- None.
934 --Function:
935 -- Retrieves the vendor party email address for acceptance entries entered
936 -- by suppliers.
937 --Parameters:
938 --IN:
939 -- p_user_id: user_id of the supplier party
940 --Returns:
941 -- email address stored in HZ_PARTIES; if that is not available, return
942 -- email address stored in FND_USER
943 --Testing:
944 --End of Comments
945 ---------------------------------------------------------------------------
946 FUNCTION get_vendor_email (p_user_id IN NUMBER)
947 RETURN VARCHAR2;
948 --<HTML Agreement R12 End>
949
950 END PO_INQ_SV;
951
[Home] [Help]