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.PER_APL_BUS dependencies on PER_APPLICATIONS

Line 148: ,p_descflex_name => 'PER_APPLICATIONS'

144: -- so we must call the DFF validation routine
145: --
146: hr_dflex_utility.ins_or_upd_descflex_attribs(
147: p_appl_short_name => 'PER'
148: ,p_descflex_name => 'PER_APPLICATIONS'
149: ,p_attribute_category => p_rec.appl_attribute_category
150: ,p_attribute1_name => 'APPL_ATTRIBUTE1'
151: ,p_attribute1_value => p_rec.appl_attribute1
152: ,p_attribute2_name => 'APPL_ATTRIBUTE2'

Line 260: ,p_descflex_name => 'PER_APPLICATIONS'

256: --
257: if nvl(p_validate_df_flex,true) then -- 4689836
258: hr_dflex_utility.ins_or_upd_descflex_attribs(
259: p_appl_short_name => 'PER'
260: ,p_descflex_name => 'PER_APPLICATIONS'
261: ,p_attribute_category => p_rec.appl_attribute_category
262: ,p_attribute1_name => 'APPL_ATTRIBUTE1'
263: ,p_attribute1_value => p_rec.appl_attribute1
264: ,p_attribute2_name => 'APPL_ATTRIBUTE2'

Line 405: (p_person_id in per_applications.person_id%TYPE

401: -- ----------------------------------------------------------------------------
402: -- |--------------------< chk_date_received_person_id >-----------------------|
403: -- ----------------------------------------------------------------------------
404: Procedure chk_date_received_person_id
405: (p_person_id in per_applications.person_id%TYPE
406: ,p_business_group_id in per_applications.business_group_id%TYPE
407: ,p_date_received in per_applications.date_received%TYPE
408: ,p_date_end in per_applications.date_end%TYPE
409: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE

Line 406: ,p_business_group_id in per_applications.business_group_id%TYPE

402: -- |--------------------< chk_date_received_person_id >-----------------------|
403: -- ----------------------------------------------------------------------------
404: Procedure chk_date_received_person_id
405: (p_person_id in per_applications.person_id%TYPE
406: ,p_business_group_id in per_applications.business_group_id%TYPE
407: ,p_date_received in per_applications.date_received%TYPE
408: ,p_date_end in per_applications.date_end%TYPE
409: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
410: ,p_application_id in per_applications.application_id%TYPE

Line 407: ,p_date_received in per_applications.date_received%TYPE

403: -- ----------------------------------------------------------------------------
404: Procedure chk_date_received_person_id
405: (p_person_id in per_applications.person_id%TYPE
406: ,p_business_group_id in per_applications.business_group_id%TYPE
407: ,p_date_received in per_applications.date_received%TYPE
408: ,p_date_end in per_applications.date_end%TYPE
409: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
410: ,p_application_id in per_applications.application_id%TYPE
411: ,p_object_version_number in per_applications.object_version_number%TYPE

Line 408: ,p_date_end in per_applications.date_end%TYPE

404: Procedure chk_date_received_person_id
405: (p_person_id in per_applications.person_id%TYPE
406: ,p_business_group_id in per_applications.business_group_id%TYPE
407: ,p_date_received in per_applications.date_received%TYPE
408: ,p_date_end in per_applications.date_end%TYPE
409: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
410: ,p_application_id in per_applications.application_id%TYPE
411: ,p_object_version_number in per_applications.object_version_number%TYPE
412: ) is

Line 409: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE

405: (p_person_id in per_applications.person_id%TYPE
406: ,p_business_group_id in per_applications.business_group_id%TYPE
407: ,p_date_received in per_applications.date_received%TYPE
408: ,p_date_end in per_applications.date_end%TYPE
409: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
410: ,p_application_id in per_applications.application_id%TYPE
411: ,p_object_version_number in per_applications.object_version_number%TYPE
412: ) is
413: --

Line 410: ,p_application_id in per_applications.application_id%TYPE

406: ,p_business_group_id in per_applications.business_group_id%TYPE
407: ,p_date_received in per_applications.date_received%TYPE
408: ,p_date_end in per_applications.date_end%TYPE
409: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
410: ,p_application_id in per_applications.application_id%TYPE
411: ,p_object_version_number in per_applications.object_version_number%TYPE
412: ) is
413: --
414: l_proc varchar2(72) := g_package||'chk_person_id';

Line 411: ,p_object_version_number in per_applications.object_version_number%TYPE

407: ,p_date_received in per_applications.date_received%TYPE
408: ,p_date_end in per_applications.date_end%TYPE
409: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
410: ,p_application_id in per_applications.application_id%TYPE
411: ,p_object_version_number in per_applications.object_version_number%TYPE
412: ) is
413: --
414: l_proc varchar2(72) := g_package||'chk_person_id';
415: l_business_group_id per_applications.business_group_id%TYPE;

Line 415: l_business_group_id per_applications.business_group_id%TYPE;

411: ,p_object_version_number in per_applications.object_version_number%TYPE
412: ) is
413: --
414: l_proc varchar2(72) := g_package||'chk_person_id';
415: l_business_group_id per_applications.business_group_id%TYPE;
416: l_system_person_type per_person_types.system_person_type%TYPE;
417: l_api_updating boolean;
418: l_application_id per_applications.application_id%TYPE;
419: --

Line 418: l_application_id per_applications.application_id%TYPE;

414: l_proc varchar2(72) := g_package||'chk_person_id';
415: l_business_group_id per_applications.business_group_id%TYPE;
416: l_system_person_type per_person_types.system_person_type%TYPE;
417: l_api_updating boolean;
418: l_application_id per_applications.application_id%TYPE;
419: --
420: --
421: -- Cursor to check that person_id exists, in addition obtain
422: -- the system_person_type and the business_group_id for the

Line 439: from per_applications

435: -- Cursor to check person_id, date_received combination
436: --
437: cursor csr_valid_person_per_apl is
438: select application_id
439: from per_applications
440: where person_id = p_person_id
441: and date_received = p_date_received;
442: --
443: begin

Line 489: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'

485: if (csr_valid_person_per_people_f%notfound) then
486: close csr_valid_person_per_people_f;
487: hr_utility.set_message(801,'HR_51194_APL_INV_DT_PERSON');
488: hr_multi_message.add
489: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
490: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'
491: );
492: else
493: close csr_valid_person_per_people_f;

Line 490: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'

486: close csr_valid_person_per_people_f;
487: hr_utility.set_message(801,'HR_51194_APL_INV_DT_PERSON');
488: hr_multi_message.add
489: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
490: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'
491: );
492: else
493: close csr_valid_person_per_people_f;
494: --

Line 514: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'

510: l_system_person_type <> 'APL_EX_APL' AND
511: l_system_person_type <> 'EX_EMP_APL') then
512: hr_utility.set_message(801,'HR_51185_APL_INV_SYS_PER_TYPE');
513: hr_multi_message.add
514: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
515: );
516: end if;
517: --
518: hr_utility.set_location(l_proc,51);

Line 525: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'

521: --
522: if (p_business_group_id <> l_business_group_id) then
523: hr_utility.set_message(801,'HR_51187_APL_INV_BUS_GRP');
524: hr_multi_message.add
525: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
526: );
527: end if;
528: end if;
529: end if;

Line 538: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'

534: --
535: if (p_date_received > nvl(p_date_end,hr_api.g_eot)) then
536: hr_utility.set_message(801,'HR_51188_APL_DTE_REC_DTE_END');
537: hr_multi_message.add
538: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
539: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'
540: );
541: end if;
542: --

Line 539: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'

535: if (p_date_received > nvl(p_date_end,hr_api.g_eot)) then
536: hr_utility.set_message(801,'HR_51188_APL_DTE_REC_DTE_END');
537: hr_multi_message.add
538: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
539: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'
540: );
541: end if;
542: --
543: hr_utility.set_location(l_proc,71);

Line 550: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'

546: --
547: if (p_date_received > nvl(p_projected_hire_date,hr_api.g_eot)) then
548: hr_utility.set_message(801,'HR_51189_APL_DTE_REC_PROJ_HIRE');
549: hr_multi_message.add
550: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
551: ,p_associated_column2 => 'PER_APPLICATIONS.PROJECTED_HIRE_DATE'
552: );
553: end if;
554: --

Line 551: ,p_associated_column2 => 'PER_APPLICATIONS.PROJECTED_HIRE_DATE'

547: if (p_date_received > nvl(p_projected_hire_date,hr_api.g_eot)) then
548: hr_utility.set_message(801,'HR_51189_APL_DTE_REC_PROJ_HIRE');
549: hr_multi_message.add
550: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
551: ,p_associated_column2 => 'PER_APPLICATIONS.PROJECTED_HIRE_DATE'
552: );
553: end if;
554: --
555: hr_utility.set_location(l_proc,81);

Line 569: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'

565: if (csr_valid_person_per_apl%found) then
566: close csr_valid_person_per_apl;
567: hr_utility.set_message(801,'HR_51190_APL_DTE_REC_PERSON');
568: hr_multi_message.add
569: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
570: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'
571: );
572: else
573: close csr_valid_person_per_apl;

Line 570: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'

566: close csr_valid_person_per_apl;
567: hr_utility.set_message(801,'HR_51190_APL_DTE_REC_PERSON');
568: hr_multi_message.add
569: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
570: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'
571: );
572: else
573: close csr_valid_person_per_apl;
574: end if;

Line 588: (p_date_received in per_applications.date_received%TYPE

584: -- ---------------------------------------------------------------------------
585: -- |----------------< chk_projected_hire_date >------------------------------|
586: -- ---------------------------------------------------------------------------
587: Procedure chk_projected_hire_date
588: (p_date_received in per_applications.date_received%TYPE
589: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
590: ,p_application_id in per_applications.application_id%TYPE
591: ,p_object_version_number in per_applications.object_version_number%TYPE
592: ) is

Line 589: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE

585: -- |----------------< chk_projected_hire_date >------------------------------|
586: -- ---------------------------------------------------------------------------
587: Procedure chk_projected_hire_date
588: (p_date_received in per_applications.date_received%TYPE
589: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
590: ,p_application_id in per_applications.application_id%TYPE
591: ,p_object_version_number in per_applications.object_version_number%TYPE
592: ) is
593: --

Line 590: ,p_application_id in per_applications.application_id%TYPE

586: -- ---------------------------------------------------------------------------
587: Procedure chk_projected_hire_date
588: (p_date_received in per_applications.date_received%TYPE
589: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
590: ,p_application_id in per_applications.application_id%TYPE
591: ,p_object_version_number in per_applications.object_version_number%TYPE
592: ) is
593: --
594: l_proc varchar2(72) := g_package||'chk_proj_hire_date';

Line 591: ,p_object_version_number in per_applications.object_version_number%TYPE

587: Procedure chk_projected_hire_date
588: (p_date_received in per_applications.date_received%TYPE
589: ,p_projected_hire_date in per_applications.projected_hire_date%TYPE
590: ,p_application_id in per_applications.application_id%TYPE
591: ,p_object_version_number in per_applications.object_version_number%TYPE
592: ) is
593: --
594: l_proc varchar2(72) := g_package||'chk_proj_hire_date';
595: l_api_updating boolean;

Line 603: (p_check_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'

599: --
600: -- Check if projected hire date is not null, only validate if it is not null
601: --
602: if hr_multi_message.no_all_inclusive_error
603: (p_check_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
604: ) then
605: if (p_projected_hire_date is not null) then
606: --
607: -- Check if application is being updated and load g_old_rec if applicable

Line 628: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'

624: --
625: if (p_date_received > p_projected_hire_date) then
626: hr_utility.set_message(801,'HR_51192_APL_PROJ_HIRE_DTE_REC');
627: hr_multi_message.add
628: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
629: ,p_associated_column2 => 'PER_APPLICATIONS.PROJECTED_HIRE_DATE'
630: );
631: end if;
632: end if;

Line 629: ,p_associated_column2 => 'PER_APPLICATIONS.PROJECTED_HIRE_DATE'

625: if (p_date_received > p_projected_hire_date) then
626: hr_utility.set_message(801,'HR_51192_APL_PROJ_HIRE_DTE_REC');
627: hr_multi_message.add
628: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
629: ,p_associated_column2 => 'PER_APPLICATIONS.PROJECTED_HIRE_DATE'
630: );
631: end if;
632: end if;
633: hr_utility.set_location('Inside:'||l_proc,21);

Line 646: (p_date_end in per_applications.date_end%TYPE

642: -- ----------------------------------------------------------------------------
643: -- |---------------------------< chk_date_end >-------------------------------|
644: -- ----------------------------------------------------------------------------
645: Procedure chk_date_end
646: (p_date_end in per_applications.date_end%TYPE
647: ,p_date_received in per_applications.date_received%TYPE
648: ,p_application_id in per_applications.application_id%TYPE
649: ,p_object_version_number in per_applications.object_version_number%TYPE
650: ) is

Line 647: ,p_date_received in per_applications.date_received%TYPE

643: -- |---------------------------< chk_date_end >-------------------------------|
644: -- ----------------------------------------------------------------------------
645: Procedure chk_date_end
646: (p_date_end in per_applications.date_end%TYPE
647: ,p_date_received in per_applications.date_received%TYPE
648: ,p_application_id in per_applications.application_id%TYPE
649: ,p_object_version_number in per_applications.object_version_number%TYPE
650: ) is
651: --

Line 648: ,p_application_id in per_applications.application_id%TYPE

644: -- ----------------------------------------------------------------------------
645: Procedure chk_date_end
646: (p_date_end in per_applications.date_end%TYPE
647: ,p_date_received in per_applications.date_received%TYPE
648: ,p_application_id in per_applications.application_id%TYPE
649: ,p_object_version_number in per_applications.object_version_number%TYPE
650: ) is
651: --
652: l_proc varchar2(72) := g_package||'chk_date_end';

Line 649: ,p_object_version_number in per_applications.object_version_number%TYPE

645: Procedure chk_date_end
646: (p_date_end in per_applications.date_end%TYPE
647: ,p_date_received in per_applications.date_received%TYPE
648: ,p_application_id in per_applications.application_id%TYPE
649: ,p_object_version_number in per_applications.object_version_number%TYPE
650: ) is
651: --
652: l_proc varchar2(72) := g_package||'chk_date_end';
653: l_api_updating boolean;

Line 668: per_applications pa

664: --
665: cursor csr_chk_apl_future_changes is
666: select ppf.person_id
667: from per_people_f ppf,
668: per_applications pa
669: where pa.application_id = p_application_id
670: and pa.person_id = ppf.person_id
671: and ppf.effective_start_date > p_date_end;
672: --

Line 699: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'

695: --
696: hr_utility.set_message(801,'HR_7441_API_ARG_NOT_SET');
697: hr_utility.set_message_token('ARG_NAME','DATE_END');
698: hr_multi_message.add
699: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
700: );
701: --
702: elsif (l_api_updating and
703: nvl(per_apl_shd.g_old_rec.date_end,hr_api.g_date) <>

Line 717: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'

713: per_apl_shd.g_old_rec.date_end <> p_date_end) then
714: hr_utility.set_location('Inside:'||l_proc,35);
715: hr_utility.set_message(801,'HR_51234_APL_INVALID_UPDATE');
716: hr_multi_message.add
717: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
718: );
719: end if;
720: hr_utility.set_location(l_proc,41);
721: --

Line 727: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'

723: --
724: if (p_date_end < p_date_received) then
725: hr_utility.set_message(801,'HR_51235_APL_DTE_END_DTE_REC');
726: hr_multi_message.add
727: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
728: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'
729: );
730: end if;
731: hr_utility.set_location(l_proc,51);

Line 728: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'

724: if (p_date_end < p_date_received) then
725: hr_utility.set_message(801,'HR_51235_APL_DTE_END_DTE_REC');
726: hr_multi_message.add
727: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
728: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'
729: );
730: end if;
731: hr_utility.set_location(l_proc,51);
732: --

Line 744: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'

740: close csr_chk_asg_future_changes;
741: --
742: hr_utility.set_message(801,'HR_51236_APL_ASG_FUTURE_CHGS');
743: hr_multi_message.add
744: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
745: );
746: else
747: --
748: close csr_chk_asg_future_changes;

Line 765: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'

761: close csr_chk_apl_future_changes;
762: --
763: hr_utility.set_message(801,'HR_51237_APL_PER_FUTURE_CHGS');
764: hr_multi_message.add
765: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
766: );
767: else
768: --
769: close csr_chk_apl_future_changes;

Line 785: (p_successful_flag in per_applications.successful_flag%TYPE

781: -- ----------------------------------------------------------------------------
782: -- |------------------------< chk_successful_flag >---------------------------|
783: -- ----------------------------------------------------------------------------
784: Procedure chk_successful_flag
785: (p_successful_flag in per_applications.successful_flag%TYPE
786: ,p_application_id in per_applications.application_id%TYPE
787: ,p_object_version_number in per_applications.object_version_number%TYPE
788: ) is
789: --

Line 786: ,p_application_id in per_applications.application_id%TYPE

782: -- |------------------------< chk_successful_flag >---------------------------|
783: -- ----------------------------------------------------------------------------
784: Procedure chk_successful_flag
785: (p_successful_flag in per_applications.successful_flag%TYPE
786: ,p_application_id in per_applications.application_id%TYPE
787: ,p_object_version_number in per_applications.object_version_number%TYPE
788: ) is
789: --
790: l_proc varchar2(72) := g_package||'chk_successful_flag';

Line 787: ,p_object_version_number in per_applications.object_version_number%TYPE

783: -- ----------------------------------------------------------------------------
784: Procedure chk_successful_flag
785: (p_successful_flag in per_applications.successful_flag%TYPE
786: ,p_application_id in per_applications.application_id%TYPE
787: ,p_object_version_number in per_applications.object_version_number%TYPE
788: ) is
789: --
790: l_proc varchar2(72) := g_package||'chk_successful_flag';
791: l_api_updating boolean;

Line 830: (p_associated_column1 => 'PER_APPLICATIONS.SUCCESSFUL_FLAG'

826: --
827: exception
828: when app_exception.application_exception then
829: if hr_multi_message.exception_add
830: (p_associated_column1 => 'PER_APPLICATIONS.SUCCESSFUL_FLAG'
831: ) then
832: hr_utility.set_location(' Leaving:' || l_proc,40);
833: raise;
834: end if;

Line 842: (p_termination_reason in per_applications.termination_reason%TYPE

838: -- ----------------------------------------------------------------------------
839: -- |-----------------------< chk_termination_reason >-------------------------|
840: -- ----------------------------------------------------------------------------
841: Procedure chk_termination_reason
842: (p_termination_reason in per_applications.termination_reason%TYPE
843: ,p_application_id in per_applications.application_id%TYPE
844: ,p_effective_date in date
845: ,p_object_version_number in per_applications.object_version_number%TYPE
846: ) is

Line 843: ,p_application_id in per_applications.application_id%TYPE

839: -- |-----------------------< chk_termination_reason >-------------------------|
840: -- ----------------------------------------------------------------------------
841: Procedure chk_termination_reason
842: (p_termination_reason in per_applications.termination_reason%TYPE
843: ,p_application_id in per_applications.application_id%TYPE
844: ,p_effective_date in date
845: ,p_object_version_number in per_applications.object_version_number%TYPE
846: ) is
847: --

Line 845: ,p_object_version_number in per_applications.object_version_number%TYPE

841: Procedure chk_termination_reason
842: (p_termination_reason in per_applications.termination_reason%TYPE
843: ,p_application_id in per_applications.application_id%TYPE
844: ,p_effective_date in date
845: ,p_object_version_number in per_applications.object_version_number%TYPE
846: ) is
847: --
848: l_proc varchar2(72) := g_package||'chk_termination_reason';
849: l_api_updating boolean;

Line 903: (p_associated_column1 => 'PER_APPLICATIONS.TERMINATION_REASON'

899: hr_utility.set_location(' Leaving:'|| l_proc, 31);
900: exception
901: when app_exception.application_exception then
902: if hr_multi_message.exception_add
903: (p_associated_column1 => 'PER_APPLICATIONS.TERMINATION_REASON'
904: ) then
905: hr_utility.set_location(' Leaving:'||l_proc,40);
906: raise;
907: end if;

Line 924: , per_applications apl

920: --
921: cursor csr_leg_code is
922: select pbg.legislation_code
923: from per_business_groups pbg
924: , per_applications apl
925: where apl.application_id = p_application_id
926: and pbg.business_group_id = apl.business_group_id;
927: --
928: -- Declare local variables