1 PACKAGE BODY ONT_MGD_EURO_OE_MEDIATOR AS
2 /* $Header: ONTMSOXB.pls 120.0 2005/06/01 01:09:43 appldev noship $ */
3
4 ---+=======================================================================+
5 --| Copyright (c) 2000 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+=======================================================================+
9 --| FILENAME |
10 --| ONTMSOXB.pls |
11 --| |
12 --| DESCRIPTION |
13 --| Package Body of Euro Sales Order Conversion |
14 --| |
15 --| HISTORY |
16 --| 10-Jul-2000 rajkrish Created
17 --| 06-Jan-2000 rajkrish Updated reprice flag
18 --| 06-Apr-2000 rajkrish convert new col, PATCH E
19 --| Jan-17-2002 4PM rajkrish BUG 2185432
20 --| Manufacturing Globalization Team
21 --| 03-APR-2002 tsimmond removed code |
22 --+======================================================================
23
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ONT_MGD_EURO_OE_MEDIATOR' ;
25
26
27 -- Global variable to hold the reason code if the
28 -- Order conversion fails. This code is used for the
29 -- Output report generation.
30
31 G_IGNORE_REASON VARCHAR2(100) := NULL ;
32 G_rate NUMBER;
33 G_HEADER_EURO_LIST_ID NUMBER;
34 G_HEADER_NCU_LIST_ID NUMBER;
35
36 TYPE EURO_LINE_REPORT_REC IS RECORD
37 ( order_number NUMBER
38 , line_id NUMBER
39 , Line_nu NUMBER
40 , action VARCHAR2(100)
41 , reason VARCHAR2(100)
42 );
43
44
45 TYPE EURO_LINE_REPORT_TABLE IS TABLE OF EURO_LINE_REPORT_REC
46 INDEX BY BINARY_INTEGER;
47
48 G_EURO_LINE_REPORT_TABLE EURO_LINE_REPORT_TABLE ;
49
50 --===========================
51 -- PROCEDURES AND FUNCTIONS
52 --===========================
53
54 --========================================================================
55 -- PROCEDURE : Convert_sales_orders
56
57 -- COMMENT : Main Logic to Convert the Sales Orders to Euro
58 -- This package converts the Open Sales Order to Euro
59 --=======================================================================
60 PROCEDURE Convert_sales_orders
61 ( p_customer_id IN NUMBER
62 , p_header_invoice_to_org_id IN NUMBER
63 , p_line_invoice_to_org_id IN NUMBER
64 , p_so_conversion_ncu IN VARCHAR2
65 , p_convert_partial_so IN VARCHAR2
66 , p_so_reprice_flag IN VARCHAR2
67 )
68 IS
69 BEGIN
70
71 NULL;
72 ---code is removed, since Euro Customer Conversion program
73 ---is decomissioned
74
75 END Convert_sales_orders;
76
77
78 END ONT_MGD_EURO_OE_MEDIATOR;
79