1 PACKAGE PO_MGD_EURO_VENDOR_MEDIATOR AUTHID CURRENT_USER AS
2 -- $Header: POXMVENS.pls 115.8 2002/11/23 03:24:33 sbull ship $
3 /*+=======================================================================+
4 --| Copyright (c) 1999 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| POXMVENS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Specification of PO_MGD_EURO_VENDOR_MEDIATOR |
13 --| |
14 --| HISTORY |
15 --| 12/26/1999 rajkrish Created |
16 --| 01/Feb/2000 tsimmond updated |
17 --| 04/30/2001 tsimmond added procedure all_vendor_conversion |
18 --+======================================================================*/
19
20
21 --===================
22 -- PROCEDURES AND FUNCTIONS
23 --===================
24
25 --========================================================================
26 -- PROCEDURE : Vendor_Conversion PUBLIC
27 -- PARAMETERS: p_vendor_ID Vendor to be converted
28 -- p_update_DB_Flag Commit the Conversion
29 -- p_vendor_number Vendor Number for Report Gen
30 --
31 --
32 -- COMMENT : Main Logic to Process the Vendor Conversion
33 --
34 --=======================================================================
35 PROCEDURE Vendor_Conversion
36 ( p_vendor_id IN NUMBER
37 , p_update_db_flag IN VARCHAR2
38 );
39
40 --========================================================================
41 -- PROCEDURE : Sites_Conversion PUBLIC
42 -- PARAMETERS: p_vendor_id Vednor ID
43 -- p_vendor_site_id Specific Site to be Processed
44 -- p_site_conv_from_ncu NCU Sites to be Converted
45 -- p_conv_standard_po_flag Flag to indicate conversion of
46 -- Standard PO
47 -- p_conv_blanket_po_flag Flag to indicate conversion of
48 -- Blanket PO
49 -- p_conv_planned_po_flag Flag to indicate conversion of
50 -- Planned PO
51 -- p_conv_contract_po_flag Flag to indicate conversion of
52 -- Contract PO
53 -- p_po_conv_from_ncu Site NCU to be converted
54 -- p_update_db_flag Commit Flag
55 --
56 --
57 -- COMMENT : Main Logic to Process the Supplier Sites Conversion
58 --
59 --=======================================================================
60 PROCEDURE Sites_Conversion
61 ( p_vendor_id IN NUMBER
62 , p_vendor_site_id IN NUMBER
63 , p_site_conv_from_ncu IN VARCHAR2
64 , p_conv_standard_po_flag IN VARCHAR2 := 'N'
65 , p_conv_blanket_po_flag IN VARCHAR2 := 'N'
66 , p_conv_planned_po_flag IN VARCHAR2 := 'N'
67 , p_conv_contract_po_flag IN VARCHAR2 := 'N'
68 , p_po_conv_from_ncu IN VARCHAR2
69 , p_conv_partial IN VARCHAR2
70 , p_update_db_flag IN VARCHAR2 := 'N'
71 );
72
73
74 --========================================================================
75 -- PROCEDURE : All_Vendor_Conversion PUBLIC
76 -- PARAMETERS: p_standard_po_flag Indicate if Standard PO needs to be converted
77 -- p_blanket_po_flag Indicate if Blanket PO needs to be converted
78 -- p_planned_po_flag Indicate if Planned PO needs to be converted
79 -- p_contract_po_flag Indicate if Contract PO needs to be converted
80 -- p_po_from_ncu NCU POs to be converted
81 -- p_convert_partial Indicates if partially transacted PO need
82 -- to be converted
83 --
84 -- COMMENT : Main Logic to Process the All Vendor Conversion
85 --
86 --=======================================================================
87 PROCEDURE All_Vendor_Conversion
88 ( p_standard_po_flag IN VARCHAR2 DEFAULT 'N'
89 , p_blanket_po_flag IN VARCHAR2 DEFAULT 'N'
90 , p_planned_po_flag IN VARCHAR2 DEFAULT 'N'
91 , p_contract_po_flag IN VARCHAR2 DEFAULT 'N'
92 , p_po_from_ncu IN VARCHAR2 DEFAULT NULL
93 , p_convert_partial IN VARCHAR2 DEFAULT 'N'
94 );
95
96
97 END PO_MGD_EURO_VENDOR_MEDIATOR;
98