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

Line 76: (p_rec in out nocopy irc_ias_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy irc_ias_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

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

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: irc_ias_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: irc_assignment_statuses
88: --
89: insert into irc_assignment_statuses

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

102: ,p_rec.assignment_status_type_id
103: ,p_rec.status_change_date
104: );
105: --
106: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: Exception
110: When hr_api.check_integrity_violated Then

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

108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: Exception
110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
113: --
114: irc_ias_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then

Line 114: irc_ias_shd.constraint_error

110: When hr_api.check_integrity_violated Then
111: -- A check constraint has been violated
112: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
113: --
114: irc_ias_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

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

114: irc_ias_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
119: --
120: irc_ias_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then

Line 120: irc_ias_shd.constraint_error

116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
119: --
120: irc_ias_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

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

120: irc_ias_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
125: --
126: irc_ias_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then

Line 126: irc_ias_shd.constraint_error

122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
125: --
126: irc_ias_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: irc_ias_shd.g_api_dml := false; -- Unset the api dml status

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

126: irc_ias_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: irc_ias_shd.g_api_dml := false; -- Unset the api dml status
131: --
132: Raise;
133: End insert_dml;
134: --

Line 173: (p_rec in out nocopy irc_ias_shd.g_rec_type

169: --
170: -- {End Of Comments}
171: -- ----------------------------------------------------------------------------
172: Procedure pre_insert
173: (p_rec in out nocopy irc_ias_shd.g_rec_type
174: ) is
175: --
176: Cursor C_Sel1 is select irc_assignment_statuses_s.nextval from sys.dual;
177: --

Line 260: (p_rec in irc_ias_shd.g_rec_type

256: --
257: -- {End Of Comments}
258: -- ----------------------------------------------------------------------------
259: Procedure post_insert
260: (p_rec in irc_ias_shd.g_rec_type
261: ) is
262: --
263: l_proc varchar2(72) := g_package||'post_insert';
264: --

Line 302: ( p_rec in out nocopy irc_ias_shd.g_rec_type

298: -- ----------------------------------------------------------------------------
299: -- |---------------------------------< ins >----------------------------------|
300: -- ----------------------------------------------------------------------------
301: Procedure ins
302: ( p_rec in out nocopy irc_ias_shd.g_rec_type
303: ) is
304: --
305: l_proc varchar2(72) := g_package||'ins';
306: --

Line 346: l_rec irc_ias_shd.g_rec_type;

342: ,p_assignment_status_id out nocopy number
343: ,p_object_version_number out nocopy number
344: ) is
345: --
346: l_rec irc_ias_shd.g_rec_type;
347: l_proc varchar2(72) := g_package||'ins';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);

Line 356: irc_ias_shd.convert_args

352: -- Call conversion function to turn arguments into the
353: -- p_rec structure.
354: --
355: l_rec :=
356: irc_ias_shd.convert_args
357: (null
358: ,p_assignment_id
359: ,p_status_change_reason
360: ,null