1 PACKAGE OE_PRICE_ORDER_PVT AUTHID CURRENT_USER AS
2 /* $Header: ONTHPROS.pls 120.0.12010000.1 2008/07/25 08:10:12 appldev ship $ */
3
4 G_STMT_NO Varchar2(2000);
5
6 -- Global constant holding the package name
7
8 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_PRICE_ORDER_PVT';
9
10 TYPE Price_Att_Rec_Type IS RECORD
11 ( header_id number
12 , line_id number
13 , flex_title varchar2(60)
14 , pricing_context varchar2(30)
15 , pricing_attribute varchar2(30)
16 , pricing_attr_value varchar2(240)
17 , Override_Flag varchar2(1)
18 );
19
20 TYPE Price_Att_Tbl_Type is table of Price_Att_Rec_Type INDEX BY BINARY_INTEGER;
21
22 -- Price_Order is to simulate a OM pricing call to get the pricing information
23 -- It assumes the caller will pass all the information of the order to the call
24 -- For example,if your order has two lines and you only call with one line,
25 -- the call will price as if there is only one line
26 -- You can pass a line but not to reprice it by setting operation code to G_OPR_NONE
27 -- You can pass a line but freeze its price by setting calculate price flag to 'N'
28 -- This API assumes the following setting:
29 -- Request_Type_Code: 'ONT'
30 -- Write_To_DB: FALSE
31 -- Honor_Price_FLag: 'Y'
32 -- Calculate_flag: 'Y'
33 -- Simulation_Flag: 'Y'
34 -- Get_Freight_FLag: 'N'
35 Procedure Price_Order(
36 px_Header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
37 ,px_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
38 -- ,px_Line_Tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
39 ,px_Line_Adj_Tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type
40 ,p_Line_Price_Att_Tbl IN Price_Att_Tbl_Type
41 ,p_action_code IN VARCHAR2
42 ,p_Pricing_Events IN VARCHAR2
43 ,p_Simulation_Flag IN VARCHAR2
44 ,p_Get_Freight_Flag IN VARCHAR2
45 ,x_Return_Status OUT NOCOPY VARCHAR2
46 );
47
48 end OE_PRICE_ORDER_PVT;