79:
80: ---------------------------------------------------------------------------
81: -- Procedure to merge the new value in the given Table
82: ---------------------------------------------------------------------------
83: PROCEDURE Merge_new_entry(p_num_table IN OUT NOCOPY EGO_NUMBER_TBL_TYPE,
84: p_num_value IN NUMBER) IS
85:
86: l_value_exists BOOLEAN := FALSE;
87: BEGIN
87: BEGIN
88:
89: IF (p_num_table IS NULL) THEN
90:
91: p_num_table := EGO_NUMBER_TBL_TYPE();
92: --WRITE_OUT('NEW Entry, add value to the end: '||p_num_value);
93: p_num_table.EXTEND();
94: p_num_table(p_num_table.LAST) := p_num_value;
95:
3815: l_attr_code CONSTANT VARCHAR2(30) := 'ATTRIBUTE_GROUP';
3816: l_acceptable_policy CONSTANT VARCHAR2(30) := 'ALLOWED';
3817:
3818: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3819: l_attr_group_ids EGO_NUMBER_TBL_TYPE := NULL;
3820: l_attr_group_ids_to_exclude EGO_NUMBER_TBL_TYPE := NULL;
3821: l_perform_dml BOOLEAN := TRUE;
3822: l_lc_catalog_cat_id NUMBER;
3823: l_catalog_category_id NUMBER;
3816: l_acceptable_policy CONSTANT VARCHAR2(30) := 'ALLOWED';
3817:
3818: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3819: l_attr_group_ids EGO_NUMBER_TBL_TYPE := NULL;
3820: l_attr_group_ids_to_exclude EGO_NUMBER_TBL_TYPE := NULL;
3821: l_perform_dml BOOLEAN := TRUE;
3822: l_lc_catalog_cat_id NUMBER;
3823: l_catalog_category_id NUMBER;
3824: l_lifecycle_id NUMBER;
3970: l_policy_value <> l_acceptable_policy) THEN
3971:
3972: IF l_attr_group_ids_to_exclude IS NULL THEN
3973:
3974: l_attr_group_ids_to_exclude := EGO_NUMBER_TBL_TYPE();
3975:
3976: END IF;
3977:
3978: -- exclude this attribute group
4035: -----------------------------------------------------------------------
4036: -- If the Exclusion Number table is NULL, then create new.
4037: -----------------------------------------------------------------------
4038: IF l_attr_group_ids_to_exclude IS NULL THEN
4039: l_attr_group_ids_to_exclude := EGO_NUMBER_TBL_TYPE();
4040: END IF;
4041:
4042: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Attr Grp ID => '|| l_attr_grp_table(i));
4043: -----------------------------------------------------------------------