TRIGGER: APPS.PAY_BALANCE_BATCH_LINES_BRIUD

Source

Description

pay_balance_batch_lines_briud
before insert or update or delete
on     pay_balance_batch_lines
for    each row

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE OR DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
if hr_general.g_data_migrator_mode <> 'Y' then
  if inserting or updating then
    pay_balance_upload.lock_batch_header(:new.batch_id);
  elsif deleting then
    pay_balance_upload.lock_batch_header(:old.batch_id);
  end if;
end if;
end pay_batch_lines_bruid;