[Home] [Help]
3710: l_data_table_index NUMBER := 1;
3711: l_failed_row_count NUMBER;
3712: --l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3713: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
3714: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3715: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
3716: l_current_row_element EGO_USER_ATTR_ROW_OBJ;
3717: l_current_data_element EGO_USER_ATTR_DATA_OBJ;
3718: l_ego_attr_group_request_obj EGO_ATTR_GROUP_REQUEST_OBJ;
3716: l_current_row_element EGO_USER_ATTR_ROW_OBJ;
3717: l_current_data_element EGO_USER_ATTR_DATA_OBJ;
3718: l_ego_attr_group_request_obj EGO_ATTR_GROUP_REQUEST_OBJ;
3719: l_ego_col_name_value_pair_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
3720: --l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3721: --l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
3722:
3723: --Consolidated data and row tables
3724: --l_cons_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3720: --l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3721: --l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
3722:
3723: --Consolidated data and row tables
3724: --l_cons_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3725: --l_cons_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
3726:
3727: Cursor get_dest_comps(p_src_comp_seq_id NUMBER, p_str_type_id NUMBER)
3728: IS
3762: --Table to maintain the attr grp data
3763: --l_cons_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
3764:
3765: --Table to maintain attributes data
3766: --l_cons_attributes_data_table := EGO_USER_ATTR_DATA_TABLE();
3767:
3768: --For each attr grp, get data from source, and copy in the destn comp
3769:
3770: /*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)