1 PACKAGE OZF_VOLUME_CALCULATION_PUB AS
2 /* $Header: ozfpvocs.pls 120.7 2006/09/08 00:37:41 julou noship $ */
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 FUNCTION get_numeric_attribute_value
24 (
25 p_list_line_id IN NUMBER
26 ,p_list_line_no IN VARCHAR2
27 ,p_order_header_id IN NUMBER
28 ,p_order_line_id IN NUMBER
29 ,p_price_effective_date IN DATE
30 ,p_req_line_attrs_tbl IN qp_runtime_source.accum_req_line_attrs_tbl
31 ,p_accum_rec IN qp_runtime_source.accum_record_type
32 )
33 RETURN NUMBER;
34
35
36 PROCEDURE get_volume -- overload version 1, used by OM
37 (
38 p_offer_id IN NUMBER
39 ,p_cust_acct_id IN NUMBER
40 ,p_bill_to IN NUMBER
41 ,p_ship_to IN NUMBER
42 ,p_group_no IN NUMBER
43 ,p_vol_track_type IN VARCHAR2
44 ,p_pbh_line_id IN NUMBER
45 ,p_combine_schedule IN VARCHAR2
46 ,x_acc_volume OUT NOCOPY NUMBER
47 );
48
49 /*
50 PROCEDURE get_volume -- overload version 2, used by IDSM
51 (
52 p_offer_id IN NUMBER
53 ,p_cust_acct_id IN NUMBER
54 ,p_bill_to IN NUMBER
55 ,p_ship_to IN NUMBER
56 ,p_distributor_acct_id IN NUMBER
57 ,p_group_no IN NUMBER
58 ,p_vol_track_type IN VARCHAR2
59 ,p_combine_schedule_yn IN VARCHAR2
60 ,p_pbh_line_id IN NUMBER
61 ,p_prod_attr IN VARCHAR2
62 ,p_attr_value IN VARCHAR2
63 ,p_trx_date IN DATE
64 ,x_acc_volume OUT NOCOPY NUMBER
65 );
66 */
67
68 PROCEDURE get_volume -- overload version 2, used by budget
69 (
70 p_init_msg_list IN VARCHAR2
71 ,p_api_version IN NUMBER
72 ,p_commit IN VARCHAR2
73 ,x_return_status OUT NOCOPY VARCHAR2
74 ,x_msg_count OUT NOCOPY NUMBER
75 ,x_msg_data OUT NOCOPY VARCHAR2
76 ,p_qp_list_header_id IN NUMBER
77 ,p_order_line_id IN NUMBER
78 ,p_source_code IN VARCHAR2 -- O for OM, R for IS
79 ,p_trx_date IN DATE
80 ,x_acc_volume OUT NOCOPY NUMBER
81 );
82
83
84 PROCEDURE create_volume
85 (
86 p_init_msg_list IN VARCHAR2
87 ,p_api_version IN NUMBER
88 ,p_commit IN VARCHAR2
89 ,x_return_status OUT NOCOPY VARCHAR2
90 ,x_msg_count OUT NOCOPY NUMBER
91 ,x_msg_data OUT NOCOPY VARCHAR2
92 ,p_volume_detail_rec IN ozf_sales_transactions_pvt.sales_transaction_rec_type
93 ,p_qp_list_header_id IN NUMBER DEFAULT NULL
94 ,x_apply_discount OUT NOCOPY VARCHAR2
95 );
96
97
98 FUNCTION get_beneficiary
99 (
100 p_offer_id IN NUMBER
101 ,p_cust_account_id IN NUMBER
102 )
103 RETURN NUMBER;
104
105
106 PROCEDURE update_tracking_line
107 (
108 p_init_msg_list IN VARCHAR2
109 ,p_api_version IN NUMBER
110 ,p_commit IN VARCHAR2
111 ,x_return_status OUT NOCOPY VARCHAR2
112 ,x_msg_count OUT NOCOPY NUMBER
113 ,x_msg_data OUT NOCOPY VARCHAR2
114 ,p_list_header_id IN NUMBER
115 ,p_interface_line_id IN NUMBER
116 ,p_resale_line_id IN NUMBER
117 );
118 --------------------------
119 -- Used by Volume Tracking
120 -- Will return a value only if tracking by GROUP.
121 --------------------------
122 FUNCTION get_group_volume
123 (
124 p_offer_id IN NUMBER
125 ,p_group_number IN NUMBER
126 ,p_pbh_line_id IN NUMBER
127 )
128 RETURN NUMBER;
129
130 FUNCTION get_product_volume
131 (
132 p_offer_id IN NUMBER
133 ,p_pbh_line_id IN NUMBER
134 ,p_cust_account_id IN NUMBER
135 ,p_bill_to_id IN NUMBER
136 ,p_ship_to_id IN NUMBER
137 )
138 RETURN NUMBER;
139
140 FUNCTION get_actual_tier
141 (
142 p_offer_id IN NUMBER
143 ,p_inventory_item_id IN NUMBER
144 ,p_pbh_line_id IN NUMBER
145 ,p_cust_account_id IN NUMBER
146 ,p_bill_to_id IN NUMBER
147 ,p_ship_to_id IN NUMBER
148 )
149 RETURN VARCHAR2;
150
151 FUNCTION get_actual_discount
152 (
153 p_offer_id IN NUMBER
154 ,p_inventory_item_id IN NUMBER
155 ,p_pbh_line_id IN NUMBER
156 ,p_cust_account_id IN NUMBER
157 ,p_bill_to_id IN NUMBER
158 ,p_ship_to_id IN NUMBER
159 )
160 RETURN VARCHAR2;
161
162
163 FUNCTION get_preset_tier
164 (
165 p_offer_id IN NUMBER
166 ,p_pbh_line_id IN NUMBER
167 ,p_group_no IN NUMBER
168 )
169 RETURN VARCHAR2;
170
171 FUNCTION get_preset_discount
172 (
173 p_offer_id IN NUMBER
174 ,p_pbh_line_id IN NUMBER
175 ,p_group_no IN NUMBER
176 )
177 RETURN VARCHAR2;
178
179 FUNCTION get_payout_accrual
180 (
181 p_offer_id IN NUMBER
182 ,p_item_id IN NUMBER
183 ,p_cust_account_id IN NUMBER
184 ,p_bill_to_id IN NUMBER
185 ,p_ship_to_id IN NUMBER
186 )
187 RETURN VARCHAR2;
188
189 FUNCTION get_approx_actual_accrual
190 (
191 p_offer_id IN NUMBER
192 ,p_pbh_line_id IN NUMBER
193 ,p_group_no IN NUMBER
194 ,p_item_id IN NUMBER
195 ,p_cust_account_id IN NUMBER
196 ,p_bill_to_id IN NUMBER
197 ,p_ship_to_id IN NUMBER
198 )
199 RETURN VARCHAR2;
200
201 END OZF_VOLUME_CALCULATION_PUB;