1 PACKAGE MSC_RESOURCE_AVAILABILITY AS
2 /* $Header: MSCRAVLS.pls 120.1 2007/04/12 06:46:57 vpalla 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 END MSC_Resource_Availability;
[Home] [Help]