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_INO_INS dependencies on IRC_INO_SHD

Line 76: (p_rec in out nocopy irc_ino_shd.g_rec_type

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

Line 86: irc_ino_shd.g_api_dml := true; -- Set the api dml status

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

Line 111: irc_ino_shd.g_api_dml := false; -- Unset the api dml status

107: ,length(p_rec.note_text)
108: ,1
109: ,p_rec.note_text);
110: end if;
111: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: Exception
115: When hr_api.check_integrity_violated Then

Line 117: irc_ino_shd.g_api_dml := false; -- Unset the api dml status

113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
118: irc_ino_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated

Line 118: irc_ino_shd.constraint_error

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

Line 122: irc_ino_shd.g_api_dml := false; -- Unset the api dml status

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

Line 123: irc_ino_shd.constraint_error

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

Line 127: irc_ino_shd.g_api_dml := false; -- Unset the api dml status

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

Line 128: irc_ino_shd.constraint_error

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

Line 131: irc_ino_shd.g_api_dml := false; -- Unset the api dml status

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

Line 173: (p_rec in out nocopy irc_ino_shd.g_rec_type

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

Line 260: (p_rec in irc_ino_shd.g_rec_type

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

Line 297: (p_rec in out nocopy irc_ino_shd.g_rec_type

293: -- ----------------------------------------------------------------------------
294: -- |---------------------------------< ins >----------------------------------|
295: -- ----------------------------------------------------------------------------
296: Procedure ins
297: (p_rec in out nocopy irc_ino_shd.g_rec_type
298: ) is
299: --
300: l_proc varchar2(72) := g_package||'ins';
301: --

Line 344: l_rec irc_ino_shd.g_rec_type;

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

Line 354: irc_ino_shd.convert_args

350: -- Call conversion function to turn arguments into the
351: -- p_rec structure.
352: --
353: l_rec :=
354: irc_ino_shd.convert_args
355: (null
356: ,p_offer_status_history_id
357: ,p_note_text
358: ,null