1 PACKAGE OZF_QP_QUAL_PVT as
2 /* $Header: ozfvqpqs.pls 120.2 2006/01/27 20:25:22 julou 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 -- End of Comments
30 --
31 --------------- end of comments ----------------------------
32 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);
33
34 --------------- start of comments --------------------------
35 -- NAME
36 -- get_buying_groups
37 --
38 -- USAGE
39 -- Function will return all the buying groups
40 -- to which the Customer belongs
41 -- NOTES
42 --
43 -- HISTORY
44 -- 11/07/2001 jieli created
45 -- End of Comments
46 --
47 --------------- end of comments ----------------------------
48 FUNCTION get_buying_groups(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
49 RETURN qp_attr_mapping_pub.t_MultiRecord ;
50
51
52 --------------- start of comments --------------------------
53 -- NAME
54 -- get_Customer_list
55 --
56 -- USAGE
57 -- Function will return all the lists
58 -- to which the Customer belongs
59 -- NOTES
60 --
61 -- HISTORY
62 -- 03-MAY-2001 julou created
63 --
64 --------------- end of comments ----------------------------
65 FUNCTION Get_lists(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
66 RETURN qp_attr_mapping_pub.t_MultiRecord;
67
68 --------------- start of comments --------------------------
69 -- NAME
70 -- get_segments
71 --
72 -- USAGE
73 -- Function will return all the Market Segments
74 -- to which the Customer belongs
75 -- NOTES
76 --
77 -- HISTORY
78 -- 03-MAY-2001 julou created
79 -- End of Comments
80 --
81 --------------- end of comments ----------------------------
82 FUNCTION Get_segments(aso_party_id IN NUMBER,om_sold_to_org IN NUMBER)
83 RETURN qp_attr_mapping_pub.t_MultiRecord;
84
85 --------------- start of comments --------------------------
86 -- NAME
87 -- Find_TM_Territories
88 --
89 -- USAGE
90 -- Function will return the winning territories ID
91 -- for trade management
92 -- NOTES
93 --
94 -- HISTORY
95 -- 28-OCT-2001 julou created
96 -- End of Comments
97 --
98 --------------- end of comments ----------------------------
99 FUNCTION Find_TM_Territories
100 (
101 p_party_id IN NUMBER
102 ,p_sold_to_org IN NUMBER
103 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
104
105 --------------- start of comments --------------------------
106 -- NAME
107 -- Find_TM_Territories
108 --
109 -- USAGE
110 -- Overload function will return the winning territories ID
111 -- for trade management.
112 -- NOTES
113 --
114 -- HISTORY
115 -- 28-OCT-2001 julou created
116 -- End of Comments
117 --
118 --------------- end of comments ----------------------------
119 FUNCTION Find_TM_Territories
120 (
121 p_party_id IN NUMBER
122 ,p_sold_to_org IN NUMBER
123 ,p_ship_to_org IN NUMBER
124 ,p_bill_to_org IN NUMBER
125 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
126
127 --------------- start of comments --------------------------
128 -- NAME
129 -- Find_SA_Territories
130 --
131 -- USAGE
132 -- Function will return the winning territories ID
133 -- for sales account
134 -- NOTES
135 --
136 -- HISTORY
137 -- 28-OCT-2001 julou created
138 -- End of Comments
139 --
140 --------------- end of comments ----------------------------
141 FUNCTION Find_SA_Territories
142 (
143 p_party_id IN NUMBER
144 ,p_sold_to_org IN NUMBER
145 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
146
147 --------------- start of comments --------------------------
148 -- NAME
149 -- Find_SA_Territories
150 --
151 -- USAGE
152 -- Overload function will return the winning territories ID
153 -- for sales account
154 -- NOTES
155 --
156 -- HISTORY
157 -- 28-OCT-2001 julou created
158 -- End of Comments
159 --
160 --------------- end of comments ----------------------------
161 FUNCTION Find_SA_Territories
162 (
163 p_party_id IN NUMBER
164 ,p_sold_to_org IN NUMBER
165 ,p_ship_to_org IN NUMBER
166 ,p_bill_to_org IN NUMBER
167 ) RETURN Qp_Attr_Mapping_Pub.t_multirecord;
168
169 -- sourcing rules for SOLD_BY context
170 FUNCTION get_sales_method
171 (
172 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type
173 )
174 RETURN VARCHAR2;
175
176 FUNCTION get_distributor_acct_id
177 (
178 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type -- OZF_ORDER_PRICE_PVT.G_RESALE_LINE_TBL
179 )
180 RETURN NUMBER;
181
182 FUNCTION get_distributor_lists
183 (
184 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type
185 )
186 RETURN Qp_Attr_Mapping_Pub.t_multirecord;
187
188 FUNCTION get_distributor_segments
189 (
190 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type
191 )
192 RETURN Qp_Attr_Mapping_Pub.t_multirecord;
193
194 FUNCTION get_distributor_territories
195 (
196 p_resale_line_tbl ozf_order_price_pvt.resale_line_tbl_type
197 -- ,p_party_id NUMBER
198 -- ,p_sold_to_org_id NUMBER
199 )
200 RETURN Qp_Attr_Mapping_Pub.t_multirecord;
201
202 END OZF_QP_QUAL_PVT ;