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.3 2011/04/26 11:00:15 vakulkar ship $ */
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.3 2011/04/26 11:00:15 vakulkar ship $ */
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 76: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.CREATE_ACCESS_HOURS';

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

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

309: p_data_chg_frm_ui VARCHAR2
310: )
311:
312: IS
313: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.UPDATE_ACCESS_HOURS';
314: -- l_access_hour_rec Access_Hours_Rec_Type;
315: l_return_status varchar2(100);
316: l_msg_count NUMBER;
317: l_msg_data varchar2(1000);

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

424: IS
425: l_return_status varchar2(100);
426: l_msg_count NUMBER;
427: l_msg_data varchar2(1000);
428: l_api_name_full constant varchar2(50) := 'CSF_ACCESS_HOURS_PVT.DELETE_ACCESS_HOURS';
429: BEGIN
430: x_return_status := fnd_api.g_ret_sts_success;
431: DELETE FROM CSF_ACCESS_HOURS_TL
432: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;

Line 556: END CSF_ACCESS_HOURS_PVT;

552: -- ADD SESSION INFO
553: g_user_id := fnd_global.user_id;
554: g_login_id := fnd_global.login_id;
555:
556: END CSF_ACCESS_HOURS_PVT;