APPS.CSF_ACCESS_HOURS_PVT dependencies on CSF_ACCESS_HOURS_B

Line 74: CURSOR c_next_seq IS SELECT CSF_ACCESS_HOURS_B_S1.nextval FROM sys.dual;

70: p_data_chg_frm_ui VARCHAR2
71: )
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);

Line 84: Cursor c_check_b is select ROWID from csf_access_hours_b where access_hour_id=x_access_hour_id;

80: l_msg_data varchar2(1000);
81: l_temp_b rowid;
82: l_temp_tl rowid;
83:
84: Cursor c_check_b is select ROWID from csf_access_hours_b where access_hour_id=x_access_hour_id;
85: Cursor c_check_tl is select ROWID from csf_access_hours_tl where access_hour_id=x_access_hour_id;
86:
87:
88: BEGIN

Line 104: INSERT INTO CSF_ACCESS_HOURS_B(

100: then
101: px_object_version_number := 1;
102: end if;
103:
104: INSERT INTO CSF_ACCESS_HOURS_B(
105: ACCESS_HOUR_ID,
106: TASK_ID ,
107: CREATED_BY ,
108: CREATION_DATE,

Line 322: Update CSF_ACCESS_HOURS_B

318: BEGIN
319:
320: x_return_status := fnd_api.g_ret_sts_success;
321: px_object_version_number:=px_object_version_number+1;
322: Update CSF_ACCESS_HOURS_B
323: SET
324:
325: LAST_UPDATE_DATE = sysdate,
326: LAST_UPDATED_BY = g_user_id,

Line 438: DELETE FROM CSF_ACCESS_HOURS_B

434: -- RAISE NO_DATA_FOUND;
435: Raise fnd_api.g_exc_unexpected_error;
436: end if;
437:
438: DELETE FROM CSF_ACCESS_HOURS_B
439: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;
440: If (SQL%NOTFOUND) then
441: -- RAISE NO_DATA_FOUND;
442: Raise fnd_api.g_exc_unexpected_error;

Line 495: from csf_access_hours_b

491: IS
492: cursor c_ovn
493: is
494: select object_version_number
495: from csf_access_hours_b
496: where access_hour_id = p_access_hour_id
497: for update of access_hour_id nowait;
498:
499: l_rec c_ovn%rowtype;