1 PACKAGE AHL_LTP_RESRC_LEVL_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPRLGS.pls 115.12 2003/11/06 00:55:14 ssurapan noship $*/
3
4 -----------------------------------------------------------------------
5 -- Define Record Types for record structures needed by the APIs --
6 ---------------------------------------------------------------------
7
8 TYPE Req_Resources_rec IS RECORD
9 (
10 ORG_NAME VARCHAR2(240) ,
11 DEPT_NAME VARCHAR2(80) ,
12 DEPT_ID NUMBER ,
13 PLAN_ID NUMBER ,
14 START_DATE DATE ,
15 END_DATE DATE ,
16 DISPLAY_START_DATE DATE ,
17 DISPLAY_END_DATE DATE ,
18 UOM_CODE VARCHAR2(10) ,
19 REQUIRED_CAPACITY NUMBER ,
20 RESOURCE_ID NUMBER ,
21 RESOURCE_TYPE NUMBER ,
22 ASO_BOM_TYPE VARCHAR2(30) ,
23 RESOURCE_TYPE_MEANING VARCHAR2(30)
24 );
25
26 TYPE Aval_Resources_Rec IS RECORD
27 (
28 PERIOD_STRING VARCHAR2(80) ,
29 PERIOD_START DATE ,
30 PERIOD_END DATE ,
31 REQUIRED_CAPACITY NUMBER ,
32 DEPT_NAME VARCHAR2(80) ,
33 RESOURCE_ID NUMBER ,
34 RESOURCE_TYPE NUMBER ,
35 RESOURCE_TYPE_MEANING VARCHAR2(30) ,
36 RESOURCE_NAME VARCHAR2(30) ,
37 RESOURCE_DESCRIPTION VARCHAR2(240)
38 );
39
40 TYPE Resource_Con_Rec IS RECORD
41 (
42 VISIT_ID NUMBER ,
43 TASK_ID NUMBER ,
44 VISIT_NAME VARCHAR2(80) ,
45 VISIT_TASK_NAME VARCHAR2(80) ,
46 TASK_TYPE_CODE VARCHAR2(30) ,
47 DEPT_NAME VARCHAR2(80) ,
48 QUANTITY NUMBER ,
49 REQUIRED_UNITS NUMBER ,
50 AVAILABLE_UNITS NUMBER
51 );
52
53 ----------------------------------------------
54 -- Define Table Type for records structures --
55 ----------------------------------------------
56 TYPE Aval_Resources_Tbl IS TABLE OF Aval_Resources_Rec INDEX BY BINARY_INTEGER;
57 TYPE Resource_Con_Tbl IS TABLE OF Resource_Con_Rec INDEX BY BINARY_INTEGER;
58
59 ------------------------
60 -- Declare Procedures --
61 ------------------------
62
63 -- Start of Comments --
64 -- Procedure name : Derieve_Resource_Capacity
65 -- Type : Public
66 -- Function :
67 -- Pre-reqs :
68 -- Parameters :
69 --
70 -- Standard IN Parameters :
71 -- p_api_version IN NUMBER Required
72 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
73 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
74 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
75 -- Based on this flag, the API will set the default attributes.
76 -- p_module_type In VARCHAR2 Default NULL
77 -- This will be null.
78 -- Standard OUT Parameters :
79 -- x_return_status OUT VARCHAR2 Required
80 -- x_msg_count OUT NUMBER Required
81 -- x_msg_data OUT VARCHAR2 Required
82 --
83 -- Process_Space_Assignment Parameters :
84 -- p_req_resources IN Req_Resources_Rec Required,
85 -- x_aval_resources_tbl OUT Aval_Resources_Tbl,
86
87 PROCEDURE Derive_Resource_Capacity
88 (
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
91 p_commit IN VARCHAR2 := FND_API.g_false,
92 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
93 p_module_type IN VARCHAR2 := 'JSP',
94 p_req_resources IN Req_Resources_Rec,
95 x_aval_resources_tbl OUT NOCOPY Aval_Resources_Tbl,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101 -- Start of Comments --
102 -- Procedure name : Derieve_Resource_Consum
103 -- Type : Public
104 -- Function :
105 -- Pre-reqs :
106 -- Parameters :
107 --
108 -- Standard IN Parameters :
109 -- p_api_version IN NUMBER Required
110 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
111 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
112 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
113 -- Based on this flag, the API will set the default attributes.
114 -- p_module_type In VARCHAR2 Default NULL
115 -- This will be null.
116 -- Standard OUT Parameters :
117 -- x_return_status OUT VARCHAR2 Required
118 -- x_msg_count OUT NUMBER Required
119 -- x_msg_data OUT VARCHAR2 Required
120 --
121 -- Process_Space_Assignment Parameters :
122 -- p_req_resources IN Req_Resources_Rec Required,
123 -- x_resource_con_tbl OUT Resource_Con_Tbl,
124
125 PROCEDURE Derive_Resource_Consum
126 (
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
129 p_commit IN VARCHAR2 := FND_API.g_false,
130 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
131 p_module_type IN VARCHAR2 := 'JSP',
132 p_req_resources IN Req_Resources_Rec,
133 x_resource_con_tbl OUT NOCOPY Resource_Con_Tbl,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139
140 END AHL_LTP_RESRC_LEVL_PUB;