APPS.CSF_ACCESS_HOURS_PVT dependencies on CSF_ACCESS_HOURS_PVT

Line 1: PACKAGE BODY CSF_ACCESS_HOURS_PVT as

1: PACKAGE BODY CSF_ACCESS_HOURS_PVT as
2: /* $Header: CSFVACHB.pls 120.1 2005/10/27 00:19:25 srengana noship $ */
3: -- Start of Comments
4: --
5: -- Package name : CSF_ACCESS_HOURS_PVT

Line 5: -- Package name : CSF_ACCESS_HOURS_PVT

1: PACKAGE BODY CSF_ACCESS_HOURS_PVT as
2: /* $Header: CSFVACHB.pls 120.1 2005/10/27 00:19:25 srengana noship $ */
3: -- Start of Comments
4: --
5: -- Package name : CSF_ACCESS_HOURS_PVT
6: -- Purpose :
7: -- History :
8: -- 17-AUG-2004 : Changed the package name from CSF_ACCESS_HOURS_PKG to CSF_ACCESS_HOURS_PVT
9: -- :

Line 8: -- 17-AUG-2004 : Changed the package name from CSF_ACCESS_HOURS_PKG to CSF_ACCESS_HOURS_PVT

4: --
5: -- Package name : CSF_ACCESS_HOURS_PVT
6: -- Purpose :
7: -- History :
8: -- 17-AUG-2004 : Changed the package name from CSF_ACCESS_HOURS_PKG to CSF_ACCESS_HOURS_PVT
9: -- :
10: -- NOTE :
11: -- End of Comments
12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_ACCESS_HOUR_PVT';

Line 75: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.CREATE_ACCESS_HOURS';

71:
72: IS
73: CURSOR c_next_seq IS SELECT CSF_ACCESS_HOURS_B_S1.nextval FROM sys.dual;
74:
75: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.CREATE_ACCESS_HOURS';
76: -- l_access_hour_rec Access_Hours_Rec_Type;
77: l_return_status varchar2(100);
78: l_msg_count NUMBER;
79: l_msg_data varchar2(1000);

Line 309: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.UPDATE_ACCESS_HOURS';

305: x_msg_count OUT NOCOPY NUMBER
306: )
307:
308: IS
309: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.UPDATE_ACCESS_HOURS';
310: -- l_access_hour_rec Access_Hours_Rec_Type;
311: l_return_status varchar2(100);
312: l_msg_count NUMBER;
313: l_msg_data varchar2(1000);

Line 423: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.DELETE_ACCESS_HOURS';

419: IS
420: l_return_status varchar2(100);
421: l_msg_count NUMBER;
422: l_msg_data varchar2(1000);
423: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.DELETE_ACCESS_HOURS';
424: BEGIN
425: x_return_status := fnd_api.g_ret_sts_success;
426: DELETE FROM CSF_ACCESS_HOURS_TL
427: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;

Line 551: END CSF_ACCESS_HOURS_PVT;

547: -- ADD SESSION INFO
548: g_user_id := fnd_global.user_id;
549: g_login_id := fnd_global.login_id;
550:
551: END CSF_ACCESS_HOURS_PVT;