[Home] [Help]
PACKAGE BODY: APPS.QP_MGD_EURO_CUSTOMER_MEDIATOR
Source
1 PACKAGE BODY QP_MGD_EURO_CUSTOMER_MEDIATOR AS
2 -- $Header: QPXMCSTB.pls 120.0 2005/06/02 00:57:13 appldev noship $
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| QPXMCSTB.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Package Body for the Customer/Site Conversion |
13 --| |
14 --| PROCEDURE LIST |
15 --| Customer_Conversion PUBLIC |
16 --| Sites_Conversion PUBLIC |
17 --| All_Customer_Conversion PUBLIC |
18 --| Validate_customer PRIVATE |
19 --| HISTORY |
20 --| 01-May-2000 Created |
21 --| 17-Aug-2000 Updated |
22 --| 07-May-2001 tsimmond added procedure All_Customer_Conversion |
23 --| 04-Jun-2001 tsimmond added procedure Validate_Customer |
24 --| Jan-14-2002 BUG 2181515 |
25 --| 03-APR-2002 tsimmond removed code |
26 --+========================================================================
27
28 --===================
29 -- GLOBALS
30 --===================
31
32 G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_MGD_EURO_CUSTOMER_MEDIATOR';
33
34 --===================
35 -- PROCEDURES AND FUNCTIONS
36 --===================
37
38 --========================================================================
39 -- PROCEDURE : Customer_Conversion PUBLIC
40 -- PARAMETERS: p_customer_id Customer id to be Converted
41 -- p_customer_number Customer number
42 -- p_default_euro_price_list_id Default Euro price list id.
43 -- p_update_existing_euro_pl Yes/No to update existing
44 -- price list.
45 --
46 -- COMMENT : Main Logic to Process the Customer Conversion
47 --
48 --=======================================================================
49 PROCEDURE Customer_Conversion
50 ( p_customer_id IN NUMBER
51 , p_customer_number IN VARCHAR2
52 , p_default_euro_price_list_id IN NUMBER
53 , p_update_existing_euro_pl IN VARCHAR2 := 'N'
54 )
55 IS
56 BEGIN
57
58 NULL;
59 ---code is removed, since Euro Customer Conversion program
60 ---is decomissioned
61
62 END Customer_Conversion;
63
64 --========================================================================
65 -- PROCEDURE : Sites_Conversion PUBLIC
66 -- PARAMETERS: p_customer_number Customer Number
67 -- p_customer_address_id Customer Address
68 -- p_site_conversion_ncu NCU Address Sites to be converted
69 -- p_convert_so_flag Convert Sales Order?
70 -- p_so_conversion_ncu NCU Sales Orders to be converted
71 -- p_convert_partial_ship_flag
72 -- p_update_db_flag commit the changes
73 --
74 -- COMMENT : Main Logic to Process the Sites Conversion
75 --
76 --=======================================================================
77 PROCEDURE Sites_Conversion
78 ( p_customer_id IN NUMBER
79 , p_customer_address_id IN NUMBER
80 , p_convert_so_flag IN VARCHAR2
81 , p_so_conversion_ncu IN VARCHAR2
82 , p_convert_partial_so IN VARCHAR2
83 , p_line_invoice_to_org_id IN NUMBER
84 , p_so_reprice_flag IN VARCHAR2
85 , p_default_euro_price_list_id IN NUMBER
86 , p_update_existing_euro_pl IN VARCHAR2 := 'N'
87 )
88 IS
89 BEGIN
90
91 NULL;
92 ---code is removed, since Euro Customer Conversion program
93 ---is decomissioned
94
95 END Sites_Conversion;
96
97
98 --========================================================================
99 -- PROCEDURE : ALL_Customer_Conversion PUBLIC
100 -- PARAMETERS:
101 -- p_default_euro_price_list_id Id of the default Euro price list
102 -- p_update_existing_euro_pl Yes/No to update existing price list
103 -- p_convert_so_flag Yes/No to convert Sales Orders
104 -- p_so_conversion_ncu NCU of the So to be converted
105 -- Default is ALL
106 -- p_convert_partial_so Yes/No to convert partially shipped SO
107 -- p_so_reprice_flag Yes/No to reprice all sales orders
108 --
109 -- COMMENT : Main Logic to Process the ALL Customer Conversion
110 --
111 --=======================================================================
112 PROCEDURE ALL_Customer_Conversion
113 ( p_default_euro_price_list_id IN NUMBER DEFAULT NULL
114 , p_convert_so_flag IN VARCHAR2 := 'N'
115 , p_so_conversion_ncu IN VARCHAR2 := NULL
116 , p_convert_partial_so IN VARCHAR2 := 'N'
117 , p_update_existing_euro_pl IN VARCHAR2 := 'N'
118 , p_so_reprice_flag IN VARCHAR2 := 'N'
119 )
120 IS
121 BEGIN
122
123 NULL;
124 ---code is removed, since Euro Customer Conversion program
125 ---is decomissioned
126
127 END ALL_Customer_Conversion;
128
129
130
131 END QP_MGD_EURO_CUSTOMER_MEDIATOR;
132