DBA Data[Home] [Help]

APPS.GHR_POSITION_EXTRA_INFO_IUDAR dependencies on GHR_HISTORY_API

Line 5: l_sess_var ghr_history_api.g_session_var_type;

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

Line 37: ghr_history_api.get_g_session_var(l_sess_var);

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

Line 41: ghr_history_api.set_g_session_var(l_sess_var);

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

Line 63: ghr_history_api.set_g_session_var(l_sess_var);

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

Line 69: ghr_history_api.set_g_session_var(l_sess_var);

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