APPS.GHR_PER_POSITION_EI_AFIUD dependencies on GHR_HISTORY_API

Line 4: l_session_var ghr_history_api.g_session_var_type;

1: TRIGGER "APPS"."GHR_PER_POSITION_EI_AFIUD" AFTER INSERT OR UPDATE OR DELETE
2: ON "APPS"."PER_POSITION_EXTRA_INFO" FOR EACH ROW
3: DECLARE
4: l_session_var ghr_history_api.g_session_var_type;
5: l_old_position_ei_data per_position_extra_info%rowtype;
6: l_old_position_ei_hist_data ghr_pa_history%rowtype;
7: l_proc varchar2(40):='per_position_ei_afiud';
8:

Line 73: ghr_history_api.get_g_session_var (l_session_var);

69: END get_old_position_ei_data;
70:
71: BEGIN
72: hr_utility.set_location('Entering:'|| l_proc , 1);
73: ghr_history_api.get_g_session_var (l_session_var);
74:
75: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
76: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
77:

Line 81: ghr_history_api.get_session_date( l_session_var.date_effective);

77:
78:
79: IF l_session_var.fire_trigger = 'Y' THEN
80: IF lower(l_session_var.program_name) = 'core' then
81: ghr_history_api.get_session_date( l_session_var.date_effective);
82: ghr_history_api.set_g_session_var (l_session_var);
83: END IF;
84:
85: IF (lower(l_session_var.program_name) = 'sf50' or

Line 82: ghr_history_api.set_g_session_var (l_session_var);

78:
79: IF l_session_var.fire_trigger = 'Y' THEN
80: IF lower(l_session_var.program_name) = 'core' then
81: ghr_history_api.get_session_date( l_session_var.date_effective);
82: ghr_history_api.set_g_session_var (l_session_var);
83: END IF;
84:
85: IF (lower(l_session_var.program_name) = 'sf50' or
86: lower(l_session_var.program_name) = 'core') then

Line 89: ghr_history_api.get_g_session_var( l_session_var);

85: IF (lower(l_session_var.program_name) = 'sf50' or
86: lower(l_session_var.program_name) = 'core') then
87: IF inserting THEN
88: hr_utility.set_location( l_proc , 170);
89: ghr_history_api.get_g_session_var( l_session_var);
90: hr_utility.set_location( l_proc , 160);
91: ghr_history_api.set_operation_info(
92: p_table_name => ghr_history_api.g_posnei_table,
93: p_program_name => l_session_var.program_name,

Line 91: ghr_history_api.set_operation_info(

87: IF inserting THEN
88: hr_utility.set_location( l_proc , 170);
89: ghr_history_api.get_g_session_var( l_session_var);
90: hr_utility.set_location( l_proc , 160);
91: ghr_history_api.set_operation_info(
92: p_table_name => ghr_history_api.g_posnei_table,
93: p_program_name => l_session_var.program_name,
94: p_date_effective => l_session_var.date_effective,
95: p_table_pk_id => :new.position_extra_info_id,

Line 92: p_table_name => ghr_history_api.g_posnei_table,

88: hr_utility.set_location( l_proc , 170);
89: ghr_history_api.get_g_session_var( l_session_var);
90: hr_utility.set_location( l_proc , 160);
91: ghr_history_api.set_operation_info(
92: p_table_name => ghr_history_api.g_posnei_table,
93: p_program_name => l_session_var.program_name,
94: p_date_effective => l_session_var.date_effective,
95: p_table_pk_id => :new.position_extra_info_id,
96: p_operation => 'insert',

Line 101: ghr_history_api.get_g_session_var( l_session_var);

97: p_old_record_data => l_old_position_ei_hist_data,
98: p_row_id => :new.rowid
99: );
100: ELSIF updating THEN
101: ghr_history_api.get_g_session_var( l_session_var);
102: hr_utility.set_location( l_proc , 140);
103: get_old_position_ei_data( l_old_position_ei_data);
104: ghr_history_conv_rg.conv_positionei_rg_to_hist_rg( p_position_ei_data => l_old_position_ei_data,
105: p_history_data => l_old_position_ei_hist_data);

Line 107: ghr_history_api.set_operation_info(

103: get_old_position_ei_data( l_old_position_ei_data);
104: ghr_history_conv_rg.conv_positionei_rg_to_hist_rg( p_position_ei_data => l_old_position_ei_data,
105: p_history_data => l_old_position_ei_hist_data);
106:
107: ghr_history_api.set_operation_info(
108: p_table_name => ghr_history_api.g_posnei_table,
109: p_program_name => l_session_var.program_name,
110: p_date_Effective => l_session_var.date_effective,
111: p_table_pk_id => :new.position_extra_info_id,

Line 108: p_table_name => ghr_history_api.g_posnei_table,

104: ghr_history_conv_rg.conv_positionei_rg_to_hist_rg( p_position_ei_data => l_old_position_ei_data,
105: p_history_data => l_old_position_ei_hist_data);
106:
107: ghr_history_api.set_operation_info(
108: p_table_name => ghr_history_api.g_posnei_table,
109: p_program_name => l_session_var.program_name,
110: p_date_Effective => l_session_var.date_effective,
111: p_table_pk_id => :new.position_extra_info_id,
112: p_operation => 'update',

Line 118: ghr_history_api.get_g_session_var( l_session_var);

114: p_row_id => :new.rowid
115: );
116: ELSE /* ie deleting */
117: hr_utility.set_location( l_proc , 120);
118: ghr_history_api.get_g_session_var( l_session_var);
119: /* Need to discuss with functionals to decide if we should allow deletes */
120: NULL;
121: END IF;
122: ELSE /* Not a known type */