[Home] [Help]
PACKAGE: APPS.OZF_ADJUSTMENT_EXT_PVT
Source
1 PACKAGE ozf_adjustment_ext_pvt AUTHID CURRENT_USER AS
2 /*$Header: ozfvades.pls 120.6.12020000.3 2013/02/14 12:30:15 nepanda ship $*/
3 TYPE LINE_REC_TYPE is RECORD
4 (
5 LINE_INDEX NUMBER,
6 INVENTORY_ITEM_ID NUMBER,
7 LINE_ID NUMBER,
8 HEADER_ID NUMBER,
9 ORG_ID NUMBER,
10 LINE_TYPE_CODE VARCHAR2(30),
11 PRICING_EFFECTIVE_DATE DATE,
12 ACTIVE_DATE_FIRST DATE,
13 ACTIVE_DATE_FIRST_TYPE VARCHAR2(30),
14 ACTIVE_DATE_SECOND DATE,
15 ACTIVE_DATE_SECOND_TYPE VARCHAR2(30),
16 LINE_QUANTITY NUMBER,
17 LINE_UOM_CODE VARCHAR2(30),
18 SHIPPED_QUANTITY NUMBER,
19 SHIPPING_QUANTITY_UOM VARCHAR2(30),
20 -- Catch Weight ER
21 SHIPPING_QUANTITY NUMBER,
22 SHIPPING_QUANTITY_UOM2 VARCHAR2(30),
23 SHIPPING_QUANTITY2 NUMBER,
24 FULFILLMENT_BASE oe_order_lines_all.fulfillment_base%TYPE,
25 -- Catch Weight ER
26 REQUEST_TYPE_CODE VARCHAR2(30),
27 PRICED_QUANTITY NUMBER,
28 PRICED_UOM_CODE VARCHAR2(30),
29 CURRENCY_CODE VARCHAR2(30),
30 TRANSACTIONAL_CURR_CODE oe_order_headers_all.transactional_curr_code%TYPE,
31 ORDER_NUMBER oe_order_headers_all.order_number%TYPE,
32 LINE_CATEGORY_CODE oe_order_lines_all.line_category_code%TYPE,
33 REFERENCE_LINE_ID NUMBER,
34 UNIT_PRICE NUMBER,
35 SELLING_PRICE NUMBER,
36 PERCENT_PRICE NUMBER,
37 UOM_QUANTITY NUMBER,
38 INVOICED_QUANTITY NUMBER,
39 ADJUSTED_UNIT_PRICE NUMBER,
40 UPD_ADJUSTED_UNIT_PRICE NUMBER,
41 PROCESSED_FLAG VARCHAR2(1),
42 PRICE_FLAG VARCHAR2(1),
43 PROCESSING_ORDER NUMBER,
44 PRICING_STATUS_CODE VARCHAR2(30),
45 PRICING_STATUS_TEXT VARCHAR2(2000),
46 ROUNDING_FLAG VARCHAR2(1),
47 ROUNDING_FACTOR NUMBER,
48 QUALIFIERS_EXIST_FLAG VARCHAR2(1),
49 PRICING_ATTRS_EXIST_FLAG VARCHAR2(1),
50 PRICE_LIST_ID NUMBER,
51 PL_VALIDATED_FLAG VARCHAR2(1),
52 PRICE_REQUEST_CODE VARCHAR2(240),
53 USAGE_PRICING_TYPE VARCHAR2(30),
54 LINE_CATEGORY VARCHAR2(30) ,
55 SHIP_TO_ORG_ID NUMBER,
56 SOLD_TO_ORG_ID NUMBER,
57 INVOICE_TO_ORG_ID NUMBER,
58 INVOICE_INTERFACE_STATUS_CODE oe_order_lines_all.invoice_interface_status_code%TYPE,
59 FLOW_STATUS_CODE oe_order_lines_all.flow_status_code%TYPE,
60 ACTUAL_SHIPMENT_DATE oe_order_lines_all.actual_shipment_date%TYPE
61 );
62
63
64
65 TYPE LINE_REC_TBL_TYPE is table of LINE_REC_TYPE index by binary_integer;
66 TYPE LDETS_TBL_TYPE is table of qp_ldets_v%rowtype index by binary_integer;
67 TYPE numberTbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
68 ---------------------------------------------------------------------
69 -- PROCEDURE
70 --
71 --
72 -- PURPOSE
73 --
74 -- PARAMETERS
75 -- x_errbuf OUT NOCOPY VARCHAR2 STANDARD OUT NOCOPY PARAMETER
76 -- x_retcode OUT NOCOPY NUMBER STANDARD OUT NOCOPY PARAMETER
77 -- NOTES
78 -- HISTORY
79 -- 4/18/2002 Mumu Pande Create.
80 ----------------------------------------------------------------------
81 PROCEDURE adjust_backdated_offer(
82 x_errbuf OUT NOCOPY VARCHAR2
83 ,x_retcode OUT NOCOPY NUMBER
84 ,p_debug IN VARCHAR2 := 'N' );
85 ---------------------------------------------------------------------
86 -- PROCEDURE
87 --
88 --
89 -- PURPOSE
90 --
91 -- PARAMETERS
92 -- x_errbuf OUT NOCOPY VARCHAR2 STANDARD OUT NOCOPY PARAMETER
93 -- x_retcode OUT NOCOPY NUMBER STANDARD OUT NOCOPY PARAMETER
94 -- NOTES
95 -- HISTORY
96 -- 7/30/2002 Mumu Pande Create.
97 ----------------------------------------------------------------------
98 PROCEDURE adjust_volume_offer(
99 x_errbuf OUT NOCOPY VARCHAR2
100 ,x_retcode OUT NOCOPY NUMBER
101 ,p_debug IN VARCHAR2 := 'N' );
102 ---------------------------------------------------------------------
103 -- FUNCTION
104 -- get_order_amount_quantity
105 --
106 -- PURPOSE
107 --
108 -- PARAMETERS
109 -- p_list_header_id IN NUMBER,
110 -- x_order_amount OUT NOCOPY NUMBER,
111 -- x_new_discount OUT NOCOPY NUMBER,
112 -- x_new_operator OUT NOCOPY VARCHAR2,
113 -- x_old_discount OUT NOCOPY NUMBER,
114 -- x_old_operator OUT NOCOPY VARCHAR2,
115 -- x_return_status OUT NOCOPY VARCHAR2
116 -- NOTES
117 -- HISTORY
118 -- 8/6/2002 Mumu Pande Create.
119 ----------------------------------------------------------------------
120
121 FUNCTION get_order_amount_quantity( p_list_header_id IN NUMBER,
122 x_order_amount_quantity OUT NOCOPY NUMBER,
123 x_new_discount OUT NOCOPY NUMBER,
124 x_new_operator OUT NOCOPY VARCHAR2,
125 x_old_discount OUT NOCOPY NUMBER,
126 x_old_operator OUT NOCOPY VARCHAR2,
127 x_volume_type OUT NOCOPY VARCHAR2,
128 x_return_status OUT NOCOPY VARCHAR2
129 ) RETURN NUMBER;
130 ---------------------------------------------------------------------
131 -- FUNCTION
132 -- get_order_amount_quantity
133 --
134 -- PURPOSE -- Called from Offers UI
135 --
136 -- PARAMETERS
137 -- p_list_header_id IN NUMBER,
138 -- x_order_amount OUT NOCOPY NUMBER,
139 -- NOTES
140 -- HISTORY
141 -- 10/18/2002 Mumu Pande Create.
142 ----------------------------------------------------------------------
143
144 FUNCTION get_order_amount_quantity(
145 p_list_header_id IN NUMBER
146 ) RETURN NUMBER;
147
148
149
150 ---------------------------------------------------------------------
151 -- PROCEDURE
152 -- volume_offer_adjustment
153 --
154 -- PURPOSE
155 -- adjustment for volume offer. it is called when
156 -- 1. run volume offer adjutment from accrual engine.
157 -- 2. run backdated adjustment for volume offer.
158
159 -- PARAMETERS
160 -- p_qp_list_header_id IN NUMBER
161 -- p_offer_adjustment_id IN NUMBER,
162 -- p_retroactive IN VARCHAR2,
163 -- p_vol_off_type IN VARCHAR2
164
165 -- NOTES
166 -- HISTORY
167 -- 6/10/2005 feliu Create.
168
169 ----------------------------------------------------------------------
170
171 PROCEDURE volume_offer_adjustment (
172 p_qp_list_header_id IN NUMBER,
173 p_vol_off_type IN VARCHAR2,
174 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175 p_commit IN VARCHAR2 := fnd_api.g_false,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2
179 );
180
181 PROCEDURE volume_offer_util_adjustment(
182 p_qp_list_header_id IN NUMBER,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2
186 );
187
188 PROCEDURE Process_VO_Result(
189 p_line_rec IN OZF_Adjustment_ext_PVT.LINE_REC_TYPE,
190 p_ldets_rec IN qp_ldets_v%rowtype,
191 p_adjIdByListHdrId IN OUT NOCOPY numberTbl,
192 p_vol_off_type IN VARCHAR2,
193 x_return_status OUT NOCOPY VARCHAR2
194 );
195 -- 13579540 added p_adjIdByListHdrId for exception handling
196 PROCEDURE Process_SSD_Result(
197 p_line_rec IN OZF_Adjustment_ext_PVT.LINE_REC_TYPE,
198 p_ldets_rec IN qp_ldets_v%rowtype,
199 p_adjIdByListHdrId IN OUT NOCOPY numberTbl,
200 x_return_status OUT NOCOPY VARCHAR2
201 );
202
203 PROCEDURE Process_Result(
204 p_line_rec IN OZF_Adjustment_ext_PVT.LINE_REC_TYPE,
205 p_ldets_rec IN qp_ldets_v%rowtype,
206 p_adjIdByListHdrId IN OUT NOCOPY numberTbl,
207 x_return_status OUT NOCOPY VARCHAR2
208 );
209
210 PROCEDURE Process_Pricing_Result(
211 p_header_id IN NUMBER,
212 p_line_tbl IN OZF_Adjustment_ext_PVT.LINE_REC_TBL_TYPE,
213 p_adjIdByListHdrId IN OUT NOCOPY numberTbl,
214 x_return_status OUT NOCOPY VARCHAR2
215 );
216
217 END ozf_adjustment_ext_pvt;
218