DBA Data[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