APPS.ASF_REC_VIEW_HIS_PUB dependencies on ASF_RECORD_VIEW_HISTORY

Line 16: from ASF_RECORD_VIEW_HISTORY

12: g_user_id := FND_GLOBAL.USER_ID;
13: l_date := SYSDATE;
14:
15: select count(1) into l_exist
16: from ASF_RECORD_VIEW_HISTORY
17: where OBJECT_CODE = p_object_code
18: and OBJECT_ID = p_object_id
19: and LAST_UPDATED_BY = g_user_id;
20:

Line 22: update ASF_RECORD_VIEW_HISTORY

18: and OBJECT_ID = p_object_id
19: and LAST_UPDATED_BY = g_user_id;
20:
21: if (l_exist > 0) then
22: update ASF_RECORD_VIEW_HISTORY
23: set LAST_UPDATE_DATE = l_date
24: where OBJECT_CODE = p_object_code
25: and OBJECT_ID = p_object_id
26: and LAST_UPDATED_BY = g_user_id;

Line 35: insert into ASF_RECORD_VIEW_HISTORY (

31: and nvl(START_DATE_ACTIVE, l_date) <= l_date
32: and nvl(END_DATE_ACTIVE, l_date) >= l_date;
33: if (l_exist > 0) then
34: begin
35: insert into ASF_RECORD_VIEW_HISTORY (
36: OBJECT_CODE,
37: OBJECT_ID,
38: CREATED_BY,
39: CREATION_DATE,

Line 66: x_error_message := 'Unexpected error. Please verify ASF_RECORD_VIEW_HISTORY table.';

62:
63: EXCEPTION
64: WHEN OTHERS THEN
65: x_return_status := 'U';
66: x_error_message := 'Unexpected error. Please verify ASF_RECORD_VIEW_HISTORY table.';
67: RETURN;
68: END Update_Entry;
69:
70: end ASF_REC_VIEW_HIS_PUB;