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

Line 56: (p_rec in out nocopy irc_ino_shd.g_rec_type

52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy irc_ino_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: l_note_text clob;

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

64: --
65: -- Increment the object version
66: p_rec.object_version_number := p_rec.object_version_number + 1;
67: --
68: irc_ino_shd.g_api_dml := true; -- Set the api dml status
69: --
70: -- Update the irc_notes Row
71: --
72: update irc_notes

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

87: ,length(p_rec.note_text)
88: ,1
89: ,p_rec.note_text);
90: end if;
91: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
92: --
93: hr_utility.set_location(' Leaving:'||l_proc, 10);
94: --
95: Exception

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

94: --
95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
99: irc_ino_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated

Line 99: irc_ino_shd.constraint_error

95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
99: irc_ino_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.parent_integrity_violated Then
102: -- Parent integrity has been violated
103: irc_ino_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 104: irc_ino_shd.constraint_error

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

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

104: irc_ino_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
109: irc_ino_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: irc_ino_shd.g_api_dml := false; -- Unset the api dml status

Line 109: irc_ino_shd.constraint_error

105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.unique_integrity_violated Then
107: -- Unique integrity has been violated
108: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
109: irc_ino_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;

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

108: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
109: irc_ino_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: irc_ino_shd.g_api_dml := false; -- Unset the api dml status
113: Raise;
114: End update_dml;
115: --
116: -- ----------------------------------------------------------------------------

Line 149: (p_rec in irc_ino_shd.g_rec_type

145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_update
149: (p_rec in irc_ino_shd.g_rec_type
150: ) is
151: --
152: l_proc varchar2(72) := g_package||'pre_update';
153: --

Line 193: (p_rec in irc_ino_shd.g_rec_type

189: --
190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure post_update
193: (p_rec in irc_ino_shd.g_rec_type
194: ) is
195: --
196: l_proc varchar2(72) := g_package||'post_update';
197: --

Line 212: => irc_ino_shd.g_old_rec.offer_status_history_id

208: => p_rec.note_text
209: ,p_object_version_number
210: => p_rec.object_version_number
211: ,p_offer_status_history_id_o
212: => irc_ino_shd.g_old_rec.offer_status_history_id
213: ,p_note_text_o
214: => irc_ino_shd.g_old_rec.note_text
215: ,p_object_version_number_o
216: => irc_ino_shd.g_old_rec.object_version_number

Line 214: => irc_ino_shd.g_old_rec.note_text

210: => p_rec.object_version_number
211: ,p_offer_status_history_id_o
212: => irc_ino_shd.g_old_rec.offer_status_history_id
213: ,p_note_text_o
214: => irc_ino_shd.g_old_rec.note_text
215: ,p_object_version_number_o
216: => irc_ino_shd.g_old_rec.object_version_number
217: );
218: --

Line 216: => irc_ino_shd.g_old_rec.object_version_number

212: => irc_ino_shd.g_old_rec.offer_status_history_id
213: ,p_note_text_o
214: => irc_ino_shd.g_old_rec.note_text
215: ,p_object_version_number_o
216: => irc_ino_shd.g_old_rec.object_version_number
217: );
218: --
219: exception
220: --

Line 276: (p_rec in out nocopy irc_ino_shd.g_rec_type

272: --
273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure convert_defs
276: (p_rec in out nocopy irc_ino_shd.g_rec_type
277: ) is
278: --
279: Begin
280: --

Line 288: irc_ino_shd.g_old_rec.offer_status_history_id;

284: -- is being used then we must set to the 'current' argument value.
285: --
286: If (p_rec.offer_status_history_id = hr_api.g_number) then
287: p_rec.offer_status_history_id :=
288: irc_ino_shd.g_old_rec.offer_status_history_id;
289: End If;
290: If (p_rec.note_text = hr_api.g_varchar2) then
291: p_rec.note_text :=
292: irc_ino_shd.g_old_rec.note_text;

Line 292: irc_ino_shd.g_old_rec.note_text;

288: irc_ino_shd.g_old_rec.offer_status_history_id;
289: End If;
290: If (p_rec.note_text = hr_api.g_varchar2) then
291: p_rec.note_text :=
292: irc_ino_shd.g_old_rec.note_text;
293: g_note_text:=false;
294: Else
295: g_note_text:=true;
296: End If;

Line 304: (p_rec in out nocopy irc_ino_shd.g_rec_type

300: -- ----------------------------------------------------------------------------
301: -- |---------------------------------< upd >----------------------------------|
302: -- ----------------------------------------------------------------------------
303: Procedure upd
304: (p_rec in out nocopy irc_ino_shd.g_rec_type
305: ) is
306: --
307: l_proc varchar2(72) := g_package||'upd';
308: --

Line 314: irc_ino_shd.lck

310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: -- We must lock the row which we need to update.
313: --
314: irc_ino_shd.lck
315: (p_rec.note_id
316: ,p_rec.object_version_number
317: );
318: --

Line 361: l_rec irc_ino_shd.g_rec_type;

357: ,p_offer_status_history_id in number default hr_api.g_number
358: ,p_note_text in varchar2 default hr_api.g_varchar2
359: ) is
360: --
361: l_rec irc_ino_shd.g_rec_type;
362: l_proc varchar2(72) := g_package||'upd';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);

Line 371: irc_ino_shd.convert_args

367: -- Call conversion function to turn arguments into the
368: -- l_rec structure.
369: --
370: l_rec :=
371: irc_ino_shd.convert_args
372: (p_note_id
373: ,p_offer_status_history_id
374: ,p_note_text
375: ,p_object_version_number