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_IAS_UPD dependencies on IRC_IAS_SHD

Line 55: (p_rec in out nocopy irc_ias_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy irc_ias_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 66: irc_ias_shd.g_api_dml := true; -- Set the dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: irc_ias_shd.g_api_dml := true; -- Set the dml status
67: --
68: -- Update the irc_assignment_statuses Row
69: --
70: update irc_assignment_statuses

Line 79: irc_ias_shd.g_api_dml := false; -- Unset the dml status

75: ,assignment_status_type_id = p_rec.assignment_status_type_id
76: ,status_change_date = p_rec.status_change_date
77: where assignment_status_id = p_rec.assignment_status_id;
78: --
79: irc_ias_shd.g_api_dml := false; -- Unset the dml status
80: --
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --

Line 87: irc_ias_shd.g_api_dml := false; -- Unset the dml status

83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: irc_ias_shd.g_api_dml := false; -- Unset the dml status
88: --
89: irc_ias_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then

Line 89: irc_ias_shd.constraint_error

85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: irc_ias_shd.g_api_dml := false; -- Unset the dml status
88: --
89: irc_ias_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: irc_ias_shd.g_api_dml := false; -- Unset the dml status

Line 93: irc_ias_shd.g_api_dml := false; -- Unset the dml status

89: irc_ias_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: irc_ias_shd.g_api_dml := false; -- Unset the dml status
94: --
95: irc_ias_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then

Line 95: irc_ias_shd.constraint_error

91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: irc_ias_shd.g_api_dml := false; -- Unset the dml status
94: --
95: irc_ias_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: irc_ias_shd.g_api_dml := false; -- Unset the dml status

Line 99: irc_ias_shd.g_api_dml := false; -- Unset the dml status

95: irc_ias_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: irc_ias_shd.g_api_dml := false; -- Unset the dml status
100: --
101: irc_ias_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then

Line 101: irc_ias_shd.constraint_error

97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: irc_ias_shd.g_api_dml := false; -- Unset the dml status
100: --
101: irc_ias_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: irc_ias_shd.g_api_dml := false; -- Unset the dml status
105: --

Line 104: irc_ias_shd.g_api_dml := false; -- Unset the dml status

100: --
101: irc_ias_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: irc_ias_shd.g_api_dml := false; -- Unset the dml status
105: --
106: Raise;
107: End update_dml;
108: --

Line 142: (p_rec in irc_ias_shd.g_rec_type

138: --
139: -- {End Of Comments}
140: -- ----------------------------------------------------------------------------
141: Procedure pre_update
142: (p_rec in irc_ias_shd.g_rec_type
143: ) is
144: --
145: l_proc varchar2(72) := g_package||'pre_update';
146: --

Line 186: (p_rec in irc_ias_shd.g_rec_type

182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure post_update
186: (p_rec in irc_ias_shd.g_rec_type
187: ) is
188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: --

Line 209: => irc_ias_shd.g_old_rec.assignment_id

205: => p_rec.assignment_status_type_id
206: ,p_status_change_date
207: => p_rec.status_change_date
208: ,p_assignment_id_o
209: => irc_ias_shd.g_old_rec.assignment_id
210: ,p_status_change_reason_o
211: => irc_ias_shd.g_old_rec.status_change_reason
212: ,p_object_version_number_o
213: => irc_ias_shd.g_old_rec.object_version_number

Line 211: => irc_ias_shd.g_old_rec.status_change_reason

207: => p_rec.status_change_date
208: ,p_assignment_id_o
209: => irc_ias_shd.g_old_rec.assignment_id
210: ,p_status_change_reason_o
211: => irc_ias_shd.g_old_rec.status_change_reason
212: ,p_object_version_number_o
213: => irc_ias_shd.g_old_rec.object_version_number
214: ,p_assignment_status_type_id_o
215: => irc_ias_shd.g_old_rec.assignment_status_type_id

Line 213: => irc_ias_shd.g_old_rec.object_version_number

209: => irc_ias_shd.g_old_rec.assignment_id
210: ,p_status_change_reason_o
211: => irc_ias_shd.g_old_rec.status_change_reason
212: ,p_object_version_number_o
213: => irc_ias_shd.g_old_rec.object_version_number
214: ,p_assignment_status_type_id_o
215: => irc_ias_shd.g_old_rec.assignment_status_type_id
216: ,p_status_change_date_o
217: => irc_ias_shd.g_old_rec.status_change_date

Line 215: => irc_ias_shd.g_old_rec.assignment_status_type_id

211: => irc_ias_shd.g_old_rec.status_change_reason
212: ,p_object_version_number_o
213: => irc_ias_shd.g_old_rec.object_version_number
214: ,p_assignment_status_type_id_o
215: => irc_ias_shd.g_old_rec.assignment_status_type_id
216: ,p_status_change_date_o
217: => irc_ias_shd.g_old_rec.status_change_date
218: );
219: --

Line 217: => irc_ias_shd.g_old_rec.status_change_date

213: => irc_ias_shd.g_old_rec.object_version_number
214: ,p_assignment_status_type_id_o
215: => irc_ias_shd.g_old_rec.assignment_status_type_id
216: ,p_status_change_date_o
217: => irc_ias_shd.g_old_rec.status_change_date
218: );
219: --
220: exception
221: --

Line 277: (p_rec in out nocopy irc_ias_shd.g_rec_type

273: --
274: -- {End Of Comments}
275: -- ----------------------------------------------------------------------------
276: Procedure convert_defs
277: (p_rec in out nocopy irc_ias_shd.g_rec_type
278: ) is
279: --
280: Begin
281: --

Line 289: irc_ias_shd.g_old_rec.assignment_id;

285: -- is being used then we must set to the 'current' argument value.
286: --
287: If (p_rec.assignment_id = hr_api.g_number) then
288: p_rec.assignment_id :=
289: irc_ias_shd.g_old_rec.assignment_id;
290: End If;
291: If (p_rec.status_change_reason = hr_api.g_varchar2) then
292: p_rec.status_change_reason :=
293: irc_ias_shd.g_old_rec.status_change_reason;

Line 293: irc_ias_shd.g_old_rec.status_change_reason;

289: irc_ias_shd.g_old_rec.assignment_id;
290: End If;
291: If (p_rec.status_change_reason = hr_api.g_varchar2) then
292: p_rec.status_change_reason :=
293: irc_ias_shd.g_old_rec.status_change_reason;
294: End If;
295: If (p_rec.assignment_status_type_id = hr_api.g_number) then
296: p_rec.assignment_status_type_id :=
297: irc_ias_shd.g_old_rec.assignment_status_type_id;

Line 297: irc_ias_shd.g_old_rec.assignment_status_type_id;

293: irc_ias_shd.g_old_rec.status_change_reason;
294: End If;
295: If (p_rec.assignment_status_type_id = hr_api.g_number) then
296: p_rec.assignment_status_type_id :=
297: irc_ias_shd.g_old_rec.assignment_status_type_id;
298: End If;
299: If (p_rec.status_change_date = hr_api.g_date) then
300: p_rec.status_change_date :=
301: irc_ias_shd.g_old_rec.status_change_date;

Line 301: irc_ias_shd.g_old_rec.status_change_date;

297: irc_ias_shd.g_old_rec.assignment_status_type_id;
298: End If;
299: If (p_rec.status_change_date = hr_api.g_date) then
300: p_rec.status_change_date :=
301: irc_ias_shd.g_old_rec.status_change_date;
302: End If;
303: --
304: End convert_defs;
305: --

Line 310: (p_rec in out nocopy irc_ias_shd.g_rec_type

306: -- ----------------------------------------------------------------------------
307: -- |---------------------------------< upd >----------------------------------|
308: -- ----------------------------------------------------------------------------
309: Procedure upd
310: (p_rec in out nocopy irc_ias_shd.g_rec_type
311: ) is
312: --
313: l_proc varchar2(72) := g_package||'upd';
314: --

Line 320: irc_ias_shd.lck

316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: -- We must lock the row which we need to update.
319: --
320: irc_ias_shd.lck
321: (p_rec.assignment_status_id
322: ,p_rec.object_version_number
323: );
324: --

Line 367: l_rec irc_ias_shd.g_rec_type;

363: ,p_status_change_reason in varchar2 default hr_api.g_varchar2
364: ,p_status_change_date in date
365: ) is
366: --
367: l_rec irc_ias_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'upd';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);

Line 377: irc_ias_shd.convert_args

373: -- Call conversion function to turn arguments into the
374: -- l_rec structure.
375: --
376: l_rec :=
377: irc_ias_shd.convert_args
378: (p_assignment_status_id
379: ,p_assignment_id
380: ,p_status_change_reason
381: ,p_object_version_number