1 PACKAGE BODY PO_MGD_EURO_VENDOR_MEDIATOR AS
2 -- $Header: POXMVENB.pls 115.15 2002/11/23 03:27:27 sbull ship $
3 --+=======================================================================+
4 --| Copyright (c) 1999 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| POXMVENB.pls |
10 --| |
11 --| DESCRIPTION |
12 --| |
13 --| |
14 --| PROCEDURE LIST |
15 --| Create_Vendor_Mirror PRIVATE |
16 --| Create_Vendor_Site_Mirror PRIVATE |
17 --| Vendor_Conversion PUBLIC |
18 --| Sites_Conversion PUBLIC |
19 --| All_Vendor_Conversion PUBLIC |
20 --| |
21 --| |
22 --| HISTORY |
23 --| |
24 --| 26-Dec-1999 rajkrish Created |
25 --| 01-Feb-2000 rajkrish Updated |
26 --| 04/30/2001 tsimmond added procedure all_vendor_conversion |
27 --| 10/22/2001 vto bug 2048490, 2040015,indicate supplier |
28 --| already in EURO. |
29 --| 12/06/2001 tsimmond added check for org_id before sites |
30 --| conversion, R11.5 implementation of |
31 --| bug fix #2110056 for R11 |
32 --| 03/25/2002 tsimmond updated, code removed for patch 'H' remove |
33 --+======================================================================*/
34
35
36 --===================
37 -- PROCEDURES AND FUNCTIONS
38 --===================
39
40 --========================================================================
41 -- PROCEDURE : Vendor_Conversion PUBLIC
42 -- PARAMETERS: p_vendor_ID Vendor to be converted
43 -- p_update_DB_Flag Commit the Conversion
44 -- p_vendor_number Vendor Number for Report Gen
45 --
46 --
47 -- COMMENT : Main Logic to Process the Vendor Conversion
48 --
49 --=======================================================================
50 PROCEDURE Vendor_Conversion
51 ( p_vendor_id IN NUMBER
52 , p_update_db_flag IN VARCHAR2
53 )
54 IS
55 BEGIN
56
57 NULL;
58
59 END Vendor_Conversion;
60
61 --========================================================================
62 -- PROCEDURE : Sites_Conversion PUBLIC
63 -- PARAMETERS: p_vendor_id Vednor ID
64 -- p_vendor_site_id Specific Site to be Processed
65 -- p_site_conv_from_ncu NCU Sites to be Converted
66 -- p_conv_standard_po_flag Flag to indicate conversion of
67 -- Standard PO
68 -- p_conv_blanket_po_flag Flag to indicate conversion of
69 -- Blanket PO
70 -- p_conv_planned_po_flag Flag to indicate conversion of
71 -- Planned PO
72 -- p_conv_contract_po_flag Flag to indicate conversion of
73 -- Contract PO
74 -- p_po_conv_from_ncu Site NCU to be converted
75 -- p_update_db_flag Commit Flag
76 --
77 --
78 -- COMMENT : Main Logic to Process the Supplier Sites Conversion
79 --
80 --=======================================================================
81 PROCEDURE Sites_Conversion
82 ( p_vendor_id IN NUMBER
83 , p_vendor_site_id IN NUMBER
84 , p_site_conv_from_ncu IN VARCHAR2
85 , p_conv_standard_po_flag IN VARCHAR2 := 'N'
86 , p_conv_blanket_po_flag IN VARCHAR2 := 'N'
87 , p_conv_planned_po_flag IN VARCHAR2 := 'N'
88 , p_conv_contract_po_flag IN VARCHAR2 := 'N'
89 , p_po_conv_from_ncu IN VARCHAR2
90 , p_conv_partial IN VARCHAR2
91 , p_update_db_flag IN VARCHAR2 := 'N'
92 )
93 IS
94 BEGIN
95
96 NULL;
97
98 END Sites_Conversion;
99
100 --========================================================================
101 -- PROCEDURE : All_Vendor_Conversion PUBLIC
102 -- PARAMETERS: p_standard_po_flag Indicate if Standard PO needs to be converted
103 -- p_blanket_po_flag Indicate if Blanket PO needs to be converted
104 -- p_planned_po_flag Indicate if Planned PO needs to be converted
105 -- p_contract_po_flag Indicate if Contract PO needs to be converted
106 -- p_po_from_ncu NCU POs to be converted
107 -- p_convert_partial Indicates if partially transacted PO need
108 -- to be converted
109 --
110 -- COMMENT : Main Logic to Process the All Vendor Conversion
111 --
112 --=======================================================================
113 PROCEDURE All_Vendor_Conversion
114 ( p_standard_po_flag IN VARCHAR2 DEFAULT 'N'
115 , p_blanket_po_flag IN VARCHAR2 DEFAULT 'N'
116 , p_planned_po_flag IN VARCHAR2 DEFAULT 'N'
117 , p_contract_po_flag IN VARCHAR2 DEFAULT 'N'
118 , p_po_from_ncu IN VARCHAR2 DEFAULT NULL
119 , p_convert_partial IN VARCHAR2 DEFAULT 'N'
120 )
121 IS
122 BEGIN
123
124 NULL;
125
126 END All_Vendor_Conversion;
127
128 END PO_MGD_EURO_VENDOR_MEDIATOR;
129