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_IDO_UPD dependencies on IRC_IDO_SHD

Line 55: (p_rec in out nocopy irc_ido_shd.g_rec_type

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

Line 66: irc_ido_shd.g_api_dml := true; -- Set the dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: irc_ido_shd.g_api_dml := true; -- Set the dml status
67: --
68: --
69: -- Update the irc_documents Row
70: --

Line 85: irc_ido_shd.g_api_dml := false; -- Unset the dml status

81: ,end_date = p_rec.end_date
82: ,character_doc = null
83: where document_id = p_rec.document_id;
84: --
85: irc_ido_shd.g_api_dml := false; -- Unset the dml status
86: --
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: --

Line 93: irc_ido_shd.g_api_dml := false; -- Unset the dml status

89: --
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: irc_ido_shd.g_api_dml := false; -- Unset the dml status
94: --
95: irc_ido_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then

Line 95: irc_ido_shd.constraint_error

91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: irc_ido_shd.g_api_dml := false; -- Unset the dml status
94: --
95: irc_ido_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: irc_ido_shd.g_api_dml := false; -- Unset the dml status

Line 99: irc_ido_shd.g_api_dml := false; -- Unset the dml status

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

Line 101: irc_ido_shd.constraint_error

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

Line 105: irc_ido_shd.g_api_dml := false; -- Unset the dml status

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

Line 107: irc_ido_shd.constraint_error

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

Line 110: irc_ido_shd.g_api_dml := false; -- Unset the dml status

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

Line 148: (p_rec in out nocopy irc_ido_shd.g_rec_type

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

Line 203: ,p_rec in irc_ido_shd.g_rec_type

199: -- {End Of Comments}
200: -- ----------------------------------------------------------------------------
201: Procedure post_update
202: (p_effective_date in date
203: ,p_rec in irc_ido_shd.g_rec_type
204: ) is
205: --
206: l_proc varchar2(72) := g_package||'post_update';
207: --

Line 236: => irc_ido_shd.g_old_rec.party_id

232: => p_rec.object_version_number
233: ,p_end_date
234: => p_rec.end_date
235: ,p_party_id_o
236: => irc_ido_shd.g_old_rec.party_id
237: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id
238: ,p_assignment_id_o
239: => irc_ido_shd.g_old_rec.assignment_id
240: ,p_file_name_o

Line 237: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id

233: ,p_end_date
234: => p_rec.end_date
235: ,p_party_id_o
236: => irc_ido_shd.g_old_rec.party_id
237: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id
238: ,p_assignment_id_o
239: => irc_ido_shd.g_old_rec.assignment_id
240: ,p_file_name_o
241: => irc_ido_shd.g_old_rec.file_name

Line 239: => irc_ido_shd.g_old_rec.assignment_id

235: ,p_party_id_o
236: => irc_ido_shd.g_old_rec.party_id
237: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id
238: ,p_assignment_id_o
239: => irc_ido_shd.g_old_rec.assignment_id
240: ,p_file_name_o
241: => irc_ido_shd.g_old_rec.file_name
242: ,p_file_format_o
243: => irc_ido_shd.g_old_rec.file_format

Line 241: => irc_ido_shd.g_old_rec.file_name

237: ,p_person_id_o => irc_ido_shd.g_old_rec.person_id
238: ,p_assignment_id_o
239: => irc_ido_shd.g_old_rec.assignment_id
240: ,p_file_name_o
241: => irc_ido_shd.g_old_rec.file_name
242: ,p_file_format_o
243: => irc_ido_shd.g_old_rec.file_format
244: ,p_mime_type_o
245: => irc_ido_shd.g_old_rec.mime_type

Line 243: => irc_ido_shd.g_old_rec.file_format

239: => irc_ido_shd.g_old_rec.assignment_id
240: ,p_file_name_o
241: => irc_ido_shd.g_old_rec.file_name
242: ,p_file_format_o
243: => irc_ido_shd.g_old_rec.file_format
244: ,p_mime_type_o
245: => irc_ido_shd.g_old_rec.mime_type
246: ,p_description_o
247: => irc_ido_shd.g_old_rec.description

Line 245: => irc_ido_shd.g_old_rec.mime_type

241: => irc_ido_shd.g_old_rec.file_name
242: ,p_file_format_o
243: => irc_ido_shd.g_old_rec.file_format
244: ,p_mime_type_o
245: => irc_ido_shd.g_old_rec.mime_type
246: ,p_description_o
247: => irc_ido_shd.g_old_rec.description
248: ,p_type_o
249: => irc_ido_shd.g_old_rec.type

Line 247: => irc_ido_shd.g_old_rec.description

243: => irc_ido_shd.g_old_rec.file_format
244: ,p_mime_type_o
245: => irc_ido_shd.g_old_rec.mime_type
246: ,p_description_o
247: => irc_ido_shd.g_old_rec.description
248: ,p_type_o
249: => irc_ido_shd.g_old_rec.type
250: ,p_object_version_number_o
251: => irc_ido_shd.g_old_rec.object_version_number

Line 249: => irc_ido_shd.g_old_rec.type

245: => irc_ido_shd.g_old_rec.mime_type
246: ,p_description_o
247: => irc_ido_shd.g_old_rec.description
248: ,p_type_o
249: => irc_ido_shd.g_old_rec.type
250: ,p_object_version_number_o
251: => irc_ido_shd.g_old_rec.object_version_number
252: ,p_end_date_o
253: => irc_ido_shd.g_old_rec.end_date

Line 251: => irc_ido_shd.g_old_rec.object_version_number

247: => irc_ido_shd.g_old_rec.description
248: ,p_type_o
249: => irc_ido_shd.g_old_rec.type
250: ,p_object_version_number_o
251: => irc_ido_shd.g_old_rec.object_version_number
252: ,p_end_date_o
253: => irc_ido_shd.g_old_rec.end_date
254: );
255: --

Line 253: => irc_ido_shd.g_old_rec.end_date

249: => irc_ido_shd.g_old_rec.type
250: ,p_object_version_number_o
251: => irc_ido_shd.g_old_rec.object_version_number
252: ,p_end_date_o
253: => irc_ido_shd.g_old_rec.end_date
254: );
255: --
256: exception
257: --

Line 313: (p_rec in out nocopy irc_ido_shd.g_rec_type

309: --
310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure convert_defs
313: (p_rec in out nocopy irc_ido_shd.g_rec_type
314: ) is
315: --
316: Begin
317: --

Line 325: irc_ido_shd.g_old_rec.party_id;

321: -- is being used then we must set to the 'current' argument value.
322: --
323: If (p_rec.party_id = hr_api.g_number) then
324: p_rec.party_id :=
325: irc_ido_shd.g_old_rec.party_id;
326: End If;
327: If (p_rec.person_id = hr_api.g_number) then
328: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;
329: End If;

Line 328: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;

324: p_rec.party_id :=
325: irc_ido_shd.g_old_rec.party_id;
326: End If;
327: If (p_rec.person_id = hr_api.g_number) then
328: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;
329: End If;
330: If (p_rec.assignment_id = hr_api.g_number) then
331: p_rec.assignment_id :=
332: irc_ido_shd.g_old_rec.assignment_id;

Line 332: irc_ido_shd.g_old_rec.assignment_id;

328: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;
329: End If;
330: If (p_rec.assignment_id = hr_api.g_number) then
331: p_rec.assignment_id :=
332: irc_ido_shd.g_old_rec.assignment_id;
333: End If;
334: If (p_rec.file_name = hr_api.g_varchar2) then
335: p_rec.file_name :=
336: irc_ido_shd.g_old_rec.file_name;

Line 336: irc_ido_shd.g_old_rec.file_name;

332: irc_ido_shd.g_old_rec.assignment_id;
333: End If;
334: If (p_rec.file_name = hr_api.g_varchar2) then
335: p_rec.file_name :=
336: irc_ido_shd.g_old_rec.file_name;
337: End If;
338: If (p_rec.file_format = hr_api.g_varchar2) then
339: p_rec.file_format :=
340: irc_ido_shd.g_old_rec.file_format;

Line 340: irc_ido_shd.g_old_rec.file_format;

336: irc_ido_shd.g_old_rec.file_name;
337: End If;
338: If (p_rec.file_format = hr_api.g_varchar2) then
339: p_rec.file_format :=
340: irc_ido_shd.g_old_rec.file_format;
341: End If;
342: If (p_rec.mime_type = hr_api.g_varchar2) then
343: p_rec.mime_type :=
344: irc_ido_shd.g_old_rec.mime_type;

Line 344: irc_ido_shd.g_old_rec.mime_type;

340: irc_ido_shd.g_old_rec.file_format;
341: End If;
342: If (p_rec.mime_type = hr_api.g_varchar2) then
343: p_rec.mime_type :=
344: irc_ido_shd.g_old_rec.mime_type;
345: End If;
346: If (p_rec.description = hr_api.g_varchar2) then
347: p_rec.description :=
348: irc_ido_shd.g_old_rec.description;

Line 348: irc_ido_shd.g_old_rec.description;

344: irc_ido_shd.g_old_rec.mime_type;
345: End If;
346: If (p_rec.description = hr_api.g_varchar2) then
347: p_rec.description :=
348: irc_ido_shd.g_old_rec.description;
349: End If;
350: If (p_rec.type = hr_api.g_varchar2) then
351: p_rec.type :=
352: irc_ido_shd.g_old_rec.type;

Line 352: irc_ido_shd.g_old_rec.type;

348: irc_ido_shd.g_old_rec.description;
349: End If;
350: If (p_rec.type = hr_api.g_varchar2) then
351: p_rec.type :=
352: irc_ido_shd.g_old_rec.type;
353: End If;
354: If (p_rec.end_date = hr_api.g_date) then
355: p_rec.end_date :=
356: irc_ido_shd.g_old_rec.end_date;

Line 356: irc_ido_shd.g_old_rec.end_date;

352: irc_ido_shd.g_old_rec.type;
353: End If;
354: If (p_rec.end_date = hr_api.g_date) then
355: p_rec.end_date :=
356: irc_ido_shd.g_old_rec.end_date;
357: End If;
358: --
359: End convert_defs;
360: --

Line 366: ,p_rec in out nocopy irc_ido_shd.g_rec_type

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

Line 376: irc_ido_shd.lck

372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- We must lock the row which we need to update.
375: --
376: irc_ido_shd.lck
377: (p_rec.document_id
378: ,p_rec.object_version_number
379: );
380: --

Line 398: p_rec.party_id := irc_ido_shd.g_old_rec.party_id;

394: --
395: irc_ido_upd.pre_update(p_rec);
396: --
397: if p_rec.party_id is null then
398: p_rec.party_id := irc_ido_shd.g_old_rec.party_id;
399: end if;
400: if p_rec.person_id is null then
401: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;
402: end if;

Line 401: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;

397: if p_rec.party_id is null then
398: p_rec.party_id := irc_ido_shd.g_old_rec.party_id;
399: end if;
400: if p_rec.person_id is null then
401: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;
402: end if;
403: if p_rec.assignment_id is null then
404: p_rec.assignment_id := irc_ido_shd.g_old_rec.assignment_id;
405: end if;

Line 404: p_rec.assignment_id := irc_ido_shd.g_old_rec.assignment_id;

400: if p_rec.person_id is null then
401: p_rec.person_id := irc_ido_shd.g_old_rec.person_id;
402: end if;
403: if p_rec.assignment_id is null then
404: p_rec.assignment_id := irc_ido_shd.g_old_rec.assignment_id;
405: end if;
406:
407: --
408: -- Update the row.

Line 434: l_rec irc_ido_shd.g_rec_type;

430: ,p_description in varchar2 default hr_api.g_varchar2
431: ,p_end_date in date default hr_api.g_date
432: ) is
433: --
434: l_rec irc_ido_shd.g_rec_type;
435: l_proc varchar2(72) := g_package||'upd';
436: --
437: Begin
438: hr_utility.set_location('Entering:'||l_proc, 5);

Line 444: irc_ido_shd.convert_args

440: -- Call conversion function to turn arguments into the
441: -- l_rec structure.
442: --
443: l_rec :=
444: irc_ido_shd.convert_args
445: (p_document_id
446: ,null
447: ,null
448: ,null