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_ASP_BUS dependencies on PER_SEC_PROFILE_ASSIGNMENTS

Line 56: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_PK');

52: <> per_asp_shd.g_old_rec.sec_profile_assignment_id) then
53: --
54: -- raise error as PK has changed
55: --
56: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_PK');

62: if p_sec_profile_assignment_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_PK');
67: --
68: end if;
69: --
70: end if;

Line 139: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_FK');

135: --
136: -- raise error as FK does not relate to PK in per_security_profiles
137: -- table.
138: --
139: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_FK');
140: --
141: end if;
142: --
143: close c1;

Line 215: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_FK');

211: --
212: -- raise error as FK does not relate to PK in per_business_groups
213: -- view
214: --
215: per_asp_shd.constraint_error('PER_SEC_PROFILE_ASSIGNMENTS_FK');
216: --
217: end if;
218: --
219: close c1;

Line 388: IN per_sec_profile_assignments.user_id%TYPE

384: -- ----------------------------------------------------------------------------
385: --
386: PROCEDURE chk_assignment_dates
387: (p_user_id
388: IN per_sec_profile_assignments.user_id%TYPE
389: ,p_responsibility_id
390: IN per_sec_profile_assignments.responsibility_id%TYPE
391: ,p_application_id
392: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 390: IN per_sec_profile_assignments.responsibility_id%TYPE

386: PROCEDURE chk_assignment_dates
387: (p_user_id
388: IN per_sec_profile_assignments.user_id%TYPE
389: ,p_responsibility_id
390: IN per_sec_profile_assignments.responsibility_id%TYPE
391: ,p_application_id
392: IN per_sec_profile_assignments.responsibility_application_id%TYPE
393: ,p_security_group_id
394: IN per_sec_profile_assignments.security_group_id%TYPE

Line 392: IN per_sec_profile_assignments.responsibility_application_id%TYPE

388: IN per_sec_profile_assignments.user_id%TYPE
389: ,p_responsibility_id
390: IN per_sec_profile_assignments.responsibility_id%TYPE
391: ,p_application_id
392: IN per_sec_profile_assignments.responsibility_application_id%TYPE
393: ,p_security_group_id
394: IN per_sec_profile_assignments.security_group_id%TYPE
395: ,p_start_date
396: IN per_sec_profile_assignments.start_date%TYPE

Line 394: IN per_sec_profile_assignments.security_group_id%TYPE

390: IN per_sec_profile_assignments.responsibility_id%TYPE
391: ,p_application_id
392: IN per_sec_profile_assignments.responsibility_application_id%TYPE
393: ,p_security_group_id
394: IN per_sec_profile_assignments.security_group_id%TYPE
395: ,p_start_date
396: IN per_sec_profile_assignments.start_date%TYPE
397: ,p_end_date
398: IN per_sec_profile_assignments.end_date%TYPE

Line 396: IN per_sec_profile_assignments.start_date%TYPE

392: IN per_sec_profile_assignments.responsibility_application_id%TYPE
393: ,p_security_group_id
394: IN per_sec_profile_assignments.security_group_id%TYPE
395: ,p_start_date
396: IN per_sec_profile_assignments.start_date%TYPE
397: ,p_end_date
398: IN per_sec_profile_assignments.end_date%TYPE
399: )
400: IS

Line 398: IN per_sec_profile_assignments.end_date%TYPE

394: IN per_sec_profile_assignments.security_group_id%TYPE
395: ,p_start_date
396: IN per_sec_profile_assignments.start_date%TYPE
397: ,p_end_date
398: IN per_sec_profile_assignments.end_date%TYPE
399: )
400: IS
401: --
402: CURSOR c_get_assignment_dates

Line 472: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE

468: -- ----------------------------------------------------------------------------
469: --
470: PROCEDURE chk_invalid_dates
471: (p_sec_profile_assignment_id
472: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
473: DEFAULT NULL
474: ,p_user_id
475: IN per_sec_profile_assignments.user_id%TYPE
476: ,p_responsibility_id

Line 475: IN per_sec_profile_assignments.user_id%TYPE

471: (p_sec_profile_assignment_id
472: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
473: DEFAULT NULL
474: ,p_user_id
475: IN per_sec_profile_assignments.user_id%TYPE
476: ,p_responsibility_id
477: IN per_sec_profile_assignments.responsibility_id%TYPE
478: ,p_application_id
479: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 477: IN per_sec_profile_assignments.responsibility_id%TYPE

473: DEFAULT NULL
474: ,p_user_id
475: IN per_sec_profile_assignments.user_id%TYPE
476: ,p_responsibility_id
477: IN per_sec_profile_assignments.responsibility_id%TYPE
478: ,p_application_id
479: IN per_sec_profile_assignments.responsibility_application_id%TYPE
480: ,p_security_group_id
481: IN per_sec_profile_assignments.security_group_id%TYPE

Line 479: IN per_sec_profile_assignments.responsibility_application_id%TYPE

475: IN per_sec_profile_assignments.user_id%TYPE
476: ,p_responsibility_id
477: IN per_sec_profile_assignments.responsibility_id%TYPE
478: ,p_application_id
479: IN per_sec_profile_assignments.responsibility_application_id%TYPE
480: ,p_security_group_id
481: IN per_sec_profile_assignments.security_group_id%TYPE
482: ,p_business_group_id
483: IN per_sec_profile_assignments.business_group_id%TYPE

Line 481: IN per_sec_profile_assignments.security_group_id%TYPE

477: IN per_sec_profile_assignments.responsibility_id%TYPE
478: ,p_application_id
479: IN per_sec_profile_assignments.responsibility_application_id%TYPE
480: ,p_security_group_id
481: IN per_sec_profile_assignments.security_group_id%TYPE
482: ,p_business_group_id
483: IN per_sec_profile_assignments.business_group_id%TYPE
484: ,p_security_profile_id
485: IN per_sec_profile_assignments.security_profile_id%TYPE

Line 483: IN per_sec_profile_assignments.business_group_id%TYPE

479: IN per_sec_profile_assignments.responsibility_application_id%TYPE
480: ,p_security_group_id
481: IN per_sec_profile_assignments.security_group_id%TYPE
482: ,p_business_group_id
483: IN per_sec_profile_assignments.business_group_id%TYPE
484: ,p_security_profile_id
485: IN per_sec_profile_assignments.security_profile_id%TYPE
486: ,p_start_date
487: IN per_sec_profile_assignments.start_date%TYPE

Line 485: IN per_sec_profile_assignments.security_profile_id%TYPE

481: IN per_sec_profile_assignments.security_group_id%TYPE
482: ,p_business_group_id
483: IN per_sec_profile_assignments.business_group_id%TYPE
484: ,p_security_profile_id
485: IN per_sec_profile_assignments.security_profile_id%TYPE
486: ,p_start_date
487: IN per_sec_profile_assignments.start_date%TYPE
488: ,p_end_date
489: IN per_sec_profile_assignments.end_date%TYPE

Line 487: IN per_sec_profile_assignments.start_date%TYPE

483: IN per_sec_profile_assignments.business_group_id%TYPE
484: ,p_security_profile_id
485: IN per_sec_profile_assignments.security_profile_id%TYPE
486: ,p_start_date
487: IN per_sec_profile_assignments.start_date%TYPE
488: ,p_end_date
489: IN per_sec_profile_assignments.end_date%TYPE
490: )
491: IS

Line 489: IN per_sec_profile_assignments.end_date%TYPE

485: IN per_sec_profile_assignments.security_profile_id%TYPE
486: ,p_start_date
487: IN per_sec_profile_assignments.start_date%TYPE
488: ,p_end_date
489: IN per_sec_profile_assignments.end_date%TYPE
490: )
491: IS
492: --
493: CURSOR c_chk_invalid_dates

Line 496: FROM per_sec_profile_assignments s

492: --
493: CURSOR c_chk_invalid_dates
494: IS
495: SELECT 'Y'
496: FROM per_sec_profile_assignments s
497: WHERE s.user_id = p_user_id
498: AND s.responsibility_id = p_responsibility_id
499: AND s.responsibility_application_id = p_application_id
500: AND s.security_group_id = p_security_group_id

Line 539: IN per_sec_profile_assignments.user_id%TYPE

535: -- ----------------------------------------------------------------------------
536: --
537: PROCEDURE chk_duplicate_assignments
538: (p_user_id
539: IN per_sec_profile_assignments.user_id%TYPE
540: ,p_responsibility_id
541: IN per_sec_profile_assignments.responsibility_id%TYPE
542: ,p_application_id
543: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 541: IN per_sec_profile_assignments.responsibility_id%TYPE

537: PROCEDURE chk_duplicate_assignments
538: (p_user_id
539: IN per_sec_profile_assignments.user_id%TYPE
540: ,p_responsibility_id
541: IN per_sec_profile_assignments.responsibility_id%TYPE
542: ,p_application_id
543: IN per_sec_profile_assignments.responsibility_application_id%TYPE
544: ,p_security_group_id
545: IN per_sec_profile_assignments.security_group_id%TYPE

Line 543: IN per_sec_profile_assignments.responsibility_application_id%TYPE

539: IN per_sec_profile_assignments.user_id%TYPE
540: ,p_responsibility_id
541: IN per_sec_profile_assignments.responsibility_id%TYPE
542: ,p_application_id
543: IN per_sec_profile_assignments.responsibility_application_id%TYPE
544: ,p_security_group_id
545: IN per_sec_profile_assignments.security_group_id%TYPE
546: ,p_business_group_id
547: IN per_sec_profile_assignments.business_group_id%TYPE

Line 545: IN per_sec_profile_assignments.security_group_id%TYPE

541: IN per_sec_profile_assignments.responsibility_id%TYPE
542: ,p_application_id
543: IN per_sec_profile_assignments.responsibility_application_id%TYPE
544: ,p_security_group_id
545: IN per_sec_profile_assignments.security_group_id%TYPE
546: ,p_business_group_id
547: IN per_sec_profile_assignments.business_group_id%TYPE
548: ,p_security_profile_id
549: IN per_sec_profile_assignments.security_profile_id%TYPE

Line 547: IN per_sec_profile_assignments.business_group_id%TYPE

543: IN per_sec_profile_assignments.responsibility_application_id%TYPE
544: ,p_security_group_id
545: IN per_sec_profile_assignments.security_group_id%TYPE
546: ,p_business_group_id
547: IN per_sec_profile_assignments.business_group_id%TYPE
548: ,p_security_profile_id
549: IN per_sec_profile_assignments.security_profile_id%TYPE
550: ,p_start_date
551: IN per_sec_profile_assignments.start_date%TYPE

Line 549: IN per_sec_profile_assignments.security_profile_id%TYPE

545: IN per_sec_profile_assignments.security_group_id%TYPE
546: ,p_business_group_id
547: IN per_sec_profile_assignments.business_group_id%TYPE
548: ,p_security_profile_id
549: IN per_sec_profile_assignments.security_profile_id%TYPE
550: ,p_start_date
551: IN per_sec_profile_assignments.start_date%TYPE
552: ,p_end_date
553: IN per_sec_profile_assignments.end_date%TYPE

Line 551: IN per_sec_profile_assignments.start_date%TYPE

547: IN per_sec_profile_assignments.business_group_id%TYPE
548: ,p_security_profile_id
549: IN per_sec_profile_assignments.security_profile_id%TYPE
550: ,p_start_date
551: IN per_sec_profile_assignments.start_date%TYPE
552: ,p_end_date
553: IN per_sec_profile_assignments.end_date%TYPE
554: )
555: IS

Line 553: IN per_sec_profile_assignments.end_date%TYPE

549: IN per_sec_profile_assignments.security_profile_id%TYPE
550: ,p_start_date
551: IN per_sec_profile_assignments.start_date%TYPE
552: ,p_end_date
553: IN per_sec_profile_assignments.end_date%TYPE
554: )
555: IS
556: --
557: CURSOR c_exists_duplicate_assignment

Line 560: FROM per_sec_profile_assignments

556: --
557: CURSOR c_exists_duplicate_assignment
558: IS
559: SELECT 'Y'
560: FROM per_sec_profile_assignments
561: WHERE user_id = p_user_id
562: AND responsibility_id = p_responsibility_id
563: AND responsibility_application_id = p_application_id
564: AND security_group_id = p_security_group_id

Line 608: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE

604: -- ----------------------------------------------------------------------------
605: --
606: PROCEDURE chk_overlapping_dates
607: (p_sec_profile_assignment_id
608: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
609: DEFAULT NULL
610: ,p_user_id
611: IN per_sec_profile_assignments.user_id%TYPE
612: ,p_responsibility_id

Line 611: IN per_sec_profile_assignments.user_id%TYPE

607: (p_sec_profile_assignment_id
608: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
609: DEFAULT NULL
610: ,p_user_id
611: IN per_sec_profile_assignments.user_id%TYPE
612: ,p_responsibility_id
613: IN per_sec_profile_assignments.responsibility_id%TYPE
614: ,p_application_id
615: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 613: IN per_sec_profile_assignments.responsibility_id%TYPE

609: DEFAULT NULL
610: ,p_user_id
611: IN per_sec_profile_assignments.user_id%TYPE
612: ,p_responsibility_id
613: IN per_sec_profile_assignments.responsibility_id%TYPE
614: ,p_application_id
615: IN per_sec_profile_assignments.responsibility_application_id%TYPE
616: ,p_security_group_id
617: IN per_sec_profile_assignments.security_group_id%TYPE

Line 615: IN per_sec_profile_assignments.responsibility_application_id%TYPE

611: IN per_sec_profile_assignments.user_id%TYPE
612: ,p_responsibility_id
613: IN per_sec_profile_assignments.responsibility_id%TYPE
614: ,p_application_id
615: IN per_sec_profile_assignments.responsibility_application_id%TYPE
616: ,p_security_group_id
617: IN per_sec_profile_assignments.security_group_id%TYPE
618: ,p_business_group_id
619: IN per_sec_profile_assignments.business_group_id%TYPE

Line 617: IN per_sec_profile_assignments.security_group_id%TYPE

613: IN per_sec_profile_assignments.responsibility_id%TYPE
614: ,p_application_id
615: IN per_sec_profile_assignments.responsibility_application_id%TYPE
616: ,p_security_group_id
617: IN per_sec_profile_assignments.security_group_id%TYPE
618: ,p_business_group_id
619: IN per_sec_profile_assignments.business_group_id%TYPE
620: ,p_security_profile_id
621: IN per_sec_profile_assignments.security_profile_id%TYPE

Line 619: IN per_sec_profile_assignments.business_group_id%TYPE

615: IN per_sec_profile_assignments.responsibility_application_id%TYPE
616: ,p_security_group_id
617: IN per_sec_profile_assignments.security_group_id%TYPE
618: ,p_business_group_id
619: IN per_sec_profile_assignments.business_group_id%TYPE
620: ,p_security_profile_id
621: IN per_sec_profile_assignments.security_profile_id%TYPE
622: ,p_start_date
623: IN per_sec_profile_assignments.start_date%TYPE

Line 621: IN per_sec_profile_assignments.security_profile_id%TYPE

617: IN per_sec_profile_assignments.security_group_id%TYPE
618: ,p_business_group_id
619: IN per_sec_profile_assignments.business_group_id%TYPE
620: ,p_security_profile_id
621: IN per_sec_profile_assignments.security_profile_id%TYPE
622: ,p_start_date
623: IN per_sec_profile_assignments.start_date%TYPE
624: ,p_end_date
625: IN per_sec_profile_assignments.end_date%TYPE

Line 623: IN per_sec_profile_assignments.start_date%TYPE

619: IN per_sec_profile_assignments.business_group_id%TYPE
620: ,p_security_profile_id
621: IN per_sec_profile_assignments.security_profile_id%TYPE
622: ,p_start_date
623: IN per_sec_profile_assignments.start_date%TYPE
624: ,p_end_date
625: IN per_sec_profile_assignments.end_date%TYPE
626: )
627: IS

Line 625: IN per_sec_profile_assignments.end_date%TYPE

621: IN per_sec_profile_assignments.security_profile_id%TYPE
622: ,p_start_date
623: IN per_sec_profile_assignments.start_date%TYPE
624: ,p_end_date
625: IN per_sec_profile_assignments.end_date%TYPE
626: )
627: IS
628: --
629: l_id per_sec_profile_assignments.sec_profile_assignment_id%TYPE DEFAULT NULL;

Line 629: l_id per_sec_profile_assignments.sec_profile_assignment_id%TYPE DEFAULT NULL;

625: IN per_sec_profile_assignments.end_date%TYPE
626: )
627: IS
628: --
629: l_id per_sec_profile_assignments.sec_profile_assignment_id%TYPE DEFAULT NULL;
630: l_ovn per_sec_profile_assignments.object_version_number%TYPE DEFAULT NULL;
631: l_start_date per_sec_profile_assignments.start_date%TYPE DEFAULT NULL;
632: l_end_date per_sec_profile_assignments.end_date%TYPE DEFAULT NULL;
633: --

Line 630: l_ovn per_sec_profile_assignments.object_version_number%TYPE DEFAULT NULL;

626: )
627: IS
628: --
629: l_id per_sec_profile_assignments.sec_profile_assignment_id%TYPE DEFAULT NULL;
630: l_ovn per_sec_profile_assignments.object_version_number%TYPE DEFAULT NULL;
631: l_start_date per_sec_profile_assignments.start_date%TYPE DEFAULT NULL;
632: l_end_date per_sec_profile_assignments.end_date%TYPE DEFAULT NULL;
633: --
634: BEGIN

Line 631: l_start_date per_sec_profile_assignments.start_date%TYPE DEFAULT NULL;

627: IS
628: --
629: l_id per_sec_profile_assignments.sec_profile_assignment_id%TYPE DEFAULT NULL;
630: l_ovn per_sec_profile_assignments.object_version_number%TYPE DEFAULT NULL;
631: l_start_date per_sec_profile_assignments.start_date%TYPE DEFAULT NULL;
632: l_end_date per_sec_profile_assignments.end_date%TYPE DEFAULT NULL;
633: --
634: BEGIN
635: --

Line 632: l_end_date per_sec_profile_assignments.end_date%TYPE DEFAULT NULL;

628: --
629: l_id per_sec_profile_assignments.sec_profile_assignment_id%TYPE DEFAULT NULL;
630: l_ovn per_sec_profile_assignments.object_version_number%TYPE DEFAULT NULL;
631: l_start_date per_sec_profile_assignments.start_date%TYPE DEFAULT NULL;
632: l_end_date per_sec_profile_assignments.end_date%TYPE DEFAULT NULL;
633: --
634: BEGIN
635: --
636: -- call the other chk_overlapping_dates procedure and raise the relavent exception

Line 688: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE

684: -- ----------------------------------------------------------------------------
685: --
686: PROCEDURE chk_overlapping_dates
687: (p_sec_profile_assignment_id
688: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
689: DEFAULT NULL
690: ,p_user_id
691: IN per_sec_profile_assignments.user_id%TYPE
692: ,p_responsibility_id

Line 691: IN per_sec_profile_assignments.user_id%TYPE

687: (p_sec_profile_assignment_id
688: IN per_sec_profile_assignments.sec_profile_assignment_id%TYPE
689: DEFAULT NULL
690: ,p_user_id
691: IN per_sec_profile_assignments.user_id%TYPE
692: ,p_responsibility_id
693: IN per_sec_profile_assignments.responsibility_id%TYPE
694: ,p_application_id
695: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 693: IN per_sec_profile_assignments.responsibility_id%TYPE

689: DEFAULT NULL
690: ,p_user_id
691: IN per_sec_profile_assignments.user_id%TYPE
692: ,p_responsibility_id
693: IN per_sec_profile_assignments.responsibility_id%TYPE
694: ,p_application_id
695: IN per_sec_profile_assignments.responsibility_application_id%TYPE
696: ,p_security_group_id
697: IN per_sec_profile_assignments.security_group_id%TYPE

Line 695: IN per_sec_profile_assignments.responsibility_application_id%TYPE

691: IN per_sec_profile_assignments.user_id%TYPE
692: ,p_responsibility_id
693: IN per_sec_profile_assignments.responsibility_id%TYPE
694: ,p_application_id
695: IN per_sec_profile_assignments.responsibility_application_id%TYPE
696: ,p_security_group_id
697: IN per_sec_profile_assignments.security_group_id%TYPE
698: ,p_business_group_id
699: IN per_sec_profile_assignments.business_group_id%TYPE

Line 697: IN per_sec_profile_assignments.security_group_id%TYPE

693: IN per_sec_profile_assignments.responsibility_id%TYPE
694: ,p_application_id
695: IN per_sec_profile_assignments.responsibility_application_id%TYPE
696: ,p_security_group_id
697: IN per_sec_profile_assignments.security_group_id%TYPE
698: ,p_business_group_id
699: IN per_sec_profile_assignments.business_group_id%TYPE
700: ,p_security_profile_id
701: IN per_sec_profile_assignments.security_profile_id%TYPE

Line 699: IN per_sec_profile_assignments.business_group_id%TYPE

695: IN per_sec_profile_assignments.responsibility_application_id%TYPE
696: ,p_security_group_id
697: IN per_sec_profile_assignments.security_group_id%TYPE
698: ,p_business_group_id
699: IN per_sec_profile_assignments.business_group_id%TYPE
700: ,p_security_profile_id
701: IN per_sec_profile_assignments.security_profile_id%TYPE
702: ,p_start_date
703: IN per_sec_profile_assignments.start_date%TYPE

Line 701: IN per_sec_profile_assignments.security_profile_id%TYPE

697: IN per_sec_profile_assignments.security_group_id%TYPE
698: ,p_business_group_id
699: IN per_sec_profile_assignments.business_group_id%TYPE
700: ,p_security_profile_id
701: IN per_sec_profile_assignments.security_profile_id%TYPE
702: ,p_start_date
703: IN per_sec_profile_assignments.start_date%TYPE
704: ,p_end_date
705: IN per_sec_profile_assignments.end_date%TYPE

Line 703: IN per_sec_profile_assignments.start_date%TYPE

699: IN per_sec_profile_assignments.business_group_id%TYPE
700: ,p_security_profile_id
701: IN per_sec_profile_assignments.security_profile_id%TYPE
702: ,p_start_date
703: IN per_sec_profile_assignments.start_date%TYPE
704: ,p_end_date
705: IN per_sec_profile_assignments.end_date%TYPE
706: ,p_clashing_id
707: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE

Line 705: IN per_sec_profile_assignments.end_date%TYPE

701: IN per_sec_profile_assignments.security_profile_id%TYPE
702: ,p_start_date
703: IN per_sec_profile_assignments.start_date%TYPE
704: ,p_end_date
705: IN per_sec_profile_assignments.end_date%TYPE
706: ,p_clashing_id
707: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE
708: ,p_clashing_ovn
709: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE

Line 707: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE

703: IN per_sec_profile_assignments.start_date%TYPE
704: ,p_end_date
705: IN per_sec_profile_assignments.end_date%TYPE
706: ,p_clashing_id
707: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE
708: ,p_clashing_ovn
709: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE
710: ,p_clashing_start_date
711: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE

Line 709: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE

705: IN per_sec_profile_assignments.end_date%TYPE
706: ,p_clashing_id
707: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE
708: ,p_clashing_ovn
709: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE
710: ,p_clashing_start_date
711: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE
712: ,p_clashing_end_date
713: OUT NOCOPY per_sec_profile_assignments.end_date%TYPE

Line 711: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE

707: OUT NOCOPY per_sec_profile_assignments.sec_profile_assignment_id%TYPE
708: ,p_clashing_ovn
709: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE
710: ,p_clashing_start_date
711: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE
712: ,p_clashing_end_date
713: OUT NOCOPY per_sec_profile_assignments.end_date%TYPE
714: )
715: IS

Line 713: OUT NOCOPY per_sec_profile_assignments.end_date%TYPE

709: OUT NOCOPY per_sec_profile_assignments.object_version_number%TYPE
710: ,p_clashing_start_date
711: OUT NOCOPY per_sec_profile_assignments.start_date%TYPE
712: ,p_clashing_end_date
713: OUT NOCOPY per_sec_profile_assignments.end_date%TYPE
714: )
715: IS
716: --
717: CURSOR c_chk_overlapping_dates

Line 723: FROM per_sec_profile_assignments s

719: SELECT s.sec_profile_assignment_id
720: ,s.object_version_number
721: ,s.start_date
722: ,s.end_date
723: FROM per_sec_profile_assignments s
724: WHERE s.user_id = p_user_id
725: AND s.responsibility_id = p_responsibility_id
726: AND s.responsibility_application_id = p_application_id
727: AND s.security_group_id = p_security_group_id

Line 761: IN per_sec_profile_assignments.user_id%TYPE

757: -- ----------------------------------------------------------------------------
758: --
759: PROCEDURE chk_assignment_exists
760: (p_user_id
761: IN per_sec_profile_assignments.user_id%TYPE
762: ,p_responsibility_id
763: IN per_sec_profile_assignments.responsibility_id%TYPE
764: ,p_application_id
765: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 763: IN per_sec_profile_assignments.responsibility_id%TYPE

759: PROCEDURE chk_assignment_exists
760: (p_user_id
761: IN per_sec_profile_assignments.user_id%TYPE
762: ,p_responsibility_id
763: IN per_sec_profile_assignments.responsibility_id%TYPE
764: ,p_application_id
765: IN per_sec_profile_assignments.responsibility_application_id%TYPE
766: ,p_security_group_id
767: IN per_sec_profile_assignments.security_group_id%TYPE

Line 765: IN per_sec_profile_assignments.responsibility_application_id%TYPE

761: IN per_sec_profile_assignments.user_id%TYPE
762: ,p_responsibility_id
763: IN per_sec_profile_assignments.responsibility_id%TYPE
764: ,p_application_id
765: IN per_sec_profile_assignments.responsibility_application_id%TYPE
766: ,p_security_group_id
767: IN per_sec_profile_assignments.security_group_id%TYPE
768: )
769: IS

Line 767: IN per_sec_profile_assignments.security_group_id%TYPE

763: IN per_sec_profile_assignments.responsibility_id%TYPE
764: ,p_application_id
765: IN per_sec_profile_assignments.responsibility_application_id%TYPE
766: ,p_security_group_id
767: IN per_sec_profile_assignments.security_group_id%TYPE
768: )
769: IS
770: --
771: BEGIN

Line 797: IN per_sec_profile_assignments.user_id%TYPE

793: -- ----------------------------------------------------------------------------
794: --
795: FUNCTION chk_assignment_exists
796: (p_user_id
797: IN per_sec_profile_assignments.user_id%TYPE
798: ,p_responsibility_id
799: IN per_sec_profile_assignments.responsibility_id%TYPE
800: ,p_application_id
801: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 799: IN per_sec_profile_assignments.responsibility_id%TYPE

795: FUNCTION chk_assignment_exists
796: (p_user_id
797: IN per_sec_profile_assignments.user_id%TYPE
798: ,p_responsibility_id
799: IN per_sec_profile_assignments.responsibility_id%TYPE
800: ,p_application_id
801: IN per_sec_profile_assignments.responsibility_application_id%TYPE
802: ,p_security_group_id
803: IN per_sec_profile_assignments.security_group_id%TYPE

Line 801: IN per_sec_profile_assignments.responsibility_application_id%TYPE

797: IN per_sec_profile_assignments.user_id%TYPE
798: ,p_responsibility_id
799: IN per_sec_profile_assignments.responsibility_id%TYPE
800: ,p_application_id
801: IN per_sec_profile_assignments.responsibility_application_id%TYPE
802: ,p_security_group_id
803: IN per_sec_profile_assignments.security_group_id%TYPE
804: ) RETURN BOOLEAN
805: IS

Line 803: IN per_sec_profile_assignments.security_group_id%TYPE

799: IN per_sec_profile_assignments.responsibility_id%TYPE
800: ,p_application_id
801: IN per_sec_profile_assignments.responsibility_application_id%TYPE
802: ,p_security_group_id
803: IN per_sec_profile_assignments.security_group_id%TYPE
804: ) RETURN BOOLEAN
805: IS
806: --
807: BEGIN

Line 1054: IN per_sec_profile_assignments.user_id%TYPE

1050: -- ----------------------------------------------------------------------------
1051: --
1052: PROCEDURE Synchronize_Assignment_Dates
1053: (p_user_id
1054: IN per_sec_profile_assignments.user_id%TYPE
1055: ,p_responsibility_id
1056: IN per_sec_profile_assignments.responsibility_id%TYPE
1057: ,p_application_id
1058: IN per_sec_profile_assignments.responsibility_application_id%TYPE

Line 1056: IN per_sec_profile_assignments.responsibility_id%TYPE

1052: PROCEDURE Synchronize_Assignment_Dates
1053: (p_user_id
1054: IN per_sec_profile_assignments.user_id%TYPE
1055: ,p_responsibility_id
1056: IN per_sec_profile_assignments.responsibility_id%TYPE
1057: ,p_application_id
1058: IN per_sec_profile_assignments.responsibility_application_id%TYPE
1059: ,p_security_group_id
1060: IN per_sec_profile_assignments.security_group_id%TYPE

Line 1058: IN per_sec_profile_assignments.responsibility_application_id%TYPE

1054: IN per_sec_profile_assignments.user_id%TYPE
1055: ,p_responsibility_id
1056: IN per_sec_profile_assignments.responsibility_id%TYPE
1057: ,p_application_id
1058: IN per_sec_profile_assignments.responsibility_application_id%TYPE
1059: ,p_security_group_id
1060: IN per_sec_profile_assignments.security_group_id%TYPE
1061: ,p_business_group_id
1062: IN per_sec_profile_assignments.business_group_id%TYPE

Line 1060: IN per_sec_profile_assignments.security_group_id%TYPE

1056: IN per_sec_profile_assignments.responsibility_id%TYPE
1057: ,p_application_id
1058: IN per_sec_profile_assignments.responsibility_application_id%TYPE
1059: ,p_security_group_id
1060: IN per_sec_profile_assignments.security_group_id%TYPE
1061: ,p_business_group_id
1062: IN per_sec_profile_assignments.business_group_id%TYPE
1063: )
1064: IS

Line 1062: IN per_sec_profile_assignments.business_group_id%TYPE

1058: IN per_sec_profile_assignments.responsibility_application_id%TYPE
1059: ,p_security_group_id
1060: IN per_sec_profile_assignments.security_group_id%TYPE
1061: ,p_business_group_id
1062: IN per_sec_profile_assignments.business_group_id%TYPE
1063: )
1064: IS
1065: --
1066: CURSOR c_get_minmax_dates

Line 1069: FROM per_sec_profile_assignments s

1065: --
1066: CURSOR c_get_minmax_dates
1067: IS
1068: SELECT MIN(s.start_date), MAX(s.end_date)
1069: FROM per_sec_profile_assignments s
1070: WHERE s.user_id = p_user_id
1071: AND s.responsibility_id = p_responsibility_id
1072: AND s.responsibility_application_id = p_application_id
1073: AND s.security_group_id = p_security_group_id

Line 1079: FROM per_sec_profile_assignments s

1075: --
1076: CURSOR c_chk_null_end_date
1077: IS
1078: SELECT 'Y'
1079: FROM per_sec_profile_assignments s
1080: WHERE s.user_id = p_user_id
1081: AND s.responsibility_id = p_responsibility_id
1082: AND s.responsibility_application_id = p_application_id
1083: AND s.security_group_id = p_security_group_id