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 81: irc_ias_shd.g_api_dml := false; -- Unset the dml status

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

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

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

Line 91: irc_ias_shd.constraint_error

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

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

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

Line 97: irc_ias_shd.constraint_error

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

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

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

Line 103: irc_ias_shd.constraint_error

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

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

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

Line 144: (p_rec in irc_ias_shd.g_rec_type

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

Line 188: (p_rec in irc_ias_shd.g_rec_type

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

Line 215: => irc_ias_shd.g_old_rec.assignment_id

211: => p_rec.status_change_comments
212: ,p_status_change_by
213: => p_rec.status_change_by
214: ,p_assignment_id_o
215: => irc_ias_shd.g_old_rec.assignment_id
216: ,p_status_change_reason_o
217: => irc_ias_shd.g_old_rec.status_change_reason
218: ,p_object_version_number_o
219: => irc_ias_shd.g_old_rec.object_version_number

Line 217: => irc_ias_shd.g_old_rec.status_change_reason

213: => p_rec.status_change_by
214: ,p_assignment_id_o
215: => irc_ias_shd.g_old_rec.assignment_id
216: ,p_status_change_reason_o
217: => irc_ias_shd.g_old_rec.status_change_reason
218: ,p_object_version_number_o
219: => irc_ias_shd.g_old_rec.object_version_number
220: ,p_assignment_status_type_id_o
221: => irc_ias_shd.g_old_rec.assignment_status_type_id

Line 219: => irc_ias_shd.g_old_rec.object_version_number

215: => irc_ias_shd.g_old_rec.assignment_id
216: ,p_status_change_reason_o
217: => irc_ias_shd.g_old_rec.status_change_reason
218: ,p_object_version_number_o
219: => irc_ias_shd.g_old_rec.object_version_number
220: ,p_assignment_status_type_id_o
221: => irc_ias_shd.g_old_rec.assignment_status_type_id
222: ,p_status_change_date_o
223: => irc_ias_shd.g_old_rec.status_change_date

Line 221: => irc_ias_shd.g_old_rec.assignment_status_type_id

217: => irc_ias_shd.g_old_rec.status_change_reason
218: ,p_object_version_number_o
219: => irc_ias_shd.g_old_rec.object_version_number
220: ,p_assignment_status_type_id_o
221: => irc_ias_shd.g_old_rec.assignment_status_type_id
222: ,p_status_change_date_o
223: => irc_ias_shd.g_old_rec.status_change_date
224: ,p_status_change_comments_o
225: => irc_ias_shd.g_old_rec.status_change_comments

Line 223: => irc_ias_shd.g_old_rec.status_change_date

219: => irc_ias_shd.g_old_rec.object_version_number
220: ,p_assignment_status_type_id_o
221: => irc_ias_shd.g_old_rec.assignment_status_type_id
222: ,p_status_change_date_o
223: => irc_ias_shd.g_old_rec.status_change_date
224: ,p_status_change_comments_o
225: => irc_ias_shd.g_old_rec.status_change_comments
226: ,p_status_change_by_o
227: => irc_ias_shd.g_old_rec.status_change_by

Line 225: => irc_ias_shd.g_old_rec.status_change_comments

221: => irc_ias_shd.g_old_rec.assignment_status_type_id
222: ,p_status_change_date_o
223: => irc_ias_shd.g_old_rec.status_change_date
224: ,p_status_change_comments_o
225: => irc_ias_shd.g_old_rec.status_change_comments
226: ,p_status_change_by_o
227: => irc_ias_shd.g_old_rec.status_change_by
228: );
229: --

Line 227: => irc_ias_shd.g_old_rec.status_change_by

223: => irc_ias_shd.g_old_rec.status_change_date
224: ,p_status_change_comments_o
225: => irc_ias_shd.g_old_rec.status_change_comments
226: ,p_status_change_by_o
227: => irc_ias_shd.g_old_rec.status_change_by
228: );
229: --
230: exception
231: --

Line 287: (p_rec in out nocopy irc_ias_shd.g_rec_type

283: --
284: -- {End Of Comments}
285: -- ----------------------------------------------------------------------------
286: Procedure convert_defs
287: (p_rec in out nocopy irc_ias_shd.g_rec_type
288: ) is
289: --
290: Begin
291: --

Line 299: irc_ias_shd.g_old_rec.assignment_id;

295: -- is being used then we must set to the 'current' argument value.
296: --
297: If (p_rec.assignment_id = hr_api.g_number) then
298: p_rec.assignment_id :=
299: irc_ias_shd.g_old_rec.assignment_id;
300: End If;
301: If (p_rec.status_change_reason = hr_api.g_varchar2) then
302: p_rec.status_change_reason :=
303: irc_ias_shd.g_old_rec.status_change_reason;

Line 303: irc_ias_shd.g_old_rec.status_change_reason;

299: irc_ias_shd.g_old_rec.assignment_id;
300: End If;
301: If (p_rec.status_change_reason = hr_api.g_varchar2) then
302: p_rec.status_change_reason :=
303: irc_ias_shd.g_old_rec.status_change_reason;
304: End If;
305: If (p_rec.assignment_status_type_id = hr_api.g_number) then
306: p_rec.assignment_status_type_id :=
307: irc_ias_shd.g_old_rec.assignment_status_type_id;

Line 307: irc_ias_shd.g_old_rec.assignment_status_type_id;

303: irc_ias_shd.g_old_rec.status_change_reason;
304: End If;
305: If (p_rec.assignment_status_type_id = hr_api.g_number) then
306: p_rec.assignment_status_type_id :=
307: irc_ias_shd.g_old_rec.assignment_status_type_id;
308: End If;
309: If (p_rec.status_change_date = hr_api.g_date) then
310: p_rec.status_change_date :=
311: irc_ias_shd.g_old_rec.status_change_date;

Line 311: irc_ias_shd.g_old_rec.status_change_date;

307: irc_ias_shd.g_old_rec.assignment_status_type_id;
308: End If;
309: If (p_rec.status_change_date = hr_api.g_date) then
310: p_rec.status_change_date :=
311: irc_ias_shd.g_old_rec.status_change_date;
312: End If;
313: If (p_rec.status_change_comments = hr_api.g_varchar2) then
314: p_rec.status_change_comments :=
315: irc_ias_shd.g_old_rec.status_change_comments;

Line 315: irc_ias_shd.g_old_rec.status_change_comments;

311: irc_ias_shd.g_old_rec.status_change_date;
312: End If;
313: If (p_rec.status_change_comments = hr_api.g_varchar2) then
314: p_rec.status_change_comments :=
315: irc_ias_shd.g_old_rec.status_change_comments;
316: End If;
317: If (p_rec.status_change_by = hr_api.g_varchar2) then
318: p_rec.status_change_by :=
319: irc_ias_shd.g_old_rec.status_change_by;

Line 319: irc_ias_shd.g_old_rec.status_change_by;

315: irc_ias_shd.g_old_rec.status_change_comments;
316: End If;
317: If (p_rec.status_change_by = hr_api.g_varchar2) then
318: p_rec.status_change_by :=
319: irc_ias_shd.g_old_rec.status_change_by;
320: End If;
321:
322: --
323: End convert_defs;

Line 329: (p_rec in out nocopy irc_ias_shd.g_rec_type

325: -- ----------------------------------------------------------------------------
326: -- |---------------------------------< upd >----------------------------------|
327: -- ----------------------------------------------------------------------------
328: Procedure upd
329: (p_rec in out nocopy irc_ias_shd.g_rec_type
330: ) is
331: --
332: l_proc varchar2(72) := g_package||'upd';
333: --

Line 339: irc_ias_shd.lck

335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- We must lock the row which we need to update.
338: --
339: irc_ias_shd.lck
340: (p_rec.assignment_status_id
341: ,p_rec.object_version_number
342: );
343: --

Line 388: l_rec irc_ias_shd.g_rec_type;

384: ,p_status_change_comments in varchar2 default hr_api.g_varchar2
385: ,p_status_change_by in varchar2 default hr_api.g_varchar2
386: ) is
387: --
388: l_rec irc_ias_shd.g_rec_type;
389: l_proc varchar2(72) := g_package||'upd';
390: --
391: Begin
392: hr_utility.set_location('Entering:'||l_proc, 5);

Line 398: irc_ias_shd.convert_args

394: -- Call conversion function to turn arguments into the
395: -- l_rec structure.
396: --
397: l_rec :=
398: irc_ias_shd.convert_args
399: (p_assignment_status_id
400: ,p_assignment_id
401: ,p_status_change_reason
402: ,p_object_version_number