1 PACKAGE OE_Blkt_Release_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUBRLS.pls 120.2.12020000.1 2012/06/26 09:22:24 appldev ship $ */
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 (
34 HEADER_ID NUMBER
35 ,OVERRIDE_AMOUNT_FLAG VARCHAR2(1)
36 ,RELEASED_AMOUNT NUMBER
37 ,RETURNED_AMOUNT NUMBER
38 ,FULFILLED_AMOUNT NUMBER
39 ,BLANKET_MAX_AMOUNT NUMBER
40 ,CURRENCY_CODE VARCHAR2(15) -- Bug 5511359
41 ,CONVERSION_TYPE_CODE VARCHAR2(30)
42 -- 11i10 Pricing change, add new attributes to cache
43 -- old values sourced from this order against this blanket header
44 ,LOCKED_FLAG VARCHAR2(1)
45 );
46
47 TYPE Blanket_Header_Tbl_TYPE IS TABLE OF Blanket_Header_Rec_TYPE
48 INDEX BY BINARY_INTEGER;
49
50 g_blkt_line_tbl Blanket_Line_Tbl_TYPE;
51 g_blkt_hdr_tbl Blanket_Header_Tbl_TYPE;
52
53 TYPE BL_Order_Val_Rec_TYPE IS RECORD
54 (ORDER_RELEASED_QUANTITY NUMBER
55 ,ORDER_RELEASED_AMOUNT NUMBER
56 );
57
58 TYPE BL_Order_Val_Tbl_TYPE IS TABLE OF BL_Order_Val_Rec_TYPE
59 INDEX BY BINARY_INTEGER;
60
61 TYPE BH_Order_Val_Rec_TYPE IS RECORD
62 (ORDER_RELEASED_AMOUNT NUMBER
63 );
64
65 TYPE BH_Order_Val_Tbl_TYPE IS TABLE OF BH_Order_Val_Rec_TYPE
66 INDEX BY BINARY_INTEGER;
67
68 g_bl_order_val_tbl BL_Order_Val_Tbl_TYPE;
69 g_bh_order_val_tbl BH_Order_Val_Tbl_TYPE;
70
71 FUNCTION Convert_Amount
72 (p_from_currency IN VARCHAR2
73 ,p_to_currency IN VARCHAR2
74 ,p_conversion_date IN DATE
75 ,p_conversion_type IN VARCHAR2
76 ,p_amount IN NUMBER
77 )
78 RETURN NUMBER;
79
80 PROCEDURE Process_Releases
81 (p_request_tbl IN OUT NOCOPY OE_ORDER_PUB.Request_Tbl_Type
82 ,x_return_status OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE Populate_Old_Values
86 (p_blanket_number IN NUMBER
87 ,p_blanket_line_number IN NUMBER
88 ,p_line_id IN NUMBER
89 ,p_old_quantity IN NUMBER DEFAULT NULL
90 ,p_old_unit_sp IN NUMBER DEFAULT NULL
91 ,p_header_id IN NUMBER DEFAULT NULL
92 );
93
94 PROCEDURE Cache_Order_Qty_Amt
95 (p_request_rec IN OUT NOCOPY OE_ORDER_PUB.Request_Rec_Type
96 ,x_return_status OUT NOCOPY VARCHAR2
97 );
98
99 END;