APPS.PQP_AAD_UPD dependencies on HR_API

Line 99: When hr_api.check_integrity_violated Then

95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
102: pqp_aad_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
102: pqp_aad_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_aad_shd.constraint_error

Line 104: When hr_api.parent_integrity_violated Then

100: -- A check constraint has been violated
101: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
102: pqp_aad_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_aad_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

104: When hr_api.parent_integrity_violated Then
105: -- Parent integrity has been violated
106: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_aad_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_aad_shd.constraint_error

Line 109: When hr_api.unique_integrity_violated Then

105: -- Parent integrity has been violated
106: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_aad_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_aad_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

109: When hr_api.unique_integrity_violated Then
110: -- Unique integrity has been violated
111: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_aad_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When Others Then
115: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
116: Raise;
117: End update_dml;

Line 254: when hr_api.cannot_find_prog_unit then

250: );
251: --
252: exception
253: --
254: when hr_api.cannot_find_prog_unit then
255: --
256: hr_api.cannot_find_prog_unit_error
257: (p_module_name => 'PQP_ANALYZED_ALIEN_DATA'
258: ,p_hook_type => 'AU');

Line 256: hr_api.cannot_find_prog_unit_error

252: exception
253: --
254: when hr_api.cannot_find_prog_unit then
255: --
256: hr_api.cannot_find_prog_unit_error
257: (p_module_name => 'PQP_ANALYZED_ALIEN_DATA'
258: ,p_hook_type => 'AU');
259: --
260: end;

Line 324: If (p_rec.assignment_id = hr_api.g_number) then

320: -- p_rec plsql record structure
321: -- to see if a system default is being used. If a system default
322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.assignment_id = hr_api.g_number) then
325: p_rec.assignment_id :=
326: pqp_aad_shd.g_old_rec.assignment_id;
327: End If;
328: If (p_rec.data_source = hr_api.g_varchar2) then

Line 328: If (p_rec.data_source = hr_api.g_varchar2) then

324: If (p_rec.assignment_id = hr_api.g_number) then
325: p_rec.assignment_id :=
326: pqp_aad_shd.g_old_rec.assignment_id;
327: End If;
328: If (p_rec.data_source = hr_api.g_varchar2) then
329: p_rec.data_source :=
330: pqp_aad_shd.g_old_rec.data_source;
331: End If;
332: If (p_rec.tax_year = hr_api.g_number) then

Line 332: If (p_rec.tax_year = hr_api.g_number) then

328: If (p_rec.data_source = hr_api.g_varchar2) then
329: p_rec.data_source :=
330: pqp_aad_shd.g_old_rec.data_source;
331: End If;
332: If (p_rec.tax_year = hr_api.g_number) then
333: p_rec.tax_year :=
334: pqp_aad_shd.g_old_rec.tax_year;
335: End If;
336: If (p_rec.current_residency_status = hr_api.g_varchar2) then

Line 336: If (p_rec.current_residency_status = hr_api.g_varchar2) then

332: If (p_rec.tax_year = hr_api.g_number) then
333: p_rec.tax_year :=
334: pqp_aad_shd.g_old_rec.tax_year;
335: End If;
336: If (p_rec.current_residency_status = hr_api.g_varchar2) then
337: p_rec.current_residency_status :=
338: pqp_aad_shd.g_old_rec.current_residency_status;
339: End If;
340: If (p_rec.nra_to_ra_date = hr_api.g_date) then

Line 340: If (p_rec.nra_to_ra_date = hr_api.g_date) then

336: If (p_rec.current_residency_status = hr_api.g_varchar2) then
337: p_rec.current_residency_status :=
338: pqp_aad_shd.g_old_rec.current_residency_status;
339: End If;
340: If (p_rec.nra_to_ra_date = hr_api.g_date) then
341: p_rec.nra_to_ra_date :=
342: pqp_aad_shd.g_old_rec.nra_to_ra_date;
343: End If;
344: If (p_rec.target_departure_date = hr_api.g_date) then

Line 344: If (p_rec.target_departure_date = hr_api.g_date) then

340: If (p_rec.nra_to_ra_date = hr_api.g_date) then
341: p_rec.nra_to_ra_date :=
342: pqp_aad_shd.g_old_rec.nra_to_ra_date;
343: End If;
344: If (p_rec.target_departure_date = hr_api.g_date) then
345: p_rec.target_departure_date :=
346: pqp_aad_shd.g_old_rec.target_departure_date;
347: End If;
348: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then

Line 348: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then

344: If (p_rec.target_departure_date = hr_api.g_date) then
345: p_rec.target_departure_date :=
346: pqp_aad_shd.g_old_rec.target_departure_date;
347: End If;
348: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then
349: p_rec.tax_residence_country_code :=
350: pqp_aad_shd.g_old_rec.tax_residence_country_code;
351: End If;
352: If (p_rec.treaty_info_update_date = hr_api.g_date) then

Line 352: If (p_rec.treaty_info_update_date = hr_api.g_date) then

348: If (p_rec.tax_residence_country_code = hr_api.g_varchar2) then
349: p_rec.tax_residence_country_code :=
350: pqp_aad_shd.g_old_rec.tax_residence_country_code;
351: End If;
352: If (p_rec.treaty_info_update_date = hr_api.g_date) then
353: p_rec.treaty_info_update_date :=
354: pqp_aad_shd.g_old_rec.treaty_info_update_date;
355: End If;
356: If (p_rec.number_of_days_in_usa = hr_api.g_number) then

Line 356: If (p_rec.number_of_days_in_usa = hr_api.g_number) then

352: If (p_rec.treaty_info_update_date = hr_api.g_date) then
353: p_rec.treaty_info_update_date :=
354: pqp_aad_shd.g_old_rec.treaty_info_update_date;
355: End If;
356: If (p_rec.number_of_days_in_usa = hr_api.g_number) then
357: p_rec.number_of_days_in_usa :=
358: pqp_aad_shd.g_old_rec.number_of_days_in_usa;
359: End If;
360: If (p_rec.withldg_allow_eligible_flag = hr_api.g_varchar2) then

Line 360: If (p_rec.withldg_allow_eligible_flag = hr_api.g_varchar2) then

356: If (p_rec.number_of_days_in_usa = hr_api.g_number) then
357: p_rec.number_of_days_in_usa :=
358: pqp_aad_shd.g_old_rec.number_of_days_in_usa;
359: End If;
360: If (p_rec.withldg_allow_eligible_flag = hr_api.g_varchar2) then
361: p_rec.withldg_allow_eligible_flag :=
362: pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag;
363: End If;
364: If (p_rec.ra_effective_date = hr_api.g_date) then

Line 364: If (p_rec.ra_effective_date = hr_api.g_date) then

360: If (p_rec.withldg_allow_eligible_flag = hr_api.g_varchar2) then
361: p_rec.withldg_allow_eligible_flag :=
362: pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag;
363: End If;
364: If (p_rec.ra_effective_date = hr_api.g_date) then
365: p_rec.ra_effective_date :=
366: pqp_aad_shd.g_old_rec.ra_effective_date;
367: End If;
368: If (p_rec.record_source = hr_api.g_varchar2) then

Line 368: If (p_rec.record_source = hr_api.g_varchar2) then

364: If (p_rec.ra_effective_date = hr_api.g_date) then
365: p_rec.ra_effective_date :=
366: pqp_aad_shd.g_old_rec.ra_effective_date;
367: End If;
368: If (p_rec.record_source = hr_api.g_varchar2) then
369: p_rec.record_source :=
370: pqp_aad_shd.g_old_rec.record_source;
371: End If;
372: If (p_rec.visa_type = hr_api.g_varchar2) then

Line 372: If (p_rec.visa_type = hr_api.g_varchar2) then

368: If (p_rec.record_source = hr_api.g_varchar2) then
369: p_rec.record_source :=
370: pqp_aad_shd.g_old_rec.record_source;
371: End If;
372: If (p_rec.visa_type = hr_api.g_varchar2) then
373: p_rec.visa_type :=
374: pqp_aad_shd.g_old_rec.visa_type;
375: End If;
376: If (p_rec.j_sub_type = hr_api.g_varchar2) then

Line 376: If (p_rec.j_sub_type = hr_api.g_varchar2) then

372: If (p_rec.visa_type = hr_api.g_varchar2) then
373: p_rec.visa_type :=
374: pqp_aad_shd.g_old_rec.visa_type;
375: End If;
376: If (p_rec.j_sub_type = hr_api.g_varchar2) then
377: p_rec.j_sub_type :=
378: pqp_aad_shd.g_old_rec.j_sub_type;
379: End If;
380: If (p_rec.primary_activity = hr_api.g_varchar2) then

Line 380: If (p_rec.primary_activity = hr_api.g_varchar2) then

376: If (p_rec.j_sub_type = hr_api.g_varchar2) then
377: p_rec.j_sub_type :=
378: pqp_aad_shd.g_old_rec.j_sub_type;
379: End If;
380: If (p_rec.primary_activity = hr_api.g_varchar2) then
381: p_rec.primary_activity :=
382: pqp_aad_shd.g_old_rec.primary_activity;
383: End If;
384: If (p_rec.non_us_country_code = hr_api.g_varchar2) then

Line 384: If (p_rec.non_us_country_code = hr_api.g_varchar2) then

380: If (p_rec.primary_activity = hr_api.g_varchar2) then
381: p_rec.primary_activity :=
382: pqp_aad_shd.g_old_rec.primary_activity;
383: End If;
384: If (p_rec.non_us_country_code = hr_api.g_varchar2) then
385: p_rec.non_us_country_code :=
386: pqp_aad_shd.g_old_rec.non_us_country_code;
387: End If;
388: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then

Line 388: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then

384: If (p_rec.non_us_country_code = hr_api.g_varchar2) then
385: p_rec.non_us_country_code :=
386: pqp_aad_shd.g_old_rec.non_us_country_code;
387: End If;
388: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then
389: p_rec.citizenship_country_code :=
390: pqp_aad_shd.g_old_rec.citizenship_country_code;
391: End If;
392: If (p_rec.date_8233_signed = hr_api.g_date) then

Line 392: If (p_rec.date_8233_signed = hr_api.g_date) then

388: If (p_rec.citizenship_country_code = hr_api.g_varchar2) then
389: p_rec.citizenship_country_code :=
390: pqp_aad_shd.g_old_rec.citizenship_country_code;
391: End If;
392: If (p_rec.date_8233_signed = hr_api.g_date) then
393: p_rec.date_8233_signed :=
394: pqp_aad_shd.g_old_rec.date_8233_signed;
395: End If;
396: If (p_rec.date_w4_signed = hr_api.g_date) then

Line 396: If (p_rec.date_w4_signed = hr_api.g_date) then

392: If (p_rec.date_8233_signed = hr_api.g_date) then
393: p_rec.date_8233_signed :=
394: pqp_aad_shd.g_old_rec.date_8233_signed;
395: End If;
396: If (p_rec.date_w4_signed = hr_api.g_date) then
397: p_rec.date_w4_signed :=
398: pqp_aad_shd.g_old_rec.date_w4_signed;
399: End If;
400:

Line 459: p_assignment_id in number default hr_api.g_number,

455: Procedure upd
456: (
457: p_effective_date in date,
458: p_analyzed_data_id in number,
459: p_assignment_id in number default hr_api.g_number,
460: p_data_source in varchar2 default hr_api.g_varchar2,
461: p_tax_year in number default hr_api.g_number,
462: p_current_residency_status in varchar2 default hr_api.g_varchar2,
463: p_nra_to_ra_date in date default hr_api.g_date,

Line 460: p_data_source in varchar2 default hr_api.g_varchar2,

456: (
457: p_effective_date in date,
458: p_analyzed_data_id in number,
459: p_assignment_id in number default hr_api.g_number,
460: p_data_source in varchar2 default hr_api.g_varchar2,
461: p_tax_year in number default hr_api.g_number,
462: p_current_residency_status in varchar2 default hr_api.g_varchar2,
463: p_nra_to_ra_date in date default hr_api.g_date,
464: p_target_departure_date in date default hr_api.g_date,

Line 461: p_tax_year in number default hr_api.g_number,

457: p_effective_date in date,
458: p_analyzed_data_id in number,
459: p_assignment_id in number default hr_api.g_number,
460: p_data_source in varchar2 default hr_api.g_varchar2,
461: p_tax_year in number default hr_api.g_number,
462: p_current_residency_status in varchar2 default hr_api.g_varchar2,
463: p_nra_to_ra_date in date default hr_api.g_date,
464: p_target_departure_date in date default hr_api.g_date,
465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,

Line 462: p_current_residency_status in varchar2 default hr_api.g_varchar2,

458: p_analyzed_data_id in number,
459: p_assignment_id in number default hr_api.g_number,
460: p_data_source in varchar2 default hr_api.g_varchar2,
461: p_tax_year in number default hr_api.g_number,
462: p_current_residency_status in varchar2 default hr_api.g_varchar2,
463: p_nra_to_ra_date in date default hr_api.g_date,
464: p_target_departure_date in date default hr_api.g_date,
465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
466: p_treaty_info_update_date in date default hr_api.g_date,

Line 463: p_nra_to_ra_date in date default hr_api.g_date,

459: p_assignment_id in number default hr_api.g_number,
460: p_data_source in varchar2 default hr_api.g_varchar2,
461: p_tax_year in number default hr_api.g_number,
462: p_current_residency_status in varchar2 default hr_api.g_varchar2,
463: p_nra_to_ra_date in date default hr_api.g_date,
464: p_target_departure_date in date default hr_api.g_date,
465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
466: p_treaty_info_update_date in date default hr_api.g_date,
467: p_number_of_days_in_usa in number default hr_api.g_number,

Line 464: p_target_departure_date in date default hr_api.g_date,

460: p_data_source in varchar2 default hr_api.g_varchar2,
461: p_tax_year in number default hr_api.g_number,
462: p_current_residency_status in varchar2 default hr_api.g_varchar2,
463: p_nra_to_ra_date in date default hr_api.g_date,
464: p_target_departure_date in date default hr_api.g_date,
465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
466: p_treaty_info_update_date in date default hr_api.g_date,
467: p_number_of_days_in_usa in number default hr_api.g_number,
468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,

Line 465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,

461: p_tax_year in number default hr_api.g_number,
462: p_current_residency_status in varchar2 default hr_api.g_varchar2,
463: p_nra_to_ra_date in date default hr_api.g_date,
464: p_target_departure_date in date default hr_api.g_date,
465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
466: p_treaty_info_update_date in date default hr_api.g_date,
467: p_number_of_days_in_usa in number default hr_api.g_number,
468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
469: p_ra_effective_date in date default hr_api.g_date,

Line 466: p_treaty_info_update_date in date default hr_api.g_date,

462: p_current_residency_status in varchar2 default hr_api.g_varchar2,
463: p_nra_to_ra_date in date default hr_api.g_date,
464: p_target_departure_date in date default hr_api.g_date,
465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
466: p_treaty_info_update_date in date default hr_api.g_date,
467: p_number_of_days_in_usa in number default hr_api.g_number,
468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
469: p_ra_effective_date in date default hr_api.g_date,
470: p_record_source in varchar2 default hr_api.g_varchar2,

Line 467: p_number_of_days_in_usa in number default hr_api.g_number,

463: p_nra_to_ra_date in date default hr_api.g_date,
464: p_target_departure_date in date default hr_api.g_date,
465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
466: p_treaty_info_update_date in date default hr_api.g_date,
467: p_number_of_days_in_usa in number default hr_api.g_number,
468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
469: p_ra_effective_date in date default hr_api.g_date,
470: p_record_source in varchar2 default hr_api.g_varchar2,
471: p_visa_type in varchar2 default hr_api.g_varchar2,

Line 468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,

464: p_target_departure_date in date default hr_api.g_date,
465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
466: p_treaty_info_update_date in date default hr_api.g_date,
467: p_number_of_days_in_usa in number default hr_api.g_number,
468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
469: p_ra_effective_date in date default hr_api.g_date,
470: p_record_source in varchar2 default hr_api.g_varchar2,
471: p_visa_type in varchar2 default hr_api.g_varchar2,
472: p_j_sub_type in varchar2 default hr_api.g_varchar2,

Line 469: p_ra_effective_date in date default hr_api.g_date,

465: p_tax_residence_country_code in varchar2 default hr_api.g_varchar2,
466: p_treaty_info_update_date in date default hr_api.g_date,
467: p_number_of_days_in_usa in number default hr_api.g_number,
468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
469: p_ra_effective_date in date default hr_api.g_date,
470: p_record_source in varchar2 default hr_api.g_varchar2,
471: p_visa_type in varchar2 default hr_api.g_varchar2,
472: p_j_sub_type in varchar2 default hr_api.g_varchar2,
473: p_primary_activity in varchar2 default hr_api.g_varchar2,

Line 470: p_record_source in varchar2 default hr_api.g_varchar2,

466: p_treaty_info_update_date in date default hr_api.g_date,
467: p_number_of_days_in_usa in number default hr_api.g_number,
468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
469: p_ra_effective_date in date default hr_api.g_date,
470: p_record_source in varchar2 default hr_api.g_varchar2,
471: p_visa_type in varchar2 default hr_api.g_varchar2,
472: p_j_sub_type in varchar2 default hr_api.g_varchar2,
473: p_primary_activity in varchar2 default hr_api.g_varchar2,
474: p_non_us_country_code in varchar2 default hr_api.g_varchar2,

Line 471: p_visa_type in varchar2 default hr_api.g_varchar2,

467: p_number_of_days_in_usa in number default hr_api.g_number,
468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
469: p_ra_effective_date in date default hr_api.g_date,
470: p_record_source in varchar2 default hr_api.g_varchar2,
471: p_visa_type in varchar2 default hr_api.g_varchar2,
472: p_j_sub_type in varchar2 default hr_api.g_varchar2,
473: p_primary_activity in varchar2 default hr_api.g_varchar2,
474: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
475: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,

Line 472: p_j_sub_type in varchar2 default hr_api.g_varchar2,

468: p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2,
469: p_ra_effective_date in date default hr_api.g_date,
470: p_record_source in varchar2 default hr_api.g_varchar2,
471: p_visa_type in varchar2 default hr_api.g_varchar2,
472: p_j_sub_type in varchar2 default hr_api.g_varchar2,
473: p_primary_activity in varchar2 default hr_api.g_varchar2,
474: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
475: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
476: p_object_version_number in out nocopy number ,

Line 473: p_primary_activity in varchar2 default hr_api.g_varchar2,

469: p_ra_effective_date in date default hr_api.g_date,
470: p_record_source in varchar2 default hr_api.g_varchar2,
471: p_visa_type in varchar2 default hr_api.g_varchar2,
472: p_j_sub_type in varchar2 default hr_api.g_varchar2,
473: p_primary_activity in varchar2 default hr_api.g_varchar2,
474: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
475: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
476: p_object_version_number in out nocopy number ,
477: p_date_8233_signed in date default hr_api.g_date ,

Line 474: p_non_us_country_code in varchar2 default hr_api.g_varchar2,

470: p_record_source in varchar2 default hr_api.g_varchar2,
471: p_visa_type in varchar2 default hr_api.g_varchar2,
472: p_j_sub_type in varchar2 default hr_api.g_varchar2,
473: p_primary_activity in varchar2 default hr_api.g_varchar2,
474: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
475: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
476: p_object_version_number in out nocopy number ,
477: p_date_8233_signed in date default hr_api.g_date ,
478: p_date_w4_signed in date default hr_api.g_date

Line 475: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,

471: p_visa_type in varchar2 default hr_api.g_varchar2,
472: p_j_sub_type in varchar2 default hr_api.g_varchar2,
473: p_primary_activity in varchar2 default hr_api.g_varchar2,
474: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
475: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
476: p_object_version_number in out nocopy number ,
477: p_date_8233_signed in date default hr_api.g_date ,
478: p_date_w4_signed in date default hr_api.g_date
479: ) is

Line 477: p_date_8233_signed in date default hr_api.g_date ,

473: p_primary_activity in varchar2 default hr_api.g_varchar2,
474: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
475: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
476: p_object_version_number in out nocopy number ,
477: p_date_8233_signed in date default hr_api.g_date ,
478: p_date_w4_signed in date default hr_api.g_date
479: ) is
480: --
481: l_rec pqp_aad_shd.g_rec_type;

Line 478: p_date_w4_signed in date default hr_api.g_date

474: p_non_us_country_code in varchar2 default hr_api.g_varchar2,
475: p_citizenship_country_code in varchar2 default hr_api.g_varchar2,
476: p_object_version_number in out nocopy number ,
477: p_date_8233_signed in date default hr_api.g_date ,
478: p_date_w4_signed in date default hr_api.g_date
479: ) is
480: --
481: l_rec pqp_aad_shd.g_rec_type;
482: l_proc varchar2(72) := g_package||'upd';