[Home] [Help]
TRIGGER: APPS.XTR_AI_INTERACCT_TRANSFERS_T
Source
Description
XTR_AI_INTERACCT_TRANSFERS_T
AFTER INSERT on XTR_INTERACCT_TRANSFERS
FOR EACH ROW
Type
AFTER EACH ROW
Event
INSERT
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
declare
l_sys_date DATE;
begin
--Insert row into XTR_CONFIRMATION_DETAILS table
l_sys_date :=trunc(sysdate);
XTR_MISC_P.DEAL_ACTIONS (:NEW.deal_type,
0,
:NEW.transaction_number,
'INTERACCOUNT_TRANSFER',
:NEW.COMPANY_CODE,
null,
l_sys_date,
:NEW.COMPANY_CODE,
:NEW.STATUS_CODE,
null,
:NEW.DEAL_SUBTYPE,
:NEW.CURRENCY,
null,
null,
:NEW.TRANSFER_AMOUNT,
'Y');
end;