1 PACKAGE MSC_RESOURCE_AVAILABILITY AUTHID CURRENT_USER AS
2 /* $Header: MSCRAVLS.pls 120.4 2012/02/21 14:02:36 ramepai ship $ */
3
4 PROCEDURE calc_res_avail(arg_organization_id IN number,
5 arg_sr_instance_id IN number,
6 arg_department_id IN number,
7 arg_resource_id IN number,
8 arg_simulation_set IN varchar2,
9 arg_24hr_flag IN number,
10 arg_start_date IN date default SYSDATE,
11 arg_cutoff_date IN date,
12 arg_aggregate_resource_id IN number,
13 arg_refresh_number IN number,
14 arg_capacity_units IN number,
15 arg_disable_date IN DATE);
16
17 PROCEDURE populate_avail_resources(
18 arg_refresh_number IN number,
19 arg_refresh_flag IN number,
20 arg_simulation_set IN varchar2,
21 arg_organization_id IN number,
22 arg_sr_instance_id IN number,
23 arg_start_date IN date default SYSDATE,
24 arg_cutoff_date IN date default NULL);
25
26 PROCEDURE populate_org_resources(
27 RETCODE OUT NOCOPY number,
28 arg_refresh_flag IN number,
29 arg_refresh_number IN number,
30 arg_organization_id IN number,
31 arg_sr_instance_id IN number,
32 arg_start_date IN date default NULL,
33 arg_cutoff_date IN date default NULL);
34
35 PROCEDURE populate_all_lines(
36 RETCODE OUT NOCOPY number,
37 arg_refresh_flag IN number,
38 arg_refresh_number IN number,
39 arg_organization_id IN number,
40 arg_sr_instance_id IN number,
41 arg_start_date IN date default NULL,
42 arg_cutoff_date IN date default NULL);
43
44 PROCEDURE LOG_MESSAGE(pBUFF IN VARCHAR2);
45 PROCEDURE COMPUTE_RES_AVAIL (ERRBUF OUT NOCOPY VARCHAR2,
46 RETCODE OUT NOCOPY NUMBER,
47 pINSTANCE_ID IN NUMBER,
48 pSTART_DATE IN VARCHAR2);
49
50 FUNCTION CALC_RESOURCE_AVAILABILITY (pSTART_TIME IN DATE,
51 pORG_GROUP IN VARCHAR2,
52 pSTANDALONE BOOLEAN)
53 RETURN NUMBER;
54
55 PROCEDURE LOAD_NET_RESOURCE_AVAIL;
56
57 PROCEDURE POPULATE_AVAIL_RES_AHL (
58 ERRBUF OUT NOCOPY VARCHAR2,
59 RETCODE OUT NOCOPY NUMBER,
60 pINSTANCE_ID IN NUMBER
61 );
62
63 END MSC_Resource_Availability;