[Home] [Help]
PACKAGE: APPS.JTF_RESOURCE_UTL
Source
1 PACKAGE jtf_resource_utl AS
2 /* $Header: jtfrspus.pls 120.3 2005/10/17 17:15:59 nsinghai ship $ */
3
4 /*****************************************************************************************
5 This package provides the common routines that are called from the resource module
6 functions.
7 Its main functions and procedures are as following:
8 Function_Created_By
9 Function_Updated_By
10 Function_Login_Id
11 Validate_Resource_Group
12 Validate_Resource_Number
13 Validate_Input_Dates
14 Validate_Usage
15 Validate_Resource_Category
16 Validate_Employee_Resource
17 Validate_Time_Zone
18 Validate_NLS_Language
19 Validate_Support_Site_id
20 Validate_Server_Group
21 Validate_Currency_Code
22 Validate_Hold_Reason_Code
23 Validate_Resource_Team
24 Validate_User_Id
25 Validate_Salesrep_Id
26 Validate_Territory_Id
27 Validate_Sales_Credit_Type
28 Validate_Salesrep_Number
29 Check_Object_Existence
30 validate_resource_param_value_id
31 validate_rs_value_type
32 validate_resource_value
33 validate_resource_role
34 validate_rs_role_flags
35 Call_internal_hook
36 Validate_Salesrep_dates
37 ******************************************************************************************/
38
39 --Global variable Just used for Migration Starts
40 G_SOURCE_NAME VARCHAR2(2000);
41 --Global variable Just used for Migration Ends
42
43 /* Functions to get the Who columns. */
44
45 FUNCTION created_by
46 RETURN NUMBER;
47
48 FUNCTION updated_by
49 RETURN NUMBER;
50
51 FUNCTION login_id
52 RETURN NUMBER;
53
54 /* Procedure to call internal user hook. */
55
56 PROCEDURE call_internal_hook
57 (p_package_name IN VARCHAR2,
58 p_api_name IN VARCHAR2,
59 p_processing_type IN VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2
61 );
62
63 /* Procedure to validate the resource group. */
64
65 PROCEDURE validate_resource_group
66 (p_group_id IN NUMBER,
67 p_group_number IN VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_group_id OUT NOCOPY NUMBER
70 );
71
72
73 /* Procedure to validate the resource number. */
74
75 PROCEDURE validate_resource_number
76 (p_resource_id IN NUMBER,
77 p_resource_number IN NUMBER,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_resource_id OUT NOCOPY NUMBER
80 );
81
82
83 /* Procedure to validate the resource number. */
84
85 PROCEDURE validate_input_dates
86 (p_start_date_active IN DATE,
87 p_end_date_active IN DATE,
88 x_return_status OUT NOCOPY VARCHAR2
89 );
90
91
92 /* Procedure to validate the usage. */
93
94 PROCEDURE validate_usage
95 (p_usage IN VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2
97 );
98
99
100 /* Procedure to validate the resource category. */
101
102 PROCEDURE validate_resource_category
103 (p_category IN VARCHAR2,
104 x_return_status OUT NOCOPY VARCHAR2
105 );
106
107
108 /* Procedure to validate the source id. */
109
110 PROCEDURE validate_source_id
111 (p_category IN VARCHAR2,
112 p_source_id IN NUMBER,
113 p_address_id IN NUMBER,
114 x_return_status OUT NOCOPY VARCHAR2
115 );
116
117
118 /* Procedure to validate the Employee Resource */
119
120 PROCEDURE validate_employee_resource
121 (p_emp_resource_id IN NUMBER,
122 p_emp_resource_number IN NUMBER,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_emp_resource_id OUT NOCOPY NUMBER
125 );
126
127
128 /* Procedure to validate the Time Zone. */
129
130 PROCEDURE validate_time_zone
131 (p_time_zone_id IN NUMBER,
132 x_return_status OUT NOCOPY VARCHAR2
133 );
134
135
136 /* Procedure to validate the Language. */
137
138 PROCEDURE validate_nls_language
139 (p_nls_language IN VARCHAR2,
140 x_return_status OUT NOCOPY VARCHAR2
141 );
142
143
144 /* Procedure to validate the Support Site. */
145
146 PROCEDURE validate_support_site_id
147 (p_support_site_id IN NUMBER,
148 x_return_status OUT NOCOPY VARCHAR2
149 );
150
151
152 /* Validate the Server Group */
153
154 PROCEDURE validate_server_group
155 (p_server_group_id IN NUMBER,
156 p_server_group_name IN VARCHAR2,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_server_group_id OUT NOCOPY NUMBER
159 );
160
161
162 /* Procedure to validate the Currency Code. */
163
164 PROCEDURE validate_currency_code
165 (p_currency_code IN VARCHAR2,
166 x_return_status OUT NOCOPY VARCHAR2
167 );
168
169
170 /* Procedure to validate the Hold Reason Code. */
171
172 PROCEDURE validate_hold_reason_code
173 (p_hold_reason_code IN VARCHAR2,
174 x_return_status OUT NOCOPY VARCHAR2
175 );
176
177
178 /* Procedure to validate the Resource Team. */
179
180 PROCEDURE validate_resource_team
181 (p_team_id IN NUMBER,
182 p_team_number IN VARCHAR2,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_team_id OUT NOCOPY NUMBER
185 );
186
187
188 /* Procedure to validate the User Id. */
189
190 PROCEDURE validate_user_id
191 (p_user_id IN NUMBER,
192 p_category IN VARCHAR2,
193 p_source_id IN NUMBER,
194 x_return_status OUT NOCOPY VARCHAR2
195 );
196
197
198 PROCEDURE validate_salesrep_id
199 (P_SALESREP_ID IN NUMBER,
200 P_ORG_ID IN NUMBER,
201 X_RETURN_STATUS OUT NOCOPY VARCHAR2
202 );
203
204 PROCEDURE validate_salesrep_dates
205 (P_ID IN VARCHAR2,
206 P_ORG_ID IN NUMBER,
207 P_SRP_START_DATE IN DATE,
208 P_SRP_END_DATE IN DATE,
209 P_CR_UPD_MODE IN VARCHAR2,
210 X_RETURN_STATUS OUT NOCOPY VARCHAR2
211 );
212
213 PROCEDURE validate_territory_id
214 (P_TERRITORY_ID IN NUMBER,
215 X_RETURN_STATUS OUT NOCOPY VARCHAR2
216 );
217
218
219 PROCEDURE validate_sales_credit_type
220 (P_SALES_CREDIT_TYPE_ID IN NUMBER,
221 X_RETURN_STATUS OUT NOCOPY VARCHAR2
222 );
223
224
225 PROCEDURE validate_salesrep_number
226 (P_SALESREP_NUMBER IN VARCHAR2,
227 P_ORG_ID IN NUMBER,
228 X_RETURN_STATUS OUT NOCOPY VARCHAR2
229 );
230
231
232 PROCEDURE check_object_existence
233 (P_OBJECT_CODE IN JTF_OBJECTS_B.OBJECT_CODE%TYPE,
234 P_SELECT_ID IN VARCHAR2,
235 P_OBJECT_USER_CODE IN VARCHAR2,
236 X_FOUND OUT NOCOPY BOOLEAN ,
237 X_RETURN_STATUS OUT NOCOPY VARCHAR2
238 );
239
240
241 PROCEDURE check_object_existence_migr
242 (P_OBJECT_CODE IN JTF_OBJECTS_B.OBJECT_CODE%TYPE,
243 P_SELECT_ID IN VARCHAR2,
244 P_OBJECT_USER_CODE IN VARCHAR2,
245 P_RS_ID_PUB_FLAG IN VARCHAR2,
246 X_FOUND OUT NOCOPY BOOLEAN ,
247 X_RETURN_STATUS OUT NOCOPY VARCHAR2
248 );
249
250
251 /* Procedure to validate resource param id. */
252
253 PROCEDURE validate_resource_param_id
254 (p_resource_param_id IN NUMBER,
255 x_return_status OUT NOCOPY VARCHAR2
256 );
257
258 /* Procedure to validate resource value type. */
259
260 PROCEDURE validate_rs_value_type
261 (p_resource_param_id IN JTF_RS_RESOURCE_VALUES.RESOURCE_PARAM_ID%TYPE,
262 p_value_type IN JTF_RS_RESOURCE_VALUES.VALUE_TYPE%TYPE,
263 x_return_status OUT NOCOPY VARCHAR2
264 );
265
266 /* Procedure to validate resource value. */
267
268 PROCEDURE validate_resource_value
269 (p_resource_param_id IN JTF_RS_RESOURCE_VALUES.RESOURCE_PARAM_ID%TYPE,
270 p_value IN JTF_RS_RESOURCE_VALUES.VALUE%TYPE,
271 x_return_status OUT NOCOPY VARCHAR2
272 );
273
274 /* Procedure to validate resource role. */
275
276 PROCEDURE validate_resource_role
277 (p_role_id IN JTF_RS_ROLES_B.ROLE_ID%TYPE,
278 p_role_code IN JTF_RS_ROLES_B.ROLE_CODE%TYPE,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_role_id OUT NOCOPY JTF_RS_ROLES_B.ROLE_ID%TYPE
281 );
282
283 /*Procedure to validate resource role flags. */
284
285 PROCEDURE validate_rs_role_flags
286 (p_rs_role_flag IN VARCHAR2,
287 x_return_status OUT NOCOPY VARCHAR2
288 );
289
290 /*Function : get_g_miss_char. */
291
292 FUNCTION get_g_miss_num RETURN NUMBER;
293
294 /*Function : get_g_miss_char. */
295
296 FUNCTION get_g_miss_char RETURN VARCHAR2;
297
298 /*Function : get_g_miss_date. */
299
300 FUNCTION get_g_miss_date RETURN DATE;
301
302 /* Function to check for user hooks execution flag */
303
304 Function Ok_To_Execute( p_Pkg_name varchar2,
305 p_API_name varchar2,
306 p_Process_type varchar2,
307 p_User_hook_type varchar2
308 ) Return Boolean ;
309
310
311 /* Function to check for access to XMLGEN and valid status of JTF_USR_HKS*/
312 -- The below function will not be called from any API's.
313 -- Removing as a part of fixing GSCC errors in R12
314 -- Right now it is only called from jtfrsvrb.pls
315 -- Function check_access( x_Pkg_name out NOCOPY varchar2
316 -- ) Return Boolean ;
317
318 Function get_inventory_org_id return number;
319
320 END jtf_resource_utl;