DBA Data[Home] [Help]

APPS.FTE_SEL_GROUPS_PKG dependencies on FTE_SEL_GROUP_ATTRIBUTES

Line 450: from fte_sel_group_attributes

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

Line 593: -- 2) FTE_SEL_GROUP_ATTRIBUTES

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

Line 675: -- 2) FTE_SEL_GROUP_ATTRIBUTES

671:
672:
673:
674: --
675: -- 2) FTE_SEL_GROUP_ATTRIBUTES
676: --
677:
678: t_group_attribute_id.DELETE;
679: t_attribute_id.DELETE;

Line 710: INSERT INTO fte_sel_group_attributes (

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,

Line 723: (FTE_SEL_GROUP_ATTRIBUTES_S.NEXTVAL,

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,