APPS.HR_LEGISLATION_BENEFITS dependencies on BEN_BENEFIT_CLASSIFICATIONS

Line 568: -- INSTALLATION PROCEDURE FOR : BEN_BENEFIT_CLASSIFICATIONS

564:
565: END install_cobra_qfying_events;
566:
567: --****************************************************************************
568: -- INSTALLATION PROCEDURE FOR : BEN_BENEFIT_CLASSIFICATIONS
569: --****************************************************************************
570:
571: PROCEDURE install_ben_class(p_phase IN number)
572: ----------------------------------------------

Line 641: from ben_benefit_classifications a

637:
638:
639: select distinct null
640: into l_null_return
641: from ben_benefit_classifications a
642: where exists
643: (select null
644: from hr_s_benefit_classifications b
645: where a.benefit_classification_id=b.benefit_classification_id

Line 670: select ben_benefit_classifications_s.nextval

666: into v_min_delivered
667: , v_max_delivered
668: from hr_s_benefit_classifications;
669:
670: select ben_benefit_classifications_s.nextval
671: into v_sequence_number
672: from dual;
673:
674: WHILE

Line 679: select ben_benefit_classifications_s.nextval

675: v_sequence_number BETWEEN v_min_delivered AND v_max_delivered
676: LOOP
677:
678:
679: select ben_benefit_classifications_s.nextval
680: into v_sequence_number
681: from dual;
682:
683: END LOOP;

Line 691: -- BEN_BENEFIT_CLASSIFICATIONS

687: PROCEDURE crt_exc (exception_type IN varchar2)
688: ----------------------------------------------
689: IS
690: -- Reports any exceptions during the delivery of startup data to
691: -- BEN_BENEFIT_CLASSIFICATIONS
692:
693: BEGIN
694: -- When the installation procedures encounter an error that cannot
695: -- be handled, an exception is raised and all work is rolled back

Line 702: hr_legislation.insert_hr_stu_exceptions('ben_benefit_classifications'

698: -- not be raised more than once.
699:
700: rollback to new_classification_name;
701:
702: hr_legislation.insert_hr_stu_exceptions('ben_benefit_classifications'
703: , stu_rec.c_surrogate_key
704: , exception_type
705: , stu_rec.c_true_key);
706:

Line 722: from ben_benefit_classifications

718:
719:
720: select distinct benefit_classification_id
721: into l_new_surrogate_key
722: from ben_benefit_classifications
723: where benefit_classification_name = stu_rec.c_true_key
724: and business_group_id is null
725: and ( (legislation_code is null
726: and stu_rec.c_leg_code is null)

Line 732: select ben_benefit_classifications_s.nextval

728:
729: EXCEPTION WHEN NO_DATA_FOUND THEN
730:
731:
732: select ben_benefit_classifications_s.nextval
733: into l_new_surrogate_key
734: from dual;
735:
736: END;

Line 860: from ben_benefit_classifications a

856: -- already been created by a user.
857:
858: select distinct null
859: into l_null_return
860: from ben_benefit_classifications a
861: where a.business_group_id is not null
862: and a.benefit_classification_name = stu_rec.c_true_key
863: and exists (select null from per_business_groups b
864: where b.business_group_id = a.business_group_id

Line 890: from ben_benefit_classifications

886: BEGIN
887:
888: select distinct null
889: into l_null_return
890: from ben_benefit_classifications
891: where benefit_classification_name = stu_rec.c_true_key
892: and nvl(legislation_code,'x') <> nvl(stu_rec.c_leg_code,'x')
893: and ( legislation_code is null
894: or stu_rec.c_leg_code is null );

Line 937: update ben_benefit_classifications

933: return;
934: END IF;
935:
936:
937: update ben_benefit_classifications
938: set benefit_classification_name = stu_rec.c_true_key
939: , business_group_id = stu_rec.business_group_id
940: , legislation_code = stu_rec.c_leg_code
941: , active_flag = stu_rec.active_flag

Line 962: insert into ben_benefit_classifications

958:
959: IF SQL%NOTFOUND THEN
960:
961:
962: insert into ben_benefit_classifications
963: ( benefit_classification_name
964: , benefit_classification_id
965: , business_group_id
966: , legislation_code