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_DEAL_DATE_AMOUNTS

Line 192: from XTR_DEAL_DATE_AMOUNTS_V

188: l_dealer IN VARCHAR2,
189: l_exists IN OUT NOCOPY VARCHAR2) as
190: cursor DEAL_EXISTS_YN is
191: select 'Y'
192: from XTR_DEAL_DATE_AMOUNTS_V
193: where AMOUNT_DATE = l_date
194: and COMPANY_CODE like nvl(l_company,'%')
195: and DEAL_TYPE like nvl(l_d_type,'%')
196: and DEAL_SUBTYPE like nvl(l_d_subty,'%')

Line 1234: /* EXP open API which inserts into Xtr_Exposure_Transactions and Xtr_Deal_Date_Amounts **/

1230: v_exp_rec.TAX_BROKERAGE_TYPE := 'Y';
1231: v_exp_rec.COMMENTS := v_comments;
1232: v_exp_rec.CPARTY_ACCOUNT_NO := p_one_step_rec.p_cparty_account_no;
1233:
1234: /***** EXP open API which inserts into Xtr_Exposure_Transactions and Xtr_Deal_Date_Amounts ******/
1235:
1236: XTR_EXP_TRANSFERS_PKG.TRANSFER_EXP_DEALS(v_exp_rec,
1237: p_one_step_rec.p_source,
1238: v_user_error,

Line 1535: from xtr_deal_date_amounts

1531:
1532:
1533: cursor check_settlement_done is
1534: select nvl(min(amount_date),p_start_date) -- Ilavenil modified for witholding tax project
1535: from xtr_deal_date_amounts
1536: where company_code = p_company
1537: and deal_number = p_deal_no
1538: and settle = 'Y'
1539: and amount_date > p_start_date

Line 1543: from xtr_deal_date_amounts a,

1539: and amount_date > p_start_date
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)

Line 1591: from xtr_deal_date_amounts

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
1593: and amount_type = 'INTSET'
1594: and nvl(settle, 'N') = 'Y')
1595: and maturity_date > p_start_date;

Line 1621: from xtr_deal_date_amounts

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
1623: and amount_type = 'INTSET'
1624: and batch_id is NOT NULL);
1625:

Line 1902: update XTR_DEAL_DATE_AMOUNTS

1898: set interest_rate = p_new_rate
1899: where deal_number = p_deal_no
1900: and transaction_number = p_trans_no;
1901:
1902: update XTR_DEAL_DATE_AMOUNTS
1903: set transaction_rate = p_new_rate
1904: where deal_number = p_deal_no
1905: and transaction_number = p_trans_no;
1906:

Line 2027: update XTR_DEAL_DATE_AMOUNTS

2023: TAX_AMOUNT = v_RT.TAX_AMOUNT, -- Ilavenil Bug 234413
2024: TAX_AMOUNT_HCE = v_RT.TAX_AMOUNT_HCE -- Ilavenil Bug 234413
2025: where rowid = pmt.ROWID;
2026:
2027: update XTR_DEAL_DATE_AMOUNTS
2028: set amount = pmt.interest,
2029: hce_amount = l_int_hce
2030: where deal_number = p_deal_no
2031: and transaction_number = pmt.transaction_number

Line 2035: update XTR_DEAL_DATE_AMOUNTS

2031: and transaction_number = pmt.transaction_number
2032: and amount_type = 'INTERST';
2033:
2034: if pmt.settle_term_interest = 'Y' then
2035: update XTR_DEAL_DATE_AMOUNTS
2036: set amount = pmt.interest_settled,
2037: hce_amount = l_int_settle_hce,
2038: cashflow_amount = decode(pmt.deal_subtype, 'FUND', (-1), 1) *
2039: pmt.interest_settled

Line 2083: Update XTR_DEAL_DATE_AMOUNTS

2079: original_amount = l_interest --Add Interest Override
2080: where deal_number = p_deal_no
2081: and transaction_number = p_trans_no;
2082:
2083: Update XTR_DEAL_DATE_AMOUNTS
2084: set transaction_rate = l_int_rate
2085: where deal_number = p_deal_no
2086: and transaction_number = p_trans_no;
2087:

Line 2088: Update XTR_DEAL_DATE_AMOUNTS

2084: set transaction_rate = l_int_rate
2085: where deal_number = p_deal_no
2086: and transaction_number = p_trans_no;
2087:
2088: Update XTR_DEAL_DATE_AMOUNTS
2089: set amount = l_interest,
2090: hce_amount = l_int_hce,
2091: cashflow_amount = decode(l_deal_subtype, 'FUND',
2092: l_interest * (-1), l_interest)

Line 2320: update XTR_DEAL_DATE_AMOUNTS

2316: TAX_AMOUNT = v_RT.TAX_AMOUNT, -- Ilavenil Bug 234413
2317: TAX_AMOUNT_HCE = v_RT.TAX_AMOUNT_HCE -- Ilavenil Bug 234413
2318: where rowid = pmt.ROWID;
2319:
2320: update XTR_DEAL_DATE_AMOUNTS
2321: set transaction_rate = p_new_rate
2322: where deal_number = p_deal_no
2323: and transaction_number = pmt.transaction_number;
2324:

Line 2325: update XTR_DEAL_DATE_AMOUNTS

2321: set transaction_rate = p_new_rate
2322: where deal_number = p_deal_no
2323: and transaction_number = pmt.transaction_number;
2324:
2325: update XTR_DEAL_DATE_AMOUNTS
2326: set amount = pmt.interest,
2327: hce_amount = l_int_hce
2328: where deal_number = p_deal_no
2329: and transaction_number = pmt.transaction_number

Line 2333: update XTR_DEAL_DATE_AMOUNTS

2329: and transaction_number = pmt.transaction_number
2330: and amount_type = 'INTERST';
2331:
2332: if pmt.settle_term_interest = 'Y' then
2333: update XTR_DEAL_DATE_AMOUNTS
2334: set amount = pmt.interest_settled,
2335: hce_amount = l_int_settle_hce,
2336: cashflow_amount = decode(pmt.deal_subtype, 'FUND', (-1), 1) *
2337: pmt.interest_settled

Line 2377: Update XTR_DEAL_DATE_AMOUNTS

2373: interest_hce = l_int_hce,
2374: original_amount = l_interest --Add Interest Override
2375: where rowid = pms.rowid;
2376:
2377: Update XTR_DEAL_DATE_AMOUNTS
2378: set transaction_rate = p_new_rate
2379: where deal_number = p_deal_no
2380: and transaction_number = pms.transaction_number;
2381:

Line 2382: Update XTR_DEAL_DATE_AMOUNTS

2378: set transaction_rate = p_new_rate
2379: where deal_number = p_deal_no
2380: and transaction_number = pms.transaction_number;
2381:
2382: Update XTR_DEAL_DATE_AMOUNTS
2383: set amount = l_interest,
2384: hce_amount = l_int_hce,
2385: cashflow_amount = decode(pms.deal_subtype, 'FUND',
2386: l_interest * (-1), l_interest)

Line 2798: delete XTR_DEAL_DATE_AMOUNTS

2794: ---------------------------------------
2795: delete XTR_EXPOSURE_TRANSACTIONS
2796: where TRANSACTION_NUMBER = p_prncpl_ref;
2797:
2798: delete XTR_DEAL_DATE_AMOUNTS
2799: where DEAL_TYPE = 'EXP'
2800: and TRANSACTION_NUMBER = p_prncpl_ref;
2801:
2802: end if;

Line 2817: delete XTR_DEAL_DATE_AMOUNTS

2813:
2814: delete XTR_EXPOSURE_TRANSACTIONS
2815: where TRANSACTION_NUMBER = p_prncpl_ref;
2816:
2817: delete XTR_DEAL_DATE_AMOUNTS
2818: where DEAL_TYPE = 'EXP'
2819: and TRANSACTION_NUMBER = p_prncpl_ref;
2820:
2821: p_one_step.p_exp_number := null;

Line 2831: update XTR_DEAL_DATE_AMOUNTS

2827: AMOUNT_HCE = abs(nvl(p_amt_hce,0)),
2828: VALUE_DATE = p_one_step.p_settlement_date
2829: where TRANSACTION_NUMBER = p_prncpl_ref;
2830:
2831: update XTR_DEAL_DATE_AMOUNTS
2832: set AMOUNT = abs(p_one_step.p_amount),
2833: HCE_AMOUNT = abs(p_amt_hce),
2834: AMOUNT_DATE = p_one_step.p_settlement_date,
2835: CASHFLOW_AMOUNT = decode(ACTION_CODE,'PAY',-1,1) * abs(p_one_step.p_amount)

Line 2870: delete XTR_DEAL_DATE_AMOUNTS

2866: ---------------------------------------
2867: delete XTR_EXPOSURE_TRANSACTIONS
2868: where TRANSACTION_NUMBER = p_income_ref;
2869:
2870: delete XTR_DEAL_DATE_AMOUNTS
2871: where DEAL_TYPE = 'EXP'
2872: and TRANSACTION_NUMBER = p_income_ref;
2873:
2874: end if;

Line 2889: delete XTR_DEAL_DATE_AMOUNTS

2885:
2886: delete XTR_EXPOSURE_TRANSACTIONS
2887: where TRANSACTION_NUMBER = p_income_ref;
2888:
2889: delete XTR_DEAL_DATE_AMOUNTS
2890: where DEAL_TYPE = 'EXP'
2891: and TRANSACTION_NUMBER = p_income_ref;
2892:
2893: p_one_step.p_exp_number := null;

Line 2903: update XTR_DEAL_DATE_AMOUNTS

2899: AMOUNT_HCE = abs(nvl(p_amt_hce,0)),
2900: VALUE_DATE = p_one_step.p_settlement_date
2901: where TRANSACTION_NUMBER = p_income_ref;
2902:
2903: update XTR_DEAL_DATE_AMOUNTS
2904: set AMOUNT = abs(p_one_step.p_amount),
2905: HCE_AMOUNT = abs(p_amt_hce),
2906: AMOUNT_DATE = p_one_step.p_settlement_date,
2907: CASHFLOW_AMOUNT = decode(ACTION_CODE,'PAY',-1,1) * abs(p_one_step.p_amount)

Line 3020: delete from XTR_DEAL_DATE_AMOUNTS_V

3016: if p_tax_settle_no is not null then
3017: delete from XTR_EXPOSURE_TRANSACTIONS
3018: where TRANSACTION_NUMBER = p_tax_settle_no;
3019:
3020: delete from XTR_DEAL_DATE_AMOUNTS_V
3021: where DEAL_TYPE = 'EXP'
3022: and deal_number = 0
3023: and TRANSACTION_NUMBER = p_tax_settle_no;
3024:

Line 3057: from xtr_deal_date_amounts_v

3053: PROCEDURE UPDATE_TAX_DDA (p_exp_number NUMBER,
3054: p_amount NUMBER) IS
3055: cursor get_dda_cashflow is
3056: select cashflow_amount
3057: from xtr_deal_date_amounts_v
3058: where transaction_number=p_exp_number
3059: and deal_type='EXP'
3060: and deal_number=0;
3061: v_cashflow NUMBER;

Line 3069: update xtr_deal_date_amounts_v

3065: close get_dda_cashflow;
3066: if v_cashflow=0 then
3067: --need to update with ADDition since the DDA cashflow_amount for TAX
3068: --is always negative
3069: update xtr_deal_date_amounts_v
3070: set amount=amount-nvl(p_amount,0)
3071: where transaction_number=p_exp_number
3072: and deal_type='EXP'
3073: and deal_number=0;

Line 3075: update xtr_deal_date_amounts_v

3071: where transaction_number=p_exp_number
3072: and deal_type='EXP'
3073: and deal_number=0;
3074: else
3075: update xtr_deal_date_amounts_v
3076: set amount=amount-nvl(p_amount,0),
3077: cashflow_amount=cashflow_amount+nvl(p_amount,0)
3078: where transaction_number=p_exp_number
3079: and deal_type='EXP'