1 PACKAGE QP_MGD_EURO_CP AS
2 /* $Header: QPXCEURS.pls 120.1 2005/06/09 23:03:56 appldev $ */
3
4 ---+=======================================================================+
5 --| Copyright (c) 2000 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+=======================================================================+
9 --| FILENAME |
10 --| QPXCEURS.pls |
11 --| |
12 --| DESCRIPTION |
13 --| Spec. of concurrent program package QP_MGD_EURO_CP |
14 --| |
15 --| HISTORY |
16 --| 01-May-2000 rajkrish Created |
17 --| 04-May-2001 tsimmond Added new procedure Run_Euro_All_Customer_ |
18 --| Conversion |
19 --| |
20 --+======================================================================
21
22
23 --========================================================================
24 -- PROCEDURE : Run_Euro_Customer_Conversion PUBLIC
25 -- PARAMETERS:
26 -- x_retcode OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 -- x_errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 -- p_customer_id Customer being converted
29 -- p_customer_address_id Customer Site Address
30 -- p_convert_so_flag Flag to indicate of SO needs to be converted
31 -- p_line_invoice_to_org_id Bill to site of the Order Lines
32 -- p_so_conversion_ncu NCU of the So to be converted
33 -- Default is ALL
34 -- p_convert_partial_so Indicate to convert partially transacted SO
35 -- p_so_reprice_flag Reprice flag for the new Euro Order
36 -- NULL will take the original value
37 --
38 -- COMMENT : This is the concurrent program for EURO conversion of
39 -- customer and customer sites,
40 -- Including the Sales Orders.
41 --
42 --========================================================================
43 PROCEDURE Run_Euro_Customer_Conversion
44 ( x_retcode OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , p_customer_id IN NUMBER
47 , p_customer_address_id IN NUMBER
48 , p_convert_so_flag IN VARCHAR2
49 , p_line_invoice_to_org_id IN NUMBER
50 , p_so_conversion_ncu IN VARCHAR2
51 , p_convert_partial_so IN VARCHAR2
52 , p_so_reprice_flag IN VARCHAR2
53 ) ;
54
55
56 --========================================================================
57 -- PROCEDURE : Run_All_Customer_Conversion PUBLIC
58 -- PARAMETERS:
59 -- x_retcode OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 -- x_errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61 -- p_default_euro_price_list_id Id of the default Euro price list
62 -- p_update_existing_euro_pl Yes/No to update existing price list
63 -- p_convert_so_flag Yes/No to convert Sales Orders
64 -- p_so_conversion_ncu NCU of the So to be converted
65 -- Default is ALL
66 -- p_convert_partial_so Yes/No to convert partially shipped SO
67 -- p_so_reprice_flag Yes/No to reprice all sales orders
68 --
69 -- COMMENT : This is the concurrent program for EURO conversion of
70 -- all customers and customer sites, including the Sales Orders
71 -- in one operation.
72 --
73 --========================================================================
74 PROCEDURE Run_All_Customer_Conversion
75 ( x_retcode OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 , x_errbuf OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 , p_default_euro_price_list_id IN NUMBER
78 , p_update_existing_euro_pl IN VARCHAR2
79 , p_convert_so_flag IN VARCHAR2
80 , p_so_conversion_ncu IN VARCHAR2
81 , p_convert_partial_so IN VARCHAR2
82 , p_so_reprice_flag IN VARCHAR2
83 ) ;
84
85
86 END QP_MGD_EURO_CP;
87