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

Line 1351: from XTR_ROLLOVER_TRANSACTIONS a,

1347: a.START_DATE,
1348: a.RATE_FIXING_DATE,
1349: b.RATE_BASIS,
1350: nvl(b.MARGIN,0)
1351: from XTR_ROLLOVER_TRANSACTIONS a,
1352: XTR_DEALS b,
1353: XTR_PARTIES_V c
1354: where a.deal_type = NVL(p_deal_type,a.deal_type)
1355: and a.deal_type in ('TMM','IRS')

Line 1377: from xtr_rollover_transactions

1373: -- it's the latest transactions and we want to update the subsequent row.
1374: -- If something found, then we only want to update one row.
1375: cursor C_ONE_ROW is
1376: select 'Y'
1377: from xtr_rollover_transactions
1378: where deal_number = l_deal_no
1379: and transaction_number = l_tran_no
1380: and rate_fixing_date <
1381: (select max(rate_fixing_date)

Line 1382: from xtr_rollover_transactions

1378: where deal_number = l_deal_no
1379: and transaction_number = l_tran_no
1380: and rate_fixing_date <
1381: (select max(rate_fixing_date)
1382: from xtr_rollover_transactions
1383: where deal_number = l_deal_no
1384: and rate_fixing_date between fnd_date.canonical_to_date(p_rateset_from)
1385: and fnd_date.canonical_to_date(p_rateset_to));
1386:

Line 1544: xtr_rollover_transactions b

1540: /******** Ilavenil modified for witholding tax *********/
1541: union
1542: select nvl(min(a.amount_date),p_start_date) -- Ilavenil modified for witholding tax project
1543: from xtr_deal_date_amounts a,
1544: xtr_rollover_transactions b
1545: where b.company_code = p_company
1546: and b.deal_number = p_deal_no
1547: and (b.tax_settled_reference is not null)
1548: and a.company_code = p_company

Line 1567: xtr_rollover_transactions b

1563: union
1564: /********* Ilavenil modified for witholding tax *********/
1565: select nvl(max(b.maturity_date), p_start_date)
1566: from xtr_journals a,
1567: xtr_rollover_transactions b
1568: where b.company_code =p_company
1569: and b.deal_number = p_deal_no
1570: and b.tax_settled_reference is not null
1571: and a.company_code = p_company

Line 1588: from xtr_rollover_transactions_v

1584: l_pre_int VARCHAR2(1) := NULL;
1585:
1586: Cursor last_int_set is
1587: select max(maturity_date)
1588: from xtr_rollover_transactions_v
1589: where deal_number = p_deal_no
1590: and org_trans_no in (select min(transaction_number)
1591: from xtr_deal_date_amounts
1592: where deal_number = p_deal_no

Line 1607: xtr_rollover_transactions b

1603: and amount_type in ('INTSET','TAX')
1604: union
1605: select nvl(max(b.maturity_date), p_start_date)
1606: from xtr_journals a,
1607: xtr_rollover_transactions b
1608: where b.company_code = p_company
1609: and b.deal_number = p_deal_no
1610: and b.tax_settled_reference is not null
1611: and a.company_code = p_company

Line 1618: from xtr_rollover_transactions

1614: order by 1 desc;
1615:
1616: Cursor last_int_journal is
1617: select nvl(max(maturity_date), p_start_date)
1618: from xtr_rollover_transactions
1619: where deal_number = p_deal_no
1620: and transaction_number in (select transaction_number
1621: from xtr_deal_date_amounts
1622: where deal_number = p_deal_no

Line 1818: from XTR_ROLLOVER_TRANSACTIONS r,

1814: r.balance_out,
1815: d.settle_account_no,
1816: d.company_code, d.cparty_code, d.year_calc_type
1817: /**********/
1818: from XTR_ROLLOVER_TRANSACTIONS r,
1819: XTR_DEALS d
1820: where r.deal_number = d.deal_no
1821: and r.deal_type = p_deal_type
1822: and r.deal_type = 'TMM'

Line 1830: from XTR_ROLLOVER_TRANSACTIONS_V

1826: pmt TMM_ROLL%ROWTYPE;
1827:
1828: cursor LAST_TMM is
1829: select rowid
1830: from XTR_ROLLOVER_TRANSACTIONS_V
1831: where deal_number = p_deal_no
1832: and status_code = 'CURRENT'
1833: order by maturity_date desc, start_date desc, transaction_number desc;
1834:

Line 1842: XTR_ROLLOVER_TRANSACTIONS r

1838: cursor IRS_ROLL is
1839: select r.currency, r.balance_out, r.no_of_days, d.year_basis,
1840: d.deal_subtype, d.rounding_type
1841: from XTR_DEALS d,
1842: XTR_ROLLOVER_TRANSACTIONS r
1843: where d.deal_type = p_deal_type
1844: and d.deal_type = 'IRS'
1845: and d.deal_no = r.deal_number
1846: and r.deal_number = p_deal_no

Line 1878: v_RT Xtr_Rollover_Transactions_V%Rowtype;

1874: l_int_settle_hce NUMBER;
1875: l_prin_adj NUMBER;
1876: l_rounding_type VARCHAR2(1); -- Add Interest Override
1877:
1878: v_RT Xtr_Rollover_Transactions_V%Rowtype;
1879: v_first_time Char(1) := 'Y';
1880: v_last_trans Varchar2(1) ;
1881: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1882: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;

Line 1897: Update XTR_ROLLOVER_TRANSACTIONS

1893: set confirmation_validated_by = null,
1894: confirmation_validated_on = to_date(null)
1895: where deal_no = p_deal_no;
1896:
1897: Update XTR_ROLLOVER_TRANSACTIONS
1898: set interest_rate = p_new_rate
1899: where deal_number = p_deal_no
1900: and transaction_number = p_trans_no;
1901:

Line 2013: update XTR_ROLLOVER_TRANSACTIONS

2009: v_last_trans,
2010: v_rt
2011: );
2012:
2013: update XTR_ROLLOVER_TRANSACTIONS
2014: set accum_interest_bf = pmt.accum_interest_bf,
2015: accum_interest_bf_hce = l_accum_int_bf_hce,
2016: accum_interest_hce = l_accum_int_hce,
2017: accum_interest = pmt.accum_interest,

Line 2074: Update XTR_ROLLOVER_TRANSACTIONS

2070: l_int_hce := round(l_int_settled /l_hce_rate, l_round);
2071: End if;
2072: Close IRS_ROLL;
2073:
2074: Update XTR_ROLLOVER_TRANSACTIONS
2075: set interest_rate = l_int_rate,
2076: interest = l_interest,
2077: interest_settled = l_int_settled,
2078: interest_hce = l_int_hce,

Line 2122: from XTR_ROLLOVER_TRANSACTIONS_V r,

2118: r.balance_out,
2119: d.settle_account_no,
2120: d.company_code, d.cparty_code, d.year_calc_type
2121: /**********/
2122: from XTR_ROLLOVER_TRANSACTIONS_V r,
2123: XTR_DEALS d
2124: where r.deal_number = d.deal_no
2125: and r.deal_type = p_deal_type
2126: and r.deal_type = 'TMM'

Line 2135: from XTR_ROLLOVER_TRANSACTIONS_V

2131: pmt TMM_ROLL%ROWTYPE;
2132:
2133: cursor LAST_TMM is
2134: select rowid
2135: from XTR_ROLLOVER_TRANSACTIONS_V
2136: where deal_number = p_deal_no
2137: and status_code = 'CURRENT'
2138: order by maturity_date desc, start_date desc, transaction_number desc;
2139:

Line 2147: XTR_ROLLOVER_TRANSACTIONS r

2143: cursor IRS_ROLL is
2144: select r.rowid, r.transaction_number, d.currency, r.balance_out,
2145: r.no_of_days, d.year_basis, d.deal_subtype, d.rounding_type
2146: from XTR_DEALS d,
2147: XTR_ROLLOVER_TRANSACTIONS r
2148: where d.deal_type = p_deal_type
2149: and d.deal_type = 'IRS'
2150: and d.deal_no = r.deal_number
2151: and d.deal_no = p_deal_no

Line 2178: v_RT Xtr_Rollover_Transactions_V%Rowtype;

2174: l_hce_rate NUMBER;
2175: l_int_settle_hce NUMBER;
2176: l_prin_adj NUMBER;
2177:
2178: v_RT Xtr_Rollover_Transactions_V%Rowtype;
2179: v_first_time Char(1) := 'Y';
2180: v_last_trans Varchar2(1) ;
2181: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2182: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;

Line 2305: update XTR_ROLLOVER_TRANSACTIONS

2301: v_last_trans,
2302: v_rt
2303: );
2304:
2305: update XTR_ROLLOVER_TRANSACTIONS
2306: set interest_rate = p_new_rate,
2307: accum_interest_bf = pmt.accum_interest_bf,
2308: accum_interest_bf_hce = l_accum_int_bf_hce,
2309: accum_interest_hce = l_accum_int_hce,

Line 2369: Update XTR_ROLLOVER_TRANSACTIONS

2365: --End of Change ----------------------------------------
2366: l_int_settled := l_interest;
2367: l_int_hce := round(l_int_settled /l_hce_rate, l_round);
2368:
2369: Update XTR_ROLLOVER_TRANSACTIONS
2370: set interest_rate = p_new_rate,
2371: interest = l_interest,
2372: interest_settled = l_int_settled,
2373: interest_hce = l_int_hce,

Line 2529: p_RT IN OUT NOCOPY XTR_ROLLOVER_TRANSACTIONS_V%ROWTYPE) IS

2525: p_income_ctype IN VARCHAR2,
2526: p_income_method IN VARCHAR2,
2527: p_settle_acct IN VARCHAR2,
2528: p_last_tran IN VARCHAR2,
2529: p_RT IN OUT NOCOPY XTR_ROLLOVER_TRANSACTIONS_V%ROWTYPE) IS
2530:
2531: l_hce_rate NUMBER;
2532: l_hce_rounding NUMBER;
2533: l_orig_prncpl_amt NUMBER;

Line 2553: from XTR_ROLLOVER_TRANSACTIONS

2549: cursor RT_BAL_OUT IS
2550: select START_DATE,
2551: MATURITY_DATE,
2552: BALANCE_OUT
2553: from XTR_ROLLOVER_TRANSACTIONS
2554: where deal_number = p_RT.deal_number
2555: order by start_date, maturity_date, transaction_number;
2556:
2557: --------------------------------------------

Line 2935: from xtr_rollover_transactions a

2931: IS
2932: -- The following 2 cursors are used if given transaction number
2933: cursor t_rollover_deal_exposures is
2934: select a.tax_settled_reference
2935: from xtr_rollover_transactions a
2936: where a.deal_number = p_deal_no and
2937: a.tax_settled_reference is not null and
2938: a.transaction_number = p_trans_no;
2939:

Line 2942: from xtr_rollover_transactions a

2938: a.transaction_number = p_trans_no;
2939:
2940: cursor t_rollover_deal_exposures_p is
2941: select a.principal_tax_settled_ref
2942: from xtr_rollover_transactions a
2943: where a.deal_number= p_deal_no and
2944: a.principal_tax_settled_ref is not null and
2945: a.transaction_number = p_trans_no;
2946:

Line 2950: from xtr_rollover_transactions a

2946:
2947: -- The following 2 cursor are used if not give a trasaction number
2948: cursor rollover_deal_exposures is
2949: select a.tax_settled_reference
2950: from xtr_rollover_transactions a
2951: where a.deal_number = p_deal_no and
2952: a.tax_settled_reference is not null;
2953:
2954: cursor rollover_deal_exposures_p is

Line 2956: from xtr_rollover_transactions a

2952: a.tax_settled_reference is not null;
2953:
2954: cursor rollover_deal_exposures_p is
2955: select a.principal_tax_settled_ref
2956: from xtr_rollover_transactions a
2957: where a.deal_number= p_deal_no and
2958: a.principal_tax_settled_ref is not null;
2959:
2960: cursor xtr_deals is

Line 3025: update XTR_ROLLOVER_TRANSACTIONS

3021: where DEAL_TYPE = 'EXP'
3022: and deal_number = 0
3023: and TRANSACTION_NUMBER = p_tax_settle_no;
3024:
3025: update XTR_ROLLOVER_TRANSACTIONS
3026: set tax_settled_reference = null
3027: where tax_settled_reference = p_tax_settle_no;
3028:
3029: update XTR_ROLLOVER_TRANSACTIONS

Line 3029: update XTR_ROLLOVER_TRANSACTIONS

3025: update XTR_ROLLOVER_TRANSACTIONS
3026: set tax_settled_reference = null
3027: where tax_settled_reference = p_tax_settle_no;
3028:
3029: update XTR_ROLLOVER_TRANSACTIONS
3030: set principal_tax_settled_ref = null
3031: where principal_tax_settled_ref = p_tax_settle_no;
3032:
3033: update XTR_DEALS