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_REPLICATE_BANK_BALANCES dependencies on XTR_BANK_ACCOUNTS

Line 330: l_ccy xtr_bank_accounts.currency%TYPE;

326: l_prv_day_count_type XTR_BANK_BALANCES.day_count_type%TYPE;
327: l_prv_rounding_type XTR_BANK_BALANCES.rounding_type%TYPE;
328:
329:
330: l_ccy xtr_bank_accounts.currency%TYPE;
331: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
332: l_bank_code xtr_bank_accounts.bank_code%TYPE;
333: l_yr_type xtr_bank_accounts.year_calc_type%TYPE;
334: l_rounding_type xtr_bank_accounts.rounding_type%TYPE;

Line 331: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;

327: l_prv_rounding_type XTR_BANK_BALANCES.rounding_type%TYPE;
328:
329:
330: l_ccy xtr_bank_accounts.currency%TYPE;
331: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
332: l_bank_code xtr_bank_accounts.bank_code%TYPE;
333: l_yr_type xtr_bank_accounts.year_calc_type%TYPE;
334: l_rounding_type xtr_bank_accounts.rounding_type%TYPE;
335: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;

Line 332: l_bank_code xtr_bank_accounts.bank_code%TYPE;

328:
329:
330: l_ccy xtr_bank_accounts.currency%TYPE;
331: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
332: l_bank_code xtr_bank_accounts.bank_code%TYPE;
333: l_yr_type xtr_bank_accounts.year_calc_type%TYPE;
334: l_rounding_type xtr_bank_accounts.rounding_type%TYPE;
335: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
336: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE;

Line 333: l_yr_type xtr_bank_accounts.year_calc_type%TYPE;

329:
330: l_ccy xtr_bank_accounts.currency%TYPE;
331: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
332: l_bank_code xtr_bank_accounts.bank_code%TYPE;
333: l_yr_type xtr_bank_accounts.year_calc_type%TYPE;
334: l_rounding_type xtr_bank_accounts.rounding_type%TYPE;
335: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
336: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE;
337:

Line 334: l_rounding_type xtr_bank_accounts.rounding_type%TYPE;

330: l_ccy xtr_bank_accounts.currency%TYPE;
331: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
332: l_bank_code xtr_bank_accounts.bank_code%TYPE;
333: l_yr_type xtr_bank_accounts.year_calc_type%TYPE;
334: l_rounding_type xtr_bank_accounts.rounding_type%TYPE;
335: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
336: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE;
337:
338: l_round_factor XTR_MASTER_CURRENCIES_V.ROUNDING_FACTOR%TYPE;

Line 335: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;

331: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
332: l_bank_code xtr_bank_accounts.bank_code%TYPE;
333: l_yr_type xtr_bank_accounts.year_calc_type%TYPE;
334: l_rounding_type xtr_bank_accounts.rounding_type%TYPE;
335: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
336: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE;
337:
338: l_round_factor XTR_MASTER_CURRENCIES_V.ROUNDING_FACTOR%TYPE;
339: l_yr_basis XTR_MASTER_CURRENCIES_V.YEAR_BASIS%TYPE;

Line 336: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE;

332: l_bank_code xtr_bank_accounts.bank_code%TYPE;
333: l_yr_type xtr_bank_accounts.year_calc_type%TYPE;
334: l_rounding_type xtr_bank_accounts.rounding_type%TYPE;
335: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
336: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE;
337:
338: l_round_factor XTR_MASTER_CURRENCIES_V.ROUNDING_FACTOR%TYPE;
339: l_yr_basis XTR_MASTER_CURRENCIES_V.YEAR_BASIS%TYPE;
340: l_hce_rate XTR_MASTER_CURRENCIES_V.HCE_RATE%TYPE;

Line 374: -- Check whether the bank account exist in the xtr_bank_accounts table

370: WHERE b.ACCOUNT_NUMBER = p_balance_rec.account_number
371: AND b.COMPANY_CODE = p_balance_rec.company_code);
372:
373:
374: -- Check whether the bank account exist in the xtr_bank_accounts table
375: CURSOR BANK_ACCT_DETAILS IS
376: SELECT CURRENCY,PORTFOLIO_CODE,BANK_CODE,nvl(YEAR_CALC_TYPE,'ACTUAL/ACTUAL') year_calc_type,rounding_type, day_count_type,ce_bank_account_id
377: FROM XTR_BANK_ACCOUNTS
378: WHERE ACCOUNT_NUMBER = p_balance_rec.account_number

Line 377: FROM XTR_BANK_ACCOUNTS

373:
374: -- Check whether the bank account exist in the xtr_bank_accounts table
375: CURSOR BANK_ACCT_DETAILS IS
376: SELECT CURRENCY,PORTFOLIO_CODE,BANK_CODE,nvl(YEAR_CALC_TYPE,'ACTUAL/ACTUAL') year_calc_type,rounding_type, day_count_type,ce_bank_account_id
377: FROM XTR_BANK_ACCOUNTS
378: WHERE ACCOUNT_NUMBER = p_balance_rec.account_number
379: AND PARTY_CODE = p_balance_rec.company_code;
380: --
381:

Line 667: l_ccy xtr_bank_accounts.currency%TYPE;

663:
664: l_cross_ref xtr_party_info.cross_ref_to_other_party%TYPE;
665: l_exists VARCHAR2(1);
666: l_ce_bank_acct_bal_id xtr_bank_balances.ce_bank_account_balance_id%TYPE;
667: l_ccy xtr_bank_accounts.currency%TYPE;
668:
669: -- Finding the subsidiary for the company
670: CURSOR C_CROSS_REF IS
671: SELECT CROSS_REF_TO_OTHER_PARTY

Line 679: FROM XTR_BANK_ACCOUNTS

675:
676: -- Finding the currency for the account number and company combination
677: CURSOR C_CURRENCY IS
678: SELECT CURRENCY
679: FROM XTR_BANK_ACCOUNTS
680: WHERE PARTY_CODE = P_BALANCE_REC.COMPANY_CODE
681: AND ACCOUNT_NUMBER = P_BALANCE_REC.ACCOUNT_NUMBER;
682:
683:

Line 806: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;

802: x_return_status OUT NOCOPY VARCHAR2
803: )
804: IS
805:
806: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
807: l_currency xtr_bank_accounts.currency%TYPE;
808: l_bank_code xtr_bank_accounts.bank_code%TYPE;
809: l_result BOOLEAN;
810: l_duplicate NUMBER;

Line 807: l_currency xtr_bank_accounts.currency%TYPE;

803: )
804: IS
805:
806: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
807: l_currency xtr_bank_accounts.currency%TYPE;
808: l_bank_code xtr_bank_accounts.bank_code%TYPE;
809: l_result BOOLEAN;
810: l_duplicate NUMBER;
811: l_return_error VARCHAR2(30);

Line 808: l_bank_code xtr_bank_accounts.bank_code%TYPE;

804: IS
805:
806: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
807: l_currency xtr_bank_accounts.currency%TYPE;
808: l_bank_code xtr_bank_accounts.bank_code%TYPE;
809: l_result BOOLEAN;
810: l_duplicate NUMBER;
811: l_return_error VARCHAR2(30);
812: l_authorised VARCHAR2(1);

Line 813: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE ;

809: l_result BOOLEAN;
810: l_duplicate NUMBER;
811: l_return_error VARCHAR2(30);
812: l_authorised VARCHAR2(1);
813: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE ;
814: l_int_schedule_id ce_bank_accounts.interest_schedule_id%TYPE ;
815: l_pricing_model xtr_bank_accounts.pricing_model%TYPE;
816:
817:

Line 815: l_pricing_model xtr_bank_accounts.pricing_model%TYPE;

811: l_return_error VARCHAR2(30);
812: l_authorised VARCHAR2(1);
813: l_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE ;
814: l_int_schedule_id ce_bank_accounts.interest_schedule_id%TYPE ;
815: l_pricing_model xtr_bank_accounts.pricing_model%TYPE;
816:
817:
818: -- Check whether the portfolio code exists for the bank account for which balacnes
819: -- are to be entered

Line 823: FROM xtr_bank_accounts

819: -- are to be entered
820: CURSOR C_PORTFOLIO IS
821: SELECT PORTFOLIO_CODE, CURRENCY , BANK_CODE, PRICING_MODEL,
822: ce_bank_account_id /* Bug 5346243 */
823: FROM xtr_bank_accounts
824: WHERE ACCOUNT_NUMBER = p_account_number
825: AND PARTY_CODE = p_company_code;
826:
827:

Line 832: XTR_BANK_ACCOUNTS_V B

828: -- Check whether the balance does not already exist for
829: CURSOR C_DUPLICATE_DATE IS
830: SELECT 1
831: FROM XTR_BANK_BALANCES_V A,
832: XTR_BANK_ACCOUNTS_V B
833: WHERE A.BALANCE_DATE = p_balance_date
834: AND A.ACCOUNT_NUMBER = B.ACCOUNT_NUMBER
835: AND A.COMPANY_CODE = B.PARTY_CODE
836: AND B.CURRENCY = l_currency

Line 1139: , p_currency IN xtr_bank_accounts.currency%TYPE

1135:
1136:
1137: FUNCTION CHK_ACCRUAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
1138: , p_account_number IN xtr_bank_balances.account_number%TYPE
1139: , p_currency IN xtr_bank_accounts.currency%TYPE
1140: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1141: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE DEFAULT NULL
1142: , p_interest_calc_balance IN NUMBER
1143: , p_action_flag IN VARCHAR2

Line 1158: xtr_bank_balances bb, xtr_bank_accounts ba,

1154: -- Check whether the accruals have been run for that particular deal
1155: CURSOR c_accrl_deal IS
1156: SELECT max(period_to)
1157: FROM
1158: xtr_bank_balances bb, xtr_bank_accounts ba,
1159: xtr_deal_date_amounts dd, xtr_accrls_amort aa
1160: WHERE bb.company_code = p_company_code
1161: AND bb.account_number = p_account_number
1162: AND bb.company_code = ba.party_code

Line 1252: , p_currency IN xtr_bank_accounts.currency%TYPE

1248: -- insertion/updation/deletion
1249:
1250: FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
1251: , p_account_number IN xtr_bank_balances.account_number%TYPE
1252: , p_currency IN xtr_bank_accounts.currency%TYPE
1253: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1254: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE DEFAULT NULL
1255: , p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
1256: , p_action_flag IN VARCHAR2

Line 1284: xtr_bank_balances bb,xtr_bank_accounts ba

1280:
1281: CURSOR c_deal_delete IS
1282: SELECT max(bb.balance_date)
1283: FROM
1284: xtr_bank_balances bb,xtr_bank_accounts ba
1285: WHERE
1286: bb.company_code = p_company_code
1287: AND bb.account_number = p_account_number
1288: AND bb.company_code = ba.party_code

Line 1298: xtr_bank_balances bb,xtr_bank_accounts ba,

1294: -- Check whether the revaluations have been run for that particular deal
1295: CURSOR c_reval_deal IS
1296: SELECT max(period_to)
1297: FROM
1298: xtr_bank_balances bb,xtr_bank_accounts ba,
1299: xtr_revaluation_details rd
1300: WHERE
1301: bb.company_code = p_company_code
1302: AND bb.account_number = p_account_number

Line 1392: l_ccy xtr_bank_accounts.currency%TYPE;

1388: x_return_status OUT NOCOPY VARCHAR2
1389: )
1390: IS
1391:
1392: l_ccy xtr_bank_accounts.currency%TYPE;
1393: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
1394: l_bank_code xtr_bank_accounts.bank_code%TYPE;
1395: l_cross_ref xtr_party_info.cross_ref_to_other_party%TYPE;
1396: l_bal_exists VARCHAR2(10);

Line 1393: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;

1389: )
1390: IS
1391:
1392: l_ccy xtr_bank_accounts.currency%TYPE;
1393: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
1394: l_bank_code xtr_bank_accounts.bank_code%TYPE;
1395: l_cross_ref xtr_party_info.cross_ref_to_other_party%TYPE;
1396: l_bal_exists VARCHAR2(10);
1397: l_dummy_num VARCHAR2(1);

Line 1394: l_bank_code xtr_bank_accounts.bank_code%TYPE;

1390: IS
1391:
1392: l_ccy xtr_bank_accounts.currency%TYPE;
1393: l_portfolio_code xtr_bank_accounts.portfolio_code%TYPE;
1394: l_bank_code xtr_bank_accounts.bank_code%TYPE;
1395: l_cross_ref xtr_party_info.cross_ref_to_other_party%TYPE;
1396: l_bal_exists VARCHAR2(10);
1397: l_dummy_num VARCHAR2(1);
1398: l_bal_date xtr_bank_balances.balance_date%TYPE;

Line 1409: FROM XTR_BANK_ACCOUNTS

1405:
1406:
1407: CURSOR C_ACCT_DETAILS IS
1408: SELECT CURRENCY,PORTFOLIO_CODE,BANK_CODE
1409: FROM XTR_BANK_ACCOUNTS
1410: WHERE ACCOUNT_NUMBER = p_account_number
1411: AND PARTY_CODE = p_company_code;
1412:
1413: -- To check whether the 'BAL' row exists in DDA table

Line 1587: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

1583: deletion of the record
1584: */
1585:
1586: FUNCTION CHK_INTEREST_SETTLED
1587: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
1588: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1589: )return VARCHAR2 is
1590:
1591: l_return VARCHAR2(2);

Line 1593: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;

1589: )return VARCHAR2 is
1590:
1591: l_return VARCHAR2(2);
1592: l_dummy VARCHAR2(1);
1593: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;
1594: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1595: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1596:
1597:

Line 1594: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;

1590:
1591: l_return VARCHAR2(2);
1592: l_dummy VARCHAR2(1);
1593: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;
1594: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1595: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1596:
1597:
1598: CURSOR c_account_details IS

Line 1595: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;

1591: l_return VARCHAR2(2);
1592: l_dummy VARCHAR2(1);
1593: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;
1594: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1595: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1596:
1597:
1598: CURSOR c_account_details IS
1599: SELECT party_code, account_number,currency

Line 1600: FROM XTR_BANK_ACCOUNTS

1596:
1597:
1598: CURSOR c_account_details IS
1599: SELECT party_code, account_number,currency
1600: FROM XTR_BANK_ACCOUNTS
1601: WHERE ce_bank_account_id = p_ce_bank_account_id;
1602:
1603: cursor INT_SETTLED is
1604: select 'Y'

Line 1648: , p_currency IN xtr_bank_accounts.currency%TYPE

1644:
1645: FUNCTION CHK_REVAL_ON_RENDER
1646: ( p_company_code IN xtr_bank_balances.company_code%TYPE
1647: , p_account_number IN xtr_bank_balances.account_number%TYPE
1648: , p_currency IN xtr_bank_accounts.currency%TYPE
1649: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1650: )RETURN BOOLEAN
1651: IS
1652:

Line 1660: xtr_bank_balances bb,xtr_bank_accounts ba,

1656: -- Check whether the revaluations have been run for that particular deal
1657: CURSOR c_reval_deal IS
1658: SELECT max(period_to)
1659: FROM
1660: xtr_bank_balances bb,xtr_bank_accounts ba,
1661: xtr_revaluation_details rd
1662: WHERE
1663: bb.company_code = p_company_code
1664: AND bb.account_number = p_account_number

Line 1675: xtr_bank_balances bb,xtr_bank_accounts ba

1671:
1672: CURSOR c_deal_delete IS
1673: SELECT max(bb.balance_date)
1674: FROM
1675: xtr_bank_balances bb,xtr_bank_accounts ba
1676: WHERE
1677: bb.company_code = p_company_code
1678: AND bb.account_number = p_account_number
1679: AND bb.company_code = ba.party_code

Line 1710: , p_currency IN xtr_bank_accounts.currency%TYPE

1706: -- to enable/disable the interest calculated balance
1707: FUNCTION CHK_ACCRUAL_ON_RENDER
1708: ( p_company_code IN xtr_bank_balances.company_code%TYPE
1709: , p_account_number IN xtr_bank_balances.account_number%TYPE
1710: , p_currency IN xtr_bank_accounts.currency%TYPE
1711: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1712: )RETURN BOOLEAN
1713: IS
1714:

Line 1721: xtr_bank_balances bb, xtr_bank_accounts ba,

1717: -- Check whether the accruals have been run for that particular deal
1718: CURSOR c_accrl_deal IS
1719: SELECT max(period_to)
1720: FROM
1721: xtr_bank_balances bb, xtr_bank_accounts ba,
1722: xtr_deal_date_amounts dd, xtr_accrls_amort aa
1723: WHERE bb.company_code = p_company_code
1724: AND bb.account_number = p_account_number
1725: AND bb.company_code = ba.party_code

Line 1750: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

1746:
1747: END CHK_ACCRUAL_ON_RENDER;
1748:
1749: FUNCTION CHK_ACCRUAL_ON_RENDER
1750: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
1751: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1752: )return VARCHAR2 is
1753: l_return VARCHAR2(2);
1754: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;

Line 1754: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;

1750: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
1751: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1752: )return VARCHAR2 is
1753: l_return VARCHAR2(2);
1754: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;
1755: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1756: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1757: CURSOR c_account_details IS
1758: SELECT party_code, account_number,currency

Line 1755: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;

1751: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1752: )return VARCHAR2 is
1753: l_return VARCHAR2(2);
1754: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;
1755: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1756: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1757: CURSOR c_account_details IS
1758: SELECT party_code, account_number,currency
1759: FROM XTR_BANK_ACCOUNTS

Line 1756: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;

1752: )return VARCHAR2 is
1753: l_return VARCHAR2(2);
1754: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;
1755: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1756: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1757: CURSOR c_account_details IS
1758: SELECT party_code, account_number,currency
1759: FROM XTR_BANK_ACCOUNTS
1760: WHERE ce_bank_account_id = p_ce_bank_account_id;

Line 1759: FROM XTR_BANK_ACCOUNTS

1755: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1756: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1757: CURSOR c_account_details IS
1758: SELECT party_code, account_number,currency
1759: FROM XTR_BANK_ACCOUNTS
1760: WHERE ce_bank_account_id = p_ce_bank_account_id;
1761: BEGIN
1762: l_return := 'Y';
1763: IF(p_ce_bank_account_id is not null and p_balance_date is not null) THEN

Line 1779: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

1775:
1776:
1777:
1778: FUNCTION CHK_REVAL_ON_RENDER
1779: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
1780: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1781: )return VARCHAR2 is
1782: l_return VARCHAR2(2);
1783: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;

Line 1783: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;

1779: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
1780: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1781: )return VARCHAR2 is
1782: l_return VARCHAR2(2);
1783: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;
1784: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1785: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1786:
1787: CURSOR c_account_details IS

Line 1784: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;

1780: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
1781: )return VARCHAR2 is
1782: l_return VARCHAR2(2);
1783: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;
1784: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1785: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1786:
1787: CURSOR c_account_details IS
1788: SELECT party_code, account_number,currency

Line 1785: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;

1781: )return VARCHAR2 is
1782: l_return VARCHAR2(2);
1783: l_company_code XTR_BANK_ACCOUNTS.party_code%TYPE;
1784: l_account_number XTR_BANK_ACCOUNTS.account_number%TYPE;
1785: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1786:
1787: CURSOR c_account_details IS
1788: SELECT party_code, account_number,currency
1789: FROM XTR_BANK_ACCOUNTS

Line 1789: FROM XTR_BANK_ACCOUNTS

1785: l_currency XTR_BANK_ACCOUNTS.currency%TYPE;
1786:
1787: CURSOR c_account_details IS
1788: SELECT party_code, account_number,currency
1789: FROM XTR_BANK_ACCOUNTS
1790: WHERE ce_bank_account_id = p_ce_bank_account_id;
1791:
1792: BEGIN
1793: l_return := 'Y';

Line 1903: xtr_bank_balances IF THE same has been updated IN THE xtr_bank_accounts TABLE

1899: END LOG_ERR_MSG;
1900:
1901:
1902: /* This procedure updates the rounding_type and the day_count_type in the
1903: xtr_bank_balances IF THE same has been updated IN THE xtr_bank_accounts TABLE
1904:
1905: This will be called FORM xtr_replicate_bank_accounts API WHEN THE rounding TYPE/
1906: day_count_type has been updated IN THE interest schedules page OR THE
1907: schedule has been changed BY THE USER */

Line 1911: (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE

1907: schedule has been changed BY THE USER */
1908:
1909:
1910: PROCEDURE UPDATE_ROUNDING_DAYCOUNT
1911: (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE
1912: ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE
1913: ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE
1914: ,x_return_status OUT NOCOPY VARCHAR2
1915: )

Line 1912: ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE

1908:
1909:
1910: PROCEDURE UPDATE_ROUNDING_DAYCOUNT
1911: (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE
1912: ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE
1913: ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE
1914: ,x_return_status OUT NOCOPY VARCHAR2
1915: )
1916:

Line 1913: ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE

1909:
1910: PROCEDURE UPDATE_ROUNDING_DAYCOUNT
1911: (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE
1912: ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE
1913: ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE
1914: ,x_return_status OUT NOCOPY VARCHAR2
1915: )
1916:
1917: IS

Line 1919: l_old_rounding_type xtr_bank_accounts.rounding_type%TYPE;

1915: )
1916:
1917: IS
1918:
1919: l_old_rounding_type xtr_bank_accounts.rounding_type%TYPE;
1920: l_old_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1921: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1922: l_party_code xtr_bank_accounts.party_code%TYPE;
1923: l_account_number xtr_bank_accounts.account_number%TYPE;

Line 1920: l_old_day_count_type xtr_bank_accounts.day_count_type%TYPE;

1916:
1917: IS
1918:
1919: l_old_rounding_type xtr_bank_accounts.rounding_type%TYPE;
1920: l_old_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1921: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1922: l_party_code xtr_bank_accounts.party_code%TYPE;
1923: l_account_number xtr_bank_accounts.account_number%TYPE;
1924: l_latest_date DATE;

Line 1921: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;

1917: IS
1918:
1919: l_old_rounding_type xtr_bank_accounts.rounding_type%TYPE;
1920: l_old_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1921: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1922: l_party_code xtr_bank_accounts.party_code%TYPE;
1923: l_account_number xtr_bank_accounts.account_number%TYPE;
1924: l_latest_date DATE;
1925: l_oldest_date DATE;

Line 1922: l_party_code xtr_bank_accounts.party_code%TYPE;

1918:
1919: l_old_rounding_type xtr_bank_accounts.rounding_type%TYPE;
1920: l_old_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1921: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1922: l_party_code xtr_bank_accounts.party_code%TYPE;
1923: l_account_number xtr_bank_accounts.account_number%TYPE;
1924: l_latest_date DATE;
1925: l_oldest_date DATE;
1926: l_acc_status varchar2(20);

Line 1923: l_account_number xtr_bank_accounts.account_number%TYPE;

1919: l_old_rounding_type xtr_bank_accounts.rounding_type%TYPE;
1920: l_old_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1921: l_day_count_type xtr_bank_accounts.day_count_type%TYPE;
1922: l_party_code xtr_bank_accounts.party_code%TYPE;
1923: l_account_number xtr_bank_accounts.account_number%TYPE;
1924: l_latest_date DATE;
1925: l_oldest_date DATE;
1926: l_acc_status varchar2(20);
1927: l_batch_error varchar2(20);

Line 1930: -- xtr_bank_accounts table

1926: l_acc_status varchar2(20);
1927: l_batch_error varchar2(20);
1928:
1929: -- This cursor gets the existing rounding type/day count type from the
1930: -- xtr_bank_accounts table
1931:
1932: CURSOR c_old_types IS
1933: SELECT rounding_type, day_count_type, party_code, account_number
1934: FROM XTR_BANK_ACCOUNTS

Line 1934: FROM XTR_BANK_ACCOUNTS

1930: -- xtr_bank_accounts table
1931:
1932: CURSOR c_old_types IS
1933: SELECT rounding_type, day_count_type, party_code, account_number
1934: FROM XTR_BANK_ACCOUNTS
1935: WHERE ce_bank_account_id = p_ce_bank_account_id;
1936:
1937: -- Gets the maximum balance date and the minimum balance date for that
1938: -- company and account

Line 2038: p_party_code xtr_bank_accounts.party_code%type

2034:
2035:
2036:
2037: FUNCTION CHK_INT_OVERRIDE (
2038: p_party_code xtr_bank_accounts.party_code%type
2039: ,p_account_number xtr_bank_accounts.account_number%type
2040: ,p_oldest_date DATE
2041: ) RETURN VARCHAR2 IS
2042:

Line 2039: ,p_account_number xtr_bank_accounts.account_number%type

2035:
2036:
2037: FUNCTION CHK_INT_OVERRIDE (
2038: p_party_code xtr_bank_accounts.party_code%type
2039: ,p_account_number xtr_bank_accounts.account_number%type
2040: ,p_oldest_date DATE
2041: ) RETURN VARCHAR2 IS
2042:
2043: l_check_status varchar2(1);

Line 2111: p_party_code xtr_bank_accounts.party_code%type

2107:
2108:
2109:
2110: FUNCTION CHK_ACCRUAL_INT (
2111: p_party_code xtr_bank_accounts.party_code%type
2112: ,p_account_number xtr_bank_accounts.account_number%type
2113: )RETURN varchar2 IS
2114:
2115: l_acc_int number;

Line 2112: ,p_account_number xtr_bank_accounts.account_number%type

2108:
2109:
2110: FUNCTION CHK_ACCRUAL_INT (
2111: p_party_code xtr_bank_accounts.party_code%type
2112: ,p_account_number xtr_bank_accounts.account_number%type
2113: )RETURN varchar2 IS
2114:
2115: l_acc_int number;
2116: l_acc_status varchar2(20);

Line 2147: (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

2143: END CHK_ACCRUAL_INT;
2144:
2145:
2146: PROCEDURE CHK_ACCRUAL_REVAL_WARNINGS
2147: (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
2148: ,p_balance_date IN xtr_bank_balances.balance_date%TYPE
2149: ,p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
2150: ,p_interest_calc_balance IN NUMBER
2151: ,p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE

Line 2159: FROM XTR_BANK_ACCOUNTS

2155: ,x_msg_data OUT NOCOPY VARCHAR2 )IS
2156:
2157: CURSOR c_bank_acct_details IS
2158: SELECT party_code,account_number,currency
2159: FROM XTR_BANK_ACCOUNTS
2160: WHERE ce_bank_account_id = p_ce_bank_account_id;
2161:
2162: l_company_code xtr_bank_accounts.party_code%TYPE;
2163: l_account_number xtr_bank_accounts.account_number%TYPE;

Line 2162: l_company_code xtr_bank_accounts.party_code%TYPE;

2158: SELECT party_code,account_number,currency
2159: FROM XTR_BANK_ACCOUNTS
2160: WHERE ce_bank_account_id = p_ce_bank_account_id;
2161:
2162: l_company_code xtr_bank_accounts.party_code%TYPE;
2163: l_account_number xtr_bank_accounts.account_number%TYPE;
2164: l_currency xtr_bank_accounts.currency%TYPE;
2165: l_return_error VARCHAR2(30);
2166:

Line 2163: l_account_number xtr_bank_accounts.account_number%TYPE;

2159: FROM XTR_BANK_ACCOUNTS
2160: WHERE ce_bank_account_id = p_ce_bank_account_id;
2161:
2162: l_company_code xtr_bank_accounts.party_code%TYPE;
2163: l_account_number xtr_bank_accounts.account_number%TYPE;
2164: l_currency xtr_bank_accounts.currency%TYPE;
2165: l_return_error VARCHAR2(30);
2166:
2167: BEGIN

Line 2164: l_currency xtr_bank_accounts.currency%TYPE;

2160: WHERE ce_bank_account_id = p_ce_bank_account_id;
2161:
2162: l_company_code xtr_bank_accounts.party_code%TYPE;
2163: l_account_number xtr_bank_accounts.account_number%TYPE;
2164: l_currency xtr_bank_accounts.currency%TYPE;
2165: l_return_error VARCHAR2(30);
2166:
2167: BEGIN
2168: FND_MSG_PUB.Initialize;