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

Line 4: l_session_var ghr_history_api.g_session_var_type;

1: TRIGGER "APPS"."GHR_PER_PEOPLE_EI_AFIUD" AFTER INSERT OR UPDATE OR DELETE
2: ON "APPS"."PER_PEOPLE_EXTRA_INFO" FOR EACH ROW
3: DECLARE
4: l_session_var ghr_history_api.g_session_var_type;
5: l_old_peopleei_data per_people_extra_info%rowtype;
6: l_old_peopleei_hist_data ghr_pa_history%rowtype;
7: l_sequence_number number;
8: l_proc varchar2(40):='per_people_ei_afiud';

Line 78: ghr_history_api.get_g_session_var( l_session_var);

74: END get_old_peopleei_data;
75:
76: BEGIN
77: hr_utility.set_location('Entering:'|| l_proc , 1);
78: ghr_history_api.get_g_session_var( l_session_var);
79: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
80: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
81:
82:

Line 86: ghr_history_api.set_g_session_var (l_session_var);

82:
83: IF l_session_var.fire_trigger = 'Y' THEN
84: IF l_session_var.person_id is null then
85: l_session_var.person_id := :new.person_id;
86: ghr_history_api.set_g_session_var (l_session_var);
87: END IF;
88: IF lower(l_session_var.program_name) = 'core' then
89: ghr_history_api.get_session_date( l_session_var.date_effective);
90: ghr_history_api.set_g_session_var (l_session_var);

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

85: l_session_var.person_id := :new.person_id;
86: ghr_history_api.set_g_session_var (l_session_var);
87: END IF;
88: IF lower(l_session_var.program_name) = 'core' then
89: ghr_history_api.get_session_date( l_session_var.date_effective);
90: ghr_history_api.set_g_session_var (l_session_var);
91: END IF;
92: IF (lower(l_session_var.program_name) = 'sf50' or
93: lower(l_session_var.program_name) = 'core') then

Line 90: ghr_history_api.set_g_session_var (l_session_var);

86: ghr_history_api.set_g_session_var (l_session_var);
87: END IF;
88: IF lower(l_session_var.program_name) = 'core' then
89: ghr_history_api.get_session_date( l_session_var.date_effective);
90: ghr_history_api.set_g_session_var (l_session_var);
91: END IF;
92: IF (lower(l_session_var.program_name) = 'sf50' or
93: lower(l_session_var.program_name) = 'core') then
94: IF inserting THEN

Line 96: ghr_history_api.get_g_session_var( l_session_var);

92: IF (lower(l_session_var.program_name) = 'sf50' or
93: lower(l_session_var.program_name) = 'core') then
94: IF inserting THEN
95: hr_utility.set_location( l_proc , 170);
96: ghr_history_api.get_g_session_var( l_session_var);
97: hr_utility.set_location( l_proc , 160);
98: ghr_history_api.set_operation_info(
99: p_table_name => lower(ghr_history_api.g_peopei_table),
100: p_program_name => l_session_var.program_name,

Line 98: ghr_history_api.set_operation_info(

94: IF inserting THEN
95: hr_utility.set_location( l_proc , 170);
96: ghr_history_api.get_g_session_var( l_session_var);
97: hr_utility.set_location( l_proc , 160);
98: ghr_history_api.set_operation_info(
99: p_table_name => lower(ghr_history_api.g_peopei_table),
100: p_program_name => l_session_var.program_name,
101: p_date_effective => l_session_var.date_effective,
102: p_table_pk_id => :new.person_extra_info_id,

Line 99: p_table_name => lower(ghr_history_api.g_peopei_table),

95: hr_utility.set_location( l_proc , 170);
96: ghr_history_api.get_g_session_var( l_session_var);
97: hr_utility.set_location( l_proc , 160);
98: ghr_history_api.set_operation_info(
99: p_table_name => lower(ghr_history_api.g_peopei_table),
100: p_program_name => l_session_var.program_name,
101: p_date_effective => l_session_var.date_effective,
102: p_table_pk_id => :new.person_extra_info_id,
103: p_operation => 'insert',

Line 108: ghr_history_api.get_g_session_var( l_session_var);

104: p_old_record_data => l_old_peopleei_hist_data,
105: p_row_id => :new.rowid
106: );
107: ELSIF updating THEN
108: ghr_history_api.get_g_session_var( l_session_var);
109: hr_utility.set_location( l_proc , 140);
110: get_old_peopleei_data( l_old_peopleei_data);
111: ghr_history_conv_rg.conv_peopleei_rg_to_hist_rg(
112: p_people_ei_data => l_old_peopleei_data,

Line 115: ghr_history_api.set_operation_info(

111: ghr_history_conv_rg.conv_peopleei_rg_to_hist_rg(
112: p_people_ei_data => l_old_peopleei_data,
113: p_history_data => l_old_peopleei_hist_data);
114:
115: ghr_history_api.set_operation_info(
116: p_table_name => lower(ghr_history_api.g_peopei_table),
117: p_program_name => l_session_var.program_name,
118: p_date_Effective => l_session_var.date_effective,
119: p_table_pk_id => :new.person_extra_info_id,

Line 116: p_table_name => lower(ghr_history_api.g_peopei_table),

112: p_people_ei_data => l_old_peopleei_data,
113: p_history_data => l_old_peopleei_hist_data);
114:
115: ghr_history_api.set_operation_info(
116: p_table_name => lower(ghr_history_api.g_peopei_table),
117: p_program_name => l_session_var.program_name,
118: p_date_Effective => l_session_var.date_effective,
119: p_table_pk_id => :new.person_extra_info_id,
120: p_operation => 'update',