Page Comparison

function_name(apply_old_data table%rowtype, has_found_apply_row boolean, 
primary_key_data table%rowtype, new_data table%rowtype) return number;

The following applies:

apply_old_data : the values at the target, queried by using key columns in the where clause. The boolean flag indicates whether any such record was found.

primary_key_data: old values at the source; mostly used to see the key, but it actually contains all supplementally logged values, too. Thus it will always (excl. LOBs, LONGs) include the modified column, too.

new_data: new (modified) values at the source.