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

1: TRIGGER GHR_PER_ASSIGNMENTS_F_AFIUD AFTER INSERT OR UPDATE OR DELETE ON PER_ALL_ASSIGNMENTS_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_asgn_data per_all_assignments_f%rowtype;
6: l_old_asgn_hist_data ghr_pa_history%rowtype;
7: l_sequence_number number;

Line 114: ghr_history_api.get_g_session_var( l_session_var);

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

Line 128: ghr_history_api.set_g_session_var( l_session_var);

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

Line 133: ghr_history_api.get_session_date( l_session_date);

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

Line 137: ghr_history_api.get_g_session_var( l_session_var);

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

Line 144: ghr_history_api.set_g_session_var( l_session_var);

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

Line 146: ghr_history_api.set_operation_info(

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

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

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

Line 164: ghr_history_api.get_g_session_var( l_session_var);

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

Line 178: ghr_history_api.set_g_session_var( l_session_var);

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

Line 180: ghr_history_api.set_operation_info(

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

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

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

Line 198: ghr_history_api.get_g_session_var( l_session_var);

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

Line 205: ghr_history_api.set_operation_info(

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

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

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

Line 223: ghr_history_api.set_operation_info(

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

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

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