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_RSE_INS dependencies on IRC_RSE_SHD

Line 76: (p_rec in out nocopy irc_rse_shd.g_rec_type

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

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

Line 187: irc_rse_shd.g_api_dml := false; -- Unset the api dml status

183: ,p_rec.posting_impl_class
184: );
185: --
186: --
187: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated

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

188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
193: --
194: irc_rse_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then

Line 194: irc_rse_shd.constraint_error

190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
193: --
194: irc_rse_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: irc_rse_shd.g_api_dml := false; -- Unset the api dml status

Line 198: irc_rse_shd.g_api_dml := false; -- Unset the api dml status

194: irc_rse_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
199: --
200: irc_rse_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then

Line 200: irc_rse_shd.constraint_error

196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
199: --
200: irc_rse_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: irc_rse_shd.g_api_dml := false; -- Unset the api dml status

Line 204: irc_rse_shd.g_api_dml := false; -- Unset the api dml status

200: irc_rse_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
205: --
206: irc_rse_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then

Line 206: irc_rse_shd.constraint_error

202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
205: --
206: irc_rse_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
210: --

Line 209: irc_rse_shd.g_api_dml := false; -- Unset the api dml status

205: --
206: irc_rse_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
210: --
211: Raise;
212: End insert_dml;
213: --

Line 252: (p_rec in out nocopy irc_rse_shd.g_rec_type

248: --
249: -- {End Of Comments}
250: -- ----------------------------------------------------------------------------
251: Procedure pre_insert
252: (p_rec in out nocopy irc_rse_shd.g_rec_type
253: ) is
254: --
255: Cursor C_Sel1 is select irc_all_recruiting_sites_s.nextval from sys.dual;
256: --

Line 340: ,p_rec in irc_rse_shd.g_rec_type

336: -- {End Of Comments}
337: -- ----------------------------------------------------------------------------
338: Procedure post_insert
339: (p_effective_date in date
340: ,p_rec in irc_rse_shd.g_rec_type
341: ) is
342: --
343: l_proc varchar2(72) := g_package||'post_insert';
344: --

Line 463: ,p_rec in out nocopy irc_rse_shd.g_rec_type

459: -- |---------------------------------< ins >----------------------------------|
460: -- ----------------------------------------------------------------------------
461: Procedure ins
462: (p_effective_date in date
463: ,p_rec in out nocopy irc_rse_shd.g_rec_type
464: ) is
465: --
466: l_proc varchar2(72) := g_package||'ins';
467: --

Line 555: l_rec irc_rse_shd.g_rec_type;

551: ,p_object_version_number out nocopy number
552: ,p_posting_impl_class in varchar2 default null
553: ) is
554: --
555: l_rec irc_rse_shd.g_rec_type;
556: l_proc varchar2(72) := g_package||'ins';
557: --
558: Begin
559: hr_utility.set_location('Entering:'||l_proc, 5);

Line 565: irc_rse_shd.convert_args

561: -- Call conversion function to turn arguments into the
562: -- p_rec structure.
563: --
564: l_rec :=
565: irc_rse_shd.convert_args
566: (null
567: ,p_date_from
568: ,p_date_to
569: ,p_posting_username