DBA Data[Home] [Help]

PACKAGE: APPS.POA_SUPPLIER_CONSOLIDATION_PK

Source


1 PACKAGE poa_supplier_consolidation_pk AUTHID CURRENT_USER AS
2 /* $Header: poaspcos.pls 115.3 2002/12/27 21:29:47 iali ship $ */
3 
4 
5 PROCEDURE calculate_savings
6  		(p_item_id		IN  NUMBER,
7 		  p_pref_supplier_id	IN  NUMBER,
8 		  p_cons_supplier_id	IN  NUMBER,
9 		  p_defect_cost		IN  NUMBER,
10 		  p_del_excp_cost	IN  NUMBER,
11 		  p_currency_code	IN  VARCHAR2,
12 		  p_start_date		IN  DATE,
13 		  p_end_date		IN  DATE,
14 		  p_user_id		IN  NUMBER,
15 		  p_bucket_type		IN  NUMBER,
16 		 p_price_savings	OUT NOCOPY NUMBER,
17 		 p_quality_savings	OUT NOCOPY NUMBER,
18 		 p_delivery_savings	OUT NOCOPY NUMBER,
19 		 p_total_savings	OUT NOCOPY NUMBER);
20 
21 END poa_supplier_consolidation_pk;