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

Line 4: l_session_var ghr_history_api.g_session_var_type;

1: TRIGGER "APPS"."GHR_PER_ASSIGNMENTS_F_AFIUD" AFTER INSERT OR UPDATE OR DELETE
2: ON "APPS"."PER_ALL_ASSIGNMENTS_F" FOR EACH ROW
3: DECLARE
4: l_session_var ghr_history_api.g_session_var_type;
5: l_session_date date;
6: l_old_asgn_data per_all_assignments_f%rowtype;
7: l_old_asgn_hist_data ghr_pa_history%rowtype;
8: l_sequence_number number;

Line 115: ghr_history_api.get_g_session_var( l_session_var);

111:
112: BEGIN
113:
114: hr_utility.set_location('Entering:'|| l_proc , 1);
115: ghr_history_api.get_g_session_var( l_session_var);
116: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
117: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
118:
119:

Line 129: ghr_history_api.set_g_session_var( l_session_var);

125: end if;
126: if l_session_var.assignment_id is null then
127: l_session_var.assignment_id := :new.assignment_id;
128: end if;
129: ghr_history_api.set_g_session_var( l_session_var);
130:
131: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
132: IF lower(l_session_var.program_name) = 'core' THEN
133: hr_utility.set_location( l_proc , 180);

Line 134: ghr_history_api.get_session_date( l_session_date);

130:
131: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
132: IF lower(l_session_var.program_name) = 'core' THEN
133: hr_utility.set_location( l_proc , 180);
134: ghr_history_api.get_session_date( l_session_date);
135:
136: IF inserting THEN
137: hr_utility.set_location( l_proc , 170);
138: ghr_history_api.get_g_session_var( l_session_var);

Line 138: ghr_history_api.get_g_session_var( l_session_var);

134: ghr_history_api.get_session_date( l_session_date);
135:
136: IF inserting THEN
137: hr_utility.set_location( l_proc , 170);
138: ghr_history_api.get_g_session_var( l_session_var);
139: IF :new.effective_start_date >= l_session_date THEN
140: hr_utility.set_location( l_proc , 160);
141: -- For core forms effective date must be set to effective start date.
142: -- Currently this is not set correctly thru core form. As it sets the

Line 145: ghr_history_api.set_g_session_var( l_session_var);

141: -- For core forms effective date must be set to effective start date.
142: -- Currently this is not set correctly thru core form. As it sets the
143: -- effective date to session date.
144: l_session_var.date_effective := :new.effective_start_date;
145: ghr_history_api.set_g_session_var( l_session_var);
146:
147: ghr_history_api.set_operation_info(
148: p_table_name => lower(ghr_history_api.g_asgn_table),
149: p_program_name => l_session_var.program_name,

Line 147: ghr_history_api.set_operation_info(

143: -- effective date to session date.
144: l_session_var.date_effective := :new.effective_start_date;
145: ghr_history_api.set_g_session_var( l_session_var);
146:
147: ghr_history_api.set_operation_info(
148: p_table_name => lower(ghr_history_api.g_asgn_table),
149: p_program_name => l_session_var.program_name,
150: p_date_effective => l_session_var.date_effective,
151: p_table_pk_id => :new.assignment_id,

Line 148: p_table_name => lower(ghr_history_api.g_asgn_table),

144: l_session_var.date_effective := :new.effective_start_date;
145: ghr_history_api.set_g_session_var( l_session_var);
146:
147: ghr_history_api.set_operation_info(
148: p_table_name => lower(ghr_history_api.g_asgn_table),
149: p_program_name => l_session_var.program_name,
150: p_date_effective => l_session_var.date_effective,
151: p_table_pk_id => :new.assignment_id,
152: p_operation => 'insert',

Line 165: ghr_history_api.get_g_session_var( l_session_var);

161: */
162: NULL;
163: END IF;
164: ELSIF updating THEN
165: ghr_history_api.get_g_session_var( l_session_var);
166: IF l_session_date between :new.effective_start_date and
167: :new.effective_end_date THEN
168:
169: hr_utility.set_location( l_proc , 140);

Line 179: ghr_history_api.set_g_session_var( l_session_var);

175: -- For core forms effective date must be set to effective start date.
176: -- Currently this is not set correctly thru core form. As it sets the
177: -- effective date to session date.
178: l_session_var.date_effective := :new.effective_start_date;
179: ghr_history_api.set_g_session_var( l_session_var);
180:
181: ghr_history_api.set_operation_info(
182: p_table_name => lower(ghr_history_api.g_asgn_table),
183: p_program_name => l_session_var.program_name,

Line 181: ghr_history_api.set_operation_info(

177: -- effective date to session date.
178: l_session_var.date_effective := :new.effective_start_date;
179: ghr_history_api.set_g_session_var( l_session_var);
180:
181: ghr_history_api.set_operation_info(
182: p_table_name => lower(ghr_history_api.g_asgn_table),
183: p_program_name => l_session_var.program_name,
184: p_date_Effective => l_session_var.date_effective,
185: p_table_pk_id => :new.assignment_id,

Line 182: p_table_name => lower(ghr_history_api.g_asgn_table),

178: l_session_var.date_effective := :new.effective_start_date;
179: ghr_history_api.set_g_session_var( l_session_var);
180:
181: ghr_history_api.set_operation_info(
182: p_table_name => lower(ghr_history_api.g_asgn_table),
183: p_program_name => l_session_var.program_name,
184: p_date_Effective => l_session_var.date_effective,
185: p_table_pk_id => :new.assignment_id,
186: p_operation => 'update',

Line 199: ghr_history_api.get_g_session_var( l_session_var);

195: NULL;
196: END IF;
197: ELSE /* ie deleting */
198: hr_utility.set_location( l_proc , 120);
199: ghr_history_api.get_g_session_var( l_session_var);
200: /* Should we allow deletes from core. How should it be handled?? */
201: NULL;
202: END IF;
203: ELSIF lower(l_session_var.program_name) = 'sf50' THEN

Line 206: ghr_history_api.set_operation_info(

202: END IF;
203: ELSIF lower(l_session_var.program_name) = 'sf50' THEN
204: IF inserting THEN
205: hr_utility.set_location( l_proc , 110);
206: ghr_history_api.set_operation_info(
207: p_program_name => l_session_var.program_name,
208: p_date_effective => l_session_var.date_effective,
209: p_table_name => lower(ghr_history_api.g_asgn_table),
210: p_table_pk_id => :new.assignment_id,

Line 209: p_table_name => lower(ghr_history_api.g_asgn_table),

205: hr_utility.set_location( l_proc , 110);
206: ghr_history_api.set_operation_info(
207: p_program_name => l_session_var.program_name,
208: p_date_effective => l_session_var.date_effective,
209: p_table_name => lower(ghr_history_api.g_asgn_table),
210: p_table_pk_id => :new.assignment_id,
211: p_operation => 'insert',
212: p_old_record_data => l_old_asgn_hist_data,
213: p_row_id => :new.rowid);

Line 224: ghr_history_api.set_operation_info(

220: get_old_asgn_data ( l_old_asgn_data);
221: ghr_history_conv_rg.conv_asgn_rg_to_hist_rg(
222: p_assignment_data => l_old_asgn_data,
223: p_history_data => l_old_asgn_hist_data);
224: ghr_history_api.set_operation_info(
225: p_program_name => l_session_var.program_name,
226: p_date_effective => l_session_var.date_effective,
227: p_table_name => lower(ghr_history_api.g_asgn_table),
228: p_table_pk_id => :new.person_id,

Line 227: p_table_name => lower(ghr_history_api.g_asgn_table),

223: p_history_data => l_old_asgn_hist_data);
224: ghr_history_api.set_operation_info(
225: p_program_name => l_session_var.program_name,
226: p_date_effective => l_session_var.date_effective,
227: p_table_name => lower(ghr_history_api.g_asgn_table),
228: p_table_pk_id => :new.person_id,
229: p_operation => 'update',
230: p_old_record_data => l_old_asgn_hist_data,
231: p_row_id => :new.rowid);