[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy hr_oru_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: hr_oru_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the hr_all_organization_units Row
69: --
70: update hr_all_organization_units
117: --End Enhancement 4040086
118: ,object_version_number = p_rec.object_version_number
119: where organization_id = p_rec.organization_id;
120: --
121: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: --
125: Exception
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
129: hr_oru_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
129: hr_oru_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
129: hr_oru_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
134: hr_oru_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
134: hr_oru_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
134: hr_oru_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
139: hr_oru_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
139: hr_oru_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
143: Raise;
138: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
139: hr_oru_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: hr_oru_shd.g_api_dml := false; -- Unset the api dml status
143: Raise;
144: End update_dml;
145: --
146: -- ----------------------------------------------------------------------------
175: --
176: -- {End Of Comments}
177: -- ----------------------------------------------------------------------------
178: Procedure pre_update
179: (p_rec in hr_oru_shd.g_rec_type
180: ) is
181: --
182: l_proc varchar2(72) := g_package||'pre_update';
183: --
220: -- {End Of Comments}
221: -- ----------------------------------------------------------------------------
222: Procedure post_update
223: (p_effective_date in date
224: ,p_rec in hr_oru_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72) := g_package||'post_update';
228: --
322: --End Enhacement 4040086
323: ,p_object_version_number
324: => p_rec.object_version_number
325: ,p_business_group_id_o
326: => hr_oru_shd.g_old_rec.business_group_id
327: ,p_cost_allocation_keyflex_id_o
328: => hr_oru_shd.g_old_rec.cost_allocation_keyflex_id
329: ,p_location_id_o
330: => hr_oru_shd.g_old_rec.location_id
324: => p_rec.object_version_number
325: ,p_business_group_id_o
326: => hr_oru_shd.g_old_rec.business_group_id
327: ,p_cost_allocation_keyflex_id_o
328: => hr_oru_shd.g_old_rec.cost_allocation_keyflex_id
329: ,p_location_id_o
330: => hr_oru_shd.g_old_rec.location_id
331: ,p_soft_coding_keyflex_id_o
332: => hr_oru_shd.g_old_rec.soft_coding_keyflex_id
326: => hr_oru_shd.g_old_rec.business_group_id
327: ,p_cost_allocation_keyflex_id_o
328: => hr_oru_shd.g_old_rec.cost_allocation_keyflex_id
329: ,p_location_id_o
330: => hr_oru_shd.g_old_rec.location_id
331: ,p_soft_coding_keyflex_id_o
332: => hr_oru_shd.g_old_rec.soft_coding_keyflex_id
333: ,p_date_from_o
334: => hr_oru_shd.g_old_rec.date_from
328: => hr_oru_shd.g_old_rec.cost_allocation_keyflex_id
329: ,p_location_id_o
330: => hr_oru_shd.g_old_rec.location_id
331: ,p_soft_coding_keyflex_id_o
332: => hr_oru_shd.g_old_rec.soft_coding_keyflex_id
333: ,p_date_from_o
334: => hr_oru_shd.g_old_rec.date_from
335: ,p_name_o
336: => hr_oru_shd.g_old_rec.name
330: => hr_oru_shd.g_old_rec.location_id
331: ,p_soft_coding_keyflex_id_o
332: => hr_oru_shd.g_old_rec.soft_coding_keyflex_id
333: ,p_date_from_o
334: => hr_oru_shd.g_old_rec.date_from
335: ,p_name_o
336: => hr_oru_shd.g_old_rec.name
337: ,p_comments_o
338: => hr_oru_shd.g_old_rec.comments
332: => hr_oru_shd.g_old_rec.soft_coding_keyflex_id
333: ,p_date_from_o
334: => hr_oru_shd.g_old_rec.date_from
335: ,p_name_o
336: => hr_oru_shd.g_old_rec.name
337: ,p_comments_o
338: => hr_oru_shd.g_old_rec.comments
339: ,p_date_to_o
340: => hr_oru_shd.g_old_rec.date_to
334: => hr_oru_shd.g_old_rec.date_from
335: ,p_name_o
336: => hr_oru_shd.g_old_rec.name
337: ,p_comments_o
338: => hr_oru_shd.g_old_rec.comments
339: ,p_date_to_o
340: => hr_oru_shd.g_old_rec.date_to
341: ,p_internal_external_flag_o
342: => hr_oru_shd.g_old_rec.internal_external_flag
336: => hr_oru_shd.g_old_rec.name
337: ,p_comments_o
338: => hr_oru_shd.g_old_rec.comments
339: ,p_date_to_o
340: => hr_oru_shd.g_old_rec.date_to
341: ,p_internal_external_flag_o
342: => hr_oru_shd.g_old_rec.internal_external_flag
343: ,p_internal_address_line_o
344: => hr_oru_shd.g_old_rec.internal_address_line
338: => hr_oru_shd.g_old_rec.comments
339: ,p_date_to_o
340: => hr_oru_shd.g_old_rec.date_to
341: ,p_internal_external_flag_o
342: => hr_oru_shd.g_old_rec.internal_external_flag
343: ,p_internal_address_line_o
344: => hr_oru_shd.g_old_rec.internal_address_line
345: ,p_type_o
346: => hr_oru_shd.g_old_rec.type
340: => hr_oru_shd.g_old_rec.date_to
341: ,p_internal_external_flag_o
342: => hr_oru_shd.g_old_rec.internal_external_flag
343: ,p_internal_address_line_o
344: => hr_oru_shd.g_old_rec.internal_address_line
345: ,p_type_o
346: => hr_oru_shd.g_old_rec.type
347: ,p_request_id_o
348: => hr_oru_shd.g_old_rec.request_id
342: => hr_oru_shd.g_old_rec.internal_external_flag
343: ,p_internal_address_line_o
344: => hr_oru_shd.g_old_rec.internal_address_line
345: ,p_type_o
346: => hr_oru_shd.g_old_rec.type
347: ,p_request_id_o
348: => hr_oru_shd.g_old_rec.request_id
349: ,p_program_application_id_o
350: => hr_oru_shd.g_old_rec.program_application_id
344: => hr_oru_shd.g_old_rec.internal_address_line
345: ,p_type_o
346: => hr_oru_shd.g_old_rec.type
347: ,p_request_id_o
348: => hr_oru_shd.g_old_rec.request_id
349: ,p_program_application_id_o
350: => hr_oru_shd.g_old_rec.program_application_id
351: ,p_program_id_o
352: => hr_oru_shd.g_old_rec.program_id
346: => hr_oru_shd.g_old_rec.type
347: ,p_request_id_o
348: => hr_oru_shd.g_old_rec.request_id
349: ,p_program_application_id_o
350: => hr_oru_shd.g_old_rec.program_application_id
351: ,p_program_id_o
352: => hr_oru_shd.g_old_rec.program_id
353: ,p_program_update_date_o
354: => hr_oru_shd.g_old_rec.program_update_date
348: => hr_oru_shd.g_old_rec.request_id
349: ,p_program_application_id_o
350: => hr_oru_shd.g_old_rec.program_application_id
351: ,p_program_id_o
352: => hr_oru_shd.g_old_rec.program_id
353: ,p_program_update_date_o
354: => hr_oru_shd.g_old_rec.program_update_date
355: ,p_attribute_category_o
356: => hr_oru_shd.g_old_rec.attribute_category
350: => hr_oru_shd.g_old_rec.program_application_id
351: ,p_program_id_o
352: => hr_oru_shd.g_old_rec.program_id
353: ,p_program_update_date_o
354: => hr_oru_shd.g_old_rec.program_update_date
355: ,p_attribute_category_o
356: => hr_oru_shd.g_old_rec.attribute_category
357: ,p_attribute1_o
358: => hr_oru_shd.g_old_rec.attribute1
352: => hr_oru_shd.g_old_rec.program_id
353: ,p_program_update_date_o
354: => hr_oru_shd.g_old_rec.program_update_date
355: ,p_attribute_category_o
356: => hr_oru_shd.g_old_rec.attribute_category
357: ,p_attribute1_o
358: => hr_oru_shd.g_old_rec.attribute1
359: ,p_attribute2_o
360: => hr_oru_shd.g_old_rec.attribute2
354: => hr_oru_shd.g_old_rec.program_update_date
355: ,p_attribute_category_o
356: => hr_oru_shd.g_old_rec.attribute_category
357: ,p_attribute1_o
358: => hr_oru_shd.g_old_rec.attribute1
359: ,p_attribute2_o
360: => hr_oru_shd.g_old_rec.attribute2
361: ,p_attribute3_o
362: => hr_oru_shd.g_old_rec.attribute3
356: => hr_oru_shd.g_old_rec.attribute_category
357: ,p_attribute1_o
358: => hr_oru_shd.g_old_rec.attribute1
359: ,p_attribute2_o
360: => hr_oru_shd.g_old_rec.attribute2
361: ,p_attribute3_o
362: => hr_oru_shd.g_old_rec.attribute3
363: ,p_attribute4_o
364: => hr_oru_shd.g_old_rec.attribute4
358: => hr_oru_shd.g_old_rec.attribute1
359: ,p_attribute2_o
360: => hr_oru_shd.g_old_rec.attribute2
361: ,p_attribute3_o
362: => hr_oru_shd.g_old_rec.attribute3
363: ,p_attribute4_o
364: => hr_oru_shd.g_old_rec.attribute4
365: ,p_attribute5_o
366: => hr_oru_shd.g_old_rec.attribute5
360: => hr_oru_shd.g_old_rec.attribute2
361: ,p_attribute3_o
362: => hr_oru_shd.g_old_rec.attribute3
363: ,p_attribute4_o
364: => hr_oru_shd.g_old_rec.attribute4
365: ,p_attribute5_o
366: => hr_oru_shd.g_old_rec.attribute5
367: ,p_attribute6_o
368: => hr_oru_shd.g_old_rec.attribute6
362: => hr_oru_shd.g_old_rec.attribute3
363: ,p_attribute4_o
364: => hr_oru_shd.g_old_rec.attribute4
365: ,p_attribute5_o
366: => hr_oru_shd.g_old_rec.attribute5
367: ,p_attribute6_o
368: => hr_oru_shd.g_old_rec.attribute6
369: ,p_attribute7_o
370: => hr_oru_shd.g_old_rec.attribute7
364: => hr_oru_shd.g_old_rec.attribute4
365: ,p_attribute5_o
366: => hr_oru_shd.g_old_rec.attribute5
367: ,p_attribute6_o
368: => hr_oru_shd.g_old_rec.attribute6
369: ,p_attribute7_o
370: => hr_oru_shd.g_old_rec.attribute7
371: ,p_attribute8_o
372: => hr_oru_shd.g_old_rec.attribute8
366: => hr_oru_shd.g_old_rec.attribute5
367: ,p_attribute6_o
368: => hr_oru_shd.g_old_rec.attribute6
369: ,p_attribute7_o
370: => hr_oru_shd.g_old_rec.attribute7
371: ,p_attribute8_o
372: => hr_oru_shd.g_old_rec.attribute8
373: ,p_attribute9_o
374: => hr_oru_shd.g_old_rec.attribute9
368: => hr_oru_shd.g_old_rec.attribute6
369: ,p_attribute7_o
370: => hr_oru_shd.g_old_rec.attribute7
371: ,p_attribute8_o
372: => hr_oru_shd.g_old_rec.attribute8
373: ,p_attribute9_o
374: => hr_oru_shd.g_old_rec.attribute9
375: ,p_attribute10_o
376: => hr_oru_shd.g_old_rec.attribute10
370: => hr_oru_shd.g_old_rec.attribute7
371: ,p_attribute8_o
372: => hr_oru_shd.g_old_rec.attribute8
373: ,p_attribute9_o
374: => hr_oru_shd.g_old_rec.attribute9
375: ,p_attribute10_o
376: => hr_oru_shd.g_old_rec.attribute10
377: ,p_attribute11_o
378: => hr_oru_shd.g_old_rec.attribute11
372: => hr_oru_shd.g_old_rec.attribute8
373: ,p_attribute9_o
374: => hr_oru_shd.g_old_rec.attribute9
375: ,p_attribute10_o
376: => hr_oru_shd.g_old_rec.attribute10
377: ,p_attribute11_o
378: => hr_oru_shd.g_old_rec.attribute11
379: ,p_attribute12_o
380: => hr_oru_shd.g_old_rec.attribute12
374: => hr_oru_shd.g_old_rec.attribute9
375: ,p_attribute10_o
376: => hr_oru_shd.g_old_rec.attribute10
377: ,p_attribute11_o
378: => hr_oru_shd.g_old_rec.attribute11
379: ,p_attribute12_o
380: => hr_oru_shd.g_old_rec.attribute12
381: ,p_attribute13_o
382: => hr_oru_shd.g_old_rec.attribute13
376: => hr_oru_shd.g_old_rec.attribute10
377: ,p_attribute11_o
378: => hr_oru_shd.g_old_rec.attribute11
379: ,p_attribute12_o
380: => hr_oru_shd.g_old_rec.attribute12
381: ,p_attribute13_o
382: => hr_oru_shd.g_old_rec.attribute13
383: ,p_attribute14_o
384: => hr_oru_shd.g_old_rec.attribute14
378: => hr_oru_shd.g_old_rec.attribute11
379: ,p_attribute12_o
380: => hr_oru_shd.g_old_rec.attribute12
381: ,p_attribute13_o
382: => hr_oru_shd.g_old_rec.attribute13
383: ,p_attribute14_o
384: => hr_oru_shd.g_old_rec.attribute14
385: ,p_attribute15_o
386: => hr_oru_shd.g_old_rec.attribute15
380: => hr_oru_shd.g_old_rec.attribute12
381: ,p_attribute13_o
382: => hr_oru_shd.g_old_rec.attribute13
383: ,p_attribute14_o
384: => hr_oru_shd.g_old_rec.attribute14
385: ,p_attribute15_o
386: => hr_oru_shd.g_old_rec.attribute15
387: ,p_attribute16_o
388: => hr_oru_shd.g_old_rec.attribute16
382: => hr_oru_shd.g_old_rec.attribute13
383: ,p_attribute14_o
384: => hr_oru_shd.g_old_rec.attribute14
385: ,p_attribute15_o
386: => hr_oru_shd.g_old_rec.attribute15
387: ,p_attribute16_o
388: => hr_oru_shd.g_old_rec.attribute16
389: ,p_attribute17_o
390: => hr_oru_shd.g_old_rec.attribute17
384: => hr_oru_shd.g_old_rec.attribute14
385: ,p_attribute15_o
386: => hr_oru_shd.g_old_rec.attribute15
387: ,p_attribute16_o
388: => hr_oru_shd.g_old_rec.attribute16
389: ,p_attribute17_o
390: => hr_oru_shd.g_old_rec.attribute17
391: ,p_attribute18_o
392: => hr_oru_shd.g_old_rec.attribute18
386: => hr_oru_shd.g_old_rec.attribute15
387: ,p_attribute16_o
388: => hr_oru_shd.g_old_rec.attribute16
389: ,p_attribute17_o
390: => hr_oru_shd.g_old_rec.attribute17
391: ,p_attribute18_o
392: => hr_oru_shd.g_old_rec.attribute18
393: ,p_attribute19_o
394: => hr_oru_shd.g_old_rec.attribute19
388: => hr_oru_shd.g_old_rec.attribute16
389: ,p_attribute17_o
390: => hr_oru_shd.g_old_rec.attribute17
391: ,p_attribute18_o
392: => hr_oru_shd.g_old_rec.attribute18
393: ,p_attribute19_o
394: => hr_oru_shd.g_old_rec.attribute19
395: ,p_attribute20_o
396: => hr_oru_shd.g_old_rec.attribute20
390: => hr_oru_shd.g_old_rec.attribute17
391: ,p_attribute18_o
392: => hr_oru_shd.g_old_rec.attribute18
393: ,p_attribute19_o
394: => hr_oru_shd.g_old_rec.attribute19
395: ,p_attribute20_o
396: => hr_oru_shd.g_old_rec.attribute20
397: --Enhancement 4040086
398: ,p_attribute21_o
392: => hr_oru_shd.g_old_rec.attribute18
393: ,p_attribute19_o
394: => hr_oru_shd.g_old_rec.attribute19
395: ,p_attribute20_o
396: => hr_oru_shd.g_old_rec.attribute20
397: --Enhancement 4040086
398: ,p_attribute21_o
399: => hr_oru_shd.g_old_rec.attribute21
400: ,p_attribute22_o
395: ,p_attribute20_o
396: => hr_oru_shd.g_old_rec.attribute20
397: --Enhancement 4040086
398: ,p_attribute21_o
399: => hr_oru_shd.g_old_rec.attribute21
400: ,p_attribute22_o
401: => hr_oru_shd.g_old_rec.attribute22
402: ,p_attribute23_o
403: => hr_oru_shd.g_old_rec.attribute23
397: --Enhancement 4040086
398: ,p_attribute21_o
399: => hr_oru_shd.g_old_rec.attribute21
400: ,p_attribute22_o
401: => hr_oru_shd.g_old_rec.attribute22
402: ,p_attribute23_o
403: => hr_oru_shd.g_old_rec.attribute23
404: ,p_attribute24_o
405: => hr_oru_shd.g_old_rec.attribute24
399: => hr_oru_shd.g_old_rec.attribute21
400: ,p_attribute22_o
401: => hr_oru_shd.g_old_rec.attribute22
402: ,p_attribute23_o
403: => hr_oru_shd.g_old_rec.attribute23
404: ,p_attribute24_o
405: => hr_oru_shd.g_old_rec.attribute24
406: ,p_attribute25_o
407: => hr_oru_shd.g_old_rec.attribute25
401: => hr_oru_shd.g_old_rec.attribute22
402: ,p_attribute23_o
403: => hr_oru_shd.g_old_rec.attribute23
404: ,p_attribute24_o
405: => hr_oru_shd.g_old_rec.attribute24
406: ,p_attribute25_o
407: => hr_oru_shd.g_old_rec.attribute25
408: ,p_attribute26_o
409: => hr_oru_shd.g_old_rec.attribute26
403: => hr_oru_shd.g_old_rec.attribute23
404: ,p_attribute24_o
405: => hr_oru_shd.g_old_rec.attribute24
406: ,p_attribute25_o
407: => hr_oru_shd.g_old_rec.attribute25
408: ,p_attribute26_o
409: => hr_oru_shd.g_old_rec.attribute26
410: ,p_attribute27_o
411: => hr_oru_shd.g_old_rec.attribute27
405: => hr_oru_shd.g_old_rec.attribute24
406: ,p_attribute25_o
407: => hr_oru_shd.g_old_rec.attribute25
408: ,p_attribute26_o
409: => hr_oru_shd.g_old_rec.attribute26
410: ,p_attribute27_o
411: => hr_oru_shd.g_old_rec.attribute27
412: ,p_attribute28_o
413: => hr_oru_shd.g_old_rec.attribute28
407: => hr_oru_shd.g_old_rec.attribute25
408: ,p_attribute26_o
409: => hr_oru_shd.g_old_rec.attribute26
410: ,p_attribute27_o
411: => hr_oru_shd.g_old_rec.attribute27
412: ,p_attribute28_o
413: => hr_oru_shd.g_old_rec.attribute28
414: ,p_attribute29_o
415: => hr_oru_shd.g_old_rec.attribute29
409: => hr_oru_shd.g_old_rec.attribute26
410: ,p_attribute27_o
411: => hr_oru_shd.g_old_rec.attribute27
412: ,p_attribute28_o
413: => hr_oru_shd.g_old_rec.attribute28
414: ,p_attribute29_o
415: => hr_oru_shd.g_old_rec.attribute29
416: ,p_attribute30_o
417: => hr_oru_shd.g_old_rec.attribute30
411: => hr_oru_shd.g_old_rec.attribute27
412: ,p_attribute28_o
413: => hr_oru_shd.g_old_rec.attribute28
414: ,p_attribute29_o
415: => hr_oru_shd.g_old_rec.attribute29
416: ,p_attribute30_o
417: => hr_oru_shd.g_old_rec.attribute30
418: --End Enhancement 4040086
419: ,p_object_version_number_o
413: => hr_oru_shd.g_old_rec.attribute28
414: ,p_attribute29_o
415: => hr_oru_shd.g_old_rec.attribute29
416: ,p_attribute30_o
417: => hr_oru_shd.g_old_rec.attribute30
418: --End Enhancement 4040086
419: ,p_object_version_number_o
420: => hr_oru_shd.g_old_rec.object_version_number
421: );
416: ,p_attribute30_o
417: => hr_oru_shd.g_old_rec.attribute30
418: --End Enhancement 4040086
419: ,p_object_version_number_o
420: => hr_oru_shd.g_old_rec.object_version_number
421: );
422: --
423: exception
424: --
476: --
477: -- {End Of Comments}
478: -- ----------------------------------------------------------------------------
479: Procedure convert_defs
480: (p_rec in out nocopy hr_oru_shd.g_rec_type
481: ) is
482: --
483: Begin
484: --
488: -- is being used then we must set to the 'current' argument value.
489: --
490: If (p_rec.business_group_id = hr_api.g_number) then
491: p_rec.business_group_id :=
492: hr_oru_shd.g_old_rec.business_group_id;
493: End If;
494: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
495: p_rec.cost_allocation_keyflex_id :=
496: hr_oru_shd.g_old_rec.cost_allocation_keyflex_id;
492: hr_oru_shd.g_old_rec.business_group_id;
493: End If;
494: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
495: p_rec.cost_allocation_keyflex_id :=
496: hr_oru_shd.g_old_rec.cost_allocation_keyflex_id;
497: End If;
498: If (p_rec.location_id = hr_api.g_number) then
499: p_rec.location_id :=
500: hr_oru_shd.g_old_rec.location_id;
496: hr_oru_shd.g_old_rec.cost_allocation_keyflex_id;
497: End If;
498: If (p_rec.location_id = hr_api.g_number) then
499: p_rec.location_id :=
500: hr_oru_shd.g_old_rec.location_id;
501: End If;
502: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
503: p_rec.soft_coding_keyflex_id :=
504: hr_oru_shd.g_old_rec.soft_coding_keyflex_id;
500: hr_oru_shd.g_old_rec.location_id;
501: End If;
502: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
503: p_rec.soft_coding_keyflex_id :=
504: hr_oru_shd.g_old_rec.soft_coding_keyflex_id;
505: End If;
506: If (p_rec.date_from = hr_api.g_date) then
507: p_rec.date_from :=
508: hr_oru_shd.g_old_rec.date_from;
504: hr_oru_shd.g_old_rec.soft_coding_keyflex_id;
505: End If;
506: If (p_rec.date_from = hr_api.g_date) then
507: p_rec.date_from :=
508: hr_oru_shd.g_old_rec.date_from;
509: End If;
510: If (p_rec.name = hr_api.g_varchar2) then
511: p_rec.name :=
512: hr_oru_shd.g_old_rec.name;
508: hr_oru_shd.g_old_rec.date_from;
509: End If;
510: If (p_rec.name = hr_api.g_varchar2) then
511: p_rec.name :=
512: hr_oru_shd.g_old_rec.name;
513: End If;
514: If (p_rec.comments = hr_api.g_varchar2) then
515: p_rec.comments :=
516: hr_oru_shd.g_old_rec.comments;
512: hr_oru_shd.g_old_rec.name;
513: End If;
514: If (p_rec.comments = hr_api.g_varchar2) then
515: p_rec.comments :=
516: hr_oru_shd.g_old_rec.comments;
517: End If;
518: If (p_rec.date_to = hr_api.g_date) then
519: p_rec.date_to :=
520: hr_oru_shd.g_old_rec.date_to;
516: hr_oru_shd.g_old_rec.comments;
517: End If;
518: If (p_rec.date_to = hr_api.g_date) then
519: p_rec.date_to :=
520: hr_oru_shd.g_old_rec.date_to;
521: End If;
522: If (p_rec.internal_external_flag = hr_api.g_varchar2) then
523: p_rec.internal_external_flag :=
524: hr_oru_shd.g_old_rec.internal_external_flag;
520: hr_oru_shd.g_old_rec.date_to;
521: End If;
522: If (p_rec.internal_external_flag = hr_api.g_varchar2) then
523: p_rec.internal_external_flag :=
524: hr_oru_shd.g_old_rec.internal_external_flag;
525: End If;
526: If (p_rec.internal_address_line = hr_api.g_varchar2) then
527: p_rec.internal_address_line :=
528: hr_oru_shd.g_old_rec.internal_address_line;
524: hr_oru_shd.g_old_rec.internal_external_flag;
525: End If;
526: If (p_rec.internal_address_line = hr_api.g_varchar2) then
527: p_rec.internal_address_line :=
528: hr_oru_shd.g_old_rec.internal_address_line;
529: End If;
530: If (p_rec.type = hr_api.g_varchar2) then
531: p_rec.type :=
532: hr_oru_shd.g_old_rec.type;
528: hr_oru_shd.g_old_rec.internal_address_line;
529: End If;
530: If (p_rec.type = hr_api.g_varchar2) then
531: p_rec.type :=
532: hr_oru_shd.g_old_rec.type;
533: End If;
534: If (p_rec.request_id = hr_api.g_number) then
535: p_rec.request_id :=
536: hr_oru_shd.g_old_rec.request_id;
532: hr_oru_shd.g_old_rec.type;
533: End If;
534: If (p_rec.request_id = hr_api.g_number) then
535: p_rec.request_id :=
536: hr_oru_shd.g_old_rec.request_id;
537: End If;
538: If (p_rec.program_application_id = hr_api.g_number) then
539: p_rec.program_application_id :=
540: hr_oru_shd.g_old_rec.program_application_id;
536: hr_oru_shd.g_old_rec.request_id;
537: End If;
538: If (p_rec.program_application_id = hr_api.g_number) then
539: p_rec.program_application_id :=
540: hr_oru_shd.g_old_rec.program_application_id;
541: End If;
542: If (p_rec.program_id = hr_api.g_number) then
543: p_rec.program_id :=
544: hr_oru_shd.g_old_rec.program_id;
540: hr_oru_shd.g_old_rec.program_application_id;
541: End If;
542: If (p_rec.program_id = hr_api.g_number) then
543: p_rec.program_id :=
544: hr_oru_shd.g_old_rec.program_id;
545: End If;
546: If (p_rec.program_update_date = hr_api.g_date) then
547: p_rec.program_update_date :=
548: hr_oru_shd.g_old_rec.program_update_date;
544: hr_oru_shd.g_old_rec.program_id;
545: End If;
546: If (p_rec.program_update_date = hr_api.g_date) then
547: p_rec.program_update_date :=
548: hr_oru_shd.g_old_rec.program_update_date;
549: End If;
550: If (p_rec.attribute_category = hr_api.g_varchar2) then
551: p_rec.attribute_category :=
552: hr_oru_shd.g_old_rec.attribute_category;
548: hr_oru_shd.g_old_rec.program_update_date;
549: End If;
550: If (p_rec.attribute_category = hr_api.g_varchar2) then
551: p_rec.attribute_category :=
552: hr_oru_shd.g_old_rec.attribute_category;
553: End If;
554: If (p_rec.attribute1 = hr_api.g_varchar2) then
555: p_rec.attribute1 :=
556: hr_oru_shd.g_old_rec.attribute1;
552: hr_oru_shd.g_old_rec.attribute_category;
553: End If;
554: If (p_rec.attribute1 = hr_api.g_varchar2) then
555: p_rec.attribute1 :=
556: hr_oru_shd.g_old_rec.attribute1;
557: End If;
558: If (p_rec.attribute2 = hr_api.g_varchar2) then
559: p_rec.attribute2 :=
560: hr_oru_shd.g_old_rec.attribute2;
556: hr_oru_shd.g_old_rec.attribute1;
557: End If;
558: If (p_rec.attribute2 = hr_api.g_varchar2) then
559: p_rec.attribute2 :=
560: hr_oru_shd.g_old_rec.attribute2;
561: End If;
562: If (p_rec.attribute3 = hr_api.g_varchar2) then
563: p_rec.attribute3 :=
564: hr_oru_shd.g_old_rec.attribute3;
560: hr_oru_shd.g_old_rec.attribute2;
561: End If;
562: If (p_rec.attribute3 = hr_api.g_varchar2) then
563: p_rec.attribute3 :=
564: hr_oru_shd.g_old_rec.attribute3;
565: End If;
566: If (p_rec.attribute4 = hr_api.g_varchar2) then
567: p_rec.attribute4 :=
568: hr_oru_shd.g_old_rec.attribute4;
564: hr_oru_shd.g_old_rec.attribute3;
565: End If;
566: If (p_rec.attribute4 = hr_api.g_varchar2) then
567: p_rec.attribute4 :=
568: hr_oru_shd.g_old_rec.attribute4;
569: End If;
570: If (p_rec.attribute5 = hr_api.g_varchar2) then
571: p_rec.attribute5 :=
572: hr_oru_shd.g_old_rec.attribute5;
568: hr_oru_shd.g_old_rec.attribute4;
569: End If;
570: If (p_rec.attribute5 = hr_api.g_varchar2) then
571: p_rec.attribute5 :=
572: hr_oru_shd.g_old_rec.attribute5;
573: End If;
574: If (p_rec.attribute6 = hr_api.g_varchar2) then
575: p_rec.attribute6 :=
576: hr_oru_shd.g_old_rec.attribute6;
572: hr_oru_shd.g_old_rec.attribute5;
573: End If;
574: If (p_rec.attribute6 = hr_api.g_varchar2) then
575: p_rec.attribute6 :=
576: hr_oru_shd.g_old_rec.attribute6;
577: End If;
578: If (p_rec.attribute7 = hr_api.g_varchar2) then
579: p_rec.attribute7 :=
580: hr_oru_shd.g_old_rec.attribute7;
576: hr_oru_shd.g_old_rec.attribute6;
577: End If;
578: If (p_rec.attribute7 = hr_api.g_varchar2) then
579: p_rec.attribute7 :=
580: hr_oru_shd.g_old_rec.attribute7;
581: End If;
582: If (p_rec.attribute8 = hr_api.g_varchar2) then
583: p_rec.attribute8 :=
584: hr_oru_shd.g_old_rec.attribute8;
580: hr_oru_shd.g_old_rec.attribute7;
581: End If;
582: If (p_rec.attribute8 = hr_api.g_varchar2) then
583: p_rec.attribute8 :=
584: hr_oru_shd.g_old_rec.attribute8;
585: End If;
586: If (p_rec.attribute9 = hr_api.g_varchar2) then
587: p_rec.attribute9 :=
588: hr_oru_shd.g_old_rec.attribute9;
584: hr_oru_shd.g_old_rec.attribute8;
585: End If;
586: If (p_rec.attribute9 = hr_api.g_varchar2) then
587: p_rec.attribute9 :=
588: hr_oru_shd.g_old_rec.attribute9;
589: End If;
590: If (p_rec.attribute10 = hr_api.g_varchar2) then
591: p_rec.attribute10 :=
592: hr_oru_shd.g_old_rec.attribute10;
588: hr_oru_shd.g_old_rec.attribute9;
589: End If;
590: If (p_rec.attribute10 = hr_api.g_varchar2) then
591: p_rec.attribute10 :=
592: hr_oru_shd.g_old_rec.attribute10;
593: End If;
594: If (p_rec.attribute11 = hr_api.g_varchar2) then
595: p_rec.attribute11 :=
596: hr_oru_shd.g_old_rec.attribute11;
592: hr_oru_shd.g_old_rec.attribute10;
593: End If;
594: If (p_rec.attribute11 = hr_api.g_varchar2) then
595: p_rec.attribute11 :=
596: hr_oru_shd.g_old_rec.attribute11;
597: End If;
598: If (p_rec.attribute12 = hr_api.g_varchar2) then
599: p_rec.attribute12 :=
600: hr_oru_shd.g_old_rec.attribute12;
596: hr_oru_shd.g_old_rec.attribute11;
597: End If;
598: If (p_rec.attribute12 = hr_api.g_varchar2) then
599: p_rec.attribute12 :=
600: hr_oru_shd.g_old_rec.attribute12;
601: End If;
602: If (p_rec.attribute13 = hr_api.g_varchar2) then
603: p_rec.attribute13 :=
604: hr_oru_shd.g_old_rec.attribute13;
600: hr_oru_shd.g_old_rec.attribute12;
601: End If;
602: If (p_rec.attribute13 = hr_api.g_varchar2) then
603: p_rec.attribute13 :=
604: hr_oru_shd.g_old_rec.attribute13;
605: End If;
606: If (p_rec.attribute14 = hr_api.g_varchar2) then
607: p_rec.attribute14 :=
608: hr_oru_shd.g_old_rec.attribute14;
604: hr_oru_shd.g_old_rec.attribute13;
605: End If;
606: If (p_rec.attribute14 = hr_api.g_varchar2) then
607: p_rec.attribute14 :=
608: hr_oru_shd.g_old_rec.attribute14;
609: End If;
610: If (p_rec.attribute15 = hr_api.g_varchar2) then
611: p_rec.attribute15 :=
612: hr_oru_shd.g_old_rec.attribute15;
608: hr_oru_shd.g_old_rec.attribute14;
609: End If;
610: If (p_rec.attribute15 = hr_api.g_varchar2) then
611: p_rec.attribute15 :=
612: hr_oru_shd.g_old_rec.attribute15;
613: End If;
614: If (p_rec.attribute16 = hr_api.g_varchar2) then
615: p_rec.attribute16 :=
616: hr_oru_shd.g_old_rec.attribute16;
612: hr_oru_shd.g_old_rec.attribute15;
613: End If;
614: If (p_rec.attribute16 = hr_api.g_varchar2) then
615: p_rec.attribute16 :=
616: hr_oru_shd.g_old_rec.attribute16;
617: End If;
618: If (p_rec.attribute17 = hr_api.g_varchar2) then
619: p_rec.attribute17 :=
620: hr_oru_shd.g_old_rec.attribute17;
616: hr_oru_shd.g_old_rec.attribute16;
617: End If;
618: If (p_rec.attribute17 = hr_api.g_varchar2) then
619: p_rec.attribute17 :=
620: hr_oru_shd.g_old_rec.attribute17;
621: End If;
622: If (p_rec.attribute18 = hr_api.g_varchar2) then
623: p_rec.attribute18 :=
624: hr_oru_shd.g_old_rec.attribute18;
620: hr_oru_shd.g_old_rec.attribute17;
621: End If;
622: If (p_rec.attribute18 = hr_api.g_varchar2) then
623: p_rec.attribute18 :=
624: hr_oru_shd.g_old_rec.attribute18;
625: End If;
626: If (p_rec.attribute19 = hr_api.g_varchar2) then
627: p_rec.attribute19 :=
628: hr_oru_shd.g_old_rec.attribute19;
624: hr_oru_shd.g_old_rec.attribute18;
625: End If;
626: If (p_rec.attribute19 = hr_api.g_varchar2) then
627: p_rec.attribute19 :=
628: hr_oru_shd.g_old_rec.attribute19;
629: End If;
630: If (p_rec.attribute20 = hr_api.g_varchar2) then
631: p_rec.attribute20 :=
632: hr_oru_shd.g_old_rec.attribute20;
628: hr_oru_shd.g_old_rec.attribute19;
629: End If;
630: If (p_rec.attribute20 = hr_api.g_varchar2) then
631: p_rec.attribute20 :=
632: hr_oru_shd.g_old_rec.attribute20;
633: End If;
634: --Enhancement 4040086
635: If (p_rec.attribute21 = hr_api.g_varchar2) then
636: p_rec.attribute21 :=
633: End If;
634: --Enhancement 4040086
635: If (p_rec.attribute21 = hr_api.g_varchar2) then
636: p_rec.attribute21 :=
637: hr_oru_shd.g_old_rec.attribute21;
638: End If;
639: If (p_rec.attribute22 = hr_api.g_varchar2) then
640: p_rec.attribute22 :=
641: hr_oru_shd.g_old_rec.attribute22;
637: hr_oru_shd.g_old_rec.attribute21;
638: End If;
639: If (p_rec.attribute22 = hr_api.g_varchar2) then
640: p_rec.attribute22 :=
641: hr_oru_shd.g_old_rec.attribute22;
642: End If;
643: If (p_rec.attribute23 = hr_api.g_varchar2) then
644: p_rec.attribute23 :=
645: hr_oru_shd.g_old_rec.attribute23;
641: hr_oru_shd.g_old_rec.attribute22;
642: End If;
643: If (p_rec.attribute23 = hr_api.g_varchar2) then
644: p_rec.attribute23 :=
645: hr_oru_shd.g_old_rec.attribute23;
646: End If;
647: If (p_rec.attribute24 = hr_api.g_varchar2) then
648: p_rec.attribute24 :=
649: hr_oru_shd.g_old_rec.attribute24;
645: hr_oru_shd.g_old_rec.attribute23;
646: End If;
647: If (p_rec.attribute24 = hr_api.g_varchar2) then
648: p_rec.attribute24 :=
649: hr_oru_shd.g_old_rec.attribute24;
650: End If;
651: If (p_rec.attribute25 = hr_api.g_varchar2) then
652: p_rec.attribute25 :=
653: hr_oru_shd.g_old_rec.attribute25;
649: hr_oru_shd.g_old_rec.attribute24;
650: End If;
651: If (p_rec.attribute25 = hr_api.g_varchar2) then
652: p_rec.attribute25 :=
653: hr_oru_shd.g_old_rec.attribute25;
654: End If;
655: If (p_rec.attribute26 = hr_api.g_varchar2) then
656: p_rec.attribute26 :=
657: hr_oru_shd.g_old_rec.attribute26;
653: hr_oru_shd.g_old_rec.attribute25;
654: End If;
655: If (p_rec.attribute26 = hr_api.g_varchar2) then
656: p_rec.attribute26 :=
657: hr_oru_shd.g_old_rec.attribute26;
658: End If;
659: If (p_rec.attribute27 = hr_api.g_varchar2) then
660: p_rec.attribute27 :=
661: hr_oru_shd.g_old_rec.attribute27;
657: hr_oru_shd.g_old_rec.attribute26;
658: End If;
659: If (p_rec.attribute27 = hr_api.g_varchar2) then
660: p_rec.attribute27 :=
661: hr_oru_shd.g_old_rec.attribute27;
662: End If;
663: If (p_rec.attribute28 = hr_api.g_varchar2) then
664: p_rec.attribute28 :=
665: hr_oru_shd.g_old_rec.attribute28;
661: hr_oru_shd.g_old_rec.attribute27;
662: End If;
663: If (p_rec.attribute28 = hr_api.g_varchar2) then
664: p_rec.attribute28 :=
665: hr_oru_shd.g_old_rec.attribute28;
666: End If;
667: If (p_rec.attribute29 = hr_api.g_varchar2) then
668: p_rec.attribute29 :=
669: hr_oru_shd.g_old_rec.attribute29;
665: hr_oru_shd.g_old_rec.attribute28;
666: End If;
667: If (p_rec.attribute29 = hr_api.g_varchar2) then
668: p_rec.attribute29 :=
669: hr_oru_shd.g_old_rec.attribute29;
670: End If;
671: If (p_rec.attribute30 = hr_api.g_varchar2) then
672: p_rec.attribute30 :=
673: hr_oru_shd.g_old_rec.attribute30;
669: hr_oru_shd.g_old_rec.attribute29;
670: End If;
671: If (p_rec.attribute30 = hr_api.g_varchar2) then
672: p_rec.attribute30 :=
673: hr_oru_shd.g_old_rec.attribute30;
674: End If;
675: --End Enhancement 4040086
676: --
677: End convert_defs;
680: -- |---------------------------------< upd >----------------------------------|
681: -- ----------------------------------------------------------------------------
682: Procedure upd
683: (p_effective_date in date
684: ,p_rec in out nocopy hr_oru_shd.g_rec_type
685: ,p_duplicate_org_warning out nocopy boolean
686: ) is
687: --
688: l_proc varchar2(72) := g_package||'upd';
691: hr_utility.set_location('Entering:'||l_proc, 5);
692: --
693: -- We must lock the row which we need to update.
694: --
695: hr_oru_shd.lck
696: (p_rec.organization_id
697: ,p_rec.object_version_number
698: );
699: --
780: --End Enhancement 4040086
781: ,p_duplicate_org_warning out nocopy boolean
782: ) is
783: --
784: l_rec hr_oru_shd.g_rec_type;
785: l_proc varchar2(72) := g_package||'upd';
786: --
787: Begin
788: hr_utility.set_location('Entering:'||l_proc, 5);
790: -- Call conversion function to turn arguments into the
791: -- l_rec structure.
792: --
793: l_rec :=
794: hr_oru_shd.convert_args
795: (p_organization_id
796: ,p_business_group_id
797: ,p_cost_allocation_keyflex_id
798: ,p_location_id