[Home] [Help]
PACKAGE: APPS.QP_PRICING_ENGINE_PVT
Source
1 PACKAGE QP_Pricing_Engine_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXVDLNS.pls 115.1 99/10/15 16:21:34 porting ship $ */
3
4 TYPE l_discount_line_rec IS RECORD (
5 p_discount_id QP_LIST_LINES.LIST_HEADER_ID%TYPE,
6 p_discount_line_id QP_LIST_LINES.LIST_LINE_ID%TYPE,
7 p_discount_name QP_LIST_HEADERS.NAME%TYPE,
8 p_discount_percent NUMBER);
9
10 TYPE l_discount_lines_tbl IS TABLE OF l_discount_line_rec
11 INDEX BY BINARY_INTEGER;
12
13 PROCEDURE Get_Discount_Lines
14 (p_price_list_id NUMBER,
15 p_list_price NUMBER,
16 p_quantity NUMBER,
17 p_unit_code VARCHAR2,
18 p_attribute_id NUMBER,
19 p_attribute_value VARCHAR2,
20 p_pricing_date DATE,
21 p_customer_class_code VARCHAR2,
22 p_sold_to_org_id VARCHAR2,
23 p_ship_to_id VARCHAR2,
24 p_invoice_to_id VARCHAR2,
25 p_best_adj_percent NUMBER,
26 p_gsa VARCHAR2,
27 p_asc_desc_flag VARCHAR2,
28 x_discount_line_rec OUT l_discount_line_rec);
29 --x_discount_lines_tbl OUT l_discount_lines_tbl);
30 END QP_Pricing_Engine_PVT;
31