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_LIMITS_P dependencies on XTR_PRO_PARAM

Line 129: from XTR_PRO_PARAM

125: and company_code = pc_comp_code;
126: --
127: cursor get_home_ccy is
128: select param_value
129: from XTR_PRO_PARAM
130: where param_name = 'SYSTEM_FUNCTIONAL_CCY';
131: --
132: -- Old utilised will only be picked up if all the variables have remained the same
133: -- ie only amount has been altered

Line 161: from XTR_PRO_PARAM

157: from DUAL;
158: --
159: cursor c_ok_limit_chk (pc3_param_name VARCHAR2) is
160: select param_value
161: from XTR_PRO_PARAM
162: where param_name = pc3_param_name;
163: --
164: cursor c_date_restr is
165: select range

Line 175: FROM xtr_pro_param_v

171: order by cparty_code,security_name,deal_subtype;
172: --
173: CURSOR c_limit_control IS
174: SELECT substr(param_name,13) limit_check
175: FROM xtr_pro_param_v
176: WHERE param_name in ('LIMIT_CHECK_CPARTY','LIMIT_CHECK_GROUP','LIMIT_CHECK_SOVRN')
177: AND nvl(param_value,'N') = 'Y';
178: --
179: v_limit_check_type VARCHAR2(8);

Line 499: FROM XTR_PRO_PARAM

495: v_dummy:=0;
496: if (p_amount<0) then --payment
497: SELECT COUNT(*)
498: INTO v_dummy
499: FROM XTR_PRO_PARAM
500: WHERE PARAM_NAME='LIMIT_INCLUDE_PAYMENTS'
501: AND PARAM_VALUE='N';
502: end if;
503: if v_company_code is NOT null and p_limit_party is NOT null and p_amount_date is NOT null and v_dummy=0 then

Line 813: from XTR_PRO_PARAM

809: -- if not alreay done once for today
810: --
811: cursor CHK_UPDATE is
812: select 1
813: from XTR_PRO_PARAM
814: where PARAM_NAME = 'LAST_LIMIT_RECALC'
815: and to_date(nvl(PARAM_VALUE,'01/01/1990'),'DD/MM/YYYY') < trunc(sysdate);
816: --
817: cursor c_dda_row is

Line 842: select param_value from xtr_pro_param where

838: for update of amount;
839: --
840: -- ER 6449996 Start
841: cursor GET_LIMIT_RELEASE_TYPE IS
842: select param_value from xtr_pro_param where
843: param_name = 'RELEASE_LIMIT_UTIL';
844: -- ER 6449996 End
845: --
846: l_new_utilamt NUMBER;

Line 856: L_RELEASE_TYPE XTR_PRO_PARAM.PARAM_VALUE%TYPE;

852: v_utilised_amt NUMBER;
853: v_hce_utilised_amt NUMBER;
854: v_limit_party VARCHAR2(7);
855: -- ER 6449996 Start
856: L_RELEASE_TYPE XTR_PRO_PARAM.PARAM_VALUE%TYPE;
857: -- ER 6449996 End
858: L_SYS_DATE DATE;
859: --
860: begin

Line 908: update XTR_PRO_PARAM

904: xtr_debug_pkg.debug('After update xtr_mirror_dda_limit_row('||c.row_id||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
905: END IF;
906: END LOOP;
907: --
908: update XTR_PRO_PARAM
909: set PARAM_VALUE = to_char(sysdate,'DD/MM/YYYY')
910: where PARAM_NAME = 'LAST_LIMIT_RECALC';
911: --- commit;
912: end if;

Line 1186: from XTR_PRO_PARAM

1182: AND (limit_amount <> 0 OR utilised_amount <> 0);
1183: --
1184: cursor c_ok_to_do (pc3_param_name VARCHAR2) is
1185: select nvl(param_value,'Y')
1186: from XTR_PRO_PARAM
1187: where param_name = pc3_param_name;
1188: --
1189: v_ok_to_do VARCHAR2(2);
1190: v_auth VARCHAR2(1);

Line 1243: from XTR_PRO_PARAM

1239: AND (limit_amount <> 0 OR utilised_amount <> 0);
1240: --
1241: cursor c_ok_to_do (pc3_param_name VARCHAR2) is
1242: select nvl(param_value,'Y')
1243: from XTR_PRO_PARAM
1244: where param_name = pc3_param_name;
1245: --
1246: v_ok_to_do VARCHAR2(2);
1247: v_auth VARCHAR2(1);

Line 1311: from XTR_PRO_PARAM

1307: AND (limit_amount <> 0 OR utilised_amount <> 0);
1308: --
1309: cursor c_ok_to_do (pc3_param_name VARCHAR2) is
1310: select nvl(param_value,'Y')
1311: from XTR_PRO_PARAM
1312: where param_name = pc3_param_name;
1313: --
1314: v_ok_to_do VARCHAR2(2);
1315: v_auth VARCHAR2(1);

Line 1367: from XTR_PRO_PARAM

1363: order by product_type;
1364: --
1365: cursor c_ok_to_do (pc3_param_name VARCHAR2) is
1366: select nvl(param_value,'Y')
1367: from XTR_PRO_PARAM
1368: where param_name = pc3_param_name;
1369: --
1370: v_limit_amt NUMBER;
1371: v_ok_to_do VARCHAR2(2);

Line 1427: from XTR_pro_param

1423: and deal_type = pc2_deal_type;
1424: --
1425: cursor c_ok_to_do (pc3_param_name VARCHAR2) is
1426: select nvl(param_value,'Y')
1427: from XTR_pro_param
1428: where param_name = pc3_param_name;
1429: --
1430: v_ok_to_do VARCHAR2(2);
1431: v_auth XTR_DEALER_LIMITS.authorised%TYPE;

Line 1488: from XTR_pro_param

1484: AND (cl.limit_amount <> 0 OR cl.utilised_amount <> 0);
1485: --
1486: cursor c_ok_to_do (pc3_param_name VARCHAR2) is
1487: select nvl(param_value,'Y')
1488: from XTR_pro_param
1489: where param_name = pc3_param_name;
1490: --
1491: v_ok_to_do VARCHAR2(2);
1492: v_auth VARCHAR2(1);

Line 1565: from XTR_PRO_PARAM

1561: );
1562: --
1563: cursor c_ok_to_do(pc3_param_name VARCHAR2) is
1564: select nvl(param_value,'Y')
1565: from XTR_PRO_PARAM
1566: where param_name = pc3_param_name;
1567: --
1568: cursor c_get_limit_amt(pc1_company_code VARCHAR2,pc1_limit_party VARCHAR2) is
1569: select nvl(limit_amount,0)

Line 1686: from XTR_PRO_PARAM

1682: GROUP BY cl.cparty_code, cl.company_code, sru.effective_date;
1683: --
1684: cursor c_param_val(pc3_param_name VARCHAR2) is
1685: select param_value
1686: from XTR_PRO_PARAM
1687: where param_name = pc3_param_name;
1688: --
1689: cursor c_get_limit_amt(pc1_company_code VARCHAR2,pc1_limit_party VARCHAR2) is
1690: select nvl(limit_amount,0)

Line 1763: FROM xtr_pro_param p

1759: WHERE mc.authorised = 'Y'
1760: AND (mc.net_fx_exposure <> 0 OR mc.utilised_amount <> 0)
1761: /* bug 1289530 limit check should be done for home ccy
1762: AND mc.currency <> (SELECT max(param_value)
1763: FROM xtr_pro_param p
1764: WHERE p.param_name='SYSTEM_FUNCTIONAL_CCY')
1765: bug 1289530 */
1766: AND mc.currency = p_currency;
1767: --

Line 1770: from XTR_PRO_PARAM

1766: AND mc.currency = p_currency;
1767: --
1768: cursor c_ok_to_do (pc3_param_name VARCHAR2) is
1769: select nvl(param_value,'Y')
1770: from XTR_PRO_PARAM
1771: where param_name = pc3_param_name;
1772: --
1773: v_ok_to_do VARCHAR2(2);
1774: v_auth VARCHAR2(1);