APPS.CSF_ACCESS_HOURS_PVT dependencies on CSF_ACCESS_HOURS_B

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

69: x_msg_count OUT NOCOPY NUMBER
70: )
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);

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

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

Line 103: INSERT INTO CSF_ACCESS_HOURS_B(

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

Line 318: Update CSF_ACCESS_HOURS_B

314: BEGIN
315:
316: x_return_status := fnd_api.g_ret_sts_success;
317: px_object_version_number:=px_object_version_number+1;
318: Update CSF_ACCESS_HOURS_B
319: SET
320:
321: LAST_UPDATE_DATE = sysdate,
322: LAST_UPDATED_BY = g_user_id,

Line 433: DELETE FROM CSF_ACCESS_HOURS_B

429: -- RAISE NO_DATA_FOUND;
430: Raise fnd_api.g_exc_unexpected_error;
431: end if;
432:
433: DELETE FROM CSF_ACCESS_HOURS_B
434: WHERE ACCESS_HOUR_ID=p_ACCESS_HOUR_ID;
435: If (SQL%NOTFOUND) then
436: -- RAISE NO_DATA_FOUND;
437: Raise fnd_api.g_exc_unexpected_error;

Line 490: from csf_access_hours_b

486: IS
487: cursor c_ovn
488: is
489: select object_version_number
490: from csf_access_hours_b
491: where access_hour_id = p_access_hour_id
492: for update of access_hour_id nowait;
493:
494: l_rec c_ovn%rowtype;