eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PSD_UPD dependencies on PAY_PSD_SHD

Line 58: (p_rec in out nocopy pay_psd_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_psd_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 130: pay_psd_shd.constraint_error

126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: --
130: pay_psd_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: --

Line 135: pay_psd_shd.constraint_error

131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: --
135: pay_psd_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: --
139: Raise;

Line 174: (p_rec in out nocopy pay_psd_shd.g_rec_type

170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure update_dml
174: (p_rec in out nocopy pay_psd_shd.g_rec_type
175: ,p_effective_date in date
176: ,p_datetrack_mode in varchar2
177: ,p_validation_start_date in date
178: ,p_validation_end_date in date

Line 241: (p_rec in out nocopy pay_psd_shd.g_rec_type

237: --
238: -- {End Of Comments}
239: -- ----------------------------------------------------------------------------
240: Procedure dt_pre_update
241: (p_rec in out nocopy pay_psd_shd.g_rec_type
242: ,p_effective_date in date
243: ,p_datetrack_mode in varchar2
244: ,p_validation_start_date in date
245: ,p_validation_end_date in date

Line 257: pay_psd_shd.upd_effective_end_date

253: If (p_datetrack_mode <> hr_api.g_correction) then
254: --
255: -- Update the current effective end date
256: --
257: pay_psd_shd.upd_effective_end_date
258: (p_effective_date => p_effective_date
259: ,p_base_key_value => p_rec.sii_details_id
260: ,p_new_effective_end_date => (p_validation_start_date - 1)
261: ,p_validation_start_date => p_validation_start_date

Line 326: (p_rec in out nocopy pay_psd_shd.g_rec_type

322: --
323: -- {End Of Comments}
324: -- ----------------------------------------------------------------------------
325: Procedure pre_update
326: (p_rec in out nocopy pay_psd_shd.g_rec_type
327: ,p_effective_date in date
328: ,p_datetrack_mode in varchar2
329: ,p_validation_start_date in date
330: ,p_validation_end_date in date

Line 384: (p_rec in pay_psd_shd.g_rec_type

380: --
381: -- {End Of Comments}
382: -- ----------------------------------------------------------------------------
383: Procedure post_update
384: (p_rec in pay_psd_shd.g_rec_type
385: ,p_effective_date in date
386: ,p_datetrack_mode in varchar2
387: ,p_validation_start_date in date
388: ,p_validation_end_date in date

Line 453: => pay_psd_shd.g_old_rec.effective_start_date

449: => p_rec.program_application_id
450: ,p_request_id
451: => p_rec.request_id
452: ,p_effective_start_date_o
453: => pay_psd_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o
455: => pay_psd_shd.g_old_rec.effective_end_date
456: ,p_per_or_asg_id_o
457: => pay_psd_shd.g_old_rec.per_or_asg_id

Line 455: => pay_psd_shd.g_old_rec.effective_end_date

451: => p_rec.request_id
452: ,p_effective_start_date_o
453: => pay_psd_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o
455: => pay_psd_shd.g_old_rec.effective_end_date
456: ,p_per_or_asg_id_o
457: => pay_psd_shd.g_old_rec.per_or_asg_id
458: ,p_business_group_id_o
459: => pay_psd_shd.g_old_rec.business_group_id

Line 457: => pay_psd_shd.g_old_rec.per_or_asg_id

453: => pay_psd_shd.g_old_rec.effective_start_date
454: ,p_effective_end_date_o
455: => pay_psd_shd.g_old_rec.effective_end_date
456: ,p_per_or_asg_id_o
457: => pay_psd_shd.g_old_rec.per_or_asg_id
458: ,p_business_group_id_o
459: => pay_psd_shd.g_old_rec.business_group_id
460: ,p_contract_category_o
461: => pay_psd_shd.g_old_rec.contract_category

Line 459: => pay_psd_shd.g_old_rec.business_group_id

455: => pay_psd_shd.g_old_rec.effective_end_date
456: ,p_per_or_asg_id_o
457: => pay_psd_shd.g_old_rec.per_or_asg_id
458: ,p_business_group_id_o
459: => pay_psd_shd.g_old_rec.business_group_id
460: ,p_contract_category_o
461: => pay_psd_shd.g_old_rec.contract_category
462: ,p_object_version_number_o
463: => pay_psd_shd.g_old_rec.object_version_number

Line 461: => pay_psd_shd.g_old_rec.contract_category

457: => pay_psd_shd.g_old_rec.per_or_asg_id
458: ,p_business_group_id_o
459: => pay_psd_shd.g_old_rec.business_group_id
460: ,p_contract_category_o
461: => pay_psd_shd.g_old_rec.contract_category
462: ,p_object_version_number_o
463: => pay_psd_shd.g_old_rec.object_version_number
464: ,p_emp_social_security_info_o
465: => pay_psd_shd.g_old_rec.emp_social_security_info

Line 463: => pay_psd_shd.g_old_rec.object_version_number

459: => pay_psd_shd.g_old_rec.business_group_id
460: ,p_contract_category_o
461: => pay_psd_shd.g_old_rec.contract_category
462: ,p_object_version_number_o
463: => pay_psd_shd.g_old_rec.object_version_number
464: ,p_emp_social_security_info_o
465: => pay_psd_shd.g_old_rec.emp_social_security_info
466: ,p_old_age_contribution_o
467: => pay_psd_shd.g_old_rec.old_age_contribution

Line 465: => pay_psd_shd.g_old_rec.emp_social_security_info

461: => pay_psd_shd.g_old_rec.contract_category
462: ,p_object_version_number_o
463: => pay_psd_shd.g_old_rec.object_version_number
464: ,p_emp_social_security_info_o
465: => pay_psd_shd.g_old_rec.emp_social_security_info
466: ,p_old_age_contribution_o
467: => pay_psd_shd.g_old_rec.old_age_contribution
468: ,p_pension_contribution_o
469: => pay_psd_shd.g_old_rec.pension_contribution

Line 467: => pay_psd_shd.g_old_rec.old_age_contribution

463: => pay_psd_shd.g_old_rec.object_version_number
464: ,p_emp_social_security_info_o
465: => pay_psd_shd.g_old_rec.emp_social_security_info
466: ,p_old_age_contribution_o
467: => pay_psd_shd.g_old_rec.old_age_contribution
468: ,p_pension_contribution_o
469: => pay_psd_shd.g_old_rec.pension_contribution
470: ,p_sickness_contribution_o
471: => pay_psd_shd.g_old_rec.sickness_contribution

Line 469: => pay_psd_shd.g_old_rec.pension_contribution

465: => pay_psd_shd.g_old_rec.emp_social_security_info
466: ,p_old_age_contribution_o
467: => pay_psd_shd.g_old_rec.old_age_contribution
468: ,p_pension_contribution_o
469: => pay_psd_shd.g_old_rec.pension_contribution
470: ,p_sickness_contribution_o
471: => pay_psd_shd.g_old_rec.sickness_contribution
472: ,p_work_injury_contribution_o
473: => pay_psd_shd.g_old_rec.work_injury_contribution

Line 471: => pay_psd_shd.g_old_rec.sickness_contribution

467: => pay_psd_shd.g_old_rec.old_age_contribution
468: ,p_pension_contribution_o
469: => pay_psd_shd.g_old_rec.pension_contribution
470: ,p_sickness_contribution_o
471: => pay_psd_shd.g_old_rec.sickness_contribution
472: ,p_work_injury_contribution_o
473: => pay_psd_shd.g_old_rec.work_injury_contribution
474: ,p_labor_contribution_o
475: => pay_psd_shd.g_old_rec.labor_contribution

Line 473: => pay_psd_shd.g_old_rec.work_injury_contribution

469: => pay_psd_shd.g_old_rec.pension_contribution
470: ,p_sickness_contribution_o
471: => pay_psd_shd.g_old_rec.sickness_contribution
472: ,p_work_injury_contribution_o
473: => pay_psd_shd.g_old_rec.work_injury_contribution
474: ,p_labor_contribution_o
475: => pay_psd_shd.g_old_rec.labor_contribution
476: ,p_health_contribution_o
477: => pay_psd_shd.g_old_rec.health_contribution

Line 475: => pay_psd_shd.g_old_rec.labor_contribution

471: => pay_psd_shd.g_old_rec.sickness_contribution
472: ,p_work_injury_contribution_o
473: => pay_psd_shd.g_old_rec.work_injury_contribution
474: ,p_labor_contribution_o
475: => pay_psd_shd.g_old_rec.labor_contribution
476: ,p_health_contribution_o
477: => pay_psd_shd.g_old_rec.health_contribution
478: ,p_unemployment_contribution_o
479: => pay_psd_shd.g_old_rec.unemployment_contribution

Line 477: => pay_psd_shd.g_old_rec.health_contribution

473: => pay_psd_shd.g_old_rec.work_injury_contribution
474: ,p_labor_contribution_o
475: => pay_psd_shd.g_old_rec.labor_contribution
476: ,p_health_contribution_o
477: => pay_psd_shd.g_old_rec.health_contribution
478: ,p_unemployment_contribution_o
479: => pay_psd_shd.g_old_rec.unemployment_contribution
480: ,p_old_age_cont_end_reason_o
481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason

Line 479: => pay_psd_shd.g_old_rec.unemployment_contribution

475: => pay_psd_shd.g_old_rec.labor_contribution
476: ,p_health_contribution_o
477: => pay_psd_shd.g_old_rec.health_contribution
478: ,p_unemployment_contribution_o
479: => pay_psd_shd.g_old_rec.unemployment_contribution
480: ,p_old_age_cont_end_reason_o
481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
482: ,p_pension_cont_end_reason_o
483: => pay_psd_shd.g_old_rec.pension_cont_end_reason

Line 481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason

477: => pay_psd_shd.g_old_rec.health_contribution
478: ,p_unemployment_contribution_o
479: => pay_psd_shd.g_old_rec.unemployment_contribution
480: ,p_old_age_cont_end_reason_o
481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
482: ,p_pension_cont_end_reason_o
483: => pay_psd_shd.g_old_rec.pension_cont_end_reason
484: ,p_sickness_cont_end_reason_o
485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason

Line 483: => pay_psd_shd.g_old_rec.pension_cont_end_reason

479: => pay_psd_shd.g_old_rec.unemployment_contribution
480: ,p_old_age_cont_end_reason_o
481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
482: ,p_pension_cont_end_reason_o
483: => pay_psd_shd.g_old_rec.pension_cont_end_reason
484: ,p_sickness_cont_end_reason_o
485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
486: ,p_work_injury_cont_end_reaso_o
487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason

Line 485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason

481: => pay_psd_shd.g_old_rec.old_age_cont_end_reason
482: ,p_pension_cont_end_reason_o
483: => pay_psd_shd.g_old_rec.pension_cont_end_reason
484: ,p_sickness_cont_end_reason_o
485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
486: ,p_work_injury_cont_end_reaso_o
487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
488: ,p_labor_fund_cont_end_reason_o
489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason

Line 487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason

483: => pay_psd_shd.g_old_rec.pension_cont_end_reason
484: ,p_sickness_cont_end_reason_o
485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
486: ,p_work_injury_cont_end_reaso_o
487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
488: ,p_labor_fund_cont_end_reason_o
489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
490: ,p_health_cont_end_reason_o
491: => pay_psd_shd.g_old_rec.health_cont_end_reason

Line 489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason

485: => pay_psd_shd.g_old_rec.sickness_cont_end_reason
486: ,p_work_injury_cont_end_reaso_o
487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
488: ,p_labor_fund_cont_end_reason_o
489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
490: ,p_health_cont_end_reason_o
491: => pay_psd_shd.g_old_rec.health_cont_end_reason
492: ,p_unemployment_cont_end_reas_o
493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason

Line 491: => pay_psd_shd.g_old_rec.health_cont_end_reason

487: => pay_psd_shd.g_old_rec.work_injury_cont_end_reason
488: ,p_labor_fund_cont_end_reason_o
489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
490: ,p_health_cont_end_reason_o
491: => pay_psd_shd.g_old_rec.health_cont_end_reason
492: ,p_unemployment_cont_end_reas_o
493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
494: ,p_program_id_o
495: => pay_psd_shd.g_old_rec.program_id

Line 493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason

489: => pay_psd_shd.g_old_rec.labor_fund_cont_end_reason
490: ,p_health_cont_end_reason_o
491: => pay_psd_shd.g_old_rec.health_cont_end_reason
492: ,p_unemployment_cont_end_reas_o
493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
494: ,p_program_id_o
495: => pay_psd_shd.g_old_rec.program_id
496: ,p_program_login_id_o
497: => pay_psd_shd.g_old_rec.program_login_id

Line 495: => pay_psd_shd.g_old_rec.program_id

491: => pay_psd_shd.g_old_rec.health_cont_end_reason
492: ,p_unemployment_cont_end_reas_o
493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
494: ,p_program_id_o
495: => pay_psd_shd.g_old_rec.program_id
496: ,p_program_login_id_o
497: => pay_psd_shd.g_old_rec.program_login_id
498: ,p_program_application_id_o
499: => pay_psd_shd.g_old_rec.program_application_id

Line 497: => pay_psd_shd.g_old_rec.program_login_id

493: => pay_psd_shd.g_old_rec.unemployment_cont_end_reason
494: ,p_program_id_o
495: => pay_psd_shd.g_old_rec.program_id
496: ,p_program_login_id_o
497: => pay_psd_shd.g_old_rec.program_login_id
498: ,p_program_application_id_o
499: => pay_psd_shd.g_old_rec.program_application_id
500: ,p_request_id_o
501: => pay_psd_shd.g_old_rec.request_id

Line 499: => pay_psd_shd.g_old_rec.program_application_id

495: => pay_psd_shd.g_old_rec.program_id
496: ,p_program_login_id_o
497: => pay_psd_shd.g_old_rec.program_login_id
498: ,p_program_application_id_o
499: => pay_psd_shd.g_old_rec.program_application_id
500: ,p_request_id_o
501: => pay_psd_shd.g_old_rec.request_id
502: );
503: --

Line 501: => pay_psd_shd.g_old_rec.request_id

497: => pay_psd_shd.g_old_rec.program_login_id
498: ,p_program_application_id_o
499: => pay_psd_shd.g_old_rec.program_application_id
500: ,p_request_id_o
501: => pay_psd_shd.g_old_rec.request_id
502: );
503: --
504: exception
505: --

Line 561: (p_rec in out nocopy pay_psd_shd.g_rec_type

557: --
558: -- {End Of Comments}
559: -- ----------------------------------------------------------------------------
560: Procedure convert_defs
561: (p_rec in out nocopy pay_psd_shd.g_rec_type
562: ) is
563: --
564: Begin
565: --

Line 573: pay_psd_shd.g_old_rec.per_or_asg_id;

569: -- is being used then we must set to the 'current' argument value.
570: --
571: If (p_rec.per_or_asg_id = hr_api.g_number) then
572: p_rec.per_or_asg_id :=
573: pay_psd_shd.g_old_rec.per_or_asg_id;
574: End If;
575: If (p_rec.business_group_id = hr_api.g_number) then
576: p_rec.business_group_id :=
577: pay_psd_shd.g_old_rec.business_group_id;

Line 577: pay_psd_shd.g_old_rec.business_group_id;

573: pay_psd_shd.g_old_rec.per_or_asg_id;
574: End If;
575: If (p_rec.business_group_id = hr_api.g_number) then
576: p_rec.business_group_id :=
577: pay_psd_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.contract_category = hr_api.g_varchar2) then
580: p_rec.contract_category :=
581: pay_psd_shd.g_old_rec.contract_category;

Line 581: pay_psd_shd.g_old_rec.contract_category;

577: pay_psd_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.contract_category = hr_api.g_varchar2) then
580: p_rec.contract_category :=
581: pay_psd_shd.g_old_rec.contract_category;
582: End If;
583: If (p_rec.emp_social_security_info = hr_api.g_varchar2) then
584: p_rec.emp_social_security_info :=
585: pay_psd_shd.g_old_rec.emp_social_security_info;

Line 585: pay_psd_shd.g_old_rec.emp_social_security_info;

581: pay_psd_shd.g_old_rec.contract_category;
582: End If;
583: If (p_rec.emp_social_security_info = hr_api.g_varchar2) then
584: p_rec.emp_social_security_info :=
585: pay_psd_shd.g_old_rec.emp_social_security_info;
586: End If;
587: If (p_rec.old_age_contribution = hr_api.g_varchar2) then
588: p_rec.old_age_contribution :=
589: pay_psd_shd.g_old_rec.old_age_contribution;

Line 589: pay_psd_shd.g_old_rec.old_age_contribution;

585: pay_psd_shd.g_old_rec.emp_social_security_info;
586: End If;
587: If (p_rec.old_age_contribution = hr_api.g_varchar2) then
588: p_rec.old_age_contribution :=
589: pay_psd_shd.g_old_rec.old_age_contribution;
590: End If;
591: If (p_rec.pension_contribution = hr_api.g_varchar2) then
592: p_rec.pension_contribution :=
593: pay_psd_shd.g_old_rec.pension_contribution;

Line 593: pay_psd_shd.g_old_rec.pension_contribution;

589: pay_psd_shd.g_old_rec.old_age_contribution;
590: End If;
591: If (p_rec.pension_contribution = hr_api.g_varchar2) then
592: p_rec.pension_contribution :=
593: pay_psd_shd.g_old_rec.pension_contribution;
594: End If;
595: If (p_rec.sickness_contribution = hr_api.g_varchar2) then
596: p_rec.sickness_contribution :=
597: pay_psd_shd.g_old_rec.sickness_contribution;

Line 597: pay_psd_shd.g_old_rec.sickness_contribution;

593: pay_psd_shd.g_old_rec.pension_contribution;
594: End If;
595: If (p_rec.sickness_contribution = hr_api.g_varchar2) then
596: p_rec.sickness_contribution :=
597: pay_psd_shd.g_old_rec.sickness_contribution;
598: End If;
599: If (p_rec.work_injury_contribution = hr_api.g_varchar2) then
600: p_rec.work_injury_contribution :=
601: pay_psd_shd.g_old_rec.work_injury_contribution;

Line 601: pay_psd_shd.g_old_rec.work_injury_contribution;

597: pay_psd_shd.g_old_rec.sickness_contribution;
598: End If;
599: If (p_rec.work_injury_contribution = hr_api.g_varchar2) then
600: p_rec.work_injury_contribution :=
601: pay_psd_shd.g_old_rec.work_injury_contribution;
602: End If;
603: If (p_rec.labor_contribution = hr_api.g_varchar2) then
604: p_rec.labor_contribution :=
605: pay_psd_shd.g_old_rec.labor_contribution;

Line 605: pay_psd_shd.g_old_rec.labor_contribution;

601: pay_psd_shd.g_old_rec.work_injury_contribution;
602: End If;
603: If (p_rec.labor_contribution = hr_api.g_varchar2) then
604: p_rec.labor_contribution :=
605: pay_psd_shd.g_old_rec.labor_contribution;
606: End If;
607: If (p_rec.health_contribution = hr_api.g_varchar2) then
608: p_rec.health_contribution :=
609: pay_psd_shd.g_old_rec.health_contribution;

Line 609: pay_psd_shd.g_old_rec.health_contribution;

605: pay_psd_shd.g_old_rec.labor_contribution;
606: End If;
607: If (p_rec.health_contribution = hr_api.g_varchar2) then
608: p_rec.health_contribution :=
609: pay_psd_shd.g_old_rec.health_contribution;
610: End If;
611: If (p_rec.unemployment_contribution = hr_api.g_varchar2) then
612: p_rec.unemployment_contribution :=
613: pay_psd_shd.g_old_rec.unemployment_contribution;

Line 613: pay_psd_shd.g_old_rec.unemployment_contribution;

609: pay_psd_shd.g_old_rec.health_contribution;
610: End If;
611: If (p_rec.unemployment_contribution = hr_api.g_varchar2) then
612: p_rec.unemployment_contribution :=
613: pay_psd_shd.g_old_rec.unemployment_contribution;
614: End If;
615: If (p_rec.old_age_cont_end_reason = hr_api.g_varchar2) then
616: p_rec.old_age_cont_end_reason :=
617: pay_psd_shd.g_old_rec.old_age_cont_end_reason;

Line 617: pay_psd_shd.g_old_rec.old_age_cont_end_reason;

613: pay_psd_shd.g_old_rec.unemployment_contribution;
614: End If;
615: If (p_rec.old_age_cont_end_reason = hr_api.g_varchar2) then
616: p_rec.old_age_cont_end_reason :=
617: pay_psd_shd.g_old_rec.old_age_cont_end_reason;
618: End If;
619: If (p_rec.pension_cont_end_reason = hr_api.g_varchar2) then
620: p_rec.pension_cont_end_reason :=
621: pay_psd_shd.g_old_rec.pension_cont_end_reason;

Line 621: pay_psd_shd.g_old_rec.pension_cont_end_reason;

617: pay_psd_shd.g_old_rec.old_age_cont_end_reason;
618: End If;
619: If (p_rec.pension_cont_end_reason = hr_api.g_varchar2) then
620: p_rec.pension_cont_end_reason :=
621: pay_psd_shd.g_old_rec.pension_cont_end_reason;
622: End If;
623: If (p_rec.sickness_cont_end_reason = hr_api.g_varchar2) then
624: p_rec.sickness_cont_end_reason :=
625: pay_psd_shd.g_old_rec.sickness_cont_end_reason;

Line 625: pay_psd_shd.g_old_rec.sickness_cont_end_reason;

621: pay_psd_shd.g_old_rec.pension_cont_end_reason;
622: End If;
623: If (p_rec.sickness_cont_end_reason = hr_api.g_varchar2) then
624: p_rec.sickness_cont_end_reason :=
625: pay_psd_shd.g_old_rec.sickness_cont_end_reason;
626: End If;
627: If (p_rec.work_injury_cont_end_reason = hr_api.g_varchar2) then
628: p_rec.work_injury_cont_end_reason :=
629: pay_psd_shd.g_old_rec.work_injury_cont_end_reason;

Line 629: pay_psd_shd.g_old_rec.work_injury_cont_end_reason;

625: pay_psd_shd.g_old_rec.sickness_cont_end_reason;
626: End If;
627: If (p_rec.work_injury_cont_end_reason = hr_api.g_varchar2) then
628: p_rec.work_injury_cont_end_reason :=
629: pay_psd_shd.g_old_rec.work_injury_cont_end_reason;
630: End If;
631: If (p_rec.labor_fund_cont_end_reason = hr_api.g_varchar2) then
632: p_rec.labor_fund_cont_end_reason :=
633: pay_psd_shd.g_old_rec.labor_fund_cont_end_reason;

Line 633: pay_psd_shd.g_old_rec.labor_fund_cont_end_reason;

629: pay_psd_shd.g_old_rec.work_injury_cont_end_reason;
630: End If;
631: If (p_rec.labor_fund_cont_end_reason = hr_api.g_varchar2) then
632: p_rec.labor_fund_cont_end_reason :=
633: pay_psd_shd.g_old_rec.labor_fund_cont_end_reason;
634: End If;
635: If (p_rec.health_cont_end_reason = hr_api.g_varchar2) then
636: p_rec.health_cont_end_reason :=
637: pay_psd_shd.g_old_rec.health_cont_end_reason;

Line 637: pay_psd_shd.g_old_rec.health_cont_end_reason;

633: pay_psd_shd.g_old_rec.labor_fund_cont_end_reason;
634: End If;
635: If (p_rec.health_cont_end_reason = hr_api.g_varchar2) then
636: p_rec.health_cont_end_reason :=
637: pay_psd_shd.g_old_rec.health_cont_end_reason;
638: End If;
639: If (p_rec.unemployment_cont_end_reason = hr_api.g_varchar2) then
640: p_rec.unemployment_cont_end_reason :=
641: pay_psd_shd.g_old_rec.unemployment_cont_end_reason;

Line 641: pay_psd_shd.g_old_rec.unemployment_cont_end_reason;

637: pay_psd_shd.g_old_rec.health_cont_end_reason;
638: End If;
639: If (p_rec.unemployment_cont_end_reason = hr_api.g_varchar2) then
640: p_rec.unemployment_cont_end_reason :=
641: pay_psd_shd.g_old_rec.unemployment_cont_end_reason;
642: End If;
643: If (p_rec.program_id = hr_api.g_number) then
644: p_rec.program_id :=
645: pay_psd_shd.g_old_rec.program_id;

Line 645: pay_psd_shd.g_old_rec.program_id;

641: pay_psd_shd.g_old_rec.unemployment_cont_end_reason;
642: End If;
643: If (p_rec.program_id = hr_api.g_number) then
644: p_rec.program_id :=
645: pay_psd_shd.g_old_rec.program_id;
646: End If;
647: If (p_rec.program_login_id = hr_api.g_number) then
648: p_rec.program_login_id :=
649: pay_psd_shd.g_old_rec.program_login_id;

Line 649: pay_psd_shd.g_old_rec.program_login_id;

645: pay_psd_shd.g_old_rec.program_id;
646: End If;
647: If (p_rec.program_login_id = hr_api.g_number) then
648: p_rec.program_login_id :=
649: pay_psd_shd.g_old_rec.program_login_id;
650: End If;
651: If (p_rec.program_application_id = hr_api.g_number) then
652: p_rec.program_application_id :=
653: pay_psd_shd.g_old_rec.program_application_id;

Line 653: pay_psd_shd.g_old_rec.program_application_id;

649: pay_psd_shd.g_old_rec.program_login_id;
650: End If;
651: If (p_rec.program_application_id = hr_api.g_number) then
652: p_rec.program_application_id :=
653: pay_psd_shd.g_old_rec.program_application_id;
654: End If;
655: If (p_rec.request_id = hr_api.g_number) then
656: p_rec.request_id :=
657: pay_psd_shd.g_old_rec.request_id;

Line 657: pay_psd_shd.g_old_rec.request_id;

653: pay_psd_shd.g_old_rec.program_application_id;
654: End If;
655: If (p_rec.request_id = hr_api.g_number) then
656: p_rec.request_id :=
657: pay_psd_shd.g_old_rec.request_id;
658: End If;
659: --
660: End convert_defs;
661: --

Line 668: ,p_rec in out nocopy pay_psd_shd.g_rec_type

664: -- ----------------------------------------------------------------------------
665: Procedure upd
666: (p_effective_date in date
667: ,p_datetrack_mode in varchar2
668: ,p_rec in out nocopy pay_psd_shd.g_rec_type
669: ) is
670: --
671: l_proc varchar2(72) := g_package||'upd';
672: l_validation_start_date date;

Line 684: pay_psd_shd.lck

680: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
681: --
682: -- We must lock the row which we need to update.
683: --
684: pay_psd_shd.lck
685: (p_effective_date => p_effective_date
686: ,p_datetrack_mode => p_datetrack_mode
687: ,p_sii_details_id => p_rec.sii_details_id
688: ,p_object_version_number => p_rec.object_version_number

Line 777: l_rec pay_psd_shd.g_rec_type;

773: ,p_effective_start_date out nocopy date
774: ,p_effective_end_date out nocopy date
775: ) is
776: --
777: l_rec pay_psd_shd.g_rec_type;
778: l_proc varchar2(72) := g_package||'upd';
779: --
780: Begin
781: hr_utility.set_location('Entering:'||l_proc, 5);

Line 787: pay_psd_shd.convert_args

783: -- Call conversion function to turn arguments into the
784: -- l_rec structure.
785: --
786: l_rec :=
787: pay_psd_shd.convert_args
788: (p_sii_details_id
789: ,null
790: ,null
791: ,hr_api.g_number