PACKAGE: APPS.MSC_CRP_HORIZONTAL_PLAN

Source

1 PACKAGE msc_crp_horizontal_plan AUTHID CURRENT_USER AS
2 /*	$Header: MSCHCPLS.pls 120.1 2005/06/10 14:02:45 appldev  $ */
3 
4 FUNCTION populate_horizontal_plan(
5                         p_batchable		IN NUMBER,
6 			p_item_list_id		IN NUMBER,
7 			p_org_id		IN NUMBER,
8 			p_inst_id		IN NUMBER,
9 			p_plan_id		IN NUMBER,
10 			p_bucket_type		IN NUMBER,
11 			p_cutoff_date		IN DATE,
12 			p_current_data		IN NUMBER DEFAULT 2) RETURN NUMBER;
13                    --     p_inst_list             IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
14 
15 FUNCTION compute_days_between(
16             spread_load NUMBER,
17             start_date  DATE,
18             end_date    DATE) RETURN NUMBER ;
19 
20 PROCEDURE query_list(p_query_id IN NUMBER,
21                 p_plan_id IN NUMBER,
22                 p_org_list IN VARCHAR2,
23                 p_dept_list IN VARCHAR2,
24                 p_res_list IN VARCHAR2,
25                 p_data IN NUMBER,
26                 p_inst_list IN VARCHAR2 DEFAULT NULL,
27                 p_serial_num_list IN VARCHAR2 DEFAULT NULL);
28 
29 END msc_crp_horizontal_plan;