3761: select ORG_CLASSIFICATION,
3762: ORG_INFORMATION_TYPE,
3763: MANDATORY_FLAG,
3764: ENABLED_FLAG
3765: from hr_org_info_types_by_class
3766: where org_information_type = stu_rec.org_information_type
3767: )
3768: UNION
3769: (select ORG_CLASSIFICATION,
3769: (select ORG_CLASSIFICATION,
3770: ORG_INFORMATION_TYPE,
3771: MANDATORY_FLAG,
3772: ENABLED_FLAG
3773: from hr_org_info_types_by_class
3774: where org_information_type = stu_rec.org_information_type
3775: MINUS
3776: select ORG_CLASSIFICATION,
3777: ORG_INFORMATION_TYPE,
3829:
3830: END IF;
3831:
3832:
3833: delete from hr_org_info_types_by_class
3834: where org_information_type = stu_rec.org_information_type;
3835:
3836:
3837: insert into hr_org_info_types_by_class
3833: delete from hr_org_info_types_by_class
3834: where org_information_type = stu_rec.org_information_type;
3835:
3836:
3837: insert into hr_org_info_types_by_class
3838: (ORG_CLASSIFICATION
3839: ,ORG_INFORMATION_TYPE
3840: ,MANDATORY_FLAG
3841: ,ENABLED_FLAG