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_CMM_UPD dependencies on IRC_CMM_SHD

Line 55: (p_rec in out nocopy irc_cmm_shd.g_rec_type

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

Line 94: irc_cmm_shd.constraint_error

90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: --
94: irc_cmm_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --

Line 99: irc_cmm_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: irc_cmm_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --

Line 104: irc_cmm_shd.constraint_error

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: irc_cmm_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: --
108: Raise;

Line 144: (p_rec in irc_cmm_shd.g_rec_type

140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure pre_update
144: (p_rec in irc_cmm_shd.g_rec_type
145: ) is
146: --
147: l_proc varchar2(72) := g_package||'pre_update';
148: --

Line 189: ,p_rec in irc_cmm_shd.g_rec_type

185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure post_update
188: (p_effective_date in date
189: ,p_rec in irc_cmm_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'post_update';
193: --

Line 225: => irc_cmm_shd.g_old_rec.parent_id

221: => p_rec.deleted_flag
222: ,p_object_version_number
223: => p_rec.object_version_number
224: ,p_parent_id_o
225: => irc_cmm_shd.g_old_rec.parent_id
226: ,p_communication_topic_id_o
227: => irc_cmm_shd.g_old_rec.communication_topic_id
228: ,p_message_subject_o
229: => irc_cmm_shd.g_old_rec.message_subject

Line 227: => irc_cmm_shd.g_old_rec.communication_topic_id

223: => p_rec.object_version_number
224: ,p_parent_id_o
225: => irc_cmm_shd.g_old_rec.parent_id
226: ,p_communication_topic_id_o
227: => irc_cmm_shd.g_old_rec.communication_topic_id
228: ,p_message_subject_o
229: => irc_cmm_shd.g_old_rec.message_subject
230: ,p_message_body_o
231: => irc_cmm_shd.g_old_rec.message_body

Line 229: => irc_cmm_shd.g_old_rec.message_subject

225: => irc_cmm_shd.g_old_rec.parent_id
226: ,p_communication_topic_id_o
227: => irc_cmm_shd.g_old_rec.communication_topic_id
228: ,p_message_subject_o
229: => irc_cmm_shd.g_old_rec.message_subject
230: ,p_message_body_o
231: => irc_cmm_shd.g_old_rec.message_body
232: ,p_message_post_date_o
233: => irc_cmm_shd.g_old_rec.message_post_date

Line 231: => irc_cmm_shd.g_old_rec.message_body

227: => irc_cmm_shd.g_old_rec.communication_topic_id
228: ,p_message_subject_o
229: => irc_cmm_shd.g_old_rec.message_subject
230: ,p_message_body_o
231: => irc_cmm_shd.g_old_rec.message_body
232: ,p_message_post_date_o
233: => irc_cmm_shd.g_old_rec.message_post_date
234: ,p_sender_type_o
235: => irc_cmm_shd.g_old_rec.sender_type

Line 233: => irc_cmm_shd.g_old_rec.message_post_date

229: => irc_cmm_shd.g_old_rec.message_subject
230: ,p_message_body_o
231: => irc_cmm_shd.g_old_rec.message_body
232: ,p_message_post_date_o
233: => irc_cmm_shd.g_old_rec.message_post_date
234: ,p_sender_type_o
235: => irc_cmm_shd.g_old_rec.sender_type
236: ,p_sender_id_o
237: => irc_cmm_shd.g_old_rec.sender_id

Line 235: => irc_cmm_shd.g_old_rec.sender_type

231: => irc_cmm_shd.g_old_rec.message_body
232: ,p_message_post_date_o
233: => irc_cmm_shd.g_old_rec.message_post_date
234: ,p_sender_type_o
235: => irc_cmm_shd.g_old_rec.sender_type
236: ,p_sender_id_o
237: => irc_cmm_shd.g_old_rec.sender_id
238: ,p_document_type_o
239: => irc_cmm_shd.g_old_rec.document_type

Line 237: => irc_cmm_shd.g_old_rec.sender_id

233: => irc_cmm_shd.g_old_rec.message_post_date
234: ,p_sender_type_o
235: => irc_cmm_shd.g_old_rec.sender_type
236: ,p_sender_id_o
237: => irc_cmm_shd.g_old_rec.sender_id
238: ,p_document_type_o
239: => irc_cmm_shd.g_old_rec.document_type
240: ,p_document_id_o
241: => irc_cmm_shd.g_old_rec.document_id

Line 239: => irc_cmm_shd.g_old_rec.document_type

235: => irc_cmm_shd.g_old_rec.sender_type
236: ,p_sender_id_o
237: => irc_cmm_shd.g_old_rec.sender_id
238: ,p_document_type_o
239: => irc_cmm_shd.g_old_rec.document_type
240: ,p_document_id_o
241: => irc_cmm_shd.g_old_rec.document_id
242: ,p_deleted_flag_o
243: => irc_cmm_shd.g_old_rec.deleted_flag

Line 241: => irc_cmm_shd.g_old_rec.document_id

237: => irc_cmm_shd.g_old_rec.sender_id
238: ,p_document_type_o
239: => irc_cmm_shd.g_old_rec.document_type
240: ,p_document_id_o
241: => irc_cmm_shd.g_old_rec.document_id
242: ,p_deleted_flag_o
243: => irc_cmm_shd.g_old_rec.deleted_flag
244: ,p_object_version_number_o
245: => irc_cmm_shd.g_old_rec.object_version_number

Line 243: => irc_cmm_shd.g_old_rec.deleted_flag

239: => irc_cmm_shd.g_old_rec.document_type
240: ,p_document_id_o
241: => irc_cmm_shd.g_old_rec.document_id
242: ,p_deleted_flag_o
243: => irc_cmm_shd.g_old_rec.deleted_flag
244: ,p_object_version_number_o
245: => irc_cmm_shd.g_old_rec.object_version_number
246: );
247: --

Line 245: => irc_cmm_shd.g_old_rec.object_version_number

241: => irc_cmm_shd.g_old_rec.document_id
242: ,p_deleted_flag_o
243: => irc_cmm_shd.g_old_rec.deleted_flag
244: ,p_object_version_number_o
245: => irc_cmm_shd.g_old_rec.object_version_number
246: );
247: --
248: exception
249: --

Line 305: (p_rec in out nocopy irc_cmm_shd.g_rec_type

301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure convert_defs
305: (p_rec in out nocopy irc_cmm_shd.g_rec_type
306: ) is
307: --
308: Begin
309: --

Line 317: irc_cmm_shd.g_old_rec.parent_id;

313: -- is being used then we must set to the 'current' argument value.
314: --
315: If (p_rec.parent_id = hr_api.g_number) then
316: p_rec.parent_id :=
317: irc_cmm_shd.g_old_rec.parent_id;
318: End If;
319: If (p_rec.communication_topic_id = hr_api.g_number) then
320: p_rec.communication_topic_id :=
321: irc_cmm_shd.g_old_rec.communication_topic_id;

Line 321: irc_cmm_shd.g_old_rec.communication_topic_id;

317: irc_cmm_shd.g_old_rec.parent_id;
318: End If;
319: If (p_rec.communication_topic_id = hr_api.g_number) then
320: p_rec.communication_topic_id :=
321: irc_cmm_shd.g_old_rec.communication_topic_id;
322: End If;
323: If (p_rec.message_subject = hr_api.g_varchar2) then
324: p_rec.message_subject :=
325: irc_cmm_shd.g_old_rec.message_subject;

Line 325: irc_cmm_shd.g_old_rec.message_subject;

321: irc_cmm_shd.g_old_rec.communication_topic_id;
322: End If;
323: If (p_rec.message_subject = hr_api.g_varchar2) then
324: p_rec.message_subject :=
325: irc_cmm_shd.g_old_rec.message_subject;
326: End If;
327: If (p_rec.message_body = hr_api.g_varchar2) then
328: p_rec.message_body :=
329: irc_cmm_shd.g_old_rec.message_body;

Line 329: irc_cmm_shd.g_old_rec.message_body;

325: irc_cmm_shd.g_old_rec.message_subject;
326: End If;
327: If (p_rec.message_body = hr_api.g_varchar2) then
328: p_rec.message_body :=
329: irc_cmm_shd.g_old_rec.message_body;
330: End If;
331: If (p_rec.message_post_date = hr_api.g_date) then
332: p_rec.message_post_date :=
333: irc_cmm_shd.g_old_rec.message_post_date;

Line 333: irc_cmm_shd.g_old_rec.message_post_date;

329: irc_cmm_shd.g_old_rec.message_body;
330: End If;
331: If (p_rec.message_post_date = hr_api.g_date) then
332: p_rec.message_post_date :=
333: irc_cmm_shd.g_old_rec.message_post_date;
334: End If;
335: If (p_rec.sender_type = hr_api.g_varchar2) then
336: p_rec.sender_type :=
337: irc_cmm_shd.g_old_rec.sender_type;

Line 337: irc_cmm_shd.g_old_rec.sender_type;

333: irc_cmm_shd.g_old_rec.message_post_date;
334: End If;
335: If (p_rec.sender_type = hr_api.g_varchar2) then
336: p_rec.sender_type :=
337: irc_cmm_shd.g_old_rec.sender_type;
338: End If;
339: If (p_rec.sender_id = hr_api.g_number) then
340: p_rec.sender_id :=
341: irc_cmm_shd.g_old_rec.sender_id;

Line 341: irc_cmm_shd.g_old_rec.sender_id;

337: irc_cmm_shd.g_old_rec.sender_type;
338: End If;
339: If (p_rec.sender_id = hr_api.g_number) then
340: p_rec.sender_id :=
341: irc_cmm_shd.g_old_rec.sender_id;
342: End If;
343: If (p_rec.document_type = hr_api.g_varchar2) then
344: p_rec.document_type :=
345: irc_cmm_shd.g_old_rec.document_type;

Line 345: irc_cmm_shd.g_old_rec.document_type;

341: irc_cmm_shd.g_old_rec.sender_id;
342: End If;
343: If (p_rec.document_type = hr_api.g_varchar2) then
344: p_rec.document_type :=
345: irc_cmm_shd.g_old_rec.document_type;
346: End If;
347: If (p_rec.document_id = hr_api.g_number) then
348: p_rec.document_id :=
349: irc_cmm_shd.g_old_rec.document_id;

Line 349: irc_cmm_shd.g_old_rec.document_id;

345: irc_cmm_shd.g_old_rec.document_type;
346: End If;
347: If (p_rec.document_id = hr_api.g_number) then
348: p_rec.document_id :=
349: irc_cmm_shd.g_old_rec.document_id;
350: End If;
351: If (p_rec.deleted_flag = hr_api.g_varchar2) then
352: p_rec.deleted_flag :=
353: irc_cmm_shd.g_old_rec.deleted_flag;

Line 353: irc_cmm_shd.g_old_rec.deleted_flag;

349: irc_cmm_shd.g_old_rec.document_id;
350: End If;
351: If (p_rec.deleted_flag = hr_api.g_varchar2) then
352: p_rec.deleted_flag :=
353: irc_cmm_shd.g_old_rec.deleted_flag;
354: End If;
355: --
356: End convert_defs;
357: --

Line 363: ,p_rec in out nocopy irc_cmm_shd.g_rec_type

359: -- |---------------------------------< upd >----------------------------------|
360: -- ----------------------------------------------------------------------------
361: Procedure upd
362: (p_effective_date in date
363: ,p_rec in out nocopy irc_cmm_shd.g_rec_type
364: ) is
365: --
366: l_proc varchar2(72) := g_package||'upd';
367: --

Line 373: irc_cmm_shd.lck

369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: -- We must lock the row which we need to update.
372: --
373: irc_cmm_shd.lck
374: (p_rec.communication_message_id
375: ,p_rec.object_version_number
376: );
377: --

Line 431: l_rec irc_cmm_shd.g_rec_type;

427: ,p_document_id in number default hr_api.g_number
428: ,p_deleted_flag in varchar2 default hr_api.g_varchar2
429: ) is
430: --
431: l_rec irc_cmm_shd.g_rec_type;
432: l_proc varchar2(72) := g_package||'upd';
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);

Line 441: irc_cmm_shd.convert_args

437: -- Call conversion function to turn arguments into the
438: -- l_rec structure.
439: --
440: l_rec :=
441: irc_cmm_shd.convert_args
442: (p_communication_message_id
443: ,p_parent_id
444: ,p_communication_topic_id
445: ,p_message_subject