[Home] [Help]
4024: l_data_table_index NUMBER := 1;
4025: l_failed_row_count NUMBER;
4026: --l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
4027: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
4028: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
4029: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
4030: l_current_row_element EGO_USER_ATTR_ROW_OBJ;
4031: l_current_data_element EGO_USER_ATTR_DATA_OBJ;
4032: l_ego_attr_group_request_obj EGO_ATTR_GROUP_REQUEST_OBJ;
4030: l_current_row_element EGO_USER_ATTR_ROW_OBJ;
4031: l_current_data_element EGO_USER_ATTR_DATA_OBJ;
4032: l_ego_attr_group_request_obj EGO_ATTR_GROUP_REQUEST_OBJ;
4033: l_ego_col_name_value_pair_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
4034: --l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
4035: --l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
4036:
4037: --Consolidated data and row tables
4038: --l_cons_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
4034: --l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
4035: --l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
4036:
4037: --Consolidated data and row tables
4038: --l_cons_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
4039: --l_cons_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
4040:
4041: Cursor get_dest_comps(p_src_comp_seq_id NUMBER, p_str_type_id NUMBER)
4042: IS
4076: --Table to maintain the attr grp data
4077: --l_cons_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
4078:
4079: --Table to maintain attributes data
4080: --l_cons_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
4081:
4082: --For each attr grp, get data from source, and copy in the destn comp
4083:
4084: /*FOR attr_grp IN Get_Attribute_Groups(p_component_seq_id => p_src_comp_seq_id, p_bill_seq_id => l_src_bill_seq_id)