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 670: per_applications pa

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

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

701: --
702: hr_utility.set_message(801,'HR_7441_API_ARG_NOT_SET');
703: hr_utility.set_message_token('ARG_NAME','DATE_END');
704: hr_multi_message.add
705: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
706: );
707: --
708: elsif (l_api_updating and
709: nvl(per_apl_shd.g_old_rec.date_end,hr_api.g_date) <>

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

719: per_apl_shd.g_old_rec.date_end <> p_date_end) then
720: hr_utility.set_location('Inside:'||l_proc,35);
721: hr_utility.set_message(801,'HR_51234_APL_INVALID_UPDATE');
722: hr_multi_message.add
723: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
724: );
725: end if;
726: hr_utility.set_location(l_proc,41);
727: --

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

729: --
730: if (p_date_end < p_date_received) then
731: hr_utility.set_message(801,'HR_51235_APL_DTE_END_DTE_REC');
732: hr_multi_message.add
733: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
734: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'
735: );
736: end if;
737: hr_utility.set_location(l_proc,51);

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

730: if (p_date_end < p_date_received) then
731: hr_utility.set_message(801,'HR_51235_APL_DTE_END_DTE_REC');
732: hr_multi_message.add
733: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
734: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'
735: );
736: end if;
737: hr_utility.set_location(l_proc,51);
738: --

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

747: close csr_chk_asg_future_changes;
748: --
749: hr_utility.set_message(801,'HR_51236_APL_ASG_FUTURE_CHGS');
750: hr_multi_message.add
751: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
752: );
753: else
754: --
755: close csr_chk_asg_future_changes;

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

768: close csr_chk_apl_future_changes;
769: --
770: hr_utility.set_message(801,'HR_51237_APL_PER_FUTURE_CHGS');
771: hr_multi_message.add
772: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
773: );
774: else
775: --
776: close csr_chk_apl_future_changes;

Line 792: (p_successful_flag in per_applications.successful_flag%TYPE

788: -- ----------------------------------------------------------------------------
789: -- |------------------------< chk_successful_flag >---------------------------|
790: -- ----------------------------------------------------------------------------
791: Procedure chk_successful_flag
792: (p_successful_flag in per_applications.successful_flag%TYPE
793: ,p_application_id in per_applications.application_id%TYPE
794: ,p_object_version_number in per_applications.object_version_number%TYPE
795: ) is
796: --

Line 793: ,p_application_id in per_applications.application_id%TYPE

789: -- |------------------------< chk_successful_flag >---------------------------|
790: -- ----------------------------------------------------------------------------
791: Procedure chk_successful_flag
792: (p_successful_flag in per_applications.successful_flag%TYPE
793: ,p_application_id in per_applications.application_id%TYPE
794: ,p_object_version_number in per_applications.object_version_number%TYPE
795: ) is
796: --
797: l_proc varchar2(72) := g_package||'chk_successful_flag';

Line 794: ,p_object_version_number in per_applications.object_version_number%TYPE

790: -- ----------------------------------------------------------------------------
791: Procedure chk_successful_flag
792: (p_successful_flag in per_applications.successful_flag%TYPE
793: ,p_application_id in per_applications.application_id%TYPE
794: ,p_object_version_number in per_applications.object_version_number%TYPE
795: ) is
796: --
797: l_proc varchar2(72) := g_package||'chk_successful_flag';
798: l_api_updating boolean;

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

833: --
834: exception
835: when app_exception.application_exception then
836: if hr_multi_message.exception_add
837: (p_associated_column1 => 'PER_APPLICATIONS.SUCCESSFUL_FLAG'
838: ) then
839: hr_utility.set_location(' Leaving:' || l_proc,40);
840: raise;
841: end if;

Line 849: (p_termination_reason in per_applications.termination_reason%TYPE

845: -- ----------------------------------------------------------------------------
846: -- |-----------------------< chk_termination_reason >-------------------------|
847: -- ----------------------------------------------------------------------------
848: Procedure chk_termination_reason
849: (p_termination_reason in per_applications.termination_reason%TYPE
850: ,p_application_id in per_applications.application_id%TYPE
851: ,p_effective_date in date
852: ,p_object_version_number in per_applications.object_version_number%TYPE
853: ) is

Line 850: ,p_application_id in per_applications.application_id%TYPE

846: -- |-----------------------< chk_termination_reason >-------------------------|
847: -- ----------------------------------------------------------------------------
848: Procedure chk_termination_reason
849: (p_termination_reason in per_applications.termination_reason%TYPE
850: ,p_application_id in per_applications.application_id%TYPE
851: ,p_effective_date in date
852: ,p_object_version_number in per_applications.object_version_number%TYPE
853: ) is
854: --

Line 852: ,p_object_version_number in per_applications.object_version_number%TYPE

848: Procedure chk_termination_reason
849: (p_termination_reason in per_applications.termination_reason%TYPE
850: ,p_application_id in per_applications.application_id%TYPE
851: ,p_effective_date in date
852: ,p_object_version_number in per_applications.object_version_number%TYPE
853: ) is
854: --
855: l_proc varchar2(72) := g_package||'chk_termination_reason';
856: l_api_updating boolean;

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

906: hr_utility.set_location(' Leaving:'|| l_proc, 31);
907: exception
908: when app_exception.application_exception then
909: if hr_multi_message.exception_add
910: (p_associated_column1 => 'PER_APPLICATIONS.TERMINATION_REASON'
911: ) then
912: hr_utility.set_location(' Leaving:'||l_proc,40);
913: raise;
914: end if;

Line 931: , per_applications apl

927: --
928: cursor csr_leg_code is
929: select pbg.legislation_code
930: from per_business_groups pbg
931: , per_applications apl
932: where apl.application_id = p_application_id
933: and pbg.business_group_id = apl.business_group_id;
934: --
935: -- Declare local variables