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.HXC_HAC_BUS dependencies on HXC_APPROVAL_COMPS

Line 28: -- hxc_approval_comps and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- hxc_approval_comps and PER_BUSINESS_GROUPS
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is

Line 35: , hxc_approval_comps hac

31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , hxc_approval_comps hac
36: -- , EDIT_HERE table_name(s) 333
37: where hac.approval_comp_id = p_approval_comp_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 100: -- hxc_approval_comps and PER_BUSINESS_GROUPS

96: --
97: -- Declare cursor
98: --
99: -- EDIT_HERE In the following cursor statement add join(s) between
100: -- hxc_approval_comps and PER_BUSINESS_GROUPS
101: -- so that the legislation_code for
102: -- the current business group context can be derived.
103: -- Remove this comment when the edit has been completed.
104: cursor csr_leg_code is

Line 107: , hxc_approval_comps hac

103: -- Remove this comment when the edit has been completed.
104: cursor csr_leg_code is
105: select pbg.legislation_code
106: from per_business_groups pbg
107: , hxc_approval_comps hac
108: -- , EDIT_HERE table_name(s) 333
109: where hac.approval_comp_id = p_approval_comp_id;
110: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
111: --

Line 278: IN hxc_approval_comps.approval_comp_id%TYPE

274: -- ----------------------------------------------------------------------------
275: --
276: PROCEDURE chk_approval_comp_dates
277: (p_approval_comp_id
278: IN hxc_approval_comps.approval_comp_id%TYPE
279: ,p_start_date
280: IN hxc_approval_comps.start_date%TYPE
281: ,p_end_date
282: IN hxc_approval_comps.end_date%TYPE

Line 280: IN hxc_approval_comps.start_date%TYPE

276: PROCEDURE chk_approval_comp_dates
277: (p_approval_comp_id
278: IN hxc_approval_comps.approval_comp_id%TYPE
279: ,p_start_date
280: IN hxc_approval_comps.start_date%TYPE
281: ,p_end_date
282: IN hxc_approval_comps.end_date%TYPE
283: )
284: IS

Line 282: IN hxc_approval_comps.end_date%TYPE

278: IN hxc_approval_comps.approval_comp_id%TYPE
279: ,p_start_date
280: IN hxc_approval_comps.start_date%TYPE
281: ,p_end_date
282: IN hxc_approval_comps.end_date%TYPE
283: )
284: IS
285: --
286: CURSOR c_get_approval_comp_dates

Line 290: FROM hxc_approval_comps

286: CURSOR c_get_approval_comp_dates
287: IS
288: SELECT start_date
289: ,end_date
290: FROM hxc_approval_comps
291: WHERE approval_comp_id = p_approval_comp_id;
292: --
293: BEGIN
294: --

Line 353: IN hxc_approval_comps.approval_style_id%TYPE

349: -- ----------------------------------------------------------------------------
350: --
351: PROCEDURE chk_invalid_dates_create
352: ( p_approval_style_id
353: IN hxc_approval_comps.approval_style_id%TYPE
354: ,p_time_recipient_id
355: IN hxc_approval_comps.time_recipient_id%TYPE
356: ,p_start_date
357: IN hxc_approval_comps.start_date%TYPE

Line 355: IN hxc_approval_comps.time_recipient_id%TYPE

351: PROCEDURE chk_invalid_dates_create
352: ( p_approval_style_id
353: IN hxc_approval_comps.approval_style_id%TYPE
354: ,p_time_recipient_id
355: IN hxc_approval_comps.time_recipient_id%TYPE
356: ,p_start_date
357: IN hxc_approval_comps.start_date%TYPE
358: ,p_end_date
359: IN hxc_approval_comps.end_date%TYPE

Line 357: IN hxc_approval_comps.start_date%TYPE

353: IN hxc_approval_comps.approval_style_id%TYPE
354: ,p_time_recipient_id
355: IN hxc_approval_comps.time_recipient_id%TYPE
356: ,p_start_date
357: IN hxc_approval_comps.start_date%TYPE
358: ,p_end_date
359: IN hxc_approval_comps.end_date%TYPE
360: )
361: IS

Line 359: IN hxc_approval_comps.end_date%TYPE

355: IN hxc_approval_comps.time_recipient_id%TYPE
356: ,p_start_date
357: IN hxc_approval_comps.start_date%TYPE
358: ,p_end_date
359: IN hxc_approval_comps.end_date%TYPE
360: )
361: IS
362: --
363: CURSOR c_chk_invalid_dates_create

Line 366: FROM hxc_approval_comps s

362: --
363: CURSOR c_chk_invalid_dates_create
364: IS
365: SELECT 'Y'
366: FROM hxc_approval_comps s
367: WHERE s.approval_style_id = p_approval_style_id
368: AND s.time_recipient_id = p_time_recipient_id
369: AND s.start_date >= p_start_date
370: AND NVL(s.end_date, hr_general.END_OF_TIME)

Line 431: IN hxc_approval_comps.approval_comp_id%TYPE

427: -- ----------------------------------------------------------------------------
428: --
429: PROCEDURE chk_invalid_dates_update
430: (p_approval_comp_id
431: IN hxc_approval_comps.approval_comp_id%TYPE
432: ,p_approval_style_id
433: IN hxc_approval_comps.approval_style_id%TYPE
434: ,p_time_recipient_id
435: IN hxc_approval_comps.time_recipient_id%TYPE

Line 433: IN hxc_approval_comps.approval_style_id%TYPE

429: PROCEDURE chk_invalid_dates_update
430: (p_approval_comp_id
431: IN hxc_approval_comps.approval_comp_id%TYPE
432: ,p_approval_style_id
433: IN hxc_approval_comps.approval_style_id%TYPE
434: ,p_time_recipient_id
435: IN hxc_approval_comps.time_recipient_id%TYPE
436: ,p_start_date
437: IN hxc_approval_comps.start_date%TYPE

Line 435: IN hxc_approval_comps.time_recipient_id%TYPE

431: IN hxc_approval_comps.approval_comp_id%TYPE
432: ,p_approval_style_id
433: IN hxc_approval_comps.approval_style_id%TYPE
434: ,p_time_recipient_id
435: IN hxc_approval_comps.time_recipient_id%TYPE
436: ,p_start_date
437: IN hxc_approval_comps.start_date%TYPE
438: ,p_end_date
439: IN hxc_approval_comps.end_date%TYPE

Line 437: IN hxc_approval_comps.start_date%TYPE

433: IN hxc_approval_comps.approval_style_id%TYPE
434: ,p_time_recipient_id
435: IN hxc_approval_comps.time_recipient_id%TYPE
436: ,p_start_date
437: IN hxc_approval_comps.start_date%TYPE
438: ,p_end_date
439: IN hxc_approval_comps.end_date%TYPE
440: )
441: IS

Line 439: IN hxc_approval_comps.end_date%TYPE

435: IN hxc_approval_comps.time_recipient_id%TYPE
436: ,p_start_date
437: IN hxc_approval_comps.start_date%TYPE
438: ,p_end_date
439: IN hxc_approval_comps.end_date%TYPE
440: )
441: IS
442: --
443: CURSOR c_chk_invalid_dates_update

Line 446: FROM hxc_approval_comps s

442: --
443: CURSOR c_chk_invalid_dates_update
444: IS
445: SELECT 'Y'
446: FROM hxc_approval_comps s
447: WHERE s.approval_comp_id <> p_approval_comp_id
448: AND s.approval_style_id = p_approval_style_id
449: AND s.time_recipient_id = p_time_recipient_id
450: AND s.start_date >= p_start_date

Line 516: IN hxc_approval_comps.approval_style_id%TYPE

512: -- ----------------------------------------------------------------------------
513: --
514: PROCEDURE chk_overlapping_dates_create
515: (p_approval_style_id
516: IN hxc_approval_comps.approval_style_id%TYPE
517: ,p_time_recipient_id
518: IN hxc_approval_comps.time_recipient_id%TYPE
519: ,p_start_date
520: IN hxc_approval_comps.start_date%TYPE

Line 518: IN hxc_approval_comps.time_recipient_id%TYPE

514: PROCEDURE chk_overlapping_dates_create
515: (p_approval_style_id
516: IN hxc_approval_comps.approval_style_id%TYPE
517: ,p_time_recipient_id
518: IN hxc_approval_comps.time_recipient_id%TYPE
519: ,p_start_date
520: IN hxc_approval_comps.start_date%TYPE
521: ,p_end_date
522: IN hxc_approval_comps.end_date%TYPE

Line 520: IN hxc_approval_comps.start_date%TYPE

516: IN hxc_approval_comps.approval_style_id%TYPE
517: ,p_time_recipient_id
518: IN hxc_approval_comps.time_recipient_id%TYPE
519: ,p_start_date
520: IN hxc_approval_comps.start_date%TYPE
521: ,p_end_date
522: IN hxc_approval_comps.end_date%TYPE
523: )
524: IS

Line 522: IN hxc_approval_comps.end_date%TYPE

518: IN hxc_approval_comps.time_recipient_id%TYPE
519: ,p_start_date
520: IN hxc_approval_comps.start_date%TYPE
521: ,p_end_date
522: IN hxc_approval_comps.end_date%TYPE
523: )
524: IS
525: --
526: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;

Line 526: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;

522: IN hxc_approval_comps.end_date%TYPE
523: )
524: IS
525: --
526: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;
527: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;
528: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;
529: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;
530: --

Line 527: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;

523: )
524: IS
525: --
526: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;
527: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;
528: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;
529: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;
530: --
531: BEGIN

Line 528: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;

524: IS
525: --
526: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;
527: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;
528: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;
529: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;
530: --
531: BEGIN
532: --

Line 529: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;

525: --
526: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;
527: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;
528: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;
529: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;
530: --
531: BEGIN
532: --
533: -- call the other chk_overlapping_dates_create procedure and

Line 619: IN hxc_approval_comps.approval_style_id%TYPE

615: -- ----------------------------------------------------------------------------
616: --
617: PROCEDURE chk_overlapping_dates_create
618: (p_approval_style_id
619: IN hxc_approval_comps.approval_style_id%TYPE
620: ,p_time_recipient_id
621: IN hxc_approval_comps.time_recipient_id%TYPE
622: ,p_start_date
623: IN hxc_approval_comps.start_date%TYPE

Line 621: IN hxc_approval_comps.time_recipient_id%TYPE

617: PROCEDURE chk_overlapping_dates_create
618: (p_approval_style_id
619: IN hxc_approval_comps.approval_style_id%TYPE
620: ,p_time_recipient_id
621: IN hxc_approval_comps.time_recipient_id%TYPE
622: ,p_start_date
623: IN hxc_approval_comps.start_date%TYPE
624: ,p_end_date
625: IN hxc_approval_comps.end_date%TYPE

Line 623: IN hxc_approval_comps.start_date%TYPE

619: IN hxc_approval_comps.approval_style_id%TYPE
620: ,p_time_recipient_id
621: IN hxc_approval_comps.time_recipient_id%TYPE
622: ,p_start_date
623: IN hxc_approval_comps.start_date%TYPE
624: ,p_end_date
625: IN hxc_approval_comps.end_date%TYPE
626: ,p_clashing_id
627: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE

Line 625: IN hxc_approval_comps.end_date%TYPE

621: IN hxc_approval_comps.time_recipient_id%TYPE
622: ,p_start_date
623: IN hxc_approval_comps.start_date%TYPE
624: ,p_end_date
625: IN hxc_approval_comps.end_date%TYPE
626: ,p_clashing_id
627: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
628: ,p_clashing_ovn
629: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE

Line 627: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE

623: IN hxc_approval_comps.start_date%TYPE
624: ,p_end_date
625: IN hxc_approval_comps.end_date%TYPE
626: ,p_clashing_id
627: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
628: ,p_clashing_ovn
629: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
630: ,p_clashing_start_date
631: OUT NOCOPY hxc_approval_comps.start_date%TYPE

Line 629: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE

625: IN hxc_approval_comps.end_date%TYPE
626: ,p_clashing_id
627: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
628: ,p_clashing_ovn
629: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
630: ,p_clashing_start_date
631: OUT NOCOPY hxc_approval_comps.start_date%TYPE
632: ,p_clashing_end_date
633: OUT NOCOPY hxc_approval_comps.end_date%TYPE

Line 631: OUT NOCOPY hxc_approval_comps.start_date%TYPE

627: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
628: ,p_clashing_ovn
629: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
630: ,p_clashing_start_date
631: OUT NOCOPY hxc_approval_comps.start_date%TYPE
632: ,p_clashing_end_date
633: OUT NOCOPY hxc_approval_comps.end_date%TYPE
634: )
635: IS

Line 633: OUT NOCOPY hxc_approval_comps.end_date%TYPE

629: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
630: ,p_clashing_start_date
631: OUT NOCOPY hxc_approval_comps.start_date%TYPE
632: ,p_clashing_end_date
633: OUT NOCOPY hxc_approval_comps.end_date%TYPE
634: )
635: IS
636: --
637: CURSOR c_chk_overlapping_dates_create

Line 643: FROM hxc_approval_comps s

639: SELECT s.approval_style_id
640: ,s.object_version_number
641: ,s.start_date
642: ,s.end_date
643: FROM hxc_approval_comps s
644: WHERE s.approval_style_id = p_approval_style_id
645: AND s.time_recipient_id = p_time_recipient_id
646: AND NOT ( (s.start_date < p_start_date
647: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)

Line 708: IN hxc_approval_comps.approval_comp_id%TYPE

704: -- ----------------------------------------------------------------------------
705: --
706: PROCEDURE chk_overlapping_dates_update
707: (p_approval_comp_id
708: IN hxc_approval_comps.approval_comp_id%TYPE
709: ,p_approval_style_id
710: IN hxc_approval_comps.approval_style_id%TYPE
711: ,p_time_recipient_id
712: IN hxc_approval_comps.time_recipient_id%TYPE

Line 710: IN hxc_approval_comps.approval_style_id%TYPE

706: PROCEDURE chk_overlapping_dates_update
707: (p_approval_comp_id
708: IN hxc_approval_comps.approval_comp_id%TYPE
709: ,p_approval_style_id
710: IN hxc_approval_comps.approval_style_id%TYPE
711: ,p_time_recipient_id
712: IN hxc_approval_comps.time_recipient_id%TYPE
713: ,p_start_date
714: IN hxc_approval_comps.start_date%TYPE

Line 712: IN hxc_approval_comps.time_recipient_id%TYPE

708: IN hxc_approval_comps.approval_comp_id%TYPE
709: ,p_approval_style_id
710: IN hxc_approval_comps.approval_style_id%TYPE
711: ,p_time_recipient_id
712: IN hxc_approval_comps.time_recipient_id%TYPE
713: ,p_start_date
714: IN hxc_approval_comps.start_date%TYPE
715: ,p_end_date
716: IN hxc_approval_comps.end_date%TYPE

Line 714: IN hxc_approval_comps.start_date%TYPE

710: IN hxc_approval_comps.approval_style_id%TYPE
711: ,p_time_recipient_id
712: IN hxc_approval_comps.time_recipient_id%TYPE
713: ,p_start_date
714: IN hxc_approval_comps.start_date%TYPE
715: ,p_end_date
716: IN hxc_approval_comps.end_date%TYPE
717: )
718: IS

Line 716: IN hxc_approval_comps.end_date%TYPE

712: IN hxc_approval_comps.time_recipient_id%TYPE
713: ,p_start_date
714: IN hxc_approval_comps.start_date%TYPE
715: ,p_end_date
716: IN hxc_approval_comps.end_date%TYPE
717: )
718: IS
719: --
720: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;

Line 720: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;

716: IN hxc_approval_comps.end_date%TYPE
717: )
718: IS
719: --
720: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;
721: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;
722: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;
723: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;
724: --

Line 721: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;

717: )
718: IS
719: --
720: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;
721: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;
722: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;
723: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;
724: --
725: BEGIN

Line 722: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;

718: IS
719: --
720: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;
721: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;
722: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;
723: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;
724: --
725: BEGIN
726: --

Line 723: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;

719: --
720: l_id hxc_approval_comps.approval_style_id%TYPE DEFAULT NULL;
721: l_ovn hxc_approval_comps.object_version_number%TYPE DEFAULT NULL;
722: l_start_date hxc_approval_comps.start_date%TYPE DEFAULT NULL;
723: l_end_date hxc_approval_comps.end_date%TYPE DEFAULT NULL;
724: --
725: BEGIN
726: --
727: -- call the other chk_overlapping_dates_update procedure and

Line 814: IN hxc_approval_comps.approval_comp_id%TYPE

810: -- ----------------------------------------------------------------------------
811: --
812: PROCEDURE chk_overlapping_dates_update
813: (p_approval_comp_id
814: IN hxc_approval_comps.approval_comp_id%TYPE
815: ,p_approval_style_id
816: IN hxc_approval_comps.approval_style_id%TYPE
817: ,p_time_recipient_id
818: IN hxc_approval_comps.time_recipient_id%TYPE

Line 816: IN hxc_approval_comps.approval_style_id%TYPE

812: PROCEDURE chk_overlapping_dates_update
813: (p_approval_comp_id
814: IN hxc_approval_comps.approval_comp_id%TYPE
815: ,p_approval_style_id
816: IN hxc_approval_comps.approval_style_id%TYPE
817: ,p_time_recipient_id
818: IN hxc_approval_comps.time_recipient_id%TYPE
819: ,p_start_date
820: IN hxc_approval_comps.start_date%TYPE

Line 818: IN hxc_approval_comps.time_recipient_id%TYPE

814: IN hxc_approval_comps.approval_comp_id%TYPE
815: ,p_approval_style_id
816: IN hxc_approval_comps.approval_style_id%TYPE
817: ,p_time_recipient_id
818: IN hxc_approval_comps.time_recipient_id%TYPE
819: ,p_start_date
820: IN hxc_approval_comps.start_date%TYPE
821: ,p_end_date
822: IN hxc_approval_comps.end_date%TYPE

Line 820: IN hxc_approval_comps.start_date%TYPE

816: IN hxc_approval_comps.approval_style_id%TYPE
817: ,p_time_recipient_id
818: IN hxc_approval_comps.time_recipient_id%TYPE
819: ,p_start_date
820: IN hxc_approval_comps.start_date%TYPE
821: ,p_end_date
822: IN hxc_approval_comps.end_date%TYPE
823: ,p_clashing_id
824: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE

Line 822: IN hxc_approval_comps.end_date%TYPE

818: IN hxc_approval_comps.time_recipient_id%TYPE
819: ,p_start_date
820: IN hxc_approval_comps.start_date%TYPE
821: ,p_end_date
822: IN hxc_approval_comps.end_date%TYPE
823: ,p_clashing_id
824: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
825: ,p_clashing_ovn
826: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE

Line 824: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE

820: IN hxc_approval_comps.start_date%TYPE
821: ,p_end_date
822: IN hxc_approval_comps.end_date%TYPE
823: ,p_clashing_id
824: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
825: ,p_clashing_ovn
826: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
827: ,p_clashing_start_date
828: OUT NOCOPY hxc_approval_comps.start_date%TYPE

Line 826: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE

822: IN hxc_approval_comps.end_date%TYPE
823: ,p_clashing_id
824: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
825: ,p_clashing_ovn
826: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
827: ,p_clashing_start_date
828: OUT NOCOPY hxc_approval_comps.start_date%TYPE
829: ,p_clashing_end_date
830: OUT NOCOPY hxc_approval_comps.end_date%TYPE

Line 828: OUT NOCOPY hxc_approval_comps.start_date%TYPE

824: OUT NOCOPY hxc_approval_comps.approval_style_id%TYPE
825: ,p_clashing_ovn
826: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
827: ,p_clashing_start_date
828: OUT NOCOPY hxc_approval_comps.start_date%TYPE
829: ,p_clashing_end_date
830: OUT NOCOPY hxc_approval_comps.end_date%TYPE
831: )
832: IS

Line 830: OUT NOCOPY hxc_approval_comps.end_date%TYPE

826: OUT NOCOPY hxc_approval_comps.object_version_number%TYPE
827: ,p_clashing_start_date
828: OUT NOCOPY hxc_approval_comps.start_date%TYPE
829: ,p_clashing_end_date
830: OUT NOCOPY hxc_approval_comps.end_date%TYPE
831: )
832: IS
833: --
834: CURSOR c_chk_overlapping_dates_update

Line 840: FROM hxc_approval_comps s

836: SELECT s.approval_style_id
837: ,s.object_version_number
838: ,s.start_date
839: ,s.end_date
840: FROM hxc_approval_comps s
841: WHERE s.approval_comp_id <> p_approval_comp_id
842: AND s.approval_style_id = p_approval_style_id
843: AND s.time_recipient_id = p_time_recipient_id
844: AND NOT ( (s.start_date < p_start_date

Line 904: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

900: -- ----------------------------------------------------------------------------
901: --
902: PROCEDURE chk_master_detail_rel
903: (
904: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
905: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )
906:
907:
908: IS

Line 905: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )

901: --
902: PROCEDURE chk_master_detail_rel
903: (
904: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
905: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )
906:
907:
908: IS
909: --

Line 910: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;

906:
907:
908: IS
909: --
910: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
911: l_object_version_number hxc_approval_comps.object_version_number%TYPE;
912:
913: CURSOR c_chk_master_record_exists
914: IS

Line 911: l_object_version_number hxc_approval_comps.object_version_number%TYPE;

907:
908: IS
909: --
910: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
911: l_object_version_number hxc_approval_comps.object_version_number%TYPE;
912:
913: CURSOR c_chk_master_record_exists
914: IS
915: SELECT s.approval_comp_id

Line 917: FROM hxc_approval_comps s

913: CURSOR c_chk_master_record_exists
914: IS
915: SELECT s.approval_comp_id
916: ,s.object_version_number
917: FROM hxc_approval_comps s
918: WHERE s.approval_comp_id = p_parent_comp_id
919: AND s.object_version_number = p_parent_comp_ovn
920: AND s.approval_mechanism = 'ENTRY_LEVEL_APPROVAL';
921: --

Line 984: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

980: -- ----------------------------------------------------------------------------
981: --
982: PROCEDURE chk_parent_fields
983: (
984: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
985: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )
986:
987: IS
988: --

Line 985: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )

981: --
982: PROCEDURE chk_parent_fields
983: (
984: p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
985: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )
986:
987: IS
988: --
989: --

Line 1046: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

1042: -- {End Of Comments}
1043: -- ----------------------------------------------------------------------------
1044: --
1045: PROCEDURE chk_tim_cat
1046: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1047: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1048: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE )
1049:
1050: IS

Line 1047: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE

1043: -- ----------------------------------------------------------------------------
1044: --
1045: PROCEDURE chk_tim_cat
1046: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1047: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1048: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE )
1049:
1050: IS
1051: --

Line 1048: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE )

1044: --
1045: PROCEDURE chk_tim_cat
1046: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1047: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1048: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE )
1049:
1050: IS
1051: --
1052:

Line 1138: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE

1134: -- ----------------------------------------------------------------------------
1135: --
1136: PROCEDURE chk_def_ela_rec_exists
1137: (
1138: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
1139: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1140: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1141: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )
1142:

Line 1139: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE

1135: --
1136: PROCEDURE chk_def_ela_rec_exists
1137: (
1138: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
1139: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1140: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1141: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )
1142:
1143:

Line 1140: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

1136: PROCEDURE chk_def_ela_rec_exists
1137: (
1138: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
1139: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1140: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1141: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )
1142:
1143:
1144: IS

Line 1141: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )

1137: (
1138: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
1139: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1140: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1141: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE )
1142:
1143:
1144: IS
1145: --

Line 1146: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;

1142:
1143:
1144: IS
1145: --
1146: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
1147: l_object_version_number hxc_approval_comps.object_version_number%TYPE;
1148:
1149: CURSOR c_def_ela_rec_exists
1150: IS

Line 1147: l_object_version_number hxc_approval_comps.object_version_number%TYPE;

1143:
1144: IS
1145: --
1146: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
1147: l_object_version_number hxc_approval_comps.object_version_number%TYPE;
1148:
1149: CURSOR c_def_ela_rec_exists
1150: IS
1151: SELECT s.approval_comp_id

Line 1153: FROM hxc_approval_comps s

1149: CURSOR c_def_ela_rec_exists
1150: IS
1151: SELECT s.approval_comp_id
1152: ,s.object_version_number
1153: FROM hxc_approval_comps s
1154: WHERE s.approval_comp_id <> nvl(p_approval_comp_id,-99)
1155: AND s.parent_comp_id = p_parent_comp_id
1156: AND s.parent_comp_ovn = p_parent_comp_ovn
1157: AND s.time_category_id = p_time_category_id;

Line 1219: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

1215: -- {End Of Comments}
1216: -- ----------------------------------------------------------------------------
1217: --
1218: PROCEDURE chk_tim_rcp
1219: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1220: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1221: ,p_time_recipient_id IN hxc_approval_comps.time_recipient_id%TYPE )
1222:
1223: IS

Line 1220: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE

1216: -- ----------------------------------------------------------------------------
1217: --
1218: PROCEDURE chk_tim_rcp
1219: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1220: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1221: ,p_time_recipient_id IN hxc_approval_comps.time_recipient_id%TYPE )
1222:
1223: IS
1224: --

Line 1221: ,p_time_recipient_id IN hxc_approval_comps.time_recipient_id%TYPE )

1217: --
1218: PROCEDURE chk_tim_rcp
1219: ( p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1220: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1221: ,p_time_recipient_id IN hxc_approval_comps.time_recipient_id%TYPE )
1222:
1223: IS
1224: --
1225:

Line 1313: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE

1309: -- ----------------------------------------------------------------------------
1310: --
1311: PROCEDURE chk_tim_cat_dup
1312: (
1313: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
1314: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1315: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
1316: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE

Line 1314: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE

1310: --
1311: PROCEDURE chk_tim_cat_dup
1312: (
1313: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
1314: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1315: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
1316: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1318: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE

Line 1315: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE

1311: PROCEDURE chk_tim_cat_dup
1312: (
1313: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
1314: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1315: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
1316: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1318: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1319: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE

Line 1316: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

1312: (
1313: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
1314: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1315: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
1316: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1318: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1319: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
1320: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE

Line 1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE

1313: p_approval_comp_id IN hxc_approval_comps.approval_comp_id%TYPE
1314: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1315: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
1316: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1318: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1319: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
1320: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
1321: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE)

Line 1318: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE

1314: ,p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1315: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
1316: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1318: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1319: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
1320: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
1321: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE)
1322:

Line 1319: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE

1315: ,p_approval_order IN hxc_approval_comps.approval_order%TYPE
1316: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1318: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1319: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
1320: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
1321: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE)
1322:
1323: IS

Line 1320: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE

1316: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1318: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1319: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
1320: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
1321: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE)
1322:
1323: IS
1324: --

Line 1321: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE)

1317: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1318: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1319: ,p_approval_mechanism_id IN hxc_approval_comps.approval_mechanism_id%TYPE
1320: ,p_wf_name IN hxc_approval_comps.wf_name%TYPE
1321: ,p_wf_item_type IN hxc_approval_comps.wf_item_type%TYPE)
1322:
1323: IS
1324: --
1325: l_dummy varchar2(1);

Line 1330: FROM hxc_approval_comps s

1326:
1327: CURSOR c_tim_cat_exists
1328: IS
1329: SELECT 'Y'
1330: FROM hxc_approval_comps s
1331: WHERE s.approval_comp_id <> nvl(p_approval_comp_id,-99)
1332: AND s.parent_comp_id = p_parent_comp_id
1333: AND s.parent_comp_ovn = p_parent_comp_ovn
1334: AND s.time_category_id = p_time_category_id

Line 1344: FROM hxc_approval_comps s

1340:
1341: CURSOR c_tim_cat_dup
1342: IS
1343: SELECT 'Y'
1344: FROM hxc_approval_comps s
1345: WHERE s.approval_comp_id <> nvl(p_approval_comp_id,-99)
1346: AND s.parent_comp_id = p_parent_comp_id
1347: AND s.parent_comp_ovn = p_parent_comp_ovn
1348: AND s.time_category_id = p_time_category_id

Line 1434: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE

1430: -- ----------------------------------------------------------------------------
1431: --
1432: PROCEDURE chk_app_mech_for_child
1433: (
1434: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1435: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1436: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1437: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1438: )

Line 1435: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE

1431: --
1432: PROCEDURE chk_app_mech_for_child
1433: (
1434: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1435: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1436: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1437: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1438: )
1439:

Line 1436: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE

1432: PROCEDURE chk_app_mech_for_child
1433: (
1434: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1435: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1436: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1437: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1438: )
1439:
1440: IS

Line 1437: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE

1433: (
1434: p_time_category_id IN hxc_approval_comps.time_category_id%TYPE
1435: ,p_approval_mechanism IN hxc_approval_comps.approval_mechanism%TYPE
1436: ,p_parent_comp_id IN hxc_approval_comps.parent_comp_id%TYPE
1437: ,p_parent_comp_ovn IN hxc_approval_comps.parent_comp_ovn%TYPE
1438: )
1439:
1440: IS
1441: --

Line 1511: p_run_recipient_extensions in hxc_approval_comps.run_recipient_extensions%type

1507:
1508:
1509: Procedure chk_allowable_extensions
1510: (
1511: p_run_recipient_extensions in hxc_approval_comps.run_recipient_extensions%type
1512: ,p_approval_style_id in hxc_approval_comps.approval_style_id%type
1513: ) is
1514:
1515: cursor crs_approval_extensions is select

Line 1512: ,p_approval_style_id in hxc_approval_comps.approval_style_id%type

1508:
1509: Procedure chk_allowable_extensions
1510: (
1511: p_run_recipient_extensions in hxc_approval_comps.run_recipient_extensions%type
1512: ,p_approval_style_id in hxc_approval_comps.approval_style_id%type
1513: ) is
1514:
1515: cursor crs_approval_extensions is select
1516: run_recipient_extensions from