DBA Data[Home] [Help]

APPS.JTF_CAL_PVT dependencies on JTF_CAL_PVT

Line 1: PACKAGE BODY Jtf_Cal_Pvt AS

1: PACKAGE BODY Jtf_Cal_Pvt AS
2: /* $Header: jtfvhcb.pls 120.6 2006/05/30 13:19:14 sbarat ship $ */
3:
4: PROCEDURE GetCalendarList
5: /*******************************************************************************

Line 153: , x_DisplayItems IN OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab

149: , p_Color IN VARCHAR2
150: , p_prefix IN VARCHAR2
151: , p_pers_cal IN VARCHAR2
152: , x_index IN OUT NOCOPY BINARY_INTEGER
153: , x_DisplayItems IN OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab
154: , x_Preferences IN OUT NOCOPY Jtf_Cal_Pvt.Preference
155: ) IS
156:
157: l_TempStartDate DATE;

Line 154: , x_Preferences IN OUT NOCOPY Jtf_Cal_Pvt.Preference

150: , p_prefix IN VARCHAR2
151: , p_pers_cal IN VARCHAR2
152: , x_index IN OUT NOCOPY BINARY_INTEGER
153: , x_DisplayItems IN OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab
154: , x_Preferences IN OUT NOCOPY Jtf_Cal_Pvt.Preference
155: ) IS
156:
157: l_TempStartDate DATE;
158: l_TempEndDate DATE;

Line 457: , x_DisplayItems IN OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab

453: , p_GroupRSID IN VARCHAR2
454: , p_Color IN VARCHAR2
455: , p_prefix IN VARCHAR2
456: , x_index IN OUT NOCOPY BINARY_INTEGER
457: , x_DisplayItems IN OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab
458: , x_Preferences IN OUT NOCOPY Jtf_Cal_Pvt.Preference
459: ) IS
460:
461: CURSOR c_Items

Line 458: , x_Preferences IN OUT NOCOPY Jtf_Cal_Pvt.Preference

454: , p_Color IN VARCHAR2
455: , p_prefix IN VARCHAR2
456: , x_index IN OUT NOCOPY BINARY_INTEGER
457: , x_DisplayItems IN OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab
458: , x_Preferences IN OUT NOCOPY Jtf_Cal_Pvt.Preference
459: ) IS
460:
461: CURSOR c_Items
462: /*****************************************************************************

Line 675: , p_input IN Jtf_Cal_Pvt.QueryIn

671: , p_validation_level IN NUMBER
672: , x_return_status OUT NOCOPY VARCHAR2
673: , x_msg_count OUT NOCOPY NUMBER
674: , x_msg_data OUT NOCOPY VARCHAR2
675: , p_input IN Jtf_Cal_Pvt.QueryIn
676: , x_DisplayItems OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab
677: , x_Preferences OUT NOCOPY Jtf_Cal_Pvt.Preference
678: )IS
679: l_LoggedOnRSID NUMBER; -- ResourceID of the logged on user

Line 676: , x_DisplayItems OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab

672: , x_return_status OUT NOCOPY VARCHAR2
673: , x_msg_count OUT NOCOPY NUMBER
674: , x_msg_data OUT NOCOPY VARCHAR2
675: , p_input IN Jtf_Cal_Pvt.QueryIn
676: , x_DisplayItems OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab
677: , x_Preferences OUT NOCOPY Jtf_Cal_Pvt.Preference
678: )IS
679: l_LoggedOnRSID NUMBER; -- ResourceID of the logged on user
680: l_LoggedOnRSType VARCHAR2(30); -- ResourceType of the logged on user

Line 677: , x_Preferences OUT NOCOPY Jtf_Cal_Pvt.Preference

673: , x_msg_count OUT NOCOPY NUMBER
674: , x_msg_data OUT NOCOPY VARCHAR2
675: , p_input IN Jtf_Cal_Pvt.QueryIn
676: , x_DisplayItems OUT NOCOPY Jtf_Cal_Pvt.QueryOutTab
677: , x_Preferences OUT NOCOPY Jtf_Cal_Pvt.Preference
678: )IS
679: l_LoggedOnRSID NUMBER; -- ResourceID of the logged on user
680: l_LoggedOnRSType VARCHAR2(30); -- ResourceType of the logged on user
681: l_QueryRSID NUMBER; -- ResourceID of the logged on user

Line 1091: END Jtf_Cal_Pvt;

1087: Jtf_Cal_Utility_Pvt.SortTable(x_DisplayItems);
1088:
1089: END GetView;
1090:
1091: END Jtf_Cal_Pvt;