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
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
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
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
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
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
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
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: (
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
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
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