eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_IAC_TRANSFERS_PKG dependencies on XTR_DEAL_DATE_AMOUNTS

Line 439: p_From_Bank IN XTR_DEAL_DATE_AMOUNTS.LIMIT_PARTY%TYPE,

435: -----------------------------------------------------------------------------------------------------
436: -- Local procedure to insert Deal Date Rows
437: -----------------------------------------------------------------------------------------------------
438: procedure INS_DEAL_DATE_AMTS (ARec_IAC IN XTR_INTERACCT_TRANSFERS%rowtype,
439: p_From_Bank IN XTR_DEAL_DATE_AMOUNTS.LIMIT_PARTY%TYPE,
440: p_To_Bank IN XTR_DEAL_DATE_AMOUNTS.LIMIT_PARTY%TYPE,
441: p_tran_num IN NUMBER,
442: p_Validated IN BOOLEAN,
443: p_Settled IN BOOLEAN ) is

Line 440: p_To_Bank IN XTR_DEAL_DATE_AMOUNTS.LIMIT_PARTY%TYPE,

436: -- Local procedure to insert Deal Date Rows
437: -----------------------------------------------------------------------------------------------------
438: procedure INS_DEAL_DATE_AMTS (ARec_IAC IN XTR_INTERACCT_TRANSFERS%rowtype,
439: p_From_Bank IN XTR_DEAL_DATE_AMOUNTS.LIMIT_PARTY%TYPE,
440: p_To_Bank IN XTR_DEAL_DATE_AMOUNTS.LIMIT_PARTY%TYPE,
441: p_tran_num IN NUMBER,
442: p_Validated IN BOOLEAN,
443: p_Settled IN BOOLEAN ) is
444: -----------------------------------------------------------------------------------------------------

Line 449: l_settle_auth xtr_deal_date_amounts.SETTLEMENT_AUTHORISED_BY%TYPE;

445:
446: l_settle VARCHAR2(1);
447: l_settle_no NUMBER := null;
448: l_settle_no2 NUMBER := null;
449: l_settle_auth xtr_deal_date_amounts.SETTLEMENT_AUTHORISED_BY%TYPE;
450: l_settle_date DATE;
451: l_dual_auth_by xtr_deal_date_amounts.DUAL_AUTHORISATION_BY%TYPE;
452: l_dual_auth_on DATE;
453: l_trans_mts VARCHAR2(1);

Line 451: l_dual_auth_by xtr_deal_date_amounts.DUAL_AUTHORISATION_BY%TYPE;

447: l_settle_no NUMBER := null;
448: l_settle_no2 NUMBER := null;
449: l_settle_auth xtr_deal_date_amounts.SETTLEMENT_AUTHORISED_BY%TYPE;
450: l_settle_date DATE;
451: l_dual_auth_by xtr_deal_date_amounts.DUAL_AUTHORISATION_BY%TYPE;
452: l_dual_auth_on DATE;
453: l_trans_mts VARCHAR2(1);
454: l_audit_indic VARCHAR2(1);
455: l_dummy_num NUMBER;

Line 478: insert into XTR_DEAL_DATE_AMOUNTS_V

474:
475: -------------------------------------------------------------------------
476: -- Paying side (bank account from)
477: -------------------------------------------------------------------------
478: insert into XTR_DEAL_DATE_AMOUNTS_V
479: (deal_type, amount_type, date_type, product_type,
480: deal_number, transaction_number, transaction_date,
481: currency, amount, hce_amount, amount_date,
482: cashflow_amount, company_code, account_no, action_code,

Line 501: insert into XTR_DEAL_DATE_AMOUNTS_V

497:
498: -------------------------------------------------------------------------
499: -- Receiving Side (Bank account to)
500: -------------------------------------------------------------------------
501: insert into XTR_DEAL_DATE_AMOUNTS_V
502: (deal_type, amount_type, date_type, product_type,
503: deal_number, transaction_number, transaction_date,
504: currency, amount, hce_amount, amount_date,
505: cashflow_amount, company_code, account_no, action_code,

Line 676: l_bank_code_from xtr_deal_date_amounts.limit_party%TYPE;

672: select XTR_EXPOSURE_TRANS_S.NEXTVAL
673: from DUAL;
674:
675: l_dummy NUMBER;
676: l_bank_code_from xtr_deal_date_amounts.limit_party%TYPE;
677: l_bank_code_to xtr_deal_date_amounts.limit_party%TYPE;
678:
679: begin
680:

Line 677: l_bank_code_to xtr_deal_date_amounts.limit_party%TYPE;

673: from DUAL;
674:
675: l_dummy NUMBER;
676: l_bank_code_from xtr_deal_date_amounts.limit_party%TYPE;
677: l_bank_code_to xtr_deal_date_amounts.limit_party%TYPE;
678:
679: begin
680:
681: -------------------------