1 PACKAGE OE_ORDER_PRICE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVOPRS.pls 120.1.12010000.1 2008/07/25 08:06:00 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_ORDER_PRICE_PVT';
9 G_SEEDED_PRICE_ERROR_HOLD_ID CONSTANT NUMBER := 50;
10
11 -- Pricing Integration Control Record is to communicate with Caller and Pricing Engine
12 -- It can be expanded without making change to the signature of Price_Line
13 Type Control_Rec_Type is Record
14 (p_Request_Type_Code VARCHAR2(3) DEFAULT 'ONT'
15 ,p_write_to_db BOOLEAN DEFAULT TRUE
16 ,p_honor_price_flag VARCHAR2(1) DEFAULT 'Y'
17 ,p_multiple_events VARCHAR2(1) DEFAULT 'N'
18 ,p_use_current_header BOOLEAN DEFAULT FALSE
19 ,p_calculate_flag VARCHAR2(30) DEFAULT 'Y'
20 ,p_simulation_flag VARCHAR2(1) DEFAULT 'N'
21 ,p_get_freight_flag VARCHAR2(1) DEFAULT 'N'
22 );
23
24 -- Price_Line is the main Pricing Integration API
25 -- It can be used to Price an order, an order line, or multiple lines
26 Procedure Price_line(
27 p_Header_id IN NUMBER DEFAULT NULL
28 ,p_Line_id IN NUMBER DEFAULT NULL
29 ,px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type
30 ,p_Control_Rec IN OE_ORDER_PRICE_PVT.control_rec_type
31 ,p_action_code IN VARCHAR2 DEFAULT 'NONE'
32 ,p_Pricing_Events IN VARCHAR2
33 --RT{
34 ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
35 --RT}
36 ,x_Return_Status OUT NOCOPY VARCHAR2
37 );
38
39 --bucket man
40 procedure copy_Line_to_request(
41 p_Line_rec OE_Order_PUB.Line_Rec_Type
42 ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
43 ,p_pricing_events varchar2
44 ,p_request_type_code varchar2
45 ,p_honor_price_flag varchar2
46 ,px_line_index in out NOCOPY NUMBER
47 );
48
49 procedure copy_Header_to_request(
50 p_header_rec OE_Order_PUB.Header_Rec_Type
51 ,px_req_line_tbl in out NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE
52 --,p_pricing_event varchar2
53 ,p_Request_Type_Code varchar2
54 ,p_calculate_price_flag varchar2
55 ,px_line_index in out NOCOPY NUMBER
56 );
57
58 procedure Populate_Temp_Table;
59
60 procedure Append_asked_for(
61 p_header_id number
62 ,p_Line_id number
63 ,p_line_index number
64 ,px_line_attr_index in out NOCOPY number
65 );
66
67 PROCEDURE Reset_All_Tbls;
68
69 end OE_ORDER_PRICE_PVT;