618: cHeader_where);
619: BEGIN
620: SELECT eit.key_column_name
621: INTO c_header_common_key_name
622: FROM ece_interface_tables eit
623: WHERE eit.transaction_type = cTransaction_Type AND
624: eit.interface_table_name = cHeader_Interface AND
625: eit.map_id = iMap_ID;
626: EXCEPTION
639:
640: BEGIN
641: SELECT eit.key_column_name
642: INTO c_line_common_key_name
643: FROM ece_interface_tables eit
644: WHERE eit.transaction_type = cTransaction_Type AND
645: eit.interface_table_name = cLine_Interface AND
646: eit.map_id = iMap_ID;
647: EXCEPTION
660:
661: BEGIN
662: SELECT eit.key_column_name
663: INTO c_shipment_key_name
664: FROM ece_interface_tables eit
665: WHERE eit.transaction_type = cTransaction_Type AND
666: eit.interface_table_name = cShipment_Interface AND
667: eit.map_id = iMap_ID;
668: EXCEPTION