1 PACKAGE PO_MGD_EURO_CP AUTHID CURRENT_USER AS
2 -- $Header: POXCEURS.pls 115.7 2002/11/23 03:31:17 sbull ship $
3 /*+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| POXCEURS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Spec. of concurrent program package PO_MGD_EURO_CP. |
13 --| Supplier Conversion. |
14 --| |
15 --| HISTORY |
16 --| 12/02/1999 tsimmond Created |
17 --| 04/30/2001 tsimmond Added new public procedure |
18 --| Run_All_Vendor_Conversion |
19 --| 11/28/2001 tsimmond updated, added set verify off |
20 --+======================================================================*/
21
22
23 --========================================================================
24 -- PROCEDURE : Run_Vendor_Conversion PUBLIC
25 -- PARAMETERS: x_errbuf error buffer
26 -- x_retcode 0 success, 1 warning, 2 error
27 -- p_vend_id Supplier ID
28 -- p_vend_site_id Supplier Site ID
29 -- p_site_from_ncu NCU address sites to be converted
30 -- p_standard_po_flag Indicate if Standard PO needs to be converted
31 -- p_blanket_po_flag Indicate if Blanket PO needs to be converted
32 -- p_planned_po_flag Indicate if Planned PO needs to be converted
33 -- p_contract_po_flag Indicate if Contract PO needs to be converted
34 -- p_po_from_ncu NCU POs to be converted
35 -- p_convert_partial Indicates if partially transacted PO need to be converted
36 -- p_db_flag Indicate if database needs to be updated
37 --
38 -- COMMENT : This is the concurrent program for EURO conversion of
39 -- supplier and supplier sites,
40 -- Including different types of Purchase Orders.
41 --
42 --========================================================================
43 PROCEDURE Run_Vendor_Conversion
44 ( x_errbuf OUT NOCOPY VARCHAR2
45 , x_retcode OUT NOCOPY VARCHAR2
46 , p_vend_id IN NUMBER
47 , p_vend_site_id IN NUMBER DEFAULT NULL
48 , p_site_from_ncu IN VARCHAR2 DEFAULT NULL
49 , p_standard_po_flag IN VARCHAR2 DEFAULT 'N'
50 , p_blanket_po_flag IN VARCHAR2 DEFAULT 'N'
51 , p_planned_po_flag IN VARCHAR2 DEFAULT 'N'
52 , p_contract_po_flag IN VARCHAR2 DEFAULT 'N'
53 , p_po_from_ncu IN VARCHAR2 DEFAULT NULL
54 , p_convert_partial IN VARCHAR2 DEFAULT 'N'
55 , p_db_flag IN VARCHAR2 DEFAULT 'N'
56 );
57
58
59 --========================================================================
60 -- PROCEDURE : Run_All_Vendor_Conversion PUBLIC
61 -- PARAMETERS: x_errbuf error buffer
62 -- x_retcode 0 success, 1 warning, 2 error
63 -- p_st_po_flag Indicate if Standard PO needs to be converted
64 -- p_bl_po_flag Indicate if Blanket PO needs to be converted
65 -- p_pl_po_flag Indicate if Planned PO needs to be converted
66 -- p_ct_po_flag Indicate if Contract PO needs to be converted
67 -- p_po_from_cur NCU POs to be converted
68 -- p_convert_part Indicates if partially transacted PO need
69 -- to be converted
70 --
71 -- COMMENT : This is the concurrent program for EURO conversion of
72 -- ALL Suppliers and Suppliers sites,
73 -- including the Purchase Orders.
74 --
75 --========================================================================
76 PROCEDURE Run_All_Vendor_Conversion
77 ( x_retcode OUT NOCOPY VARCHAR2
78 , x_errbuf OUT NOCOPY VARCHAR2
79 , p_st_po_flag IN VARCHAR2 DEFAULT 'N'
80 , p_bl_po_flag IN VARCHAR2 DEFAULT 'N'
81 , p_pl_po_flag IN VARCHAR2 DEFAULT 'N'
82 , p_ct_po_flag IN VARCHAR2 DEFAULT 'N'
83 , p_po_from_cur IN VARCHAR2 DEFAULT NULL
84 , p_convert_part IN VARCHAR2 DEFAULT 'N'
85 );
86
87 END PO_MGD_EURO_CP;
88