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_PER_ALL_PEOPLE_F_AFIUD dependencies on GHR_HISTORY_API

Line 3: l_session_var ghr_history_api.g_session_var_type;

1: TRIGGER GHR_PER_ALL_PEOPLE_F_AFIUD AFTER INSERT OR UPDATE OR DELETE ON PER_ALL_PEOPLE_F FOR EACH ROW
2: DECLARE
3: l_session_var ghr_history_api.g_session_var_type;
4: l_old_people_data per_all_people_f%rowtype;
5: l_old_people_hist_data ghr_pa_history%rowtype;
6: l_session_date date;
7: l_proc varchar2(30):='per_all_people_f_afiud';

Line 152: ghr_history_api.get_g_session_var( l_session_var);

148: END get_old_people_data;
149:
150: BEGIN
151: hr_utility.set_location('Entering:'|| l_proc , 1);
152: ghr_history_api.get_g_session_var( l_session_var);
153: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
154: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
155:
156: IF l_session_var.fire_trigger = 'Y' THEN

Line 164: ghr_history_api.get_session_date( l_session_date);

160:
161: if l_session_var.person_id is null then
162: l_session_var.person_id := :new.person_id;
163: end if;
164: ghr_history_api.get_session_date( l_session_date);
165: IF inserting THEN
166: hr_utility.set_location( l_proc , 170);
167: IF :new.effective_start_date >= l_session_date THEN
168: hr_utility.set_location( l_proc , 160);

Line 173: ghr_history_api.set_g_session_var( l_session_var);

169: -- For core forms effective date must be set to effective start date.
170: -- Currently this is not set correctly thru core form. As it sets the
171: -- effective date to session date.
172: l_session_var.date_effective := :new.effective_start_date;
173: ghr_history_api.set_g_session_var( l_session_var);
174:
175: ghr_history_api.set_operation_info(
176: p_table_name => lower(ghr_history_api.g_peop_table),
177: p_program_name => l_session_var.program_name,

Line 175: ghr_history_api.set_operation_info(

171: -- effective date to session date.
172: l_session_var.date_effective := :new.effective_start_date;
173: ghr_history_api.set_g_session_var( l_session_var);
174:
175: ghr_history_api.set_operation_info(
176: p_table_name => lower(ghr_history_api.g_peop_table),
177: p_program_name => l_session_var.program_name,
178: p_date_effective => l_session_var.date_effective,
179: p_table_pk_id => :new.person_id,

Line 176: p_table_name => lower(ghr_history_api.g_peop_table),

172: l_session_var.date_effective := :new.effective_start_date;
173: ghr_history_api.set_g_session_var( l_session_var);
174:
175: ghr_history_api.set_operation_info(
176: p_table_name => lower(ghr_history_api.g_peop_table),
177: p_program_name => l_session_var.program_name,
178: p_date_effective => l_session_var.date_effective,
179: p_table_pk_id => :new.person_id,
180: p_operation => 'insert',

Line 204: ghr_history_api.set_g_session_var( l_session_var);

200: -- For core forms effective date must be set to effective start date.
201: -- Currently this is not set correctly thru core form. As it sets the
202: -- effective date to session date.
203: l_session_var.date_effective := :new.effective_start_date;
204: ghr_history_api.set_g_session_var( l_session_var);
205:
206: ghr_history_api.set_operation_info(
207: p_table_name => lower(ghr_history_api.g_peop_table),
208: p_program_name => l_session_var.program_name,

Line 206: ghr_history_api.set_operation_info(

202: -- effective date to session date.
203: l_session_var.date_effective := :new.effective_start_date;
204: ghr_history_api.set_g_session_var( l_session_var);
205:
206: ghr_history_api.set_operation_info(
207: p_table_name => lower(ghr_history_api.g_peop_table),
208: p_program_name => l_session_var.program_name,
209: p_date_Effective => l_session_var.date_effective,
210: p_table_pk_id => :new.person_id,

Line 207: p_table_name => lower(ghr_history_api.g_peop_table),

203: l_session_var.date_effective := :new.effective_start_date;
204: ghr_history_api.set_g_session_var( l_session_var);
205:
206: ghr_history_api.set_operation_info(
207: p_table_name => lower(ghr_history_api.g_peop_table),
208: p_program_name => l_session_var.program_name,
209: p_date_Effective => l_session_var.date_effective,
210: p_table_pk_id => :new.person_id,
211: p_operation => 'update',

Line 224: ghr_history_api.get_g_session_var( l_session_var);

220: NULL;
221: END IF;
222: ELSE /* ie deleting */
223: hr_utility.set_location( l_proc , 120);
224: ghr_history_api.get_g_session_var( l_session_var);
225: /* Should we allow deletes from core. How should it be handled?? */
226: NULL;
227: END IF;
228: ELSIF lower(l_session_var.program_name) = 'sf50' THEN

Line 231: ghr_history_api.set_operation_info(

227: END IF;
228: ELSIF lower(l_session_var.program_name) = 'sf50' THEN
229: IF inserting THEN
230: hr_utility.set_location( l_proc , 110);
231: ghr_history_api.set_operation_info(
232: p_program_name => l_session_var.program_name,
233: p_date_effective => l_session_var.date_effective,
234: p_table_name => lower(ghr_history_api.g_peop_table),
235: p_table_pk_id => :new.person_id,

Line 234: p_table_name => lower(ghr_history_api.g_peop_table),

230: hr_utility.set_location( l_proc , 110);
231: ghr_history_api.set_operation_info(
232: p_program_name => l_session_var.program_name,
233: p_date_effective => l_session_var.date_effective,
234: p_table_name => lower(ghr_history_api.g_peop_table),
235: p_table_pk_id => :new.person_id,
236: p_operation => 'insert',
237: p_old_record_data => l_old_people_hist_data,
238: p_row_id => :new.rowid);

Line 251: ghr_history_api.set_operation_info(

247: ghr_history_conv_rg.conv_people_rg_to_hist_rg(
248: p_people_data => l_old_people_data,
249: p_history_data => l_old_people_hist_data);
250:
251: ghr_history_api.set_operation_info(
252: p_program_name => l_session_var.program_name,
253: p_date_effective => l_session_var.date_effective,
254: p_table_name => lower(ghr_history_api.g_peop_table),
255: p_table_pk_id => :new.person_id,

Line 254: p_table_name => lower(ghr_history_api.g_peop_table),

250:
251: ghr_history_api.set_operation_info(
252: p_program_name => l_session_var.program_name,
253: p_date_effective => l_session_var.date_effective,
254: p_table_name => lower(ghr_history_api.g_peop_table),
255: p_table_pk_id => :new.person_id,
256: p_operation => 'update',
257: p_old_record_data => l_old_people_hist_data,
258: p_row_id => :new.rowid);