237: l_return_status VARCHAR2(100);
238: l_error_code NUMBER;
239: l_msg_count NUMBER ;
240: l_msg_data VARCHAR2(100);
241: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
242: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
243: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
244:
245: l_temp_message VARCHAR2(2000);
238: l_error_code NUMBER;
239: l_msg_count NUMBER ;
240: l_msg_data VARCHAR2(100);
241: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
242: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
243: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
244:
245: l_temp_message VARCHAR2(2000);
246: l_retcode VARCHAR2(100);
239: l_msg_count NUMBER ;
240: l_msg_data VARCHAR2(100);
241: l_pk_item_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
242: l_pk_item_rev_pairs_src EGO_COL_NAME_VALUE_PAIR_ARRAY;
243: l_pk_item_rev_pairs_dst EGO_COL_NAME_VALUE_PAIR_ARRAY;
244:
245: l_temp_message VARCHAR2(2000);
246: l_retcode VARCHAR2(100);
247: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;