p_datetrack_update_mode
-----------------------
APIs that do updates on at least one datetracked table will contain this
parameter. It defines the type of datetracked operation to be performed. The
choices are
UPDATE Keep history of existing information
CORRECTION Correct existing information
UPDATE_OVERRIDE Replace all scheduled changes
UPDATE_CHANGE_INSERT Insert this change before next scheduled change.
Please note that the OVN for each datetrack change for the same primary key
will be different. It is,therefore, important that the correct datetrack record
is read for the appropriate datetrack mode of operation. i.e; at the correct
p_effective_date.
p_datetrack_delete_mode
-----------------------
APIs that do delete operations on a datetracked table will contain this
parameter. It allows you to define the type of datetrack deletes to make.
The choices are
ZAP Completely remove from database
DELETE Set end date of record to effective date
FUTURE_CHANGE Remove all scheduled changes
DELETE_NEXT_CHANGE Remove next change
-----------------------
APIs that do updates on at least one datetracked table will contain this
parameter. It defines the type of datetracked operation to be performed. The
choices are
UPDATE Keep history of existing information
CORRECTION Correct existing information
UPDATE_OVERRIDE Replace all scheduled changes
UPDATE_CHANGE_INSERT Insert this change before next scheduled change.
Please note that the OVN for each datetrack change for the same primary key
will be different. It is,therefore, important that the correct datetrack record
is read for the appropriate datetrack mode of operation. i.e; at the correct
p_effective_date.
p_datetrack_delete_mode
-----------------------
APIs that do delete operations on a datetracked table will contain this
parameter. It allows you to define the type of datetrack deletes to make.
The choices are
ZAP Completely remove from database
DELETE Set end date of record to effective date
FUTURE_CHANGE Remove all scheduled changes
DELETE_NEXT_CHANGE Remove next change
Is there a way to hide the correct button from certain users?
ReplyDeleteMeaning when prompted with the update/correct window, only the update option will be available.
Is this possible?
Have you looked at Forms Personalisations? That might be the approach to adopt.
ReplyDeleteHi Jad,
ReplyDeleteThe requirement u r asking for is not possible.
Cheersss...
Sandip