APPS.DPP_VENDORMERGE_GRP SQL Statements

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

Line: 96

		UPDATE DPP_TRANSACTION_HEADERS_ALL

		SET vendor_id = p_vendor_id,

				vendor_site_id = p_vendor_site_id,

				last_update_date = hz_utility_pub.last_update_date,

				last_updated_by = hz_utility_pub.user_id,

				last_update_login = hz_utility_pub.last_update_login,

				program_application_id = hz_utility_pub.program_application_id,

				program_id = hz_utility_pub.program_id,

				program_update_date = sysdate

		WHERE   vendor_id = p_dup_vendor_id

			AND vendor_site_id = p_dup_vendor_site_id;

Line: 134

		FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

Line: 156

			UPDATE DPP_TRANSACTION_HEADERS_LOG

			SET vendor_id = p_vendor_id,

					vendor_site_id = p_vendor_site_id,

					last_update_date = hz_utility_pub.last_update_date,

					last_updated_by = hz_utility_pub.user_id,

					last_update_login = hz_utility_pub.last_update_login

			WHERE   vendor_id = p_dup_vendor_id

					AND vendor_site_id = p_dup_vendor_site_id;

Line: 188

			FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);

Line: 210

			UPDATE DPP_TXN_HEADERS_INT_ALL

			SET     vendor_id = p_vendor_id,

					vendor_site_id = p_vendor_site_id,

					last_update_date = hz_utility_pub.last_update_date,

					last_updated_by = hz_utility_pub.user_id,

					last_update_login = hz_utility_pub.last_update_login,

					program_application_id = hz_utility_pub.program_application_id,

					program_id = hz_utility_pub.program_id,

					program_update_date = sysdate

			WHERE   vendor_id = p_dup_vendor_id

					AND vendor_site_id = p_dup_vendor_site_id;

Line: 249

			FND_MESSAGE.SET_TOKEN('ROWS_UPDATED',l_row_count);