APPS.XTR_WRAPPER_API_P dependencies on XTR_BANK_BALANCES

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

470:
471:
472: /*------------------------------------------------------------------------------/
473: Bank_Balance_Upload takes input parameters from 'CE' and uploads
474: balances into XTR_BANK_BALANCES if the data passes validations.
475: USes local procedure bank_balance_validate for doing reval or accrual
476: related validations.
477:
478: Output Params:

Line 570: from XTR_BANK_BALANCES a

566: cursor PREV_DETAILS is
567: select
568: a.BALANCE_DATE,a.BALANCE_CFLOW,a.ACCUM_INT_CFWD,a.INTEREST_RATE,A.ACCRUAL_INTEREST,
569: a.rounding_type, a.day_count_type -- Added for Interest Override
570: from XTR_BANK_BALANCES a
571: where a.ACCOUNT_NUMBER = acct_no
572: and a.COMPANY_CODE = new_company
573: and a.BALANCE_DATE = (select max(b.BALANCE_DATE)
574: from XTR_BANK_BALANCES b

Line 574: from XTR_BANK_BALANCES b

570: from XTR_BANK_BALANCES a
571: where a.ACCOUNT_NUMBER = acct_no
572: and a.COMPANY_CODE = new_company
573: and a.BALANCE_DATE = (select max(b.BALANCE_DATE)
574: from XTR_BANK_BALANCES b
575: where b.ACCOUNT_NUMBER = acct_no
576: and b.COMPANY_CODE = new_company);
577: --
578: cursor CHK_EXISTING_DATE is

Line 580: from XTR_BANK_BALANCES

576: and b.COMPANY_CODE = new_company);
577: --
578: cursor CHK_EXISTING_DATE is
579: select 'x'
580: from XTR_BANK_BALANCES
581: where ACCOUNT_NUMBER = acct_no
582: and COMPANY_CODE = new_company
583: and TRUNC(BALANCE_DATE) = TRUNC(new_date);
584: --

Line 587: from XTR_BANK_BALANCES

583: and TRUNC(BALANCE_DATE) = TRUNC(new_date);
584: --
585: cursor GET_LIM_CODE_BAL is
586: select LIMIT_CODE
587: from XTR_BANK_BALANCES
588: where ACCOUNT_NUMBER = acct_no
589: and COMPANY_CODE = new_company
590: and BALANCE_DATE < new_date
591: and ((new_bal_ledger >= 0 and BALANCE_CFLOW >= 0)

Line 618: FROM xtr_bank_balances a

614:
615: -- Added for Interest Override
616: CURSOR oldest_date IS
617: SELECT MIN(a.balance_date)
618: FROM xtr_bank_balances a
619: WHERE a.account_number = acct_no
620: AND a.COMPANY_CODE = new_company;
621:
622: CURSOR PRV_PRV_DETAILS IS

Line 624: FROM xtr_bank_balances a

620: AND a.COMPANY_CODE = new_company;
621:
622: CURSOR PRV_PRV_DETAILS IS
623: SELECT a.day_count_type
624: FROM xtr_bank_balances a
625: WHERE a.account_number = acct_no
626: AND a.COMPANY_CODE = new_company
627: AND a.balance_date = (select max(b.BALANCE_DATE)
628: from XTR_BANK_BALANCES b

Line 628: from XTR_BANK_BALANCES b

624: FROM xtr_bank_balances a
625: WHERE a.account_number = acct_no
626: AND a.COMPANY_CODE = new_company
627: AND a.balance_date = (select max(b.BALANCE_DATE)
628: from XTR_BANK_BALANCES b
629: where b.ACCOUNT_NUMBER = acct_no
630: and b.COMPANY_CODE = new_company
631: AND b.balance_date < l_prv_date);
632:

Line 777: insert into XTR_BANK_BALANCES

773: if nvl(p_result,'XX') = 'XTR3_BU_VAL_ERROR' then
774: P_RESULT := 'XTR3_BU_WARNING';
775: return;
776: elsif nvl(p_result,'XX') = 'XTR3_BU_VAL_WARN' then
777: insert into XTR_BANK_BALANCES
778: (company_code,account_number,balance_date,no_of_days,
779: statement_balance,balance_adjustment,balance_cflow,
780: accum_int_bfwd,interest,interest_rate,interest_settled,
781: interest_settled_hce,accum_int_cfwd,setoff,limit_code,

Line 797: insert into XTR_BANK_BALANCES

793: new_bal_ledger_hce := round(new_bal_ledger / l_hc_rate,roundfac);
794: P_RESULT := 'XTR3_BU_WARNING';
795: else
796: -- the uploaded date is the latest date then ok to insert
797: insert into XTR_BANK_BALANCES
798: (company_code,account_number,balance_date,no_of_days,
799: statement_balance,balance_adjustment,balance_cflow,
800: accum_int_bfwd,interest,interest_rate,interest_settled,
801: interest_settled_hce,accum_int_cfwd,setoff,limit_code,

Line 827: update XTR_BANK_BALANCES

823: if nvl(p_result,'XX') = 'XTR3_BU_VAL_ERROR' then
824: P_RESULT := 'XTR3_BU_WARNING';
825: return;
826: elsif nvl(p_result,'XX') = 'XTR3_BU_VAL_WARN' then
827: update XTR_BANK_BALANCES
828: set statement_balance=new_bal_ledger,
829: balance_adjustment=new_bal_intcalc,
830: balance_cflow=new_bal_cashflow,
831: accum_int_bfwd=l_int_bf,

Line 852: update XTR_BANK_BALANCES

848: and COMPANY_CODE = new_company
849: and TRUNC(BALANCE_DATE) = TRUNC(new_date);
850: P_RESULT := 'XTR3_BU_WARNING';
851: else
852: update XTR_BANK_BALANCES
853: set statement_balance=new_bal_ledger,
854: balance_adjustment=new_bal_intcalc,
855: balance_cflow=new_bal_cashflow,
856: accum_int_bfwd=l_int_bf,

Line 947: xtr_bank_balances bb,xtr_bank_accounts ba,

943: --bug 7631275 starts
944: /*cursor cur_reval_insbal IS
945: SELECT max(period_to)
946: FROM
947: xtr_bank_balances bb,xtr_bank_accounts ba,
948: xtr_deal_date_amounts dd,xtr_revaluation_details rd
949: WHERE
950: bb.company_code = p_company_code
951: AND bb.account_number = p_account_number

Line 973: and exists (select 1 from xtr_bank_balances bb

969: AND dd.company_code = ba.party_code
970: AND dd.account_no = ba.account_number
971: AND dd.company_code = p_company_code
972: and dd.account_no = p_account_number
973: and exists (select 1 from xtr_bank_balances bb
974: where bb.company_code = dd.company_code
975: and bb.account_number = dd.account_no);
976:
977: /*cursor cur_accrl_insbal IS

Line 980: xtr_bank_balances bb,xtr_bank_accounts ba,

976:
977: /*cursor cur_accrl_insbal IS
978: SELECT max(period_to)
979: FROM
980: xtr_bank_balances bb,xtr_bank_accounts ba,
981: xtr_deal_date_amounts dd,xtr_accrls_amort aa
982: WHERE
983: bb.company_code = p_company_code
984: AND bb.account_number = p_account_number

Line 1006: and exists (select 1 from xtr_bank_balances bb

1002: AND dd.company_code = ba.party_code
1003: AND dd.account_no = ba.account_number
1004: AND dd.company_code = p_company_code
1005: and dd.account_no = p_account_number
1006: and exists (select 1 from xtr_bank_balances bb
1007: where bb.company_code = dd.company_code
1008: and bb.account_number = dd.account_no);
1009:
1010: --bug 7631275 ends