DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on HR_API

Line 220: pen.effective_end_date = hr_api.g_eot and

216: from ben_prtt_enrt_rslt_f pen
217: where pen.person_id=p_person_id and
218: pen.sspndd_flag='N' and
219: pen.prtt_enrt_rslt_stat_cd is null and
220: pen.effective_end_date = hr_api.g_eot and
221: nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)-1 <=
222: pen.enrt_cvg_thru_dt and
223: pen.enrt_cvg_strt_dt < pen.effective_end_date
224: and pen.pl_id = l_pl_id

Line 235: pen.effective_end_date = hr_api.g_eot and

231: from ben_prtt_enrt_rslt_f pen
232: where pen.person_id=p_person_id and
233: pen.sspndd_flag='N' and
234: pen.prtt_enrt_rslt_stat_cd is null and
235: pen.effective_end_date = hr_api.g_eot and
236: nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)-1 <=
237: pen.enrt_cvg_thru_dt and
238: pen.enrt_cvg_strt_dt < pen.effective_end_date and
239: pen.oipl_id=l_oipl_id

Line 258: between pdp.cvg_strt_dt and nvl(pdp.cvg_thru_dt,hr_api.g_eot)

254: and pdp.dpnt_person_id = p_contact_person_id
255: and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)
256: between pdp.effective_start_date and pdp.effective_end_date
257: and nvl(l_per_in_ler.lf_evt_ocrd_dt, p_effective_date)
258: between pdp.cvg_strt_dt and nvl(pdp.cvg_thru_dt,hr_api.g_eot)
259: and pil.per_in_ler_id=pdp.per_in_ler_id
260: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
261: --
262:

Line 388: ,p_ELIG_THRU_DT => hr_api.g_eot

384: ,p_BUSINESS_GROUP_ID => epe.business_group_id
385: ,p_elig_per_elctbl_chc_id => epe.elig_per_elctbl_chc_id
386: ,p_DPNT_PERSON_ID => p_contact_person_id
387: ,p_ELIG_STRT_DT => nvl(l_lf_evt_ocrd_dt,p_effective_date)
388: ,p_ELIG_THRU_DT => hr_api.g_eot
389: ,p_elig_per_id => l_elig_per_id
390: ,p_elig_per_opt_id => l_elig_per_opt_id
391: ,p_OBJECT_VERSION_NUMBER => l_object_version_number
392: ,p_ovrdn_flag => 'N'

Line 420: ,p_elig_thru_dt => hr_api.g_eot

416: ben_elig_dpnt_api.update_elig_dpnt(
417: p_elig_dpnt_id => l_elig_dpnt.elig_dpnt_id
418: ,p_object_version_number => l_elig_dpnt.object_version_number
419: ,p_effective_date => p_effective_date
420: ,p_elig_thru_dt => hr_api.g_eot
421: ,p_dpnt_inelig_flag => 'N'
422: ,p_inelg_rsn_cd => null
423: );
424: --

Line 580: l_datetrack_mode := hr_api.g_update_override;

576: p_update_change_insert => l_update_change_insert);
577: --
578: if l_update_override then
579: --
580: l_datetrack_mode := hr_api.g_update_override;
581: --
582: elsif l_update then
583: --
584: l_datetrack_mode := hr_api.g_update;

Line 584: l_datetrack_mode := hr_api.g_update;

580: l_datetrack_mode := hr_api.g_update_override;
581: --
582: elsif l_update then
583: --
584: l_datetrack_mode := hr_api.g_update;
585: --
586: else
587: --
588: l_datetrack_mode := hr_api.g_correction;

Line 588: l_datetrack_mode := hr_api.g_correction;

584: l_datetrack_mode := hr_api.g_update;
585: --
586: else
587: --
588: l_datetrack_mode := hr_api.g_correction;
589: --
590: end if;
591:
592: if l_cvg_end_dt is null then

Line 594: l_cvg_end_dt := hr_api.g_eot;

590: end if;
591:
592: if l_cvg_end_dt is null then
593: --
594: l_cvg_end_dt := hr_api.g_eot;
595: --
596: end if;
597: --
598: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt

Line 1323: ,p_contact_type in varchar2 default hr_api.g_varchar2

1319: procedure update_contact_w
1320: (p_validate in varchar2 default 'N'
1321: ,p_effective_date in date
1322: ,p_contact_relationship_id in number
1323: ,p_contact_type in varchar2 default hr_api.g_varchar2
1324: ,p_comments in long default hr_api.g_varchar2
1325: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1326: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2

Line 1324: ,p_comments in long default hr_api.g_varchar2

1320: (p_validate in varchar2 default 'N'
1321: ,p_effective_date in date
1322: ,p_contact_relationship_id in number
1323: ,p_contact_type in varchar2 default hr_api.g_varchar2
1324: ,p_comments in long default hr_api.g_varchar2
1325: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1326: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1328: ,p_date_start in date default hr_api.g_date

Line 1325: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2

1321: ,p_effective_date in date
1322: ,p_contact_relationship_id in number
1323: ,p_contact_type in varchar2 default hr_api.g_varchar2
1324: ,p_comments in long default hr_api.g_varchar2
1325: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1326: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1328: ,p_date_start in date default hr_api.g_date
1329: ,p_start_life_reason_id in number default hr_api.g_number

Line 1326: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2

1322: ,p_contact_relationship_id in number
1323: ,p_contact_type in varchar2 default hr_api.g_varchar2
1324: ,p_comments in long default hr_api.g_varchar2
1325: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1326: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1328: ,p_date_start in date default hr_api.g_date
1329: ,p_start_life_reason_id in number default hr_api.g_number
1330: ,p_date_end in date default hr_api.g_date

Line 1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2

1323: ,p_contact_type in varchar2 default hr_api.g_varchar2
1324: ,p_comments in long default hr_api.g_varchar2
1325: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1326: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1328: ,p_date_start in date default hr_api.g_date
1329: ,p_start_life_reason_id in number default hr_api.g_number
1330: ,p_date_end in date default hr_api.g_date
1331: ,p_end_life_reason_id in number default hr_api.g_number

Line 1328: ,p_date_start in date default hr_api.g_date

1324: ,p_comments in long default hr_api.g_varchar2
1325: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1326: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1328: ,p_date_start in date default hr_api.g_date
1329: ,p_start_life_reason_id in number default hr_api.g_number
1330: ,p_date_end in date default hr_api.g_date
1331: ,p_end_life_reason_id in number default hr_api.g_number
1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2

Line 1329: ,p_start_life_reason_id in number default hr_api.g_number

1325: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
1326: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1328: ,p_date_start in date default hr_api.g_date
1329: ,p_start_life_reason_id in number default hr_api.g_number
1330: ,p_date_end in date default hr_api.g_date
1331: ,p_end_life_reason_id in number default hr_api.g_number
1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2

Line 1330: ,p_date_end in date default hr_api.g_date

1326: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1328: ,p_date_start in date default hr_api.g_date
1329: ,p_start_life_reason_id in number default hr_api.g_number
1330: ,p_date_end in date default hr_api.g_date
1331: ,p_end_life_reason_id in number default hr_api.g_number
1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1334: ,p_sequence_number in number default hr_api.g_number

Line 1331: ,p_end_life_reason_id in number default hr_api.g_number

1327: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
1328: ,p_date_start in date default hr_api.g_date
1329: ,p_start_life_reason_id in number default hr_api.g_number
1330: ,p_date_end in date default hr_api.g_date
1331: ,p_end_life_reason_id in number default hr_api.g_number
1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1334: ,p_sequence_number in number default hr_api.g_number
1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2

Line 1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2

1328: ,p_date_start in date default hr_api.g_date
1329: ,p_start_life_reason_id in number default hr_api.g_number
1330: ,p_date_end in date default hr_api.g_date
1331: ,p_end_life_reason_id in number default hr_api.g_number
1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1334: ,p_sequence_number in number default hr_api.g_number
1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2

Line 1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2

1329: ,p_start_life_reason_id in number default hr_api.g_number
1330: ,p_date_end in date default hr_api.g_date
1331: ,p_end_life_reason_id in number default hr_api.g_number
1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1334: ,p_sequence_number in number default hr_api.g_number
1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2

Line 1334: ,p_sequence_number in number default hr_api.g_number

1330: ,p_date_end in date default hr_api.g_date
1331: ,p_end_life_reason_id in number default hr_api.g_number
1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1334: ,p_sequence_number in number default hr_api.g_number
1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2

Line 1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2

1331: ,p_end_life_reason_id in number default hr_api.g_number
1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1334: ,p_sequence_number in number default hr_api.g_number
1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2

Line 1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2

1332: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1334: ,p_sequence_number in number default hr_api.g_number
1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2

Line 1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2

1333: ,p_personal_flag in varchar2 default hr_api.g_varchar2
1334: ,p_sequence_number in number default hr_api.g_number
1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2

Line 1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2

1334: ,p_sequence_number in number default hr_api.g_number
1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2

Line 1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2

1335: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2

Line 1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2

1336: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2

Line 1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2

1337: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2

Line 1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2

1338: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2

Line 1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2

1339: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2

Line 1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2

1340: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2

Line 1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2

1341: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2

Line 1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2

1342: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2

Line 1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2

1343: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2

Line 1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2

1344: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2

Line 1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2

1345: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2

Line 1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2

1346: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2

Line 1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2

1347: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2

Line 1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2

1348: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2

Line 1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2

1349: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2

Line 1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2

1350: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2

Line 1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2

1351: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2

Line 1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2

1352: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2

Line 1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2

1353: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2

Line 1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2

1354: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2

Line 1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2

1355: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2

Line 1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2

1356: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2

Line 1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2

1357: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2

Line 1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2

1358: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2

Line 1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2

1359: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2

Line 1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2

1360: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2

Line 1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2

1361: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2

Line 1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2

1362: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2

Line 1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2

1363: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2

Line 1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2

1364: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2

Line 1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2

1365: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2

Line 1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2

1366: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2

Line 1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2

1367: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1375: ,p_cont_information17 in varchar2 default hr_api.g_varchar2

Line 1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2

1368: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1375: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1376: ,p_cont_information18 in varchar2 default hr_api.g_varchar2

Line 1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2

1369: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1375: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1376: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1377: ,p_cont_information19 in varchar2 default hr_api.g_varchar2

Line 1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2

1370: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1375: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1376: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1377: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1378: ,p_cont_information20 in varchar2 default hr_api.g_varchar2

Line 1375: ,p_cont_information17 in varchar2 default hr_api.g_varchar2

1371: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1375: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1376: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1377: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1378: ,p_cont_information20 in varchar2 default hr_api.g_varchar2
1379: ,p_object_version_number in out nocopy number

Line 1376: ,p_cont_information18 in varchar2 default hr_api.g_varchar2

1372: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1375: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1376: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1377: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1378: ,p_cont_information20 in varchar2 default hr_api.g_varchar2
1379: ,p_object_version_number in out nocopy number
1380: ,p_return_status out nocopy varchar2

Line 1377: ,p_cont_information19 in varchar2 default hr_api.g_varchar2

1373: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1375: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1376: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1377: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1378: ,p_cont_information20 in varchar2 default hr_api.g_varchar2
1379: ,p_object_version_number in out nocopy number
1380: ,p_return_status out nocopy varchar2
1381: ) IS

Line 1378: ,p_cont_information20 in varchar2 default hr_api.g_varchar2

1374: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1375: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1376: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1377: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1378: ,p_cont_information20 in varchar2 default hr_api.g_varchar2
1379: ,p_object_version_number in out nocopy number
1380: ,p_return_status out nocopy varchar2
1381: ) IS
1382:

Line 1476: ,p_person_type_id in number default hr_api.g_number

1472: ,p_effective_date in date
1473: ,p_datetrack_update_mode in varchar2
1474: ,p_person_id in number
1475: ,p_object_version_number in out NOCOPY number
1476: ,p_person_type_id in number default hr_api.g_number
1477: ,p_last_name in varchar2 default hr_api.g_varchar2
1478: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1479: ,p_comments in varchar2 default hr_api.g_varchar2
1480: ,p_date_employee_data_verified in date default hr_api.g_date

Line 1477: ,p_last_name in varchar2 default hr_api.g_varchar2

1473: ,p_datetrack_update_mode in varchar2
1474: ,p_person_id in number
1475: ,p_object_version_number in out NOCOPY number
1476: ,p_person_type_id in number default hr_api.g_number
1477: ,p_last_name in varchar2 default hr_api.g_varchar2
1478: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1479: ,p_comments in varchar2 default hr_api.g_varchar2
1480: ,p_date_employee_data_verified in date default hr_api.g_date
1481: ,p_date_of_birth in date default hr_api.g_date

Line 1478: ,p_applicant_number in varchar2 default hr_api.g_varchar2

1474: ,p_person_id in number
1475: ,p_object_version_number in out NOCOPY number
1476: ,p_person_type_id in number default hr_api.g_number
1477: ,p_last_name in varchar2 default hr_api.g_varchar2
1478: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1479: ,p_comments in varchar2 default hr_api.g_varchar2
1480: ,p_date_employee_data_verified in date default hr_api.g_date
1481: ,p_date_of_birth in date default hr_api.g_date
1482: ,p_email_address in varchar2 default hr_api.g_varchar2

Line 1479: ,p_comments in varchar2 default hr_api.g_varchar2

1475: ,p_object_version_number in out NOCOPY number
1476: ,p_person_type_id in number default hr_api.g_number
1477: ,p_last_name in varchar2 default hr_api.g_varchar2
1478: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1479: ,p_comments in varchar2 default hr_api.g_varchar2
1480: ,p_date_employee_data_verified in date default hr_api.g_date
1481: ,p_date_of_birth in date default hr_api.g_date
1482: ,p_email_address in varchar2 default hr_api.g_varchar2
1483: ,p_employee_number in out NOCOPY varchar2

Line 1480: ,p_date_employee_data_verified in date default hr_api.g_date

1476: ,p_person_type_id in number default hr_api.g_number
1477: ,p_last_name in varchar2 default hr_api.g_varchar2
1478: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1479: ,p_comments in varchar2 default hr_api.g_varchar2
1480: ,p_date_employee_data_verified in date default hr_api.g_date
1481: ,p_date_of_birth in date default hr_api.g_date
1482: ,p_email_address in varchar2 default hr_api.g_varchar2
1483: ,p_employee_number in out NOCOPY varchar2
1484: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

Line 1481: ,p_date_of_birth in date default hr_api.g_date

1477: ,p_last_name in varchar2 default hr_api.g_varchar2
1478: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1479: ,p_comments in varchar2 default hr_api.g_varchar2
1480: ,p_date_employee_data_verified in date default hr_api.g_date
1481: ,p_date_of_birth in date default hr_api.g_date
1482: ,p_email_address in varchar2 default hr_api.g_varchar2
1483: ,p_employee_number in out NOCOPY varchar2
1484: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1485: ,p_first_name in varchar2 default hr_api.g_varchar2

Line 1482: ,p_email_address in varchar2 default hr_api.g_varchar2

1478: ,p_applicant_number in varchar2 default hr_api.g_varchar2
1479: ,p_comments in varchar2 default hr_api.g_varchar2
1480: ,p_date_employee_data_verified in date default hr_api.g_date
1481: ,p_date_of_birth in date default hr_api.g_date
1482: ,p_email_address in varchar2 default hr_api.g_varchar2
1483: ,p_employee_number in out NOCOPY varchar2
1484: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1485: ,p_first_name in varchar2 default hr_api.g_varchar2
1486: ,p_known_as in varchar2 default hr_api.g_varchar2

Line 1484: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

1480: ,p_date_employee_data_verified in date default hr_api.g_date
1481: ,p_date_of_birth in date default hr_api.g_date
1482: ,p_email_address in varchar2 default hr_api.g_varchar2
1483: ,p_employee_number in out NOCOPY varchar2
1484: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1485: ,p_first_name in varchar2 default hr_api.g_varchar2
1486: ,p_known_as in varchar2 default hr_api.g_varchar2
1487: ,p_marital_status in varchar2 default hr_api.g_varchar2
1488: ,p_middle_names in varchar2 default hr_api.g_varchar2

Line 1485: ,p_first_name in varchar2 default hr_api.g_varchar2

1481: ,p_date_of_birth in date default hr_api.g_date
1482: ,p_email_address in varchar2 default hr_api.g_varchar2
1483: ,p_employee_number in out NOCOPY varchar2
1484: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1485: ,p_first_name in varchar2 default hr_api.g_varchar2
1486: ,p_known_as in varchar2 default hr_api.g_varchar2
1487: ,p_marital_status in varchar2 default hr_api.g_varchar2
1488: ,p_middle_names in varchar2 default hr_api.g_varchar2
1489: ,p_nationality in varchar2 default hr_api.g_varchar2

Line 1486: ,p_known_as in varchar2 default hr_api.g_varchar2

1482: ,p_email_address in varchar2 default hr_api.g_varchar2
1483: ,p_employee_number in out NOCOPY varchar2
1484: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1485: ,p_first_name in varchar2 default hr_api.g_varchar2
1486: ,p_known_as in varchar2 default hr_api.g_varchar2
1487: ,p_marital_status in varchar2 default hr_api.g_varchar2
1488: ,p_middle_names in varchar2 default hr_api.g_varchar2
1489: ,p_nationality in varchar2 default hr_api.g_varchar2
1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2

Line 1487: ,p_marital_status in varchar2 default hr_api.g_varchar2

1483: ,p_employee_number in out NOCOPY varchar2
1484: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1485: ,p_first_name in varchar2 default hr_api.g_varchar2
1486: ,p_known_as in varchar2 default hr_api.g_varchar2
1487: ,p_marital_status in varchar2 default hr_api.g_varchar2
1488: ,p_middle_names in varchar2 default hr_api.g_varchar2
1489: ,p_nationality in varchar2 default hr_api.g_varchar2
1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2

Line 1488: ,p_middle_names in varchar2 default hr_api.g_varchar2

1484: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1485: ,p_first_name in varchar2 default hr_api.g_varchar2
1486: ,p_known_as in varchar2 default hr_api.g_varchar2
1487: ,p_marital_status in varchar2 default hr_api.g_varchar2
1488: ,p_middle_names in varchar2 default hr_api.g_varchar2
1489: ,p_nationality in varchar2 default hr_api.g_varchar2
1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

Line 1489: ,p_nationality in varchar2 default hr_api.g_varchar2

1485: ,p_first_name in varchar2 default hr_api.g_varchar2
1486: ,p_known_as in varchar2 default hr_api.g_varchar2
1487: ,p_marital_status in varchar2 default hr_api.g_varchar2
1488: ,p_middle_names in varchar2 default hr_api.g_varchar2
1489: ,p_nationality in varchar2 default hr_api.g_varchar2
1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1493: ,p_sex in varchar2 default hr_api.g_varchar2

Line 1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2

1486: ,p_known_as in varchar2 default hr_api.g_varchar2
1487: ,p_marital_status in varchar2 default hr_api.g_varchar2
1488: ,p_middle_names in varchar2 default hr_api.g_varchar2
1489: ,p_nationality in varchar2 default hr_api.g_varchar2
1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1493: ,p_sex in varchar2 default hr_api.g_varchar2
1494: ,p_title in varchar2 default hr_api.g_varchar2

Line 1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2

1487: ,p_marital_status in varchar2 default hr_api.g_varchar2
1488: ,p_middle_names in varchar2 default hr_api.g_varchar2
1489: ,p_nationality in varchar2 default hr_api.g_varchar2
1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1493: ,p_sex in varchar2 default hr_api.g_varchar2
1494: ,p_title in varchar2 default hr_api.g_varchar2
1495: ,p_vendor_id in number default hr_api.g_number

Line 1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

1488: ,p_middle_names in varchar2 default hr_api.g_varchar2
1489: ,p_nationality in varchar2 default hr_api.g_varchar2
1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1493: ,p_sex in varchar2 default hr_api.g_varchar2
1494: ,p_title in varchar2 default hr_api.g_varchar2
1495: ,p_vendor_id in number default hr_api.g_number
1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2

Line 1493: ,p_sex in varchar2 default hr_api.g_varchar2

1489: ,p_nationality in varchar2 default hr_api.g_varchar2
1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1493: ,p_sex in varchar2 default hr_api.g_varchar2
1494: ,p_title in varchar2 default hr_api.g_varchar2
1495: ,p_vendor_id in number default hr_api.g_number
1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1494: ,p_title in varchar2 default hr_api.g_varchar2

1490: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1493: ,p_sex in varchar2 default hr_api.g_varchar2
1494: ,p_title in varchar2 default hr_api.g_varchar2
1495: ,p_vendor_id in number default hr_api.g_number
1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1495: ,p_vendor_id in number default hr_api.g_number

1491: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1493: ,p_sex in varchar2 default hr_api.g_varchar2
1494: ,p_title in varchar2 default hr_api.g_varchar2
1495: ,p_vendor_id in number default hr_api.g_number
1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2

1492: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1493: ,p_sex in varchar2 default hr_api.g_varchar2
1494: ,p_title in varchar2 default hr_api.g_varchar2
1495: ,p_vendor_id in number default hr_api.g_number
1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1493: ,p_sex in varchar2 default hr_api.g_varchar2
1494: ,p_title in varchar2 default hr_api.g_varchar2
1495: ,p_vendor_id in number default hr_api.g_number
1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1494: ,p_title in varchar2 default hr_api.g_varchar2
1495: ,p_vendor_id in number default hr_api.g_number
1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1495: ,p_vendor_id in number default hr_api.g_number
1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1496: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1497: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1498: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1499: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1500: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1501: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1502: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1503: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1504: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1505: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1506: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1507: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1508: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1509: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1510: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1511: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1512: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1513: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1514: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1515: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1516: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1517: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1518: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1519: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1520: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2

Line 1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1521: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2

Line 1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1522: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2

Line 1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1523: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2

Line 1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2

1524: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2

Line 1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2

1525: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2

Line 1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2

1526: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2

Line 1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2

1527: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2

Line 1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2

1528: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2

Line 1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2

1529: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2

Line 1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2

1530: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2

Line 1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2

1531: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2

Line 1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2

1532: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2

Line 1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2

1533: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2

Line 1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2

1534: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2

Line 1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2

1535: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2

Line 1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2

1536: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2

Line 1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2

1537: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2

Line 1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2

1538: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2

Line 1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2

1539: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2

Line 1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2

1540: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2

Line 1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2

1541: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2

Line 1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2

1542: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2

Line 1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2

1543: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2

Line 1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2

1544: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2

Line 1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2

1545: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2

Line 1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2

1546: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2

Line 1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2

1547: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2

Line 1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2

1548: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2

Line 1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2

1549: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2

Line 1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2

1550: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2

Line 1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2

1551: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1559: ,p_date_of_death in date default hr_api.g_date

Line 1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2

1552: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1559: ,p_date_of_death in date default hr_api.g_date
1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2

Line 1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2

1553: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1559: ,p_date_of_death in date default hr_api.g_date
1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1561: ,p_background_date_check in date default hr_api.g_date

Line 1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2

1554: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1559: ,p_date_of_death in date default hr_api.g_date
1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1561: ,p_background_date_check in date default hr_api.g_date
1562: ,p_blood_type in varchar2 default hr_api.g_varchar2

Line 1559: ,p_date_of_death in date default hr_api.g_date

1555: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1559: ,p_date_of_death in date default hr_api.g_date
1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1561: ,p_background_date_check in date default hr_api.g_date
1562: ,p_blood_type in varchar2 default hr_api.g_varchar2
1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

Line 1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2

1556: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1559: ,p_date_of_death in date default hr_api.g_date
1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1561: ,p_background_date_check in date default hr_api.g_date
1562: ,p_blood_type in varchar2 default hr_api.g_varchar2
1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

Line 1561: ,p_background_date_check in date default hr_api.g_date

1557: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1559: ,p_date_of_death in date default hr_api.g_date
1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1561: ,p_background_date_check in date default hr_api.g_date
1562: ,p_blood_type in varchar2 default hr_api.g_varchar2
1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1565: ,p_fte_capacity in number default hr_api.g_number

Line 1562: ,p_blood_type in varchar2 default hr_api.g_varchar2

1558: ,p_per_information30 in varchar2 default hr_api.g_varchar2
1559: ,p_date_of_death in date default hr_api.g_date
1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1561: ,p_background_date_check in date default hr_api.g_date
1562: ,p_blood_type in varchar2 default hr_api.g_varchar2
1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1565: ,p_fte_capacity in number default hr_api.g_number
1566: ,p_hold_applicant_date_until in date default hr_api.g_date

Line 1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

1559: ,p_date_of_death in date default hr_api.g_date
1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1561: ,p_background_date_check in date default hr_api.g_date
1562: ,p_blood_type in varchar2 default hr_api.g_varchar2
1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1565: ,p_fte_capacity in number default hr_api.g_number
1566: ,p_hold_applicant_date_until in date default hr_api.g_date
1567: ,p_honors in varchar2 default hr_api.g_varchar2

Line 1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

1560: ,p_background_check_status in varchar2 default hr_api.g_varchar2
1561: ,p_background_date_check in date default hr_api.g_date
1562: ,p_blood_type in varchar2 default hr_api.g_varchar2
1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1565: ,p_fte_capacity in number default hr_api.g_number
1566: ,p_hold_applicant_date_until in date default hr_api.g_date
1567: ,p_honors in varchar2 default hr_api.g_varchar2
1568: ,p_internal_location in varchar2 default hr_api.g_varchar2

Line 1565: ,p_fte_capacity in number default hr_api.g_number

1561: ,p_background_date_check in date default hr_api.g_date
1562: ,p_blood_type in varchar2 default hr_api.g_varchar2
1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1565: ,p_fte_capacity in number default hr_api.g_number
1566: ,p_hold_applicant_date_until in date default hr_api.g_date
1567: ,p_honors in varchar2 default hr_api.g_varchar2
1568: ,p_internal_location in varchar2 default hr_api.g_varchar2
1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

Line 1566: ,p_hold_applicant_date_until in date default hr_api.g_date

1562: ,p_blood_type in varchar2 default hr_api.g_varchar2
1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1565: ,p_fte_capacity in number default hr_api.g_number
1566: ,p_hold_applicant_date_until in date default hr_api.g_date
1567: ,p_honors in varchar2 default hr_api.g_varchar2
1568: ,p_internal_location in varchar2 default hr_api.g_varchar2
1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1570: ,p_last_medical_test_date in date default hr_api.g_date

Line 1567: ,p_honors in varchar2 default hr_api.g_varchar2

1563: ,p_correspondence_language in varchar2 default hr_api.g_varchar2
1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1565: ,p_fte_capacity in number default hr_api.g_number
1566: ,p_hold_applicant_date_until in date default hr_api.g_date
1567: ,p_honors in varchar2 default hr_api.g_varchar2
1568: ,p_internal_location in varchar2 default hr_api.g_varchar2
1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1570: ,p_last_medical_test_date in date default hr_api.g_date
1571: ,p_mailstop in varchar2 default hr_api.g_varchar2

Line 1568: ,p_internal_location in varchar2 default hr_api.g_varchar2

1564: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
1565: ,p_fte_capacity in number default hr_api.g_number
1566: ,p_hold_applicant_date_until in date default hr_api.g_date
1567: ,p_honors in varchar2 default hr_api.g_varchar2
1568: ,p_internal_location in varchar2 default hr_api.g_varchar2
1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1570: ,p_last_medical_test_date in date default hr_api.g_date
1571: ,p_mailstop in varchar2 default hr_api.g_varchar2
1572: ,p_office_number in varchar2 default hr_api.g_varchar2

Line 1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

1565: ,p_fte_capacity in number default hr_api.g_number
1566: ,p_hold_applicant_date_until in date default hr_api.g_date
1567: ,p_honors in varchar2 default hr_api.g_varchar2
1568: ,p_internal_location in varchar2 default hr_api.g_varchar2
1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1570: ,p_last_medical_test_date in date default hr_api.g_date
1571: ,p_mailstop in varchar2 default hr_api.g_varchar2
1572: ,p_office_number in varchar2 default hr_api.g_varchar2
1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2

Line 1570: ,p_last_medical_test_date in date default hr_api.g_date

1566: ,p_hold_applicant_date_until in date default hr_api.g_date
1567: ,p_honors in varchar2 default hr_api.g_varchar2
1568: ,p_internal_location in varchar2 default hr_api.g_varchar2
1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1570: ,p_last_medical_test_date in date default hr_api.g_date
1571: ,p_mailstop in varchar2 default hr_api.g_varchar2
1572: ,p_office_number in varchar2 default hr_api.g_varchar2
1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2

Line 1571: ,p_mailstop in varchar2 default hr_api.g_varchar2

1567: ,p_honors in varchar2 default hr_api.g_varchar2
1568: ,p_internal_location in varchar2 default hr_api.g_varchar2
1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1570: ,p_last_medical_test_date in date default hr_api.g_date
1571: ,p_mailstop in varchar2 default hr_api.g_varchar2
1572: ,p_office_number in varchar2 default hr_api.g_varchar2
1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1575: ,p_projected_start_date in date default hr_api.g_date

Line 1572: ,p_office_number in varchar2 default hr_api.g_varchar2

1568: ,p_internal_location in varchar2 default hr_api.g_varchar2
1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1570: ,p_last_medical_test_date in date default hr_api.g_date
1571: ,p_mailstop in varchar2 default hr_api.g_varchar2
1572: ,p_office_number in varchar2 default hr_api.g_varchar2
1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1575: ,p_projected_start_date in date default hr_api.g_date
1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

Line 1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2

1569: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
1570: ,p_last_medical_test_date in date default hr_api.g_date
1571: ,p_mailstop in varchar2 default hr_api.g_varchar2
1572: ,p_office_number in varchar2 default hr_api.g_varchar2
1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1575: ,p_projected_start_date in date default hr_api.g_date
1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

Line 1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2

1570: ,p_last_medical_test_date in date default hr_api.g_date
1571: ,p_mailstop in varchar2 default hr_api.g_varchar2
1572: ,p_office_number in varchar2 default hr_api.g_varchar2
1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1575: ,p_projected_start_date in date default hr_api.g_date
1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2

Line 1575: ,p_projected_start_date in date default hr_api.g_date

1571: ,p_mailstop in varchar2 default hr_api.g_varchar2
1572: ,p_office_number in varchar2 default hr_api.g_varchar2
1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1575: ,p_projected_start_date in date default hr_api.g_date
1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1579: ,p_resume_last_updated in date default hr_api.g_date

Line 1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

1572: ,p_office_number in varchar2 default hr_api.g_varchar2
1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1575: ,p_projected_start_date in date default hr_api.g_date
1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1579: ,p_resume_last_updated in date default hr_api.g_date
1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

Line 1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

1573: ,p_on_military_service in varchar2 default hr_api.g_varchar2
1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1575: ,p_projected_start_date in date default hr_api.g_date
1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1579: ,p_resume_last_updated in date default hr_api.g_date
1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1581: ,p_student_status in varchar2 default hr_api.g_varchar2

Line 1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2

1574: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
1575: ,p_projected_start_date in date default hr_api.g_date
1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1579: ,p_resume_last_updated in date default hr_api.g_date
1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1581: ,p_student_status in varchar2 default hr_api.g_varchar2
1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2

Line 1579: ,p_resume_last_updated in date default hr_api.g_date

1575: ,p_projected_start_date in date default hr_api.g_date
1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1579: ,p_resume_last_updated in date default hr_api.g_date
1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1581: ,p_student_status in varchar2 default hr_api.g_varchar2
1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

1576: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1579: ,p_resume_last_updated in date default hr_api.g_date
1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1581: ,p_student_status in varchar2 default hr_api.g_varchar2
1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1584: ,p_suffix in varchar2 default hr_api.g_varchar2

Line 1581: ,p_student_status in varchar2 default hr_api.g_varchar2

1577: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1579: ,p_resume_last_updated in date default hr_api.g_date
1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1581: ,p_student_status in varchar2 default hr_api.g_varchar2
1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1584: ,p_suffix in varchar2 default hr_api.g_varchar2
1585: ,p_benefit_group_id in number default hr_api.g_number

Line 1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2

1578: ,p_resume_exists in varchar2 default hr_api.g_varchar2
1579: ,p_resume_last_updated in date default hr_api.g_date
1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1581: ,p_student_status in varchar2 default hr_api.g_varchar2
1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1584: ,p_suffix in varchar2 default hr_api.g_varchar2
1585: ,p_benefit_group_id in number default hr_api.g_number
1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date

Line 1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

1579: ,p_resume_last_updated in date default hr_api.g_date
1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1581: ,p_student_status in varchar2 default hr_api.g_varchar2
1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1584: ,p_suffix in varchar2 default hr_api.g_varchar2
1585: ,p_benefit_group_id in number default hr_api.g_number
1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

Line 1584: ,p_suffix in varchar2 default hr_api.g_varchar2

1580: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
1581: ,p_student_status in varchar2 default hr_api.g_varchar2
1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1584: ,p_suffix in varchar2 default hr_api.g_varchar2
1585: ,p_benefit_group_id in number default hr_api.g_number
1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

Line 1585: ,p_benefit_group_id in number default hr_api.g_number

1581: ,p_student_status in varchar2 default hr_api.g_varchar2
1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1584: ,p_suffix in varchar2 default hr_api.g_varchar2
1585: ,p_benefit_group_id in number default hr_api.g_number
1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

Line 1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date

1582: ,p_work_schedule in varchar2 default hr_api.g_varchar2
1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1584: ,p_suffix in varchar2 default hr_api.g_varchar2
1585: ,p_benefit_group_id in number default hr_api.g_number
1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

Line 1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

1583: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1584: ,p_suffix in varchar2 default hr_api.g_varchar2
1585: ,p_benefit_group_id in number default hr_api.g_number
1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

Line 1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

1584: ,p_suffix in varchar2 default hr_api.g_varchar2
1585: ,p_benefit_group_id in number default hr_api.g_number
1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

Line 1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

1585: ,p_benefit_group_id in number default hr_api.g_number
1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

Line 1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

1586: ,p_receipt_of_death_cert_date in date default hr_api.g_date
1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

Line 1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

1587: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

Line 1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

1588: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1596: ,p_dpdnt_adoption_date in date default hr_api.g_date

Line 1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

1589: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1596: ,p_dpdnt_adoption_date in date default hr_api.g_date
1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

Line 1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

1590: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1596: ,p_dpdnt_adoption_date in date default hr_api.g_date
1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1598: ,p_original_date_of_hire in date default hr_api.g_date

Line 1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

1591: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1596: ,p_dpdnt_adoption_date in date default hr_api.g_date
1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1598: ,p_original_date_of_hire in date default hr_api.g_date
1599: ,p_adjusted_svc_date in date default hr_api.g_date

Line 1596: ,p_dpdnt_adoption_date in date default hr_api.g_date

1592: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1596: ,p_dpdnt_adoption_date in date default hr_api.g_date
1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1598: ,p_original_date_of_hire in date default hr_api.g_date
1599: ,p_adjusted_svc_date in date default hr_api.g_date
1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

Line 1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

1593: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1596: ,p_dpdnt_adoption_date in date default hr_api.g_date
1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1598: ,p_original_date_of_hire in date default hr_api.g_date
1599: ,p_adjusted_svc_date in date default hr_api.g_date
1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

Line 1598: ,p_original_date_of_hire in date default hr_api.g_date

1594: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1596: ,p_dpdnt_adoption_date in date default hr_api.g_date
1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1598: ,p_original_date_of_hire in date default hr_api.g_date
1599: ,p_adjusted_svc_date in date default hr_api.g_date
1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1602: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

Line 1599: ,p_adjusted_svc_date in date default hr_api.g_date

1595: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
1596: ,p_dpdnt_adoption_date in date default hr_api.g_date
1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1598: ,p_original_date_of_hire in date default hr_api.g_date
1599: ,p_adjusted_svc_date in date default hr_api.g_date
1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1602: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1603: ,p_global_person_id in varchar2 default hr_api.g_varchar2

Line 1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

1596: ,p_dpdnt_adoption_date in date default hr_api.g_date
1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1598: ,p_original_date_of_hire in date default hr_api.g_date
1599: ,p_adjusted_svc_date in date default hr_api.g_date
1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1602: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1603: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1604: ,p_party_id in number default hr_api.g_number

Line 1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

1597: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
1598: ,p_original_date_of_hire in date default hr_api.g_date
1599: ,p_adjusted_svc_date in date default hr_api.g_date
1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1602: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1603: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1604: ,p_party_id in number default hr_api.g_number
1605: ,p_npw_number in varchar2 default hr_api.g_varchar2

Line 1602: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

1598: ,p_original_date_of_hire in date default hr_api.g_date
1599: ,p_adjusted_svc_date in date default hr_api.g_date
1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1602: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1603: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1604: ,p_party_id in number default hr_api.g_number
1605: ,p_npw_number in varchar2 default hr_api.g_varchar2
1606: ,p_effective_start_date out NOCOPY date

Line 1603: ,p_global_person_id in varchar2 default hr_api.g_varchar2

1599: ,p_adjusted_svc_date in date default hr_api.g_date
1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1602: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1603: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1604: ,p_party_id in number default hr_api.g_number
1605: ,p_npw_number in varchar2 default hr_api.g_varchar2
1606: ,p_effective_start_date out NOCOPY date
1607: ,p_effective_end_date out NOCOPY date

Line 1604: ,p_party_id in number default hr_api.g_number

1600: ,p_town_of_birth in varchar2 default hr_api.g_varchar2
1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1602: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1603: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1604: ,p_party_id in number default hr_api.g_number
1605: ,p_npw_number in varchar2 default hr_api.g_varchar2
1606: ,p_effective_start_date out NOCOPY date
1607: ,p_effective_end_date out NOCOPY date
1608: ,p_full_name out NOCOPY varchar2

Line 1605: ,p_npw_number in varchar2 default hr_api.g_varchar2

1601: ,p_region_of_birth in varchar2 default hr_api.g_varchar2
1602: ,p_country_of_birth in varchar2 default hr_api.g_varchar2
1603: ,p_global_person_id in varchar2 default hr_api.g_varchar2
1604: ,p_party_id in number default hr_api.g_number
1605: ,p_npw_number in varchar2 default hr_api.g_varchar2
1606: ,p_effective_start_date out NOCOPY date
1607: ,p_effective_end_date out NOCOPY date
1608: ,p_full_name out NOCOPY varchar2
1609: ,p_comment_id out NOCOPY number