DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on HR_API

Line 217: pen.effective_end_date = hr_api.g_eot and

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

Line 232: pen.effective_end_date = hr_api.g_eot and

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

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

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

Line 385: ,p_ELIG_THRU_DT => hr_api.g_eot

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

Line 417: ,p_elig_thru_dt => hr_api.g_eot

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

Line 577: l_datetrack_mode := hr_api.g_update_override;

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

Line 581: l_datetrack_mode := hr_api.g_update;

577: l_datetrack_mode := hr_api.g_update_override;
578: --
579: elsif l_update then
580: --
581: l_datetrack_mode := hr_api.g_update;
582: --
583: else
584: --
585: l_datetrack_mode := hr_api.g_correction;

Line 585: l_datetrack_mode := hr_api.g_correction;

581: l_datetrack_mode := hr_api.g_update;
582: --
583: else
584: --
585: l_datetrack_mode := hr_api.g_correction;
586: --
587: end if;
588:
589: if l_cvg_end_dt is null then

Line 591: l_cvg_end_dt := hr_api.g_eot;

587: end if;
588:
589: if l_cvg_end_dt is null then
590: --
591: l_cvg_end_dt := hr_api.g_eot;
592: --
593: end if;
594: --
595: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt

Line 1320: ,p_contact_type in varchar2 default hr_api.g_varchar2

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

Line 1321: ,p_comments in long default hr_api.g_varchar2

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

Line 1322: ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2

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

Line 1323: ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2

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

Line 1324: ,p_bondholder_flag in varchar2 default hr_api.g_varchar2

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

Line 1325: ,p_date_start in date default hr_api.g_date

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

Line 1326: ,p_start_life_reason_id in number default hr_api.g_number

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

Line 1327: ,p_date_end in date default hr_api.g_date

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

Line 1328: ,p_end_life_reason_id in number default hr_api.g_number

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

Line 1329: ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2

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

Line 1330: ,p_personal_flag in varchar2 default hr_api.g_varchar2

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

Line 1331: ,p_sequence_number in number default hr_api.g_number

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

Line 1332: ,p_dependent_flag in varchar2 default hr_api.g_varchar2

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

Line 1333: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2

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

Line 1334: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2

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

Line 1335: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2

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

Line 1336: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2

1332: ,p_dependent_flag in varchar2 default hr_api.g_varchar2
1333: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1334: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1335: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1336: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2

Line 1337: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2

1333: ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
1334: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1335: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1336: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2

Line 1338: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2

1334: ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
1335: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1336: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2

Line 1339: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2

1335: ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
1336: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2

Line 1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2

1336: ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
1337: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2

Line 1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2

1337: ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
1338: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2

Line 1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2

1338: ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
1339: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2

Line 1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2

1339: ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2

Line 1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2

1340: ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2

Line 1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2

1341: ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2

Line 1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2

1342: ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2

Line 1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2

1343: ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2

Line 1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2

1344: ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2

Line 1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2

1345: ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2

Line 1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2

1346: ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2

Line 1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2

1347: ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2

Line 1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2

1348: ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2

Line 1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2

1349: ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2

Line 1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2

1350: ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2

Line 1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2

1351: ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2

Line 1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2

1352: ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2

Line 1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2

1353: ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2

Line 1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2

1354: ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2

Line 1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2

1355: ,p_cont_information_category in varchar2 default hr_api.g_varchar2
1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2

Line 1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2

1356: ,p_cont_information1 in varchar2 default hr_api.g_varchar2
1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2

Line 1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2

1357: ,p_cont_information2 in varchar2 default hr_api.g_varchar2
1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2

Line 1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2

1358: ,p_cont_information3 in varchar2 default hr_api.g_varchar2
1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2

Line 1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2

1359: ,p_cont_information4 in varchar2 default hr_api.g_varchar2
1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2

Line 1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2

1360: ,p_cont_information5 in varchar2 default hr_api.g_varchar2
1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information13 in varchar2 default hr_api.g_varchar2

Line 1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2

1361: ,p_cont_information6 in varchar2 default hr_api.g_varchar2
1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information14 in varchar2 default hr_api.g_varchar2

Line 1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2

1362: ,p_cont_information7 in varchar2 default hr_api.g_varchar2
1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information15 in varchar2 default hr_api.g_varchar2

Line 1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2

1363: ,p_cont_information8 in varchar2 default hr_api.g_varchar2
1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information16 in varchar2 default hr_api.g_varchar2

Line 1368: ,p_cont_information13 in varchar2 default hr_api.g_varchar2

1364: ,p_cont_information9 in varchar2 default hr_api.g_varchar2
1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information17 in varchar2 default hr_api.g_varchar2

Line 1369: ,p_cont_information14 in varchar2 default hr_api.g_varchar2

1365: ,p_cont_information10 in varchar2 default hr_api.g_varchar2
1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information18 in varchar2 default hr_api.g_varchar2

Line 1370: ,p_cont_information15 in varchar2 default hr_api.g_varchar2

1366: ,p_cont_information11 in varchar2 default hr_api.g_varchar2
1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information19 in varchar2 default hr_api.g_varchar2

Line 1371: ,p_cont_information16 in varchar2 default hr_api.g_varchar2

1367: ,p_cont_information12 in varchar2 default hr_api.g_varchar2
1368: ,p_cont_information13 in varchar2 default hr_api.g_varchar2
1369: ,p_cont_information14 in varchar2 default hr_api.g_varchar2
1370: ,p_cont_information15 in varchar2 default hr_api.g_varchar2
1371: ,p_cont_information16 in varchar2 default hr_api.g_varchar2
1372: ,p_cont_information17 in varchar2 default hr_api.g_varchar2
1373: ,p_cont_information18 in varchar2 default hr_api.g_varchar2
1374: ,p_cont_information19 in varchar2 default hr_api.g_varchar2
1375: ,p_cont_information20 in varchar2 default hr_api.g_varchar2

Line 1372: ,p_cont_information17 in varchar2 default hr_api.g_varchar2

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

Line 1373: ,p_cont_information18 in varchar2 default hr_api.g_varchar2

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

Line 1374: ,p_cont_information19 in varchar2 default hr_api.g_varchar2

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

Line 1375: ,p_cont_information20 in varchar2 default hr_api.g_varchar2

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

Line 1473: ,p_person_type_id in number default hr_api.g_number

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

Line 1474: ,p_last_name in varchar2 default hr_api.g_varchar2

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

Line 1475: ,p_applicant_number in varchar2 default hr_api.g_varchar2

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

Line 1476: ,p_comments in varchar2 default hr_api.g_varchar2

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

Line 1477: ,p_date_employee_data_verified in date default hr_api.g_date

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

Line 1478: ,p_date_of_birth in date default hr_api.g_date

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

Line 1479: ,p_email_address in varchar2 default hr_api.g_varchar2

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

Line 1481: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2

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

Line 1482: ,p_first_name in varchar2 default hr_api.g_varchar2

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

Line 1483: ,p_known_as in varchar2 default hr_api.g_varchar2

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

Line 1484: ,p_marital_status in varchar2 default hr_api.g_varchar2

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

Line 1485: ,p_middle_names in varchar2 default hr_api.g_varchar2

1481: ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
1482: ,p_first_name in varchar2 default hr_api.g_varchar2
1483: ,p_known_as in varchar2 default hr_api.g_varchar2
1484: ,p_marital_status in varchar2 default hr_api.g_varchar2
1485: ,p_middle_names in varchar2 default hr_api.g_varchar2
1486: ,p_nationality in varchar2 default hr_api.g_varchar2
1487: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1488: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1489: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

Line 1486: ,p_nationality in varchar2 default hr_api.g_varchar2

1482: ,p_first_name in varchar2 default hr_api.g_varchar2
1483: ,p_known_as in varchar2 default hr_api.g_varchar2
1484: ,p_marital_status in varchar2 default hr_api.g_varchar2
1485: ,p_middle_names in varchar2 default hr_api.g_varchar2
1486: ,p_nationality in varchar2 default hr_api.g_varchar2
1487: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1488: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1489: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1490: ,p_sex in varchar2 default hr_api.g_varchar2

Line 1487: ,p_national_identifier in varchar2 default hr_api.g_varchar2

1483: ,p_known_as in varchar2 default hr_api.g_varchar2
1484: ,p_marital_status in varchar2 default hr_api.g_varchar2
1485: ,p_middle_names in varchar2 default hr_api.g_varchar2
1486: ,p_nationality in varchar2 default hr_api.g_varchar2
1487: ,p_national_identifier in varchar2 default hr_api.g_varchar2
1488: ,p_previous_last_name in varchar2 default hr_api.g_varchar2
1489: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
1490: ,p_sex in varchar2 default hr_api.g_varchar2
1491: ,p_title in varchar2 default hr_api.g_varchar2

Line 1488: ,p_previous_last_name in varchar2 default hr_api.g_varchar2

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

Line 1489: ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2

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

Line 1490: ,p_sex in varchar2 default hr_api.g_varchar2

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

Line 1491: ,p_title in varchar2 default hr_api.g_varchar2

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

Line 1492: ,p_vendor_id in number default hr_api.g_number

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

Line 1493: ,p_work_telephone in varchar2 default hr_api.g_varchar2

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

Line 1494: ,p_attribute_category in varchar2 default hr_api.g_varchar2

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

Line 1495: ,p_attribute1 in varchar2 default hr_api.g_varchar2

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

Line 1496: ,p_attribute2 in varchar2 default hr_api.g_varchar2

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

Line 1497: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1493: ,p_work_telephone in varchar2 default hr_api.g_varchar2
1494: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1495: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1498: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1494: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1495: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1499: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1495: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1500: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1496: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1497: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1498: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1499: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1500: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1501: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1502: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1503: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1504: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1505: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1506: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1507: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1508: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1509: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1510: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1511: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1512: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1513: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1514: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1515: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1516: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1517: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2

Line 1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1518: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2

Line 1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1519: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2

Line 1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1520: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2

Line 1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2

1521: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2

Line 1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2

1522: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2

Line 1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2

1523: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2

Line 1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2

1524: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2

Line 1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2

1525: ,p_per_information_category in varchar2 default hr_api.g_varchar2
1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2

Line 1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2

1526: ,p_per_information1 in varchar2 default hr_api.g_varchar2
1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2

Line 1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2

1527: ,p_per_information2 in varchar2 default hr_api.g_varchar2
1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2

Line 1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2

1528: ,p_per_information3 in varchar2 default hr_api.g_varchar2
1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2

Line 1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2

1529: ,p_per_information4 in varchar2 default hr_api.g_varchar2
1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2

Line 1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2

1530: ,p_per_information5 in varchar2 default hr_api.g_varchar2
1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2

Line 1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2

1531: ,p_per_information6 in varchar2 default hr_api.g_varchar2
1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2

Line 1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2

1532: ,p_per_information7 in varchar2 default hr_api.g_varchar2
1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2

Line 1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2

1533: ,p_per_information8 in varchar2 default hr_api.g_varchar2
1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2

Line 1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2

1534: ,p_per_information9 in varchar2 default hr_api.g_varchar2
1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2

Line 1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2

1535: ,p_per_information10 in varchar2 default hr_api.g_varchar2
1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2

Line 1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2

1536: ,p_per_information11 in varchar2 default hr_api.g_varchar2
1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2

Line 1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2

1537: ,p_per_information12 in varchar2 default hr_api.g_varchar2
1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2

Line 1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2

1538: ,p_per_information13 in varchar2 default hr_api.g_varchar2
1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2

Line 1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2

1539: ,p_per_information14 in varchar2 default hr_api.g_varchar2
1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2

Line 1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2

1540: ,p_per_information15 in varchar2 default hr_api.g_varchar2
1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information23 in varchar2 default hr_api.g_varchar2

Line 1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2

1541: ,p_per_information16 in varchar2 default hr_api.g_varchar2
1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information24 in varchar2 default hr_api.g_varchar2

Line 1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2

1542: ,p_per_information17 in varchar2 default hr_api.g_varchar2
1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information25 in varchar2 default hr_api.g_varchar2

Line 1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2

1543: ,p_per_information18 in varchar2 default hr_api.g_varchar2
1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information26 in varchar2 default hr_api.g_varchar2

Line 1548: ,p_per_information23 in varchar2 default hr_api.g_varchar2

1544: ,p_per_information19 in varchar2 default hr_api.g_varchar2
1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information27 in varchar2 default hr_api.g_varchar2

Line 1549: ,p_per_information24 in varchar2 default hr_api.g_varchar2

1545: ,p_per_information20 in varchar2 default hr_api.g_varchar2
1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information28 in varchar2 default hr_api.g_varchar2

Line 1550: ,p_per_information25 in varchar2 default hr_api.g_varchar2

1546: ,p_per_information21 in varchar2 default hr_api.g_varchar2
1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information29 in varchar2 default hr_api.g_varchar2

Line 1551: ,p_per_information26 in varchar2 default hr_api.g_varchar2

1547: ,p_per_information22 in varchar2 default hr_api.g_varchar2
1548: ,p_per_information23 in varchar2 default hr_api.g_varchar2
1549: ,p_per_information24 in varchar2 default hr_api.g_varchar2
1550: ,p_per_information25 in varchar2 default hr_api.g_varchar2
1551: ,p_per_information26 in varchar2 default hr_api.g_varchar2
1552: ,p_per_information27 in varchar2 default hr_api.g_varchar2
1553: ,p_per_information28 in varchar2 default hr_api.g_varchar2
1554: ,p_per_information29 in varchar2 default hr_api.g_varchar2
1555: ,p_per_information30 in varchar2 default hr_api.g_varchar2

Line 1552: ,p_per_information27 in varchar2 default hr_api.g_varchar2

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

Line 1553: ,p_per_information28 in varchar2 default hr_api.g_varchar2

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

Line 1554: ,p_per_information29 in varchar2 default hr_api.g_varchar2

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

Line 1555: ,p_per_information30 in varchar2 default hr_api.g_varchar2

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

Line 1556: ,p_date_of_death in date default hr_api.g_date

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

Line 1557: ,p_background_check_status in varchar2 default hr_api.g_varchar2

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

Line 1558: ,p_background_date_check in date default hr_api.g_date

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

Line 1559: ,p_blood_type in varchar2 default hr_api.g_varchar2

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

Line 1560: ,p_correspondence_language in varchar2 default hr_api.g_varchar2

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

Line 1561: ,p_fast_path_employee in varchar2 default hr_api.g_varchar2

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

Line 1562: ,p_fte_capacity in number default hr_api.g_number

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

Line 1563: ,p_hold_applicant_date_until in date default hr_api.g_date

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

Line 1564: ,p_honors in varchar2 default hr_api.g_varchar2

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

Line 1565: ,p_internal_location in varchar2 default hr_api.g_varchar2

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

Line 1566: ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2

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

Line 1567: ,p_last_medical_test_date in date default hr_api.g_date

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

Line 1568: ,p_mailstop in varchar2 default hr_api.g_varchar2

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

Line 1569: ,p_office_number in varchar2 default hr_api.g_varchar2

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

Line 1570: ,p_on_military_service in varchar2 default hr_api.g_varchar2

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

Line 1571: ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2

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

Line 1572: ,p_projected_start_date in date default hr_api.g_date

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

Line 1573: ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2

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

Line 1574: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2

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

Line 1575: ,p_resume_exists in varchar2 default hr_api.g_varchar2

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

Line 1576: ,p_resume_last_updated in date default hr_api.g_date

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

Line 1577: ,p_second_passport_exists in varchar2 default hr_api.g_varchar2

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

Line 1578: ,p_student_status in varchar2 default hr_api.g_varchar2

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

Line 1579: ,p_work_schedule in varchar2 default hr_api.g_varchar2

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

Line 1580: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

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

Line 1581: ,p_suffix in varchar2 default hr_api.g_varchar2

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

Line 1582: ,p_benefit_group_id in number default hr_api.g_number

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

Line 1583: ,p_receipt_of_death_cert_date in date default hr_api.g_date

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

Line 1584: ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2

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

Line 1585: ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2

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

Line 1586: ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2

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

Line 1587: ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2

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

Line 1588: ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2

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

Line 1589: ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2

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

Line 1590: ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date

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

Line 1591: ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date

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

Line 1592: ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2

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

Line 1593: ,p_dpdnt_adoption_date in date default hr_api.g_date

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

Line 1594: ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2

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

Line 1595: ,p_original_date_of_hire in date default hr_api.g_date

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

Line 1596: ,p_adjusted_svc_date in date default hr_api.g_date

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

Line 1597: ,p_town_of_birth in varchar2 default hr_api.g_varchar2

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

Line 1598: ,p_region_of_birth in varchar2 default hr_api.g_varchar2

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

Line 1599: ,p_country_of_birth in varchar2 default hr_api.g_varchar2

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

Line 1600: ,p_global_person_id in varchar2 default hr_api.g_varchar2

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

Line 1601: ,p_party_id in number default hr_api.g_number

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

Line 1602: ,p_npw_number in varchar2 default hr_api.g_varchar2

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