1 PACKAGE OE_Blkt_Release_Util AS
2 /* $Header: OEXUBRLS.pls 120.1 2006/09/06 03:40:17 xding noship $ */
3
4 -- 11i10 Pricing Change
5 -- Move cached blanket header/line values to package spec
6 TYPE Blanket_Line_Rec_TYPE IS RECORD
7 (LINE_ID NUMBER
8 ,HEADER_ID NUMBER
9 ,OVERRIDE_BLANKET_CONTROLS_FLAG VARCHAR2(1)
10 ,OVERRIDE_RELEASE_CONTROLS_FLAG VARCHAR2(1)
11 ,RELEASED_AMOUNT NUMBER
12 ,RETURNED_AMOUNT NUMBER
13 ,MIN_RELEASE_AMOUNT NUMBER
14 ,MAX_RELEASE_AMOUNT NUMBER
15 ,BLANKET_LINE_MAX_AMOUNT NUMBER
16 ,BLANKET_MAX_QUANTITY NUMBER
17 ,RELEASED_QUANTITY NUMBER
18 ,FULFILLED_QUANTITY NUMBER
19 ,FULFILLED_AMOUNT NUMBER
20 ,MIN_RELEASE_QUANTITY NUMBER
21 ,MAX_RELEASE_QUANTITY NUMBER
22 ,UOM VARCHAR2(30)
23 ,RETURNED_QUANTITY NUMBER
24 -- 11i10 Pricing change, add new attributes to cache
25 -- old values sourced from this order against this blanket line
26 ,LOCKED_FLAG VARCHAR2(1)
27 );
28
29 TYPE Blanket_Line_Tbl_TYPE IS TABLE OF Blanket_Line_Rec_TYPE
30 INDEX BY BINARY_INTEGER;
31
32 TYPE Blanket_Header_Rec_TYPE IS RECORD
33 (OVERRIDE_AMOUNT_FLAG VARCHAR2(1)
34 ,RELEASED_AMOUNT NUMBER
35 ,RETURNED_AMOUNT NUMBER
36 ,FULFILLED_AMOUNT NUMBER
37 ,BLANKET_MAX_AMOUNT NUMBER
38 ,CURRENCY_CODE VARCHAR2(15) -- Bug 5511359
39 ,CONVERSION_TYPE_CODE VARCHAR2(30)
40 -- 11i10 Pricing change, add new attributes to cache
41 -- old values sourced from this order against this blanket header
42 ,LOCKED_FLAG VARCHAR2(1)
43 );
44
45 TYPE Blanket_Header_Tbl_TYPE IS TABLE OF Blanket_Header_Rec_TYPE
46 INDEX BY BINARY_INTEGER;
47
48 g_blkt_line_tbl Blanket_Line_Tbl_TYPE;
49 g_blkt_hdr_tbl Blanket_Header_Tbl_TYPE;
50
51 TYPE BL_Order_Val_Rec_TYPE IS RECORD
52 (ORDER_RELEASED_QUANTITY NUMBER
53 ,ORDER_RELEASED_AMOUNT NUMBER
54 );
55
56 TYPE BL_Order_Val_Tbl_TYPE IS TABLE OF BL_Order_Val_Rec_TYPE
57 INDEX BY BINARY_INTEGER;
58
59 TYPE BH_Order_Val_Rec_TYPE IS RECORD
60 (ORDER_RELEASED_AMOUNT NUMBER
61 );
62
63 TYPE BH_Order_Val_Tbl_TYPE IS TABLE OF BH_Order_Val_Rec_TYPE
64 INDEX BY BINARY_INTEGER;
65
66 g_bl_order_val_tbl BL_Order_Val_Tbl_TYPE;
67 g_bh_order_val_tbl BH_Order_Val_Tbl_TYPE;
68
69 FUNCTION Convert_Amount
70 (p_from_currency IN VARCHAR2
71 ,p_to_currency IN VARCHAR2
72 ,p_conversion_date IN DATE
73 ,p_conversion_type IN VARCHAR2
74 ,p_amount IN NUMBER
75 )
76 RETURN NUMBER;
77
78 PROCEDURE Process_Releases
79 (p_request_tbl IN OUT NOCOPY OE_ORDER_PUB.Request_Tbl_Type
80 ,x_return_status OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE Populate_Old_Values
84 (p_blanket_number IN NUMBER
85 ,p_blanket_line_number IN NUMBER
86 ,p_line_id IN NUMBER
87 ,p_old_quantity IN NUMBER DEFAULT NULL
88 ,p_old_unit_sp IN NUMBER DEFAULT NULL
89 ,p_header_id IN NUMBER DEFAULT NULL
90 );
91
92 PROCEDURE Cache_Order_Qty_Amt
93 (p_request_rec IN OUT NOCOPY OE_ORDER_PUB.Request_Rec_Type
94 ,x_return_status OUT NOCOPY VARCHAR2
95 );
96
97 END;