162: -- declare local variables
163: -- --------------------------------------------------------------------------
164: l_proc varchar2(72) := g_package||'get_varchar2_value';
165: l_insert boolean := false;
166: l_name hr_api_transaction_values.name%type;
167: l_varchar2_value varchar2(1000);
168: --
169: cursor csr_hatv is
170: select hatv.varchar2_value
167: l_varchar2_value varchar2(1000);
168: --
169: cursor csr_hatv is
170: select hatv.varchar2_value
171: from hr_api_transaction_values hatv
172: where hatv.transaction_step_id = p_transaction_step_id
173: and hatv.name = l_name;
174: --
175: begin
206: -- declare local variables
207: -- --------------------------------------------------------------------------
208: l_proc varchar2(72) := g_package||'get_number_value';
209: l_insert boolean := false;
210: l_name hr_api_transaction_values.name%type;
211: l_number_value number;
212: --
213: cursor csr_hatv is
214: select hatv.number_value
211: l_number_value number;
212: --
213: cursor csr_hatv is
214: select hatv.number_value
215: from hr_api_transaction_values hatv
216: where hatv.transaction_step_id = p_transaction_step_id
217: and hatv.name = l_name;
218: --
219: begin
1425: PROCEDURE update_contact_relationship
1426: (p_validate in varchar2 default 'Y'
1427: ,p_cont_effective_date in date
1428: ,p_contact_relationship_id in number
1429: ,p_contact_type in varchar2 default hr_api.g_varchar2
1430: ,p_ctr_comments in long default hr_api.g_varchar2
1431: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1432: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1433: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1426: (p_validate in varchar2 default 'Y'
1427: ,p_cont_effective_date in date
1428: ,p_contact_relationship_id in number
1429: ,p_contact_type in varchar2 default hr_api.g_varchar2
1430: ,p_ctr_comments in long default hr_api.g_varchar2
1431: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1432: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1433: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1434: ,p_date_start in date default hr_api.g_date
1427: ,p_cont_effective_date in date
1428: ,p_contact_relationship_id in number
1429: ,p_contact_type in varchar2 default hr_api.g_varchar2
1430: ,p_ctr_comments in long default hr_api.g_varchar2
1431: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1432: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1433: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1434: ,p_date_start in date default hr_api.g_date
1435: ,p_start_life_reason_id in number default hr_api.g_number
1428: ,p_contact_relationship_id in number
1429: ,p_contact_type in varchar2 default hr_api.g_varchar2
1430: ,p_ctr_comments in long default hr_api.g_varchar2
1431: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1432: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1433: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1434: ,p_date_start in date default hr_api.g_date
1435: ,p_start_life_reason_id in number default hr_api.g_number
1436: ,p_date_end in date default hr_api.g_date
1429: ,p_contact_type in varchar2 default hr_api.g_varchar2
1430: ,p_ctr_comments in long default hr_api.g_varchar2
1431: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1432: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1433: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1434: ,p_date_start in date default hr_api.g_date
1435: ,p_start_life_reason_id in number default hr_api.g_number
1436: ,p_date_end in date default hr_api.g_date
1437: ,p_end_life_reason_id in number default hr_api.g_number
1430: ,p_ctr_comments in long default hr_api.g_varchar2
1431: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1432: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1433: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1434: ,p_date_start in date default hr_api.g_date
1435: ,p_start_life_reason_id in number default hr_api.g_number
1436: ,p_date_end in date default hr_api.g_date
1437: ,p_end_life_reason_id in number default hr_api.g_number
1438: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1431: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1432: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1433: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1434: ,p_date_start in date default hr_api.g_date
1435: ,p_start_life_reason_id in number default hr_api.g_number
1436: ,p_date_end in date default hr_api.g_date
1437: ,p_end_life_reason_id in number default hr_api.g_number
1438: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1439: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1432: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1433: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1434: ,p_date_start in date default hr_api.g_date
1435: ,p_start_life_reason_id in number default hr_api.g_number
1436: ,p_date_end in date default hr_api.g_date
1437: ,p_end_life_reason_id in number default hr_api.g_number
1438: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1439: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1440: ,p_sequence_number in number default hr_api.g_number
1433: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1434: ,p_date_start in date default hr_api.g_date
1435: ,p_start_life_reason_id in number default hr_api.g_number
1436: ,p_date_end in date default hr_api.g_date
1437: ,p_end_life_reason_id in number default hr_api.g_number
1438: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1439: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1440: ,p_sequence_number in number default hr_api.g_number
1441: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1434: ,p_date_start in date default hr_api.g_date
1435: ,p_start_life_reason_id in number default hr_api.g_number
1436: ,p_date_end in date default hr_api.g_date
1437: ,p_end_life_reason_id in number default hr_api.g_number
1438: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1439: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1440: ,p_sequence_number in number default hr_api.g_number
1441: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1442: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1435: ,p_start_life_reason_id in number default hr_api.g_number
1436: ,p_date_end in date default hr_api.g_date
1437: ,p_end_life_reason_id in number default hr_api.g_number
1438: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1439: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1440: ,p_sequence_number in number default hr_api.g_number
1441: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1442: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1443: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1436: ,p_date_end in date default hr_api.g_date
1437: ,p_end_life_reason_id in number default hr_api.g_number
1438: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1439: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1440: ,p_sequence_number in number default hr_api.g_number
1441: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1442: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1443: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1444: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1437: ,p_end_life_reason_id in number default hr_api.g_number
1438: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1439: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1440: ,p_sequence_number in number default hr_api.g_number
1441: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1442: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1443: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1444: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1445: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1438: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1439: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1440: ,p_sequence_number in number default hr_api.g_number
1441: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1442: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1443: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1444: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1445: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1446: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1439: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1440: ,p_sequence_number in number default hr_api.g_number
1441: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1442: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1443: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1444: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1445: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1446: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1447: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1440: ,p_sequence_number in number default hr_api.g_number
1441: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1442: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1443: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1444: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1445: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1446: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1447: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1448: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1441: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1442: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1443: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1444: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1445: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1446: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1447: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1448: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1449: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1442: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1443: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1444: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1445: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1446: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1447: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1448: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1449: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1450: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1443: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1444: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1445: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1446: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1447: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1448: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1449: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1450: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1451: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1444: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1445: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1446: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1447: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1448: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1449: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1450: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1451: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1452: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1445: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1446: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1447: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1448: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1449: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1450: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1451: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1452: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1453: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1446: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1447: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1448: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1449: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1450: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1451: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1452: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1453: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1454: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1447: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1448: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1449: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1450: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1451: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1452: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1453: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1454: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1455: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1448: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1449: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1450: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1451: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1452: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1453: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1454: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1455: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1456: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1449: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1450: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1451: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1452: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1453: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1454: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1455: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1456: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1457: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1450: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1451: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1452: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1453: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1454: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1455: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1456: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1457: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1458: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1451: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1452: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1453: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1454: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1455: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1456: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1457: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1458: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1459: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1452: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1453: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1454: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1455: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1456: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1457: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1458: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1459: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1460: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1453: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1454: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1455: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1456: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1457: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1458: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1459: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1460: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1461: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1454: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1455: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1456: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1457: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1458: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1459: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1460: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1461: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1462: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1455: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1456: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1457: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1458: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1459: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1460: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1461: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1462: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1463: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1456: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1457: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1458: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1459: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1460: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1461: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1462: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1463: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1464: ,p_person_id in number
1457: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1458: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1459: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1460: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1461: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1462: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1463: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1464: ,p_person_id in number
1465: ,p_login_person_id in number default hr_api.g_number
1458: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1459: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1460: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1461: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1462: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1463: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1464: ,p_person_id in number
1465: ,p_login_person_id in number default hr_api.g_number
1466: ,p_cont_object_version_number in out nocopy number
1459: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1460: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1461: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1462: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1463: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1464: ,p_person_id in number
1465: ,p_login_person_id in number default hr_api.g_number
1466: ,p_cont_object_version_number in out nocopy number
1467: ,p_item_type in varchar2
1461: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1462: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1463: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1464: ,p_person_id in number
1465: ,p_login_person_id in number default hr_api.g_number
1466: ,p_cont_object_version_number in out nocopy number
1467: ,p_item_type in varchar2
1468: ,p_item_key in varchar2
1469: ,p_activity_id in number
1468: ,p_item_key in varchar2
1469: ,p_activity_id in number
1470: ,p_action in varchar2 -- this is p_action_type
1471: ,p_process_section_name in varchar2
1472: ,p_review_page_region_code in varchar2 default hr_api.g_varchar2
1473:
1474: -- Update_person parameters
1475:
1476: ,p_per_effective_date in date
1476: ,p_per_effective_date in date
1477: ,p_datetrack_update_mode in varchar2
1478: ,p_cont_person_id in number
1479: ,p_per_object_version_number in out nocopy number
1480: ,p_person_type_id in number default hr_api.g_number
1481: ,p_last_name in varchar2 default hr_api.g_varchar2
1482: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1483: ,p_per_comments in varchar2 default hr_api.g_varchar2
1484: ,p_date_employee_data_verified in date default hr_api.g_date
1477: ,p_datetrack_update_mode in varchar2
1478: ,p_cont_person_id in number
1479: ,p_per_object_version_number in out nocopy number
1480: ,p_person_type_id in number default hr_api.g_number
1481: ,p_last_name in varchar2 default hr_api.g_varchar2
1482: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1483: ,p_per_comments in varchar2 default hr_api.g_varchar2
1484: ,p_date_employee_data_verified in date default hr_api.g_date
1485: ,p_date_of_birth in date default hr_api.g_date
1478: ,p_cont_person_id in number
1479: ,p_per_object_version_number in out nocopy number
1480: ,p_person_type_id in number default hr_api.g_number
1481: ,p_last_name in varchar2 default hr_api.g_varchar2
1482: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1483: ,p_per_comments in varchar2 default hr_api.g_varchar2
1484: ,p_date_employee_data_verified in date default hr_api.g_date
1485: ,p_date_of_birth in date default hr_api.g_date
1486: ,p_email_address in varchar2 default hr_api.g_varchar2
1479: ,p_per_object_version_number in out nocopy number
1480: ,p_person_type_id in number default hr_api.g_number
1481: ,p_last_name in varchar2 default hr_api.g_varchar2
1482: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1483: ,p_per_comments in varchar2 default hr_api.g_varchar2
1484: ,p_date_employee_data_verified in date default hr_api.g_date
1485: ,p_date_of_birth in date default hr_api.g_date
1486: ,p_email_address in varchar2 default hr_api.g_varchar2
1487: ,p_employee_number in out nocopy varchar2
1480: ,p_person_type_id in number default hr_api.g_number
1481: ,p_last_name in varchar2 default hr_api.g_varchar2
1482: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1483: ,p_per_comments in varchar2 default hr_api.g_varchar2
1484: ,p_date_employee_data_verified in date default hr_api.g_date
1485: ,p_date_of_birth in date default hr_api.g_date
1486: ,p_email_address in varchar2 default hr_api.g_varchar2
1487: ,p_employee_number in out nocopy varchar2
1488: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1481: ,p_last_name in varchar2 default hr_api.g_varchar2
1482: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1483: ,p_per_comments in varchar2 default hr_api.g_varchar2
1484: ,p_date_employee_data_verified in date default hr_api.g_date
1485: ,p_date_of_birth in date default hr_api.g_date
1486: ,p_email_address in varchar2 default hr_api.g_varchar2
1487: ,p_employee_number in out nocopy varchar2
1488: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1489: ,p_first_name in varchar2 default hr_api.g_varchar2
1482: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1483: ,p_per_comments in varchar2 default hr_api.g_varchar2
1484: ,p_date_employee_data_verified in date default hr_api.g_date
1485: ,p_date_of_birth in date default hr_api.g_date
1486: ,p_email_address in varchar2 default hr_api.g_varchar2
1487: ,p_employee_number in out nocopy varchar2
1488: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1489: ,p_first_name in varchar2 default hr_api.g_varchar2
1490: ,p_known_as in varchar2 default hr_api.g_varchar2
1484: ,p_date_employee_data_verified in date default hr_api.g_date
1485: ,p_date_of_birth in date default hr_api.g_date
1486: ,p_email_address in varchar2 default hr_api.g_varchar2
1487: ,p_employee_number in out nocopy varchar2
1488: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1489: ,p_first_name in varchar2 default hr_api.g_varchar2
1490: ,p_known_as in varchar2 default hr_api.g_varchar2
1491: ,p_marital_status in varchar2 default hr_api.g_varchar2
1492: ,p_middle_names in varchar2 default hr_api.g_varchar2
1485: ,p_date_of_birth in date default hr_api.g_date
1486: ,p_email_address in varchar2 default hr_api.g_varchar2
1487: ,p_employee_number in out nocopy varchar2
1488: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1489: ,p_first_name in varchar2 default hr_api.g_varchar2
1490: ,p_known_as in varchar2 default hr_api.g_varchar2
1491: ,p_marital_status in varchar2 default hr_api.g_varchar2
1492: ,p_middle_names in varchar2 default hr_api.g_varchar2
1493: ,p_nationality in varchar2 default hr_api.g_varchar2
1486: ,p_email_address in varchar2 default hr_api.g_varchar2
1487: ,p_employee_number in out nocopy varchar2
1488: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1489: ,p_first_name in varchar2 default hr_api.g_varchar2
1490: ,p_known_as in varchar2 default hr_api.g_varchar2
1491: ,p_marital_status in varchar2 default hr_api.g_varchar2
1492: ,p_middle_names in varchar2 default hr_api.g_varchar2
1493: ,p_nationality in varchar2 default hr_api.g_varchar2
1494: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1487: ,p_employee_number in out nocopy varchar2
1488: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1489: ,p_first_name in varchar2 default hr_api.g_varchar2
1490: ,p_known_as in varchar2 default hr_api.g_varchar2
1491: ,p_marital_status in varchar2 default hr_api.g_varchar2
1492: ,p_middle_names in varchar2 default hr_api.g_varchar2
1493: ,p_nationality in varchar2 default hr_api.g_varchar2
1494: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1495: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1488: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1489: ,p_first_name in varchar2 default hr_api.g_varchar2
1490: ,p_known_as in varchar2 default hr_api.g_varchar2
1491: ,p_marital_status in varchar2 default hr_api.g_varchar2
1492: ,p_middle_names in varchar2 default hr_api.g_varchar2
1493: ,p_nationality in varchar2 default hr_api.g_varchar2
1494: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1495: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1496: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1489: ,p_first_name in varchar2 default hr_api.g_varchar2
1490: ,p_known_as in varchar2 default hr_api.g_varchar2
1491: ,p_marital_status in varchar2 default hr_api.g_varchar2
1492: ,p_middle_names in varchar2 default hr_api.g_varchar2
1493: ,p_nationality in varchar2 default hr_api.g_varchar2
1494: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1495: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1496: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1497: ,p_sex in varchar2 default hr_api.g_varchar2
1490: ,p_known_as in varchar2 default hr_api.g_varchar2
1491: ,p_marital_status in varchar2 default hr_api.g_varchar2
1492: ,p_middle_names in varchar2 default hr_api.g_varchar2
1493: ,p_nationality in varchar2 default hr_api.g_varchar2
1494: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1495: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1496: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1497: ,p_sex in varchar2 default hr_api.g_varchar2
1498: ,p_title in varchar2 default hr_api.g_varchar2
1491: ,p_marital_status in varchar2 default hr_api.g_varchar2
1492: ,p_middle_names in varchar2 default hr_api.g_varchar2
1493: ,p_nationality in varchar2 default hr_api.g_varchar2
1494: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1495: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1496: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1497: ,p_sex in varchar2 default hr_api.g_varchar2
1498: ,p_title in varchar2 default hr_api.g_varchar2
1499: ,p_vendor_id in number default hr_api.g_number
1492: ,p_middle_names in varchar2 default hr_api.g_varchar2
1493: ,p_nationality in varchar2 default hr_api.g_varchar2
1494: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1495: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1496: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1497: ,p_sex in varchar2 default hr_api.g_varchar2
1498: ,p_title in varchar2 default hr_api.g_varchar2
1499: ,p_vendor_id in number default hr_api.g_number
1500: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1493: ,p_nationality in varchar2 default hr_api.g_varchar2
1494: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1495: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1496: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1497: ,p_sex in varchar2 default hr_api.g_varchar2
1498: ,p_title in varchar2 default hr_api.g_varchar2
1499: ,p_vendor_id in number default hr_api.g_number
1500: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1494: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1495: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1496: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1497: ,p_sex in varchar2 default hr_api.g_varchar2
1498: ,p_title in varchar2 default hr_api.g_varchar2
1499: ,p_vendor_id in number default hr_api.g_number
1500: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1495: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1496: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1497: ,p_sex in varchar2 default hr_api.g_varchar2
1498: ,p_title in varchar2 default hr_api.g_varchar2
1499: ,p_vendor_id in number default hr_api.g_number
1500: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1496: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1497: ,p_sex in varchar2 default hr_api.g_varchar2
1498: ,p_title in varchar2 default hr_api.g_varchar2
1499: ,p_vendor_id in number default hr_api.g_number
1500: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1497: ,p_sex in varchar2 default hr_api.g_varchar2
1498: ,p_title in varchar2 default hr_api.g_varchar2
1499: ,p_vendor_id in number default hr_api.g_number
1500: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1498: ,p_title in varchar2 default hr_api.g_varchar2
1499: ,p_vendor_id in number default hr_api.g_number
1500: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1499: ,p_vendor_id in number default hr_api.g_number
1500: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1500: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1533: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1533: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1533: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1533: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1533: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1533: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1533: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1533: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1559: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1559: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1560: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1559: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1560: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1561: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1559: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1560: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1561: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1562: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1559: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1560: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1561: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1562: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1563: ,p_date_of_death in date default hr_api.g_date
1556: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1559: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1560: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1561: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1562: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1563: ,p_date_of_death in date default hr_api.g_date
1564: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1557: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1559: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1560: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1561: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1562: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1563: ,p_date_of_death in date default hr_api.g_date
1564: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1565: ,p_background_date_check in date default hr_api.g_date
1558: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1559: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1560: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1561: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1562: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1563: ,p_date_of_death in date default hr_api.g_date
1564: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1565: ,p_background_date_check in date default hr_api.g_date
1566: ,p_blood_type in varchar2 default hr_api.g_varchar2
1559: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1560: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1561: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1562: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1563: ,p_date_of_death in date default hr_api.g_date
1564: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1565: ,p_background_date_check in date default hr_api.g_date
1566: ,p_blood_type in varchar2 default hr_api.g_varchar2
1567: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1560: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1561: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1562: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1563: ,p_date_of_death in date default hr_api.g_date
1564: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1565: ,p_background_date_check in date default hr_api.g_date
1566: ,p_blood_type in varchar2 default hr_api.g_varchar2
1567: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1568: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1561: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1562: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1563: ,p_date_of_death in date default hr_api.g_date
1564: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1565: ,p_background_date_check in date default hr_api.g_date
1566: ,p_blood_type in varchar2 default hr_api.g_varchar2
1567: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1568: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1569: ,p_fte_capacity in number default hr_api.g_number
1562: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1563: ,p_date_of_death in date default hr_api.g_date
1564: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1565: ,p_background_date_check in date default hr_api.g_date
1566: ,p_blood_type in varchar2 default hr_api.g_varchar2
1567: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1568: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1569: ,p_fte_capacity in number default hr_api.g_number
1570: ,p_hold_applicant_date_until in date default hr_api.g_date
1563: ,p_date_of_death in date default hr_api.g_date
1564: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1565: ,p_background_date_check in date default hr_api.g_date
1566: ,p_blood_type in varchar2 default hr_api.g_varchar2
1567: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1568: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1569: ,p_fte_capacity in number default hr_api.g_number
1570: ,p_hold_applicant_date_until in date default hr_api.g_date
1571: ,p_honors in varchar2 default hr_api.g_varchar2
1564: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1565: ,p_background_date_check in date default hr_api.g_date
1566: ,p_blood_type in varchar2 default hr_api.g_varchar2
1567: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1568: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1569: ,p_fte_capacity in number default hr_api.g_number
1570: ,p_hold_applicant_date_until in date default hr_api.g_date
1571: ,p_honors in varchar2 default hr_api.g_varchar2
1572: ,p_internal_location in varchar2 default hr_api.g_varchar2
1565: ,p_background_date_check in date default hr_api.g_date
1566: ,p_blood_type in varchar2 default hr_api.g_varchar2
1567: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1568: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1569: ,p_fte_capacity in number default hr_api.g_number
1570: ,p_hold_applicant_date_until in date default hr_api.g_date
1571: ,p_honors in varchar2 default hr_api.g_varchar2
1572: ,p_internal_location in varchar2 default hr_api.g_varchar2
1573: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1566: ,p_blood_type in varchar2 default hr_api.g_varchar2
1567: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1568: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1569: ,p_fte_capacity in number default hr_api.g_number
1570: ,p_hold_applicant_date_until in date default hr_api.g_date
1571: ,p_honors in varchar2 default hr_api.g_varchar2
1572: ,p_internal_location in varchar2 default hr_api.g_varchar2
1573: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1574: ,p_last_medical_test_date in date default hr_api.g_date
1567: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1568: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1569: ,p_fte_capacity in number default hr_api.g_number
1570: ,p_hold_applicant_date_until in date default hr_api.g_date
1571: ,p_honors in varchar2 default hr_api.g_varchar2
1572: ,p_internal_location in varchar2 default hr_api.g_varchar2
1573: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1574: ,p_last_medical_test_date in date default hr_api.g_date
1575: ,p_mailstop in varchar2 default hr_api.g_varchar2
1568: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1569: ,p_fte_capacity in number default hr_api.g_number
1570: ,p_hold_applicant_date_until in date default hr_api.g_date
1571: ,p_honors in varchar2 default hr_api.g_varchar2
1572: ,p_internal_location in varchar2 default hr_api.g_varchar2
1573: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1574: ,p_last_medical_test_date in date default hr_api.g_date
1575: ,p_mailstop in varchar2 default hr_api.g_varchar2
1576: ,p_office_number in varchar2 default hr_api.g_varchar2
1569: ,p_fte_capacity in number default hr_api.g_number
1570: ,p_hold_applicant_date_until in date default hr_api.g_date
1571: ,p_honors in varchar2 default hr_api.g_varchar2
1572: ,p_internal_location in varchar2 default hr_api.g_varchar2
1573: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1574: ,p_last_medical_test_date in date default hr_api.g_date
1575: ,p_mailstop in varchar2 default hr_api.g_varchar2
1576: ,p_office_number in varchar2 default hr_api.g_varchar2
1577: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1570: ,p_hold_applicant_date_until in date default hr_api.g_date
1571: ,p_honors in varchar2 default hr_api.g_varchar2
1572: ,p_internal_location in varchar2 default hr_api.g_varchar2
1573: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1574: ,p_last_medical_test_date in date default hr_api.g_date
1575: ,p_mailstop in varchar2 default hr_api.g_varchar2
1576: ,p_office_number in varchar2 default hr_api.g_varchar2
1577: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1578: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1571: ,p_honors in varchar2 default hr_api.g_varchar2
1572: ,p_internal_location in varchar2 default hr_api.g_varchar2
1573: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1574: ,p_last_medical_test_date in date default hr_api.g_date
1575: ,p_mailstop in varchar2 default hr_api.g_varchar2
1576: ,p_office_number in varchar2 default hr_api.g_varchar2
1577: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1578: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1579: ,p_projected_start_date in date default hr_api.g_date
1572: ,p_internal_location in varchar2 default hr_api.g_varchar2
1573: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1574: ,p_last_medical_test_date in date default hr_api.g_date
1575: ,p_mailstop in varchar2 default hr_api.g_varchar2
1576: ,p_office_number in varchar2 default hr_api.g_varchar2
1577: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1578: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1579: ,p_projected_start_date in date default hr_api.g_date
1580: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1573: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1574: ,p_last_medical_test_date in date default hr_api.g_date
1575: ,p_mailstop in varchar2 default hr_api.g_varchar2
1576: ,p_office_number in varchar2 default hr_api.g_varchar2
1577: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1578: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1579: ,p_projected_start_date in date default hr_api.g_date
1580: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1581: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1574: ,p_last_medical_test_date in date default hr_api.g_date
1575: ,p_mailstop in varchar2 default hr_api.g_varchar2
1576: ,p_office_number in varchar2 default hr_api.g_varchar2
1577: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1578: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1579: ,p_projected_start_date in date default hr_api.g_date
1580: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1581: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1582: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1575: ,p_mailstop in varchar2 default hr_api.g_varchar2
1576: ,p_office_number in varchar2 default hr_api.g_varchar2
1577: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1578: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1579: ,p_projected_start_date in date default hr_api.g_date
1580: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1581: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1582: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1583: ,p_resume_last_updated in date default hr_api.g_date
1576: ,p_office_number in varchar2 default hr_api.g_varchar2
1577: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1578: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1579: ,p_projected_start_date in date default hr_api.g_date
1580: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1581: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1582: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1583: ,p_resume_last_updated in date default hr_api.g_date
1584: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1577: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1578: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1579: ,p_projected_start_date in date default hr_api.g_date
1580: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1581: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1582: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1583: ,p_resume_last_updated in date default hr_api.g_date
1584: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1585: ,p_student_status in varchar2 default hr_api.g_varchar2
1578: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1579: ,p_projected_start_date in date default hr_api.g_date
1580: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1581: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1582: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1583: ,p_resume_last_updated in date default hr_api.g_date
1584: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1585: ,p_student_status in varchar2 default hr_api.g_varchar2
1586: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1579: ,p_projected_start_date in date default hr_api.g_date
1580: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1581: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1582: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1583: ,p_resume_last_updated in date default hr_api.g_date
1584: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1585: ,p_student_status in varchar2 default hr_api.g_varchar2
1586: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1587: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1580: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1581: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1582: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1583: ,p_resume_last_updated in date default hr_api.g_date
1584: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1585: ,p_student_status in varchar2 default hr_api.g_varchar2
1586: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1587: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1588: ,p_suffix in varchar2 default hr_api.g_varchar2
1581: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1582: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1583: ,p_resume_last_updated in date default hr_api.g_date
1584: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1585: ,p_student_status in varchar2 default hr_api.g_varchar2
1586: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1587: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1588: ,p_suffix in varchar2 default hr_api.g_varchar2
1589: ,p_benefit_group_id in number default hr_api.g_number
1582: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1583: ,p_resume_last_updated in date default hr_api.g_date
1584: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1585: ,p_student_status in varchar2 default hr_api.g_varchar2
1586: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1587: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1588: ,p_suffix in varchar2 default hr_api.g_varchar2
1589: ,p_benefit_group_id in number default hr_api.g_number
1590: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1583: ,p_resume_last_updated in date default hr_api.g_date
1584: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1585: ,p_student_status in varchar2 default hr_api.g_varchar2
1586: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1587: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1588: ,p_suffix in varchar2 default hr_api.g_varchar2
1589: ,p_benefit_group_id in number default hr_api.g_number
1590: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1591: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1584: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1585: ,p_student_status in varchar2 default hr_api.g_varchar2
1586: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1587: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1588: ,p_suffix in varchar2 default hr_api.g_varchar2
1589: ,p_benefit_group_id in number default hr_api.g_number
1590: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1591: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1585: ,p_student_status in varchar2 default hr_api.g_varchar2
1586: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1587: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1588: ,p_suffix in varchar2 default hr_api.g_varchar2
1589: ,p_benefit_group_id in number default hr_api.g_number
1590: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1591: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1593: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1586: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1587: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1588: ,p_suffix in varchar2 default hr_api.g_varchar2
1589: ,p_benefit_group_id in number default hr_api.g_number
1590: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1591: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1593: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1594: ,p_dpdnt_adoption_date in date default hr_api.g_date
1587: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1588: ,p_suffix in varchar2 default hr_api.g_varchar2
1589: ,p_benefit_group_id in number default hr_api.g_number
1590: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1591: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1593: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1594: ,p_dpdnt_adoption_date in date default hr_api.g_date
1595: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1588: ,p_suffix in varchar2 default hr_api.g_varchar2
1589: ,p_benefit_group_id in number default hr_api.g_number
1590: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1591: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1593: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1594: ,p_dpdnt_adoption_date in date default hr_api.g_date
1595: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1596: ,p_original_date_of_hire in date default hr_api.g_date
1589: ,p_benefit_group_id in number default hr_api.g_number
1590: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1591: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1593: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1594: ,p_dpdnt_adoption_date in date default hr_api.g_date
1595: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1596: ,p_original_date_of_hire in date default hr_api.g_date
1597: ,p_adjusted_svc_date in date default hr_api.g_date
1590: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1591: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1593: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1594: ,p_dpdnt_adoption_date in date default hr_api.g_date
1595: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1596: ,p_original_date_of_hire in date default hr_api.g_date
1597: ,p_adjusted_svc_date in date default hr_api.g_date
1598: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1591: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1593: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1594: ,p_dpdnt_adoption_date in date default hr_api.g_date
1595: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1596: ,p_original_date_of_hire in date default hr_api.g_date
1597: ,p_adjusted_svc_date in date default hr_api.g_date
1598: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1599: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1593: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1594: ,p_dpdnt_adoption_date in date default hr_api.g_date
1595: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1596: ,p_original_date_of_hire in date default hr_api.g_date
1597: ,p_adjusted_svc_date in date default hr_api.g_date
1598: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1599: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1600: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1593: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1594: ,p_dpdnt_adoption_date in date default hr_api.g_date
1595: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1596: ,p_original_date_of_hire in date default hr_api.g_date
1597: ,p_adjusted_svc_date in date default hr_api.g_date
1598: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1599: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1600: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1594: ,p_dpdnt_adoption_date in date default hr_api.g_date
1595: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1596: ,p_original_date_of_hire in date default hr_api.g_date
1597: ,p_adjusted_svc_date in date default hr_api.g_date
1598: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1599: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1600: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1602: ,p_business_group_id in number default hr_api.g_number
1595: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1596: ,p_original_date_of_hire in date default hr_api.g_date
1597: ,p_adjusted_svc_date in date default hr_api.g_date
1598: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1599: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1600: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1602: ,p_business_group_id in number default hr_api.g_number
1603: ,p_contact_operation in varchar2 default hr_api.g_varchar2
1596: ,p_original_date_of_hire in date default hr_api.g_date
1597: ,p_adjusted_svc_date in date default hr_api.g_date
1598: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1599: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1600: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1602: ,p_business_group_id in number default hr_api.g_number
1603: ,p_contact_operation in varchar2 default hr_api.g_varchar2
1604: ,p_emrg_cont_flag in varchar2 default hr_api.g_varchar2
1597: ,p_adjusted_svc_date in date default hr_api.g_date
1598: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1599: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1600: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1602: ,p_business_group_id in number default hr_api.g_number
1603: ,p_contact_operation in varchar2 default hr_api.g_varchar2
1604: ,p_emrg_cont_flag in varchar2 default hr_api.g_varchar2
1605: ,p_dpdnt_bnf_flag in varchar2 default hr_api.g_varchar2
1598: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1599: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1600: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1602: ,p_business_group_id in number default hr_api.g_number
1603: ,p_contact_operation in varchar2 default hr_api.g_varchar2
1604: ,p_emrg_cont_flag in varchar2 default hr_api.g_varchar2
1605: ,p_dpdnt_bnf_flag in varchar2 default hr_api.g_varchar2
1606: ,p_save_mode in varchar2 default null
1599: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1600: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1602: ,p_business_group_id in number default hr_api.g_number
1603: ,p_contact_operation in varchar2 default hr_api.g_varchar2
1604: ,p_emrg_cont_flag in varchar2 default hr_api.g_varchar2
1605: ,p_dpdnt_bnf_flag in varchar2 default hr_api.g_varchar2
1606: ,p_save_mode in varchar2 default null
1607: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
1600: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1602: ,p_business_group_id in number default hr_api.g_number
1603: ,p_contact_operation in varchar2 default hr_api.g_varchar2
1604: ,p_emrg_cont_flag in varchar2 default hr_api.g_varchar2
1605: ,p_dpdnt_bnf_flag in varchar2 default hr_api.g_varchar2
1606: ,p_save_mode in varchar2 default null
1607: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
1608: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
1601: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1602: ,p_business_group_id in number default hr_api.g_number
1603: ,p_contact_operation in varchar2 default hr_api.g_varchar2
1604: ,p_emrg_cont_flag in varchar2 default hr_api.g_varchar2
1605: ,p_dpdnt_bnf_flag in varchar2 default hr_api.g_varchar2
1606: ,p_save_mode in varchar2 default null
1607: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
1608: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
1609: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
1603: ,p_contact_operation in varchar2 default hr_api.g_varchar2
1604: ,p_emrg_cont_flag in varchar2 default hr_api.g_varchar2
1605: ,p_dpdnt_bnf_flag in varchar2 default hr_api.g_varchar2
1606: ,p_save_mode in varchar2 default null
1607: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
1608: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
1609: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
1610: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
1611: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
1604: ,p_emrg_cont_flag in varchar2 default hr_api.g_varchar2
1605: ,p_dpdnt_bnf_flag in varchar2 default hr_api.g_varchar2
1606: ,p_save_mode in varchar2 default null
1607: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
1608: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
1609: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
1610: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
1611: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
1612: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
1605: ,p_dpdnt_bnf_flag in varchar2 default hr_api.g_varchar2
1606: ,p_save_mode in varchar2 default null
1607: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
1608: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
1609: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
1610: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
1611: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
1612: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
1613: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
1606: ,p_save_mode in varchar2 default null
1607: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
1608: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
1609: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
1610: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
1611: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
1612: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
1613: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
1614: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
1607: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
1608: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
1609: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
1610: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
1611: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
1612: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
1613: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
1614: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
1615: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
1608: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
1609: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
1610: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
1611: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
1612: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
1613: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
1614: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
1615: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
1616: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
1609: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
1610: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
1611: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
1612: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
1613: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
1614: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
1615: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
1616: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
1617: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
1610: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
1611: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
1612: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
1613: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
1614: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
1615: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
1616: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
1617: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
1618: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
1611: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
1612: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
1613: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
1614: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
1615: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
1616: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
1617: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
1618: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
1619: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
1612: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
1613: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
1614: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
1615: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
1616: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
1617: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
1618: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
1619: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
1620: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
1613: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
1614: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
1615: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
1616: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
1617: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
1618: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
1619: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
1620: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
1621: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
1614: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
1615: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
1616: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
1617: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
1618: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
1619: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
1620: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
1621: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
1622: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
1615: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
1616: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
1617: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
1618: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
1619: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
1620: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
1621: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
1622: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
1623: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
1616: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
1617: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
1618: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
1619: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
1620: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
1621: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
1622: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
1623: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
1624: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
1617: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
1618: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
1619: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
1620: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
1621: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
1622: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
1623: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
1624: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
1625: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
1618: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
1619: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
1620: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
1621: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
1622: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
1623: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
1624: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
1625: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
1626: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
1619: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
1620: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
1621: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
1622: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
1623: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
1624: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
1625: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
1626: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
1627: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
1620: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
1621: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
1622: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
1623: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
1624: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
1625: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
1626: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
1627: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
1628: ,p_effective_start_date out nocopy date
1621: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
1622: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
1623: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
1624: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
1625: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
1626: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
1627: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
1628: ,p_effective_start_date out nocopy date
1629: ,p_effective_end_date out nocopy date
1622: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
1623: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
1624: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
1625: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
1626: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
1627: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
1628: ,p_effective_start_date out nocopy date
1629: ,p_effective_end_date out nocopy date
1630: ,p_full_name out nocopy varchar2
1623: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
1624: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
1625: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
1626: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
1627: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
1628: ,p_effective_start_date out nocopy date
1629: ,p_effective_end_date out nocopy date
1630: ,p_full_name out nocopy varchar2
1631: ,p_comment_id out nocopy number
1650: and trunc(sysdate) < decode(date_end,null,trunc(sysdate)+1,trunc(date_end)) ;
1651: -- and primary_contact_flag = 'Y';
1652: --
1653: l_transaction_table hr_transaction_ss.transaction_table;
1654: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1655: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
1656: l_cont_old_ovn number ;
1657: l_per_old_ovn number;
1658: l_old_contact_relationship_id number;
1651: -- and primary_contact_flag = 'Y';
1652: --
1653: l_transaction_table hr_transaction_ss.transaction_table;
1654: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
1655: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
1656: l_cont_old_ovn number ;
1657: l_per_old_ovn number;
1658: l_old_contact_relationship_id number;
1659: l_employee_number per_all_people_f.employee_number%type ;
3911: -- ---------------------------------------------------------------------------
3912: FUNCTION is_rec_changed (
3913: p_effective_date in date
3914: ,p_contact_relationship_id in number
3915: ,p_contact_type in varchar2 default hr_api.g_varchar2
3916: ,p_comments in long default hr_api.g_varchar2
3917: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
3918: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
3919: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
3912: FUNCTION is_rec_changed (
3913: p_effective_date in date
3914: ,p_contact_relationship_id in number
3915: ,p_contact_type in varchar2 default hr_api.g_varchar2
3916: ,p_comments in long default hr_api.g_varchar2
3917: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
3918: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
3919: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
3920: ,p_date_start in date default hr_api.g_date
3913: p_effective_date in date
3914: ,p_contact_relationship_id in number
3915: ,p_contact_type in varchar2 default hr_api.g_varchar2
3916: ,p_comments in long default hr_api.g_varchar2
3917: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
3918: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
3919: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
3920: ,p_date_start in date default hr_api.g_date
3921: ,p_start_life_reason_id in number default hr_api.g_number
3914: ,p_contact_relationship_id in number
3915: ,p_contact_type in varchar2 default hr_api.g_varchar2
3916: ,p_comments in long default hr_api.g_varchar2
3917: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
3918: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
3919: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
3920: ,p_date_start in date default hr_api.g_date
3921: ,p_start_life_reason_id in number default hr_api.g_number
3922: ,p_date_end in date default hr_api.g_date
3915: ,p_contact_type in varchar2 default hr_api.g_varchar2
3916: ,p_comments in long default hr_api.g_varchar2
3917: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
3918: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
3919: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
3920: ,p_date_start in date default hr_api.g_date
3921: ,p_start_life_reason_id in number default hr_api.g_number
3922: ,p_date_end in date default hr_api.g_date
3923: ,p_end_life_reason_id in number default hr_api.g_number
3916: ,p_comments in long default hr_api.g_varchar2
3917: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
3918: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
3919: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
3920: ,p_date_start in date default hr_api.g_date
3921: ,p_start_life_reason_id in number default hr_api.g_number
3922: ,p_date_end in date default hr_api.g_date
3923: ,p_end_life_reason_id in number default hr_api.g_number
3924: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
3917: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
3918: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
3919: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
3920: ,p_date_start in date default hr_api.g_date
3921: ,p_start_life_reason_id in number default hr_api.g_number
3922: ,p_date_end in date default hr_api.g_date
3923: ,p_end_life_reason_id in number default hr_api.g_number
3924: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
3925: ,p_personal_flag in varchar2 default hr_api.g_varchar2
3918: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
3919: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
3920: ,p_date_start in date default hr_api.g_date
3921: ,p_start_life_reason_id in number default hr_api.g_number
3922: ,p_date_end in date default hr_api.g_date
3923: ,p_end_life_reason_id in number default hr_api.g_number
3924: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
3925: ,p_personal_flag in varchar2 default hr_api.g_varchar2
3926: ,p_sequence_number in number default hr_api.g_number
3919: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
3920: ,p_date_start in date default hr_api.g_date
3921: ,p_start_life_reason_id in number default hr_api.g_number
3922: ,p_date_end in date default hr_api.g_date
3923: ,p_end_life_reason_id in number default hr_api.g_number
3924: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
3925: ,p_personal_flag in varchar2 default hr_api.g_varchar2
3926: ,p_sequence_number in number default hr_api.g_number
3927: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
3920: ,p_date_start in date default hr_api.g_date
3921: ,p_start_life_reason_id in number default hr_api.g_number
3922: ,p_date_end in date default hr_api.g_date
3923: ,p_end_life_reason_id in number default hr_api.g_number
3924: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
3925: ,p_personal_flag in varchar2 default hr_api.g_varchar2
3926: ,p_sequence_number in number default hr_api.g_number
3927: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
3928: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
3921: ,p_start_life_reason_id in number default hr_api.g_number
3922: ,p_date_end in date default hr_api.g_date
3923: ,p_end_life_reason_id in number default hr_api.g_number
3924: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
3925: ,p_personal_flag in varchar2 default hr_api.g_varchar2
3926: ,p_sequence_number in number default hr_api.g_number
3927: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
3928: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
3929: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
3922: ,p_date_end in date default hr_api.g_date
3923: ,p_end_life_reason_id in number default hr_api.g_number
3924: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
3925: ,p_personal_flag in varchar2 default hr_api.g_varchar2
3926: ,p_sequence_number in number default hr_api.g_number
3927: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
3928: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
3929: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
3930: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
3923: ,p_end_life_reason_id in number default hr_api.g_number
3924: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
3925: ,p_personal_flag in varchar2 default hr_api.g_varchar2
3926: ,p_sequence_number in number default hr_api.g_number
3927: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
3928: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
3929: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
3930: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
3931: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
3924: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
3925: ,p_personal_flag in varchar2 default hr_api.g_varchar2
3926: ,p_sequence_number in number default hr_api.g_number
3927: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
3928: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
3929: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
3930: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
3931: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
3932: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
3925: ,p_personal_flag in varchar2 default hr_api.g_varchar2
3926: ,p_sequence_number in number default hr_api.g_number
3927: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
3928: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
3929: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
3930: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
3931: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
3932: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
3933: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
3926: ,p_sequence_number in number default hr_api.g_number
3927: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
3928: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
3929: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
3930: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
3931: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
3932: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
3933: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
3934: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
3927: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
3928: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
3929: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
3930: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
3931: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
3932: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
3933: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
3934: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
3935: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
3928: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
3929: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
3930: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
3931: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
3932: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
3933: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
3934: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
3935: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
3936: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
3929: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
3930: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
3931: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
3932: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
3933: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
3934: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
3935: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
3936: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
3937: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
3930: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
3931: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
3932: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
3933: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
3934: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
3935: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
3936: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
3937: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
3938: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
3931: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
3932: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
3933: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
3934: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
3935: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
3936: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
3937: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
3938: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
3939: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
3932: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
3933: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
3934: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
3935: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
3936: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
3937: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
3938: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
3939: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
3940: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
3933: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
3934: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
3935: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
3936: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
3937: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
3938: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
3939: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
3940: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
3941: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
3934: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
3935: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
3936: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
3937: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
3938: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
3939: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
3940: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
3941: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
3942: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
3935: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
3936: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
3937: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
3938: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
3939: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
3940: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
3941: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
3942: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
3943: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
3936: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
3937: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
3938: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
3939: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
3940: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
3941: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
3942: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
3943: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
3944: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
3937: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
3938: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
3939: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
3940: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
3941: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
3942: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
3943: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
3944: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
3945: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
3938: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
3939: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
3940: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
3941: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
3942: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
3943: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
3944: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
3945: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
3946: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
3939: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
3940: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
3941: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
3942: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
3943: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
3944: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
3945: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
3946: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
3947: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
3940: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
3941: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
3942: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
3943: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
3944: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
3945: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
3946: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
3947: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
3948: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
3941: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
3942: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
3943: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
3944: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
3945: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
3946: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
3947: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
3948: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
3949: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
3942: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
3943: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
3944: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
3945: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
3946: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
3947: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
3948: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
3949: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
3950: -- Added new params
3943: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
3944: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
3945: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
3946: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
3947: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
3948: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
3949: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
3950: -- Added new params
3951: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
3944: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
3945: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
3946: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
3947: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
3948: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
3949: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
3950: -- Added new params
3951: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
3952: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
3945: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
3946: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
3947: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
3948: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
3949: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
3950: -- Added new params
3951: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
3952: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
3953: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
3947: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
3948: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
3949: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
3950: -- Added new params
3951: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
3952: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
3953: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
3954: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
3955: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
3948: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
3949: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
3950: -- Added new params
3951: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
3952: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
3953: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
3954: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
3955: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
3956: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
3949: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
3950: -- Added new params
3951: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
3952: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
3953: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
3954: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
3955: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
3956: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
3957: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
3950: -- Added new params
3951: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
3952: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
3953: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
3954: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
3955: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
3956: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
3957: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
3958: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
3951: ,P_CONT_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
3952: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
3953: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
3954: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
3955: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
3956: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
3957: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
3958: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
3959: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
3952: ,P_CONT_INFORMATION1 in varchar2 default hr_api.g_varchar2
3953: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
3954: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
3955: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
3956: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
3957: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
3958: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
3959: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
3960: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
3953: ,P_CONT_INFORMATION2 in varchar2 default hr_api.g_varchar2
3954: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
3955: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
3956: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
3957: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
3958: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
3959: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
3960: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
3961: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
3954: ,P_CONT_INFORMATION3 in varchar2 default hr_api.g_varchar2
3955: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
3956: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
3957: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
3958: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
3959: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
3960: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
3961: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
3962: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
3955: ,P_CONT_INFORMATION4 in varchar2 default hr_api.g_varchar2
3956: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
3957: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
3958: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
3959: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
3960: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
3961: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
3962: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
3963: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
3956: ,P_CONT_INFORMATION5 in varchar2 default hr_api.g_varchar2
3957: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
3958: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
3959: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
3960: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
3961: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
3962: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
3963: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
3964: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
3957: ,P_CONT_INFORMATION6 in varchar2 default hr_api.g_varchar2
3958: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
3959: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
3960: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
3961: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
3962: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
3963: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
3964: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
3965: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
3958: ,P_CONT_INFORMATION7 in varchar2 default hr_api.g_varchar2
3959: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
3960: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
3961: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
3962: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
3963: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
3964: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
3965: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
3966: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
3959: ,P_CONT_INFORMATION8 in varchar2 default hr_api.g_varchar2
3960: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
3961: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
3962: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
3963: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
3964: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
3965: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
3966: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
3967: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
3960: ,P_CONT_INFORMATION9 in varchar2 default hr_api.g_varchar2
3961: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
3962: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
3963: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
3964: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
3965: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
3966: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
3967: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
3968: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
3961: ,P_CONT_INFORMATION10 in varchar2 default hr_api.g_varchar2
3962: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
3963: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
3964: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
3965: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
3966: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
3967: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
3968: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
3969: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
3962: ,P_CONT_INFORMATION11 in varchar2 default hr_api.g_varchar2
3963: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
3964: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
3965: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
3966: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
3967: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
3968: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
3969: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
3970: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
3963: ,P_CONT_INFORMATION12 in varchar2 default hr_api.g_varchar2
3964: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
3965: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
3966: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
3967: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
3968: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
3969: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
3970: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
3971: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
3964: ,P_CONT_INFORMATION13 in varchar2 default hr_api.g_varchar2
3965: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
3966: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
3967: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
3968: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
3969: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
3970: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
3971: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
3972: ,p_object_version_number in number )
3965: ,P_CONT_INFORMATION14 in varchar2 default hr_api.g_varchar2
3966: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
3967: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
3968: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
3969: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
3970: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
3971: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
3972: ,p_object_version_number in number )
3973: return boolean is
3966: ,P_CONT_INFORMATION15 in varchar2 default hr_api.g_varchar2
3967: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
3968: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
3969: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
3970: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
3971: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
3972: ,p_object_version_number in number )
3973: return boolean is
3974: --
3967: ,P_CONT_INFORMATION16 in varchar2 default hr_api.g_varchar2
3968: ,P_CONT_INFORMATION17 in varchar2 default hr_api.g_varchar2
3969: ,P_CONT_INFORMATION18 in varchar2 default hr_api.g_varchar2
3970: ,P_CONT_INFORMATION19 in varchar2 default hr_api.g_varchar2
3971: ,P_CONT_INFORMATION20 in varchar2 default hr_api.g_varchar2
3972: ,p_object_version_number in number )
3973: return boolean is
3974: --
3975: l_rec_changed boolean default null;
3995: END IF;
3996: --2480916 fix ends
3997: --
3998: ------------------------------------------------------------------------------
3999: -- NOTE: We need to use nvl(xxx attribute name, hr_api.g_xxxx) because the
4000: -- parameter coming in can be null. If we do not use nvl, then it will
4001: -- never be equal to the database null value if the parameter value is
4002: -- also null.
4003: ------------------------------------------------------------------------------
4002: -- also null.
4003: ------------------------------------------------------------------------------
4004:
4005: --
4006: IF p_contact_type <> hr_api.g_varchar2
4007: THEN
4008: --
4009: IF nvl(p_contact_type, hr_api.g_varchar2) <>
4010: nvl(l_cur_contact_data.contact_type, hr_api.g_varchar2)
4005: --
4006: IF p_contact_type <> hr_api.g_varchar2
4007: THEN
4008: --
4009: IF nvl(p_contact_type, hr_api.g_varchar2) <>
4010: nvl(l_cur_contact_data.contact_type, hr_api.g_varchar2)
4011: THEN
4012: l_rec_changed := TRUE;
4013: goto finish;
4006: IF p_contact_type <> hr_api.g_varchar2
4007: THEN
4008: --
4009: IF nvl(p_contact_type, hr_api.g_varchar2) <>
4010: nvl(l_cur_contact_data.contact_type, hr_api.g_varchar2)
4011: THEN
4012: l_rec_changed := TRUE;
4013: goto finish;
4014: END IF;
4015: --
4016: END IF;
4017: --
4018: --
4019: IF p_comments <> hr_api.g_varchar2
4020: THEN
4021: --
4022: IF nvl(p_comments, hr_api.g_varchar2) <>
4023: nvl(l_cur_contact_data.comments, hr_api.g_varchar2)
4018: --
4019: IF p_comments <> hr_api.g_varchar2
4020: THEN
4021: --
4022: IF nvl(p_comments, hr_api.g_varchar2) <>
4023: nvl(l_cur_contact_data.comments, hr_api.g_varchar2)
4024: THEN
4025: l_rec_changed := TRUE;
4026: goto finish;
4019: IF p_comments <> hr_api.g_varchar2
4020: THEN
4021: --
4022: IF nvl(p_comments, hr_api.g_varchar2) <>
4023: nvl(l_cur_contact_data.comments, hr_api.g_varchar2)
4024: THEN
4025: l_rec_changed := TRUE;
4026: goto finish;
4027: END IF;
4028: --
4029: END IF;
4030: --
4031: --
4032: IF p_primary_contact_flag <> hr_api.g_varchar2
4033: THEN
4034: --
4035: IF nvl(p_primary_contact_flag, hr_api.g_varchar2) <>
4036: nvl(l_cur_contact_data.primary_contact_flag, hr_api.g_varchar2)
4031: --
4032: IF p_primary_contact_flag <> hr_api.g_varchar2
4033: THEN
4034: --
4035: IF nvl(p_primary_contact_flag, hr_api.g_varchar2) <>
4036: nvl(l_cur_contact_data.primary_contact_flag, hr_api.g_varchar2)
4037: THEN
4038: l_rec_changed := TRUE;
4039: goto finish;
4032: IF p_primary_contact_flag <> hr_api.g_varchar2
4033: THEN
4034: --
4035: IF nvl(p_primary_contact_flag, hr_api.g_varchar2) <>
4036: nvl(l_cur_contact_data.primary_contact_flag, hr_api.g_varchar2)
4037: THEN
4038: l_rec_changed := TRUE;
4039: goto finish;
4040: END IF;
4041: --
4042: END IF;
4043: --
4044: --
4045: IF p_third_party_pay_flag <> hr_api.g_varchar2
4046: THEN
4047: --
4048: IF nvl(p_third_party_pay_flag, hr_api.g_varchar2) <>
4049: nvl(l_cur_contact_data.third_party_pay_flag, hr_api.g_varchar2)
4044: --
4045: IF p_third_party_pay_flag <> hr_api.g_varchar2
4046: THEN
4047: --
4048: IF nvl(p_third_party_pay_flag, hr_api.g_varchar2) <>
4049: nvl(l_cur_contact_data.third_party_pay_flag, hr_api.g_varchar2)
4050: THEN
4051: l_rec_changed := TRUE;
4052: goto finish;
4045: IF p_third_party_pay_flag <> hr_api.g_varchar2
4046: THEN
4047: --
4048: IF nvl(p_third_party_pay_flag, hr_api.g_varchar2) <>
4049: nvl(l_cur_contact_data.third_party_pay_flag, hr_api.g_varchar2)
4050: THEN
4051: l_rec_changed := TRUE;
4052: goto finish;
4053: END IF;
4054: --
4055: END IF;
4056: --
4057: --
4058: IF p_bondholder_flag <> hr_api.g_varchar2
4059: THEN
4060: --
4061: IF nvl(p_bondholder_flag, hr_api.g_varchar2) <>
4062: nvl(l_cur_contact_data.bondholder_flag, hr_api.g_varchar2)
4057: --
4058: IF p_bondholder_flag <> hr_api.g_varchar2
4059: THEN
4060: --
4061: IF nvl(p_bondholder_flag, hr_api.g_varchar2) <>
4062: nvl(l_cur_contact_data.bondholder_flag, hr_api.g_varchar2)
4063: THEN
4064: l_rec_changed := TRUE;
4065: goto finish;
4058: IF p_bondholder_flag <> hr_api.g_varchar2
4059: THEN
4060: --
4061: IF nvl(p_bondholder_flag, hr_api.g_varchar2) <>
4062: nvl(l_cur_contact_data.bondholder_flag, hr_api.g_varchar2)
4063: THEN
4064: l_rec_changed := TRUE;
4065: goto finish;
4066: END IF;
4067: --
4068: END IF;
4069: --
4070: --
4071: IF p_date_start <> hr_api.g_date
4072: THEN
4073: --
4074: IF nvl(p_date_start, hr_api.g_date) <>
4075: nvl(l_cur_contact_data.date_start, hr_api.g_date)
4070: --
4071: IF p_date_start <> hr_api.g_date
4072: THEN
4073: --
4074: IF nvl(p_date_start, hr_api.g_date) <>
4075: nvl(l_cur_contact_data.date_start, hr_api.g_date)
4076: THEN
4077: l_rec_changed := TRUE;
4078: goto finish;
4071: IF p_date_start <> hr_api.g_date
4072: THEN
4073: --
4074: IF nvl(p_date_start, hr_api.g_date) <>
4075: nvl(l_cur_contact_data.date_start, hr_api.g_date)
4076: THEN
4077: l_rec_changed := TRUE;
4078: goto finish;
4079: END IF;
4080: --
4081: END IF;
4082: --
4083: --
4084: IF p_start_life_reason_id <> hr_api.g_number
4085: THEN
4086: --
4087: IF nvl(p_start_life_reason_id, hr_api.g_number) <>
4088: nvl(l_cur_contact_data.start_life_reason_id, hr_api.g_number)
4083: --
4084: IF p_start_life_reason_id <> hr_api.g_number
4085: THEN
4086: --
4087: IF nvl(p_start_life_reason_id, hr_api.g_number) <>
4088: nvl(l_cur_contact_data.start_life_reason_id, hr_api.g_number)
4089: THEN
4090: l_rec_changed := TRUE;
4091: goto finish;
4084: IF p_start_life_reason_id <> hr_api.g_number
4085: THEN
4086: --
4087: IF nvl(p_start_life_reason_id, hr_api.g_number) <>
4088: nvl(l_cur_contact_data.start_life_reason_id, hr_api.g_number)
4089: THEN
4090: l_rec_changed := TRUE;
4091: goto finish;
4092: END IF;
4093: --
4094: END IF;
4095: --
4096: --
4097: IF p_date_end <> hr_api.g_date
4098: THEN
4099: --
4100: IF nvl(p_date_end, hr_api.g_date) <>
4101: nvl(l_cur_contact_data.date_end, hr_api.g_date)
4096: --
4097: IF p_date_end <> hr_api.g_date
4098: THEN
4099: --
4100: IF nvl(p_date_end, hr_api.g_date) <>
4101: nvl(l_cur_contact_data.date_end, hr_api.g_date)
4102: THEN
4103: l_rec_changed := TRUE;
4104: goto finish;
4097: IF p_date_end <> hr_api.g_date
4098: THEN
4099: --
4100: IF nvl(p_date_end, hr_api.g_date) <>
4101: nvl(l_cur_contact_data.date_end, hr_api.g_date)
4102: THEN
4103: l_rec_changed := TRUE;
4104: goto finish;
4105: END IF;
4106: --
4107: END IF;
4108: --
4109: --
4110: IF p_end_life_reason_id <> hr_api.g_number
4111: THEN
4112: --
4113: IF nvl(p_end_life_reason_id, hr_api.g_number) <>
4114: nvl(l_cur_contact_data.end_life_reason_id, hr_api.g_number)
4109: --
4110: IF p_end_life_reason_id <> hr_api.g_number
4111: THEN
4112: --
4113: IF nvl(p_end_life_reason_id, hr_api.g_number) <>
4114: nvl(l_cur_contact_data.end_life_reason_id, hr_api.g_number)
4115: THEN
4116: l_rec_changed := TRUE;
4117: goto finish;
4110: IF p_end_life_reason_id <> hr_api.g_number
4111: THEN
4112: --
4113: IF nvl(p_end_life_reason_id, hr_api.g_number) <>
4114: nvl(l_cur_contact_data.end_life_reason_id, hr_api.g_number)
4115: THEN
4116: l_rec_changed := TRUE;
4117: goto finish;
4118: END IF;
4119: --
4120: END IF;
4121: --
4122: --
4123: IF p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
4124: THEN
4125: --
4126: IF nvl(p_rltd_per_rsds_w_dsgntr_flag, hr_api.g_varchar2) <>
4127: nvl(l_cur_contact_data.rltd_per_rsds_w_dsgntr_flag, hr_api.g_varchar2)
4122: --
4123: IF p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
4124: THEN
4125: --
4126: IF nvl(p_rltd_per_rsds_w_dsgntr_flag, hr_api.g_varchar2) <>
4127: nvl(l_cur_contact_data.rltd_per_rsds_w_dsgntr_flag, hr_api.g_varchar2)
4128: THEN
4129: l_rec_changed := TRUE;
4130: goto finish;
4123: IF p_rltd_per_rsds_w_dsgntr_flag <> hr_api.g_varchar2
4124: THEN
4125: --
4126: IF nvl(p_rltd_per_rsds_w_dsgntr_flag, hr_api.g_varchar2) <>
4127: nvl(l_cur_contact_data.rltd_per_rsds_w_dsgntr_flag, hr_api.g_varchar2)
4128: THEN
4129: l_rec_changed := TRUE;
4130: goto finish;
4131: END IF;
4132: --
4133: END IF;
4134: --
4135: --
4136: IF p_personal_flag <> hr_api.g_varchar2
4137: THEN
4138: --
4139: IF nvl(p_personal_flag, hr_api.g_varchar2) <>
4140: nvl(l_cur_contact_data.personal_flag, hr_api.g_varchar2)
4135: --
4136: IF p_personal_flag <> hr_api.g_varchar2
4137: THEN
4138: --
4139: IF nvl(p_personal_flag, hr_api.g_varchar2) <>
4140: nvl(l_cur_contact_data.personal_flag, hr_api.g_varchar2)
4141: THEN
4142: l_rec_changed := TRUE;
4143: goto finish;
4136: IF p_personal_flag <> hr_api.g_varchar2
4137: THEN
4138: --
4139: IF nvl(p_personal_flag, hr_api.g_varchar2) <>
4140: nvl(l_cur_contact_data.personal_flag, hr_api.g_varchar2)
4141: THEN
4142: l_rec_changed := TRUE;
4143: goto finish;
4144: END IF;
4145: --
4146: END IF;
4147: --
4148: --
4149: IF p_sequence_number <> hr_api.g_number
4150: THEN
4151: --
4152: IF nvl(p_sequence_number, hr_api.g_number) <>
4153: nvl(l_cur_contact_data.sequence_number, hr_api.g_number)
4148: --
4149: IF p_sequence_number <> hr_api.g_number
4150: THEN
4151: --
4152: IF nvl(p_sequence_number, hr_api.g_number) <>
4153: nvl(l_cur_contact_data.sequence_number, hr_api.g_number)
4154: THEN
4155: l_rec_changed := TRUE;
4156: goto finish;
4149: IF p_sequence_number <> hr_api.g_number
4150: THEN
4151: --
4152: IF nvl(p_sequence_number, hr_api.g_number) <>
4153: nvl(l_cur_contact_data.sequence_number, hr_api.g_number)
4154: THEN
4155: l_rec_changed := TRUE;
4156: goto finish;
4157: END IF;
4158: --
4159: END IF;
4160: --
4161: --
4162: IF p_dependent_flag <> hr_api.g_varchar2
4163: THEN
4164: --
4165: IF nvl(p_dependent_flag, hr_api.g_varchar2) <>
4166: nvl(l_cur_contact_data.dependent_flag, hr_api.g_varchar2)
4161: --
4162: IF p_dependent_flag <> hr_api.g_varchar2
4163: THEN
4164: --
4165: IF nvl(p_dependent_flag, hr_api.g_varchar2) <>
4166: nvl(l_cur_contact_data.dependent_flag, hr_api.g_varchar2)
4167: THEN
4168: l_rec_changed := TRUE;
4169: goto finish;
4162: IF p_dependent_flag <> hr_api.g_varchar2
4163: THEN
4164: --
4165: IF nvl(p_dependent_flag, hr_api.g_varchar2) <>
4166: nvl(l_cur_contact_data.dependent_flag, hr_api.g_varchar2)
4167: THEN
4168: l_rec_changed := TRUE;
4169: goto finish;
4170: END IF;
4171: --
4172: END IF;
4173: --
4174: --
4175: IF p_beneficiary_flag <> hr_api.g_varchar2
4176: THEN
4177: --
4178: IF nvl(p_beneficiary_flag, hr_api.g_varchar2) <>
4179: nvl(l_cur_contact_data.beneficiary_flag, hr_api.g_varchar2)
4174: --
4175: IF p_beneficiary_flag <> hr_api.g_varchar2
4176: THEN
4177: --
4178: IF nvl(p_beneficiary_flag, hr_api.g_varchar2) <>
4179: nvl(l_cur_contact_data.beneficiary_flag, hr_api.g_varchar2)
4180: THEN
4181: l_rec_changed := TRUE;
4182: goto finish;
4175: IF p_beneficiary_flag <> hr_api.g_varchar2
4176: THEN
4177: --
4178: IF nvl(p_beneficiary_flag, hr_api.g_varchar2) <>
4179: nvl(l_cur_contact_data.beneficiary_flag, hr_api.g_varchar2)
4180: THEN
4181: l_rec_changed := TRUE;
4182: goto finish;
4183: END IF;
4184: --
4185: END IF;
4186: --
4187: --
4188: IF p_cont_attribute_category <> hr_api.g_varchar2
4189: THEN
4190: --
4191: IF nvl(p_cont_attribute_category, hr_api.g_varchar2) <>
4192: nvl(l_cur_contact_data.cont_attribute_category, hr_api.g_varchar2)
4187: --
4188: IF p_cont_attribute_category <> hr_api.g_varchar2
4189: THEN
4190: --
4191: IF nvl(p_cont_attribute_category, hr_api.g_varchar2) <>
4192: nvl(l_cur_contact_data.cont_attribute_category, hr_api.g_varchar2)
4193: THEN
4194: l_rec_changed := TRUE;
4195: goto finish;
4188: IF p_cont_attribute_category <> hr_api.g_varchar2
4189: THEN
4190: --
4191: IF nvl(p_cont_attribute_category, hr_api.g_varchar2) <>
4192: nvl(l_cur_contact_data.cont_attribute_category, hr_api.g_varchar2)
4193: THEN
4194: l_rec_changed := TRUE;
4195: goto finish;
4196: END IF;
4197: --
4198: END IF;
4199: --
4200: --
4201: IF p_cont_attribute1 <> hr_api.g_varchar2
4202: THEN
4203: --
4204: IF nvl(p_cont_attribute1, hr_api.g_varchar2) <>
4205: nvl(l_cur_contact_data.cont_attribute1, hr_api.g_varchar2)
4200: --
4201: IF p_cont_attribute1 <> hr_api.g_varchar2
4202: THEN
4203: --
4204: IF nvl(p_cont_attribute1, hr_api.g_varchar2) <>
4205: nvl(l_cur_contact_data.cont_attribute1, hr_api.g_varchar2)
4206: THEN
4207: l_rec_changed := TRUE;
4208: goto finish;
4201: IF p_cont_attribute1 <> hr_api.g_varchar2
4202: THEN
4203: --
4204: IF nvl(p_cont_attribute1, hr_api.g_varchar2) <>
4205: nvl(l_cur_contact_data.cont_attribute1, hr_api.g_varchar2)
4206: THEN
4207: l_rec_changed := TRUE;
4208: goto finish;
4209: END IF;
4210: --
4211: END IF;
4212: --
4213: --
4214: IF p_cont_attribute2 <> hr_api.g_varchar2
4215: THEN
4216: --
4217: IF nvl(p_cont_attribute2, hr_api.g_varchar2) <>
4218: nvl(l_cur_contact_data.cont_attribute2, hr_api.g_varchar2)
4213: --
4214: IF p_cont_attribute2 <> hr_api.g_varchar2
4215: THEN
4216: --
4217: IF nvl(p_cont_attribute2, hr_api.g_varchar2) <>
4218: nvl(l_cur_contact_data.cont_attribute2, hr_api.g_varchar2)
4219: THEN
4220: l_rec_changed := TRUE;
4221: goto finish;
4214: IF p_cont_attribute2 <> hr_api.g_varchar2
4215: THEN
4216: --
4217: IF nvl(p_cont_attribute2, hr_api.g_varchar2) <>
4218: nvl(l_cur_contact_data.cont_attribute2, hr_api.g_varchar2)
4219: THEN
4220: l_rec_changed := TRUE;
4221: goto finish;
4222: END IF;
4223: --
4224: END IF;
4225: --
4226: --
4227: IF p_cont_attribute3 <> hr_api.g_varchar2
4228: THEN
4229: --
4230: IF nvl(p_cont_attribute3, hr_api.g_varchar2) <>
4231: nvl(l_cur_contact_data.cont_attribute3, hr_api.g_varchar2)
4226: --
4227: IF p_cont_attribute3 <> hr_api.g_varchar2
4228: THEN
4229: --
4230: IF nvl(p_cont_attribute3, hr_api.g_varchar2) <>
4231: nvl(l_cur_contact_data.cont_attribute3, hr_api.g_varchar2)
4232: THEN
4233: l_rec_changed := TRUE;
4234: goto finish;
4227: IF p_cont_attribute3 <> hr_api.g_varchar2
4228: THEN
4229: --
4230: IF nvl(p_cont_attribute3, hr_api.g_varchar2) <>
4231: nvl(l_cur_contact_data.cont_attribute3, hr_api.g_varchar2)
4232: THEN
4233: l_rec_changed := TRUE;
4234: goto finish;
4235: END IF;
4236: --
4237: END IF;
4238: --
4239: --
4240: IF p_cont_attribute4 <> hr_api.g_varchar2
4241: THEN
4242: --
4243: IF nvl(p_cont_attribute4, hr_api.g_varchar2) <>
4244: nvl(l_cur_contact_data.cont_attribute4, hr_api.g_varchar2)
4239: --
4240: IF p_cont_attribute4 <> hr_api.g_varchar2
4241: THEN
4242: --
4243: IF nvl(p_cont_attribute4, hr_api.g_varchar2) <>
4244: nvl(l_cur_contact_data.cont_attribute4, hr_api.g_varchar2)
4245: THEN
4246: l_rec_changed := TRUE;
4247: goto finish;
4240: IF p_cont_attribute4 <> hr_api.g_varchar2
4241: THEN
4242: --
4243: IF nvl(p_cont_attribute4, hr_api.g_varchar2) <>
4244: nvl(l_cur_contact_data.cont_attribute4, hr_api.g_varchar2)
4245: THEN
4246: l_rec_changed := TRUE;
4247: goto finish;
4248: END IF;
4249: --
4250: END IF;
4251: --
4252: --
4253: IF p_cont_attribute5 <> hr_api.g_varchar2
4254: THEN
4255: --
4256: IF nvl(p_cont_attribute5, hr_api.g_varchar2) <>
4257: nvl(l_cur_contact_data.cont_attribute5, hr_api.g_varchar2)
4252: --
4253: IF p_cont_attribute5 <> hr_api.g_varchar2
4254: THEN
4255: --
4256: IF nvl(p_cont_attribute5, hr_api.g_varchar2) <>
4257: nvl(l_cur_contact_data.cont_attribute5, hr_api.g_varchar2)
4258: THEN
4259: l_rec_changed := TRUE;
4260: goto finish;
4253: IF p_cont_attribute5 <> hr_api.g_varchar2
4254: THEN
4255: --
4256: IF nvl(p_cont_attribute5, hr_api.g_varchar2) <>
4257: nvl(l_cur_contact_data.cont_attribute5, hr_api.g_varchar2)
4258: THEN
4259: l_rec_changed := TRUE;
4260: goto finish;
4261: END IF;
4262: --
4263: END IF;
4264: --
4265: --
4266: IF p_cont_attribute6 <> hr_api.g_varchar2
4267: THEN
4268: --
4269: IF nvl(p_cont_attribute6, hr_api.g_varchar2) <>
4270: nvl(l_cur_contact_data.cont_attribute6, hr_api.g_varchar2)
4265: --
4266: IF p_cont_attribute6 <> hr_api.g_varchar2
4267: THEN
4268: --
4269: IF nvl(p_cont_attribute6, hr_api.g_varchar2) <>
4270: nvl(l_cur_contact_data.cont_attribute6, hr_api.g_varchar2)
4271: THEN
4272: l_rec_changed := TRUE;
4273: goto finish;
4266: IF p_cont_attribute6 <> hr_api.g_varchar2
4267: THEN
4268: --
4269: IF nvl(p_cont_attribute6, hr_api.g_varchar2) <>
4270: nvl(l_cur_contact_data.cont_attribute6, hr_api.g_varchar2)
4271: THEN
4272: l_rec_changed := TRUE;
4273: goto finish;
4274: END IF;
4275: --
4276: END IF;
4277: --
4278: --
4279: IF p_cont_attribute7 <> hr_api.g_varchar2
4280: THEN
4281: --
4282: IF nvl(p_cont_attribute7, hr_api.g_varchar2) <>
4283: nvl(l_cur_contact_data.cont_attribute7, hr_api.g_varchar2)
4278: --
4279: IF p_cont_attribute7 <> hr_api.g_varchar2
4280: THEN
4281: --
4282: IF nvl(p_cont_attribute7, hr_api.g_varchar2) <>
4283: nvl(l_cur_contact_data.cont_attribute7, hr_api.g_varchar2)
4284: THEN
4285: l_rec_changed := TRUE;
4286: goto finish;
4279: IF p_cont_attribute7 <> hr_api.g_varchar2
4280: THEN
4281: --
4282: IF nvl(p_cont_attribute7, hr_api.g_varchar2) <>
4283: nvl(l_cur_contact_data.cont_attribute7, hr_api.g_varchar2)
4284: THEN
4285: l_rec_changed := TRUE;
4286: goto finish;
4287: END IF;
4288: --
4289: END IF;
4290: --
4291: --
4292: IF p_cont_attribute8 <> hr_api.g_varchar2
4293: THEN
4294: --
4295: IF nvl(p_cont_attribute8, hr_api.g_varchar2) <>
4296: nvl(l_cur_contact_data.cont_attribute8, hr_api.g_varchar2)
4291: --
4292: IF p_cont_attribute8 <> hr_api.g_varchar2
4293: THEN
4294: --
4295: IF nvl(p_cont_attribute8, hr_api.g_varchar2) <>
4296: nvl(l_cur_contact_data.cont_attribute8, hr_api.g_varchar2)
4297: THEN
4298: l_rec_changed := TRUE;
4299: goto finish;
4292: IF p_cont_attribute8 <> hr_api.g_varchar2
4293: THEN
4294: --
4295: IF nvl(p_cont_attribute8, hr_api.g_varchar2) <>
4296: nvl(l_cur_contact_data.cont_attribute8, hr_api.g_varchar2)
4297: THEN
4298: l_rec_changed := TRUE;
4299: goto finish;
4300: END IF;
4301: --
4302: END IF;
4303: --
4304: --
4305: IF p_cont_attribute9 <> hr_api.g_varchar2
4306: THEN
4307: --
4308: IF nvl(p_cont_attribute9, hr_api.g_varchar2) <>
4309: nvl(l_cur_contact_data.cont_attribute9, hr_api.g_varchar2)
4304: --
4305: IF p_cont_attribute9 <> hr_api.g_varchar2
4306: THEN
4307: --
4308: IF nvl(p_cont_attribute9, hr_api.g_varchar2) <>
4309: nvl(l_cur_contact_data.cont_attribute9, hr_api.g_varchar2)
4310: THEN
4311: l_rec_changed := TRUE;
4312: goto finish;
4305: IF p_cont_attribute9 <> hr_api.g_varchar2
4306: THEN
4307: --
4308: IF nvl(p_cont_attribute9, hr_api.g_varchar2) <>
4309: nvl(l_cur_contact_data.cont_attribute9, hr_api.g_varchar2)
4310: THEN
4311: l_rec_changed := TRUE;
4312: goto finish;
4313: END IF;
4314: --
4315: END IF;
4316: --
4317: --
4318: IF p_cont_attribute10 <> hr_api.g_varchar2
4319: THEN
4320: --
4321: IF nvl(p_cont_attribute10, hr_api.g_varchar2) <>
4322: nvl(l_cur_contact_data.cont_attribute10, hr_api.g_varchar2)
4317: --
4318: IF p_cont_attribute10 <> hr_api.g_varchar2
4319: THEN
4320: --
4321: IF nvl(p_cont_attribute10, hr_api.g_varchar2) <>
4322: nvl(l_cur_contact_data.cont_attribute10, hr_api.g_varchar2)
4323: THEN
4324: l_rec_changed := TRUE;
4325: goto finish;
4318: IF p_cont_attribute10 <> hr_api.g_varchar2
4319: THEN
4320: --
4321: IF nvl(p_cont_attribute10, hr_api.g_varchar2) <>
4322: nvl(l_cur_contact_data.cont_attribute10, hr_api.g_varchar2)
4323: THEN
4324: l_rec_changed := TRUE;
4325: goto finish;
4326: END IF;
4327: --
4328: END IF;
4329: --
4330: --
4331: IF p_cont_attribute11 <> hr_api.g_varchar2
4332: THEN
4333: --
4334: IF nvl(p_cont_attribute11, hr_api.g_varchar2) <>
4335: nvl(l_cur_contact_data.cont_attribute11, hr_api.g_varchar2)
4330: --
4331: IF p_cont_attribute11 <> hr_api.g_varchar2
4332: THEN
4333: --
4334: IF nvl(p_cont_attribute11, hr_api.g_varchar2) <>
4335: nvl(l_cur_contact_data.cont_attribute11, hr_api.g_varchar2)
4336: THEN
4337: l_rec_changed := TRUE;
4338: goto finish;
4331: IF p_cont_attribute11 <> hr_api.g_varchar2
4332: THEN
4333: --
4334: IF nvl(p_cont_attribute11, hr_api.g_varchar2) <>
4335: nvl(l_cur_contact_data.cont_attribute11, hr_api.g_varchar2)
4336: THEN
4337: l_rec_changed := TRUE;
4338: goto finish;
4339: END IF;
4340: --
4341: END IF;
4342: --
4343: --
4344: IF p_cont_attribute12 <> hr_api.g_varchar2
4345: THEN
4346: --
4347: IF nvl(p_cont_attribute12, hr_api.g_varchar2) <>
4348: nvl(l_cur_contact_data.cont_attribute12, hr_api.g_varchar2)
4343: --
4344: IF p_cont_attribute12 <> hr_api.g_varchar2
4345: THEN
4346: --
4347: IF nvl(p_cont_attribute12, hr_api.g_varchar2) <>
4348: nvl(l_cur_contact_data.cont_attribute12, hr_api.g_varchar2)
4349: THEN
4350: l_rec_changed := TRUE;
4351: goto finish;
4344: IF p_cont_attribute12 <> hr_api.g_varchar2
4345: THEN
4346: --
4347: IF nvl(p_cont_attribute12, hr_api.g_varchar2) <>
4348: nvl(l_cur_contact_data.cont_attribute12, hr_api.g_varchar2)
4349: THEN
4350: l_rec_changed := TRUE;
4351: goto finish;
4352: END IF;
4353: --
4354: END IF;
4355: --
4356: --
4357: IF p_cont_attribute13 <> hr_api.g_varchar2
4358: THEN
4359: --
4360: IF nvl(p_cont_attribute13, hr_api.g_varchar2) <>
4361: nvl(l_cur_contact_data.cont_attribute13, hr_api.g_varchar2)
4356: --
4357: IF p_cont_attribute13 <> hr_api.g_varchar2
4358: THEN
4359: --
4360: IF nvl(p_cont_attribute13, hr_api.g_varchar2) <>
4361: nvl(l_cur_contact_data.cont_attribute13, hr_api.g_varchar2)
4362: THEN
4363: l_rec_changed := TRUE;
4364: goto finish;
4357: IF p_cont_attribute13 <> hr_api.g_varchar2
4358: THEN
4359: --
4360: IF nvl(p_cont_attribute13, hr_api.g_varchar2) <>
4361: nvl(l_cur_contact_data.cont_attribute13, hr_api.g_varchar2)
4362: THEN
4363: l_rec_changed := TRUE;
4364: goto finish;
4365: END IF;
4366: --
4367: END IF;
4368: --
4369: --
4370: IF p_cont_attribute14 <> hr_api.g_varchar2
4371: THEN
4372: --
4373: IF nvl(p_cont_attribute14, hr_api.g_varchar2) <>
4374: nvl(l_cur_contact_data.cont_attribute14, hr_api.g_varchar2)
4369: --
4370: IF p_cont_attribute14 <> hr_api.g_varchar2
4371: THEN
4372: --
4373: IF nvl(p_cont_attribute14, hr_api.g_varchar2) <>
4374: nvl(l_cur_contact_data.cont_attribute14, hr_api.g_varchar2)
4375: THEN
4376: l_rec_changed := TRUE;
4377: goto finish;
4370: IF p_cont_attribute14 <> hr_api.g_varchar2
4371: THEN
4372: --
4373: IF nvl(p_cont_attribute14, hr_api.g_varchar2) <>
4374: nvl(l_cur_contact_data.cont_attribute14, hr_api.g_varchar2)
4375: THEN
4376: l_rec_changed := TRUE;
4377: goto finish;
4378: END IF;
4379: --
4380: END IF;
4381: --
4382: --
4383: IF p_cont_attribute15 <> hr_api.g_varchar2
4384: THEN
4385: --
4386: IF nvl(p_cont_attribute15, hr_api.g_varchar2) <>
4387: nvl(l_cur_contact_data.cont_attribute15, hr_api.g_varchar2)
4382: --
4383: IF p_cont_attribute15 <> hr_api.g_varchar2
4384: THEN
4385: --
4386: IF nvl(p_cont_attribute15, hr_api.g_varchar2) <>
4387: nvl(l_cur_contact_data.cont_attribute15, hr_api.g_varchar2)
4388: THEN
4389: l_rec_changed := TRUE;
4390: goto finish;
4383: IF p_cont_attribute15 <> hr_api.g_varchar2
4384: THEN
4385: --
4386: IF nvl(p_cont_attribute15, hr_api.g_varchar2) <>
4387: nvl(l_cur_contact_data.cont_attribute15, hr_api.g_varchar2)
4388: THEN
4389: l_rec_changed := TRUE;
4390: goto finish;
4391: END IF;
4392: --
4393: END IF;
4394: --
4395: --
4396: IF p_cont_attribute16 <> hr_api.g_varchar2
4397: THEN
4398: --
4399: IF nvl(p_cont_attribute16, hr_api.g_varchar2) <>
4400: nvl(l_cur_contact_data.cont_attribute16, hr_api.g_varchar2)
4395: --
4396: IF p_cont_attribute16 <> hr_api.g_varchar2
4397: THEN
4398: --
4399: IF nvl(p_cont_attribute16, hr_api.g_varchar2) <>
4400: nvl(l_cur_contact_data.cont_attribute16, hr_api.g_varchar2)
4401: THEN
4402: l_rec_changed := TRUE;
4403: goto finish;
4396: IF p_cont_attribute16 <> hr_api.g_varchar2
4397: THEN
4398: --
4399: IF nvl(p_cont_attribute16, hr_api.g_varchar2) <>
4400: nvl(l_cur_contact_data.cont_attribute16, hr_api.g_varchar2)
4401: THEN
4402: l_rec_changed := TRUE;
4403: goto finish;
4404: END IF;
4405: --
4406: END IF;
4407: --
4408: --
4409: IF p_cont_attribute17 <> hr_api.g_varchar2
4410: THEN
4411: --
4412: IF nvl(p_cont_attribute17, hr_api.g_varchar2) <>
4413: nvl(l_cur_contact_data.cont_attribute17, hr_api.g_varchar2)
4408: --
4409: IF p_cont_attribute17 <> hr_api.g_varchar2
4410: THEN
4411: --
4412: IF nvl(p_cont_attribute17, hr_api.g_varchar2) <>
4413: nvl(l_cur_contact_data.cont_attribute17, hr_api.g_varchar2)
4414: THEN
4415: l_rec_changed := TRUE;
4416: goto finish;
4409: IF p_cont_attribute17 <> hr_api.g_varchar2
4410: THEN
4411: --
4412: IF nvl(p_cont_attribute17, hr_api.g_varchar2) <>
4413: nvl(l_cur_contact_data.cont_attribute17, hr_api.g_varchar2)
4414: THEN
4415: l_rec_changed := TRUE;
4416: goto finish;
4417: END IF;
4418: --
4419: END IF;
4420: --
4421: --
4422: IF p_cont_attribute18 <> hr_api.g_varchar2
4423: THEN
4424: --
4425: IF nvl(p_cont_attribute18, hr_api.g_varchar2) <>
4426: nvl(l_cur_contact_data.cont_attribute18, hr_api.g_varchar2)
4421: --
4422: IF p_cont_attribute18 <> hr_api.g_varchar2
4423: THEN
4424: --
4425: IF nvl(p_cont_attribute18, hr_api.g_varchar2) <>
4426: nvl(l_cur_contact_data.cont_attribute18, hr_api.g_varchar2)
4427: THEN
4428: l_rec_changed := TRUE;
4429: goto finish;
4422: IF p_cont_attribute18 <> hr_api.g_varchar2
4423: THEN
4424: --
4425: IF nvl(p_cont_attribute18, hr_api.g_varchar2) <>
4426: nvl(l_cur_contact_data.cont_attribute18, hr_api.g_varchar2)
4427: THEN
4428: l_rec_changed := TRUE;
4429: goto finish;
4430: END IF;
4431: --
4432: END IF;
4433: --
4434: --
4435: IF p_cont_attribute19 <> hr_api.g_varchar2
4436: THEN
4437: --
4438: IF nvl(p_cont_attribute19, hr_api.g_varchar2) <>
4439: nvl(l_cur_contact_data.cont_attribute19, hr_api.g_varchar2)
4434: --
4435: IF p_cont_attribute19 <> hr_api.g_varchar2
4436: THEN
4437: --
4438: IF nvl(p_cont_attribute19, hr_api.g_varchar2) <>
4439: nvl(l_cur_contact_data.cont_attribute19, hr_api.g_varchar2)
4440: THEN
4441: l_rec_changed := TRUE;
4442: goto finish;
4435: IF p_cont_attribute19 <> hr_api.g_varchar2
4436: THEN
4437: --
4438: IF nvl(p_cont_attribute19, hr_api.g_varchar2) <>
4439: nvl(l_cur_contact_data.cont_attribute19, hr_api.g_varchar2)
4440: THEN
4441: l_rec_changed := TRUE;
4442: goto finish;
4443: END IF;
4444: --
4445: END IF;
4446: --
4447: --
4448: IF p_cont_attribute20 <> hr_api.g_varchar2
4449: THEN
4450: --
4451: IF nvl(p_cont_attribute20, hr_api.g_varchar2) <>
4452: nvl(l_cur_contact_data.cont_attribute20, hr_api.g_varchar2)
4447: --
4448: IF p_cont_attribute20 <> hr_api.g_varchar2
4449: THEN
4450: --
4451: IF nvl(p_cont_attribute20, hr_api.g_varchar2) <>
4452: nvl(l_cur_contact_data.cont_attribute20, hr_api.g_varchar2)
4453: THEN
4454: l_rec_changed := TRUE;
4455: goto finish;
4448: IF p_cont_attribute20 <> hr_api.g_varchar2
4449: THEN
4450: --
4451: IF nvl(p_cont_attribute20, hr_api.g_varchar2) <>
4452: nvl(l_cur_contact_data.cont_attribute20, hr_api.g_varchar2)
4453: THEN
4454: l_rec_changed := TRUE;
4455: goto finish;
4456: END IF;
4456: END IF;
4457: --
4458: END IF;
4459: --
4460: IF P_CONT_INFORMATION1 <> hr_api.g_varchar2
4461: THEN
4462: --
4463: IF nvl(P_CONT_INFORMATION1, hr_api.g_varchar2) <>
4464: nvl(l_cur_contact_data.CONT_INFORMATION1, hr_api.g_varchar2)
4459: --
4460: IF P_CONT_INFORMATION1 <> hr_api.g_varchar2
4461: THEN
4462: --
4463: IF nvl(P_CONT_INFORMATION1, hr_api.g_varchar2) <>
4464: nvl(l_cur_contact_data.CONT_INFORMATION1, hr_api.g_varchar2)
4465: THEN
4466: l_rec_changed := TRUE;
4467: goto finish;
4460: IF P_CONT_INFORMATION1 <> hr_api.g_varchar2
4461: THEN
4462: --
4463: IF nvl(P_CONT_INFORMATION1, hr_api.g_varchar2) <>
4464: nvl(l_cur_contact_data.CONT_INFORMATION1, hr_api.g_varchar2)
4465: THEN
4466: l_rec_changed := TRUE;
4467: goto finish;
4468: END IF;
4468: END IF;
4469: --
4470: END IF;
4471:
4472: IF P_CONT_INFORMATION2 <> hr_api.g_varchar2
4473: THEN
4474: --
4475: IF nvl(P_CONT_INFORMATION2, hr_api.g_varchar2) <>
4476: nvl(l_cur_contact_data.CONT_INFORMATION2, hr_api.g_varchar2)
4471:
4472: IF P_CONT_INFORMATION2 <> hr_api.g_varchar2
4473: THEN
4474: --
4475: IF nvl(P_CONT_INFORMATION2, hr_api.g_varchar2) <>
4476: nvl(l_cur_contact_data.CONT_INFORMATION2, hr_api.g_varchar2)
4477: THEN
4478: l_rec_changed := TRUE;
4479: goto finish;
4472: IF P_CONT_INFORMATION2 <> hr_api.g_varchar2
4473: THEN
4474: --
4475: IF nvl(P_CONT_INFORMATION2, hr_api.g_varchar2) <>
4476: nvl(l_cur_contact_data.CONT_INFORMATION2, hr_api.g_varchar2)
4477: THEN
4478: l_rec_changed := TRUE;
4479: goto finish;
4480: END IF;
4480: END IF;
4481: --
4482: END IF;
4483:
4484: IF P_CONT_INFORMATION3 <> hr_api.g_varchar2
4485: THEN
4486: --
4487: IF nvl(P_CONT_INFORMATION3, hr_api.g_varchar2) <>
4488: nvl(l_cur_contact_data.CONT_INFORMATION3, hr_api.g_varchar2)
4483:
4484: IF P_CONT_INFORMATION3 <> hr_api.g_varchar2
4485: THEN
4486: --
4487: IF nvl(P_CONT_INFORMATION3, hr_api.g_varchar2) <>
4488: nvl(l_cur_contact_data.CONT_INFORMATION3, hr_api.g_varchar2)
4489: THEN
4490: l_rec_changed := TRUE;
4491: goto finish;
4484: IF P_CONT_INFORMATION3 <> hr_api.g_varchar2
4485: THEN
4486: --
4487: IF nvl(P_CONT_INFORMATION3, hr_api.g_varchar2) <>
4488: nvl(l_cur_contact_data.CONT_INFORMATION3, hr_api.g_varchar2)
4489: THEN
4490: l_rec_changed := TRUE;
4491: goto finish;
4492: END IF;
4492: END IF;
4493: --
4494: END IF;
4495:
4496: IF P_CONT_INFORMATION4 <> hr_api.g_varchar2
4497: THEN
4498: --
4499: IF nvl(P_CONT_INFORMATION4, hr_api.g_varchar2) <>
4500: nvl(l_cur_contact_data.CONT_INFORMATION4, hr_api.g_varchar2)
4495:
4496: IF P_CONT_INFORMATION4 <> hr_api.g_varchar2
4497: THEN
4498: --
4499: IF nvl(P_CONT_INFORMATION4, hr_api.g_varchar2) <>
4500: nvl(l_cur_contact_data.CONT_INFORMATION4, hr_api.g_varchar2)
4501: THEN
4502: l_rec_changed := TRUE;
4503: goto finish;
4496: IF P_CONT_INFORMATION4 <> hr_api.g_varchar2
4497: THEN
4498: --
4499: IF nvl(P_CONT_INFORMATION4, hr_api.g_varchar2) <>
4500: nvl(l_cur_contact_data.CONT_INFORMATION4, hr_api.g_varchar2)
4501: THEN
4502: l_rec_changed := TRUE;
4503: goto finish;
4504: END IF;
4504: END IF;
4505: --
4506: END IF;
4507:
4508: IF P_CONT_INFORMATION5 <> hr_api.g_varchar2
4509: THEN
4510: --
4511: IF nvl(P_CONT_INFORMATION5, hr_api.g_varchar2) <>
4512: nvl(l_cur_contact_data.CONT_INFORMATION5, hr_api.g_varchar2)
4507:
4508: IF P_CONT_INFORMATION5 <> hr_api.g_varchar2
4509: THEN
4510: --
4511: IF nvl(P_CONT_INFORMATION5, hr_api.g_varchar2) <>
4512: nvl(l_cur_contact_data.CONT_INFORMATION5, hr_api.g_varchar2)
4513: THEN
4514: l_rec_changed := TRUE;
4515: goto finish;
4508: IF P_CONT_INFORMATION5 <> hr_api.g_varchar2
4509: THEN
4510: --
4511: IF nvl(P_CONT_INFORMATION5, hr_api.g_varchar2) <>
4512: nvl(l_cur_contact_data.CONT_INFORMATION5, hr_api.g_varchar2)
4513: THEN
4514: l_rec_changed := TRUE;
4515: goto finish;
4516: END IF;
4516: END IF;
4517: --
4518: END IF;
4519:
4520: IF P_CONT_INFORMATION6 <> hr_api.g_varchar2
4521: THEN
4522: --
4523: IF nvl(P_CONT_INFORMATION6, hr_api.g_varchar2) <>
4524: nvl(l_cur_contact_data.CONT_INFORMATION6, hr_api.g_varchar2)
4519:
4520: IF P_CONT_INFORMATION6 <> hr_api.g_varchar2
4521: THEN
4522: --
4523: IF nvl(P_CONT_INFORMATION6, hr_api.g_varchar2) <>
4524: nvl(l_cur_contact_data.CONT_INFORMATION6, hr_api.g_varchar2)
4525: THEN
4526: l_rec_changed := TRUE;
4527: goto finish;
4520: IF P_CONT_INFORMATION6 <> hr_api.g_varchar2
4521: THEN
4522: --
4523: IF nvl(P_CONT_INFORMATION6, hr_api.g_varchar2) <>
4524: nvl(l_cur_contact_data.CONT_INFORMATION6, hr_api.g_varchar2)
4525: THEN
4526: l_rec_changed := TRUE;
4527: goto finish;
4528: END IF;
4528: END IF;
4529: --
4530: END IF;
4531:
4532: IF P_CONT_INFORMATION7 <> hr_api.g_varchar2
4533: THEN
4534: --
4535: IF nvl(P_CONT_INFORMATION7, hr_api.g_varchar2) <>
4536: nvl(l_cur_contact_data.CONT_INFORMATION7, hr_api.g_varchar2)
4531:
4532: IF P_CONT_INFORMATION7 <> hr_api.g_varchar2
4533: THEN
4534: --
4535: IF nvl(P_CONT_INFORMATION7, hr_api.g_varchar2) <>
4536: nvl(l_cur_contact_data.CONT_INFORMATION7, hr_api.g_varchar2)
4537: THEN
4538: l_rec_changed := TRUE;
4539: goto finish;
4532: IF P_CONT_INFORMATION7 <> hr_api.g_varchar2
4533: THEN
4534: --
4535: IF nvl(P_CONT_INFORMATION7, hr_api.g_varchar2) <>
4536: nvl(l_cur_contact_data.CONT_INFORMATION7, hr_api.g_varchar2)
4537: THEN
4538: l_rec_changed := TRUE;
4539: goto finish;
4540: END IF;
4540: END IF;
4541: --
4542: END IF;
4543:
4544: IF P_CONT_INFORMATION8 <> hr_api.g_varchar2
4545: THEN
4546: --
4547: IF nvl(P_CONT_INFORMATION8, hr_api.g_varchar2) <>
4548: nvl(l_cur_contact_data.CONT_INFORMATION8, hr_api.g_varchar2)
4543:
4544: IF P_CONT_INFORMATION8 <> hr_api.g_varchar2
4545: THEN
4546: --
4547: IF nvl(P_CONT_INFORMATION8, hr_api.g_varchar2) <>
4548: nvl(l_cur_contact_data.CONT_INFORMATION8, hr_api.g_varchar2)
4549: THEN
4550: l_rec_changed := TRUE;
4551: goto finish;
4544: IF P_CONT_INFORMATION8 <> hr_api.g_varchar2
4545: THEN
4546: --
4547: IF nvl(P_CONT_INFORMATION8, hr_api.g_varchar2) <>
4548: nvl(l_cur_contact_data.CONT_INFORMATION8, hr_api.g_varchar2)
4549: THEN
4550: l_rec_changed := TRUE;
4551: goto finish;
4552: END IF;
4552: END IF;
4553: --
4554: END IF;
4555:
4556: IF P_CONT_INFORMATION9 <> hr_api.g_varchar2
4557: THEN
4558: --
4559: IF nvl(P_CONT_INFORMATION9, hr_api.g_varchar2) <>
4560: nvl(l_cur_contact_data.CONT_INFORMATION9, hr_api.g_varchar2)
4555:
4556: IF P_CONT_INFORMATION9 <> hr_api.g_varchar2
4557: THEN
4558: --
4559: IF nvl(P_CONT_INFORMATION9, hr_api.g_varchar2) <>
4560: nvl(l_cur_contact_data.CONT_INFORMATION9, hr_api.g_varchar2)
4561: THEN
4562: l_rec_changed := TRUE;
4563: goto finish;
4556: IF P_CONT_INFORMATION9 <> hr_api.g_varchar2
4557: THEN
4558: --
4559: IF nvl(P_CONT_INFORMATION9, hr_api.g_varchar2) <>
4560: nvl(l_cur_contact_data.CONT_INFORMATION9, hr_api.g_varchar2)
4561: THEN
4562: l_rec_changed := TRUE;
4563: goto finish;
4564: END IF;
4564: END IF;
4565: --
4566: END IF;
4567:
4568: IF P_CONT_INFORMATION10 <> hr_api.g_varchar2
4569: THEN
4570: --
4571: IF nvl(P_CONT_INFORMATION10, hr_api.g_varchar2) <>
4572: nvl(l_cur_contact_data.CONT_INFORMATION10, hr_api.g_varchar2)
4567:
4568: IF P_CONT_INFORMATION10 <> hr_api.g_varchar2
4569: THEN
4570: --
4571: IF nvl(P_CONT_INFORMATION10, hr_api.g_varchar2) <>
4572: nvl(l_cur_contact_data.CONT_INFORMATION10, hr_api.g_varchar2)
4573: THEN
4574: l_rec_changed := TRUE;
4575: goto finish;
4568: IF P_CONT_INFORMATION10 <> hr_api.g_varchar2
4569: THEN
4570: --
4571: IF nvl(P_CONT_INFORMATION10, hr_api.g_varchar2) <>
4572: nvl(l_cur_contact_data.CONT_INFORMATION10, hr_api.g_varchar2)
4573: THEN
4574: l_rec_changed := TRUE;
4575: goto finish;
4576: END IF;
4576: END IF;
4577: --
4578: END IF;
4579:
4580: IF P_CONT_INFORMATION11 <> hr_api.g_varchar2
4581: THEN
4582: --
4583: IF nvl(P_CONT_INFORMATION11, hr_api.g_varchar2) <>
4584: nvl(l_cur_contact_data.CONT_INFORMATION11, hr_api.g_varchar2)
4579:
4580: IF P_CONT_INFORMATION11 <> hr_api.g_varchar2
4581: THEN
4582: --
4583: IF nvl(P_CONT_INFORMATION11, hr_api.g_varchar2) <>
4584: nvl(l_cur_contact_data.CONT_INFORMATION11, hr_api.g_varchar2)
4585: THEN
4586: l_rec_changed := TRUE;
4587: goto finish;
4580: IF P_CONT_INFORMATION11 <> hr_api.g_varchar2
4581: THEN
4582: --
4583: IF nvl(P_CONT_INFORMATION11, hr_api.g_varchar2) <>
4584: nvl(l_cur_contact_data.CONT_INFORMATION11, hr_api.g_varchar2)
4585: THEN
4586: l_rec_changed := TRUE;
4587: goto finish;
4588: END IF;
4588: END IF;
4589: --
4590: END IF;
4591:
4592: IF P_CONT_INFORMATION12 <> hr_api.g_varchar2
4593: THEN
4594: --
4595: IF nvl(P_CONT_INFORMATION12, hr_api.g_varchar2) <>
4596: nvl(l_cur_contact_data.CONT_INFORMATION12, hr_api.g_varchar2)
4591:
4592: IF P_CONT_INFORMATION12 <> hr_api.g_varchar2
4593: THEN
4594: --
4595: IF nvl(P_CONT_INFORMATION12, hr_api.g_varchar2) <>
4596: nvl(l_cur_contact_data.CONT_INFORMATION12, hr_api.g_varchar2)
4597: THEN
4598: l_rec_changed := TRUE;
4599: goto finish;
4592: IF P_CONT_INFORMATION12 <> hr_api.g_varchar2
4593: THEN
4594: --
4595: IF nvl(P_CONT_INFORMATION12, hr_api.g_varchar2) <>
4596: nvl(l_cur_contact_data.CONT_INFORMATION12, hr_api.g_varchar2)
4597: THEN
4598: l_rec_changed := TRUE;
4599: goto finish;
4600: END IF;
4600: END IF;
4601: --
4602: END IF;
4603:
4604: IF P_CONT_INFORMATION13 <> hr_api.g_varchar2
4605: THEN
4606: --
4607: IF nvl(P_CONT_INFORMATION13, hr_api.g_varchar2) <>
4608: nvl(l_cur_contact_data.CONT_INFORMATION13, hr_api.g_varchar2)
4603:
4604: IF P_CONT_INFORMATION13 <> hr_api.g_varchar2
4605: THEN
4606: --
4607: IF nvl(P_CONT_INFORMATION13, hr_api.g_varchar2) <>
4608: nvl(l_cur_contact_data.CONT_INFORMATION13, hr_api.g_varchar2)
4609: THEN
4610: l_rec_changed := TRUE;
4611: goto finish;
4604: IF P_CONT_INFORMATION13 <> hr_api.g_varchar2
4605: THEN
4606: --
4607: IF nvl(P_CONT_INFORMATION13, hr_api.g_varchar2) <>
4608: nvl(l_cur_contact_data.CONT_INFORMATION13, hr_api.g_varchar2)
4609: THEN
4610: l_rec_changed := TRUE;
4611: goto finish;
4612: END IF;
4612: END IF;
4613: --
4614: END IF;
4615:
4616: IF P_CONT_INFORMATION14 <> hr_api.g_varchar2
4617: THEN
4618: --
4619: IF nvl(P_CONT_INFORMATION14, hr_api.g_varchar2) <>
4620: nvl(l_cur_contact_data.CONT_INFORMATION14, hr_api.g_varchar2)
4615:
4616: IF P_CONT_INFORMATION14 <> hr_api.g_varchar2
4617: THEN
4618: --
4619: IF nvl(P_CONT_INFORMATION14, hr_api.g_varchar2) <>
4620: nvl(l_cur_contact_data.CONT_INFORMATION14, hr_api.g_varchar2)
4621: THEN
4622: l_rec_changed := TRUE;
4623: goto finish;
4616: IF P_CONT_INFORMATION14 <> hr_api.g_varchar2
4617: THEN
4618: --
4619: IF nvl(P_CONT_INFORMATION14, hr_api.g_varchar2) <>
4620: nvl(l_cur_contact_data.CONT_INFORMATION14, hr_api.g_varchar2)
4621: THEN
4622: l_rec_changed := TRUE;
4623: goto finish;
4624: END IF;
4624: END IF;
4625: --
4626: END IF;
4627:
4628: IF P_CONT_INFORMATION15 <> hr_api.g_varchar2
4629: THEN
4630: --
4631: IF nvl(P_CONT_INFORMATION15, hr_api.g_varchar2) <>
4632: nvl(l_cur_contact_data.CONT_INFORMATION15, hr_api.g_varchar2)
4627:
4628: IF P_CONT_INFORMATION15 <> hr_api.g_varchar2
4629: THEN
4630: --
4631: IF nvl(P_CONT_INFORMATION15, hr_api.g_varchar2) <>
4632: nvl(l_cur_contact_data.CONT_INFORMATION15, hr_api.g_varchar2)
4633: THEN
4634: l_rec_changed := TRUE;
4635: goto finish;
4628: IF P_CONT_INFORMATION15 <> hr_api.g_varchar2
4629: THEN
4630: --
4631: IF nvl(P_CONT_INFORMATION15, hr_api.g_varchar2) <>
4632: nvl(l_cur_contact_data.CONT_INFORMATION15, hr_api.g_varchar2)
4633: THEN
4634: l_rec_changed := TRUE;
4635: goto finish;
4636: END IF;
4636: END IF;
4637: --
4638: END IF;
4639:
4640: IF P_CONT_INFORMATION16 <> hr_api.g_varchar2
4641: THEN
4642: --
4643: IF nvl(P_CONT_INFORMATION16, hr_api.g_varchar2) <>
4644: nvl(l_cur_contact_data.CONT_INFORMATION16, hr_api.g_varchar2)
4639:
4640: IF P_CONT_INFORMATION16 <> hr_api.g_varchar2
4641: THEN
4642: --
4643: IF nvl(P_CONT_INFORMATION16, hr_api.g_varchar2) <>
4644: nvl(l_cur_contact_data.CONT_INFORMATION16, hr_api.g_varchar2)
4645: THEN
4646: l_rec_changed := TRUE;
4647: goto finish;
4640: IF P_CONT_INFORMATION16 <> hr_api.g_varchar2
4641: THEN
4642: --
4643: IF nvl(P_CONT_INFORMATION16, hr_api.g_varchar2) <>
4644: nvl(l_cur_contact_data.CONT_INFORMATION16, hr_api.g_varchar2)
4645: THEN
4646: l_rec_changed := TRUE;
4647: goto finish;
4648: END IF;
4648: END IF;
4649: --
4650: END IF;
4651:
4652: IF P_CONT_INFORMATION17 <> hr_api.g_varchar2
4653: THEN
4654: --
4655: IF nvl(P_CONT_INFORMATION17, hr_api.g_varchar2) <>
4656: nvl(l_cur_contact_data.CONT_INFORMATION17, hr_api.g_varchar2)
4651:
4652: IF P_CONT_INFORMATION17 <> hr_api.g_varchar2
4653: THEN
4654: --
4655: IF nvl(P_CONT_INFORMATION17, hr_api.g_varchar2) <>
4656: nvl(l_cur_contact_data.CONT_INFORMATION17, hr_api.g_varchar2)
4657: THEN
4658: l_rec_changed := TRUE;
4659: goto finish;
4652: IF P_CONT_INFORMATION17 <> hr_api.g_varchar2
4653: THEN
4654: --
4655: IF nvl(P_CONT_INFORMATION17, hr_api.g_varchar2) <>
4656: nvl(l_cur_contact_data.CONT_INFORMATION17, hr_api.g_varchar2)
4657: THEN
4658: l_rec_changed := TRUE;
4659: goto finish;
4660: END IF;
4660: END IF;
4661: --
4662: END IF;
4663:
4664: IF P_CONT_INFORMATION18 <> hr_api.g_varchar2
4665: THEN
4666: --
4667: IF nvl(P_CONT_INFORMATION18, hr_api.g_varchar2) <>
4668: nvl(l_cur_contact_data.CONT_INFORMATION18, hr_api.g_varchar2)
4663:
4664: IF P_CONT_INFORMATION18 <> hr_api.g_varchar2
4665: THEN
4666: --
4667: IF nvl(P_CONT_INFORMATION18, hr_api.g_varchar2) <>
4668: nvl(l_cur_contact_data.CONT_INFORMATION18, hr_api.g_varchar2)
4669: THEN
4670: l_rec_changed := TRUE;
4671: goto finish;
4664: IF P_CONT_INFORMATION18 <> hr_api.g_varchar2
4665: THEN
4666: --
4667: IF nvl(P_CONT_INFORMATION18, hr_api.g_varchar2) <>
4668: nvl(l_cur_contact_data.CONT_INFORMATION18, hr_api.g_varchar2)
4669: THEN
4670: l_rec_changed := TRUE;
4671: goto finish;
4672: END IF;
4672: END IF;
4673: --
4674: END IF;
4675:
4676: IF P_CONT_INFORMATION19 <> hr_api.g_varchar2
4677: THEN
4678: --
4679: IF nvl(P_CONT_INFORMATION19, hr_api.g_varchar2) <>
4680: nvl(l_cur_contact_data.CONT_INFORMATION19, hr_api.g_varchar2)
4675:
4676: IF P_CONT_INFORMATION19 <> hr_api.g_varchar2
4677: THEN
4678: --
4679: IF nvl(P_CONT_INFORMATION19, hr_api.g_varchar2) <>
4680: nvl(l_cur_contact_data.CONT_INFORMATION19, hr_api.g_varchar2)
4681: THEN
4682: l_rec_changed := TRUE;
4683: goto finish;
4676: IF P_CONT_INFORMATION19 <> hr_api.g_varchar2
4677: THEN
4678: --
4679: IF nvl(P_CONT_INFORMATION19, hr_api.g_varchar2) <>
4680: nvl(l_cur_contact_data.CONT_INFORMATION19, hr_api.g_varchar2)
4681: THEN
4682: l_rec_changed := TRUE;
4683: goto finish;
4684: END IF;
4684: END IF;
4685: --
4686: END IF;
4687:
4688: IF P_CONT_INFORMATION20 <> hr_api.g_varchar2
4689: THEN
4690: --
4691: IF nvl(P_CONT_INFORMATION20, hr_api.g_varchar2) <>
4692: nvl(l_cur_contact_data.CONT_INFORMATION20, hr_api.g_varchar2)
4687:
4688: IF P_CONT_INFORMATION20 <> hr_api.g_varchar2
4689: THEN
4690: --
4691: IF nvl(P_CONT_INFORMATION20, hr_api.g_varchar2) <>
4692: nvl(l_cur_contact_data.CONT_INFORMATION20, hr_api.g_varchar2)
4693: THEN
4694: l_rec_changed := TRUE;
4695: goto finish;
4688: IF P_CONT_INFORMATION20 <> hr_api.g_varchar2
4689: THEN
4690: --
4691: IF nvl(P_CONT_INFORMATION20, hr_api.g_varchar2) <>
4692: nvl(l_cur_contact_data.CONT_INFORMATION20, hr_api.g_varchar2)
4693: THEN
4694: l_rec_changed := TRUE;
4695: goto finish;
4696: END IF;
6538: ,p_process_section_name in varchar2
6539: ,p_review_page_region_code in varchar2 default null
6540:
6541: ,p_adjusted_svc_date in date default null
6542: ,p_datetrack_update_mode in varchar2 default hr_api.g_correction -- 9999
6543: ,p_applicant_number in varchar2 default null
6544: ,p_background_check_status in varchar2 default null
6545: ,p_background_date_check in date default null
6546: ,p_benefit_group_id in number default null
6646: )
6647: IS
6648: l_count INTEGER := 0;
6649: l_transaction_table hr_transaction_ss.transaction_table;
6650: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
6651: l_object_version_number hr_api_transaction_steps.object_version_number%type;
6652: l_attribute_update_mode varchar2(100) default null;
6653: l_validate_mode boolean default false;
6654: l_con_name_combination_warning boolean;
6647: IS
6648: l_count INTEGER := 0;
6649: l_transaction_table hr_transaction_ss.transaction_table;
6650: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
6651: l_object_version_number hr_api_transaction_steps.object_version_number%type;
6652: l_attribute_update_mode varchar2(100) default null;
6653: l_validate_mode boolean default false;
6654: l_con_name_combination_warning boolean;
6655: l_per_name_combination_warning boolean;
6722: hr_utility.set_location('IF p_primary_contact_flag =Y :'||l_proc,10 );
6723: BEGIN
6724: select count(hats.transaction_step_id)
6725: into l_primary_contact_added
6726: from hr_api_transaction_steps hats,
6727: hr_api_transaction_values hatv
6728: where hats.item_type = p_item_type
6729: and hats.item_key = p_item_key
6730: and hats.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API'
6723: BEGIN
6724: select count(hats.transaction_step_id)
6725: into l_primary_contact_added
6726: from hr_api_transaction_steps hats,
6727: hr_api_transaction_values hatv
6728: where hats.item_type = p_item_type
6729: and hats.item_key = p_item_key
6730: and hats.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API'
6731: and hats.transaction_step_id = hatv.transaction_step_id
6856: else
6857: begin
6858: select nvl(max(hats1.transaction_step_id),0)
6859: into l_validate_g_per_step_id
6860: from hr_api_transaction_steps hats1
6861: where hats1.item_type = 'HRSSA'
6862: and hats1.item_key = p_item_key
6863: and hats1.api_name in( 'HR_PROCESS_PERSON_SS.PROCESS_API', 'BEN_PROCESS_COBRA_PERSON_SS.PROCESS_API');
6864:
7288: hr_person_api.update_person (
7289: p_validate => l_validate_mode
7290: ,p_effective_date => l_start_date
7291: --p_start_date --9999p_effective_date
7292: ,p_datetrack_update_mode => hr_api.g_correction
7293: -- 9999 p_datetrack_update_mode
7294: ,p_person_id => p_per_person_id
7295: ,p_object_version_number => p_per_object_version_number
7296: -- ,p_person_type_id => p_person_type_id
9128: END create_contact_tt;
9129: --
9130:
9131: Function is_con_rec_changed (
9132: p_adjusted_svc_date in date default hr_api.g_date
9133: ,p_applicant_number in varchar2 default hr_api.g_varchar2
9134: ,p_background_check_status in varchar2 default hr_api.g_varchar2
9135: ,p_background_date_check in date default hr_api.g_date
9136: ,p_benefit_group_id in number default hr_api.g_number
9129: --
9130:
9131: Function is_con_rec_changed (
9132: p_adjusted_svc_date in date default hr_api.g_date
9133: ,p_applicant_number in varchar2 default hr_api.g_varchar2
9134: ,p_background_check_status in varchar2 default hr_api.g_varchar2
9135: ,p_background_date_check in date default hr_api.g_date
9136: ,p_benefit_group_id in number default hr_api.g_number
9137: ,p_blood_type in varchar2 default hr_api.g_varchar2
9130:
9131: Function is_con_rec_changed (
9132: p_adjusted_svc_date in date default hr_api.g_date
9133: ,p_applicant_number in varchar2 default hr_api.g_varchar2
9134: ,p_background_check_status in varchar2 default hr_api.g_varchar2
9135: ,p_background_date_check in date default hr_api.g_date
9136: ,p_benefit_group_id in number default hr_api.g_number
9137: ,p_blood_type in varchar2 default hr_api.g_varchar2
9138: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
9131: Function is_con_rec_changed (
9132: p_adjusted_svc_date in date default hr_api.g_date
9133: ,p_applicant_number in varchar2 default hr_api.g_varchar2
9134: ,p_background_check_status in varchar2 default hr_api.g_varchar2
9135: ,p_background_date_check in date default hr_api.g_date
9136: ,p_benefit_group_id in number default hr_api.g_number
9137: ,p_blood_type in varchar2 default hr_api.g_varchar2
9138: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
9139: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
9132: p_adjusted_svc_date in date default hr_api.g_date
9133: ,p_applicant_number in varchar2 default hr_api.g_varchar2
9134: ,p_background_check_status in varchar2 default hr_api.g_varchar2
9135: ,p_background_date_check in date default hr_api.g_date
9136: ,p_benefit_group_id in number default hr_api.g_number
9137: ,p_blood_type in varchar2 default hr_api.g_varchar2
9138: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
9139: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
9140: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
9133: ,p_applicant_number in varchar2 default hr_api.g_varchar2
9134: ,p_background_check_status in varchar2 default hr_api.g_varchar2
9135: ,p_background_date_check in date default hr_api.g_date
9136: ,p_benefit_group_id in number default hr_api.g_number
9137: ,p_blood_type in varchar2 default hr_api.g_varchar2
9138: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
9139: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
9140: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
9141: ,p_date_employee_data_verified in date default hr_api.g_date
9134: ,p_background_check_status in varchar2 default hr_api.g_varchar2
9135: ,p_background_date_check in date default hr_api.g_date
9136: ,p_benefit_group_id in number default hr_api.g_number
9137: ,p_blood_type in varchar2 default hr_api.g_varchar2
9138: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
9139: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
9140: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
9141: ,p_date_employee_data_verified in date default hr_api.g_date
9142: ,p_date_of_death in date default hr_api.g_date
9135: ,p_background_date_check in date default hr_api.g_date
9136: ,p_benefit_group_id in number default hr_api.g_number
9137: ,p_blood_type in varchar2 default hr_api.g_varchar2
9138: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
9139: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
9140: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
9141: ,p_date_employee_data_verified in date default hr_api.g_date
9142: ,p_date_of_death in date default hr_api.g_date
9143: ,p_dpdnt_adoption_date in date default hr_api.g_date
9136: ,p_benefit_group_id in number default hr_api.g_number
9137: ,p_blood_type in varchar2 default hr_api.g_varchar2
9138: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
9139: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
9140: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
9141: ,p_date_employee_data_verified in date default hr_api.g_date
9142: ,p_date_of_death in date default hr_api.g_date
9143: ,p_dpdnt_adoption_date in date default hr_api.g_date
9144: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
9137: ,p_blood_type in varchar2 default hr_api.g_varchar2
9138: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
9139: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
9140: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
9141: ,p_date_employee_data_verified in date default hr_api.g_date
9142: ,p_date_of_death in date default hr_api.g_date
9143: ,p_dpdnt_adoption_date in date default hr_api.g_date
9144: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
9145: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
9138: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
9139: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
9140: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
9141: ,p_date_employee_data_verified in date default hr_api.g_date
9142: ,p_date_of_death in date default hr_api.g_date
9143: ,p_dpdnt_adoption_date in date default hr_api.g_date
9144: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
9145: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
9146: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
9139: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
9140: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
9141: ,p_date_employee_data_verified in date default hr_api.g_date
9142: ,p_date_of_death in date default hr_api.g_date
9143: ,p_dpdnt_adoption_date in date default hr_api.g_date
9144: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
9145: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
9146: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
9147: ,p_fte_capacity in number default hr_api.g_number
9140: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
9141: ,p_date_employee_data_verified in date default hr_api.g_date
9142: ,p_date_of_death in date default hr_api.g_date
9143: ,p_dpdnt_adoption_date in date default hr_api.g_date
9144: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
9145: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
9146: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
9147: ,p_fte_capacity in number default hr_api.g_number
9148: ,p_global_person_id in varchar2 default hr_api.g_varchar2
9141: ,p_date_employee_data_verified in date default hr_api.g_date
9142: ,p_date_of_death in date default hr_api.g_date
9143: ,p_dpdnt_adoption_date in date default hr_api.g_date
9144: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
9145: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
9146: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
9147: ,p_fte_capacity in number default hr_api.g_number
9148: ,p_global_person_id in varchar2 default hr_api.g_varchar2
9149: ,p_hold_applicant_date_until in date default hr_api.g_date
9142: ,p_date_of_death in date default hr_api.g_date
9143: ,p_dpdnt_adoption_date in date default hr_api.g_date
9144: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
9145: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
9146: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
9147: ,p_fte_capacity in number default hr_api.g_number
9148: ,p_global_person_id in varchar2 default hr_api.g_varchar2
9149: ,p_hold_applicant_date_until in date default hr_api.g_date
9150: ,p_internal_location in varchar2 default hr_api.g_varchar2
9143: ,p_dpdnt_adoption_date in date default hr_api.g_date
9144: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
9145: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
9146: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
9147: ,p_fte_capacity in number default hr_api.g_number
9148: ,p_global_person_id in varchar2 default hr_api.g_varchar2
9149: ,p_hold_applicant_date_until in date default hr_api.g_date
9150: ,p_internal_location in varchar2 default hr_api.g_varchar2
9151: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
9144: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
9145: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
9146: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
9147: ,p_fte_capacity in number default hr_api.g_number
9148: ,p_global_person_id in varchar2 default hr_api.g_varchar2
9149: ,p_hold_applicant_date_until in date default hr_api.g_date
9150: ,p_internal_location in varchar2 default hr_api.g_varchar2
9151: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
9152: ,p_last_medical_test_date in date default hr_api.g_date
9145: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
9146: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
9147: ,p_fte_capacity in number default hr_api.g_number
9148: ,p_global_person_id in varchar2 default hr_api.g_varchar2
9149: ,p_hold_applicant_date_until in date default hr_api.g_date
9150: ,p_internal_location in varchar2 default hr_api.g_varchar2
9151: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
9152: ,p_last_medical_test_date in date default hr_api.g_date
9153: ,p_mailstop in varchar2 default hr_api.g_varchar2
9146: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
9147: ,p_fte_capacity in number default hr_api.g_number
9148: ,p_global_person_id in varchar2 default hr_api.g_varchar2
9149: ,p_hold_applicant_date_until in date default hr_api.g_date
9150: ,p_internal_location in varchar2 default hr_api.g_varchar2
9151: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
9152: ,p_last_medical_test_date in date default hr_api.g_date
9153: ,p_mailstop in varchar2 default hr_api.g_varchar2
9154: ,p_office_number in varchar2 default hr_api.g_varchar2
9147: ,p_fte_capacity in number default hr_api.g_number
9148: ,p_global_person_id in varchar2 default hr_api.g_varchar2
9149: ,p_hold_applicant_date_until in date default hr_api.g_date
9150: ,p_internal_location in varchar2 default hr_api.g_varchar2
9151: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
9152: ,p_last_medical_test_date in date default hr_api.g_date
9153: ,p_mailstop in varchar2 default hr_api.g_varchar2
9154: ,p_office_number in varchar2 default hr_api.g_varchar2
9155: ,p_on_military_service in varchar2 default hr_api.g_varchar2
9148: ,p_global_person_id in varchar2 default hr_api.g_varchar2
9149: ,p_hold_applicant_date_until in date default hr_api.g_date
9150: ,p_internal_location in varchar2 default hr_api.g_varchar2
9151: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
9152: ,p_last_medical_test_date in date default hr_api.g_date
9153: ,p_mailstop in varchar2 default hr_api.g_varchar2
9154: ,p_office_number in varchar2 default hr_api.g_varchar2
9155: ,p_on_military_service in varchar2 default hr_api.g_varchar2
9156: ,p_original_date_of_hire in date default hr_api.g_date
9149: ,p_hold_applicant_date_until in date default hr_api.g_date
9150: ,p_internal_location in varchar2 default hr_api.g_varchar2
9151: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
9152: ,p_last_medical_test_date in date default hr_api.g_date
9153: ,p_mailstop in varchar2 default hr_api.g_varchar2
9154: ,p_office_number in varchar2 default hr_api.g_varchar2
9155: ,p_on_military_service in varchar2 default hr_api.g_varchar2
9156: ,p_original_date_of_hire in date default hr_api.g_date
9157: ,p_projected_start_date in date default hr_api.g_date
9150: ,p_internal_location in varchar2 default hr_api.g_varchar2
9151: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
9152: ,p_last_medical_test_date in date default hr_api.g_date
9153: ,p_mailstop in varchar2 default hr_api.g_varchar2
9154: ,p_office_number in varchar2 default hr_api.g_varchar2
9155: ,p_on_military_service in varchar2 default hr_api.g_varchar2
9156: ,p_original_date_of_hire in date default hr_api.g_date
9157: ,p_projected_start_date in date default hr_api.g_date
9158: ,p_receipt_of_death_cert_date in date default hr_api.g_date
9151: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
9152: ,p_last_medical_test_date in date default hr_api.g_date
9153: ,p_mailstop in varchar2 default hr_api.g_varchar2
9154: ,p_office_number in varchar2 default hr_api.g_varchar2
9155: ,p_on_military_service in varchar2 default hr_api.g_varchar2
9156: ,p_original_date_of_hire in date default hr_api.g_date
9157: ,p_projected_start_date in date default hr_api.g_date
9158: ,p_receipt_of_death_cert_date in date default hr_api.g_date
9159: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
9152: ,p_last_medical_test_date in date default hr_api.g_date
9153: ,p_mailstop in varchar2 default hr_api.g_varchar2
9154: ,p_office_number in varchar2 default hr_api.g_varchar2
9155: ,p_on_military_service in varchar2 default hr_api.g_varchar2
9156: ,p_original_date_of_hire in date default hr_api.g_date
9157: ,p_projected_start_date in date default hr_api.g_date
9158: ,p_receipt_of_death_cert_date in date default hr_api.g_date
9159: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
9160: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
9153: ,p_mailstop in varchar2 default hr_api.g_varchar2
9154: ,p_office_number in varchar2 default hr_api.g_varchar2
9155: ,p_on_military_service in varchar2 default hr_api.g_varchar2
9156: ,p_original_date_of_hire in date default hr_api.g_date
9157: ,p_projected_start_date in date default hr_api.g_date
9158: ,p_receipt_of_death_cert_date in date default hr_api.g_date
9159: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
9160: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
9161: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
9154: ,p_office_number in varchar2 default hr_api.g_varchar2
9155: ,p_on_military_service in varchar2 default hr_api.g_varchar2
9156: ,p_original_date_of_hire in date default hr_api.g_date
9157: ,p_projected_start_date in date default hr_api.g_date
9158: ,p_receipt_of_death_cert_date in date default hr_api.g_date
9159: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
9160: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
9161: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
9162: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
9155: ,p_on_military_service in varchar2 default hr_api.g_varchar2
9156: ,p_original_date_of_hire in date default hr_api.g_date
9157: ,p_projected_start_date in date default hr_api.g_date
9158: ,p_receipt_of_death_cert_date in date default hr_api.g_date
9159: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
9160: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
9161: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
9162: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
9163: ,p_resume_exists in varchar2 default hr_api.g_varchar2
9156: ,p_original_date_of_hire in date default hr_api.g_date
9157: ,p_projected_start_date in date default hr_api.g_date
9158: ,p_receipt_of_death_cert_date in date default hr_api.g_date
9159: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
9160: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
9161: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
9162: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
9163: ,p_resume_exists in varchar2 default hr_api.g_varchar2
9164: ,p_resume_last_updated in date default hr_api.g_date
9157: ,p_projected_start_date in date default hr_api.g_date
9158: ,p_receipt_of_death_cert_date in date default hr_api.g_date
9159: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
9160: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
9161: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
9162: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
9163: ,p_resume_exists in varchar2 default hr_api.g_varchar2
9164: ,p_resume_last_updated in date default hr_api.g_date
9165: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
9158: ,p_receipt_of_death_cert_date in date default hr_api.g_date
9159: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
9160: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
9161: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
9162: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
9163: ,p_resume_exists in varchar2 default hr_api.g_varchar2
9164: ,p_resume_last_updated in date default hr_api.g_date
9165: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
9166: ,p_student_status in varchar2 default hr_api.g_varchar2
9159: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
9160: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
9161: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
9162: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
9163: ,p_resume_exists in varchar2 default hr_api.g_varchar2
9164: ,p_resume_last_updated in date default hr_api.g_date
9165: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
9166: ,p_student_status in varchar2 default hr_api.g_varchar2
9167: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
9160: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
9161: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
9162: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
9163: ,p_resume_exists in varchar2 default hr_api.g_varchar2
9164: ,p_resume_last_updated in date default hr_api.g_date
9165: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
9166: ,p_student_status in varchar2 default hr_api.g_varchar2
9167: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
9168: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
9161: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
9162: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
9163: ,p_resume_exists in varchar2 default hr_api.g_varchar2
9164: ,p_resume_last_updated in date default hr_api.g_date
9165: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
9166: ,p_student_status in varchar2 default hr_api.g_varchar2
9167: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
9168: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
9169: ,p_vendor_id in number default hr_api.g_number
9162: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
9163: ,p_resume_exists in varchar2 default hr_api.g_varchar2
9164: ,p_resume_last_updated in date default hr_api.g_date
9165: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
9166: ,p_student_status in varchar2 default hr_api.g_varchar2
9167: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
9168: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
9169: ,p_vendor_id in number default hr_api.g_number
9170: ,p_work_schedule in varchar2 default hr_api.g_varchar2 )
9163: ,p_resume_exists in varchar2 default hr_api.g_varchar2
9164: ,p_resume_last_updated in date default hr_api.g_date
9165: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
9166: ,p_student_status in varchar2 default hr_api.g_varchar2
9167: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
9168: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
9169: ,p_vendor_id in number default hr_api.g_number
9170: ,p_work_schedule in varchar2 default hr_api.g_varchar2 )
9171: return boolean is
9164: ,p_resume_last_updated in date default hr_api.g_date
9165: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
9166: ,p_student_status in varchar2 default hr_api.g_varchar2
9167: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
9168: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
9169: ,p_vendor_id in number default hr_api.g_number
9170: ,p_work_schedule in varchar2 default hr_api.g_varchar2 )
9171: return boolean is
9172: --
9165: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
9166: ,p_student_status in varchar2 default hr_api.g_varchar2
9167: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
9168: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
9169: ,p_vendor_id in number default hr_api.g_number
9170: ,p_work_schedule in varchar2 default hr_api.g_varchar2 )
9171: return boolean is
9172: --
9173: l_rec_changed boolean default FALSE;
9166: ,p_student_status in varchar2 default hr_api.g_varchar2
9167: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
9168: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
9169: ,p_vendor_id in number default hr_api.g_number
9170: ,p_work_schedule in varchar2 default hr_api.g_varchar2 )
9171: return boolean is
9172: --
9173: l_rec_changed boolean default FALSE;
9174: l_proc varchar2(72) := g_package||'is_con_rec_changed';
9175:
9176: BEGIN
9177: --
9178: hr_utility.set_location('Entering:'||l_proc, 5);
9179: IF p_adjusted_svc_date <> hr_api.g_date
9180: THEN
9181: l_rec_changed := TRUE;
9182: goto finish;
9183: END IF;
9182: goto finish;
9183: END IF;
9184: --
9185: --
9186: IF p_applicant_number <> hr_api.g_varchar2
9187: THEN
9188: l_rec_changed := TRUE;
9189: goto finish;
9190: END IF;
9189: goto finish;
9190: END IF;
9191: --
9192: --
9193: IF p_background_check_status <> hr_api.g_varchar2
9194: THEN
9195: l_rec_changed := TRUE;
9196: goto finish;
9197: END IF;
9196: goto finish;
9197: END IF;
9198: --
9199: --
9200: IF p_background_date_check <> hr_api.g_date
9201: THEN
9202: l_rec_changed := TRUE;
9203: goto finish;
9204: END IF;
9203: goto finish;
9204: END IF;
9205: --
9206: --
9207: IF p_benefit_group_id <> hr_api.g_number
9208: THEN
9209: l_rec_changed := TRUE;
9210: goto finish;
9211: END IF;
9210: goto finish;
9211: END IF;
9212: --
9213: --
9214: IF p_blood_type <> hr_api.g_varchar2
9215: THEN
9216: l_rec_changed := TRUE;
9217: goto finish;
9218: END IF;
9217: goto finish;
9218: END IF;
9219: --
9220: --
9221: IF p_coord_ben_med_pln_no <> hr_api.g_varchar2
9222: THEN
9223: l_rec_changed := TRUE;
9224: goto finish;
9225: END IF;
9224: goto finish;
9225: END IF;
9226: --
9227: --
9228: IF p_coord_ben_no_cvg_flag <> hr_api.g_varchar2
9229: THEN
9230: l_rec_changed := TRUE;
9231: goto finish;
9232: END IF;
9231: goto finish;
9232: END IF;
9233: --
9234: --
9235: IF p_country_of_birth <> hr_api.g_varchar2
9236: THEN
9237: l_rec_changed := TRUE;
9238: goto finish;
9239: END IF;
9238: goto finish;
9239: END IF;
9240: --
9241: --
9242: IF p_date_employee_data_verified <> hr_api.g_date
9243: THEN
9244: l_rec_changed := TRUE;
9245: goto finish;
9246: END IF;
9245: goto finish;
9246: END IF;
9247: --
9248: --
9249: IF p_date_of_death <> hr_api.g_date
9250: THEN
9251: l_rec_changed := TRUE;
9252: goto finish;
9253: END IF;
9252: goto finish;
9253: END IF;
9254: --
9255: --
9256: IF p_dpdnt_adoption_date <> hr_api.g_date
9257: THEN
9258: l_rec_changed := TRUE;
9259: goto finish;
9260: END IF;
9259: goto finish;
9260: END IF;
9261: --
9262: --
9263: IF p_dpdnt_vlntry_svce_flag <> hr_api.g_varchar2
9264: THEN
9265: l_rec_changed := TRUE;
9266: goto finish;
9267: END IF;
9266: goto finish;
9267: END IF;
9268: --
9269: --
9270: IF p_expense_check_send_to_addres <> hr_api.g_varchar2
9271: THEN
9272: l_rec_changed := TRUE;
9273: goto finish;
9274: END IF;
9273: goto finish;
9274: END IF;
9275: --
9276: --
9277: IF p_fast_path_employee <> hr_api.g_varchar2
9278: THEN
9279: l_rec_changed := TRUE;
9280: goto finish;
9281: END IF;
9280: goto finish;
9281: END IF;
9282: --
9283: --
9284: IF p_fte_capacity <> hr_api.g_number
9285: THEN
9286: l_rec_changed := TRUE;
9287: goto finish;
9288: END IF;
9287: goto finish;
9288: END IF;
9289: --
9290: --
9291: IF p_global_person_id <> hr_api.g_varchar2
9292: THEN
9293: l_rec_changed := TRUE;
9294: goto finish;
9295: END IF;
9294: goto finish;
9295: END IF;
9296: --
9297: --
9298: IF p_hold_applicant_date_until <> hr_api.g_date
9299: THEN
9300: l_rec_changed := TRUE;
9301: goto finish;
9302: END IF;
9301: goto finish;
9302: END IF;
9303: --
9304: --
9305: IF p_internal_location <> hr_api.g_varchar2
9306: THEN
9307: l_rec_changed := TRUE;
9308: goto finish;
9309: END IF;
9308: goto finish;
9309: END IF;
9310: --
9311: --
9312: IF p_last_medical_test_by <> hr_api.g_varchar2
9313: THEN
9314: l_rec_changed := TRUE;
9315: goto finish;
9316: END IF;
9315: goto finish;
9316: END IF;
9317: --
9318: --
9319: IF p_last_medical_test_date <> hr_api.g_date
9320: THEN
9321: l_rec_changed := TRUE;
9322: goto finish;
9323: END IF;
9322: goto finish;
9323: END IF;
9324: --
9325: --
9326: IF p_mailstop <> hr_api.g_varchar2
9327: THEN
9328: l_rec_changed := TRUE;
9329: goto finish;
9330: END IF;
9329: goto finish;
9330: END IF;
9331: --
9332: --
9333: IF p_office_number <> hr_api.g_varchar2
9334: THEN
9335: l_rec_changed := TRUE;
9336: goto finish;
9337: END IF;
9336: goto finish;
9337: END IF;
9338: --
9339: --
9340: IF p_on_military_service <> hr_api.g_varchar2
9341: THEN
9342: l_rec_changed := TRUE;
9343: goto finish;
9344: END IF;
9343: goto finish;
9344: END IF;
9345: --
9346: --
9347: IF p_original_date_of_hire <> hr_api.g_date
9348: THEN
9349: l_rec_changed := TRUE;
9350: goto finish;
9351: END IF;
9350: goto finish;
9351: END IF;
9352: --
9353: --
9354: IF p_projected_start_date <> hr_api.g_date
9355: THEN
9356: l_rec_changed := TRUE;
9357: goto finish;
9358: END IF;
9357: goto finish;
9358: END IF;
9359: --
9360: --
9361: IF p_receipt_of_death_cert_date <> hr_api.g_date
9362: THEN
9363: l_rec_changed := TRUE;
9364: goto finish;
9365: END IF;
9364: goto finish;
9365: END IF;
9366: --
9367: --
9368: IF p_region_of_birth <> hr_api.g_varchar2
9369: THEN
9370: l_rec_changed := TRUE;
9371: goto finish;
9372: END IF;
9371: goto finish;
9372: END IF;
9373: --
9374: --
9375: IF p_rehire_authorizor <> hr_api.g_varchar2
9376: THEN
9377: l_rec_changed := TRUE;
9378: goto finish;
9379: END IF;
9378: goto finish;
9379: END IF;
9380: --
9381: --
9382: IF p_rehire_recommendation <> hr_api.g_varchar2
9383: THEN
9384: l_rec_changed := TRUE;
9385: goto finish;
9386: END IF;
9385: goto finish;
9386: END IF;
9387: --
9388: --
9389: IF p_rehire_reason <> hr_api.g_varchar2
9390: THEN
9391: l_rec_changed := TRUE;
9392: goto finish;
9393: END IF;
9392: goto finish;
9393: END IF;
9394: --
9395: --
9396: IF p_resume_exists <> hr_api.g_varchar2
9397: THEN
9398: l_rec_changed := TRUE;
9399: goto finish;
9400: END IF;
9399: goto finish;
9400: END IF;
9401: --
9402: --
9403: IF p_resume_last_updated <> hr_api.g_date
9404: THEN
9405: l_rec_changed := TRUE;
9406: goto finish;
9407: END IF;
9406: goto finish;
9407: END IF;
9408: --
9409: --
9410: IF p_second_passport_exists <> hr_api.g_varchar2
9411: THEN
9412: l_rec_changed := TRUE;
9413: goto finish;
9414: END IF;
9413: goto finish;
9414: END IF;
9415: --
9416: --
9417: IF p_student_status <> hr_api.g_varchar2
9418: THEN
9419: l_rec_changed := TRUE;
9420: goto finish;
9421: END IF;
9420: goto finish;
9421: END IF;
9422: --
9423: --
9424: IF p_town_of_birth <> hr_api.g_varchar2
9425: THEN
9426: l_rec_changed := TRUE;
9427: goto finish;
9428: END IF;
9427: goto finish;
9428: END IF;
9429: --
9430: --
9431: IF p_uses_tobacco_flag <> hr_api.g_varchar2
9432: THEN
9433: l_rec_changed := TRUE;
9434: goto finish;
9435: END IF;
9434: goto finish;
9435: END IF;
9436: --
9437: --
9438: IF p_vendor_id <> hr_api.g_number
9439: THEN
9440: l_rec_changed := TRUE;
9441: goto finish;
9442: END IF;
9441: goto finish;
9442: END IF;
9443: --
9444: --
9445: IF p_work_schedule <> hr_api.g_varchar2
9446: THEN
9447: l_rec_changed := TRUE;
9448: goto finish;
9449: END IF;
10680: -- For processing the update_person_api
10681: hr_person_api.update_person (
10682: p_validate => p_validate
10683: ,p_effective_date => l_effective_date
10684: ,p_datetrack_update_mode => hr_api.g_correction
10685: -- 9999 p_datetrack_update_mode
10686: ,p_person_id => L_PER_PERSON_ID
10687: ,p_object_version_number => L_PER_OBJECT_VERSION_NUMBER
10688: ,p_employee_number => l_employee_number
14730: ,P_DATE_START in date
14731: ,p_transaction_step_id IN NUMBER
14732: ,p_contact_person_id in number
14733: ,p_person_id in number) is
14734: l_date_start date := hr_api.g_date;
14735: l_pds_date_start date;
14736: l_cont_start_date date;
14737: l_proc varchar2(72) := g_package||'will_address_be_changed';
14738: l_cov_date_start date;
14744: and date_from = c_date_from
14745: and primary_flag='Y';
14746:
14747: cursor csr_contact_api(c_transaction_step_id number) is
14748: select 'Y' from hr_api_transaction_steps where transaction_id =
14749: (select transaction_id from hr_api_transaction_steps where transaction_step_id =
14750: c_transaction_step_id) and api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';
14751:
14752: begin
14745: and primary_flag='Y';
14746:
14747: cursor csr_contact_api(c_transaction_step_id number) is
14748: select 'Y' from hr_api_transaction_steps where transaction_id =
14749: (select transaction_id from hr_api_transaction_steps where transaction_step_id =
14750: c_transaction_step_id) and api_name='HR_PROCESS_ADDRESS_SS.PROCESS_API';
14751:
14752: begin
14753: hr_utility.set_location('Entering:'||l_proc, 5);
14757: if p_contact_relationship_id is not null then
14758: select date_start into l_date_start from per_contact_relationships where
14759: contact_relationship_id = p_contact_relationship_id;
14760: end if;
14761: if (p_date_start < l_date_start or l_date_start = hr_api.g_date) then
14762: select max(date_start) into l_pds_date_start from per_periods_of_service
14763: where person_id = p_person_id;
14764: if l_pds_date_start > p_date_start then
14765: l_cov_date_start := l_pds_date_start;
14818: PROCEDURE end_contact_relationship
14819: (p_validate in number default 0
14820: ,p_effective_date in date
14821: ,p_contact_relationship_id in number
14822: ,p_contact_type in varchar2 default hr_api.g_varchar2
14823: ,p_comments in long default hr_api.g_varchar2
14824: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
14825: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
14826: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
14819: (p_validate in number default 0
14820: ,p_effective_date in date
14821: ,p_contact_relationship_id in number
14822: ,p_contact_type in varchar2 default hr_api.g_varchar2
14823: ,p_comments in long default hr_api.g_varchar2
14824: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
14825: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
14826: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
14827: ,p_date_start in date default hr_api.g_date
14820: ,p_effective_date in date
14821: ,p_contact_relationship_id in number
14822: ,p_contact_type in varchar2 default hr_api.g_varchar2
14823: ,p_comments in long default hr_api.g_varchar2
14824: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
14825: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
14826: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
14827: ,p_date_start in date default hr_api.g_date
14828: ,p_start_life_reason_id in number default hr_api.g_number
14821: ,p_contact_relationship_id in number
14822: ,p_contact_type in varchar2 default hr_api.g_varchar2
14823: ,p_comments in long default hr_api.g_varchar2
14824: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
14825: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
14826: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
14827: ,p_date_start in date default hr_api.g_date
14828: ,p_start_life_reason_id in number default hr_api.g_number
14829: ,p_date_end in date default hr_api.g_date
14822: ,p_contact_type in varchar2 default hr_api.g_varchar2
14823: ,p_comments in long default hr_api.g_varchar2
14824: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
14825: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
14826: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
14827: ,p_date_start in date default hr_api.g_date
14828: ,p_start_life_reason_id in number default hr_api.g_number
14829: ,p_date_end in date default hr_api.g_date
14830: ,p_end_life_reason_id in number default hr_api.g_number
14823: ,p_comments in long default hr_api.g_varchar2
14824: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
14825: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
14826: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
14827: ,p_date_start in date default hr_api.g_date
14828: ,p_start_life_reason_id in number default hr_api.g_number
14829: ,p_date_end in date default hr_api.g_date
14830: ,p_end_life_reason_id in number default hr_api.g_number
14831: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
14824: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
14825: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
14826: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
14827: ,p_date_start in date default hr_api.g_date
14828: ,p_start_life_reason_id in number default hr_api.g_number
14829: ,p_date_end in date default hr_api.g_date
14830: ,p_end_life_reason_id in number default hr_api.g_number
14831: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
14832: ,p_personal_flag in varchar2 default hr_api.g_varchar2
14825: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
14826: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
14827: ,p_date_start in date default hr_api.g_date
14828: ,p_start_life_reason_id in number default hr_api.g_number
14829: ,p_date_end in date default hr_api.g_date
14830: ,p_end_life_reason_id in number default hr_api.g_number
14831: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
14832: ,p_personal_flag in varchar2 default hr_api.g_varchar2
14833: ,p_sequence_number in number default hr_api.g_number
14826: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
14827: ,p_date_start in date default hr_api.g_date
14828: ,p_start_life_reason_id in number default hr_api.g_number
14829: ,p_date_end in date default hr_api.g_date
14830: ,p_end_life_reason_id in number default hr_api.g_number
14831: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
14832: ,p_personal_flag in varchar2 default hr_api.g_varchar2
14833: ,p_sequence_number in number default hr_api.g_number
14834: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
14827: ,p_date_start in date default hr_api.g_date
14828: ,p_start_life_reason_id in number default hr_api.g_number
14829: ,p_date_end in date default hr_api.g_date
14830: ,p_end_life_reason_id in number default hr_api.g_number
14831: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
14832: ,p_personal_flag in varchar2 default hr_api.g_varchar2
14833: ,p_sequence_number in number default hr_api.g_number
14834: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
14835: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
14828: ,p_start_life_reason_id in number default hr_api.g_number
14829: ,p_date_end in date default hr_api.g_date
14830: ,p_end_life_reason_id in number default hr_api.g_number
14831: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
14832: ,p_personal_flag in varchar2 default hr_api.g_varchar2
14833: ,p_sequence_number in number default hr_api.g_number
14834: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
14835: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
14836: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
14829: ,p_date_end in date default hr_api.g_date
14830: ,p_end_life_reason_id in number default hr_api.g_number
14831: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
14832: ,p_personal_flag in varchar2 default hr_api.g_varchar2
14833: ,p_sequence_number in number default hr_api.g_number
14834: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
14835: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
14836: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
14837: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
14830: ,p_end_life_reason_id in number default hr_api.g_number
14831: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
14832: ,p_personal_flag in varchar2 default hr_api.g_varchar2
14833: ,p_sequence_number in number default hr_api.g_number
14834: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
14835: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
14836: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
14837: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
14838: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
14831: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
14832: ,p_personal_flag in varchar2 default hr_api.g_varchar2
14833: ,p_sequence_number in number default hr_api.g_number
14834: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
14835: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
14836: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
14837: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
14838: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
14839: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
14832: ,p_personal_flag in varchar2 default hr_api.g_varchar2
14833: ,p_sequence_number in number default hr_api.g_number
14834: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
14835: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
14836: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
14837: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
14838: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
14839: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
14840: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
14833: ,p_sequence_number in number default hr_api.g_number
14834: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
14835: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
14836: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
14837: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
14838: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
14839: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
14840: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
14841: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
14834: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
14835: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
14836: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
14837: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
14838: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
14839: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
14840: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
14841: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
14842: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
14835: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
14836: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
14837: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
14838: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
14839: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
14840: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
14841: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
14842: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
14843: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
14836: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
14837: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
14838: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
14839: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
14840: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
14841: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
14842: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
14843: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
14844: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
14837: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
14838: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
14839: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
14840: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
14841: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
14842: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
14843: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
14844: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
14845: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
14838: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
14839: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
14840: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
14841: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
14842: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
14843: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
14844: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
14845: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
14846: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
14839: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
14840: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
14841: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
14842: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
14843: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
14844: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
14845: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
14846: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
14847: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
14840: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
14841: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
14842: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
14843: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
14844: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
14845: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
14846: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
14847: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
14848: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
14841: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
14842: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
14843: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
14844: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
14845: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
14846: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
14847: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
14848: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
14849: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
14842: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
14843: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
14844: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
14845: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
14846: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
14847: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
14848: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
14849: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
14850: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
14843: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
14844: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
14845: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
14846: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
14847: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
14848: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
14849: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
14850: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
14851: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
14844: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
14845: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
14846: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
14847: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
14848: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
14849: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
14850: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
14851: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
14852: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
14845: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
14846: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
14847: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
14848: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
14849: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
14850: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
14851: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
14852: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
14853: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
14846: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
14847: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
14848: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
14849: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
14850: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
14851: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
14852: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
14853: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
14854: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
14847: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
14848: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
14849: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
14850: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
14851: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
14852: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
14853: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
14854: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
14855: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
14848: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
14849: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
14850: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
14851: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
14852: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
14853: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
14854: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
14855: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
14856: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
14849: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
14850: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
14851: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
14852: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
14853: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
14854: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
14855: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
14856: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
14857: ,p_person_id in number
14850: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
14851: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
14852: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
14853: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
14854: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
14855: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
14856: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
14857: ,p_person_id in number
14858: ,p_object_version_number in out nocopy number
14851: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
14852: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
14853: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
14854: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
14855: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
14856: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
14857: ,p_person_id in number
14858: ,p_object_version_number in out nocopy number
14859: ,p_item_type in varchar2
14852: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
14853: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
14854: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
14855: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
14856: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
14857: ,p_person_id in number
14858: ,p_object_version_number in out nocopy number
14859: ,p_item_type in varchar2
14860: ,p_item_key in varchar2
14860: ,p_item_key in varchar2
14861: ,p_activity_id in number
14862: ,p_action in varchar2
14863: ,p_process_section_name in varchar2
14864: ,p_review_page_region_code in varchar2 default hr_api.g_varchar2
14865: ,p_save_mode in varchar2 default null
14866: -- SFL needs it bug #2082333
14867: ,p_login_person_id in number
14868: ,p_contact_person_id in number
14882: and trunc(sysdate) between nvl(date_start, trunc(sysdate))
14883: and nvl(date_end, trunc(sysdate));
14884:
14885: l_transaction_table hr_transaction_ss.transaction_table;
14886: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
14887: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
14888: l_old_ovn number;
14889: l_old_contact_relationship_id number;
14890: l_count INTEGER := 0;
14883: and nvl(date_end, trunc(sysdate));
14884:
14885: l_transaction_table hr_transaction_ss.transaction_table;
14886: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
14887: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
14888: l_old_ovn number;
14889: l_old_contact_relationship_id number;
14890: l_count INTEGER := 0;
14891: l_transaction_id number default null;
16779: begin
16780: hr_utility.set_location('if p_person_id is not null then:'||l_proc, 15);
16781: select nvl(max(hats1.transaction_step_id),0)
16782: into l_validate_g_per_step_id
16783: from hr_api_transaction_steps hats1
16784: where hats1.item_type = 'HRSSA'
16785: and hats1.item_key = p_item_key
16786: and hats1.api_name in( 'HR_PROCESS_PERSON_SS.PROCESS_API', 'BEN_PROCESS_COBRA_PERSON_SS.PROCESS_API');
16787: