eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_HR_ALL_POSITIONS_F_AFIUD dependencies on GHR_HISTORY_API

Line 3: l_session_var ghr_history_api.g_session_var_type;

1: TRIGGER GHR_HR_ALL_POSITIONS_F_AFIUD AFTER INSERT OR UPDATE OR DELETE ON HR_ALL_POSITIONS_F FOR EACH ROW
2: DECLARE
3: l_session_var ghr_history_api.g_session_var_type;
4: l_session_date date;
5: l_old_position_data hr_all_positions_f%rowtype;
6: l_old_position_hist_data ghr_pa_history%rowtype;
7: l_sequence_number number;

Line 149: ghr_history_api.get_g_session_var( l_session_var);

145: END get_old_position_data;
146:
147: BEGIN
148: hr_utility.set_location('Entering:'|| l_proc , 1);
149: ghr_history_api.get_g_session_var( l_session_var);
150:
151: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
152: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
153:

Line 158: ghr_history_api.get_session_date( l_session_date);

154: IF l_session_var.fire_trigger = 'Y' THEN
155: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
156: IF lower(l_session_var.program_name) = 'core' THEN
157: hr_utility.set_location( l_proc , 180);
158: ghr_history_api.get_session_date( l_session_date);
159: IF inserting THEN
160: hr_utility.set_location( l_proc , 170);
161: IF :new.effective_start_date >= l_session_date THEN
162: hr_utility.set_location( l_proc , 160);

Line 167: ghr_history_api.set_g_session_var( l_session_var);

163: -- For core forms effective date must be set to effective start date.
164: -- Currently this is not set correctly thru core form. As it sets the
165: -- effective date to session date.
166: l_session_var.date_effective := :new.effective_start_date;
167: ghr_history_api.set_g_session_var( l_session_var);
168: ghr_history_api.set_operation_info(
169: p_table_name => ghr_history_api.g_posn_table,
170: p_program_name => l_session_var.program_name,
171: p_date_effective => l_session_var.date_effective,

Line 168: ghr_history_api.set_operation_info(

164: -- Currently this is not set correctly thru core form. As it sets the
165: -- effective date to session date.
166: l_session_var.date_effective := :new.effective_start_date;
167: ghr_history_api.set_g_session_var( l_session_var);
168: ghr_history_api.set_operation_info(
169: p_table_name => ghr_history_api.g_posn_table,
170: p_program_name => l_session_var.program_name,
171: p_date_effective => l_session_var.date_effective,
172: p_table_pk_id => :new.position_id,

Line 169: p_table_name => ghr_history_api.g_posn_table,

165: -- effective date to session date.
166: l_session_var.date_effective := :new.effective_start_date;
167: ghr_history_api.set_g_session_var( l_session_var);
168: ghr_history_api.set_operation_info(
169: p_table_name => ghr_history_api.g_posn_table,
170: p_program_name => l_session_var.program_name,
171: p_date_effective => l_session_var.date_effective,
172: p_table_pk_id => :new.position_id,
173: p_operation => 'insert',

Line 197: ghr_history_api.set_g_session_var( l_session_var);

193: -- For core forms effective date must be set to effective start date.
194: -- Currently this is not set correctly thru core form. As it sets the
195: -- effective date to session date.
196: l_session_var.date_effective := :new.effective_start_date;
197: ghr_history_api.set_g_session_var( l_session_var);
198:
199: ghr_history_api.set_operation_info(
200: p_table_name => ghr_history_api.g_posn_table,
201: p_program_name => l_session_var.program_name,

Line 199: ghr_history_api.set_operation_info(

195: -- effective date to session date.
196: l_session_var.date_effective := :new.effective_start_date;
197: ghr_history_api.set_g_session_var( l_session_var);
198:
199: ghr_history_api.set_operation_info(
200: p_table_name => ghr_history_api.g_posn_table,
201: p_program_name => l_session_var.program_name,
202: p_date_Effective => l_session_var.date_effective,
203: p_table_pk_id => :new.position_id,

Line 200: p_table_name => ghr_history_api.g_posn_table,

196: l_session_var.date_effective := :new.effective_start_date;
197: ghr_history_api.set_g_session_var( l_session_var);
198:
199: ghr_history_api.set_operation_info(
200: p_table_name => ghr_history_api.g_posn_table,
201: p_program_name => l_session_var.program_name,
202: p_date_Effective => l_session_var.date_effective,
203: p_table_pk_id => :new.position_id,
204: p_operation => 'update',

Line 217: ghr_history_api.get_g_session_var( l_session_var);

213: NULL;
214: END IF;
215: ELSE /* ie deleting */
216: hr_utility.set_location( l_proc , 120);
217: ghr_history_api.get_g_session_var( l_session_var);
218: /* Should we allow deletes from core. How should it be handled?? */
219: NULL;
220: END IF;
221: ELSIF lower(l_session_var.program_name) = 'sf50' THEN

Line 224: ghr_history_api.set_operation_info(

220: END IF;
221: ELSIF lower(l_session_var.program_name) = 'sf50' THEN
222: IF inserting THEN
223: hr_utility.set_location( l_proc , 110);
224: ghr_history_api.set_operation_info(
225: p_table_name => ghr_history_api.g_posn_table,
226: p_program_name => l_session_var.program_name,
227: p_date_effective => l_session_var.date_effective,
228: p_table_pk_id => :new.position_id,

Line 225: p_table_name => ghr_history_api.g_posn_table,

221: ELSIF lower(l_session_var.program_name) = 'sf50' THEN
222: IF inserting THEN
223: hr_utility.set_location( l_proc , 110);
224: ghr_history_api.set_operation_info(
225: p_table_name => ghr_history_api.g_posn_table,
226: p_program_name => l_session_var.program_name,
227: p_date_effective => l_session_var.date_effective,
228: p_table_pk_id => :new.position_id,
229: p_operation => 'insert',

Line 242: ghr_history_api.set_operation_info(

238: hr_utility.set_location('sf50 Updating '|| l_proc , 20);
239: get_old_position_data(l_old_position_data);
240: ghr_history_conv_rg.conv_position_rg_to_hist_rg( p_position_data => l_old_position_data,
241: p_history_data => l_old_position_hist_data);
242: ghr_history_api.set_operation_info(
243: p_table_name => ghr_history_api.g_posn_table,
244: p_program_name => l_session_var.program_name,
245: p_date_effective => l_session_var.date_effective,
246: p_table_pk_id => :new.position_id,

Line 243: p_table_name => ghr_history_api.g_posn_table,

239: get_old_position_data(l_old_position_data);
240: ghr_history_conv_rg.conv_position_rg_to_hist_rg( p_position_data => l_old_position_data,
241: p_history_data => l_old_position_hist_data);
242: ghr_history_api.set_operation_info(
243: p_table_name => ghr_history_api.g_posn_table,
244: p_program_name => l_session_var.program_name,
245: p_date_effective => l_session_var.date_effective,
246: p_table_pk_id => :new.position_id,
247: p_operation => 'update',