[Home] [Help]
50: -- Internal Table Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy per_add_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: hr_utility.set_location(l_proc, 6);
66: per_add_shd.g_api_dml := true; -- Set the api dml status
67: --
68: hr_utility.set_location(l_proc, 7);
69: -- Update the per_addresses Row
70: --
134: style = p_rec.style
135: where address_id = p_rec.address_id;
136: --
137: hr_utility.set_location(l_proc, 8);
138: per_add_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
142: Exception
141: --
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: per_add_shd.g_api_dml := false; -- Unset the api dml status
146: per_add_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: per_add_shd.g_api_dml := false; -- Unset the api dml status
146: per_add_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_add_shd.g_api_dml := false; -- Unset the api dml status
146: per_add_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_add_shd.g_api_dml := false; -- Unset the api dml status
151: per_add_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_add_shd.g_api_dml := false; -- Unset the api dml status
151: per_add_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_add_shd.g_api_dml := false; -- Unset the api dml status
151: per_add_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_add_shd.g_api_dml := false; -- Unset the api dml status
156: per_add_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: per_add_shd.g_api_dml := false; -- Unset the api dml status
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_add_shd.g_api_dml := false; -- Unset the api dml status
156: per_add_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: per_add_shd.g_api_dml := false; -- Unset the api dml status
160: Raise;
155: per_add_shd.g_api_dml := false; -- Unset the api dml status
156: per_add_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: per_add_shd.g_api_dml := false; -- Unset the api dml status
160: Raise;
161: End update_dml;
162: --
163: -- ----------------------------------------------------------------------------
191: -- Internal Table Handler Use Only.
192: --
193: -- {End Of Comments}
194: -- ----------------------------------------------------------------------------
195: Procedure pre_update(p_rec in out nocopy per_add_shd.g_rec_type) is
196: --
197: l_proc varchar2(72) := g_package||'pre_update';
198: --
199: Begin
202: --
203: -- WWBUG 2203479.
204: -- Removed for irecruitment
205: -- Bug# 2747048. Uncommented the code as it is required now.
206: per_add_shd.derive_locale(p_rec);
207: --
208: -- Enhancement added for Location Searching
209: --
210: if( (fnd_profile.value('IRC_INSTALLED_FLAG') in ('Y','D') )and
258: --
259: -- {End Of Comments}
260: -- ----------------------------------------------------------------------------
261: Procedure post_update
262: (p_rec in per_add_shd.g_rec_type
263: ,p_effective_date in date
264: ,p_prflagval_override in boolean
265: ,p_validate_county in boolean
266: )
339: ,p_effective_date => p_effective_date
340: ,p_prflagval_override => p_prflagval_override
341: ,p_validate_county => p_validate_county
342: ,p_business_group_id_o
343: => per_add_shd.g_old_rec.business_group_id
344: ,p_person_id_o
345: => per_add_shd.g_old_rec.person_id
346: ,p_date_from_o
347: => per_add_shd.g_old_rec.date_from
341: ,p_validate_county => p_validate_county
342: ,p_business_group_id_o
343: => per_add_shd.g_old_rec.business_group_id
344: ,p_person_id_o
345: => per_add_shd.g_old_rec.person_id
346: ,p_date_from_o
347: => per_add_shd.g_old_rec.date_from
348: ,p_primary_flag_o
349: => per_add_shd.g_old_rec.primary_flag
343: => per_add_shd.g_old_rec.business_group_id
344: ,p_person_id_o
345: => per_add_shd.g_old_rec.person_id
346: ,p_date_from_o
347: => per_add_shd.g_old_rec.date_from
348: ,p_primary_flag_o
349: => per_add_shd.g_old_rec.primary_flag
350: ,p_style_o
351: => per_add_shd.g_old_rec.style
345: => per_add_shd.g_old_rec.person_id
346: ,p_date_from_o
347: => per_add_shd.g_old_rec.date_from
348: ,p_primary_flag_o
349: => per_add_shd.g_old_rec.primary_flag
350: ,p_style_o
351: => per_add_shd.g_old_rec.style
352: ,p_address_line1_o
353: => per_add_shd.g_old_rec.address_line1
347: => per_add_shd.g_old_rec.date_from
348: ,p_primary_flag_o
349: => per_add_shd.g_old_rec.primary_flag
350: ,p_style_o
351: => per_add_shd.g_old_rec.style
352: ,p_address_line1_o
353: => per_add_shd.g_old_rec.address_line1
354: ,p_address_line2_o
355: => per_add_shd.g_old_rec.address_line2
349: => per_add_shd.g_old_rec.primary_flag
350: ,p_style_o
351: => per_add_shd.g_old_rec.style
352: ,p_address_line1_o
353: => per_add_shd.g_old_rec.address_line1
354: ,p_address_line2_o
355: => per_add_shd.g_old_rec.address_line2
356: ,p_address_line3_o
357: => per_add_shd.g_old_rec.address_line3
351: => per_add_shd.g_old_rec.style
352: ,p_address_line1_o
353: => per_add_shd.g_old_rec.address_line1
354: ,p_address_line2_o
355: => per_add_shd.g_old_rec.address_line2
356: ,p_address_line3_o
357: => per_add_shd.g_old_rec.address_line3
358: ,p_address_type_o
359: => per_add_shd.g_old_rec.address_type
353: => per_add_shd.g_old_rec.address_line1
354: ,p_address_line2_o
355: => per_add_shd.g_old_rec.address_line2
356: ,p_address_line3_o
357: => per_add_shd.g_old_rec.address_line3
358: ,p_address_type_o
359: => per_add_shd.g_old_rec.address_type
360: ,p_comments_o
361: => per_add_shd.g_old_rec.comments
355: => per_add_shd.g_old_rec.address_line2
356: ,p_address_line3_o
357: => per_add_shd.g_old_rec.address_line3
358: ,p_address_type_o
359: => per_add_shd.g_old_rec.address_type
360: ,p_comments_o
361: => per_add_shd.g_old_rec.comments
362: ,p_country_o
363: => per_add_shd.g_old_rec.country
357: => per_add_shd.g_old_rec.address_line3
358: ,p_address_type_o
359: => per_add_shd.g_old_rec.address_type
360: ,p_comments_o
361: => per_add_shd.g_old_rec.comments
362: ,p_country_o
363: => per_add_shd.g_old_rec.country
364: ,p_date_to_o
365: => per_add_shd.g_old_rec.date_to
359: => per_add_shd.g_old_rec.address_type
360: ,p_comments_o
361: => per_add_shd.g_old_rec.comments
362: ,p_country_o
363: => per_add_shd.g_old_rec.country
364: ,p_date_to_o
365: => per_add_shd.g_old_rec.date_to
366: ,p_postal_code_o
367: => per_add_shd.g_old_rec.postal_code
361: => per_add_shd.g_old_rec.comments
362: ,p_country_o
363: => per_add_shd.g_old_rec.country
364: ,p_date_to_o
365: => per_add_shd.g_old_rec.date_to
366: ,p_postal_code_o
367: => per_add_shd.g_old_rec.postal_code
368: ,p_region_1_o
369: => per_add_shd.g_old_rec.region_1
363: => per_add_shd.g_old_rec.country
364: ,p_date_to_o
365: => per_add_shd.g_old_rec.date_to
366: ,p_postal_code_o
367: => per_add_shd.g_old_rec.postal_code
368: ,p_region_1_o
369: => per_add_shd.g_old_rec.region_1
370: ,p_region_2_o
371: => per_add_shd.g_old_rec.region_2
365: => per_add_shd.g_old_rec.date_to
366: ,p_postal_code_o
367: => per_add_shd.g_old_rec.postal_code
368: ,p_region_1_o
369: => per_add_shd.g_old_rec.region_1
370: ,p_region_2_o
371: => per_add_shd.g_old_rec.region_2
372: ,p_region_3_o
373: => per_add_shd.g_old_rec.region_3
367: => per_add_shd.g_old_rec.postal_code
368: ,p_region_1_o
369: => per_add_shd.g_old_rec.region_1
370: ,p_region_2_o
371: => per_add_shd.g_old_rec.region_2
372: ,p_region_3_o
373: => per_add_shd.g_old_rec.region_3
374: ,p_telephone_number_1_o
375: => per_add_shd.g_old_rec.telephone_number_1
369: => per_add_shd.g_old_rec.region_1
370: ,p_region_2_o
371: => per_add_shd.g_old_rec.region_2
372: ,p_region_3_o
373: => per_add_shd.g_old_rec.region_3
374: ,p_telephone_number_1_o
375: => per_add_shd.g_old_rec.telephone_number_1
376: ,p_telephone_number_2_o
377: => per_add_shd.g_old_rec.telephone_number_2
371: => per_add_shd.g_old_rec.region_2
372: ,p_region_3_o
373: => per_add_shd.g_old_rec.region_3
374: ,p_telephone_number_1_o
375: => per_add_shd.g_old_rec.telephone_number_1
376: ,p_telephone_number_2_o
377: => per_add_shd.g_old_rec.telephone_number_2
378: ,p_telephone_number_3_o
379: => per_add_shd.g_old_rec.telephone_number_3
373: => per_add_shd.g_old_rec.region_3
374: ,p_telephone_number_1_o
375: => per_add_shd.g_old_rec.telephone_number_1
376: ,p_telephone_number_2_o
377: => per_add_shd.g_old_rec.telephone_number_2
378: ,p_telephone_number_3_o
379: => per_add_shd.g_old_rec.telephone_number_3
380: ,p_town_or_city_o
381: => per_add_shd.g_old_rec.town_or_city
375: => per_add_shd.g_old_rec.telephone_number_1
376: ,p_telephone_number_2_o
377: => per_add_shd.g_old_rec.telephone_number_2
378: ,p_telephone_number_3_o
379: => per_add_shd.g_old_rec.telephone_number_3
380: ,p_town_or_city_o
381: => per_add_shd.g_old_rec.town_or_city
382: ,p_request_id_o
383: => per_add_shd.g_old_rec.request_id
377: => per_add_shd.g_old_rec.telephone_number_2
378: ,p_telephone_number_3_o
379: => per_add_shd.g_old_rec.telephone_number_3
380: ,p_town_or_city_o
381: => per_add_shd.g_old_rec.town_or_city
382: ,p_request_id_o
383: => per_add_shd.g_old_rec.request_id
384: ,p_program_application_id_o
385: => per_add_shd.g_old_rec.program_application_id
379: => per_add_shd.g_old_rec.telephone_number_3
380: ,p_town_or_city_o
381: => per_add_shd.g_old_rec.town_or_city
382: ,p_request_id_o
383: => per_add_shd.g_old_rec.request_id
384: ,p_program_application_id_o
385: => per_add_shd.g_old_rec.program_application_id
386: ,p_program_id_o
387: => per_add_shd.g_old_rec.program_id
381: => per_add_shd.g_old_rec.town_or_city
382: ,p_request_id_o
383: => per_add_shd.g_old_rec.request_id
384: ,p_program_application_id_o
385: => per_add_shd.g_old_rec.program_application_id
386: ,p_program_id_o
387: => per_add_shd.g_old_rec.program_id
388: ,p_program_update_date_o
389: => per_add_shd.g_old_rec.program_update_date
383: => per_add_shd.g_old_rec.request_id
384: ,p_program_application_id_o
385: => per_add_shd.g_old_rec.program_application_id
386: ,p_program_id_o
387: => per_add_shd.g_old_rec.program_id
388: ,p_program_update_date_o
389: => per_add_shd.g_old_rec.program_update_date
390: ,p_addr_attribute_category_o
391: => per_add_shd.g_old_rec.addr_attribute_category
385: => per_add_shd.g_old_rec.program_application_id
386: ,p_program_id_o
387: => per_add_shd.g_old_rec.program_id
388: ,p_program_update_date_o
389: => per_add_shd.g_old_rec.program_update_date
390: ,p_addr_attribute_category_o
391: => per_add_shd.g_old_rec.addr_attribute_category
392: ,p_addr_attribute1_o
393: => per_add_shd.g_old_rec.addr_attribute1
387: => per_add_shd.g_old_rec.program_id
388: ,p_program_update_date_o
389: => per_add_shd.g_old_rec.program_update_date
390: ,p_addr_attribute_category_o
391: => per_add_shd.g_old_rec.addr_attribute_category
392: ,p_addr_attribute1_o
393: => per_add_shd.g_old_rec.addr_attribute1
394: ,p_addr_attribute2_o
395: => per_add_shd.g_old_rec.addr_attribute2
389: => per_add_shd.g_old_rec.program_update_date
390: ,p_addr_attribute_category_o
391: => per_add_shd.g_old_rec.addr_attribute_category
392: ,p_addr_attribute1_o
393: => per_add_shd.g_old_rec.addr_attribute1
394: ,p_addr_attribute2_o
395: => per_add_shd.g_old_rec.addr_attribute2
396: ,p_addr_attribute3_o
397: => per_add_shd.g_old_rec.addr_attribute3
391: => per_add_shd.g_old_rec.addr_attribute_category
392: ,p_addr_attribute1_o
393: => per_add_shd.g_old_rec.addr_attribute1
394: ,p_addr_attribute2_o
395: => per_add_shd.g_old_rec.addr_attribute2
396: ,p_addr_attribute3_o
397: => per_add_shd.g_old_rec.addr_attribute3
398: ,p_addr_attribute4_o
399: => per_add_shd.g_old_rec.addr_attribute4
393: => per_add_shd.g_old_rec.addr_attribute1
394: ,p_addr_attribute2_o
395: => per_add_shd.g_old_rec.addr_attribute2
396: ,p_addr_attribute3_o
397: => per_add_shd.g_old_rec.addr_attribute3
398: ,p_addr_attribute4_o
399: => per_add_shd.g_old_rec.addr_attribute4
400: ,p_addr_attribute5_o
401: => per_add_shd.g_old_rec.addr_attribute5
395: => per_add_shd.g_old_rec.addr_attribute2
396: ,p_addr_attribute3_o
397: => per_add_shd.g_old_rec.addr_attribute3
398: ,p_addr_attribute4_o
399: => per_add_shd.g_old_rec.addr_attribute4
400: ,p_addr_attribute5_o
401: => per_add_shd.g_old_rec.addr_attribute5
402: ,p_addr_attribute6_o
403: => per_add_shd.g_old_rec.addr_attribute6
397: => per_add_shd.g_old_rec.addr_attribute3
398: ,p_addr_attribute4_o
399: => per_add_shd.g_old_rec.addr_attribute4
400: ,p_addr_attribute5_o
401: => per_add_shd.g_old_rec.addr_attribute5
402: ,p_addr_attribute6_o
403: => per_add_shd.g_old_rec.addr_attribute6
404: ,p_addr_attribute7_o
405: => per_add_shd.g_old_rec.addr_attribute7
399: => per_add_shd.g_old_rec.addr_attribute4
400: ,p_addr_attribute5_o
401: => per_add_shd.g_old_rec.addr_attribute5
402: ,p_addr_attribute6_o
403: => per_add_shd.g_old_rec.addr_attribute6
404: ,p_addr_attribute7_o
405: => per_add_shd.g_old_rec.addr_attribute7
406: ,p_addr_attribute8_o
407: => per_add_shd.g_old_rec.addr_attribute8
401: => per_add_shd.g_old_rec.addr_attribute5
402: ,p_addr_attribute6_o
403: => per_add_shd.g_old_rec.addr_attribute6
404: ,p_addr_attribute7_o
405: => per_add_shd.g_old_rec.addr_attribute7
406: ,p_addr_attribute8_o
407: => per_add_shd.g_old_rec.addr_attribute8
408: ,p_addr_attribute9_o
409: => per_add_shd.g_old_rec.addr_attribute9
403: => per_add_shd.g_old_rec.addr_attribute6
404: ,p_addr_attribute7_o
405: => per_add_shd.g_old_rec.addr_attribute7
406: ,p_addr_attribute8_o
407: => per_add_shd.g_old_rec.addr_attribute8
408: ,p_addr_attribute9_o
409: => per_add_shd.g_old_rec.addr_attribute9
410: ,p_addr_attribute10_o
411: => per_add_shd.g_old_rec.addr_attribute10
405: => per_add_shd.g_old_rec.addr_attribute7
406: ,p_addr_attribute8_o
407: => per_add_shd.g_old_rec.addr_attribute8
408: ,p_addr_attribute9_o
409: => per_add_shd.g_old_rec.addr_attribute9
410: ,p_addr_attribute10_o
411: => per_add_shd.g_old_rec.addr_attribute10
412: ,p_addr_attribute11_o
413: => per_add_shd.g_old_rec.addr_attribute11
407: => per_add_shd.g_old_rec.addr_attribute8
408: ,p_addr_attribute9_o
409: => per_add_shd.g_old_rec.addr_attribute9
410: ,p_addr_attribute10_o
411: => per_add_shd.g_old_rec.addr_attribute10
412: ,p_addr_attribute11_o
413: => per_add_shd.g_old_rec.addr_attribute11
414: ,p_addr_attribute12_o
415: => per_add_shd.g_old_rec.addr_attribute12
409: => per_add_shd.g_old_rec.addr_attribute9
410: ,p_addr_attribute10_o
411: => per_add_shd.g_old_rec.addr_attribute10
412: ,p_addr_attribute11_o
413: => per_add_shd.g_old_rec.addr_attribute11
414: ,p_addr_attribute12_o
415: => per_add_shd.g_old_rec.addr_attribute12
416: ,p_addr_attribute13_o
417: => per_add_shd.g_old_rec.addr_attribute13
411: => per_add_shd.g_old_rec.addr_attribute10
412: ,p_addr_attribute11_o
413: => per_add_shd.g_old_rec.addr_attribute11
414: ,p_addr_attribute12_o
415: => per_add_shd.g_old_rec.addr_attribute12
416: ,p_addr_attribute13_o
417: => per_add_shd.g_old_rec.addr_attribute13
418: ,p_addr_attribute14_o
419: => per_add_shd.g_old_rec.addr_attribute14
413: => per_add_shd.g_old_rec.addr_attribute11
414: ,p_addr_attribute12_o
415: => per_add_shd.g_old_rec.addr_attribute12
416: ,p_addr_attribute13_o
417: => per_add_shd.g_old_rec.addr_attribute13
418: ,p_addr_attribute14_o
419: => per_add_shd.g_old_rec.addr_attribute14
420: ,p_addr_attribute15_o
421: => per_add_shd.g_old_rec.addr_attribute15
415: => per_add_shd.g_old_rec.addr_attribute12
416: ,p_addr_attribute13_o
417: => per_add_shd.g_old_rec.addr_attribute13
418: ,p_addr_attribute14_o
419: => per_add_shd.g_old_rec.addr_attribute14
420: ,p_addr_attribute15_o
421: => per_add_shd.g_old_rec.addr_attribute15
422: ,p_addr_attribute16_o
423: => per_add_shd.g_old_rec.addr_attribute16
417: => per_add_shd.g_old_rec.addr_attribute13
418: ,p_addr_attribute14_o
419: => per_add_shd.g_old_rec.addr_attribute14
420: ,p_addr_attribute15_o
421: => per_add_shd.g_old_rec.addr_attribute15
422: ,p_addr_attribute16_o
423: => per_add_shd.g_old_rec.addr_attribute16
424: ,p_addr_attribute17_o
425: => per_add_shd.g_old_rec.addr_attribute17
419: => per_add_shd.g_old_rec.addr_attribute14
420: ,p_addr_attribute15_o
421: => per_add_shd.g_old_rec.addr_attribute15
422: ,p_addr_attribute16_o
423: => per_add_shd.g_old_rec.addr_attribute16
424: ,p_addr_attribute17_o
425: => per_add_shd.g_old_rec.addr_attribute17
426: ,p_addr_attribute18_o
427: => per_add_shd.g_old_rec.addr_attribute18
421: => per_add_shd.g_old_rec.addr_attribute15
422: ,p_addr_attribute16_o
423: => per_add_shd.g_old_rec.addr_attribute16
424: ,p_addr_attribute17_o
425: => per_add_shd.g_old_rec.addr_attribute17
426: ,p_addr_attribute18_o
427: => per_add_shd.g_old_rec.addr_attribute18
428: ,p_addr_attribute19_o
429: => per_add_shd.g_old_rec.addr_attribute19
423: => per_add_shd.g_old_rec.addr_attribute16
424: ,p_addr_attribute17_o
425: => per_add_shd.g_old_rec.addr_attribute17
426: ,p_addr_attribute18_o
427: => per_add_shd.g_old_rec.addr_attribute18
428: ,p_addr_attribute19_o
429: => per_add_shd.g_old_rec.addr_attribute19
430: ,p_addr_attribute20_o
431: => per_add_shd.g_old_rec.addr_attribute20
425: => per_add_shd.g_old_rec.addr_attribute17
426: ,p_addr_attribute18_o
427: => per_add_shd.g_old_rec.addr_attribute18
428: ,p_addr_attribute19_o
429: => per_add_shd.g_old_rec.addr_attribute19
430: ,p_addr_attribute20_o
431: => per_add_shd.g_old_rec.addr_attribute20
432: ,p_add_information13_o
433: => per_add_shd.g_old_rec.add_information13
427: => per_add_shd.g_old_rec.addr_attribute18
428: ,p_addr_attribute19_o
429: => per_add_shd.g_old_rec.addr_attribute19
430: ,p_addr_attribute20_o
431: => per_add_shd.g_old_rec.addr_attribute20
432: ,p_add_information13_o
433: => per_add_shd.g_old_rec.add_information13
434: ,p_add_information14_o
435: => per_add_shd.g_old_rec.add_information14
429: => per_add_shd.g_old_rec.addr_attribute19
430: ,p_addr_attribute20_o
431: => per_add_shd.g_old_rec.addr_attribute20
432: ,p_add_information13_o
433: => per_add_shd.g_old_rec.add_information13
434: ,p_add_information14_o
435: => per_add_shd.g_old_rec.add_information14
436: ,p_add_information15_o
437: => per_add_shd.g_old_rec.add_information15
431: => per_add_shd.g_old_rec.addr_attribute20
432: ,p_add_information13_o
433: => per_add_shd.g_old_rec.add_information13
434: ,p_add_information14_o
435: => per_add_shd.g_old_rec.add_information14
436: ,p_add_information15_o
437: => per_add_shd.g_old_rec.add_information15
438: ,p_add_information16_o
439: => per_add_shd.g_old_rec.add_information16
433: => per_add_shd.g_old_rec.add_information13
434: ,p_add_information14_o
435: => per_add_shd.g_old_rec.add_information14
436: ,p_add_information15_o
437: => per_add_shd.g_old_rec.add_information15
438: ,p_add_information16_o
439: => per_add_shd.g_old_rec.add_information16
440: ,p_add_information17_o
441: => per_add_shd.g_old_rec.add_information17
435: => per_add_shd.g_old_rec.add_information14
436: ,p_add_information15_o
437: => per_add_shd.g_old_rec.add_information15
438: ,p_add_information16_o
439: => per_add_shd.g_old_rec.add_information16
440: ,p_add_information17_o
441: => per_add_shd.g_old_rec.add_information17
442: ,p_add_information18_o
443: => per_add_shd.g_old_rec.add_information18
437: => per_add_shd.g_old_rec.add_information15
438: ,p_add_information16_o
439: => per_add_shd.g_old_rec.add_information16
440: ,p_add_information17_o
441: => per_add_shd.g_old_rec.add_information17
442: ,p_add_information18_o
443: => per_add_shd.g_old_rec.add_information18
444: ,p_add_information19_o
445: => per_add_shd.g_old_rec.add_information19
439: => per_add_shd.g_old_rec.add_information16
440: ,p_add_information17_o
441: => per_add_shd.g_old_rec.add_information17
442: ,p_add_information18_o
443: => per_add_shd.g_old_rec.add_information18
444: ,p_add_information19_o
445: => per_add_shd.g_old_rec.add_information19
446: ,p_add_information20_o
447: => per_add_shd.g_old_rec.add_information20
441: => per_add_shd.g_old_rec.add_information17
442: ,p_add_information18_o
443: => per_add_shd.g_old_rec.add_information18
444: ,p_add_information19_o
445: => per_add_shd.g_old_rec.add_information19
446: ,p_add_information20_o
447: => per_add_shd.g_old_rec.add_information20
448: ,p_object_version_number_o
449: => per_add_shd.g_old_rec.object_version_number
443: => per_add_shd.g_old_rec.add_information18
444: ,p_add_information19_o
445: => per_add_shd.g_old_rec.add_information19
446: ,p_add_information20_o
447: => per_add_shd.g_old_rec.add_information20
448: ,p_object_version_number_o
449: => per_add_shd.g_old_rec.object_version_number
450: ,p_party_id_o -- HR/TCA merge
451: => per_add_shd.g_old_rec.party_id
445: => per_add_shd.g_old_rec.add_information19
446: ,p_add_information20_o
447: => per_add_shd.g_old_rec.add_information20
448: ,p_object_version_number_o
449: => per_add_shd.g_old_rec.object_version_number
450: ,p_party_id_o -- HR/TCA merge
451: => per_add_shd.g_old_rec.party_id
452: );
453: exception
447: => per_add_shd.g_old_rec.add_information20
448: ,p_object_version_number_o
449: => per_add_shd.g_old_rec.object_version_number
450: ,p_party_id_o -- HR/TCA merge
451: => per_add_shd.g_old_rec.party_id
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
459: end;
460: --
461: -- Fix for WWBUG 1408379
462: --
463: l_old.person_id := per_add_shd.g_old_rec.person_id;
464: l_old.business_group_id := per_add_shd.g_old_rec.business_group_id;
465: l_old.date_from := per_add_shd.g_old_rec.date_from;
466: l_old.date_to := per_add_shd.g_old_rec.date_to;
467: l_old.primary_flag := per_add_shd.g_old_rec.primary_flag;
460: --
461: -- Fix for WWBUG 1408379
462: --
463: l_old.person_id := per_add_shd.g_old_rec.person_id;
464: l_old.business_group_id := per_add_shd.g_old_rec.business_group_id;
465: l_old.date_from := per_add_shd.g_old_rec.date_from;
466: l_old.date_to := per_add_shd.g_old_rec.date_to;
467: l_old.primary_flag := per_add_shd.g_old_rec.primary_flag;
468: l_old.postal_code := per_add_shd.g_old_rec.postal_code;
461: -- Fix for WWBUG 1408379
462: --
463: l_old.person_id := per_add_shd.g_old_rec.person_id;
464: l_old.business_group_id := per_add_shd.g_old_rec.business_group_id;
465: l_old.date_from := per_add_shd.g_old_rec.date_from;
466: l_old.date_to := per_add_shd.g_old_rec.date_to;
467: l_old.primary_flag := per_add_shd.g_old_rec.primary_flag;
468: l_old.postal_code := per_add_shd.g_old_rec.postal_code;
469: l_old.region_2 := per_add_shd.g_old_rec.region_2;
462: --
463: l_old.person_id := per_add_shd.g_old_rec.person_id;
464: l_old.business_group_id := per_add_shd.g_old_rec.business_group_id;
465: l_old.date_from := per_add_shd.g_old_rec.date_from;
466: l_old.date_to := per_add_shd.g_old_rec.date_to;
467: l_old.primary_flag := per_add_shd.g_old_rec.primary_flag;
468: l_old.postal_code := per_add_shd.g_old_rec.postal_code;
469: l_old.region_2 := per_add_shd.g_old_rec.region_2;
470: l_old.address_type := per_add_shd.g_old_rec.address_type;
463: l_old.person_id := per_add_shd.g_old_rec.person_id;
464: l_old.business_group_id := per_add_shd.g_old_rec.business_group_id;
465: l_old.date_from := per_add_shd.g_old_rec.date_from;
466: l_old.date_to := per_add_shd.g_old_rec.date_to;
467: l_old.primary_flag := per_add_shd.g_old_rec.primary_flag;
468: l_old.postal_code := per_add_shd.g_old_rec.postal_code;
469: l_old.region_2 := per_add_shd.g_old_rec.region_2;
470: l_old.address_type := per_add_shd.g_old_rec.address_type;
471: l_old.address_id := per_add_shd.g_old_rec.address_id;
464: l_old.business_group_id := per_add_shd.g_old_rec.business_group_id;
465: l_old.date_from := per_add_shd.g_old_rec.date_from;
466: l_old.date_to := per_add_shd.g_old_rec.date_to;
467: l_old.primary_flag := per_add_shd.g_old_rec.primary_flag;
468: l_old.postal_code := per_add_shd.g_old_rec.postal_code;
469: l_old.region_2 := per_add_shd.g_old_rec.region_2;
470: l_old.address_type := per_add_shd.g_old_rec.address_type;
471: l_old.address_id := per_add_shd.g_old_rec.address_id;
472: l_new.person_id := p_rec.person_id;
465: l_old.date_from := per_add_shd.g_old_rec.date_from;
466: l_old.date_to := per_add_shd.g_old_rec.date_to;
467: l_old.primary_flag := per_add_shd.g_old_rec.primary_flag;
468: l_old.postal_code := per_add_shd.g_old_rec.postal_code;
469: l_old.region_2 := per_add_shd.g_old_rec.region_2;
470: l_old.address_type := per_add_shd.g_old_rec.address_type;
471: l_old.address_id := per_add_shd.g_old_rec.address_id;
472: l_new.person_id := p_rec.person_id;
473: l_new.business_group_id := p_rec.business_group_id;
466: l_old.date_to := per_add_shd.g_old_rec.date_to;
467: l_old.primary_flag := per_add_shd.g_old_rec.primary_flag;
468: l_old.postal_code := per_add_shd.g_old_rec.postal_code;
469: l_old.region_2 := per_add_shd.g_old_rec.region_2;
470: l_old.address_type := per_add_shd.g_old_rec.address_type;
471: l_old.address_id := per_add_shd.g_old_rec.address_id;
472: l_new.person_id := p_rec.person_id;
473: l_new.business_group_id := p_rec.business_group_id;
474: l_new.date_from := p_rec.date_from;
467: l_old.primary_flag := per_add_shd.g_old_rec.primary_flag;
468: l_old.postal_code := per_add_shd.g_old_rec.postal_code;
469: l_old.region_2 := per_add_shd.g_old_rec.region_2;
470: l_old.address_type := per_add_shd.g_old_rec.address_type;
471: l_old.address_id := per_add_shd.g_old_rec.address_id;
472: l_new.person_id := p_rec.person_id;
473: l_new.business_group_id := p_rec.business_group_id;
474: l_new.date_from := p_rec.date_from;
475: l_new.date_to := p_rec.date_to;
533: -- Internal Table Handler Use Only.
534: --
535: -- {End Of Comments}
536: -- ----------------------------------------------------------------------------
537: Function convert_defs(p_rec in out nocopy per_add_shd.g_rec_type)
538: Return per_add_shd.g_rec_type is
539: --
540: l_proc varchar2(72) := g_package||'convert_defs';
541: --
534: --
535: -- {End Of Comments}
536: -- ----------------------------------------------------------------------------
537: Function convert_defs(p_rec in out nocopy per_add_shd.g_rec_type)
538: Return per_add_shd.g_rec_type is
539: --
540: l_proc varchar2(72) := g_package||'convert_defs';
541: --
542: Begin
549: -- is being used then we must set to the 'current' argument value.
550: --
551: If (p_rec.business_group_id = hr_api.g_number) then
552: p_rec.business_group_id :=
553: per_add_shd.g_old_rec.business_group_id;
554: End If;
555: If (p_rec.person_id = hr_api.g_number) then
556: p_rec.person_id :=
557: per_add_shd.g_old_rec.person_id;
553: per_add_shd.g_old_rec.business_group_id;
554: End If;
555: If (p_rec.person_id = hr_api.g_number) then
556: p_rec.person_id :=
557: per_add_shd.g_old_rec.person_id;
558: End If;
559: If (p_rec.date_from = hr_api.g_date) then
560: p_rec.date_from :=
561: per_add_shd.g_old_rec.date_from;
557: per_add_shd.g_old_rec.person_id;
558: End If;
559: If (p_rec.date_from = hr_api.g_date) then
560: p_rec.date_from :=
561: per_add_shd.g_old_rec.date_from;
562: End If;
563: If (p_rec.primary_flag = hr_api.g_varchar2) then
564: p_rec.primary_flag :=
565: per_add_shd.g_old_rec.primary_flag;
561: per_add_shd.g_old_rec.date_from;
562: End If;
563: If (p_rec.primary_flag = hr_api.g_varchar2) then
564: p_rec.primary_flag :=
565: per_add_shd.g_old_rec.primary_flag;
566: End If;
567: If (p_rec.style = hr_api.g_varchar2) then
568: p_rec.style :=
569: per_add_shd.g_old_rec.style;
565: per_add_shd.g_old_rec.primary_flag;
566: End If;
567: If (p_rec.style = hr_api.g_varchar2) then
568: p_rec.style :=
569: per_add_shd.g_old_rec.style;
570: End If;
571: If (p_rec.address_line1 = hr_api.g_varchar2) then
572: p_rec.address_line1 :=
573: per_add_shd.g_old_rec.address_line1;
569: per_add_shd.g_old_rec.style;
570: End If;
571: If (p_rec.address_line1 = hr_api.g_varchar2) then
572: p_rec.address_line1 :=
573: per_add_shd.g_old_rec.address_line1;
574: End If;
575: If (p_rec.address_line2 = hr_api.g_varchar2) then
576: p_rec.address_line2 :=
577: per_add_shd.g_old_rec.address_line2;
573: per_add_shd.g_old_rec.address_line1;
574: End If;
575: If (p_rec.address_line2 = hr_api.g_varchar2) then
576: p_rec.address_line2 :=
577: per_add_shd.g_old_rec.address_line2;
578: End If;
579: If (p_rec.address_line3 = hr_api.g_varchar2) then
580: p_rec.address_line3 :=
581: per_add_shd.g_old_rec.address_line3;
577: per_add_shd.g_old_rec.address_line2;
578: End If;
579: If (p_rec.address_line3 = hr_api.g_varchar2) then
580: p_rec.address_line3 :=
581: per_add_shd.g_old_rec.address_line3;
582: End If;
583: If (p_rec.address_type = hr_api.g_varchar2) then
584: p_rec.address_type :=
585: per_add_shd.g_old_rec.address_type;
581: per_add_shd.g_old_rec.address_line3;
582: End If;
583: If (p_rec.address_type = hr_api.g_varchar2) then
584: p_rec.address_type :=
585: per_add_shd.g_old_rec.address_type;
586: End If;
587: If (p_rec.comments = hr_api.g_varchar2) then
588: p_rec.comments :=
589: per_add_shd.g_old_rec.comments;
585: per_add_shd.g_old_rec.address_type;
586: End If;
587: If (p_rec.comments = hr_api.g_varchar2) then
588: p_rec.comments :=
589: per_add_shd.g_old_rec.comments;
590: End If;
591: If (p_rec.country = hr_api.g_varchar2) then
592: p_rec.country :=
593: per_add_shd.g_old_rec.country;
589: per_add_shd.g_old_rec.comments;
590: End If;
591: If (p_rec.country = hr_api.g_varchar2) then
592: p_rec.country :=
593: per_add_shd.g_old_rec.country;
594: End If;
595: If (p_rec.date_to = hr_api.g_date) then
596: p_rec.date_to :=
597: per_add_shd.g_old_rec.date_to;
593: per_add_shd.g_old_rec.country;
594: End If;
595: If (p_rec.date_to = hr_api.g_date) then
596: p_rec.date_to :=
597: per_add_shd.g_old_rec.date_to;
598: End If;
599: If (p_rec.postal_code = hr_api.g_varchar2) then
600: p_rec.postal_code :=
601: per_add_shd.g_old_rec.postal_code;
597: per_add_shd.g_old_rec.date_to;
598: End If;
599: If (p_rec.postal_code = hr_api.g_varchar2) then
600: p_rec.postal_code :=
601: per_add_shd.g_old_rec.postal_code;
602: End If;
603: If (p_rec.region_1 = hr_api.g_varchar2) then
604: p_rec.region_1 :=
605: per_add_shd.g_old_rec.region_1;
601: per_add_shd.g_old_rec.postal_code;
602: End If;
603: If (p_rec.region_1 = hr_api.g_varchar2) then
604: p_rec.region_1 :=
605: per_add_shd.g_old_rec.region_1;
606: End If;
607: If (p_rec.region_2 = hr_api.g_varchar2) then
608: p_rec.region_2 :=
609: per_add_shd.g_old_rec.region_2;
605: per_add_shd.g_old_rec.region_1;
606: End If;
607: If (p_rec.region_2 = hr_api.g_varchar2) then
608: p_rec.region_2 :=
609: per_add_shd.g_old_rec.region_2;
610: End If;
611: If (p_rec.region_3 = hr_api.g_varchar2) then
612: p_rec.region_3 :=
613: per_add_shd.g_old_rec.region_3;
609: per_add_shd.g_old_rec.region_2;
610: End If;
611: If (p_rec.region_3 = hr_api.g_varchar2) then
612: p_rec.region_3 :=
613: per_add_shd.g_old_rec.region_3;
614: End If;
615: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
616: p_rec.telephone_number_1 :=
617: per_add_shd.g_old_rec.telephone_number_1;
613: per_add_shd.g_old_rec.region_3;
614: End If;
615: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
616: p_rec.telephone_number_1 :=
617: per_add_shd.g_old_rec.telephone_number_1;
618: End If;
619: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
620: p_rec.telephone_number_2 :=
621: per_add_shd.g_old_rec.telephone_number_2;
617: per_add_shd.g_old_rec.telephone_number_1;
618: End If;
619: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
620: p_rec.telephone_number_2 :=
621: per_add_shd.g_old_rec.telephone_number_2;
622: End If;
623: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
624: p_rec.telephone_number_3 :=
625: per_add_shd.g_old_rec.telephone_number_3;
621: per_add_shd.g_old_rec.telephone_number_2;
622: End If;
623: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
624: p_rec.telephone_number_3 :=
625: per_add_shd.g_old_rec.telephone_number_3;
626: End If;
627: If (p_rec.town_or_city = hr_api.g_varchar2) then
628: p_rec.town_or_city :=
629: per_add_shd.g_old_rec.town_or_city;
625: per_add_shd.g_old_rec.telephone_number_3;
626: End If;
627: If (p_rec.town_or_city = hr_api.g_varchar2) then
628: p_rec.town_or_city :=
629: per_add_shd.g_old_rec.town_or_city;
630: End If;
631: If (p_rec.request_id = hr_api.g_number) then
632: p_rec.request_id :=
633: per_add_shd.g_old_rec.request_id;
629: per_add_shd.g_old_rec.town_or_city;
630: End If;
631: If (p_rec.request_id = hr_api.g_number) then
632: p_rec.request_id :=
633: per_add_shd.g_old_rec.request_id;
634: End If;
635: If (p_rec.program_application_id = hr_api.g_number) then
636: p_rec.program_application_id :=
637: per_add_shd.g_old_rec.program_application_id;
633: per_add_shd.g_old_rec.request_id;
634: End If;
635: If (p_rec.program_application_id = hr_api.g_number) then
636: p_rec.program_application_id :=
637: per_add_shd.g_old_rec.program_application_id;
638: End If;
639: If (p_rec.program_id = hr_api.g_number) then
640: p_rec.program_id :=
641: per_add_shd.g_old_rec.program_id;
637: per_add_shd.g_old_rec.program_application_id;
638: End If;
639: If (p_rec.program_id = hr_api.g_number) then
640: p_rec.program_id :=
641: per_add_shd.g_old_rec.program_id;
642: End If;
643: If (p_rec.program_update_date = hr_api.g_date) then
644: p_rec.program_update_date :=
645: per_add_shd.g_old_rec.program_update_date;
641: per_add_shd.g_old_rec.program_id;
642: End If;
643: If (p_rec.program_update_date = hr_api.g_date) then
644: p_rec.program_update_date :=
645: per_add_shd.g_old_rec.program_update_date;
646: End If;
647: If (p_rec.addr_attribute_category = hr_api.g_varchar2) then
648: p_rec.addr_attribute_category :=
649: per_add_shd.g_old_rec.addr_attribute_category;
645: per_add_shd.g_old_rec.program_update_date;
646: End If;
647: If (p_rec.addr_attribute_category = hr_api.g_varchar2) then
648: p_rec.addr_attribute_category :=
649: per_add_shd.g_old_rec.addr_attribute_category;
650: End If;
651: If (p_rec.addr_attribute1 = hr_api.g_varchar2) then
652: p_rec.addr_attribute1 :=
653: per_add_shd.g_old_rec.addr_attribute1;
649: per_add_shd.g_old_rec.addr_attribute_category;
650: End If;
651: If (p_rec.addr_attribute1 = hr_api.g_varchar2) then
652: p_rec.addr_attribute1 :=
653: per_add_shd.g_old_rec.addr_attribute1;
654: End If;
655: If (p_rec.addr_attribute2 = hr_api.g_varchar2) then
656: p_rec.addr_attribute2 :=
657: per_add_shd.g_old_rec.addr_attribute2;
653: per_add_shd.g_old_rec.addr_attribute1;
654: End If;
655: If (p_rec.addr_attribute2 = hr_api.g_varchar2) then
656: p_rec.addr_attribute2 :=
657: per_add_shd.g_old_rec.addr_attribute2;
658: End If;
659: If (p_rec.addr_attribute3 = hr_api.g_varchar2) then
660: p_rec.addr_attribute3 :=
661: per_add_shd.g_old_rec.addr_attribute3;
657: per_add_shd.g_old_rec.addr_attribute2;
658: End If;
659: If (p_rec.addr_attribute3 = hr_api.g_varchar2) then
660: p_rec.addr_attribute3 :=
661: per_add_shd.g_old_rec.addr_attribute3;
662: End If;
663: If (p_rec.addr_attribute4 = hr_api.g_varchar2) then
664: p_rec.addr_attribute4 :=
665: per_add_shd.g_old_rec.addr_attribute4;
661: per_add_shd.g_old_rec.addr_attribute3;
662: End If;
663: If (p_rec.addr_attribute4 = hr_api.g_varchar2) then
664: p_rec.addr_attribute4 :=
665: per_add_shd.g_old_rec.addr_attribute4;
666: End If;
667: If (p_rec.addr_attribute5 = hr_api.g_varchar2) then
668: p_rec.addr_attribute5 :=
669: per_add_shd.g_old_rec.addr_attribute5;
665: per_add_shd.g_old_rec.addr_attribute4;
666: End If;
667: If (p_rec.addr_attribute5 = hr_api.g_varchar2) then
668: p_rec.addr_attribute5 :=
669: per_add_shd.g_old_rec.addr_attribute5;
670: End If;
671: If (p_rec.addr_attribute6 = hr_api.g_varchar2) then
672: p_rec.addr_attribute6 :=
673: per_add_shd.g_old_rec.addr_attribute6;
669: per_add_shd.g_old_rec.addr_attribute5;
670: End If;
671: If (p_rec.addr_attribute6 = hr_api.g_varchar2) then
672: p_rec.addr_attribute6 :=
673: per_add_shd.g_old_rec.addr_attribute6;
674: End If;
675: If (p_rec.addr_attribute7 = hr_api.g_varchar2) then
676: p_rec.addr_attribute7 :=
677: per_add_shd.g_old_rec.addr_attribute7;
673: per_add_shd.g_old_rec.addr_attribute6;
674: End If;
675: If (p_rec.addr_attribute7 = hr_api.g_varchar2) then
676: p_rec.addr_attribute7 :=
677: per_add_shd.g_old_rec.addr_attribute7;
678: End If;
679: If (p_rec.addr_attribute8 = hr_api.g_varchar2) then
680: p_rec.addr_attribute8 :=
681: per_add_shd.g_old_rec.addr_attribute8;
677: per_add_shd.g_old_rec.addr_attribute7;
678: End If;
679: If (p_rec.addr_attribute8 = hr_api.g_varchar2) then
680: p_rec.addr_attribute8 :=
681: per_add_shd.g_old_rec.addr_attribute8;
682: End If;
683: If (p_rec.addr_attribute9 = hr_api.g_varchar2) then
684: p_rec.addr_attribute9 :=
685: per_add_shd.g_old_rec.addr_attribute9;
681: per_add_shd.g_old_rec.addr_attribute8;
682: End If;
683: If (p_rec.addr_attribute9 = hr_api.g_varchar2) then
684: p_rec.addr_attribute9 :=
685: per_add_shd.g_old_rec.addr_attribute9;
686: End If;
687: If (p_rec.addr_attribute10 = hr_api.g_varchar2) then
688: p_rec.addr_attribute10 :=
689: per_add_shd.g_old_rec.addr_attribute10;
685: per_add_shd.g_old_rec.addr_attribute9;
686: End If;
687: If (p_rec.addr_attribute10 = hr_api.g_varchar2) then
688: p_rec.addr_attribute10 :=
689: per_add_shd.g_old_rec.addr_attribute10;
690: End If;
691: If (p_rec.addr_attribute11 = hr_api.g_varchar2) then
692: p_rec.addr_attribute11 :=
693: per_add_shd.g_old_rec.addr_attribute11;
689: per_add_shd.g_old_rec.addr_attribute10;
690: End If;
691: If (p_rec.addr_attribute11 = hr_api.g_varchar2) then
692: p_rec.addr_attribute11 :=
693: per_add_shd.g_old_rec.addr_attribute11;
694: End If;
695: If (p_rec.addr_attribute12 = hr_api.g_varchar2) then
696: p_rec.addr_attribute12 :=
697: per_add_shd.g_old_rec.addr_attribute12;
693: per_add_shd.g_old_rec.addr_attribute11;
694: End If;
695: If (p_rec.addr_attribute12 = hr_api.g_varchar2) then
696: p_rec.addr_attribute12 :=
697: per_add_shd.g_old_rec.addr_attribute12;
698: End If;
699: If (p_rec.addr_attribute13 = hr_api.g_varchar2) then
700: p_rec.addr_attribute13 :=
701: per_add_shd.g_old_rec.addr_attribute13;
697: per_add_shd.g_old_rec.addr_attribute12;
698: End If;
699: If (p_rec.addr_attribute13 = hr_api.g_varchar2) then
700: p_rec.addr_attribute13 :=
701: per_add_shd.g_old_rec.addr_attribute13;
702: End If;
703: If (p_rec.addr_attribute14 = hr_api.g_varchar2) then
704: p_rec.addr_attribute14 :=
705: per_add_shd.g_old_rec.addr_attribute14;
701: per_add_shd.g_old_rec.addr_attribute13;
702: End If;
703: If (p_rec.addr_attribute14 = hr_api.g_varchar2) then
704: p_rec.addr_attribute14 :=
705: per_add_shd.g_old_rec.addr_attribute14;
706: End If;
707: If (p_rec.addr_attribute15 = hr_api.g_varchar2) then
708: p_rec.addr_attribute15 :=
709: per_add_shd.g_old_rec.addr_attribute15;
705: per_add_shd.g_old_rec.addr_attribute14;
706: End If;
707: If (p_rec.addr_attribute15 = hr_api.g_varchar2) then
708: p_rec.addr_attribute15 :=
709: per_add_shd.g_old_rec.addr_attribute15;
710: End If;
711: If (p_rec.addr_attribute16 = hr_api.g_varchar2) then
712: p_rec.addr_attribute16 :=
713: per_add_shd.g_old_rec.addr_attribute16;
709: per_add_shd.g_old_rec.addr_attribute15;
710: End If;
711: If (p_rec.addr_attribute16 = hr_api.g_varchar2) then
712: p_rec.addr_attribute16 :=
713: per_add_shd.g_old_rec.addr_attribute16;
714: End If;
715: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then
716: p_rec.addr_attribute17 :=
717: per_add_shd.g_old_rec.addr_attribute17;
713: per_add_shd.g_old_rec.addr_attribute16;
714: End If;
715: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then
716: p_rec.addr_attribute17 :=
717: per_add_shd.g_old_rec.addr_attribute17;
718: End If;
719: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then
720: p_rec.addr_attribute18 :=
721: per_add_shd.g_old_rec.addr_attribute18;
717: per_add_shd.g_old_rec.addr_attribute17;
718: End If;
719: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then
720: p_rec.addr_attribute18 :=
721: per_add_shd.g_old_rec.addr_attribute18;
722: End If;
723: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then
724: p_rec.addr_attribute19 :=
725: per_add_shd.g_old_rec.addr_attribute19;
721: per_add_shd.g_old_rec.addr_attribute18;
722: End If;
723: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then
724: p_rec.addr_attribute19 :=
725: per_add_shd.g_old_rec.addr_attribute19;
726: End If;
727: If (p_rec.addr_attribute20 = hr_api.g_varchar2) then
728: p_rec.addr_attribute20 :=
729: per_add_shd.g_old_rec.addr_attribute20;
725: per_add_shd.g_old_rec.addr_attribute19;
726: End If;
727: If (p_rec.addr_attribute20 = hr_api.g_varchar2) then
728: p_rec.addr_attribute20 :=
729: per_add_shd.g_old_rec.addr_attribute20;
730: End If;
731: If (p_rec.add_information13 = hr_api.g_varchar2) then
732: p_rec.add_information13 :=
733: per_add_shd.g_old_rec.add_information13;
729: per_add_shd.g_old_rec.addr_attribute20;
730: End If;
731: If (p_rec.add_information13 = hr_api.g_varchar2) then
732: p_rec.add_information13 :=
733: per_add_shd.g_old_rec.add_information13;
734: End If;
735: If (p_rec.add_information14 = hr_api.g_varchar2) then
736: p_rec.add_information14 :=
737: per_add_shd.g_old_rec.add_information14;
733: per_add_shd.g_old_rec.add_information13;
734: End If;
735: If (p_rec.add_information14 = hr_api.g_varchar2) then
736: p_rec.add_information14 :=
737: per_add_shd.g_old_rec.add_information14;
738: End If;
739: If (p_rec.add_information15 = hr_api.g_varchar2) then
740: p_rec.add_information15 :=
741: per_add_shd.g_old_rec.add_information15;
737: per_add_shd.g_old_rec.add_information14;
738: End If;
739: If (p_rec.add_information15 = hr_api.g_varchar2) then
740: p_rec.add_information15 :=
741: per_add_shd.g_old_rec.add_information15;
742: End If;
743: If (p_rec.add_information16 = hr_api.g_varchar2) then
744: p_rec.add_information16 :=
745: per_add_shd.g_old_rec.add_information16;
741: per_add_shd.g_old_rec.add_information15;
742: End If;
743: If (p_rec.add_information16 = hr_api.g_varchar2) then
744: p_rec.add_information16 :=
745: per_add_shd.g_old_rec.add_information16;
746: End If;
747: If (p_rec.add_information17 = hr_api.g_varchar2) then
748: p_rec.add_information17 :=
749: per_add_shd.g_old_rec.add_information17;
745: per_add_shd.g_old_rec.add_information16;
746: End If;
747: If (p_rec.add_information17 = hr_api.g_varchar2) then
748: p_rec.add_information17 :=
749: per_add_shd.g_old_rec.add_information17;
750: End If;
751: If (p_rec.add_information18 = hr_api.g_varchar2) then
752: p_rec.add_information18 :=
753: per_add_shd.g_old_rec.add_information18;
749: per_add_shd.g_old_rec.add_information17;
750: End If;
751: If (p_rec.add_information18 = hr_api.g_varchar2) then
752: p_rec.add_information18 :=
753: per_add_shd.g_old_rec.add_information18;
754: End If;
755: If (p_rec.add_information19 = hr_api.g_varchar2) then
756: p_rec.add_information19 :=
757: per_add_shd.g_old_rec.add_information19;
753: per_add_shd.g_old_rec.add_information18;
754: End If;
755: If (p_rec.add_information19 = hr_api.g_varchar2) then
756: p_rec.add_information19 :=
757: per_add_shd.g_old_rec.add_information19;
758: End If;
759: If (p_rec.add_information20 = hr_api.g_varchar2) then
760: p_rec.add_information20 :=
761: per_add_shd.g_old_rec.add_information20;
757: per_add_shd.g_old_rec.add_information19;
758: End If;
759: If (p_rec.add_information20 = hr_api.g_varchar2) then
760: p_rec.add_information20 :=
761: per_add_shd.g_old_rec.add_information20;
762: End If;
763: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
764: p_rec.party_id :=
765: per_add_shd.g_old_rec.party_id;
761: per_add_shd.g_old_rec.add_information20;
762: End If;
763: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
764: p_rec.party_id :=
765: per_add_shd.g_old_rec.party_id;
766: End If;
767:
768: --
769: -- Return the plsql record structure.
776: -- ----------------------------------------------------------------------------
777: -- |---------------------------------< upd >----------------------------------|
778: -- ----------------------------------------------------------------------------
779: Procedure upd
780: (p_rec in out nocopy per_add_shd.g_rec_type
781: ,p_validate in boolean default false
782: ,p_effective_date in date
783: ,p_prflagval_override in boolean default false
784: ,p_validate_county in boolean default true
784: ,p_validate_county in boolean default true
785: ) is
786: --
787: l_proc varchar2(72) := g_package||'upd';
788: l_convert per_add_shd.g_rec_type;
789: --
790: Begin
791: hr_utility.set_location('Entering:'||l_proc, 5);
792: --
800: End If;
801: --
802: -- We must lock the row which we need to update.
803: --
804: per_add_shd.lck
805: (
806: p_rec.address_id,
807: p_rec.object_version_number
808: );
928: ,p_validate_county in boolean default true
929: ,p_style in varchar2 default hr_api.g_varchar2
930: ) is
931: --
932: l_rec per_add_shd.g_rec_type;
933: l_proc varchar2(72) := g_package||'upd';
934: --
935: Begin
936: hr_utility.set_location('Entering:'||l_proc, 5);
938: -- Call conversion function to turn arguments into the
939: -- l_rec structure.
940: --
941: l_rec :=
942: per_add_shd.convert_args
943: (
944: p_address_id,
945: -- 70.2 change a start.
946: p_business_group_id,