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_ILP_INS dependencies on IRC_ILP_SHD

Line 76: (p_rec in out nocopy irc_ilp_shd.g_rec_type

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

Line 85: irc_ilp_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_ilp_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: irc_location_preferences
88: --
89: insert into irc_location_preferences

Line 172: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

168: ,p_rec.attribute30
169: ,p_rec.object_version_number
170: );
171: --
172: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: Exception
176: When hr_api.check_integrity_violated Then

Line 178: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: Exception
176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
179: irc_ilp_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated

Line 179: irc_ilp_shd.constraint_error

175: Exception
176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
179: irc_ilp_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

Line 183: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

179: irc_ilp_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
184: irc_ilp_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated

Line 184: irc_ilp_shd.constraint_error

180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
184: irc_ilp_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

Line 188: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

184: irc_ilp_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
189: irc_ilp_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

Line 189: irc_ilp_shd.constraint_error

185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
189: irc_ilp_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
193: Raise;

Line 192: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status

188: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
189: irc_ilp_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
193: Raise;
194: End insert_dml;
195: --
196: -- ----------------------------------------------------------------------------

Line 234: (p_rec in out nocopy irc_ilp_shd.g_rec_type

230: --
231: -- {End Of Comments}
232: -- ----------------------------------------------------------------------------
233: Procedure pre_insert
234: (p_rec in out nocopy irc_ilp_shd.g_rec_type
235: ) is
236: --
237: Cursor C_Sel1 is select irc_location_preferences_s.nextval from sys.dual;
238: --

Line 322: ,p_rec in irc_ilp_shd.g_rec_type

318: -- {End Of Comments}
319: -- ----------------------------------------------------------------------------
320: Procedure post_insert
321: (p_effective_date in date
322: ,p_rec in irc_ilp_shd.g_rec_type
323: ) is
324: --
325: l_proc varchar2(72) := g_package||'post_insert';
326: --

Line 431: ,p_rec in out nocopy irc_ilp_shd.g_rec_type

427: -- |---------------------------------< ins >----------------------------------|
428: -- ----------------------------------------------------------------------------
429: Procedure ins
430: (p_effective_date in date
431: ,p_rec in out nocopy irc_ilp_shd.g_rec_type
432: ) is
433: --
434: l_proc varchar2(72) := g_package||'ins';
435: --

Line 516: l_rec irc_ilp_shd.g_rec_type;

512: ,p_location_pref_id out nocopy number
513: ,p_object_version_number out nocopy number
514: ) is
515: --
516: l_rec irc_ilp_shd.g_rec_type;
517: l_proc varchar2(72) := g_package||'ins';
518: --
519: Begin
520: hr_utility.set_location('Entering:'||l_proc, 5);

Line 526: irc_ilp_shd.convert_args

522: -- Call conversion function to turn arguments into the
523: -- p_rec structure.
524: --
525: l_rec :=
526: irc_ilp_shd.convert_args
527: (null
528: ,p_object_id
529: ,p_object_type
530: ,p_rec_area_id