1 PACKAGE OZF_QP_QUAL_PVT AUTHID CURRENT_USER as
2 /* $Header: ozfvqpqs.pls 120.8 2011/10/16 18:08:12 nirprasa ship $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- OZF_QP_QUAL_PVT
8 --
9 -- PURPOSE
10 -- This package is a Private API for Getting Market Segment qualifiers
11 --
12 --- NOTES
13 --
14 --
15 -- HISTORY
16 -- 01/12/2000 ptendulk Created
17 -- 06/12/2000 skarumur Modified
18 -- End of Comments
19
20 -- NAME
21 -- get_all_parents
22 --
23 -- USAGE
24 -- Procedure will do recursive job to find all parents for each party
25 -- NOTES
26 --
27 -- HISTORY
28 -- 11/07/2001 jieli created
29 -- 21-Oct-2010 nirprasa 10216374/9447673 SSD-IDSM ER - IDSM AND ACCRUAL CHANGES
30 -- 10/13/2011 nirprasa ER10157845 ER: NEED BACKDATING ADJUSTMENT FUNCTIONALITY FOR SUPPLIER SHIP & DEBIT OFFERS
31 -- End of Comments
32 --
33 --------------- end of comments ----------------------------
34 PROCEDURE get_all_parents(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER, px_bg_tbl IN OUT NOCOPY qp_attr_mapping_pub.t_multirecord);
35
36 --------------- start of comments --------------------------
37 -- NAME
38 -- get_buying_groups
39 --
40 -- USAGE
41 -- Function will return all the buying groups
42 -- to which the Customer belongs
43 -- NOTES
44 --
45 -- HISTORY
46 -- 11/07/2001 jieli created
47 -- End of Comments
48 --
49 --------------- end of comments ----------------------------
50 FUNCTION get_buying_groups(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
51 RETURN qp_attr_mapping_pub.t_MultiRecord ;
52
53
54 --------------- start of comments --------------------------
55 -- NAME
56 -- get_Customer_list
57 --
58 -- USAGE
59 -- Function will return all the lists
60 -- to which the Customer belongs
61 -- NOTES
62 --
63 -- HISTORY
64 -- 03-MAY-2001 julou created
65 --
66 --------------- end of comments ----------------------------
67 FUNCTION Get_lists(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
68 RETURN qp_attr_mapping_pub.t_MultiRecord;
69
70 --------------- start of comments --------------------------
71 -- NAME
72 -- get_segments
73 --
74 -- USAGE
75 -- Function will return all the Market Segments
76 -- to which the Customer belongs
77 -- NOTES
78 --
79 -- HISTORY
80 -- 03-MAY-2001 julou created
81 -- End of Comments
82 --
83 --------------- end of comments ----------------------------
84 FUNCTION Get_segments(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
85 RETURN qp_attr_mapping_pub.t_MultiRecord;
86
87 --------------- start of comments --------------------------
88 -- NAME
89 -- Find_TM_Territories
90 --
91 -- USAGE
92 -- Function will return the winning territories ID
93 -- for trade management
94 -- NOTES
95 --
96 -- HISTORY
97 -- 28-OCT-2001 julou created
98 -- End of Comments
99 --
100 --------------- end of comments ----------------------------
101 FUNCTION Find_TM_Territories
102 (
103 p_party_id IN NUMBER
104 ,p_sold_to_org IN NUMBER
105 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
106
107 --------------- start of comments --------------------------
108 -- NAME
109 -- Find_TM_Territories
110 --
111 -- USAGE
112 -- Overload function will return the winning territories ID
113 -- for trade management.
114 -- NOTES
115 --
116 -- HISTORY
117 -- 28-OCT-2001 julou created
118 -- End of Comments
119 --
120 --------------- end of comments ----------------------------
121 FUNCTION Find_TM_Territories
122 (
123 p_party_id IN NUMBER
124 ,p_sold_to_org IN NUMBER
125 ,p_ship_to_org IN NUMBER
126 ,p_bill_to_org IN NUMBER
127 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
128
129 --------------- start of comments --------------------------
130 -- NAME
131 -- Find_SA_Territories
132 --
133 -- USAGE
134 -- Function will return the winning territories ID
135 -- for sales account
136 -- NOTES
137 --
138 -- HISTORY
139 -- 28-OCT-2001 julou created
140 -- End of Comments
141 --
142 --------------- end of comments ----------------------------
143 FUNCTION Find_SA_Territories
144 (
145 p_party_id IN NUMBER
146 ,p_sold_to_org IN NUMBER
147 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
148
149 --------------- start of comments --------------------------
150 -- NAME
151 -- Find_SA_Territories
152 --
153 -- USAGE
154 -- Overload function will return the winning territories ID
155 -- for sales account
156 -- NOTES
157 --
158 -- HISTORY
159 -- 28-OCT-2001 julou created
160 -- End of Comments
161 --
162 --------------- end of comments ----------------------------
163 FUNCTION Find_SA_Territories
164 (
165 p_party_id IN NUMBER
166 ,p_sold_to_org IN NUMBER
167 ,p_ship_to_org IN NUMBER
168 ,p_bill_to_org IN NUMBER
169 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
170
171 -- sourcing rules for SOLD_BY context
172 FUNCTION get_sales_method
173 (
174 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type
175 )
176 RETURN VARCHAR2;
177
178 FUNCTION get_distributor_acct_id
179 (
180 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type -- OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL
181 )
182 RETURN NUMBER;
183
184 FUNCTION get_distributor_lists
185 (
186 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type
187 )
188 RETURN Qp_Attr_Mapping_Pub.t_multirecord;
189
190 FUNCTION get_distributor_segments
191 (
192 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type
193 )
194 RETURN Qp_Attr_Mapping_Pub.t_multirecord;
195
196 FUNCTION get_distributor_territories
197 (
198 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type
199 -- ,p_party_id NUMBER
200 -- ,p_sold_to_org_id NUMBER
201 )
202 RETURN Qp_Attr_Mapping_Pub.t_multirecord;
203
204 FUNCTION get_item_cost
205 (
206 p_line_id NUMBER, p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type -- OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL
207 )
208 RETURN VARCHAR2;
209
210 FUNCTION get_additional_qualifiers
211 (
212 p_order_header_id NUMBER, p_order_line_id NUMBER,
213 p_list_header_id NUMBER, p_list_line_id NUMBER
214 )
215 RETURN VARCHAR2;
216
217
218 END OZF_QP_QUAL_PVT ;