77: -- Pre-reqs : None.
78: -- Parameters :
79: -- IN : p_api_version IN NUMBER Required
80: -- p_init_msg_list IN VARCHAR2 Optional
81: -- Default = FND_API.G_FALSE
82: -- p_resource_id IN NUMBER Required
83: -- p_resource_type IN VARCHAR2 Required
84: -- p_start_date IN DATE
85: -- p_end_date IN DATE
112: * @rep:displayname Get Available Time
113: */
114: PROCEDURE Get_Available_Time
115: ( p_api_version IN NUMBER ,
116: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
117: p_resource_id IN NUMBER ,
118: p_resource_type IN VARCHAR2 ,
119: p_start_date IN DATE ,
120: p_end_date IN DATE ,
132: -- Pre-reqs : None.
133: -- Parameters :
134: -- IN : p_api_version IN NUMBER Required
135: -- p_init_msg_list IN VARCHAR2 Optional
136: -- Default = FND_API.G_FALSE
137: -- p_resource_id IN NUMBER Required
138: -- p_resource_type IN VARCHAR2 Required
139: -- p_start_date_time IN DATE
140: -- p_end_date_time IN DATE
175: * @rep:displayname Get Available Slot
176: */
177: PROCEDURE Get_Available_Slot
178: ( p_api_version IN NUMBER ,
179: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
180: p_resource_id IN NUMBER ,
181: p_resource_type IN VARCHAR2 ,
182: p_start_date_time IN DATE ,
183: p_end_date_time IN DATE ,
199: -- Pre-reqs : None.
200: -- Parameters :
201: -- IN : p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Optional
203: -- Default = FND_API.G_FALSE
204: -- p_resource_id IN NUMBER Required
205: -- p_resource_type IN VARCHAR2 Required
206: -- p_start_date IN DATE
207: -- p_end_date IN DATE
218: -- ************************************************************************
219:
220: PROCEDURE Get_Resource_Shifts
221: ( p_api_version IN NUMBER ,
222: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
223: p_resource_id IN NUMBER ,
224: p_resource_type IN VARCHAR2 ,
225: p_start_date IN DATE ,
226: p_end_date IN DATE ,
239: -- Pre-reqs : None.
240: -- Parameters :
241: -- IN : p_api_version IN NUMBER Required
242: -- p_init_msg_list IN VARCHAR2 Optional
243: -- Default = FND_API.G_FALSE
244: -- p_resource_id IN NUMBER Required
245: -- p_resource_type IN VARCHAR2 Required
246: -- p_start_date IN DATE
247: -- p_end_date IN DATE
275: * @rep:displayname Get Resource Shift with attributes
276: */
277: PROCEDURE Get_Resource_Shifts
278: ( p_api_version IN NUMBER ,
279: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
280: p_resource_id IN NUMBER ,
281: p_resource_type IN VARCHAR2 ,
282: p_start_date IN DATE ,
283: p_end_date IN DATE ,
296: -- Pre-reqs : None.
297: -- Parameters :
298: -- IN : p_api_version IN NUMBER Required
299: -- p_init_msg_list IN VARCHAR2 Optional
300: -- Default = FND_API.G_FALSE
301: -- p_resource_id IN NUMBER Required
302: -- p_resource_type IN VARCHAR2 Required
303: -- p_start_date_time IN DATE
304: -- p_duration IN NUMBER Required
330: * @rep:displayname Is Resource Available
331: */
332: PROCEDURE Is_Res_Available
333: ( p_api_version IN NUMBER ,
334: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE ,
335: p_resource_id IN NUMBER ,
336: p_resource_type IN VARCHAR2 ,
337: p_start_date_time IN DATE ,
338: p_duration IN NUMBER ,
350: -- Pre-reqs : None.
351: -- Parameters :
352: -- IN : p_api_version IN NUMBER Required
353: -- p_init_msg_list IN VARCHAR2 Optional
354: -- Default = FND_API.G_FALSE
355: -- p_resource_id IN NUMBER Required
356: -- p_resource_type IN VARCHAR2 Required
357: -- p_start_date IN DATE
358: -- p_end_date IN DATE
386: * @rep:displayname Get Resource Schedule
387: */
388: PROCEDURE Get_Res_Schedule
389: ( p_api_version IN NUMBER ,
390: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
391: p_resource_id IN NUMBER ,
392: p_resource_type IN VARCHAR2 ,
393: p_start_date IN DATE ,
394: p_end_date IN DATE ,
400: -- ************************************************************************
401: -- Start of comments
402: -- API name : get_g_false
403: -- Type : Public.
404: -- Function : Used as a wrapper function to get FND_API.G_FALSE.
405: -- Pre-reqs : None.
406: -- Parameters :
407: -- IN : None.
408: -- OUT : None.
405: -- Pre-reqs : None.
406: -- Parameters :
407: -- IN : None.
408: -- OUT : None.
409: -- RETURN : FND_API.G_FALSE VARCHAR2
410: -- Version : Current version 1.0
411: -- Initial version 1.0
412: --
413: -- Notes :
420: -- ************************************************************************
421: -- Start of comments
422: -- API name : get_g_miss_num
423: -- Type : Public.
424: -- Function : Used as a wrapper function to get FND_API.G_MISS_NUM.
425: -- Pre-reqs : None.
426: -- Parameters :
427: -- IN : None.
428: -- OUT : None.
425: -- Pre-reqs : None.
426: -- Parameters :
427: -- IN : None.
428: -- OUT : None.
429: -- RETURN : FND_API.G_MISS_NUM NUMBER
430: -- Version : Current version 1.0
431: -- Initial version 1.0
432: --
433: -- Notes :
440: -- ************************************************************************
441: -- Start of comments
442: -- API name : get_g_miss_char
443: -- Type : Public.
444: -- Function : Used as a wrapper function to get FND_API.G_MISS_CHAR.
445: -- Pre-reqs : None.
446: -- Parameters :
447: -- IN : None.
448: -- OUT : None.
445: -- Pre-reqs : None.
446: -- Parameters :
447: -- IN : None.
448: -- OUT : None.
449: -- RETURN : FND_API.G_MISS_CHAR VARCHAR2
450: -- Version : Current version 1.0
451: -- Initial version 1.0
452: --
453: -- Notes :
460: -- ************************************************************************
461: -- Start of comments
462: -- API name : get_g_miss_date
463: -- Type : Public.
464: -- Function : Used as a wrapper function to get FND_API.G_MISS_DATE.
465: -- Pre-reqs : None.
466: -- Parameters :
467: -- IN : None.
468: -- OUT : None.
465: -- Pre-reqs : None.
466: -- Parameters :
467: -- IN : None.
468: -- OUT : None.
469: -- RETURN : FND_API.G_MISS_DATE DATE
470: -- Version : Current version 1.0
471: -- Initial version 1.0
472: --
473: -- Notes :
507: -- Pre-reqs : None.
508: -- Parameters :
509: -- IN : None.
510: -- OUT : None.
511: -- RETURN : FND_API.G_MISS_DATE DATE
512: -- Version : Current version 1.0
513: -- Initial version 1.0
514: --
515: -- Notes : Create Function for timezone conversion form