DBA Data[Home] [Help]

APPS.IRC_ITA_UPD dependencies on IRC_ITA_SHD

Line 55: (p_rec in out nocopy irc_ita_shd.g_rec_type

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

Line 91: irc_ita_shd.constraint_error

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

Line 96: irc_ita_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: --
96: irc_ita_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --

Line 101: irc_ita_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: --
101: irc_ita_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: --
105: Raise;

Line 141: (p_rec in irc_ita_shd.g_rec_type

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_update
141: (p_rec in irc_ita_shd.g_rec_type
142: ) is
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --

Line 186: ,p_rec in irc_ita_shd.g_rec_type

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

Line 216: => irc_ita_shd.g_old_rec.template_id

212: => p_rec.end_date
213: ,p_object_version_number
214: => p_rec.object_version_number
215: ,p_template_id_o
216: => irc_ita_shd.g_old_rec.template_id
217: ,p_default_association_o
218: => irc_ita_shd.g_old_rec.default_association
219: ,p_job_id_o
220: => irc_ita_shd.g_old_rec.job_id

Line 218: => irc_ita_shd.g_old_rec.default_association

214: => p_rec.object_version_number
215: ,p_template_id_o
216: => irc_ita_shd.g_old_rec.template_id
217: ,p_default_association_o
218: => irc_ita_shd.g_old_rec.default_association
219: ,p_job_id_o
220: => irc_ita_shd.g_old_rec.job_id
221: ,p_position_id_o
222: => irc_ita_shd.g_old_rec.position_id

Line 220: => irc_ita_shd.g_old_rec.job_id

216: => irc_ita_shd.g_old_rec.template_id
217: ,p_default_association_o
218: => irc_ita_shd.g_old_rec.default_association
219: ,p_job_id_o
220: => irc_ita_shd.g_old_rec.job_id
221: ,p_position_id_o
222: => irc_ita_shd.g_old_rec.position_id
223: ,p_organization_id_o
224: => irc_ita_shd.g_old_rec.organization_id

Line 222: => irc_ita_shd.g_old_rec.position_id

218: => irc_ita_shd.g_old_rec.default_association
219: ,p_job_id_o
220: => irc_ita_shd.g_old_rec.job_id
221: ,p_position_id_o
222: => irc_ita_shd.g_old_rec.position_id
223: ,p_organization_id_o
224: => irc_ita_shd.g_old_rec.organization_id
225: ,p_start_date_o
226: => irc_ita_shd.g_old_rec.start_date

Line 224: => irc_ita_shd.g_old_rec.organization_id

220: => irc_ita_shd.g_old_rec.job_id
221: ,p_position_id_o
222: => irc_ita_shd.g_old_rec.position_id
223: ,p_organization_id_o
224: => irc_ita_shd.g_old_rec.organization_id
225: ,p_start_date_o
226: => irc_ita_shd.g_old_rec.start_date
227: ,p_end_date_o
228: => irc_ita_shd.g_old_rec.end_date

Line 226: => irc_ita_shd.g_old_rec.start_date

222: => irc_ita_shd.g_old_rec.position_id
223: ,p_organization_id_o
224: => irc_ita_shd.g_old_rec.organization_id
225: ,p_start_date_o
226: => irc_ita_shd.g_old_rec.start_date
227: ,p_end_date_o
228: => irc_ita_shd.g_old_rec.end_date
229: ,p_object_version_number_o
230: => irc_ita_shd.g_old_rec.object_version_number

Line 228: => irc_ita_shd.g_old_rec.end_date

224: => irc_ita_shd.g_old_rec.organization_id
225: ,p_start_date_o
226: => irc_ita_shd.g_old_rec.start_date
227: ,p_end_date_o
228: => irc_ita_shd.g_old_rec.end_date
229: ,p_object_version_number_o
230: => irc_ita_shd.g_old_rec.object_version_number
231: );
232: --

Line 230: => irc_ita_shd.g_old_rec.object_version_number

226: => irc_ita_shd.g_old_rec.start_date
227: ,p_end_date_o
228: => irc_ita_shd.g_old_rec.end_date
229: ,p_object_version_number_o
230: => irc_ita_shd.g_old_rec.object_version_number
231: );
232: --
233: exception
234: --

Line 290: (p_rec in out nocopy irc_ita_shd.g_rec_type

286: --
287: -- {End Of Comments}
288: -- ----------------------------------------------------------------------------
289: Procedure convert_defs
290: (p_rec in out nocopy irc_ita_shd.g_rec_type
291: ) is
292: --
293: Begin
294: --

Line 302: irc_ita_shd.g_old_rec.template_id;

298: -- is being used then we must set to the 'current' argument value.
299: --
300: If (p_rec.template_id = hr_api.g_number) then
301: p_rec.template_id :=
302: irc_ita_shd.g_old_rec.template_id;
303: End If;
304: If (p_rec.default_association = hr_api.g_varchar2) then
305: p_rec.default_association :=
306: irc_ita_shd.g_old_rec.default_association;

Line 306: irc_ita_shd.g_old_rec.default_association;

302: irc_ita_shd.g_old_rec.template_id;
303: End If;
304: If (p_rec.default_association = hr_api.g_varchar2) then
305: p_rec.default_association :=
306: irc_ita_shd.g_old_rec.default_association;
307: End If;
308: If (p_rec.job_id = hr_api.g_number) then
309: p_rec.job_id :=
310: irc_ita_shd.g_old_rec.job_id;

Line 310: irc_ita_shd.g_old_rec.job_id;

306: irc_ita_shd.g_old_rec.default_association;
307: End If;
308: If (p_rec.job_id = hr_api.g_number) then
309: p_rec.job_id :=
310: irc_ita_shd.g_old_rec.job_id;
311: End If;
312: If (p_rec.position_id = hr_api.g_number) then
313: p_rec.position_id :=
314: irc_ita_shd.g_old_rec.position_id;

Line 314: irc_ita_shd.g_old_rec.position_id;

310: irc_ita_shd.g_old_rec.job_id;
311: End If;
312: If (p_rec.position_id = hr_api.g_number) then
313: p_rec.position_id :=
314: irc_ita_shd.g_old_rec.position_id;
315: End If;
316: If (p_rec.organization_id = hr_api.g_number) then
317: p_rec.organization_id :=
318: irc_ita_shd.g_old_rec.organization_id;

Line 318: irc_ita_shd.g_old_rec.organization_id;

314: irc_ita_shd.g_old_rec.position_id;
315: End If;
316: If (p_rec.organization_id = hr_api.g_number) then
317: p_rec.organization_id :=
318: irc_ita_shd.g_old_rec.organization_id;
319: End If;
320: If (p_rec.start_date = hr_api.g_date) then
321: p_rec.start_date :=
322: irc_ita_shd.g_old_rec.start_date;

Line 322: irc_ita_shd.g_old_rec.start_date;

318: irc_ita_shd.g_old_rec.organization_id;
319: End If;
320: If (p_rec.start_date = hr_api.g_date) then
321: p_rec.start_date :=
322: irc_ita_shd.g_old_rec.start_date;
323: End If;
324: If (p_rec.end_date = hr_api.g_date) then
325: p_rec.end_date :=
326: irc_ita_shd.g_old_rec.end_date;

Line 326: irc_ita_shd.g_old_rec.end_date;

322: irc_ita_shd.g_old_rec.start_date;
323: End If;
324: If (p_rec.end_date = hr_api.g_date) then
325: p_rec.end_date :=
326: irc_ita_shd.g_old_rec.end_date;
327: End If;
328: --
329: End convert_defs;
330: --

Line 336: ,p_rec in out nocopy irc_ita_shd.g_rec_type

332: -- |---------------------------------< upd >----------------------------------|
333: -- ----------------------------------------------------------------------------
334: Procedure upd
335: (p_effective_date in date
336: ,p_rec in out nocopy irc_ita_shd.g_rec_type
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'upd';
340: --

Line 346: irc_ita_shd.lck

342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- We must lock the row which we need to update.
345: --
346: irc_ita_shd.lck
347: (p_rec.template_association_id
348: ,p_rec.object_version_number
349: );
350: --

Line 401: l_rec irc_ita_shd.g_rec_type;

397: ,p_start_date in date default hr_api.g_date
398: ,p_end_date in date default hr_api.g_date
399: ) is
400: --
401: l_rec irc_ita_shd.g_rec_type;
402: l_proc varchar2(72) := g_package||'upd';
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);

Line 411: irc_ita_shd.convert_args

407: -- Call conversion function to turn arguments into the
408: -- l_rec structure.
409: --
410: l_rec :=
411: irc_ita_shd.convert_args
412: (p_template_association_id
413: ,p_template_id
414: ,p_default_association
415: ,p_job_id