DBA Data[Home] [Help]

APPS.EGO_COM_ATTR_VALIDATION dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 13: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

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:

Line 15: ,x_error_messages OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

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;

Line 21: l_error_messages EGO_COL_NAME_VALUE_PAIR_ARRAY;

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);

Line 65: l_error_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := EGO_COL_NAME_VALUE_PAIR_ARRAY();

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);

Line 85: x_error_messages := EGO_COL_NAME_VALUE_PAIR_ARRAY();

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:

Line 471: x_error_messages := EGO_COL_NAME_VALUE_PAIR_ARRAY();

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:

Line 487: ,p_pk_column_name_value_pairs IN ego_col_name_value_pair_array

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);

Line 504: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

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:

Line 608: EGO_COL_NAME_VALUE_PAIR_ARRAY(

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

Line 617: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

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:

Line 715: p_pk_column_name_value_pairs IN ego_col_name_value_pair_array DEFAULT NULL

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:

Line 717: ,x_error_messages OUT NOCOPY ego_col_name_value_pair_array

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;

Line 747: x_error_messages := EGO_COL_NAME_VALUE_PAIR_ARRAY();

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;

Line 786: x_error_messages := EGO_COL_NAME_VALUE_PAIR_ARRAY();

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: