APPS.ECX_TP_MERGE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

    UPDATE ECX_TP_HEADERS
    SET    party_id 		= p_To_FK_id,
           last_updated_by	= hz_utility_pub.user_id,
           last_update_login	= hz_utility_pub.last_update_login
    WHERE  party_id             = p_From_FK_id
    AND    party_type           in ('C', 'E', 'CARRIER');

Line: 39

    UPDATE ECX_DOCLOGS
    SET    partyid              = to_char(p_To_FK_id)
    WHERE  partyid              = to_char(p_From_FK_id)
    AND    party_type           in ('C', 'E', 'CARRIER');

Line: 45

    UPDATE ECX_OUTBOUND_LOGS
    SET    party_id              = to_char(p_To_FK_id)
    WHERE  party_id              = to_char(p_From_FK_id)
    AND    party_type            in ('C', 'E', 'CARRIER');

Line: 81

    UPDATE ECX_TP_HEADERS
    SET    party_site_id 	= p_To_FK_id,
           last_updated_by	= hz_utility_pub.user_id,
           last_update_login	= hz_utility_pub.last_update_login
    WHERE  party_site_id        = p_From_FK_id
    AND    party_type           in ('C', 'E', 'CARRIER');

Line: 89

    UPDATE ECX_DOCLOGS
    SET    party_site_id   = to_char(p_To_FK_id)
    WHERE  party_site_id   = to_char(p_From_FK_id)
    AND    party_type      in ('C', 'E', 'CARRIER');

Line: 95

    UPDATE ECX_OUTBOUND_LOGS
    SET    party_site_id   = to_char(p_To_FK_id)
    WHERE  party_site_id   = to_char(p_From_FK_id)
    AND    party_type      in ('C', 'E', 'CARRIER');