PACKAGE: APPS.WPS_GANTT_UTILITIES

Source

1 PACKAGE WPS_GANTT_UTILITIES AUTHID CURRENT_USER AS
2 /* $Header: wpsgants.pls 115.3 2002/12/09 21:14:29 jenchang noship $ */
3 
4 
5 
6 /* Constants for identifying the Bucket Size */
7 DAILY_BUCKET           CONSTANT INTEGER := 1 ;
8 WEEKLY_BUCKET          CONSTANT INTEGER := 2 ;
9 MONTHLY_BUCKET         CONSTANT INTEGER := 3 ;
10 YEARLY_BUCKET          CONSTANT INTEGER := 4 ;
11 
12 
13 /* Public Procedures  */
14 
15   PROCEDURE Populate_Bucketed_Res_Load
16 		       (p_group_id	    IN  NUMBER,
17 			p_organization_id   IN  NUMBER,
18                         p_department_id     IN  NUMBER,
19 			p_resource_id       IN  NUMBER,
20 			p_bucket_size       IN  NUMBER DEFAULT DAILY_BUCKET,
21 			p_date_from	    IN  DATE,
22 			p_date_to	    IN  DATE,
23 			p_userid	    IN  NUMBER,
24 			p_applicationid	    IN  NUMBER,
25 			p_errnum	    OUT NOCOPY NUMBER,
26 			p_errmesg 	    OUT NOCOPY VARCHAR2 );
27 
28 
29   PROCEDURE Populate_Res_Availability
30                        (p_group_id          IN  NUMBER,
31                         p_organization_id   IN  NUMBER,
32                         p_department_id     IN  NUMBER,
33 			p_resource_id       IN  NUMBER,
34                         p_date_from         IN  DATE,
35                         p_date_to           IN  DATE,
36                         p_userid            IN  NUMBER,
37                         p_applicationid     IN  NUMBER,
38                         p_errnum            OUT NOCOPY NUMBER,
39                         p_errmesg           OUT NOCOPY VARCHAR2);
40 
41 
42 
43 END WPS_GANTT_UTILITIES;