TRIGGER: APPS.PAY_ORG_PAYMENT_METHODS_BRUID

Source

Description

pay_org_payment_methods_bruid
before insert or update on pay_org_payment_methods_f
for each row

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare
trigger_fail exception;
status boolean;
payments_defined_balance number(16);
begin
if hr_general.g_data_migrator_mode <> 'Y' then
  if inserting or updating then
    if (:new.external_account_id is not null) then
       status := hr_payments.check_account(to_char(:new.external_account_id),
                                                to_char(:new.payment_type_id));
    end if;
    status := hr_payments.check_currency(to_char(:new.payment_type_id),
                                                     :new.currency_code);
  end if;
--
end if;
end pay_org_payment_methods_bruid;