1 PACKAGE OZF_VOLUME_CALCULATION_PUB AUTHID CURRENT_USER AS
2 /* $Header: ozfpvocs.pls 120.11.12020000.2 2012/11/16 07:18:29 rsatyava ship $ */
3 /*
4 TYPE volume_detail_rec_type IS RECORD
5 (
6 offer_id NUMBER
7 ,qp_list_header_id NUMBER
8 ,distributor_acct_id NUMBER -- cust account id of distributor.
9 ,cust_account_id NUMBER
10 ,bill_to NUMBER -- bill to site use id
11 ,ship_to NUMBER -- ship to site use id
12 ,inventory_item_id NUMBER
13 ,quantity NUMBER
14 ,price NUMBER
15 ,uom_code VARCHAR2(3)
16 ,currency_code VARCHAR2(15)
17 ,transaction_date DATE
18 ,order_line_id NUMBER
19 );
20 TYPE volume_detail_tbl_type IS TABLE OF volume_detail_rec_type INDEX BY BINARY_INTEGER;
21 */
22
23 -- 10/15/2010 nirprasa fixed bug 9027785 - BENEFICIARY IS INCORRECT FOR RETURN ORDERS UNLESS THEY ARE REPRICED
24 -- 10/27/2011 kdass fixed bug 13256460 - ACCOUNT STATUS PAGE SHOWS DUPLICATE LINES OF ACCRUALS
25 -- 11/16/2012 rsatyava Fixed Bug 14516097 - ora-00060: deadlock detected when running tpa resale table request
26
27 FUNCTION get_numeric_attribute_value
28 (
29 p_list_line_id IN NUMBER
30 ,p_list_line_no IN VARCHAR2
31 ,p_order_header_id IN NUMBER
32 ,p_order_line_id IN NUMBER
33 ,p_price_effective_date IN DATE
34 ,p_req_line_attrs_tbl IN qp_runtime_source.accum_req_line_attrs_tbl
35 ,p_accum_rec IN qp_runtime_source.accum_record_type
36 )
37 RETURN NUMBER;
38
39
40 PROCEDURE get_volume -- overload version 1, used by OM
41 (
42 p_offer_id IN NUMBER
43 ,p_cust_acct_id IN NUMBER
44 ,p_bill_to IN NUMBER
45 ,p_ship_to IN NUMBER
46 ,p_group_no IN NUMBER
47 ,p_vol_track_type IN VARCHAR2
48 ,p_pbh_line_id IN NUMBER
49 ,p_combine_schedule IN VARCHAR2
50 ,x_acc_volume OUT NOCOPY NUMBER
51 );
52
53 /*
54 PROCEDURE get_volume -- overload version 2, used by IDSM
55 (
56 p_offer_id IN NUMBER
57 ,p_cust_acct_id IN NUMBER
58 ,p_bill_to IN NUMBER
59 ,p_ship_to IN NUMBER
60 ,p_distributor_acct_id IN NUMBER
61 ,p_group_no IN NUMBER
62 ,p_vol_track_type IN VARCHAR2
63 ,p_combine_schedule_yn IN VARCHAR2
64 ,p_pbh_line_id IN NUMBER
65 ,p_prod_attr IN VARCHAR2
66 ,p_attr_value IN VARCHAR2
67 ,p_trx_date IN DATE
68 ,x_acc_volume OUT NOCOPY NUMBER
69 );
70 */
71
72 PROCEDURE get_volume -- overload version 2, used by budget
73 (
74 p_init_msg_list IN VARCHAR2
75 ,p_api_version IN NUMBER
76 ,p_commit IN VARCHAR2
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2
80 ,p_qp_list_header_id IN NUMBER
81 ,p_order_line_id IN NUMBER
82 ,p_source_code IN VARCHAR2 -- O for OM, R for IS
83 ,p_trx_date IN DATE
84 ,x_acc_volume OUT NOCOPY NUMBER
85 );
86
87
88 PROCEDURE create_volume
89 (
90 p_init_msg_list IN VARCHAR2
91 ,p_api_version IN NUMBER
92 ,p_commit IN VARCHAR2
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type
97 ,p_qp_list_header_id IN NUMBER DEFAULT NULL
98 ,x_apply_discount OUT NOCOPY VARCHAR2
99 ,p_use_vol_smry_stg_tbl IN VARCHAR2 DEFAULT 'F'
100 ,p_resale_batch_id IN NUMBER DEFAULT NULL
101
102 );
103
104
105 FUNCTION get_beneficiary
106 (
107 p_offer_id IN NUMBER
108 ,p_order_line_id IN NUMBER
109 )
110 RETURN NUMBER;
111
112
113 PROCEDURE update_tracking_line
114 (
115 p_init_msg_list IN VARCHAR2
116 ,p_api_version IN NUMBER
117 ,p_commit IN VARCHAR2
118 ,x_return_status OUT NOCOPY VARCHAR2
119 ,x_msg_count OUT NOCOPY NUMBER
120 ,x_msg_data OUT NOCOPY VARCHAR2
121 ,p_list_header_id IN NUMBER
122 ,p_interface_line_id IN NUMBER
123 ,p_resale_line_id IN NUMBER
124 );
125 --------------------------
126 -- Used by Volume Tracking
127 -- Will return a value only if tracking by GROUP.
128 --------------------------
129 FUNCTION get_group_volume
130 (
131 p_offer_id IN NUMBER
132 ,p_group_number IN NUMBER
133 ,p_pbh_line_id IN NUMBER
134 )
135 RETURN NUMBER;
136
137 FUNCTION get_product_volume
138 (
139 p_offer_id IN NUMBER
140 ,p_pbh_line_id IN NUMBER
141 ,p_cust_account_id IN NUMBER
142 ,p_bill_to_id IN NUMBER
143 ,p_ship_to_id IN NUMBER
144 ,p_group_no IN NUMBER --kdass bug 13256460 - added p_group_no
145 )
146 RETURN NUMBER;
147
148 FUNCTION get_actual_tier
149 (
150 p_offer_id IN NUMBER
151 ,p_inventory_item_id IN NUMBER
152 ,p_pbh_line_id IN NUMBER
153 ,p_cust_account_id IN NUMBER
154 ,p_bill_to_id IN NUMBER
155 ,p_ship_to_id IN NUMBER
156 ,p_group_no IN NUMBER --kdass bug 13256460 - added p_group_no
157 )
158 RETURN VARCHAR2;
159
160 FUNCTION get_actual_discount
161 (
162 p_offer_id IN NUMBER
163 ,p_inventory_item_id IN NUMBER
164 ,p_pbh_line_id IN NUMBER
165 ,p_cust_account_id IN NUMBER
166 ,p_bill_to_id IN NUMBER
167 ,p_ship_to_id IN NUMBER
168 ,p_group_no IN NUMBER --kdass bug 13256460 - added p_group_no
169 )
170 RETURN VARCHAR2;
171
172
173 FUNCTION get_preset_tier
174 (
175 p_offer_id IN NUMBER
176 ,p_pbh_line_id IN NUMBER
177 ,p_group_no IN NUMBER
178 )
179 RETURN VARCHAR2;
180
181 FUNCTION get_preset_discount
182 (
183 p_offer_id IN NUMBER
184 ,p_pbh_line_id IN NUMBER
185 ,p_group_no IN NUMBER
186 )
187 RETURN VARCHAR2;
188
189 FUNCTION get_payout_accrual
190 (
191 p_offer_id IN NUMBER
192 ,p_item_id IN NUMBER
193 ,p_cust_account_id IN NUMBER
194 ,p_bill_to_id IN NUMBER
195 ,p_ship_to_id IN NUMBER
196 )
197 RETURN VARCHAR2;
198
199 FUNCTION get_approx_actual_accrual
200 (
201 p_offer_id IN NUMBER
202 ,p_pbh_line_id IN NUMBER
203 ,p_group_no IN NUMBER
204 ,p_item_id IN NUMBER
205 ,p_cust_account_id IN NUMBER
206 ,p_bill_to_id IN NUMBER
207 ,p_ship_to_id IN NUMBER
208 )
209 RETURN VARCHAR2;
210
211 --nirprasa, added function for bug 9027785
212 FUNCTION copy_order_group_details
213 ( p_from_order_line_id IN NUMBER
214 ,p_to_order_line_id IN NUMBER
215 )
216 RETURN NUMBER;
217
218 END OZF_VOLUME_CALCULATION_PUB;