DBA Data[Home] [Help]

APPS.XTR_AID_DEAL_DATE_AMOUNTS_T dependencies on XTR_LIMITS_P

Line 84: xtr_limits_p.MIRROR_DDA_LIMIT_ROW_PROC

80: or :new.deal_type='CA' or :new.deal_type = 'IG' --RV 2229236/2197301
81: or :new.deal_type = 'STOCK' -- Bug 4401195
82: or (:new.deal_type='ONC' and nvl(L_MATURITY_DATE,L_SYS_DATE)>=L_SYS_DATE)) then
83: -- Now update mirror copy of DDA records where limit_type not null.
84: xtr_limits_p.MIRROR_DDA_LIMIT_ROW_PROC
85: (v_action,:new.LIMIT_CODE,:new.deal_number,
86: :new.transaction_number,:new.PRODUCT_TYPE,
87: :new.COMPANY_CODE,nvl(:new.LIMIT_PARTY,:new.CPARTY_CODE),
88: :new.LIMIT_CODE,:new.AMOUNT_DATE,:new.AMOUNT,

Line 103: xtr_limits_p.MIRROR_DDA_LIMIT_ROW_PROC

99: if :OLD.LIMIT_CODE is NOT NULL then
100: v_action := 'DELETE';
101:
102: -- Now update mirror copy of DDA records where limit_type not null.
103: xtr_limits_p.MIRROR_DDA_LIMIT_ROW_PROC
104: (v_action,:old.LIMIT_CODE,:old.deal_number,
105: :old.transaction_number,:old.PRODUCT_TYPE,
106: :old.COMPANY_CODE,nvl(:old.LIMIT_PARTY,:old.CPARTY_CODE),
107: :old.LIMIT_CODE,:old.AMOUNT_DATE,:old.AMOUNT,