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

Line 52: (p_rec in irc_ias_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in irc_ias_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

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

56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: irc_ias_shd.g_api_dml := true; -- Set the dml status
61: --
62: -- Delete the irc_assignment_statuses row.
63: --
64: delete from irc_assignment_statuses

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

63: --
64: delete from irc_assignment_statuses
65: where assignment_status_id = p_rec.assignment_status_id;
66: --
67: irc_ias_shd.g_api_dml := false; -- Unset the dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception

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

70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: irc_ias_shd.g_api_dml := false; -- Unset the dml status
75: --
76: irc_ias_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then

Line 76: irc_ias_shd.constraint_error

72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: irc_ias_shd.g_api_dml := false; -- Unset the dml status
75: --
76: irc_ias_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: irc_ias_shd.g_api_dml := false; -- Unset the dml status

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

76: irc_ias_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: irc_ias_shd.g_api_dml := false; -- Unset the dml status
81: Raise;
82: End delete_dml;
83: --
84: -- ----------------------------------------------------------------------------

Line 116: Procedure pre_delete(p_rec in irc_ias_shd.g_rec_type) is

112: -- Internal Row Handler Use Only.
113: --
114: -- {End Of Comments}
115: -- ----------------------------------------------------------------------------
116: Procedure pre_delete(p_rec in irc_ias_shd.g_rec_type) is
117: --
118: l_proc varchar2(72) := g_package||'pre_delete';
119: --
120: Begin

Line 158: Procedure post_delete(p_rec in irc_ias_shd.g_rec_type) is

154: -- Internal Row Handler Use Only.
155: --
156: -- {End Of Comments}
157: -- -----------------------------------------------------------------------------
158: Procedure post_delete(p_rec in irc_ias_shd.g_rec_type) is
159: --
160: l_proc varchar2(72) := g_package||'post_delete';
161: --
162: Begin

Line 170: => irc_ias_shd.g_old_rec.assignment_id

166: irc_ias_rkd.after_delete
167: (p_assignment_status_id
168: => p_rec.assignment_status_id
169: ,p_assignment_id_o
170: => irc_ias_shd.g_old_rec.assignment_id
171: ,p_status_change_reason_o
172: => irc_ias_shd.g_old_rec.status_change_reason
173: ,p_object_version_number_o
174: => irc_ias_shd.g_old_rec.object_version_number

Line 172: => irc_ias_shd.g_old_rec.status_change_reason

168: => p_rec.assignment_status_id
169: ,p_assignment_id_o
170: => irc_ias_shd.g_old_rec.assignment_id
171: ,p_status_change_reason_o
172: => irc_ias_shd.g_old_rec.status_change_reason
173: ,p_object_version_number_o
174: => irc_ias_shd.g_old_rec.object_version_number
175: ,p_assignment_status_type_id_o
176: => irc_ias_shd.g_old_rec.assignment_status_type_id

Line 174: => irc_ias_shd.g_old_rec.object_version_number

170: => irc_ias_shd.g_old_rec.assignment_id
171: ,p_status_change_reason_o
172: => irc_ias_shd.g_old_rec.status_change_reason
173: ,p_object_version_number_o
174: => irc_ias_shd.g_old_rec.object_version_number
175: ,p_assignment_status_type_id_o
176: => irc_ias_shd.g_old_rec.assignment_status_type_id
177: ,p_status_change_date_o
178: => irc_ias_shd.g_old_rec.status_change_date

Line 176: => irc_ias_shd.g_old_rec.assignment_status_type_id

172: => irc_ias_shd.g_old_rec.status_change_reason
173: ,p_object_version_number_o
174: => irc_ias_shd.g_old_rec.object_version_number
175: ,p_assignment_status_type_id_o
176: => irc_ias_shd.g_old_rec.assignment_status_type_id
177: ,p_status_change_date_o
178: => irc_ias_shd.g_old_rec.status_change_date
179: );
180: --

Line 178: => irc_ias_shd.g_old_rec.status_change_date

174: => irc_ias_shd.g_old_rec.object_version_number
175: ,p_assignment_status_type_id_o
176: => irc_ias_shd.g_old_rec.assignment_status_type_id
177: ,p_status_change_date_o
178: => irc_ias_shd.g_old_rec.status_change_date
179: );
180: --
181: exception
182: --

Line 198: (p_rec in irc_ias_shd.g_rec_type

194: -- ----------------------------------------------------------------------------
195: -- |---------------------------------< del >----------------------------------|
196: -- ----------------------------------------------------------------------------
197: Procedure del
198: (p_rec in irc_ias_shd.g_rec_type
199: ) is
200: --
201: l_proc varchar2(72) := g_package||'del';
202: --

Line 208: irc_ias_shd.lck

204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: -- We must lock the row which we need to delete.
207: --
208: irc_ias_shd.lck
209: (p_rec.assignment_status_id
210: ,p_rec.object_version_number
211: );
212: --

Line 243: l_rec irc_ias_shd.g_rec_type;

239: (p_assignment_status_id in number
240: ,p_object_version_number in number
241: ) is
242: --
243: l_rec irc_ias_shd.g_rec_type;
244: l_proc varchar2(72) := g_package||'del';
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);