APPS.CSF_ACCESS_HOURS_PVT dependencies on CSF_ACCESS_HOURS_TL

Line 85: Cursor c_check_tl is select ROWID from csf_access_hours_tl where access_hour_id=x_access_hour_id;

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
89: SAVEPOINT create_access_hours_pvt;

Line 197: insert into CSF_ACCESS_HOURS_TL(

193: end if;
194: close c_check_b;
195:
196:
197: insert into CSF_ACCESS_HOURS_TL(
198: ACCESS_HOUR_ID,
199: DESCRIPTION,
200: CREATED_BY,
201: CREATION_DATE,

Line 221: from CSF_ACCESS_HOURS_TL T

217: from FND_LANGUAGES L
218: where l.installed_flag in ('I','B')
219: and not exists
220: (select NULL
221: from CSF_ACCESS_HOURS_TL T
222: where T.ACCESS_HOUR_ID= x_ACCESS_HOUR_ID
223: and T.LANGUAGE = L.LANGUAGE_CODE);
224:
225:

Line 369: update CSF_ACCESS_HOURS_TL set

365: Raise fnd_api.g_exc_unexpected_error;
366: end if;
367:
368:
369: update CSF_ACCESS_HOURS_TL set
370: DESCRIPTION = p_DESCRIPTION,
371: LAST_UPDATE_DATE = sysdate,
372: LAST_UPDATED_BY = g_user_id,
373: LAST_UPDATE_LOGIN = g_login_id,

Line 431: DELETE FROM CSF_ACCESS_HOURS_TL

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;
433: If (SQL%NOTFOUND) then
434: -- RAISE NO_DATA_FOUND;
435: Raise fnd_api.g_exc_unexpected_error;