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_WRAPPER_API_P dependencies on XTR_BANK_BALANCES

Line 275: balances into XTR_BANK_BALANCES if the data passes validations.

271:
272:
273: /*------------------------------------------------------------------------------/
274: Bank_Balance_Upload takes input parameters from 'CE' and uploads
275: balances into XTR_BANK_BALANCES if the data passes validations.
276: USes local procedure bank_balance_validate for doing reval or accrual
277: related validations.
278:
279: Output Params:

Line 371: from XTR_BANK_BALANCES a

367: cursor PREV_DETAILS is
368: select
369: a.BALANCE_DATE,a.BALANCE_CFLOW,a.ACCUM_INT_CFWD,a.INTEREST_RATE,A.ACCRUAL_INTEREST,
370: a.rounding_type, a.day_count_type -- Added for Interest Override
371: from XTR_BANK_BALANCES a
372: where a.ACCOUNT_NUMBER = acct_no
373: and a.COMPANY_CODE = new_company
374: and a.BALANCE_DATE = (select max(b.BALANCE_DATE)
375: from XTR_BANK_BALANCES b

Line 375: from XTR_BANK_BALANCES b

371: from XTR_BANK_BALANCES a
372: where a.ACCOUNT_NUMBER = acct_no
373: and a.COMPANY_CODE = new_company
374: and a.BALANCE_DATE = (select max(b.BALANCE_DATE)
375: from XTR_BANK_BALANCES b
376: where b.ACCOUNT_NUMBER = acct_no
377: and b.COMPANY_CODE = new_company);
378: --
379: cursor CHK_EXISTING_DATE is

Line 381: from XTR_BANK_BALANCES

377: and b.COMPANY_CODE = new_company);
378: --
379: cursor CHK_EXISTING_DATE is
380: select 'x'
381: from XTR_BANK_BALANCES
382: where ACCOUNT_NUMBER = acct_no
383: and COMPANY_CODE = new_company
384: and TRUNC(BALANCE_DATE) = TRUNC(new_date);
385: --

Line 388: from XTR_BANK_BALANCES

384: and TRUNC(BALANCE_DATE) = TRUNC(new_date);
385: --
386: cursor GET_LIM_CODE_BAL is
387: select LIMIT_CODE
388: from XTR_BANK_BALANCES
389: where ACCOUNT_NUMBER = acct_no
390: and COMPANY_CODE = new_company
391: and BALANCE_DATE < new_date
392: and ((new_bal_ledger >= 0 and BALANCE_CFLOW >= 0)

Line 419: FROM xtr_bank_balances a

415:
416: -- Added for Interest Override
417: CURSOR oldest_date IS
418: SELECT MIN(a.balance_date)
419: FROM xtr_bank_balances a
420: WHERE a.account_number = acct_no
421: AND a.COMPANY_CODE = new_company;
422:
423: CURSOR PRV_PRV_DETAILS IS

Line 425: FROM xtr_bank_balances a

421: AND a.COMPANY_CODE = new_company;
422:
423: CURSOR PRV_PRV_DETAILS IS
424: SELECT a.day_count_type
425: FROM xtr_bank_balances a
426: WHERE a.account_number = acct_no
427: AND a.COMPANY_CODE = new_company
428: AND a.balance_date = (select max(b.BALANCE_DATE)
429: from XTR_BANK_BALANCES b

Line 429: from XTR_BANK_BALANCES b

425: FROM xtr_bank_balances a
426: WHERE a.account_number = acct_no
427: AND a.COMPANY_CODE = new_company
428: AND a.balance_date = (select max(b.BALANCE_DATE)
429: from XTR_BANK_BALANCES b
430: where b.ACCOUNT_NUMBER = acct_no
431: and b.COMPANY_CODE = new_company
432: AND b.balance_date < l_prv_date);
433:

Line 578: insert into XTR_BANK_BALANCES

574: if nvl(p_result,'XX') = 'XTR3_BU_VAL_ERROR' then
575: P_RESULT := 'XTR3_BU_WARNING';
576: return;
577: elsif nvl(p_result,'XX') = 'XTR3_BU_VAL_WARN' then
578: insert into XTR_BANK_BALANCES
579: (company_code,account_number,balance_date,no_of_days,
580: statement_balance,balance_adjustment,balance_cflow,
581: accum_int_bfwd,interest,interest_rate,interest_settled,
582: interest_settled_hce,accum_int_cfwd,setoff,limit_code,

Line 598: insert into XTR_BANK_BALANCES

594: new_bal_ledger_hce := round(new_bal_ledger / l_hc_rate,roundfac);
595: P_RESULT := 'XTR3_BU_WARNING';
596: else
597: -- the uploaded date is the latest date then ok to insert
598: insert into XTR_BANK_BALANCES
599: (company_code,account_number,balance_date,no_of_days,
600: statement_balance,balance_adjustment,balance_cflow,
601: accum_int_bfwd,interest,interest_rate,interest_settled,
602: interest_settled_hce,accum_int_cfwd,setoff,limit_code,

Line 628: update XTR_BANK_BALANCES

624: if nvl(p_result,'XX') = 'XTR3_BU_VAL_ERROR' then
625: P_RESULT := 'XTR3_BU_WARNING';
626: return;
627: elsif nvl(p_result,'XX') = 'XTR3_BU_VAL_WARN' then
628: update XTR_BANK_BALANCES
629: set statement_balance=new_bal_ledger,
630: balance_adjustment=new_bal_intcalc,
631: balance_cflow=new_bal_cashflow,
632: accum_int_bfwd=l_int_bf,

Line 653: update XTR_BANK_BALANCES

649: and COMPANY_CODE = new_company
650: and TRUNC(BALANCE_DATE) = TRUNC(new_date);
651: P_RESULT := 'XTR3_BU_WARNING';
652: else
653: update XTR_BANK_BALANCES
654: set statement_balance=new_bal_ledger,
655: balance_adjustment=new_bal_intcalc,
656: balance_cflow=new_bal_cashflow,
657: accum_int_bfwd=l_int_bf,

Line 748: xtr_bank_balances bb,xtr_bank_accounts ba,

744:
745: cursor cur_reval_insbal IS
746: SELECT max(period_to)
747: FROM
748: xtr_bank_balances bb,xtr_bank_accounts ba,
749: xtr_deal_date_amounts dd,xtr_revaluation_details rd
750: WHERE
751: bb.company_code = p_company_code
752: AND bb.account_number = p_account_number

Line 764: xtr_bank_balances bb,xtr_bank_accounts ba,

760:
761: cursor cur_accrl_insbal IS
762: SELECT max(period_to)
763: FROM
764: xtr_bank_balances bb,xtr_bank_accounts ba,
765: xtr_deal_date_amounts dd,xtr_accrls_amort aa
766: WHERE
767: bb.company_code = p_company_code
768: AND bb.account_number = p_account_number