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_CALCULATION_P dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 359: from XTR_ROLLOVER_TRANSACTIONS_V b

355: and a.status_code = 'CURRENT'
356: and a.deal_subtype = P_DEAL_SUBTYPE
357: and a.product_type = P_PRODUCT_TYPE
358: and a.maturity_date > (select max(b.maturity_date)
359: from XTR_ROLLOVER_TRANSACTIONS_V b
360: where b.deal_number = a.deal_no);
361: l_deal_no NUMBER;
362: c_deal DEAL%ROWTYPE;
363:

Line 367: from XTR_ROLLOVER_TRANSACTIONS_V

363:
364: cursor LAST_TRANS is
365: select start_date,maturity_date,expected_balance_out,balance_out,
366: accum_interest,interest_rate,pi_amount_due
367: from XTR_ROLLOVER_TRANSACTIONS_V
368: where deal_number = l_deal_no
369: -- and maturity_date >= l_start_date
370: order by start_date desc,maturity_date desc,transaction_number desc;
371:

Line 383: from XTR_ROLLOVER_TRANSACTIONS_V

379: l_cparty_account_no varchar2(20);
380:
381: cursor T_NOS is
382: select nvl(max(TRANSACTION_NUMBER), 0) + 1
383: from XTR_ROLLOVER_TRANSACTIONS_V
384: where DEAL_NUMBER = l_deal_no;
385:
386: TRANS_NO number;
387:

Line 389: v_principal_action xtr_rollover_transactions.principal_action%type;

385:
386: TRANS_NO number;
387:
388: --bug 3141263
389: v_principal_action xtr_rollover_transactions.principal_action%type;
390: v_ACCUM_INTEREST xtr_rollover_transactions.accum_interest%type;
391: v_ACCUM_INTEREST_HCE xtr_rollover_transactions.accum_interest_hce%type;
392: v_ADJUSTED_BALANCE xtr_rollover_transactions.adjusted_balance%type;
393: v_PRINCIPAL_ADJUST xtr_rollover_transactions.principal_adjust%type;

Line 390: v_ACCUM_INTEREST xtr_rollover_transactions.accum_interest%type;

386: TRANS_NO number;
387:
388: --bug 3141263
389: v_principal_action xtr_rollover_transactions.principal_action%type;
390: v_ACCUM_INTEREST xtr_rollover_transactions.accum_interest%type;
391: v_ACCUM_INTEREST_HCE xtr_rollover_transactions.accum_interest_hce%type;
392: v_ADJUSTED_BALANCE xtr_rollover_transactions.adjusted_balance%type;
393: v_PRINCIPAL_ADJUST xtr_rollover_transactions.principal_adjust%type;
394: v_PRINCIPAL_ADJUST_HCE xtr_rollover_transactions.principal_adjust_hce%type;

Line 391: v_ACCUM_INTEREST_HCE xtr_rollover_transactions.accum_interest_hce%type;

387:
388: --bug 3141263
389: v_principal_action xtr_rollover_transactions.principal_action%type;
390: v_ACCUM_INTEREST xtr_rollover_transactions.accum_interest%type;
391: v_ACCUM_INTEREST_HCE xtr_rollover_transactions.accum_interest_hce%type;
392: v_ADJUSTED_BALANCE xtr_rollover_transactions.adjusted_balance%type;
393: v_PRINCIPAL_ADJUST xtr_rollover_transactions.principal_adjust%type;
394: v_PRINCIPAL_ADJUST_HCE xtr_rollover_transactions.principal_adjust_hce%type;
395: v_PRINCIPAL_AMOUNT_TYPE xtr_rollover_transactions.principal_amount_type%type;

Line 392: v_ADJUSTED_BALANCE xtr_rollover_transactions.adjusted_balance%type;

388: --bug 3141263
389: v_principal_action xtr_rollover_transactions.principal_action%type;
390: v_ACCUM_INTEREST xtr_rollover_transactions.accum_interest%type;
391: v_ACCUM_INTEREST_HCE xtr_rollover_transactions.accum_interest_hce%type;
392: v_ADJUSTED_BALANCE xtr_rollover_transactions.adjusted_balance%type;
393: v_PRINCIPAL_ADJUST xtr_rollover_transactions.principal_adjust%type;
394: v_PRINCIPAL_ADJUST_HCE xtr_rollover_transactions.principal_adjust_hce%type;
395: v_PRINCIPAL_AMOUNT_TYPE xtr_rollover_transactions.principal_amount_type%type;
396: v_accum_int_amount_type xtr_rollover_transactions.accum_int_amount_type%type;

Line 393: v_PRINCIPAL_ADJUST xtr_rollover_transactions.principal_adjust%type;

389: v_principal_action xtr_rollover_transactions.principal_action%type;
390: v_ACCUM_INTEREST xtr_rollover_transactions.accum_interest%type;
391: v_ACCUM_INTEREST_HCE xtr_rollover_transactions.accum_interest_hce%type;
392: v_ADJUSTED_BALANCE xtr_rollover_transactions.adjusted_balance%type;
393: v_PRINCIPAL_ADJUST xtr_rollover_transactions.principal_adjust%type;
394: v_PRINCIPAL_ADJUST_HCE xtr_rollover_transactions.principal_adjust_hce%type;
395: v_PRINCIPAL_AMOUNT_TYPE xtr_rollover_transactions.principal_amount_type%type;
396: v_accum_int_amount_type xtr_rollover_transactions.accum_int_amount_type%type;
397: v_no_of_days NUMBER;

Line 394: v_PRINCIPAL_ADJUST_HCE xtr_rollover_transactions.principal_adjust_hce%type;

390: v_ACCUM_INTEREST xtr_rollover_transactions.accum_interest%type;
391: v_ACCUM_INTEREST_HCE xtr_rollover_transactions.accum_interest_hce%type;
392: v_ADJUSTED_BALANCE xtr_rollover_transactions.adjusted_balance%type;
393: v_PRINCIPAL_ADJUST xtr_rollover_transactions.principal_adjust%type;
394: v_PRINCIPAL_ADJUST_HCE xtr_rollover_transactions.principal_adjust_hce%type;
395: v_PRINCIPAL_AMOUNT_TYPE xtr_rollover_transactions.principal_amount_type%type;
396: v_accum_int_amount_type xtr_rollover_transactions.accum_int_amount_type%type;
397: v_no_of_days NUMBER;
398:

Line 395: v_PRINCIPAL_AMOUNT_TYPE xtr_rollover_transactions.principal_amount_type%type;

391: v_ACCUM_INTEREST_HCE xtr_rollover_transactions.accum_interest_hce%type;
392: v_ADJUSTED_BALANCE xtr_rollover_transactions.adjusted_balance%type;
393: v_PRINCIPAL_ADJUST xtr_rollover_transactions.principal_adjust%type;
394: v_PRINCIPAL_ADJUST_HCE xtr_rollover_transactions.principal_adjust_hce%type;
395: v_PRINCIPAL_AMOUNT_TYPE xtr_rollover_transactions.principal_amount_type%type;
396: v_accum_int_amount_type xtr_rollover_transactions.accum_int_amount_type%type;
397: v_no_of_days NUMBER;
398:
399: BEGIN

Line 396: v_accum_int_amount_type xtr_rollover_transactions.accum_int_amount_type%type;

392: v_ADJUSTED_BALANCE xtr_rollover_transactions.adjusted_balance%type;
393: v_PRINCIPAL_ADJUST xtr_rollover_transactions.principal_adjust%type;
394: v_PRINCIPAL_ADJUST_HCE xtr_rollover_transactions.principal_adjust_hce%type;
395: v_PRINCIPAL_AMOUNT_TYPE xtr_rollover_transactions.principal_amount_type%type;
396: v_accum_int_amount_type xtr_rollover_transactions.accum_int_amount_type%type;
397: v_no_of_days NUMBER;
398:
399: BEGIN
400:

Line 561: insert into XTR_ROLLOVER_TRANSACTIONS

557: v_accum_int_amount_type,
558: v_principal_action);
559:
560: --
561: insert into XTR_ROLLOVER_TRANSACTIONS
562: (DEAL_NUMBER,
563: TRANSACTION_NUMBER,
564: DEAL_TYPE,
565: START_DATE,