PACKAGE: APPS.MSC_SUPPLIER_HORIZONTAL_PLAN

Source

1 PACKAGE msc_supplier_horizontal_plan AS
2 /*	$Header: MSCHSPLS.pls 120.1 2005/06/10 14:03:17 appldev  $ */
3 
4 FUNCTION populate_horizontal_plan(
5 			p_item_list_id		IN NUMBER,
6 			p_org_id		IN NUMBER,
7 			p_inst_id		IN NUMBER,
8 			p_plan_id		IN NUMBER,
9 			p_bucket_type		IN NUMBER,
10 			p_cutoff_date		IN DATE,
11 			p_current_data		IN NUMBER DEFAULT 2) RETURN NUMBER;
12 
13 PROCEDURE query_list(p_query_id IN NUMBER,
14                 p_plan_id IN NUMBER,
15                 p_item_list IN VARCHAR2,
16                 p_org_list IN VARCHAR2,
17                 p_supplier_list IN VARCHAR2,
18                 p_supplier_site_list IN VARCHAR2);
19 
20 FUNCTION get_order_type_label (p_supplier_site_id NUMBER)
21 	RETURN VARCHAR2;
22 
23 END msc_supplier_horizontal_plan;