[Home] [Help]
PACKAGE: APPS.QP_MGD_EURO_CUSTOMER_MEDIATOR
Source
1 PACKAGE QP_MGD_EURO_CUSTOMER_MEDIATOR AUTHID CURRENT_USER AS
2 -- $Header: QPXMCSTS.pls 120.0 2005/06/02 00:02:16 appldev noship $
3 ---+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| QPXMCSTS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Specification of QP_MGD_EURO_CUSTOMER_MEDIATOR |
13 --| |
14 --| HISTORY |
15 --| 03-May-2000 rajkrish Created |
16 --| 07-May-2001 tsimmond added procedure All_Customer_Conversion |
17 --+======================================================================
18
19
20 --===================
21 -- PROCEDURES AND FUNCTIONS
22 --===================
23
24 --========================================================================
25 -- PROCEDURE : Customer_Conversion PUBLIC
26 -- PARAMETERS: p_customer_id Customer id to be Converted
27 -- p_customer_number Customer number
28 -- p_default_euro_price_list_id Default Euro price list id.
29 -- p_update_existing_euro_pl Yes/No to update existing
30 -- price list.
31 --
32 -- COMMENT : Main Logic to Process the Customer Conversion
33 --
34 --=======================================================================
35 PROCEDURE Customer_Conversion
36 ( p_customer_id IN NUMBER
37 , p_customer_number IN VARCHAR2
38 , p_default_euro_price_list_id IN NUMBER
39 , p_update_existing_euro_pl IN VARCHAR2 := 'N'
40 );
41
42
43 --========================================================================
44 -- PROCEDURE : Sites_Conversion PUBLIC
45 -- PARAMETERS: p_customer_number Customer Number
46 -- p_customer_address_id Customer Address
47 -- p_site_conversion_ncu NCU Address Sites to be converted
48 -- p_convert_so_flag Convert Sales Order?
49 -- p_so_conversion_ncu NCU Sales Orders to be converted
50 -- p_convert_partial_ship_flag
51 -- p_update_db_flag commit the changes
52 --
53 -- COMMENT : Main Logic to Process the Sites Conversion
54 --
55 --=======================================================================
56 PROCEDURE Sites_Conversion
57 ( p_customer_id IN NUMBER
58 , p_customer_address_id IN NUMBER
59 , p_convert_so_flag IN VARCHAR2
60 , p_so_conversion_ncu IN VARCHAR2
61 , p_convert_partial_so IN VARCHAR2
62 , p_line_invoice_to_org_id IN NUMBER
63 , p_so_reprice_flag IN VARCHAR2
64 , p_default_euro_price_list_id IN NUMBER
65 , p_update_existing_euro_pl IN VARCHAR2 := 'N'
66 );
67
68
69 --========================================================================
70 -- PROCEDURE : ALL_Customer_Conversion PUBLIC
71 -- PARAMETERS:
72 -- p_default_euro_price_list_id Id of the default Euro price list
73 -- p_update_existing_euro_pl Yes/No to update existing price list
74 -- p_convert_so_flag Yes/No to convert Sales Orders
75 -- p_so_conversion_ncu NCU of the So to be converted
76 -- Default is ALL
77 -- p_convert_partial_so Yes/No to convert partially shipped SO
78 -- p_so_reprice_flag Yes/No to reprice all sales orders
79 --
80 -- COMMENT : Main Logic to Process the ALL Customer Conversion
81 --
82 --=======================================================================
83 PROCEDURE ALL_Customer_Conversion
84 ( p_default_euro_price_list_id IN NUMBER DEFAULT NULL
85 , p_convert_so_flag IN VARCHAR2 := 'N'
86 , p_so_conversion_ncu IN VARCHAR2 := NULL
87 , p_convert_partial_so IN VARCHAR2 := 'N'
88 , p_update_existing_euro_pl IN VARCHAR2 := 'N'
89 , p_so_reprice_flag IN VARCHAR2 := 'N'
90 );
91
92
93
94 END QP_MGD_EURO_CUSTOMER_MEDIATOR;
95