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_IPD_UPD dependencies on PAY_IPD_SHD

Line 58: (p_rec in out nocopy pay_ipd_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_ipd_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 124: pay_ipd_shd.constraint_error

120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: --
124: pay_ipd_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --

Line 129: pay_ipd_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --
129: pay_ipd_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: --
133: Raise;

Line 168: (p_rec in out nocopy pay_ipd_shd.g_rec_type

164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure update_dml
168: (p_rec in out nocopy pay_ipd_shd.g_rec_type
169: ,p_effective_date in date
170: ,p_datetrack_mode in varchar2
171: ,p_validation_start_date in date
172: ,p_validation_end_date in date

Line 235: (p_rec in out nocopy pay_ipd_shd.g_rec_type

231: --
232: -- {End Of Comments}
233: -- ----------------------------------------------------------------------------
234: Procedure dt_pre_update
235: (p_rec in out nocopy pay_ipd_shd.g_rec_type
236: ,p_effective_date in date
237: ,p_datetrack_mode in varchar2
238: ,p_validation_start_date in date
239: ,p_validation_end_date in date

Line 251: pay_ipd_shd.upd_effective_end_date

247: If (p_datetrack_mode <> hr_api.g_correction) then
248: --
249: -- Update the current effective end date
250: --
251: pay_ipd_shd.upd_effective_end_date
252: (p_effective_date => p_effective_date
253: ,p_base_key_value => p_rec.paye_details_id
254: ,p_new_effective_end_date => (p_validation_start_date - 1)
255: ,p_validation_start_date => p_validation_start_date

Line 320: (p_rec in out nocopy pay_ipd_shd.g_rec_type

316: --
317: -- {End Of Comments}
318: -- ----------------------------------------------------------------------------
319: Procedure pre_update
320: (p_rec in out nocopy pay_ipd_shd.g_rec_type
321: ,p_effective_date in date
322: ,p_datetrack_mode in varchar2
323: ,p_validation_start_date in date
324: ,p_validation_end_date in date

Line 378: (p_rec in pay_ipd_shd.g_rec_type

374: --
375: -- {End Of Comments}
376: -- ----------------------------------------------------------------------------
377: Procedure post_update
378: (p_rec in pay_ipd_shd.g_rec_type
379: ,p_effective_date in date
380: ,p_datetrack_mode in varchar2
381: ,p_validation_start_date in date
382: ,p_validation_end_date in date

Line 441: => pay_ipd_shd.g_old_rec.effective_start_date

437: => p_rec.program_update_date
438: ,p_certificate_issue_date
439: => p_rec.certificate_issue_date
440: ,p_effective_start_date_o
441: => pay_ipd_shd.g_old_rec.effective_start_date
442: ,p_effective_end_date_o
443: => pay_ipd_shd.g_old_rec.effective_end_date
444: ,p_object_version_number_o
445: => pay_ipd_shd.g_old_rec.object_version_number

Line 443: => pay_ipd_shd.g_old_rec.effective_end_date

439: => p_rec.certificate_issue_date
440: ,p_effective_start_date_o
441: => pay_ipd_shd.g_old_rec.effective_start_date
442: ,p_effective_end_date_o
443: => pay_ipd_shd.g_old_rec.effective_end_date
444: ,p_object_version_number_o
445: => pay_ipd_shd.g_old_rec.object_version_number
446: ,p_assignment_id_o
447: => pay_ipd_shd.g_old_rec.assignment_id

Line 445: => pay_ipd_shd.g_old_rec.object_version_number

441: => pay_ipd_shd.g_old_rec.effective_start_date
442: ,p_effective_end_date_o
443: => pay_ipd_shd.g_old_rec.effective_end_date
444: ,p_object_version_number_o
445: => pay_ipd_shd.g_old_rec.object_version_number
446: ,p_assignment_id_o
447: => pay_ipd_shd.g_old_rec.assignment_id
448: ,p_info_source_o
449: => pay_ipd_shd.g_old_rec.info_source

Line 447: => pay_ipd_shd.g_old_rec.assignment_id

443: => pay_ipd_shd.g_old_rec.effective_end_date
444: ,p_object_version_number_o
445: => pay_ipd_shd.g_old_rec.object_version_number
446: ,p_assignment_id_o
447: => pay_ipd_shd.g_old_rec.assignment_id
448: ,p_info_source_o
449: => pay_ipd_shd.g_old_rec.info_source
450: ,p_comm_period_no_o
451: => pay_ipd_shd.g_old_rec.comm_period_no

Line 449: => pay_ipd_shd.g_old_rec.info_source

445: => pay_ipd_shd.g_old_rec.object_version_number
446: ,p_assignment_id_o
447: => pay_ipd_shd.g_old_rec.assignment_id
448: ,p_info_source_o
449: => pay_ipd_shd.g_old_rec.info_source
450: ,p_comm_period_no_o
451: => pay_ipd_shd.g_old_rec.comm_period_no
452: ,p_tax_basis_o
453: => pay_ipd_shd.g_old_rec.tax_basis

Line 451: => pay_ipd_shd.g_old_rec.comm_period_no

447: => pay_ipd_shd.g_old_rec.assignment_id
448: ,p_info_source_o
449: => pay_ipd_shd.g_old_rec.info_source
450: ,p_comm_period_no_o
451: => pay_ipd_shd.g_old_rec.comm_period_no
452: ,p_tax_basis_o
453: => pay_ipd_shd.g_old_rec.tax_basis
454: ,p_certificate_start_date_o
455: => pay_ipd_shd.g_old_rec.certificate_start_date

Line 453: => pay_ipd_shd.g_old_rec.tax_basis

449: => pay_ipd_shd.g_old_rec.info_source
450: ,p_comm_period_no_o
451: => pay_ipd_shd.g_old_rec.comm_period_no
452: ,p_tax_basis_o
453: => pay_ipd_shd.g_old_rec.tax_basis
454: ,p_certificate_start_date_o
455: => pay_ipd_shd.g_old_rec.certificate_start_date
456: ,p_certificate_end_date_o
457: => pay_ipd_shd.g_old_rec.certificate_end_date

Line 455: => pay_ipd_shd.g_old_rec.certificate_start_date

451: => pay_ipd_shd.g_old_rec.comm_period_no
452: ,p_tax_basis_o
453: => pay_ipd_shd.g_old_rec.tax_basis
454: ,p_certificate_start_date_o
455: => pay_ipd_shd.g_old_rec.certificate_start_date
456: ,p_certificate_end_date_o
457: => pay_ipd_shd.g_old_rec.certificate_end_date
458: ,p_tax_assess_basis_o
459: => pay_ipd_shd.g_old_rec.tax_assess_basis

Line 457: => pay_ipd_shd.g_old_rec.certificate_end_date

453: => pay_ipd_shd.g_old_rec.tax_basis
454: ,p_certificate_start_date_o
455: => pay_ipd_shd.g_old_rec.certificate_start_date
456: ,p_certificate_end_date_o
457: => pay_ipd_shd.g_old_rec.certificate_end_date
458: ,p_tax_assess_basis_o
459: => pay_ipd_shd.g_old_rec.tax_assess_basis
460: ,p_weekly_tax_credit_o
461: => pay_ipd_shd.g_old_rec.weekly_tax_credit

Line 459: => pay_ipd_shd.g_old_rec.tax_assess_basis

455: => pay_ipd_shd.g_old_rec.certificate_start_date
456: ,p_certificate_end_date_o
457: => pay_ipd_shd.g_old_rec.certificate_end_date
458: ,p_tax_assess_basis_o
459: => pay_ipd_shd.g_old_rec.tax_assess_basis
460: ,p_weekly_tax_credit_o
461: => pay_ipd_shd.g_old_rec.weekly_tax_credit
462: ,p_weekly_std_rate_cut_off_o
463: => pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off

Line 461: => pay_ipd_shd.g_old_rec.weekly_tax_credit

457: => pay_ipd_shd.g_old_rec.certificate_end_date
458: ,p_tax_assess_basis_o
459: => pay_ipd_shd.g_old_rec.tax_assess_basis
460: ,p_weekly_tax_credit_o
461: => pay_ipd_shd.g_old_rec.weekly_tax_credit
462: ,p_weekly_std_rate_cut_off_o
463: => pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off
464: ,p_monthly_tax_credit_o
465: => pay_ipd_shd.g_old_rec.monthly_tax_credit

Line 463: => pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off

459: => pay_ipd_shd.g_old_rec.tax_assess_basis
460: ,p_weekly_tax_credit_o
461: => pay_ipd_shd.g_old_rec.weekly_tax_credit
462: ,p_weekly_std_rate_cut_off_o
463: => pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off
464: ,p_monthly_tax_credit_o
465: => pay_ipd_shd.g_old_rec.monthly_tax_credit
466: ,p_monthly_std_rate_cut_off_o
467: => pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off

Line 465: => pay_ipd_shd.g_old_rec.monthly_tax_credit

461: => pay_ipd_shd.g_old_rec.weekly_tax_credit
462: ,p_weekly_std_rate_cut_off_o
463: => pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off
464: ,p_monthly_tax_credit_o
465: => pay_ipd_shd.g_old_rec.monthly_tax_credit
466: ,p_monthly_std_rate_cut_off_o
467: => pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off
468: ,p_request_id_o
469: => pay_ipd_shd.g_old_rec.request_id

Line 467: => pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off

463: => pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off
464: ,p_monthly_tax_credit_o
465: => pay_ipd_shd.g_old_rec.monthly_tax_credit
466: ,p_monthly_std_rate_cut_off_o
467: => pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off
468: ,p_request_id_o
469: => pay_ipd_shd.g_old_rec.request_id
470: ,p_program_application_id_o
471: => pay_ipd_shd.g_old_rec.program_application_id

Line 469: => pay_ipd_shd.g_old_rec.request_id

465: => pay_ipd_shd.g_old_rec.monthly_tax_credit
466: ,p_monthly_std_rate_cut_off_o
467: => pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off
468: ,p_request_id_o
469: => pay_ipd_shd.g_old_rec.request_id
470: ,p_program_application_id_o
471: => pay_ipd_shd.g_old_rec.program_application_id
472: ,p_program_id_o
473: => pay_ipd_shd.g_old_rec.program_id

Line 471: => pay_ipd_shd.g_old_rec.program_application_id

467: => pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off
468: ,p_request_id_o
469: => pay_ipd_shd.g_old_rec.request_id
470: ,p_program_application_id_o
471: => pay_ipd_shd.g_old_rec.program_application_id
472: ,p_program_id_o
473: => pay_ipd_shd.g_old_rec.program_id
474: ,p_program_update_date_o
475: => pay_ipd_shd.g_old_rec.program_update_date

Line 473: => pay_ipd_shd.g_old_rec.program_id

469: => pay_ipd_shd.g_old_rec.request_id
470: ,p_program_application_id_o
471: => pay_ipd_shd.g_old_rec.program_application_id
472: ,p_program_id_o
473: => pay_ipd_shd.g_old_rec.program_id
474: ,p_program_update_date_o
475: => pay_ipd_shd.g_old_rec.program_update_date
476: ,p_certificate_issue_date_o
477: => pay_ipd_shd.g_old_rec.certificate_issue_date

Line 475: => pay_ipd_shd.g_old_rec.program_update_date

471: => pay_ipd_shd.g_old_rec.program_application_id
472: ,p_program_id_o
473: => pay_ipd_shd.g_old_rec.program_id
474: ,p_program_update_date_o
475: => pay_ipd_shd.g_old_rec.program_update_date
476: ,p_certificate_issue_date_o
477: => pay_ipd_shd.g_old_rec.certificate_issue_date
478: );
479: --

Line 477: => pay_ipd_shd.g_old_rec.certificate_issue_date

473: => pay_ipd_shd.g_old_rec.program_id
474: ,p_program_update_date_o
475: => pay_ipd_shd.g_old_rec.program_update_date
476: ,p_certificate_issue_date_o
477: => pay_ipd_shd.g_old_rec.certificate_issue_date
478: );
479: --
480: exception
481: --

Line 537: (p_rec in out nocopy pay_ipd_shd.g_rec_type

533: --
534: -- {End Of Comments}
535: -- ----------------------------------------------------------------------------
536: Procedure convert_defs
537: (p_rec in out nocopy pay_ipd_shd.g_rec_type
538: ) is
539: --
540: Begin
541: --

Line 549: pay_ipd_shd.g_old_rec.assignment_id;

545: -- is being used then we must set to the 'current' argument value.
546: --
547: If (p_rec.assignment_id = hr_api.g_number) then
548: p_rec.assignment_id :=
549: pay_ipd_shd.g_old_rec.assignment_id;
550: End If;
551: If (p_rec.info_source = hr_api.g_varchar2) then
552: p_rec.info_source :=
553: pay_ipd_shd.g_old_rec.info_source;

Line 553: pay_ipd_shd.g_old_rec.info_source;

549: pay_ipd_shd.g_old_rec.assignment_id;
550: End If;
551: If (p_rec.info_source = hr_api.g_varchar2) then
552: p_rec.info_source :=
553: pay_ipd_shd.g_old_rec.info_source;
554: End If;
555: If (p_rec.comm_period_no = hr_api.g_number) then
556: p_rec.comm_period_no :=
557: pay_ipd_shd.g_old_rec.comm_period_no;

Line 557: pay_ipd_shd.g_old_rec.comm_period_no;

553: pay_ipd_shd.g_old_rec.info_source;
554: End If;
555: If (p_rec.comm_period_no = hr_api.g_number) then
556: p_rec.comm_period_no :=
557: pay_ipd_shd.g_old_rec.comm_period_no;
558: End If;
559: If (p_rec.tax_basis = hr_api.g_varchar2) then
560: p_rec.tax_basis :=
561: pay_ipd_shd.g_old_rec.tax_basis;

Line 561: pay_ipd_shd.g_old_rec.tax_basis;

557: pay_ipd_shd.g_old_rec.comm_period_no;
558: End If;
559: If (p_rec.tax_basis = hr_api.g_varchar2) then
560: p_rec.tax_basis :=
561: pay_ipd_shd.g_old_rec.tax_basis;
562: End If;
563: If (p_rec.certificate_start_date = hr_api.g_date) then
564: p_rec.certificate_start_date :=
565: pay_ipd_shd.g_old_rec.certificate_start_date;

Line 565: pay_ipd_shd.g_old_rec.certificate_start_date;

561: pay_ipd_shd.g_old_rec.tax_basis;
562: End If;
563: If (p_rec.certificate_start_date = hr_api.g_date) then
564: p_rec.certificate_start_date :=
565: pay_ipd_shd.g_old_rec.certificate_start_date;
566: End If;
567: If (p_rec.certificate_end_date = hr_api.g_date) then
568: p_rec.certificate_end_date :=
569: pay_ipd_shd.g_old_rec.certificate_end_date;

Line 569: pay_ipd_shd.g_old_rec.certificate_end_date;

565: pay_ipd_shd.g_old_rec.certificate_start_date;
566: End If;
567: If (p_rec.certificate_end_date = hr_api.g_date) then
568: p_rec.certificate_end_date :=
569: pay_ipd_shd.g_old_rec.certificate_end_date;
570: End If;
571: If (p_rec.tax_assess_basis = hr_api.g_varchar2) then
572: p_rec.tax_assess_basis :=
573: pay_ipd_shd.g_old_rec.tax_assess_basis;

Line 573: pay_ipd_shd.g_old_rec.tax_assess_basis;

569: pay_ipd_shd.g_old_rec.certificate_end_date;
570: End If;
571: If (p_rec.tax_assess_basis = hr_api.g_varchar2) then
572: p_rec.tax_assess_basis :=
573: pay_ipd_shd.g_old_rec.tax_assess_basis;
574: End If;
575: If (p_rec.weekly_tax_credit = hr_api.g_number) then
576: p_rec.weekly_tax_credit :=
577: pay_ipd_shd.g_old_rec.weekly_tax_credit;

Line 577: pay_ipd_shd.g_old_rec.weekly_tax_credit;

573: pay_ipd_shd.g_old_rec.tax_assess_basis;
574: End If;
575: If (p_rec.weekly_tax_credit = hr_api.g_number) then
576: p_rec.weekly_tax_credit :=
577: pay_ipd_shd.g_old_rec.weekly_tax_credit;
578: End If;
579: If (p_rec.weekly_std_rate_cut_off = hr_api.g_number) then
580: p_rec.weekly_std_rate_cut_off :=
581: pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off;

Line 581: pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off;

577: pay_ipd_shd.g_old_rec.weekly_tax_credit;
578: End If;
579: If (p_rec.weekly_std_rate_cut_off = hr_api.g_number) then
580: p_rec.weekly_std_rate_cut_off :=
581: pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off;
582: End If;
583: If (p_rec.monthly_tax_credit = hr_api.g_number) then
584: p_rec.monthly_tax_credit :=
585: pay_ipd_shd.g_old_rec.monthly_tax_credit;

Line 585: pay_ipd_shd.g_old_rec.monthly_tax_credit;

581: pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off;
582: End If;
583: If (p_rec.monthly_tax_credit = hr_api.g_number) then
584: p_rec.monthly_tax_credit :=
585: pay_ipd_shd.g_old_rec.monthly_tax_credit;
586: End If;
587: If (p_rec.monthly_std_rate_cut_off = hr_api.g_number) then
588: p_rec.monthly_std_rate_cut_off :=
589: pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off;

Line 589: pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off;

585: pay_ipd_shd.g_old_rec.monthly_tax_credit;
586: End If;
587: If (p_rec.monthly_std_rate_cut_off = hr_api.g_number) then
588: p_rec.monthly_std_rate_cut_off :=
589: pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off;
590: End If;
591: If (p_rec.request_id = hr_api.g_number) then
592: p_rec.request_id :=
593: pay_ipd_shd.g_old_rec.request_id;

Line 593: pay_ipd_shd.g_old_rec.request_id;

589: pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off;
590: End If;
591: If (p_rec.request_id = hr_api.g_number) then
592: p_rec.request_id :=
593: pay_ipd_shd.g_old_rec.request_id;
594: End If;
595: If (p_rec.program_application_id = hr_api.g_number) then
596: p_rec.program_application_id :=
597: pay_ipd_shd.g_old_rec.program_application_id;

Line 597: pay_ipd_shd.g_old_rec.program_application_id;

593: pay_ipd_shd.g_old_rec.request_id;
594: End If;
595: If (p_rec.program_application_id = hr_api.g_number) then
596: p_rec.program_application_id :=
597: pay_ipd_shd.g_old_rec.program_application_id;
598: End If;
599: If (p_rec.program_id = hr_api.g_number) then
600: p_rec.program_id :=
601: pay_ipd_shd.g_old_rec.program_id;

Line 601: pay_ipd_shd.g_old_rec.program_id;

597: pay_ipd_shd.g_old_rec.program_application_id;
598: End If;
599: If (p_rec.program_id = hr_api.g_number) then
600: p_rec.program_id :=
601: pay_ipd_shd.g_old_rec.program_id;
602: End If;
603: If (p_rec.program_update_date = hr_api.g_date) then
604: p_rec.program_update_date :=
605: pay_ipd_shd.g_old_rec.program_update_date;

Line 605: pay_ipd_shd.g_old_rec.program_update_date;

601: pay_ipd_shd.g_old_rec.program_id;
602: End If;
603: If (p_rec.program_update_date = hr_api.g_date) then
604: p_rec.program_update_date :=
605: pay_ipd_shd.g_old_rec.program_update_date;
606: End If;
607: If (p_rec.certificate_issue_date = hr_api.g_date) then
608: p_rec.certificate_issue_date :=
609: pay_ipd_shd.g_old_rec.certificate_issue_date;

Line 609: pay_ipd_shd.g_old_rec.certificate_issue_date;

605: pay_ipd_shd.g_old_rec.program_update_date;
606: End If;
607: If (p_rec.certificate_issue_date = hr_api.g_date) then
608: p_rec.certificate_issue_date :=
609: pay_ipd_shd.g_old_rec.certificate_issue_date;
610: End If;
611: --
612: End convert_defs;
613: --

Line 620: ,p_rec in out nocopy pay_ipd_shd.g_rec_type

616: -- ----------------------------------------------------------------------------
617: Procedure upd
618: (p_effective_date in date
619: ,p_datetrack_mode in varchar2
620: ,p_rec in out nocopy pay_ipd_shd.g_rec_type
621: ) is
622: --
623: l_proc varchar2(72) := g_package||'upd';
624: l_validation_start_date date;

Line 636: pay_ipd_shd.lck

632: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
633: --
634: -- We must lock the row which we need to update.
635: --
636: pay_ipd_shd.lck
637: (p_effective_date => p_effective_date
638: ,p_datetrack_mode => p_datetrack_mode
639: ,p_paye_details_id => p_rec.paye_details_id
640: ,p_object_version_number => p_rec.object_version_number

Line 718: l_rec pay_ipd_shd.g_rec_type;

714: ,p_effective_start_date out nocopy date
715: ,p_effective_end_date out nocopy date
716: ) is
717: --
718: l_rec pay_ipd_shd.g_rec_type;
719: l_proc varchar2(72) := g_package||'upd';
720: --
721: Begin
722: hr_utility.set_location('Entering:'||l_proc, 5);

Line 728: pay_ipd_shd.convert_args

724: -- Call conversion function to turn arguments into the
725: -- l_rec structure.
726: --
727: l_rec :=
728: pay_ipd_shd.convert_args
729: (p_paye_details_id
730: ,null
731: ,null
732: ,p_object_version_number