DBA Data[Home] [Help]

APPS.EGO_COM_ATTR_VALIDATION dependencies on EGO_USER_ATTR_DATA_TABLE

Line 12: ,p_attr_name_value_pairs IN EGO_USER_ATTR_DATA_TABLE

8: PROCEDURE Validate_Attributes (
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

Line 115: -- for ego_user_attr_row_table and ego_user_attr_data_table

111: l_curr_data_id := l_curr_data_element.ROW_IDENTIFIER;
112: l_curr_data_attr_name := l_curr_data_element.ATTR_NAME;
113:
114: -- not sure whether row_identifier should be same
115: -- for ego_user_attr_row_table and ego_user_attr_data_table
116: --IF(l_curr_row_id = l_curr_data_id) THEN
117: IF(l_curr_data_attr_name = 'Minimum_Price') THEN
118: l_minimum_price := l_curr_data_element.ATTR_VALUE_NUM;
119: l_minimum_price_exists := TRUE;

Line 486: ,p_attr_name_value_pairs IN ego_user_attr_data_table

482: FUNCTION Get_Attr_Value_From_db(p_attr_grp_id IN NUMBER
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;

Line 722: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;

718: )IS
719:
720:
721: l_object_id NUMBER;
722: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
723: l_bill_sequence_id NUMBER;
724: l_structure_type_id NUMBER;
725: l_component_sequence_id NUMBER;
726: l_index NUMBER;

Line 748: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();

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;
752: While (l_index IS NOT NULL)