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_REVAL_PROCESS_P dependencies on XTR_INTERGROUP_TRANSFERS

Line 1205: update XTR_INTERGROUP_TRANSFERS

1201: rec.effective_date := rec.revldate;
1202: r_rd.effective_days := rec.period_end - rec.period_start;
1203: r_rd.amount_type := 'CCYUNRL';
1204: xtr_revl_unreal_log(rec, 0, 0, 0, 0, null, r_rd, retcode);
1205: update XTR_INTERGROUP_TRANSFERS
1206: set first_batch_id = rec.batch_id
1207: where company_code = rec.company_code
1208: and deal_number = rec.deal_no
1209: and transfer_date <= rec.revldate;

Line 3318: /* in xtr_intergroup_transfers for deal type IG */

3314: --------------------------------------------------------------
3315: /******************************************************************/
3316: /* This procedure pass one deal no for each company and calculate */
3317: /* (un)realized currency G/L and average exchange rate for the row */
3318: /* in xtr_intergroup_transfers for deal type IG */
3319: /*******************************************************************/
3320: PROCEDURE xtr_revl_ig_curr_gl(
3321: rec IN OUT NOCOPY xtr_revl_rec,
3322: retcode OUT NOCOPY NUMBER) IS

Line 3370: FROM XTR_INTERGROUP_TRANSFERS a,

3366: SELECT a.transfer_date, a.balance_out, a.transaction_number, a.first_batch_id,
3367: a.product_type, a.portfolio,
3368: b.transfer_date, b.balance_out, b.transaction_number, b.product_type,
3369: b.portfolio
3370: FROM XTR_INTERGROUP_TRANSFERS a,
3371: XTR_INTERGROUP_TRANSFERS b
3372: WHERE a.company_code = rec.company_code
3373: AND a.company_code = b.company_code
3374: AND a.deal_number = rec.deal_no

Line 3371: XTR_INTERGROUP_TRANSFERS b

3367: a.product_type, a.portfolio,
3368: b.transfer_date, b.balance_out, b.transaction_number, b.product_type,
3369: b.portfolio
3370: FROM XTR_INTERGROUP_TRANSFERS a,
3371: XTR_INTERGROUP_TRANSFERS b
3372: WHERE a.company_code = rec.company_code
3373: AND a.company_code = b.company_code
3374: AND a.deal_number = rec.deal_no
3375: AND a.deal_number = b.deal_number

Line 3381: from XTR_INTERGROUP_TRANSFERS c

3377: AND ((b.transaction_number > a.transaction_number and a.transfer_date = b.transfer_date)
3378: or(b.transfer_date > a.transfer_date))
3379: AND a.transfer_date =
3380: (select max(transfer_date)
3381: from XTR_INTERGROUP_TRANSFERS c
3382: where c.deal_number = a.deal_number
3383: and ((c.transfer_date < b.transfer_date) or
3384: (c.transaction_number < b.transaction_number and c.transfer_date = b.transfer_date)))
3385: AND a.last_batch_id is null

Line 3393: FROM XTR_INTERGROUP_TRANSFERS b

3389:
3390: Cursor C_CURR_BALANCE is
3391: SELECT b.transfer_date, b.balance_out, b.transaction_number,
3392: b.product_type, b.portfolio
3393: FROM XTR_INTERGROUP_TRANSFERS b
3394: WHERE b.company_code = rec.company_code
3395: AND b.deal_number = rec.deal_no
3396: AND b.transfer_date <= rec.revldate
3397: AND b.last_batch_id is null

Line 3403: FROM XTR_INTERGROUP_TRANSFERS a

3399:
3400: Cursor C_PREV_BALANCE is
3401: SELECT a.transfer_date, a.balance_out, a.transaction_number, a.first_batch_id,
3402: a.product_type, a.portfolio
3403: FROM XTR_INTERGROUP_TRANSFERS a
3404: WHERE a.company_code = rec.company_code
3405: AND a.deal_number = rec.deal_no
3406: AND ((l_trans_no1 > a.transaction_number and a.transfer_date = l_bal_date1)
3407: or(l_bal_date1 > a.transfer_date))

Line 3418: FROM XTR_INTERGROUP_TRANSFERS

3414: -------------------------------------------------------------------------------
3415: Cursor C_LAST_BALANCE is
3416: SELECT transaction_number, transfer_date, balance_out,
3417: first_batch_id, product_type, portfolio
3418: FROM XTR_INTERGROUP_TRANSFERS
3419: Where deal_number = rec.deal_no
3420: AND transfer_date <= rec.revldate
3421: AND last_batch_id is null
3422: ORDER BY transfer_date desc, transaction_number desc;

Line 3426: from XTR_INTERGROUP_TRANSFERS

3422: ORDER BY transfer_date desc, transaction_number desc;
3423:
3424: /*-------------------------- AW 25/10/01 ----------------------
3425: and transfer_date = (select max(transfer_date)
3426: from XTR_INTERGROUP_TRANSFERS
3427: where deal_number = rec.deal_no)
3428: and transaction_number = (select max(transaction_number)
3429: from XTR_INTERGROUP_TRANSFERS
3430: where deal_number = rec.deal_no)

Line 3429: from XTR_INTERGROUP_TRANSFERS

3425: and transfer_date = (select max(transfer_date)
3426: from XTR_INTERGROUP_TRANSFERS
3427: where deal_number = rec.deal_no)
3428: and transaction_number = (select max(transaction_number)
3429: from XTR_INTERGROUP_TRANSFERS
3430: where deal_number = rec.deal_no)
3431: and last_batch_id is null;
3432: */-------------------------------------------------------------
3433:

Line 3440: FROM xtr_intergroup_transfers

3436: -- Select the last balance's average exchange rate
3437: -----------------------------------------------------
3438: CURSOR c_last_ig_avg_rate IS
3439: SELECT average_exchange_rate
3440: FROM xtr_intergroup_transfers
3441: WHERE deal_number = rec.deal_no
3442: AND transfer_date <= l_bal_date0
3443: AND first_batch_id = l_pre_batch_id
3444: ORDER BY transfer_date desc, transaction_number desc;

Line 3628: -- Update the first record of the pair in XTR_INTERGROUP_TRANSFERS table

3624: l_avg_rate := l_avg_rate0;
3625: end if;
3626:
3627: -------------------------------------------------------------------------
3628: -- Update the first record of the pair in XTR_INTERGROUP_TRANSFERS table
3629: -------------------------------------------------------------------------
3630: update XTR_INTERGROUP_TRANSFERS
3631: set first_batch_id = nvl(first_batch_id, l_first_batch_id),
3632: last_batch_id = nvl(last_batch_id, l_last_batch_id),

Line 3630: update XTR_INTERGROUP_TRANSFERS

3626:
3627: -------------------------------------------------------------------------
3628: -- Update the first record of the pair in XTR_INTERGROUP_TRANSFERS table
3629: -------------------------------------------------------------------------
3630: update XTR_INTERGROUP_TRANSFERS
3631: set first_batch_id = nvl(first_batch_id, l_first_batch_id),
3632: last_batch_id = nvl(last_batch_id, l_last_batch_id),
3633: exchange_rate = nvl(exchange_rate, l_ex_rate0),
3634: average_exchange_rate = nvl(average_exchange_rate, l_avg_rate0)

Line 3640: -- Update the second record of the pair in XTR_INTERGROUP_TRANSFERS table

3636: and deal_number = rec.deal_no
3637: and transaction_number = l_trans_no0;
3638:
3639: -------------------------------------------------------------------------
3640: -- Update the second record of the pair in XTR_INTERGROUP_TRANSFERS table
3641: -------------------------------------------------------------------------
3642: update XTR_INTERGROUP_TRANSFERS
3643: set average_exchange_rate = l_avg_rate
3644: where company_code = rec.company_code

Line 3642: update XTR_INTERGROUP_TRANSFERS

3638:
3639: -------------------------------------------------------------------------
3640: -- Update the second record of the pair in XTR_INTERGROUP_TRANSFERS table
3641: -------------------------------------------------------------------------
3642: update XTR_INTERGROUP_TRANSFERS
3643: set average_exchange_rate = l_avg_rate
3644: where company_code = rec.company_code
3645: and deal_number = rec.deal_no
3646: and transaction_number = l_trans_no1;

Line 3728: -- Update the last row into XTR_INTERGROUP_TRANSFERS table

3724: end if;
3725: xtr_revl_unreal_log(rec, 0, 0, 0, 0, l_unrel_cur_gl, r_rd, retcode);
3726:
3727: ------------------------------------------------------------------
3728: -- Update the last row into XTR_INTERGROUP_TRANSFERS table
3729: ------------------------------------------------------------------
3730: update XTR_INTERGROUP_TRANSFERS
3731: set first_batch_id = nvl(first_batch_id, l_first_batch_id),
3732: exchange_rate = nvl(exchange_rate, l_ex_rate0),

Line 3730: update XTR_INTERGROUP_TRANSFERS

3726:
3727: ------------------------------------------------------------------
3728: -- Update the last row into XTR_INTERGROUP_TRANSFERS table
3729: ------------------------------------------------------------------
3730: update XTR_INTERGROUP_TRANSFERS
3731: set first_batch_id = nvl(first_batch_id, l_first_batch_id),
3732: exchange_rate = nvl(exchange_rate, l_ex_rate0),
3733: average_exchange_rate = nvl(average_exchange_rate, l_avg_rate0)
3734: where company_code = rec.company_code

Line 4344: from XTR_INTERGROUP_TRANSFERS_V

4340: elsif rec.deal_type = 'IG' then
4341: -- IG's FV is for reference only. We don't take it to calculate G/L.
4342: select BALANCE_OUT
4343: into init_fv
4344: from XTR_INTERGROUP_TRANSFERS_V
4345: where DEAL_NUMBER = rec.deal_no
4346: and TRANSACTION_NUMBER = rec.trans_no;
4347:
4348: elsif rec.deal_type = 'CA' then

Line 9839: /* xtr_bank_balance, xtr_intergroup_transfers */

9835: --------------------------------------------------------
9836: /*****************************************************************/
9837: /* This procedure insert unrealized values into xtr_revaluation_details table*/
9838: /* Also update xtr_deals and xtr_rollover_transactions, */
9839: /* xtr_bank_balance, xtr_intergroup_transfers */
9840: /******************************************************************/
9841: PROCEDURE xtr_revl_unreal_log(
9842: rec IN xtr_revl_rec,
9843: unrel_pl_value IN NUMBER,

Line 10042: /* xtr_bank_balance, xtr_intergroup_transfers */

10038: --------------------------------------------------------------------
10039: /*****************************************************************/
10040: /* This procedure insert realized values into xtr_revaluation_details table*/
10041: /* Also update xtr_deals and xtr_rollover_transactions, */
10042: /* xtr_bank_balance, xtr_intergroup_transfers */
10043: /******************************************************************/
10044: PROCEDURE xtr_revl_real_log (
10045: rec IN xtr_revl_rec,
10046: rel_pl_value IN NUMBER,