52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy irc_isc_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: l_description clob;
70: l_geometry:=mdsys.sdo_geometry(2001,8307
71: ,mdsys.sdo_point_type(p_rec.longitude,p_rec.latitude,null),null,null);
72: end if;
73: --
74: irc_isc_shd.g_api_dml := true; -- Set the api dml status
75: --
76: -- Update the irc_search_criteria Row
77: --
78: update irc_search_criteria
185: ,1
186: ,p_rec.description);
187: end if;
188: --
189: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 20);
192: --
193: Exception
192: --
193: Exception
194: When hr_api.check_integrity_violated Then
195: -- A check constraint has been violated
196: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: irc_isc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.parent_integrity_violated Then
194: When hr_api.check_integrity_violated Then
195: -- A check constraint has been violated
196: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: irc_isc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.parent_integrity_violated Then
201: -- Parent integrity has been violated
202: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
198: irc_isc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.parent_integrity_violated Then
201: -- Parent integrity has been violated
202: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
203: --
204: irc_isc_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
200: When hr_api.parent_integrity_violated Then
201: -- Parent integrity has been violated
202: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
203: --
204: irc_isc_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
204: irc_isc_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
209: --
210: irc_isc_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When Others Then
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
209: --
210: irc_isc_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When Others Then
213: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
214: --
209: --
210: irc_isc_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When Others Then
213: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
214: --
215: Raise;
216: End update_dml;
217: --
247: --
248: -- {End Of Comments}
249: -- ----------------------------------------------------------------------------
250: Procedure pre_update
251: (p_rec in irc_isc_shd.g_rec_type
252: ) is
253: --
254: l_proc varchar2(72) := g_package||'pre_update';
255: --
292: -- {End Of Comments}
293: -- ----------------------------------------------------------------------------
294: Procedure post_update
295: (p_effective_date in date
296: ,p_rec in irc_isc_shd.g_rec_type
297: ) is
298: --
299: l_proc varchar2(72) := g_package||'post_update';
300: --
496: => p_rec.object_version_number
497: ,p_date_posted
498: => p_rec.date_posted
499: ,p_object_id_o
500: => irc_isc_shd.g_old_rec.object_id
501: ,p_object_type_o
502: => irc_isc_shd.g_old_rec.object_type
503: ,p_search_name_o
504: => irc_isc_shd.g_old_rec.search_name
498: => p_rec.date_posted
499: ,p_object_id_o
500: => irc_isc_shd.g_old_rec.object_id
501: ,p_object_type_o
502: => irc_isc_shd.g_old_rec.object_type
503: ,p_search_name_o
504: => irc_isc_shd.g_old_rec.search_name
505: ,p_search_type_o
506: => irc_isc_shd.g_old_rec.search_type
500: => irc_isc_shd.g_old_rec.object_id
501: ,p_object_type_o
502: => irc_isc_shd.g_old_rec.object_type
503: ,p_search_name_o
504: => irc_isc_shd.g_old_rec.search_name
505: ,p_search_type_o
506: => irc_isc_shd.g_old_rec.search_type
507: ,p_location_o
508: => irc_isc_shd.g_old_rec.location
502: => irc_isc_shd.g_old_rec.object_type
503: ,p_search_name_o
504: => irc_isc_shd.g_old_rec.search_name
505: ,p_search_type_o
506: => irc_isc_shd.g_old_rec.search_type
507: ,p_location_o
508: => irc_isc_shd.g_old_rec.location
509: ,p_distance_to_location_o
510: => irc_isc_shd.g_old_rec.distance_to_location
504: => irc_isc_shd.g_old_rec.search_name
505: ,p_search_type_o
506: => irc_isc_shd.g_old_rec.search_type
507: ,p_location_o
508: => irc_isc_shd.g_old_rec.location
509: ,p_distance_to_location_o
510: => irc_isc_shd.g_old_rec.distance_to_location
511: ,p_geocode_location_o
512: =>irc_isc_shd.g_old_rec.geocode_location
506: => irc_isc_shd.g_old_rec.search_type
507: ,p_location_o
508: => irc_isc_shd.g_old_rec.location
509: ,p_distance_to_location_o
510: => irc_isc_shd.g_old_rec.distance_to_location
511: ,p_geocode_location_o
512: =>irc_isc_shd.g_old_rec.geocode_location
513: ,p_geocode_country_o
514: =>irc_isc_shd.g_old_rec.geocode_country
508: => irc_isc_shd.g_old_rec.location
509: ,p_distance_to_location_o
510: => irc_isc_shd.g_old_rec.distance_to_location
511: ,p_geocode_location_o
512: =>irc_isc_shd.g_old_rec.geocode_location
513: ,p_geocode_country_o
514: =>irc_isc_shd.g_old_rec.geocode_country
515: ,p_derived_location_o
516: =>irc_isc_shd.g_old_rec.derived_location
510: => irc_isc_shd.g_old_rec.distance_to_location
511: ,p_geocode_location_o
512: =>irc_isc_shd.g_old_rec.geocode_location
513: ,p_geocode_country_o
514: =>irc_isc_shd.g_old_rec.geocode_country
515: ,p_derived_location_o
516: =>irc_isc_shd.g_old_rec.derived_location
517: ,p_location_id_o
518: =>irc_isc_shd.g_old_rec.location_id
512: =>irc_isc_shd.g_old_rec.geocode_location
513: ,p_geocode_country_o
514: =>irc_isc_shd.g_old_rec.geocode_country
515: ,p_derived_location_o
516: =>irc_isc_shd.g_old_rec.derived_location
517: ,p_location_id_o
518: =>irc_isc_shd.g_old_rec.location_id
519: ,p_longitude_o
520: =>irc_isc_shd.g_old_rec.longitude
514: =>irc_isc_shd.g_old_rec.geocode_country
515: ,p_derived_location_o
516: =>irc_isc_shd.g_old_rec.derived_location
517: ,p_location_id_o
518: =>irc_isc_shd.g_old_rec.location_id
519: ,p_longitude_o
520: =>irc_isc_shd.g_old_rec.longitude
521: ,p_latitude_o
522: =>irc_isc_shd.g_old_rec.latitude
516: =>irc_isc_shd.g_old_rec.derived_location
517: ,p_location_id_o
518: =>irc_isc_shd.g_old_rec.location_id
519: ,p_longitude_o
520: =>irc_isc_shd.g_old_rec.longitude
521: ,p_latitude_o
522: =>irc_isc_shd.g_old_rec.latitude
523: ,p_employee_o
524: => irc_isc_shd.g_old_rec.employee
518: =>irc_isc_shd.g_old_rec.location_id
519: ,p_longitude_o
520: =>irc_isc_shd.g_old_rec.longitude
521: ,p_latitude_o
522: =>irc_isc_shd.g_old_rec.latitude
523: ,p_employee_o
524: => irc_isc_shd.g_old_rec.employee
525: ,p_contractor_o
526: => irc_isc_shd.g_old_rec.contractor
520: =>irc_isc_shd.g_old_rec.longitude
521: ,p_latitude_o
522: =>irc_isc_shd.g_old_rec.latitude
523: ,p_employee_o
524: => irc_isc_shd.g_old_rec.employee
525: ,p_contractor_o
526: => irc_isc_shd.g_old_rec.contractor
527: ,p_employment_category_o
528: => irc_isc_shd.g_old_rec.employment_category
522: =>irc_isc_shd.g_old_rec.latitude
523: ,p_employee_o
524: => irc_isc_shd.g_old_rec.employee
525: ,p_contractor_o
526: => irc_isc_shd.g_old_rec.contractor
527: ,p_employment_category_o
528: => irc_isc_shd.g_old_rec.employment_category
529: ,p_keywords_o
530: => irc_isc_shd.g_old_rec.keywords
524: => irc_isc_shd.g_old_rec.employee
525: ,p_contractor_o
526: => irc_isc_shd.g_old_rec.contractor
527: ,p_employment_category_o
528: => irc_isc_shd.g_old_rec.employment_category
529: ,p_keywords_o
530: => irc_isc_shd.g_old_rec.keywords
531: ,p_travel_percentage_o
532: => irc_isc_shd.g_old_rec.travel_percentage
526: => irc_isc_shd.g_old_rec.contractor
527: ,p_employment_category_o
528: => irc_isc_shd.g_old_rec.employment_category
529: ,p_keywords_o
530: => irc_isc_shd.g_old_rec.keywords
531: ,p_travel_percentage_o
532: => irc_isc_shd.g_old_rec.travel_percentage
533: ,p_min_salary_o
534: => irc_isc_shd.g_old_rec.min_salary
528: => irc_isc_shd.g_old_rec.employment_category
529: ,p_keywords_o
530: => irc_isc_shd.g_old_rec.keywords
531: ,p_travel_percentage_o
532: => irc_isc_shd.g_old_rec.travel_percentage
533: ,p_min_salary_o
534: => irc_isc_shd.g_old_rec.min_salary
535: ,p_max_salary_o
536: => irc_isc_shd.g_old_rec.max_salary
530: => irc_isc_shd.g_old_rec.keywords
531: ,p_travel_percentage_o
532: => irc_isc_shd.g_old_rec.travel_percentage
533: ,p_min_salary_o
534: => irc_isc_shd.g_old_rec.min_salary
535: ,p_max_salary_o
536: => irc_isc_shd.g_old_rec.max_salary
537: ,p_salary_currency_o
538: => irc_isc_shd.g_old_rec.salary_currency
532: => irc_isc_shd.g_old_rec.travel_percentage
533: ,p_min_salary_o
534: => irc_isc_shd.g_old_rec.min_salary
535: ,p_max_salary_o
536: => irc_isc_shd.g_old_rec.max_salary
537: ,p_salary_currency_o
538: => irc_isc_shd.g_old_rec.salary_currency
539: ,p_salary_period_o
540: => irc_isc_shd.g_old_rec.salary_period
534: => irc_isc_shd.g_old_rec.min_salary
535: ,p_max_salary_o
536: => irc_isc_shd.g_old_rec.max_salary
537: ,p_salary_currency_o
538: => irc_isc_shd.g_old_rec.salary_currency
539: ,p_salary_period_o
540: => irc_isc_shd.g_old_rec.salary_period
541: ,p_match_competence_o
542: => irc_isc_shd.g_old_rec.match_competence
536: => irc_isc_shd.g_old_rec.max_salary
537: ,p_salary_currency_o
538: => irc_isc_shd.g_old_rec.salary_currency
539: ,p_salary_period_o
540: => irc_isc_shd.g_old_rec.salary_period
541: ,p_match_competence_o
542: => irc_isc_shd.g_old_rec.match_competence
543: ,p_match_qualification_o
544: => irc_isc_shd.g_old_rec.match_qualification
538: => irc_isc_shd.g_old_rec.salary_currency
539: ,p_salary_period_o
540: => irc_isc_shd.g_old_rec.salary_period
541: ,p_match_competence_o
542: => irc_isc_shd.g_old_rec.match_competence
543: ,p_match_qualification_o
544: => irc_isc_shd.g_old_rec.match_qualification
545: ,p_job_title_o
546: => irc_isc_shd.g_old_rec.job_title
540: => irc_isc_shd.g_old_rec.salary_period
541: ,p_match_competence_o
542: => irc_isc_shd.g_old_rec.match_competence
543: ,p_match_qualification_o
544: => irc_isc_shd.g_old_rec.match_qualification
545: ,p_job_title_o
546: => irc_isc_shd.g_old_rec.job_title
547: ,p_department_o
548: => irc_isc_shd.g_old_rec.department
542: => irc_isc_shd.g_old_rec.match_competence
543: ,p_match_qualification_o
544: => irc_isc_shd.g_old_rec.match_qualification
545: ,p_job_title_o
546: => irc_isc_shd.g_old_rec.job_title
547: ,p_department_o
548: => irc_isc_shd.g_old_rec.department
549: ,p_professional_area_o
550: => irc_isc_shd.g_old_rec.professional_area
544: => irc_isc_shd.g_old_rec.match_qualification
545: ,p_job_title_o
546: => irc_isc_shd.g_old_rec.job_title
547: ,p_department_o
548: => irc_isc_shd.g_old_rec.department
549: ,p_professional_area_o
550: => irc_isc_shd.g_old_rec.professional_area
551: ,p_work_at_home_o
552: => irc_isc_shd.g_old_rec.work_at_home
546: => irc_isc_shd.g_old_rec.job_title
547: ,p_department_o
548: => irc_isc_shd.g_old_rec.department
549: ,p_professional_area_o
550: => irc_isc_shd.g_old_rec.professional_area
551: ,p_work_at_home_o
552: => irc_isc_shd.g_old_rec.work_at_home
553: ,p_min_qual_level_o
554: => irc_isc_shd.g_old_rec.min_qual_level
548: => irc_isc_shd.g_old_rec.department
549: ,p_professional_area_o
550: => irc_isc_shd.g_old_rec.professional_area
551: ,p_work_at_home_o
552: => irc_isc_shd.g_old_rec.work_at_home
553: ,p_min_qual_level_o
554: => irc_isc_shd.g_old_rec.min_qual_level
555: ,p_max_qual_level_o
556: => irc_isc_shd.g_old_rec.max_qual_level
550: => irc_isc_shd.g_old_rec.professional_area
551: ,p_work_at_home_o
552: => irc_isc_shd.g_old_rec.work_at_home
553: ,p_min_qual_level_o
554: => irc_isc_shd.g_old_rec.min_qual_level
555: ,p_max_qual_level_o
556: => irc_isc_shd.g_old_rec.max_qual_level
557: ,p_use_for_matching_o
558: => irc_isc_shd.g_old_rec.use_for_matching
552: => irc_isc_shd.g_old_rec.work_at_home
553: ,p_min_qual_level_o
554: => irc_isc_shd.g_old_rec.min_qual_level
555: ,p_max_qual_level_o
556: => irc_isc_shd.g_old_rec.max_qual_level
557: ,p_use_for_matching_o
558: => irc_isc_shd.g_old_rec.use_for_matching
559: ,p_description_o
560: => irc_isc_shd.g_old_rec.description
554: => irc_isc_shd.g_old_rec.min_qual_level
555: ,p_max_qual_level_o
556: => irc_isc_shd.g_old_rec.max_qual_level
557: ,p_use_for_matching_o
558: => irc_isc_shd.g_old_rec.use_for_matching
559: ,p_description_o
560: => irc_isc_shd.g_old_rec.description
561: ,p_attribute_category_o
562: => irc_isc_shd.g_old_rec.attribute_category
556: => irc_isc_shd.g_old_rec.max_qual_level
557: ,p_use_for_matching_o
558: => irc_isc_shd.g_old_rec.use_for_matching
559: ,p_description_o
560: => irc_isc_shd.g_old_rec.description
561: ,p_attribute_category_o
562: => irc_isc_shd.g_old_rec.attribute_category
563: ,p_attribute1_o
564: => irc_isc_shd.g_old_rec.attribute1
558: => irc_isc_shd.g_old_rec.use_for_matching
559: ,p_description_o
560: => irc_isc_shd.g_old_rec.description
561: ,p_attribute_category_o
562: => irc_isc_shd.g_old_rec.attribute_category
563: ,p_attribute1_o
564: => irc_isc_shd.g_old_rec.attribute1
565: ,p_attribute2_o
566: => irc_isc_shd.g_old_rec.attribute2
560: => irc_isc_shd.g_old_rec.description
561: ,p_attribute_category_o
562: => irc_isc_shd.g_old_rec.attribute_category
563: ,p_attribute1_o
564: => irc_isc_shd.g_old_rec.attribute1
565: ,p_attribute2_o
566: => irc_isc_shd.g_old_rec.attribute2
567: ,p_attribute3_o
568: => irc_isc_shd.g_old_rec.attribute3
562: => irc_isc_shd.g_old_rec.attribute_category
563: ,p_attribute1_o
564: => irc_isc_shd.g_old_rec.attribute1
565: ,p_attribute2_o
566: => irc_isc_shd.g_old_rec.attribute2
567: ,p_attribute3_o
568: => irc_isc_shd.g_old_rec.attribute3
569: ,p_attribute4_o
570: => irc_isc_shd.g_old_rec.attribute4
564: => irc_isc_shd.g_old_rec.attribute1
565: ,p_attribute2_o
566: => irc_isc_shd.g_old_rec.attribute2
567: ,p_attribute3_o
568: => irc_isc_shd.g_old_rec.attribute3
569: ,p_attribute4_o
570: => irc_isc_shd.g_old_rec.attribute4
571: ,p_attribute5_o
572: => irc_isc_shd.g_old_rec.attribute5
566: => irc_isc_shd.g_old_rec.attribute2
567: ,p_attribute3_o
568: => irc_isc_shd.g_old_rec.attribute3
569: ,p_attribute4_o
570: => irc_isc_shd.g_old_rec.attribute4
571: ,p_attribute5_o
572: => irc_isc_shd.g_old_rec.attribute5
573: ,p_attribute6_o
574: => irc_isc_shd.g_old_rec.attribute6
568: => irc_isc_shd.g_old_rec.attribute3
569: ,p_attribute4_o
570: => irc_isc_shd.g_old_rec.attribute4
571: ,p_attribute5_o
572: => irc_isc_shd.g_old_rec.attribute5
573: ,p_attribute6_o
574: => irc_isc_shd.g_old_rec.attribute6
575: ,p_attribute7_o
576: => irc_isc_shd.g_old_rec.attribute7
570: => irc_isc_shd.g_old_rec.attribute4
571: ,p_attribute5_o
572: => irc_isc_shd.g_old_rec.attribute5
573: ,p_attribute6_o
574: => irc_isc_shd.g_old_rec.attribute6
575: ,p_attribute7_o
576: => irc_isc_shd.g_old_rec.attribute7
577: ,p_attribute8_o
578: => irc_isc_shd.g_old_rec.attribute8
572: => irc_isc_shd.g_old_rec.attribute5
573: ,p_attribute6_o
574: => irc_isc_shd.g_old_rec.attribute6
575: ,p_attribute7_o
576: => irc_isc_shd.g_old_rec.attribute7
577: ,p_attribute8_o
578: => irc_isc_shd.g_old_rec.attribute8
579: ,p_attribute9_o
580: => irc_isc_shd.g_old_rec.attribute9
574: => irc_isc_shd.g_old_rec.attribute6
575: ,p_attribute7_o
576: => irc_isc_shd.g_old_rec.attribute7
577: ,p_attribute8_o
578: => irc_isc_shd.g_old_rec.attribute8
579: ,p_attribute9_o
580: => irc_isc_shd.g_old_rec.attribute9
581: ,p_attribute10_o
582: => irc_isc_shd.g_old_rec.attribute10
576: => irc_isc_shd.g_old_rec.attribute7
577: ,p_attribute8_o
578: => irc_isc_shd.g_old_rec.attribute8
579: ,p_attribute9_o
580: => irc_isc_shd.g_old_rec.attribute9
581: ,p_attribute10_o
582: => irc_isc_shd.g_old_rec.attribute10
583: ,p_attribute11_o
584: => irc_isc_shd.g_old_rec.attribute11
578: => irc_isc_shd.g_old_rec.attribute8
579: ,p_attribute9_o
580: => irc_isc_shd.g_old_rec.attribute9
581: ,p_attribute10_o
582: => irc_isc_shd.g_old_rec.attribute10
583: ,p_attribute11_o
584: => irc_isc_shd.g_old_rec.attribute11
585: ,p_attribute12_o
586: => irc_isc_shd.g_old_rec.attribute12
580: => irc_isc_shd.g_old_rec.attribute9
581: ,p_attribute10_o
582: => irc_isc_shd.g_old_rec.attribute10
583: ,p_attribute11_o
584: => irc_isc_shd.g_old_rec.attribute11
585: ,p_attribute12_o
586: => irc_isc_shd.g_old_rec.attribute12
587: ,p_attribute13_o
588: => irc_isc_shd.g_old_rec.attribute13
582: => irc_isc_shd.g_old_rec.attribute10
583: ,p_attribute11_o
584: => irc_isc_shd.g_old_rec.attribute11
585: ,p_attribute12_o
586: => irc_isc_shd.g_old_rec.attribute12
587: ,p_attribute13_o
588: => irc_isc_shd.g_old_rec.attribute13
589: ,p_attribute14_o
590: => irc_isc_shd.g_old_rec.attribute14
584: => irc_isc_shd.g_old_rec.attribute11
585: ,p_attribute12_o
586: => irc_isc_shd.g_old_rec.attribute12
587: ,p_attribute13_o
588: => irc_isc_shd.g_old_rec.attribute13
589: ,p_attribute14_o
590: => irc_isc_shd.g_old_rec.attribute14
591: ,p_attribute15_o
592: => irc_isc_shd.g_old_rec.attribute15
586: => irc_isc_shd.g_old_rec.attribute12
587: ,p_attribute13_o
588: => irc_isc_shd.g_old_rec.attribute13
589: ,p_attribute14_o
590: => irc_isc_shd.g_old_rec.attribute14
591: ,p_attribute15_o
592: => irc_isc_shd.g_old_rec.attribute15
593: ,p_attribute16_o
594: => irc_isc_shd.g_old_rec.attribute16
588: => irc_isc_shd.g_old_rec.attribute13
589: ,p_attribute14_o
590: => irc_isc_shd.g_old_rec.attribute14
591: ,p_attribute15_o
592: => irc_isc_shd.g_old_rec.attribute15
593: ,p_attribute16_o
594: => irc_isc_shd.g_old_rec.attribute16
595: ,p_attribute17_o
596: => irc_isc_shd.g_old_rec.attribute17
590: => irc_isc_shd.g_old_rec.attribute14
591: ,p_attribute15_o
592: => irc_isc_shd.g_old_rec.attribute15
593: ,p_attribute16_o
594: => irc_isc_shd.g_old_rec.attribute16
595: ,p_attribute17_o
596: => irc_isc_shd.g_old_rec.attribute17
597: ,p_attribute18_o
598: => irc_isc_shd.g_old_rec.attribute18
592: => irc_isc_shd.g_old_rec.attribute15
593: ,p_attribute16_o
594: => irc_isc_shd.g_old_rec.attribute16
595: ,p_attribute17_o
596: => irc_isc_shd.g_old_rec.attribute17
597: ,p_attribute18_o
598: => irc_isc_shd.g_old_rec.attribute18
599: ,p_attribute19_o
600: => irc_isc_shd.g_old_rec.attribute19
594: => irc_isc_shd.g_old_rec.attribute16
595: ,p_attribute17_o
596: => irc_isc_shd.g_old_rec.attribute17
597: ,p_attribute18_o
598: => irc_isc_shd.g_old_rec.attribute18
599: ,p_attribute19_o
600: => irc_isc_shd.g_old_rec.attribute19
601: ,p_attribute20_o
602: => irc_isc_shd.g_old_rec.attribute20
596: => irc_isc_shd.g_old_rec.attribute17
597: ,p_attribute18_o
598: => irc_isc_shd.g_old_rec.attribute18
599: ,p_attribute19_o
600: => irc_isc_shd.g_old_rec.attribute19
601: ,p_attribute20_o
602: => irc_isc_shd.g_old_rec.attribute20
603: ,p_attribute21_o
604: => irc_isc_shd.g_old_rec.attribute21
598: => irc_isc_shd.g_old_rec.attribute18
599: ,p_attribute19_o
600: => irc_isc_shd.g_old_rec.attribute19
601: ,p_attribute20_o
602: => irc_isc_shd.g_old_rec.attribute20
603: ,p_attribute21_o
604: => irc_isc_shd.g_old_rec.attribute21
605: ,p_attribute22_o
606: => irc_isc_shd.g_old_rec.attribute22
600: => irc_isc_shd.g_old_rec.attribute19
601: ,p_attribute20_o
602: => irc_isc_shd.g_old_rec.attribute20
603: ,p_attribute21_o
604: => irc_isc_shd.g_old_rec.attribute21
605: ,p_attribute22_o
606: => irc_isc_shd.g_old_rec.attribute22
607: ,p_attribute23_o
608: => irc_isc_shd.g_old_rec.attribute23
602: => irc_isc_shd.g_old_rec.attribute20
603: ,p_attribute21_o
604: => irc_isc_shd.g_old_rec.attribute21
605: ,p_attribute22_o
606: => irc_isc_shd.g_old_rec.attribute22
607: ,p_attribute23_o
608: => irc_isc_shd.g_old_rec.attribute23
609: ,p_attribute24_o
610: => irc_isc_shd.g_old_rec.attribute24
604: => irc_isc_shd.g_old_rec.attribute21
605: ,p_attribute22_o
606: => irc_isc_shd.g_old_rec.attribute22
607: ,p_attribute23_o
608: => irc_isc_shd.g_old_rec.attribute23
609: ,p_attribute24_o
610: => irc_isc_shd.g_old_rec.attribute24
611: ,p_attribute25_o
612: => irc_isc_shd.g_old_rec.attribute25
606: => irc_isc_shd.g_old_rec.attribute22
607: ,p_attribute23_o
608: => irc_isc_shd.g_old_rec.attribute23
609: ,p_attribute24_o
610: => irc_isc_shd.g_old_rec.attribute24
611: ,p_attribute25_o
612: => irc_isc_shd.g_old_rec.attribute25
613: ,p_attribute26_o
614: => irc_isc_shd.g_old_rec.attribute26
608: => irc_isc_shd.g_old_rec.attribute23
609: ,p_attribute24_o
610: => irc_isc_shd.g_old_rec.attribute24
611: ,p_attribute25_o
612: => irc_isc_shd.g_old_rec.attribute25
613: ,p_attribute26_o
614: => irc_isc_shd.g_old_rec.attribute26
615: ,p_attribute27_o
616: => irc_isc_shd.g_old_rec.attribute27
610: => irc_isc_shd.g_old_rec.attribute24
611: ,p_attribute25_o
612: => irc_isc_shd.g_old_rec.attribute25
613: ,p_attribute26_o
614: => irc_isc_shd.g_old_rec.attribute26
615: ,p_attribute27_o
616: => irc_isc_shd.g_old_rec.attribute27
617: ,p_attribute28_o
618: => irc_isc_shd.g_old_rec.attribute28
612: => irc_isc_shd.g_old_rec.attribute25
613: ,p_attribute26_o
614: => irc_isc_shd.g_old_rec.attribute26
615: ,p_attribute27_o
616: => irc_isc_shd.g_old_rec.attribute27
617: ,p_attribute28_o
618: => irc_isc_shd.g_old_rec.attribute28
619: ,p_attribute29_o
620: => irc_isc_shd.g_old_rec.attribute29
614: => irc_isc_shd.g_old_rec.attribute26
615: ,p_attribute27_o
616: => irc_isc_shd.g_old_rec.attribute27
617: ,p_attribute28_o
618: => irc_isc_shd.g_old_rec.attribute28
619: ,p_attribute29_o
620: => irc_isc_shd.g_old_rec.attribute29
621: ,p_attribute30_o
622: => irc_isc_shd.g_old_rec.attribute30
616: => irc_isc_shd.g_old_rec.attribute27
617: ,p_attribute28_o
618: => irc_isc_shd.g_old_rec.attribute28
619: ,p_attribute29_o
620: => irc_isc_shd.g_old_rec.attribute29
621: ,p_attribute30_o
622: => irc_isc_shd.g_old_rec.attribute30
623: ,p_isc_information_category_o
624: => irc_isc_shd.g_old_rec.isc_information_category
618: => irc_isc_shd.g_old_rec.attribute28
619: ,p_attribute29_o
620: => irc_isc_shd.g_old_rec.attribute29
621: ,p_attribute30_o
622: => irc_isc_shd.g_old_rec.attribute30
623: ,p_isc_information_category_o
624: => irc_isc_shd.g_old_rec.isc_information_category
625: ,p_isc_information1_o
626: => irc_isc_shd.g_old_rec.isc_information1
620: => irc_isc_shd.g_old_rec.attribute29
621: ,p_attribute30_o
622: => irc_isc_shd.g_old_rec.attribute30
623: ,p_isc_information_category_o
624: => irc_isc_shd.g_old_rec.isc_information_category
625: ,p_isc_information1_o
626: => irc_isc_shd.g_old_rec.isc_information1
627: ,p_isc_information2_o
628: => irc_isc_shd.g_old_rec.isc_information2
622: => irc_isc_shd.g_old_rec.attribute30
623: ,p_isc_information_category_o
624: => irc_isc_shd.g_old_rec.isc_information_category
625: ,p_isc_information1_o
626: => irc_isc_shd.g_old_rec.isc_information1
627: ,p_isc_information2_o
628: => irc_isc_shd.g_old_rec.isc_information2
629: ,p_isc_information3_o
630: => irc_isc_shd.g_old_rec.isc_information3
624: => irc_isc_shd.g_old_rec.isc_information_category
625: ,p_isc_information1_o
626: => irc_isc_shd.g_old_rec.isc_information1
627: ,p_isc_information2_o
628: => irc_isc_shd.g_old_rec.isc_information2
629: ,p_isc_information3_o
630: => irc_isc_shd.g_old_rec.isc_information3
631: ,p_isc_information4_o
632: => irc_isc_shd.g_old_rec.isc_information4
626: => irc_isc_shd.g_old_rec.isc_information1
627: ,p_isc_information2_o
628: => irc_isc_shd.g_old_rec.isc_information2
629: ,p_isc_information3_o
630: => irc_isc_shd.g_old_rec.isc_information3
631: ,p_isc_information4_o
632: => irc_isc_shd.g_old_rec.isc_information4
633: ,p_isc_information5_o
634: => irc_isc_shd.g_old_rec.isc_information5
628: => irc_isc_shd.g_old_rec.isc_information2
629: ,p_isc_information3_o
630: => irc_isc_shd.g_old_rec.isc_information3
631: ,p_isc_information4_o
632: => irc_isc_shd.g_old_rec.isc_information4
633: ,p_isc_information5_o
634: => irc_isc_shd.g_old_rec.isc_information5
635: ,p_isc_information6_o
636: => irc_isc_shd.g_old_rec.isc_information6
630: => irc_isc_shd.g_old_rec.isc_information3
631: ,p_isc_information4_o
632: => irc_isc_shd.g_old_rec.isc_information4
633: ,p_isc_information5_o
634: => irc_isc_shd.g_old_rec.isc_information5
635: ,p_isc_information6_o
636: => irc_isc_shd.g_old_rec.isc_information6
637: ,p_isc_information7_o
638: => irc_isc_shd.g_old_rec.isc_information7
632: => irc_isc_shd.g_old_rec.isc_information4
633: ,p_isc_information5_o
634: => irc_isc_shd.g_old_rec.isc_information5
635: ,p_isc_information6_o
636: => irc_isc_shd.g_old_rec.isc_information6
637: ,p_isc_information7_o
638: => irc_isc_shd.g_old_rec.isc_information7
639: ,p_isc_information8_o
640: => irc_isc_shd.g_old_rec.isc_information8
634: => irc_isc_shd.g_old_rec.isc_information5
635: ,p_isc_information6_o
636: => irc_isc_shd.g_old_rec.isc_information6
637: ,p_isc_information7_o
638: => irc_isc_shd.g_old_rec.isc_information7
639: ,p_isc_information8_o
640: => irc_isc_shd.g_old_rec.isc_information8
641: ,p_isc_information9_o
642: => irc_isc_shd.g_old_rec.isc_information9
636: => irc_isc_shd.g_old_rec.isc_information6
637: ,p_isc_information7_o
638: => irc_isc_shd.g_old_rec.isc_information7
639: ,p_isc_information8_o
640: => irc_isc_shd.g_old_rec.isc_information8
641: ,p_isc_information9_o
642: => irc_isc_shd.g_old_rec.isc_information9
643: ,p_isc_information10_o
644: => irc_isc_shd.g_old_rec.isc_information10
638: => irc_isc_shd.g_old_rec.isc_information7
639: ,p_isc_information8_o
640: => irc_isc_shd.g_old_rec.isc_information8
641: ,p_isc_information9_o
642: => irc_isc_shd.g_old_rec.isc_information9
643: ,p_isc_information10_o
644: => irc_isc_shd.g_old_rec.isc_information10
645: ,p_isc_information11_o
646: => irc_isc_shd.g_old_rec.isc_information11
640: => irc_isc_shd.g_old_rec.isc_information8
641: ,p_isc_information9_o
642: => irc_isc_shd.g_old_rec.isc_information9
643: ,p_isc_information10_o
644: => irc_isc_shd.g_old_rec.isc_information10
645: ,p_isc_information11_o
646: => irc_isc_shd.g_old_rec.isc_information11
647: ,p_isc_information12_o
648: => irc_isc_shd.g_old_rec.isc_information12
642: => irc_isc_shd.g_old_rec.isc_information9
643: ,p_isc_information10_o
644: => irc_isc_shd.g_old_rec.isc_information10
645: ,p_isc_information11_o
646: => irc_isc_shd.g_old_rec.isc_information11
647: ,p_isc_information12_o
648: => irc_isc_shd.g_old_rec.isc_information12
649: ,p_isc_information13_o
650: => irc_isc_shd.g_old_rec.isc_information13
644: => irc_isc_shd.g_old_rec.isc_information10
645: ,p_isc_information11_o
646: => irc_isc_shd.g_old_rec.isc_information11
647: ,p_isc_information12_o
648: => irc_isc_shd.g_old_rec.isc_information12
649: ,p_isc_information13_o
650: => irc_isc_shd.g_old_rec.isc_information13
651: ,p_isc_information14_o
652: => irc_isc_shd.g_old_rec.isc_information14
646: => irc_isc_shd.g_old_rec.isc_information11
647: ,p_isc_information12_o
648: => irc_isc_shd.g_old_rec.isc_information12
649: ,p_isc_information13_o
650: => irc_isc_shd.g_old_rec.isc_information13
651: ,p_isc_information14_o
652: => irc_isc_shd.g_old_rec.isc_information14
653: ,p_isc_information15_o
654: => irc_isc_shd.g_old_rec.isc_information15
648: => irc_isc_shd.g_old_rec.isc_information12
649: ,p_isc_information13_o
650: => irc_isc_shd.g_old_rec.isc_information13
651: ,p_isc_information14_o
652: => irc_isc_shd.g_old_rec.isc_information14
653: ,p_isc_information15_o
654: => irc_isc_shd.g_old_rec.isc_information15
655: ,p_isc_information16_o
656: => irc_isc_shd.g_old_rec.isc_information16
650: => irc_isc_shd.g_old_rec.isc_information13
651: ,p_isc_information14_o
652: => irc_isc_shd.g_old_rec.isc_information14
653: ,p_isc_information15_o
654: => irc_isc_shd.g_old_rec.isc_information15
655: ,p_isc_information16_o
656: => irc_isc_shd.g_old_rec.isc_information16
657: ,p_isc_information17_o
658: => irc_isc_shd.g_old_rec.isc_information17
652: => irc_isc_shd.g_old_rec.isc_information14
653: ,p_isc_information15_o
654: => irc_isc_shd.g_old_rec.isc_information15
655: ,p_isc_information16_o
656: => irc_isc_shd.g_old_rec.isc_information16
657: ,p_isc_information17_o
658: => irc_isc_shd.g_old_rec.isc_information17
659: ,p_isc_information18_o
660: => irc_isc_shd.g_old_rec.isc_information18
654: => irc_isc_shd.g_old_rec.isc_information15
655: ,p_isc_information16_o
656: => irc_isc_shd.g_old_rec.isc_information16
657: ,p_isc_information17_o
658: => irc_isc_shd.g_old_rec.isc_information17
659: ,p_isc_information18_o
660: => irc_isc_shd.g_old_rec.isc_information18
661: ,p_isc_information19_o
662: => irc_isc_shd.g_old_rec.isc_information19
656: => irc_isc_shd.g_old_rec.isc_information16
657: ,p_isc_information17_o
658: => irc_isc_shd.g_old_rec.isc_information17
659: ,p_isc_information18_o
660: => irc_isc_shd.g_old_rec.isc_information18
661: ,p_isc_information19_o
662: => irc_isc_shd.g_old_rec.isc_information19
663: ,p_isc_information20_o
664: => irc_isc_shd.g_old_rec.isc_information20
658: => irc_isc_shd.g_old_rec.isc_information17
659: ,p_isc_information18_o
660: => irc_isc_shd.g_old_rec.isc_information18
661: ,p_isc_information19_o
662: => irc_isc_shd.g_old_rec.isc_information19
663: ,p_isc_information20_o
664: => irc_isc_shd.g_old_rec.isc_information20
665: ,p_isc_information21_o
666: => irc_isc_shd.g_old_rec.isc_information21
660: => irc_isc_shd.g_old_rec.isc_information18
661: ,p_isc_information19_o
662: => irc_isc_shd.g_old_rec.isc_information19
663: ,p_isc_information20_o
664: => irc_isc_shd.g_old_rec.isc_information20
665: ,p_isc_information21_o
666: => irc_isc_shd.g_old_rec.isc_information21
667: ,p_isc_information22_o
668: => irc_isc_shd.g_old_rec.isc_information22
662: => irc_isc_shd.g_old_rec.isc_information19
663: ,p_isc_information20_o
664: => irc_isc_shd.g_old_rec.isc_information20
665: ,p_isc_information21_o
666: => irc_isc_shd.g_old_rec.isc_information21
667: ,p_isc_information22_o
668: => irc_isc_shd.g_old_rec.isc_information22
669: ,p_isc_information23_o
670: => irc_isc_shd.g_old_rec.isc_information23
664: => irc_isc_shd.g_old_rec.isc_information20
665: ,p_isc_information21_o
666: => irc_isc_shd.g_old_rec.isc_information21
667: ,p_isc_information22_o
668: => irc_isc_shd.g_old_rec.isc_information22
669: ,p_isc_information23_o
670: => irc_isc_shd.g_old_rec.isc_information23
671: ,p_isc_information24_o
672: => irc_isc_shd.g_old_rec.isc_information24
666: => irc_isc_shd.g_old_rec.isc_information21
667: ,p_isc_information22_o
668: => irc_isc_shd.g_old_rec.isc_information22
669: ,p_isc_information23_o
670: => irc_isc_shd.g_old_rec.isc_information23
671: ,p_isc_information24_o
672: => irc_isc_shd.g_old_rec.isc_information24
673: ,p_isc_information25_o
674: => irc_isc_shd.g_old_rec.isc_information25
668: => irc_isc_shd.g_old_rec.isc_information22
669: ,p_isc_information23_o
670: => irc_isc_shd.g_old_rec.isc_information23
671: ,p_isc_information24_o
672: => irc_isc_shd.g_old_rec.isc_information24
673: ,p_isc_information25_o
674: => irc_isc_shd.g_old_rec.isc_information25
675: ,p_isc_information26_o
676: => irc_isc_shd.g_old_rec.isc_information26
670: => irc_isc_shd.g_old_rec.isc_information23
671: ,p_isc_information24_o
672: => irc_isc_shd.g_old_rec.isc_information24
673: ,p_isc_information25_o
674: => irc_isc_shd.g_old_rec.isc_information25
675: ,p_isc_information26_o
676: => irc_isc_shd.g_old_rec.isc_information26
677: ,p_isc_information27_o
678: => irc_isc_shd.g_old_rec.isc_information27
672: => irc_isc_shd.g_old_rec.isc_information24
673: ,p_isc_information25_o
674: => irc_isc_shd.g_old_rec.isc_information25
675: ,p_isc_information26_o
676: => irc_isc_shd.g_old_rec.isc_information26
677: ,p_isc_information27_o
678: => irc_isc_shd.g_old_rec.isc_information27
679: ,p_isc_information28_o
680: => irc_isc_shd.g_old_rec.isc_information28
674: => irc_isc_shd.g_old_rec.isc_information25
675: ,p_isc_information26_o
676: => irc_isc_shd.g_old_rec.isc_information26
677: ,p_isc_information27_o
678: => irc_isc_shd.g_old_rec.isc_information27
679: ,p_isc_information28_o
680: => irc_isc_shd.g_old_rec.isc_information28
681: ,p_isc_information29_o
682: => irc_isc_shd.g_old_rec.isc_information29
676: => irc_isc_shd.g_old_rec.isc_information26
677: ,p_isc_information27_o
678: => irc_isc_shd.g_old_rec.isc_information27
679: ,p_isc_information28_o
680: => irc_isc_shd.g_old_rec.isc_information28
681: ,p_isc_information29_o
682: => irc_isc_shd.g_old_rec.isc_information29
683: ,p_isc_information30_o
684: => irc_isc_shd.g_old_rec.isc_information30
678: => irc_isc_shd.g_old_rec.isc_information27
679: ,p_isc_information28_o
680: => irc_isc_shd.g_old_rec.isc_information28
681: ,p_isc_information29_o
682: => irc_isc_shd.g_old_rec.isc_information29
683: ,p_isc_information30_o
684: => irc_isc_shd.g_old_rec.isc_information30
685: ,p_object_version_number_o
686: => irc_isc_shd.g_old_rec.object_version_number
680: => irc_isc_shd.g_old_rec.isc_information28
681: ,p_isc_information29_o
682: => irc_isc_shd.g_old_rec.isc_information29
683: ,p_isc_information30_o
684: => irc_isc_shd.g_old_rec.isc_information30
685: ,p_object_version_number_o
686: => irc_isc_shd.g_old_rec.object_version_number
687: ,p_date_posted_o
688: => irc_isc_shd.g_old_rec.date_posted
682: => irc_isc_shd.g_old_rec.isc_information29
683: ,p_isc_information30_o
684: => irc_isc_shd.g_old_rec.isc_information30
685: ,p_object_version_number_o
686: => irc_isc_shd.g_old_rec.object_version_number
687: ,p_date_posted_o
688: => irc_isc_shd.g_old_rec.date_posted
689: );
690: --
684: => irc_isc_shd.g_old_rec.isc_information30
685: ,p_object_version_number_o
686: => irc_isc_shd.g_old_rec.object_version_number
687: ,p_date_posted_o
688: => irc_isc_shd.g_old_rec.date_posted
689: );
690: --
691: exception
692: --
744: --
745: -- {End Of Comments}
746: -- ----------------------------------------------------------------------------
747: Procedure convert_defs
748: (p_rec in out nocopy irc_isc_shd.g_rec_type
749: ) is
750: --
751: Begin
752: --
756: -- is being used then we must set to the 'current' argument value.
757: --
758: If (p_rec.object_id = hr_api.g_number) then
759: p_rec.object_id :=
760: irc_isc_shd.g_old_rec.object_id;
761: End If;
762: If (p_rec.object_type = hr_api.g_varchar2) then
763: p_rec.object_type :=
764: irc_isc_shd.g_old_rec.object_type;
760: irc_isc_shd.g_old_rec.object_id;
761: End If;
762: If (p_rec.object_type = hr_api.g_varchar2) then
763: p_rec.object_type :=
764: irc_isc_shd.g_old_rec.object_type;
765: End If;
766: If (p_rec.search_name = hr_api.g_varchar2) then
767: p_rec.search_name :=
768: irc_isc_shd.g_old_rec.search_name;
764: irc_isc_shd.g_old_rec.object_type;
765: End If;
766: If (p_rec.search_name = hr_api.g_varchar2) then
767: p_rec.search_name :=
768: irc_isc_shd.g_old_rec.search_name;
769: End If;
770: If (p_rec.search_type = hr_api.g_varchar2) then
771: p_rec.search_type :=
772: irc_isc_shd.g_old_rec.search_type;
768: irc_isc_shd.g_old_rec.search_name;
769: End If;
770: If (p_rec.search_type = hr_api.g_varchar2) then
771: p_rec.search_type :=
772: irc_isc_shd.g_old_rec.search_type;
773: End If;
774: If (p_rec.location = hr_api.g_varchar2) then
775: p_rec.location :=
776: irc_isc_shd.g_old_rec.location;
772: irc_isc_shd.g_old_rec.search_type;
773: End If;
774: If (p_rec.location = hr_api.g_varchar2) then
775: p_rec.location :=
776: irc_isc_shd.g_old_rec.location;
777: End If;
778: If (p_rec.distance_to_location = hr_api.g_varchar2) then
779: p_rec.distance_to_location :=
780: irc_isc_shd.g_old_rec.distance_to_location;
776: irc_isc_shd.g_old_rec.location;
777: End If;
778: If (p_rec.distance_to_location = hr_api.g_varchar2) then
779: p_rec.distance_to_location :=
780: irc_isc_shd.g_old_rec.distance_to_location;
781: End If;
782: If (p_rec.geocode_location = hr_api.g_varchar2) then
783: p_rec.geocode_location :=
784: irc_isc_shd.g_old_rec.geocode_location;
780: irc_isc_shd.g_old_rec.distance_to_location;
781: End If;
782: If (p_rec.geocode_location = hr_api.g_varchar2) then
783: p_rec.geocode_location :=
784: irc_isc_shd.g_old_rec.geocode_location;
785: End If;
786: If (p_rec.geocode_country = hr_api.g_varchar2) then
787: p_rec.geocode_country :=
788: irc_isc_shd.g_old_rec.geocode_country;
784: irc_isc_shd.g_old_rec.geocode_location;
785: End If;
786: If (p_rec.geocode_country = hr_api.g_varchar2) then
787: p_rec.geocode_country :=
788: irc_isc_shd.g_old_rec.geocode_country;
789: End If;
790: If (p_rec.derived_location = hr_api.g_varchar2) then
791: p_rec.derived_location :=
792: irc_isc_shd.g_old_rec.derived_location;
788: irc_isc_shd.g_old_rec.geocode_country;
789: End If;
790: If (p_rec.derived_location = hr_api.g_varchar2) then
791: p_rec.derived_location :=
792: irc_isc_shd.g_old_rec.derived_location;
793: End If;
794: If (p_rec.location_id = hr_api.g_number) then
795: p_rec.location_id :=
796: irc_isc_shd.g_old_rec.location_id;
792: irc_isc_shd.g_old_rec.derived_location;
793: End If;
794: If (p_rec.location_id = hr_api.g_number) then
795: p_rec.location_id :=
796: irc_isc_shd.g_old_rec.location_id;
797: End If;
798: If (p_rec.longitude = hr_api.g_number) then
799: p_rec.longitude :=
800: irc_isc_shd.g_old_rec.longitude;
796: irc_isc_shd.g_old_rec.location_id;
797: End If;
798: If (p_rec.longitude = hr_api.g_number) then
799: p_rec.longitude :=
800: irc_isc_shd.g_old_rec.longitude;
801: End If;
802: If (p_rec.latitude = hr_api.g_number) then
803: p_rec.latitude :=
804: irc_isc_shd.g_old_rec.latitude;
800: irc_isc_shd.g_old_rec.longitude;
801: End If;
802: If (p_rec.latitude = hr_api.g_number) then
803: p_rec.latitude :=
804: irc_isc_shd.g_old_rec.latitude;
805: End If;
806: If (p_rec.employee = hr_api.g_varchar2) then
807: p_rec.employee :=
808: irc_isc_shd.g_old_rec.employee;
804: irc_isc_shd.g_old_rec.latitude;
805: End If;
806: If (p_rec.employee = hr_api.g_varchar2) then
807: p_rec.employee :=
808: irc_isc_shd.g_old_rec.employee;
809: End If;
810: If (p_rec.contractor = hr_api.g_varchar2) then
811: p_rec.contractor :=
812: irc_isc_shd.g_old_rec.contractor;
808: irc_isc_shd.g_old_rec.employee;
809: End If;
810: If (p_rec.contractor = hr_api.g_varchar2) then
811: p_rec.contractor :=
812: irc_isc_shd.g_old_rec.contractor;
813: End If;
814: If (p_rec.employment_category = hr_api.g_varchar2) then
815: p_rec.employment_category :=
816: irc_isc_shd.g_old_rec.employment_category;
812: irc_isc_shd.g_old_rec.contractor;
813: End If;
814: If (p_rec.employment_category = hr_api.g_varchar2) then
815: p_rec.employment_category :=
816: irc_isc_shd.g_old_rec.employment_category;
817: End If;
818: If (p_rec.keywords = hr_api.g_varchar2) then
819: p_rec.keywords :=
820: irc_isc_shd.g_old_rec.keywords;
816: irc_isc_shd.g_old_rec.employment_category;
817: End If;
818: If (p_rec.keywords = hr_api.g_varchar2) then
819: p_rec.keywords :=
820: irc_isc_shd.g_old_rec.keywords;
821: End If;
822: If (p_rec.travel_percentage = hr_api.g_number) then
823: p_rec.travel_percentage :=
824: irc_isc_shd.g_old_rec.travel_percentage;
820: irc_isc_shd.g_old_rec.keywords;
821: End If;
822: If (p_rec.travel_percentage = hr_api.g_number) then
823: p_rec.travel_percentage :=
824: irc_isc_shd.g_old_rec.travel_percentage;
825: End If;
826: If (p_rec.min_salary = hr_api.g_number) then
827: p_rec.min_salary :=
828: irc_isc_shd.g_old_rec.min_salary;
824: irc_isc_shd.g_old_rec.travel_percentage;
825: End If;
826: If (p_rec.min_salary = hr_api.g_number) then
827: p_rec.min_salary :=
828: irc_isc_shd.g_old_rec.min_salary;
829: End If;
830: If (p_rec.max_salary = hr_api.g_number) then
831: p_rec.max_salary :=
832: irc_isc_shd.g_old_rec.max_salary;
828: irc_isc_shd.g_old_rec.min_salary;
829: End If;
830: If (p_rec.max_salary = hr_api.g_number) then
831: p_rec.max_salary :=
832: irc_isc_shd.g_old_rec.max_salary;
833: End If;
834: If (p_rec.salary_currency = hr_api.g_varchar2) then
835: p_rec.salary_currency :=
836: irc_isc_shd.g_old_rec.salary_currency;
832: irc_isc_shd.g_old_rec.max_salary;
833: End If;
834: If (p_rec.salary_currency = hr_api.g_varchar2) then
835: p_rec.salary_currency :=
836: irc_isc_shd.g_old_rec.salary_currency;
837: End If;
838: If (p_rec.salary_period = hr_api.g_varchar2) then
839: p_rec.salary_period :=
840: irc_isc_shd.g_old_rec.salary_period;
836: irc_isc_shd.g_old_rec.salary_currency;
837: End If;
838: If (p_rec.salary_period = hr_api.g_varchar2) then
839: p_rec.salary_period :=
840: irc_isc_shd.g_old_rec.salary_period;
841: End If;
842: If (p_rec.match_competence = hr_api.g_varchar2) then
843: p_rec.match_competence :=
844: irc_isc_shd.g_old_rec.match_competence;
840: irc_isc_shd.g_old_rec.salary_period;
841: End If;
842: If (p_rec.match_competence = hr_api.g_varchar2) then
843: p_rec.match_competence :=
844: irc_isc_shd.g_old_rec.match_competence;
845: End If;
846: If (p_rec.match_qualification = hr_api.g_varchar2) then
847: p_rec.match_qualification :=
848: irc_isc_shd.g_old_rec.match_qualification;
844: irc_isc_shd.g_old_rec.match_competence;
845: End If;
846: If (p_rec.match_qualification = hr_api.g_varchar2) then
847: p_rec.match_qualification :=
848: irc_isc_shd.g_old_rec.match_qualification;
849: End If;
850: If (p_rec.job_title = hr_api.g_varchar2) then
851: p_rec.job_title :=
852: irc_isc_shd.g_old_rec.job_title;
848: irc_isc_shd.g_old_rec.match_qualification;
849: End If;
850: If (p_rec.job_title = hr_api.g_varchar2) then
851: p_rec.job_title :=
852: irc_isc_shd.g_old_rec.job_title;
853: End If;
854: If (p_rec.department = hr_api.g_varchar2) then
855: p_rec.department :=
856: irc_isc_shd.g_old_rec.department;
852: irc_isc_shd.g_old_rec.job_title;
853: End If;
854: If (p_rec.department = hr_api.g_varchar2) then
855: p_rec.department :=
856: irc_isc_shd.g_old_rec.department;
857: End If;
858: If (p_rec.professional_area = hr_api.g_varchar2) then
859: p_rec.professional_area :=
860: irc_isc_shd.g_old_rec.professional_area;
856: irc_isc_shd.g_old_rec.department;
857: End If;
858: If (p_rec.professional_area = hr_api.g_varchar2) then
859: p_rec.professional_area :=
860: irc_isc_shd.g_old_rec.professional_area;
861: End If;
862: If (p_rec.work_at_home = hr_api.g_varchar2) then
863: p_rec.work_at_home :=
864: irc_isc_shd.g_old_rec.work_at_home;
860: irc_isc_shd.g_old_rec.professional_area;
861: End If;
862: If (p_rec.work_at_home = hr_api.g_varchar2) then
863: p_rec.work_at_home :=
864: irc_isc_shd.g_old_rec.work_at_home;
865: End If;
866: If (p_rec.min_qual_level = hr_api.g_number) then
867: p_rec.min_qual_level :=
868: irc_isc_shd.g_old_rec.min_qual_level;
864: irc_isc_shd.g_old_rec.work_at_home;
865: End If;
866: If (p_rec.min_qual_level = hr_api.g_number) then
867: p_rec.min_qual_level :=
868: irc_isc_shd.g_old_rec.min_qual_level;
869: End If;
870: If (p_rec.max_qual_level = hr_api.g_number) then
871: p_rec.max_qual_level :=
872: irc_isc_shd.g_old_rec.max_qual_level;
868: irc_isc_shd.g_old_rec.min_qual_level;
869: End If;
870: If (p_rec.max_qual_level = hr_api.g_number) then
871: p_rec.max_qual_level :=
872: irc_isc_shd.g_old_rec.max_qual_level;
873: End If;
874: If (p_rec.use_for_matching = hr_api.g_varchar2) then
875: p_rec.use_for_matching :=
876: irc_isc_shd.g_old_rec.use_for_matching;
872: irc_isc_shd.g_old_rec.max_qual_level;
873: End If;
874: If (p_rec.use_for_matching = hr_api.g_varchar2) then
875: p_rec.use_for_matching :=
876: irc_isc_shd.g_old_rec.use_for_matching;
877: End If;
878: If (p_rec.description = hr_api.g_varchar2) then
879: p_rec.description :=
880: irc_isc_shd.g_old_rec.description;
876: irc_isc_shd.g_old_rec.use_for_matching;
877: End If;
878: If (p_rec.description = hr_api.g_varchar2) then
879: p_rec.description :=
880: irc_isc_shd.g_old_rec.description;
881: g_description:=false;
882: Else
883: g_description:=true;
884: End If;
883: g_description:=true;
884: End If;
885: If (p_rec.attribute_category = hr_api.g_varchar2) then
886: p_rec.attribute_category :=
887: irc_isc_shd.g_old_rec.attribute_category;
888: End If;
889: If (p_rec.attribute1 = hr_api.g_varchar2) then
890: p_rec.attribute1 :=
891: irc_isc_shd.g_old_rec.attribute1;
887: irc_isc_shd.g_old_rec.attribute_category;
888: End If;
889: If (p_rec.attribute1 = hr_api.g_varchar2) then
890: p_rec.attribute1 :=
891: irc_isc_shd.g_old_rec.attribute1;
892: End If;
893: If (p_rec.attribute2 = hr_api.g_varchar2) then
894: p_rec.attribute2 :=
895: irc_isc_shd.g_old_rec.attribute2;
891: irc_isc_shd.g_old_rec.attribute1;
892: End If;
893: If (p_rec.attribute2 = hr_api.g_varchar2) then
894: p_rec.attribute2 :=
895: irc_isc_shd.g_old_rec.attribute2;
896: End If;
897: If (p_rec.attribute3 = hr_api.g_varchar2) then
898: p_rec.attribute3 :=
899: irc_isc_shd.g_old_rec.attribute3;
895: irc_isc_shd.g_old_rec.attribute2;
896: End If;
897: If (p_rec.attribute3 = hr_api.g_varchar2) then
898: p_rec.attribute3 :=
899: irc_isc_shd.g_old_rec.attribute3;
900: End If;
901: If (p_rec.attribute4 = hr_api.g_varchar2) then
902: p_rec.attribute4 :=
903: irc_isc_shd.g_old_rec.attribute4;
899: irc_isc_shd.g_old_rec.attribute3;
900: End If;
901: If (p_rec.attribute4 = hr_api.g_varchar2) then
902: p_rec.attribute4 :=
903: irc_isc_shd.g_old_rec.attribute4;
904: End If;
905: If (p_rec.attribute5 = hr_api.g_varchar2) then
906: p_rec.attribute5 :=
907: irc_isc_shd.g_old_rec.attribute5;
903: irc_isc_shd.g_old_rec.attribute4;
904: End If;
905: If (p_rec.attribute5 = hr_api.g_varchar2) then
906: p_rec.attribute5 :=
907: irc_isc_shd.g_old_rec.attribute5;
908: End If;
909: If (p_rec.attribute6 = hr_api.g_varchar2) then
910: p_rec.attribute6 :=
911: irc_isc_shd.g_old_rec.attribute6;
907: irc_isc_shd.g_old_rec.attribute5;
908: End If;
909: If (p_rec.attribute6 = hr_api.g_varchar2) then
910: p_rec.attribute6 :=
911: irc_isc_shd.g_old_rec.attribute6;
912: End If;
913: If (p_rec.attribute7 = hr_api.g_varchar2) then
914: p_rec.attribute7 :=
915: irc_isc_shd.g_old_rec.attribute7;
911: irc_isc_shd.g_old_rec.attribute6;
912: End If;
913: If (p_rec.attribute7 = hr_api.g_varchar2) then
914: p_rec.attribute7 :=
915: irc_isc_shd.g_old_rec.attribute7;
916: End If;
917: If (p_rec.attribute8 = hr_api.g_varchar2) then
918: p_rec.attribute8 :=
919: irc_isc_shd.g_old_rec.attribute8;
915: irc_isc_shd.g_old_rec.attribute7;
916: End If;
917: If (p_rec.attribute8 = hr_api.g_varchar2) then
918: p_rec.attribute8 :=
919: irc_isc_shd.g_old_rec.attribute8;
920: End If;
921: If (p_rec.attribute9 = hr_api.g_varchar2) then
922: p_rec.attribute9 :=
923: irc_isc_shd.g_old_rec.attribute9;
919: irc_isc_shd.g_old_rec.attribute8;
920: End If;
921: If (p_rec.attribute9 = hr_api.g_varchar2) then
922: p_rec.attribute9 :=
923: irc_isc_shd.g_old_rec.attribute9;
924: End If;
925: If (p_rec.attribute10 = hr_api.g_varchar2) then
926: p_rec.attribute10 :=
927: irc_isc_shd.g_old_rec.attribute10;
923: irc_isc_shd.g_old_rec.attribute9;
924: End If;
925: If (p_rec.attribute10 = hr_api.g_varchar2) then
926: p_rec.attribute10 :=
927: irc_isc_shd.g_old_rec.attribute10;
928: End If;
929: If (p_rec.attribute11 = hr_api.g_varchar2) then
930: p_rec.attribute11 :=
931: irc_isc_shd.g_old_rec.attribute11;
927: irc_isc_shd.g_old_rec.attribute10;
928: End If;
929: If (p_rec.attribute11 = hr_api.g_varchar2) then
930: p_rec.attribute11 :=
931: irc_isc_shd.g_old_rec.attribute11;
932: End If;
933: If (p_rec.attribute12 = hr_api.g_varchar2) then
934: p_rec.attribute12 :=
935: irc_isc_shd.g_old_rec.attribute12;
931: irc_isc_shd.g_old_rec.attribute11;
932: End If;
933: If (p_rec.attribute12 = hr_api.g_varchar2) then
934: p_rec.attribute12 :=
935: irc_isc_shd.g_old_rec.attribute12;
936: End If;
937: If (p_rec.attribute13 = hr_api.g_varchar2) then
938: p_rec.attribute13 :=
939: irc_isc_shd.g_old_rec.attribute13;
935: irc_isc_shd.g_old_rec.attribute12;
936: End If;
937: If (p_rec.attribute13 = hr_api.g_varchar2) then
938: p_rec.attribute13 :=
939: irc_isc_shd.g_old_rec.attribute13;
940: End If;
941: If (p_rec.attribute14 = hr_api.g_varchar2) then
942: p_rec.attribute14 :=
943: irc_isc_shd.g_old_rec.attribute14;
939: irc_isc_shd.g_old_rec.attribute13;
940: End If;
941: If (p_rec.attribute14 = hr_api.g_varchar2) then
942: p_rec.attribute14 :=
943: irc_isc_shd.g_old_rec.attribute14;
944: End If;
945: If (p_rec.attribute15 = hr_api.g_varchar2) then
946: p_rec.attribute15 :=
947: irc_isc_shd.g_old_rec.attribute15;
943: irc_isc_shd.g_old_rec.attribute14;
944: End If;
945: If (p_rec.attribute15 = hr_api.g_varchar2) then
946: p_rec.attribute15 :=
947: irc_isc_shd.g_old_rec.attribute15;
948: End If;
949: If (p_rec.attribute16 = hr_api.g_varchar2) then
950: p_rec.attribute16 :=
951: irc_isc_shd.g_old_rec.attribute16;
947: irc_isc_shd.g_old_rec.attribute15;
948: End If;
949: If (p_rec.attribute16 = hr_api.g_varchar2) then
950: p_rec.attribute16 :=
951: irc_isc_shd.g_old_rec.attribute16;
952: End If;
953: If (p_rec.attribute17 = hr_api.g_varchar2) then
954: p_rec.attribute17 :=
955: irc_isc_shd.g_old_rec.attribute17;
951: irc_isc_shd.g_old_rec.attribute16;
952: End If;
953: If (p_rec.attribute17 = hr_api.g_varchar2) then
954: p_rec.attribute17 :=
955: irc_isc_shd.g_old_rec.attribute17;
956: End If;
957: If (p_rec.attribute18 = hr_api.g_varchar2) then
958: p_rec.attribute18 :=
959: irc_isc_shd.g_old_rec.attribute18;
955: irc_isc_shd.g_old_rec.attribute17;
956: End If;
957: If (p_rec.attribute18 = hr_api.g_varchar2) then
958: p_rec.attribute18 :=
959: irc_isc_shd.g_old_rec.attribute18;
960: End If;
961: If (p_rec.attribute19 = hr_api.g_varchar2) then
962: p_rec.attribute19 :=
963: irc_isc_shd.g_old_rec.attribute19;
959: irc_isc_shd.g_old_rec.attribute18;
960: End If;
961: If (p_rec.attribute19 = hr_api.g_varchar2) then
962: p_rec.attribute19 :=
963: irc_isc_shd.g_old_rec.attribute19;
964: End If;
965: If (p_rec.attribute20 = hr_api.g_varchar2) then
966: p_rec.attribute20 :=
967: irc_isc_shd.g_old_rec.attribute20;
963: irc_isc_shd.g_old_rec.attribute19;
964: End If;
965: If (p_rec.attribute20 = hr_api.g_varchar2) then
966: p_rec.attribute20 :=
967: irc_isc_shd.g_old_rec.attribute20;
968: End If;
969: If (p_rec.attribute21 = hr_api.g_varchar2) then
970: p_rec.attribute21 :=
971: irc_isc_shd.g_old_rec.attribute21;
967: irc_isc_shd.g_old_rec.attribute20;
968: End If;
969: If (p_rec.attribute21 = hr_api.g_varchar2) then
970: p_rec.attribute21 :=
971: irc_isc_shd.g_old_rec.attribute21;
972: End If;
973: If (p_rec.attribute22 = hr_api.g_varchar2) then
974: p_rec.attribute22 :=
975: irc_isc_shd.g_old_rec.attribute22;
971: irc_isc_shd.g_old_rec.attribute21;
972: End If;
973: If (p_rec.attribute22 = hr_api.g_varchar2) then
974: p_rec.attribute22 :=
975: irc_isc_shd.g_old_rec.attribute22;
976: End If;
977: If (p_rec.attribute23 = hr_api.g_varchar2) then
978: p_rec.attribute23 :=
979: irc_isc_shd.g_old_rec.attribute23;
975: irc_isc_shd.g_old_rec.attribute22;
976: End If;
977: If (p_rec.attribute23 = hr_api.g_varchar2) then
978: p_rec.attribute23 :=
979: irc_isc_shd.g_old_rec.attribute23;
980: End If;
981: If (p_rec.attribute24 = hr_api.g_varchar2) then
982: p_rec.attribute24 :=
983: irc_isc_shd.g_old_rec.attribute24;
979: irc_isc_shd.g_old_rec.attribute23;
980: End If;
981: If (p_rec.attribute24 = hr_api.g_varchar2) then
982: p_rec.attribute24 :=
983: irc_isc_shd.g_old_rec.attribute24;
984: End If;
985: If (p_rec.attribute25 = hr_api.g_varchar2) then
986: p_rec.attribute25 :=
987: irc_isc_shd.g_old_rec.attribute25;
983: irc_isc_shd.g_old_rec.attribute24;
984: End If;
985: If (p_rec.attribute25 = hr_api.g_varchar2) then
986: p_rec.attribute25 :=
987: irc_isc_shd.g_old_rec.attribute25;
988: End If;
989: If (p_rec.attribute26 = hr_api.g_varchar2) then
990: p_rec.attribute26 :=
991: irc_isc_shd.g_old_rec.attribute26;
987: irc_isc_shd.g_old_rec.attribute25;
988: End If;
989: If (p_rec.attribute26 = hr_api.g_varchar2) then
990: p_rec.attribute26 :=
991: irc_isc_shd.g_old_rec.attribute26;
992: End If;
993: If (p_rec.attribute27 = hr_api.g_varchar2) then
994: p_rec.attribute27 :=
995: irc_isc_shd.g_old_rec.attribute27;
991: irc_isc_shd.g_old_rec.attribute26;
992: End If;
993: If (p_rec.attribute27 = hr_api.g_varchar2) then
994: p_rec.attribute27 :=
995: irc_isc_shd.g_old_rec.attribute27;
996: End If;
997: If (p_rec.attribute28 = hr_api.g_varchar2) then
998: p_rec.attribute28 :=
999: irc_isc_shd.g_old_rec.attribute28;
995: irc_isc_shd.g_old_rec.attribute27;
996: End If;
997: If (p_rec.attribute28 = hr_api.g_varchar2) then
998: p_rec.attribute28 :=
999: irc_isc_shd.g_old_rec.attribute28;
1000: End If;
1001: If (p_rec.attribute29 = hr_api.g_varchar2) then
1002: p_rec.attribute29 :=
1003: irc_isc_shd.g_old_rec.attribute29;
999: irc_isc_shd.g_old_rec.attribute28;
1000: End If;
1001: If (p_rec.attribute29 = hr_api.g_varchar2) then
1002: p_rec.attribute29 :=
1003: irc_isc_shd.g_old_rec.attribute29;
1004: End If;
1005: If (p_rec.attribute30 = hr_api.g_varchar2) then
1006: p_rec.attribute30 :=
1007: irc_isc_shd.g_old_rec.attribute30;
1003: irc_isc_shd.g_old_rec.attribute29;
1004: End If;
1005: If (p_rec.attribute30 = hr_api.g_varchar2) then
1006: p_rec.attribute30 :=
1007: irc_isc_shd.g_old_rec.attribute30;
1008: End If;
1009: If (p_rec.isc_information_category = hr_api.g_varchar2) then
1010: p_rec.isc_information_category :=
1011: irc_isc_shd.g_old_rec.isc_information_category;
1007: irc_isc_shd.g_old_rec.attribute30;
1008: End If;
1009: If (p_rec.isc_information_category = hr_api.g_varchar2) then
1010: p_rec.isc_information_category :=
1011: irc_isc_shd.g_old_rec.isc_information_category;
1012: End If;
1013: If (p_rec.isc_information1 = hr_api.g_varchar2) then
1014: p_rec.isc_information1 :=
1015: irc_isc_shd.g_old_rec.isc_information1;
1011: irc_isc_shd.g_old_rec.isc_information_category;
1012: End If;
1013: If (p_rec.isc_information1 = hr_api.g_varchar2) then
1014: p_rec.isc_information1 :=
1015: irc_isc_shd.g_old_rec.isc_information1;
1016: End If;
1017: If (p_rec.isc_information2 = hr_api.g_varchar2) then
1018: p_rec.isc_information2 :=
1019: irc_isc_shd.g_old_rec.isc_information2;
1015: irc_isc_shd.g_old_rec.isc_information1;
1016: End If;
1017: If (p_rec.isc_information2 = hr_api.g_varchar2) then
1018: p_rec.isc_information2 :=
1019: irc_isc_shd.g_old_rec.isc_information2;
1020: End If;
1021: If (p_rec.isc_information3 = hr_api.g_varchar2) then
1022: p_rec.isc_information3 :=
1023: irc_isc_shd.g_old_rec.isc_information3;
1019: irc_isc_shd.g_old_rec.isc_information2;
1020: End If;
1021: If (p_rec.isc_information3 = hr_api.g_varchar2) then
1022: p_rec.isc_information3 :=
1023: irc_isc_shd.g_old_rec.isc_information3;
1024: End If;
1025: If (p_rec.isc_information4 = hr_api.g_varchar2) then
1026: p_rec.isc_information4 :=
1027: irc_isc_shd.g_old_rec.isc_information4;
1023: irc_isc_shd.g_old_rec.isc_information3;
1024: End If;
1025: If (p_rec.isc_information4 = hr_api.g_varchar2) then
1026: p_rec.isc_information4 :=
1027: irc_isc_shd.g_old_rec.isc_information4;
1028: End If;
1029: If (p_rec.isc_information5 = hr_api.g_varchar2) then
1030: p_rec.isc_information5 :=
1031: irc_isc_shd.g_old_rec.isc_information5;
1027: irc_isc_shd.g_old_rec.isc_information4;
1028: End If;
1029: If (p_rec.isc_information5 = hr_api.g_varchar2) then
1030: p_rec.isc_information5 :=
1031: irc_isc_shd.g_old_rec.isc_information5;
1032: End If;
1033: If (p_rec.isc_information6 = hr_api.g_varchar2) then
1034: p_rec.isc_information6 :=
1035: irc_isc_shd.g_old_rec.isc_information6;
1031: irc_isc_shd.g_old_rec.isc_information5;
1032: End If;
1033: If (p_rec.isc_information6 = hr_api.g_varchar2) then
1034: p_rec.isc_information6 :=
1035: irc_isc_shd.g_old_rec.isc_information6;
1036: End If;
1037: If (p_rec.isc_information7 = hr_api.g_varchar2) then
1038: p_rec.isc_information7 :=
1039: irc_isc_shd.g_old_rec.isc_information7;
1035: irc_isc_shd.g_old_rec.isc_information6;
1036: End If;
1037: If (p_rec.isc_information7 = hr_api.g_varchar2) then
1038: p_rec.isc_information7 :=
1039: irc_isc_shd.g_old_rec.isc_information7;
1040: End If;
1041: If (p_rec.isc_information8 = hr_api.g_varchar2) then
1042: p_rec.isc_information8 :=
1043: irc_isc_shd.g_old_rec.isc_information8;
1039: irc_isc_shd.g_old_rec.isc_information7;
1040: End If;
1041: If (p_rec.isc_information8 = hr_api.g_varchar2) then
1042: p_rec.isc_information8 :=
1043: irc_isc_shd.g_old_rec.isc_information8;
1044: End If;
1045: If (p_rec.isc_information9 = hr_api.g_varchar2) then
1046: p_rec.isc_information9 :=
1047: irc_isc_shd.g_old_rec.isc_information9;
1043: irc_isc_shd.g_old_rec.isc_information8;
1044: End If;
1045: If (p_rec.isc_information9 = hr_api.g_varchar2) then
1046: p_rec.isc_information9 :=
1047: irc_isc_shd.g_old_rec.isc_information9;
1048: End If;
1049: If (p_rec.isc_information10 = hr_api.g_varchar2) then
1050: p_rec.isc_information10 :=
1051: irc_isc_shd.g_old_rec.isc_information10;
1047: irc_isc_shd.g_old_rec.isc_information9;
1048: End If;
1049: If (p_rec.isc_information10 = hr_api.g_varchar2) then
1050: p_rec.isc_information10 :=
1051: irc_isc_shd.g_old_rec.isc_information10;
1052: End If;
1053: If (p_rec.isc_information11 = hr_api.g_varchar2) then
1054: p_rec.isc_information11 :=
1055: irc_isc_shd.g_old_rec.isc_information11;
1051: irc_isc_shd.g_old_rec.isc_information10;
1052: End If;
1053: If (p_rec.isc_information11 = hr_api.g_varchar2) then
1054: p_rec.isc_information11 :=
1055: irc_isc_shd.g_old_rec.isc_information11;
1056: End If;
1057: If (p_rec.isc_information12 = hr_api.g_varchar2) then
1058: p_rec.isc_information12 :=
1059: irc_isc_shd.g_old_rec.isc_information12;
1055: irc_isc_shd.g_old_rec.isc_information11;
1056: End If;
1057: If (p_rec.isc_information12 = hr_api.g_varchar2) then
1058: p_rec.isc_information12 :=
1059: irc_isc_shd.g_old_rec.isc_information12;
1060: End If;
1061: If (p_rec.isc_information13 = hr_api.g_varchar2) then
1062: p_rec.isc_information13 :=
1063: irc_isc_shd.g_old_rec.isc_information13;
1059: irc_isc_shd.g_old_rec.isc_information12;
1060: End If;
1061: If (p_rec.isc_information13 = hr_api.g_varchar2) then
1062: p_rec.isc_information13 :=
1063: irc_isc_shd.g_old_rec.isc_information13;
1064: End If;
1065: If (p_rec.isc_information14 = hr_api.g_varchar2) then
1066: p_rec.isc_information14 :=
1067: irc_isc_shd.g_old_rec.isc_information14;
1063: irc_isc_shd.g_old_rec.isc_information13;
1064: End If;
1065: If (p_rec.isc_information14 = hr_api.g_varchar2) then
1066: p_rec.isc_information14 :=
1067: irc_isc_shd.g_old_rec.isc_information14;
1068: End If;
1069: If (p_rec.isc_information15 = hr_api.g_varchar2) then
1070: p_rec.isc_information15 :=
1071: irc_isc_shd.g_old_rec.isc_information15;
1067: irc_isc_shd.g_old_rec.isc_information14;
1068: End If;
1069: If (p_rec.isc_information15 = hr_api.g_varchar2) then
1070: p_rec.isc_information15 :=
1071: irc_isc_shd.g_old_rec.isc_information15;
1072: End If;
1073: If (p_rec.isc_information16 = hr_api.g_varchar2) then
1074: p_rec.isc_information16 :=
1075: irc_isc_shd.g_old_rec.isc_information16;
1071: irc_isc_shd.g_old_rec.isc_information15;
1072: End If;
1073: If (p_rec.isc_information16 = hr_api.g_varchar2) then
1074: p_rec.isc_information16 :=
1075: irc_isc_shd.g_old_rec.isc_information16;
1076: End If;
1077: If (p_rec.isc_information17 = hr_api.g_varchar2) then
1078: p_rec.isc_information17 :=
1079: irc_isc_shd.g_old_rec.isc_information17;
1075: irc_isc_shd.g_old_rec.isc_information16;
1076: End If;
1077: If (p_rec.isc_information17 = hr_api.g_varchar2) then
1078: p_rec.isc_information17 :=
1079: irc_isc_shd.g_old_rec.isc_information17;
1080: End If;
1081: If (p_rec.isc_information18 = hr_api.g_varchar2) then
1082: p_rec.isc_information18 :=
1083: irc_isc_shd.g_old_rec.isc_information18;
1079: irc_isc_shd.g_old_rec.isc_information17;
1080: End If;
1081: If (p_rec.isc_information18 = hr_api.g_varchar2) then
1082: p_rec.isc_information18 :=
1083: irc_isc_shd.g_old_rec.isc_information18;
1084: End If;
1085: If (p_rec.isc_information19 = hr_api.g_varchar2) then
1086: p_rec.isc_information19 :=
1087: irc_isc_shd.g_old_rec.isc_information19;
1083: irc_isc_shd.g_old_rec.isc_information18;
1084: End If;
1085: If (p_rec.isc_information19 = hr_api.g_varchar2) then
1086: p_rec.isc_information19 :=
1087: irc_isc_shd.g_old_rec.isc_information19;
1088: End If;
1089: If (p_rec.isc_information20 = hr_api.g_varchar2) then
1090: p_rec.isc_information20 :=
1091: irc_isc_shd.g_old_rec.isc_information20;
1087: irc_isc_shd.g_old_rec.isc_information19;
1088: End If;
1089: If (p_rec.isc_information20 = hr_api.g_varchar2) then
1090: p_rec.isc_information20 :=
1091: irc_isc_shd.g_old_rec.isc_information20;
1092: End If;
1093: If (p_rec.isc_information21 = hr_api.g_varchar2) then
1094: p_rec.isc_information21 :=
1095: irc_isc_shd.g_old_rec.isc_information21;
1091: irc_isc_shd.g_old_rec.isc_information20;
1092: End If;
1093: If (p_rec.isc_information21 = hr_api.g_varchar2) then
1094: p_rec.isc_information21 :=
1095: irc_isc_shd.g_old_rec.isc_information21;
1096: End If;
1097: If (p_rec.isc_information22 = hr_api.g_varchar2) then
1098: p_rec.isc_information22 :=
1099: irc_isc_shd.g_old_rec.isc_information22;
1095: irc_isc_shd.g_old_rec.isc_information21;
1096: End If;
1097: If (p_rec.isc_information22 = hr_api.g_varchar2) then
1098: p_rec.isc_information22 :=
1099: irc_isc_shd.g_old_rec.isc_information22;
1100: End If;
1101: If (p_rec.isc_information23 = hr_api.g_varchar2) then
1102: p_rec.isc_information23 :=
1103: irc_isc_shd.g_old_rec.isc_information23;
1099: irc_isc_shd.g_old_rec.isc_information22;
1100: End If;
1101: If (p_rec.isc_information23 = hr_api.g_varchar2) then
1102: p_rec.isc_information23 :=
1103: irc_isc_shd.g_old_rec.isc_information23;
1104: End If;
1105: If (p_rec.isc_information24 = hr_api.g_varchar2) then
1106: p_rec.isc_information24 :=
1107: irc_isc_shd.g_old_rec.isc_information24;
1103: irc_isc_shd.g_old_rec.isc_information23;
1104: End If;
1105: If (p_rec.isc_information24 = hr_api.g_varchar2) then
1106: p_rec.isc_information24 :=
1107: irc_isc_shd.g_old_rec.isc_information24;
1108: End If;
1109: If (p_rec.isc_information25 = hr_api.g_varchar2) then
1110: p_rec.isc_information25 :=
1111: irc_isc_shd.g_old_rec.isc_information25;
1107: irc_isc_shd.g_old_rec.isc_information24;
1108: End If;
1109: If (p_rec.isc_information25 = hr_api.g_varchar2) then
1110: p_rec.isc_information25 :=
1111: irc_isc_shd.g_old_rec.isc_information25;
1112: End If;
1113: If (p_rec.isc_information26 = hr_api.g_varchar2) then
1114: p_rec.isc_information26 :=
1115: irc_isc_shd.g_old_rec.isc_information26;
1111: irc_isc_shd.g_old_rec.isc_information25;
1112: End If;
1113: If (p_rec.isc_information26 = hr_api.g_varchar2) then
1114: p_rec.isc_information26 :=
1115: irc_isc_shd.g_old_rec.isc_information26;
1116: End If;
1117: If (p_rec.isc_information27 = hr_api.g_varchar2) then
1118: p_rec.isc_information27 :=
1119: irc_isc_shd.g_old_rec.isc_information27;
1115: irc_isc_shd.g_old_rec.isc_information26;
1116: End If;
1117: If (p_rec.isc_information27 = hr_api.g_varchar2) then
1118: p_rec.isc_information27 :=
1119: irc_isc_shd.g_old_rec.isc_information27;
1120: End If;
1121: If (p_rec.isc_information28 = hr_api.g_varchar2) then
1122: p_rec.isc_information28 :=
1123: irc_isc_shd.g_old_rec.isc_information28;
1119: irc_isc_shd.g_old_rec.isc_information27;
1120: End If;
1121: If (p_rec.isc_information28 = hr_api.g_varchar2) then
1122: p_rec.isc_information28 :=
1123: irc_isc_shd.g_old_rec.isc_information28;
1124: End If;
1125: If (p_rec.isc_information29 = hr_api.g_varchar2) then
1126: p_rec.isc_information29 :=
1127: irc_isc_shd.g_old_rec.isc_information29;
1123: irc_isc_shd.g_old_rec.isc_information28;
1124: End If;
1125: If (p_rec.isc_information29 = hr_api.g_varchar2) then
1126: p_rec.isc_information29 :=
1127: irc_isc_shd.g_old_rec.isc_information29;
1128: End If;
1129: If (p_rec.isc_information30 = hr_api.g_varchar2) then
1130: p_rec.isc_information30 :=
1131: irc_isc_shd.g_old_rec.isc_information30;
1127: irc_isc_shd.g_old_rec.isc_information29;
1128: End If;
1129: If (p_rec.isc_information30 = hr_api.g_varchar2) then
1130: p_rec.isc_information30 :=
1131: irc_isc_shd.g_old_rec.isc_information30;
1132: End If;
1133: If (p_rec.date_posted = hr_api.g_varchar2) then
1134: p_rec.date_posted :=
1135: irc_isc_shd.g_old_rec.date_posted;
1131: irc_isc_shd.g_old_rec.isc_information30;
1132: End If;
1133: If (p_rec.date_posted = hr_api.g_varchar2) then
1134: p_rec.date_posted :=
1135: irc_isc_shd.g_old_rec.date_posted;
1136: End If;
1137: --
1138: End convert_defs;
1139: --
1141: -- |---------------------------------< upd >----------------------------------|
1142: -- ----------------------------------------------------------------------------
1143: Procedure upd
1144: (p_effective_date in date
1145: ,p_rec in out nocopy irc_isc_shd.g_rec_type
1146: ) is
1147: --
1148: l_proc varchar2(72) := g_package||'upd';
1149: --
1151: hr_utility.set_location('Entering:'||l_proc, 5);
1152: --
1153: -- We must lock the row which we need to update.
1154: --
1155: irc_isc_shd.lck
1156: (p_rec.search_criteria_id
1157: ,p_rec.object_version_number
1158: );
1159: --
1293: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1294: ,p_date_posted in varchar2 default hr_api.g_varchar2
1295: ) is
1296: --
1297: l_rec irc_isc_shd.g_rec_type;
1298: l_proc varchar2(72) := g_package||'upd';
1299: --
1300: Begin
1301: hr_utility.set_location('Entering:'||l_proc, 5);
1303: -- Call conversion function to turn arguments into the
1304: -- l_rec structure.
1305: --
1306: l_rec :=
1307: irc_isc_shd.convert_args
1308: (p_search_criteria_id
1309: ,p_object_id
1310: ,p_object_type
1311: ,p_search_name