9: p_attr_group_type IN VARCHAR2
10: ,p_attr_group_name IN VARCHAR2
11: ,p_attr_group_id IN NUMBER
12: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14: ,x_return_status OUT NOCOPY VARCHAR2
15: ,x_error_messages OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
16: ) IS
17:
11: ,p_attr_group_id IN NUMBER
12: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE
13: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
14: ,x_return_status OUT NOCOPY VARCHAR2
15: ,x_error_messages OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
16: ) IS
17:
18: l_curr_data_element EGO_USER_ATTR_DATA_OBJ;
19: l_curr_pk_col_name_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
17:
18: l_curr_data_element EGO_USER_ATTR_DATA_OBJ;
19: l_curr_pk_col_name_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
20: l_curr_class_cd_val_element EGO_COL_NAME_VALUE_PAIR_OBJ;
21: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY;
22:
23: -- attribute group --
24: l_attr_group_type VARCHAR2(40);
25: l_attrgrp_name VARCHAR2(40);
61: l_min_exists BOOLEAN := FALSE;
62: l_default_value_exists BOOLEAN := FALSE;
63:
64: -- error --
65: l_error_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();
66: l_error_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
67:
68: l_appl_id NUMBER;
69: l_attr_grp_display_name VARCHAR2(60);
81: BEGIN
82:
83: -- Initialize Return Status
84: x_return_status := 'S';
85: x_error_messages := EGO_COL_NAME_VALUE_PAIR_ARRAY();
86: l_attrgrp_name := p_attr_group_name;
87:
88: IF (Is_Attribute_Group_Telco(l_attrgrp_name,p_attr_group_type)) THEN
89:
467:
468: IF ( x_return_status = 'E' ) THEN
469: x_error_messages := l_error_name_value_pairs;
470: ELSE
471: x_error_messages := EGO_COL_NAME_VALUE_PAIR_ARRAY();
472: END IF;
473:
474: END IF;
475:
483: ,p_attr_grp_type IN VARCHAR2
484: ,p_attr_grp_name IN VARCHAR2
485: ,p_attr_name IN VARCHAR2
486: ,p_attr_name_value_pairs IN ego_user_attr_data_table
487: ,p_pk_column_name_value_pairs IN ego_col_name_value_pair_array
488: ) RETURN VARCHAR2
489: IS
490: l_appl_id NUMBER;
491: l_object_name VARCHAR2(30);
500: l_user_attr_val VARCHAR2(30);
501: l_object_id NUMBER;
502: l_attr_group_metadata_obj EGO_ATTR_GROUP_METADATA_OBJ;
503: l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
504: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
505: l_extension_id NUMBER;
506: l_index NUMBER;
507: l_attr_grp_id NUMBER;
508:
604: l_object_id := EGO_USER_ATTRS_DATA_PVT.Get_Object_Id_From_Name('EGO_ITEM');
605: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(p_object_id => l_object_id);
606:
607: l_data_level_name_value_pairs :=
608: EGO_COL_NAME_VALUE_PAIR_ARRAY(
609: EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID', l_pk_value3 )
610: );
611:
612: ELSIF (p_attr_grp_type = 'BOM_COMPONENTMGMT_GROUP') THEN
613:
614: l_object_id := EGO_USER_ATTRS_DATA_PVT.Get_Object_Id_From_Name('BOM_COMPONENTS');
615: l_ext_table_metadata_obj := EGO_USER_ATTRS_COMMON_PVT.Get_Ext_Table_Metadata(p_object_id => l_object_id);
616:
617: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
618:
619: END IF;
620:
621:
711: -- Validation is done for only Single Row AG's since --
712: -- defaulting is not done for MR AG's as per current functionality --
713: -----------------------------------------------------------------------
714: PROCEDURE Validate_Default_CompAttr(
715: p_pk_column_name_value_pairs IN ego_col_name_value_pair_array DEFAULT NULL
716: ,x_return_status OUT NOCOPY VARCHAR2
717: ,x_error_messages OUT NOCOPY ego_col_name_value_pair_array
718: )IS
719:
713: -----------------------------------------------------------------------
714: PROCEDURE Validate_Default_CompAttr(
715: p_pk_column_name_value_pairs IN ego_col_name_value_pair_array DEFAULT NULL
716: ,x_return_status OUT NOCOPY VARCHAR2
717: ,x_error_messages OUT NOCOPY ego_col_name_value_pair_array
718: )IS
719:
720:
721: l_object_id NUMBER;
743:
744: BEGIN
745: -- Initialize Return Status
746: x_return_status := 'S';
747: x_error_messages := EGO_COL_NAME_VALUE_PAIR_ARRAY();
748: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
749:
750: -- get pk values - bill_sequence_id, structure_type_id, component_sequence_id
751: l_index := p_pk_column_name_value_pairs.FIRST;
782:
783: IF ( x_return_status = 'E' ) THEN
784: return;
785: ELSE
786: x_error_messages := EGO_COL_NAME_VALUE_PAIR_ARRAY();
787: END IF;
788:
789: END IF;
790: