[Home] [Help]
4023: l_row_table_index NUMBER := 1;
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;
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;
4039: --l_cons_attributes_row_table EGO_USER_ATTR_ROW_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
4043: SELECT bcb.component_sequence_id, bcb.bill_sequence_id
4073:
4074: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' , to_char(p_src_comp_seq_id))
4075: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'BILL_SEQUENCE_ID' , to_char(l_src_bill_seq_id)) );
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: