1 PACKAGE BODY CAC_VIEW_UTIL_PUB as
2 /* $Header: cacputlb.pls 115.1 2004/05/10 22:59:34 cijang noship $ */
3 /*======================================================================+
4 | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | FILENAME |
8 | cacputlb.pls |
9 | |
10 | DESCRIPTION |
11 | This package is view public utility for calendar view. |
12 | |
13 | NOTES |
14 | |
15 | Date Developer Change |
16 | ----------- --------------- --------------------------------------- |
17 | 06-May-2004 Chan-Ik Jang Created |
18 *=======================================================================*/
19
20 /* -----------------------------------------------------------------
21 * -- Function Name: get_attendees
22 * -- Description : This function returns the list of attendees.
23 * -- The attendee names are concatenated as a string.
24 * -- Parameter : p_task_id = Task Id
25 * -- Return Type : VARCHAR2
26 * -----------------------------------------------------------------*/
27 FUNCTION get_attendees(p_task_id IN NUMBER)
28 RETURN VARCHAR2
29 IS
30 BEGIN
31 RETURN get_attendees(p_task_id);
32 END get_attendees;
33
34 /* -----------------------------------------------------------------
35 * -- Function Name: get_related_items
36 * -- Description : This function returns the concatednated information
37 * -- of items related to the given task id.
38 * -- Parameter : p_task_id = Task Id
39 * -- Return Type : VARCHAR2
40 * -----------------------------------------------------------------*/
41 FUNCTION get_related_items (p_task_id IN NUMBER)
42 RETURN VARCHAR2
43 IS
44 BEGIN
45 RETURN CAC_VIEW_ACC_DAILY_VIEW_PVT.get_related_items(p_task_id);
46 EXCEPTION
47 WHEN OTHERS THEN
48 RETURN NULL;
49 END get_related_items;
50
51 /* -----------------------------------------------------------------
52 * -- Function Name: get_locations
53 * -- Description : This function returns the concatednated information
54 * -- of location related to the given task id.
55 * -- Parameter : p_task_id = Task Id
56 * -- Return Type : VARCHAR2
57 * -----------------------------------------------------------------*/
58 FUNCTION get_locations(p_task_id IN NUMBER)
59 RETURN VARCHAR2
60 IS
61 BEGIN
62 RETURN CAC_VIEW_PVT.get_locations(p_task_id);
63 EXCEPTION
64 WHEN OTHERS THEN
65 RETURN NULL;
66 END get_locations;
67
68 END CAC_VIEW_UTIL_PUB;