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_INS dependencies on IRC_ASSIGNMENT_DETAILS_F

Line 91: from irc_assignment_details_f t

87: --
88: Cursor C_Sel1 Is
89: select t.created_by,
90: t.creation_date
91: from irc_assignment_details_f t
92: where t.assignment_id = p_rec.assignment_id
93: and t.effective_start_date =
94: irc_iad_shd.g_old_rec.effective_start_date
95: and (t.effective_end_date = (p_validation_start_date - 1)

Line 101: from irc_assignment_details_f

97: --
98: -- Cursor to get the new Details Version number
99: Cursor c_details_version is
100: select nvl(max(details_version), 0)+1
101: from irc_assignment_details_f
102: where assignment_id = p_rec.assignment_id
103: and effective_start_date = p_validation_start_date
104: and effective_end_date = p_validation_end_date;
105: --

Line 107: l_created_by irc_assignment_details_f.created_by%TYPE;

103: and effective_start_date = p_validation_start_date
104: and effective_end_date = p_validation_end_date;
105: --
106: l_proc varchar2(72) := g_package||'dt_insert_dml';
107: l_created_by irc_assignment_details_f.created_by%TYPE;
108: l_creation_date irc_assignment_details_f.creation_date%TYPE;
109: l_last_update_date irc_assignment_details_f.last_update_date%TYPE;
110: l_last_updated_by irc_assignment_details_f.last_updated_by%TYPE;
111: l_last_update_login irc_assignment_details_f.last_update_login%TYPE;

Line 108: l_creation_date irc_assignment_details_f.creation_date%TYPE;

104: and effective_end_date = p_validation_end_date;
105: --
106: l_proc varchar2(72) := g_package||'dt_insert_dml';
107: l_created_by irc_assignment_details_f.created_by%TYPE;
108: l_creation_date irc_assignment_details_f.creation_date%TYPE;
109: l_last_update_date irc_assignment_details_f.last_update_date%TYPE;
110: l_last_updated_by irc_assignment_details_f.last_updated_by%TYPE;
111: l_last_update_login irc_assignment_details_f.last_update_login%TYPE;
112: --

Line 109: l_last_update_date irc_assignment_details_f.last_update_date%TYPE;

105: --
106: l_proc varchar2(72) := g_package||'dt_insert_dml';
107: l_created_by irc_assignment_details_f.created_by%TYPE;
108: l_creation_date irc_assignment_details_f.creation_date%TYPE;
109: l_last_update_date irc_assignment_details_f.last_update_date%TYPE;
110: l_last_updated_by irc_assignment_details_f.last_updated_by%TYPE;
111: l_last_update_login irc_assignment_details_f.last_update_login%TYPE;
112: --
113: Begin

Line 110: l_last_updated_by irc_assignment_details_f.last_updated_by%TYPE;

106: l_proc varchar2(72) := g_package||'dt_insert_dml';
107: l_created_by irc_assignment_details_f.created_by%TYPE;
108: l_creation_date irc_assignment_details_f.creation_date%TYPE;
109: l_last_update_date irc_assignment_details_f.last_update_date%TYPE;
110: l_last_updated_by irc_assignment_details_f.last_updated_by%TYPE;
111: l_last_update_login irc_assignment_details_f.last_update_login%TYPE;
112: --
113: Begin
114: hr_utility.set_location('Entering:'||l_proc, 5);

Line 111: l_last_update_login irc_assignment_details_f.last_update_login%TYPE;

107: l_created_by irc_assignment_details_f.created_by%TYPE;
108: l_creation_date irc_assignment_details_f.creation_date%TYPE;
109: l_last_update_date irc_assignment_details_f.last_update_date%TYPE;
110: l_last_updated_by irc_assignment_details_f.last_updated_by%TYPE;
111: l_last_update_login irc_assignment_details_f.last_update_login%TYPE;
112: --
113: Begin
114: hr_utility.set_location('Entering:'||l_proc, 5);
115: --

Line 132: (p_base_table_name => 'irc_assignment_details_f'

128: -- Get the object version number for the insert
129: --
130: p_rec.object_version_number :=
131: dt_api.get_object_version_number
132: (p_base_table_name => 'irc_assignment_details_f'
133: ,p_base_key_column => 'assignment_id'
134: ,p_base_key_value => p_rec.assignment_id
135: );
136: --

Line 174: -- Insert the row into: irc_assignment_details_f

170: -- Mark the new row being added as the latest
171: --
172: p_rec.latest_details := 'Y';
173: --
174: -- Insert the row into: irc_assignment_details_f
175: --
176: insert into irc_assignment_details_f
177: (assignment_details_id
178: ,assignment_id

Line 176: insert into irc_assignment_details_f

172: p_rec.latest_details := 'Y';
173: --
174: -- Insert the row into: irc_assignment_details_f
175: --
176: insert into irc_assignment_details_f
177: (assignment_details_id
178: ,assignment_id
179: ,effective_start_date
180: ,effective_end_date

Line 308: from irc_assignment_details_f

304: Cursor C_Sel1 is select irc_assignment_details_s.nextval from sys.dual;
305: --
306: Cursor C_Sel2 is
307: Select null
308: from irc_assignment_details_f
309: where assignment_details_id =
310: irc_iad_ins.g_assignment_details_id_i;
311: --
312: l_proc varchar2(72) := g_package||'pre_insert';

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

326: --
327: -- The primary key values are already in use.
328: --
329: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
330: fnd_message.set_token('TABLE_NAME','irc_assignment_details_f');
331: fnd_message.raise_error;
332: End If;
333: Close C_Sel2;
334: --

Line 436: (p_module_name => 'IRC_ASSIGNMENT_DETAILS_F'

432: --
433: when hr_api.cannot_find_prog_unit then
434: --
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'IRC_ASSIGNMENT_DETAILS_F'
437: ,p_hook_type => 'AI');
438: --
439: end;
440: --

Line 501: ,p_base_table_name => 'irc_assignment_details_f'

497: --
498: dt_api.validate_dt_mode
499: (p_effective_date => p_effective_date
500: ,p_datetrack_mode => p_datetrack_mode
501: ,p_base_table_name => 'irc_assignment_details_f'
502: ,p_base_key_column => 'assignment_details_id'
503: ,p_base_key_value => p_rec.assignment_details_id
504: ,p_parent_table_name1 => 'per_all_assignments_f'
505: ,p_parent_key_column1 => 'assignment_id'