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.IRC_IAD_SHD dependencies on IRC_ASSIGNMENT_DETAILS_F

Line 21: If (p_constraint_name = 'IRC_ASSIGNMENT_DETAILS_F_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'IRC_ASSIGNMENT_DETAILS_F_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 26: ElsIf (p_constraint_name = 'IRC_ASSIGNMENT_DETAILS_F_U1') Then

22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'IRC_ASSIGNMENT_DETAILS_F_U1') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 63: from irc_assignment_details_f

59: ,attempt_id
60: ,qualified
61: ,considered
62: ,object_version_number
63: from irc_assignment_details_f
64: where assignment_details_id = p_assignment_details_id;
65: --
66: l_fct_ret boolean;
67: --

Line 136: ,p_base_table_name => 'irc_assignment_details_f'

132: -- Call the corresponding datetrack api
133: --
134: dt_api.find_dt_upd_modes
135: (p_effective_date => p_effective_date
136: ,p_base_table_name => 'irc_assignment_details_f'
137: ,p_base_key_column => 'assignment_id'
138: ,p_base_key_value => p_base_key_value
139: ,p_correction => p_correction
140: ,p_update => p_update

Line 175: ,p_base_table_name => 'irc_assignment_details_f'

171: -- Call the corresponding datetrack api
172: --
173: dt_api.find_dt_del_modes
174: (p_effective_date => p_effective_date
175: ,p_base_table_name => 'irc_assignment_details_f'
176: ,p_base_key_column => 'assignment_id'
177: ,p_base_key_value => p_base_key_value
178: ,p_parent_table_name1 => 'per_all_assignments_f'
179: ,p_parent_key_column1 => 'assignment_id'

Line 213: (p_base_table_name => 'irc_assignment_details_f'

209: -- version number.
210: --
211: l_object_version_number :=
212: dt_api.get_object_version_number
213: (p_base_table_name => 'irc_assignment_details_f'
214: ,p_base_key_column => 'assignment_id'
215: ,p_base_key_value => p_base_key_value
216: );
217: --

Line 224: update irc_assignment_details_f t

220: --
221: -- Update the specified datetrack row setting the effective
222: -- end date to the specified new effective end date.
223: --
224: update irc_assignment_details_f t
225: set t.effective_end_date = p_new_effective_end_date
226: , t.object_version_number = l_object_version_number
227: where t.assignment_id = p_base_key_value
228: and p_effective_date

Line 269: from irc_assignment_details_f

265: ,attempt_id
266: ,qualified
267: ,considered
268: ,object_version_number
269: from irc_assignment_details_f
270: where assignment_id = (select assignment_id
271: from irc_assignment_details_f
272: where assignment_details_id = p_assignment_details_id)
273: and p_effective_date between effective_start_date

Line 271: from irc_assignment_details_f

267: ,considered
268: ,object_version_number
269: from irc_assignment_details_f
270: where assignment_id = (select assignment_id
271: from irc_assignment_details_f
272: where assignment_details_id = p_assignment_details_id)
273: and p_effective_date between effective_start_date
274: and effective_end_date
275: order by details_version desc

Line 335: ,p_base_table_name => 'irc_assignment_details_f'

331: If (p_datetrack_mode = hr_api.g_correction) then
332: dt_api.validate_dt_mode
333: (p_effective_date => p_effective_date
334: ,p_datetrack_mode => p_datetrack_mode
335: ,p_base_table_name => 'irc_assignment_details_f'
336: ,p_base_key_column => 'assignment_details_id'
337: ,p_base_key_value => p_assignment_details_id
338: ,p_parent_table_name1 => 'per_all_assignments_f'
339: ,p_parent_key_column1 => 'assignment_id'

Line 349: ,p_base_table_name => 'irc_assignment_details_f'

345: Else
346: dt_api.validate_dt_mode
347: (p_effective_date => p_effective_date
348: ,p_datetrack_mode => p_datetrack_mode
349: ,p_base_table_name => 'irc_assignment_details_f'
350: ,p_base_key_column => 'assignment_id'
351: ,p_base_key_value => irc_iad_shd.g_old_rec.assignment_id
352: ,p_parent_table_name1 => 'per_all_assignments_f'
353: ,p_parent_key_column1 => 'assignment_id'

Line 388: fnd_message.set_token('TABLE_NAME', 'irc_assignment_details_f');

384: -- The object is locked therefore we need to supply a meaningful
385: -- error message.
386: --
387: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
388: fnd_message.set_token('TABLE_NAME', 'irc_assignment_details_f');
389: fnd_message.raise_error;
390: End lck;
391: --
392: -- ----------------------------------------------------------------------------