1 PACKAGE OE_ORDER_IMPORT_SPECIFIC_PVT AS
2 /* $Header: OEXVIMSS.pls 120.1.12000000.1 2007/01/16 22:11:03 appldev ship $ */
3
4 -- Start of Comments
5 -- API name OE_ORDER_IMPORT_SPECIFIC_PVT
6 -- Type Private
7 -- Purpose Order Import Pre- and Post- Process_Order Processing
8 -- Function
9 -- Pre-reqs
10 -- Parameters
11 -- Version Current version = 1.0
12 -- Initial version = 1.0
13 -- Notes
14 -- End of Comments
15
16 G_PKG_NAME Varchar2(30) := 'OE_ORDER_IMPORT_SPECIFIC_PVT';
17 G_ONT_ADD_CUSTOMER Varchar2(1);
18 G_ONT_TRANSACTION_PROCESSING Varchar2(30);
19
20 -- Record structure for Add Customer processing
21
22 TYPE Customer_Rec_Type IS RECORD
23 ( Orig_Sys_Customer_Ref Varchar2(50)
24 , Orig_Ship_Address_Ref Varchar2(50)
25 , Orig_Bill_Address_Ref Varchar2(50)
26 , Orig_Deliver_Address_Ref Varchar2(50)
27 , Sold_to_Contact_Ref Varchar2(50)
28 , Ship_to_Contact_Ref Varchar2(50)
29 , Bill_to_Contact_Ref Varchar2(50)
30 , Deliver_to_Contact_Ref Varchar2(50));
31
32 TYPE Customer_Tbl_Type IS TABLE OF Customer_Rec_Type
33 INDEX BY BINARY_INTEGER;
34
35 PROCEDURE PRE_PROCESS(
36 p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
37 ,p_x_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
38 -- 1433292 Pricing Attribute
39 ,p_x_header_price_att_tbl IN OUT NOCOPY OE_Order_Pub.Header_Price_Att_Tbl_Type
40 ,p_x_header_adj_att_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Att_Tbl_Type
41 ,p_x_header_adj_assoc_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Assoc_Tbl_Type
42 ,p_x_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
43 ,p_x_header_payment_tbl IN OUT NOCOPY OE_Order_Pub.Header_Payment_Tbl_Type
44 ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
45 ,p_x_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
46 ,p_x_line_price_att_tbl IN OUT NOCOPY OE_Order_Pub.Line_Price_Att_Tbl_Type
47 ,p_x_line_adj_att_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Att_Tbl_Type
48 ,p_x_line_adj_assoc_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
49 ,p_x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
50 ,p_x_line_payment_tbl IN OUT NOCOPY OE_Order_Pub.Line_payment_Tbl_Type
51 ,p_x_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
52 ,p_x_reservation_tbl IN OUT NOCOPY OE_Order_Pub.Reservation_Tbl_Type
53 ,p_x_action_request_tbl IN OUT NOCOPY OE_Order_Pub.Request_Tbl_Type
54 --bsadri put back the action table
55 ,p_x_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
56 ,p_x_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
57 ,p_x_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
58 ,p_x_header_payment_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Payment_Val_Tbl_Type
59 ,p_x_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
60 ,p_x_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
61 ,p_x_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
62 ,p_x_line_payment_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Payment_Val_Tbl_Type
63 ,p_x_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
64 ,p_x_reservation_val_tbl IN OUT NOCOPY OE_Order_Pub.Reservation_Val_Tbl_Type
65 ,p_header_customer_rec IN Customer_Rec_Type
66 ,p_line_customer_tbl IN Customer_Tbl_Type
67
68 ,p_return_status OUT NOCOPY VARCHAR2
69
70 );
71
72
73 PROCEDURE POST_PROCESS(
74 p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
75 ,p_x_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
76 -- 1433292 Pricing Attributes
77 ,p_x_header_price_att_tbl IN OUT NOCOPY OE_Order_Pub.Header_Price_Att_Tbl_Type
78 ,p_x_header_adj_att_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Att_Tbl_Type
79 ,p_x_header_adj_assoc_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Assoc_Tbl_Type
80 ,p_x_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
81 ,p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
82 ,p_x_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
83 ,p_x_line_price_att_tbl IN OUT NOCOPY OE_Order_Pub.Line_Price_Att_Tbl_Type
84 ,p_x_line_adj_att_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Att_Tbl_Type
85 ,p_x_line_adj_assoc_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
86 ,p_x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
87 ,p_x_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
88
89 ,p_x_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
90 ,p_x_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
91 ,p_x_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
92 ,p_x_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
93 ,p_x_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
94 ,p_x_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
95 ,p_x_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
96
97 ,p_x_header_rec_old IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
98 ,p_x_header_adj_tbl_old IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
99 ,p_x_header_scredit_tbl_old IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
100 ,p_x_line_tbl_old IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
101 ,p_x_line_adj_tbl_old IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
102 ,p_x_line_price_att_tbl_old IN OUT NOCOPY OE_Order_Pub.Line_Price_Att_Tbl_Type
103 ,p_x_line_scredit_tbl_old IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
104 ,p_x_lot_serial_tbl_old IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
105
106 ,p_x_header_val_rec_old IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
107 ,p_x_header_adj_val_tbl_old IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
108 ,p_x_header_scredit_val_tbl_old IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
109 ,p_x_line_val_tbl_old IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
110 ,p_x_line_adj_val_tbl_old IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
111 ,p_x_line_scredit_val_tbl_old IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
112 ,p_x_lot_serial_val_tbl_old IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
113
114 ,p_x_reservation_tbl IN OUT NOCOPY OE_Order_Pub.Reservation_Tbl_Type
115 ,p_x_reservation_val_tbl IN OUT NOCOPY OE_Order_Pub.Reservation_Val_Tbl_Type
116
117 ,p_return_status OUT NOCOPY VARCHAR2
118
119 );
120
121 END OE_ORDER_IMPORT_SPECIFIC_PVT;