446: attribute_id,
447: attribute_default_value,
448: attribute_uom_code,
449: attribute_name
450: from fte_sel_group_attributes
451: where group_id = x_group_id;
452:
453:
454: cursor c_get_rules(xxx_group_id NUMBER) IS
589:
590: --
591: -- Copy group:
592: -- 1) FTE_SEL_GROUPS
593: -- 2) FTE_SEL_GROUP_ATTRIBUTES
594: -- 3) FTE_SEL_RULES
595: -- 4) FTE_SEL_RULE_RESTRICTIONS
596: -- 5) FTE_SEL_RESULTS
597: -- 5a) FTE_SEL_RESULT_ASSIGNMENTS
671:
672:
673:
674: --
675: -- 2) FTE_SEL_GROUP_ATTRIBUTES
676: --
677:
678: t_group_attribute_id.DELETE;
679: t_attribute_id.DELETE;
706: --
707: IF (t_group_attribute_id.COUNT > 0) THEN
708:
709: FORALL j in t_group_attribute_id.FIRST..t_group_attribute_id.LAST
710: INSERT INTO fte_sel_group_attributes (
711: GROUP_ATTRIBUTE_ID,
712: ATTRIBUTE_ID,
713: ATTRIBUTE_DEFAULT_VALUE,
714: ATTRIBUTE_UOM_CODE,
719: LAST_UPDATED_BY,
720: LAST_UPDATE_LOGIN,
721: ATTRIBUTE_NAME)
722: VALUES
723: (FTE_SEL_GROUP_ATTRIBUTES_S.NEXTVAL,
724: t_attribute_id(j),
725: t_attribute_default_value(j),
726: t_attribute_uom_code(j),
727: l_new_group_id,