DBA Data[Home] [Help]

APPS.GHR_POSITION_EXTRA_INFO_IUDAR dependencies on GHR_HISTORY_API

Line 6: l_sess_var ghr_history_api.g_session_var_type;

2: after insert or update or delete
3: on PER_POSITION_EXTRA_INFO
4: for each row
5: DECLARE
6: l_sess_var ghr_history_api.g_session_var_type;
7: l_effective_date date;
8: l_session_id fnd_sessions.session_id%type;
9: l_fire_trigger varchar2(30);
10:

Line 38: ghr_history_api.get_g_session_var(l_sess_var);

34:
35: IF ghr_utility.g_position_being_deleted THEN
36: RETURN;
37: END IF;
38: ghr_history_api.get_g_session_var(l_sess_var);
39:
40: l_fire_trigger := l_sess_var.fire_trigger;
41: l_sess_var.fire_trigger := 'N';
42: ghr_history_api.set_g_session_var(l_sess_var);

Line 42: ghr_history_api.set_g_session_var(l_sess_var);

38: ghr_history_api.get_g_session_var(l_sess_var);
39:
40: l_fire_trigger := l_sess_var.fire_trigger;
41: l_sess_var.fire_trigger := 'N';
42: ghr_history_api.set_g_session_var(l_sess_var);
43:
44:
45: for session_id in C_session_id loop
46: l_session_id := session_id.sessionid;

Line 64: ghr_history_api.set_g_session_var(l_sess_var);

60: END LOOP;
61: END IF;
62:
63: l_sess_var.fire_trigger := l_fire_trigger;
64: ghr_history_api.set_g_session_var(l_sess_var);
65: END IF;
66:
67: EXCEPTION
68: WHEN others THEN

Line 70: ghr_history_api.set_g_session_var(l_sess_var);

66:
67: EXCEPTION
68: WHEN others THEN
69: l_sess_var.fire_trigger := l_fire_trigger;
70: ghr_history_api.set_g_session_var(l_sess_var);
71: raise;
72:
73: END;
74: