APPS.CAC_VIEW_PVT dependencies on CAC_VIEW_PVT

Line 1: PACKAGE BODY CAC_VIEW_PVT AS

1: PACKAGE BODY CAC_VIEW_PVT AS
2: /* $Header: cacvpb.pls 120.15 2006/09/19 12:08:41 sankgupt noship $ */
3:
4: TYPE MENUS_TBL IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
5:

Line 300: , x_DisplayItems IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab

296: , p_GroupRSID IN VARCHAR2
297: , p_ShowBookings IN CHAR
298: , p_QueryUserAccess IN MENUS_TBL
299: , x_index IN OUT NOCOPY BINARY_INTEGER
300: , x_DisplayItems IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab
301: )
302: IS
303: l_TempStartDate DATE;
304: l_TempEndDate DATE;

Line 594: , x_DisplayItems IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab

590: , p_TimezoneId IN NUMBER
591: , p_pers_cal IN VARCHAR2
592: , p_QueryUserAccess IN MENUS_TBL
593: , x_index IN OUT NOCOPY BINARY_INTEGER
594: , x_DisplayItems IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab
595: ) IS
596:
597: l_TempStartDate DATE;
598: l_TempEndDate DATE;

Line 1216: , x_DisplayItems IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab

1212: , p_TimezoneId IN NUMBER
1213: , p_CalSpanDaysProfile IN VARCHAR2
1214: , p_GroupRSID IN VARCHAR2
1215: , x_index IN OUT NOCOPY BINARY_INTEGER
1216: , x_DisplayItems IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab
1217: ) IS
1218:
1219: CURSOR c_Items
1220: /*****************************************************************************

Line 1428: , x_items IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab

1424: ( p_object_type IN VARCHAR2
1425: , p_object_id IN NUMBER
1426: , p_start_date IN DATE
1427: , p_end_date IN DATE
1428: , x_items IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab
1429: )
1430: IS
1431: l_hrcal CAC_HR_CAL_EVENTS_PVT.HR_CAL_EVENT_TBL_TYPE;
1432: l_index NUMBER;

Line 1484: , x_items IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab

1480: , p_start_date IN DATE
1481: , p_end_date IN DATE
1482: , p_timezone_id IN NUMBER
1483: , p_view_timezone IN NUMBER
1484: , x_items IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab
1485: )
1486: IS
1487: l_return_status VARCHAR2(1);
1488: l_msg_count NUMBER;

Line 1644: (p_CalendarItems IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab

1640: ** We need to sort the output table to make life easier on the
1641: ** java end.. This is a simple bi-directional bubble sort, which
1642: ** should do the trick.
1643: ******************************************************************/
1644: (p_CalendarItems IN OUT NOCOPY CAC_VIEW_PVT.QueryOutTab
1645: )
1646: IS
1647: l_LastRecord BINARY_INTEGER;
1648:

Line 1656: l_record CAC_VIEW_PVT.QueryOut;

1652: ******************************************************************/
1653: (p_index IN NUMBER
1654: )
1655: IS
1656: l_record CAC_VIEW_PVT.QueryOut;
1657: BEGIN
1658: l_record := p_CalendarItems(p_index);
1659: p_CalendarItems(p_index) := p_CalendarItems(p_index - 1);
1660: p_CalendarItems(p_index - 1) := l_record;

Line 1759: ( p_input IN CAC_VIEW_PVT.QueryIn

1755:
1756: END GET_EMPLOYEE_RESOURCE;
1757:
1758: PROCEDURE GET_RESOURCES
1759: ( p_input IN CAC_VIEW_PVT.QueryIn
1760: , x_query_emp_resource_id OUT NOCOPY NUMBER
1761: , x_query_emp_resource_type OUT NOCOPY VARCHAR2
1762: , x_query_per_assignment_id OUT NOCOPY NUMBER
1763: , x_query_per_assignment_type OUT NOCOPY VARCHAR2

Line 1889: , p_input IN CAC_VIEW_PVT.QueryIn

1885: , p_validation_level IN NUMBER
1886: , x_return_status OUT NOCOPY VARCHAR2
1887: , x_msg_count OUT NOCOPY NUMBER
1888: , x_msg_data OUT NOCOPY VARCHAR2
1889: , p_input IN CAC_VIEW_PVT.QueryIn
1890: , x_DisplayItems OUT NOCOPY CAC_VIEW_PVT.QueryOutTab
1891: )IS
1892: l_LoggedOnRSID NUMBER; -- ResourceID of the logged on user
1893: l_LoggedOnRSType VARCHAR2(30); -- ResourceType of the logged on user

Line 1890: , x_DisplayItems OUT NOCOPY CAC_VIEW_PVT.QueryOutTab

1886: , x_return_status OUT NOCOPY VARCHAR2
1887: , x_msg_count OUT NOCOPY NUMBER
1888: , x_msg_data OUT NOCOPY VARCHAR2
1889: , p_input IN CAC_VIEW_PVT.QueryIn
1890: , x_DisplayItems OUT NOCOPY CAC_VIEW_PVT.QueryOutTab
1891: )IS
1892: l_LoggedOnRSID NUMBER; -- ResourceID of the logged on user
1893: l_LoggedOnRSType VARCHAR2(30); -- ResourceType of the logged on user
1894: l_QueryRSID NUMBER; -- ResourceID of the logged on user

Line 2404: END CAC_VIEW_PVT;

2400: WHEN OTHERS THEN
2401: RETURN NULL;
2402: END get_Contact;
2403:
2404: END CAC_VIEW_PVT;
2405: