1 PACKAGE MSC_NET_RES_INST_AVAILABILITY AS
2 /* $Header: MSCNRIAS.pls 120.0 2005/05/25 17:46:41 appldev noship $*/
3
4
5
6 DELETE_WORKDAY CONSTANT number := 1;
7 CHANGE_WORKDAY CONSTANT number := 2;
8 ADD_WORKDAY CONSTANT number := 3;
9 HOLD_TIME CONSTANT number := 9999999;
10
11 PROCEDURE calc_res_ins_avail( arg_organization_id IN number,
12 arg_sr_instance_id IN number,
13 arg_department_id IN number,
14 arg_resource_id IN number,
15 arg_simulation_set IN varchar2,
16 arg_instance_id in number,
17 arg_serial_num in varchar2,
18 arg_equipment_item_id IN number,
19 arg_24hr_flag IN number,
20 arg_start_date IN date,
21 arg_cutoff_date IN date,
22 arg_refresh_number IN Number);
23
24 PROCEDURE populate_avail_res_instances(
25 arg_refresh_number IN number,
26 arg_refresh_flag IN number,
27 arg_simulation_set IN varchar2,
28 arg_organization_id IN number,
29 arg_sr_instance_id IN number,
30 arg_start_date IN date,
31 arg_cutoff_date IN date);
32
33 PROCEDURE populate_org_res_instances( RETCODE OUT NOCOPY number,
34 arg_refresh_flag IN number,
35 arg_refresh_number IN number,
36 arg_organization_id IN number,
37 arg_sr_instance_id IN number,
38 arg_start_date IN date,
39 arg_cutoff_date IN date );
40
41 PROCEDURE LOG_MESSAGE( pBUFF IN VARCHAR2);
42
43 END MSC_NET_RES_INST_AVAILABILITY;