APPS.PAY_RCU_BUS dependencies on PAY_RETRO_COMPONENT_USAGES

Line 31: , pay_retro_component_usages rcu

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pay_retro_component_usages rcu
32: where rcu.retro_component_usage_id = p_retro_component_usage_id
33: and pbg.business_group_id (+) = rcu.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pay_retro_component_usages rcu

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pay_retro_component_usages rcu
102: where rcu.retro_component_usage_id = p_retro_component_usage_id
103: and pbg.business_group_id (+) = rcu.business_group_id;
104: --
105: -- Declare local variables

Line 328: (p_retro_component_id in pay_retro_component_usages.retro_component_id%type

324: --
325: -- {End Of Comments}
326: --
327: procedure chk_retro_component_id
328: (p_retro_component_id in pay_retro_component_usages.retro_component_id%type
329: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
330: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
331: )
332: is

Line 329: ,p_business_group_id in pay_retro_component_usages.business_group_id%type

325: -- {End Of Comments}
326: --
327: procedure chk_retro_component_id
328: (p_retro_component_id in pay_retro_component_usages.retro_component_id%type
329: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
330: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
331: )
332: is
333: --

Line 330: ,p_legislation_code in pay_retro_component_usages.legislation_code%type

326: --
327: procedure chk_retro_component_id
328: (p_retro_component_id in pay_retro_component_usages.retro_component_id%type
329: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
330: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
331: )
332: is
333: --
334: -- Declare local variables

Line 340: l_legislation_code pay_retro_component_usages.legislation_code%type;

336: l_proc varchar2(72) := g_package||'chk_retro_component_id';
337: l_varchar2 varchar2(30) := hr_api.g_varchar2;
338: l_number number := hr_api.g_number;
339: l_exists varchar2(1);
340: l_legislation_code pay_retro_component_usages.legislation_code%type;
341:
342: --
343: -- Cursor to check that a retro component exists.
344: --

Line 424: (p_creator_type in pay_retro_component_usages.creator_type%type

420: --
421: -- {End Of Comments}
422: --
423: procedure chk_creator_type_creator_id
424: (p_creator_type in pay_retro_component_usages.creator_type%type
425: ,p_creator_id in pay_retro_component_usages.creator_id%type
426: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
427: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
428: ,p_effective_date in date

Line 425: ,p_creator_id in pay_retro_component_usages.creator_id%type

421: -- {End Of Comments}
422: --
423: procedure chk_creator_type_creator_id
424: (p_creator_type in pay_retro_component_usages.creator_type%type
425: ,p_creator_id in pay_retro_component_usages.creator_id%type
426: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
427: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
428: ,p_effective_date in date
429: )

Line 426: ,p_business_group_id in pay_retro_component_usages.business_group_id%type

422: --
423: procedure chk_creator_type_creator_id
424: (p_creator_type in pay_retro_component_usages.creator_type%type
425: ,p_creator_id in pay_retro_component_usages.creator_id%type
426: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
427: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
428: ,p_effective_date in date
429: )
430: is

Line 427: ,p_legislation_code in pay_retro_component_usages.legislation_code%type

423: procedure chk_creator_type_creator_id
424: (p_creator_type in pay_retro_component_usages.creator_type%type
425: ,p_creator_id in pay_retro_component_usages.creator_id%type
426: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
427: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
428: ,p_effective_date in date
429: )
430: is
431: --

Line 438: l_legislation_code pay_retro_component_usages.legislation_code%type;

434: l_proc varchar2(72) := g_package||'chk_retro_component_id';
435: l_varchar2 varchar2(30) := hr_api.g_varchar2;
436: l_number number := hr_api.g_number;
437: l_exists varchar2(1);
438: l_legislation_code pay_retro_component_usages.legislation_code%type;
439:
440: --
441: -- Cursor to check that an element type exists.
442: --

Line 583: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type

579: --
580: -- {End Of Comments}
581: --
582: procedure chk_reprocess_type
583: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
584: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
585: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
586: ,p_reprocess_type in pay_retro_component_usages.reprocess_type%type
587: ,p_effective_date in date

Line 584: ,p_object_version_number in pay_retro_component_usages.object_version_number%type

580: -- {End Of Comments}
581: --
582: procedure chk_reprocess_type
583: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
584: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
585: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
586: ,p_reprocess_type in pay_retro_component_usages.reprocess_type%type
587: ,p_effective_date in date
588: )

Line 585: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type

581: --
582: procedure chk_reprocess_type
583: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
584: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
585: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
586: ,p_reprocess_type in pay_retro_component_usages.reprocess_type%type
587: ,p_effective_date in date
588: )
589: is

Line 586: ,p_reprocess_type in pay_retro_component_usages.reprocess_type%type

582: procedure chk_reprocess_type
583: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
584: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
585: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
586: ,p_reprocess_type in pay_retro_component_usages.reprocess_type%type
587: ,p_effective_date in date
588: )
589: is
590: --

Line 715: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type

711: --
712: -- {End Of Comments}
713: --
714: procedure chk_default_component
715: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
716: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
717: ,p_creator_type in pay_retro_component_usages.creator_type%type
718: ,p_creator_id in pay_retro_component_usages.creator_id%type
719: ,p_default_component in pay_retro_component_usages.default_component%type

Line 716: ,p_object_version_number in pay_retro_component_usages.object_version_number%type

712: -- {End Of Comments}
713: --
714: procedure chk_default_component
715: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
716: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
717: ,p_creator_type in pay_retro_component_usages.creator_type%type
718: ,p_creator_id in pay_retro_component_usages.creator_id%type
719: ,p_default_component in pay_retro_component_usages.default_component%type
720: ,p_effective_date in date

Line 717: ,p_creator_type in pay_retro_component_usages.creator_type%type

713: --
714: procedure chk_default_component
715: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
716: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
717: ,p_creator_type in pay_retro_component_usages.creator_type%type
718: ,p_creator_id in pay_retro_component_usages.creator_id%type
719: ,p_default_component in pay_retro_component_usages.default_component%type
720: ,p_effective_date in date
721: ,p_business_group_id in pay_retro_component_usages.business_group_id%type

Line 718: ,p_creator_id in pay_retro_component_usages.creator_id%type

714: procedure chk_default_component
715: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
716: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
717: ,p_creator_type in pay_retro_component_usages.creator_type%type
718: ,p_creator_id in pay_retro_component_usages.creator_id%type
719: ,p_default_component in pay_retro_component_usages.default_component%type
720: ,p_effective_date in date
721: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
722: ,p_legislation_code in pay_retro_component_usages.legislation_code%type

Line 719: ,p_default_component in pay_retro_component_usages.default_component%type

715: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
716: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
717: ,p_creator_type in pay_retro_component_usages.creator_type%type
718: ,p_creator_id in pay_retro_component_usages.creator_id%type
719: ,p_default_component in pay_retro_component_usages.default_component%type
720: ,p_effective_date in date
721: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
722: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
723: )

Line 721: ,p_business_group_id in pay_retro_component_usages.business_group_id%type

717: ,p_creator_type in pay_retro_component_usages.creator_type%type
718: ,p_creator_id in pay_retro_component_usages.creator_id%type
719: ,p_default_component in pay_retro_component_usages.default_component%type
720: ,p_effective_date in date
721: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
722: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
723: )
724: is
725: --

Line 722: ,p_legislation_code in pay_retro_component_usages.legislation_code%type

718: ,p_creator_id in pay_retro_component_usages.creator_id%type
719: ,p_default_component in pay_retro_component_usages.default_component%type
720: ,p_effective_date in date
721: ,p_business_group_id in pay_retro_component_usages.business_group_id%type
722: ,p_legislation_code in pay_retro_component_usages.legislation_code%type
723: )
724: is
725: --
726: -- Declare local variables

Line 741: from pay_retro_component_usages

737: -- while checking for the default component.
738:
739: cursor csr_default_component_usage is
740: select null
741: from pay_retro_component_usages
742: where creator_type = p_creator_type
743: and creator_id = p_creator_id
744: and retro_component_usage_id <> nvl(p_retro_component_usage_id, l_number)
745: and default_component = 'Y'

Line 871: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type

867: --
868: -- {End Of Comments}
869: --
870: procedure chk_replace_run_flag
871: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
872: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
873: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
874: ,p_replace_run_flag in pay_retro_component_usages.replace_run_flag%type
875: ,p_effective_date in date

Line 872: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type

868: -- {End Of Comments}
869: --
870: procedure chk_replace_run_flag
871: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
872: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
873: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
874: ,p_replace_run_flag in pay_retro_component_usages.replace_run_flag%type
875: ,p_effective_date in date
876: )

Line 873: ,p_object_version_number in pay_retro_component_usages.object_version_number%type

869: --
870: procedure chk_replace_run_flag
871: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
872: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
873: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
874: ,p_replace_run_flag in pay_retro_component_usages.replace_run_flag%type
875: ,p_effective_date in date
876: )
877: is

Line 874: ,p_replace_run_flag in pay_retro_component_usages.replace_run_flag%type

870: procedure chk_replace_run_flag
871: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
872: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
873: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
874: ,p_replace_run_flag in pay_retro_component_usages.replace_run_flag%type
875: ,p_effective_date in date
876: )
877: is
878: --

Line 996: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type

992: --
993: -- {End Of Comments}
994: --
995: procedure chk_use_override_dates
996: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
997: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
998: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
999: ,p_use_override_dates in pay_retro_component_usages.use_override_dates%type
1000: ,p_effective_date in date

Line 997: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type

993: -- {End Of Comments}
994: --
995: procedure chk_use_override_dates
996: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
997: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
998: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
999: ,p_use_override_dates in pay_retro_component_usages.use_override_dates%type
1000: ,p_effective_date in date
1001: )

Line 998: ,p_object_version_number in pay_retro_component_usages.object_version_number%type

994: --
995: procedure chk_use_override_dates
996: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
997: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
998: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
999: ,p_use_override_dates in pay_retro_component_usages.use_override_dates%type
1000: ,p_effective_date in date
1001: )
1002: is

Line 999: ,p_use_override_dates in pay_retro_component_usages.use_override_dates%type

995: procedure chk_use_override_dates
996: (p_retro_component_usage_id in pay_retro_component_usages.retro_component_usage_id%type
997: ,p_retro_component_id in pay_retro_component_usages.retro_component_id%type
998: ,p_object_version_number in pay_retro_component_usages.object_version_number%type
999: ,p_use_override_dates in pay_retro_component_usages.use_override_dates%type
1000: ,p_effective_date in date
1001: )
1002: is
1003: --