PACKAGE: APPS.MSC_GLOBAL_FORECASTING

Source

1 PACKAGE MSC_GLOBAL_FORECASTING AUTHID CURRENT_USER AS
2 /* $Header: MSCPHOGS.pls 120.4 2006/08/29 18:03:15 eychen noship $ */
3 
4 PROCEDURE populate_horizontal_plan (
5                           item_list_id IN NUMBER,
6 			  arg_plan_id IN NUMBER,
7                           arg_plan_organization_id IN NUMBER,
8                           arg_plan_instance_id IN NUMBER,
9 			  arg_cutoff_date IN DATE,
10                           enterprize_view IN BOOLEAN := FALSE,
11 		          arg_res_level IN NUMBER DEFAULT 1,
12 			  arg_resval1 IN VARCHAR2 DEFAULT NULL,
13 			  arg_resval2 IN NUMBER DEFAULT NULL,
14                           arg_ep_view_also IN BOOLEAN DEFAULT FALSE);
15 
16 PROCEDURE query_list(
17 		p_query_id IN NUMBER,
18                 p_plan_id IN NUMBER,
19                 p_item_list IN VARCHAR2,
20                 p_org_list IN  VARCHAR2);
21 
22 PROCEDURE get_detail_records(p_query_id IN NUMBER,
23                 p_node_type IN NUMBER,
24 		p_plan_id IN NUMBER,
25                 p_org_id IN NUMBER,
26                 p_inst_id IN NUMBER,
27                 p_item_id IN NUMBER,
28                 p_rowtype IN NUMBER,
29                 p_ship_level IN NUMBER,
30                 p_ship_id IN VARCHAR2,
31                 p_start_date IN DATE,
32                 p_end_date IN DATE) ;
33 
34 FUNCTION get_ship_to(p_ship_to_level number,
35                      p_plan_id number,
36                      p_sales_order_id number) return varchar2;
37 
38 
39 END MSC_GLOBAL_FORECASTING;