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 4: l_session_var ghr_history_api.g_session_var_type;

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

Line 153: ghr_history_api.get_g_session_var( l_session_var);

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

Line 165: ghr_history_api.get_session_date( l_session_date);

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

Line 174: ghr_history_api.set_g_session_var( l_session_var);

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

Line 176: ghr_history_api.set_operation_info(

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

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

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

Line 205: ghr_history_api.set_g_session_var( l_session_var);

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

Line 207: ghr_history_api.set_operation_info(

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

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

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

Line 225: ghr_history_api.get_g_session_var( l_session_var);

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

Line 232: ghr_history_api.set_operation_info(

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

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

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

Line 252: ghr_history_api.set_operation_info(

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

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

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