[Home] [Help]
PACKAGE: APPS.AHL_RM_RT_OPER_RESOURCE_PVT
Source
1 PACKAGE AHL_RM_RT_OPER_RESOURCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVRORS.pls 120.1.12020000.2 2012/12/07 13:45:28 sareepar ship $ */
3
4 TYPE rt_oper_resource_rec_type IS RECORD
5 (
6 RT_OPER_RESOURCE_ID NUMBER,
7 OBJECT_VERSION_NUMBER NUMBER,
8 LAST_UPDATE_DATE DATE,
9 LAST_UPDATED_BY NUMBER(15),
10 CREATION_DATE DATE,
11 CREATED_BY NUMBER(15),
12 LAST_UPDATE_LOGIN NUMBER(15),
13 ASO_RESOURCE_ID NUMBER,
14 ASO_RESOURCE_NAME VARCHAR2(30),
15 RESOURCE_TYPE_ID NUMBER,
16 RESOURCE_TYPE VARCHAR2(80),
17 QUANTITY NUMBER,
18 DURATION NUMBER,
19 ACTIVITY_ID NUMBER,
20 ACTIVITY VARCHAR2(10),
21 COST_BASIS_ID NUMBER,
22 COST_BASIS VARCHAR2(80),
23 SCHEDULED_TYPE_ID NUMBER,
24 SCHEDULED_TYPE VARCHAR2(80),
25 AUTOCHARGE_TYPE_ID NUMBER,
26 AUTOCHARGE_TYPE VARCHAR2(80),
27 STANDARD_RATE_FLAG NUMBER,
28 STANDARD_RATE VARCHAR2(80),
29 ATTRIBUTE_CATEGORY VARCHAR2(30),
30 ATTRIBUTE1 VARCHAR2(150),
31 ATTRIBUTE2 VARCHAR2(150),
32 ATTRIBUTE3 VARCHAR2(150),
33 ATTRIBUTE4 VARCHAR2(150),
34 ATTRIBUTE5 VARCHAR2(150),
35 ATTRIBUTE6 VARCHAR2(150),
36 ATTRIBUTE7 VARCHAR2(150),
37 ATTRIBUTE8 VARCHAR2(150),
38 ATTRIBUTE9 VARCHAR2(150),
39 ATTRIBUTE10 VARCHAR2(150),
40 ATTRIBUTE11 VARCHAR2(150),
41 ATTRIBUTE12 VARCHAR2(150),
42 ATTRIBUTE13 VARCHAR2(150),
43 ATTRIBUTE14 VARCHAR2(150),
44 ATTRIBUTE15 VARCHAR2(150),
45 DML_OPERATION VARCHAR2(1),
46 -- Bug # 7644260 (FP for ER # 6998882) -- start
47 SCHEDULE_SEQ NUMBER
48 -- Bug # 7644260 (FP for ER # 6998882) -- end
49 );
50
51 TYPE rt_oper_resource_tbl_type IS TABLE OF rt_oper_resource_rec_type INDEX BY BINARY_INTEGER;
52
53 TYPE rt_oper_cost_rec_type IS RECORD
54 (
55 RT_OPER_RESOURCE_ID NUMBER,
56 OBJECT_VERSION_NUMBER NUMBER,
57 ACTIVITY_ID NUMBER,
58 ACTIVITY VARCHAR2(10),
59 COST_BASIS_ID NUMBER,
60 COST_BASIS VARCHAR2(80),
61 SCHEDULED_TYPE_ID NUMBER,
62 SCHEDULED_TYPE VARCHAR2(80),
63 AUTOCHARGE_TYPE_ID NUMBER,
64 AUTOCHARGE_TYPE VARCHAR2(80),
65 STANDARD_RATE_FLAG NUMBER,
66 STANDARD_RATE VARCHAR2(80)
67 );
68
69 TYPE alt_resource_rec_type IS RECORD
70 (
71 ALTERNATE_RESOURCE_ID NUMBER,
72 OBJECT_VERSION_NUMBER NUMBER,
73 LAST_UPDATE_DATE DATE,
74 LAST_UPDATED_BY NUMBER(15),
75 CREATION_DATE DATE,
76 CREATED_BY NUMBER(15),
77 LAST_UPDATE_LOGIN NUMBER(15),
78 ASO_RESOURCE_ID NUMBER,
79 ASO_RESOURCE_NAME AHL_RESOURCES.name%TYPE,
80 PRIORITY NUMBER,
81 ASO_RESOURCE_TYPE_ID NUMBER,
82 ATTRIBUTE_CATEGORY VARCHAR2(30),
83 ATTRIBUTE1 VARCHAR2(150),
84 ATTRIBUTE2 VARCHAR2(150),
85 ATTRIBUTE3 VARCHAR2(150),
86 ATTRIBUTE4 VARCHAR2(150),
87 ATTRIBUTE5 VARCHAR2(150),
88 ATTRIBUTE6 VARCHAR2(150),
89 ATTRIBUTE7 VARCHAR2(150),
90 ATTRIBUTE8 VARCHAR2(150),
91 ATTRIBUTE9 VARCHAR2(150),
92 ATTRIBUTE10 VARCHAR2(150),
93 ATTRIBUTE11 VARCHAR2(150),
94 ATTRIBUTE12 VARCHAR2(150),
95 ATTRIBUTE13 VARCHAR2(150),
96 ATTRIBUTE14 VARCHAR2(150),
97 ATTRIBUTE15 VARCHAR2(150),
98 DML_OPERATION VARCHAR2(1)
99 );
100
101 TYPE alt_resource_tbl_type IS TABLE OF alt_resource_rec_type INDEX BY BINARY_INTEGER;
102
103 -- Start of Comments
104 -- Procedure name : process_rt_oper_resource
105 -- Type : Private
106 -- Pre-reqs :
107 -- Function :
108 -- Parameters :
109 --
110 -- Standard IN Parameters :
111 -- p_api_version NUMBER Required
112 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
113 -- p_commit VARCHAR2 Default FND_API.G_FALSE
114 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
115 -- p_default VARCHAR2 Default FND_API.G_TRUE
116 -- p_module_type VARCHAR2 Default NULL
117 --
118 -- Standard OUT Parameters :
119 -- x_return_status VARCHAR2 Required
120 -- x_msg_count NUMBER Required
121 -- x_msg_data VARCHAR2 Required
122 --
123 -- process_rt_oper_resource IN parameters:
124 -- p_association_type_code VARCHAR2 Required
125 -- p_object_id NUMBER Required
126 --
127 -- process_rt_oper_resource IN OUT parameters:
128 -- p_x_rt_oper_resource_tbl rt_oper_resource_tbl_type Required
129 --
130 -- process_rt_oper_resource OUT parameters:
131 -- None.
132 --
133 --
134 -- Version :
135 -- Current version 1.0
136 --
137 -- End of Comments
138
139 PROCEDURE process_rt_oper_resource
140 (
141 p_api_version IN NUMBER := 1.0,
142 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
143 p_commit IN VARCHAR2 := FND_API.G_FALSE,
144 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145 p_default IN VARCHAR2 := FND_API.G_FALSE,
146 p_module_type IN VARCHAR2 := NULL,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_x_rt_oper_resource_tbl IN OUT NOCOPY rt_oper_resource_tbl_type,
151 p_association_type_code IN VARCHAR2,
152 p_object_id IN NUMBER
153 );
154
155 -- Start of Comments
156 -- Procedure name : define_cost_parameter
157 -- Type : Private
158 -- Pre-reqs :
159 -- Function :
160 -- Parameters :
161 --
162 -- Standard IN Parameters :
163 -- p_api_version NUMBER Required
164 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
165 -- p_commit VARCHAR2 Default FND_API.G_FALSE
166 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
167 -- p_default VARCHAR2 Default FND_API.G_TRUE
168 -- p_module_type VARCHAR2 Default NULL
169 --
170 -- Standard OUT Parameters :
171 -- x_return_status VARCHAR2 Required
172 -- x_msg_count NUMBER Required
173 -- x_msg_data VARCHAR2 Required
174 --
175 -- define_cost_parameter IN OUT parameters:
176 -- p_x_rt_oper_cost_rec rt_oper_cost_rec_type Required
177 --
178 -- define_cost_parameter OUT parameters:
179 -- None.
180 --
181 --
182 -- Version :
183 -- Current version 1.0
184 --
185 -- End of Comments
186
187 PROCEDURE define_cost_parameter
188 (
189 p_api_version IN NUMBER := 1.0,
190 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
191 p_commit IN VARCHAR2 := FND_API.G_FALSE,
192 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193 p_default IN VARCHAR2 := FND_API.G_FALSE,
194 p_module_type IN VARCHAR2 := NULL,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_x_rt_oper_cost_rec IN OUT NOCOPY rt_oper_cost_rec_type
199 );
200
201 -- Start of Comments
202 -- Procedure name : process_alternate_resource
203 -- Type : Private
204 -- Pre-reqs :
205 -- Function :
206 -- Parameters :
207 --
208 -- Standard IN Parameters :
209 -- p_api_version NUMBER Required
210 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
211 -- p_commit VARCHAR2 Default FND_API.G_FALSE
212 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
213 -- p_default VARCHAR2 Default FND_API.G_TRUE
214 -- p_module_type VARCHAR2 Default NULL
215 --
216 -- Standard OUT Parameters :
217 -- x_return_status VARCHAR2 Required
218 -- x_msg_count NUMBER Required
219 -- x_msg_data VARCHAR2 Required
220 --
221 -- process_alternate_resource IN parameters:
222 -- p_object_id NUMBER Required
223 --
224 -- process_rt_oper_resource IN OUT parameters:
225 -- p_x_alt_resource_tbl alt_resource_tbl_type Required
226 --
227 -- process_rt_oper_resource OUT parameters:
228 -- None.
229 --
230 --
231 -- Version :
232 -- Current version 1.0
233 --
234 -- End of Comments
235
236 PROCEDURE process_alternate_resource
237 (
238 p_api_version IN NUMBER := 1.0,
239 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
240 p_commit IN VARCHAR2 := FND_API.G_FALSE,
241 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242 p_default IN VARCHAR2 := FND_API.G_FALSE,
243 p_module_type IN VARCHAR2 := NULL,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_rt_oper_resource_id IN NUMBER,
248 p_x_alt_resource_tbl IN OUT NOCOPY alt_resource_tbl_type
249 );
250
251 END AHL_RM_RT_OPER_RESOURCE_PVT;