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_MIRROR_DDA_LIMIT_ROW

Line 136: from XTR_MIRROR_DDA_LIMIT_ROW

132: -- Old utilised will only be picked up if all the variables have remained the same
133: -- ie only amount has been altered
134: cursor get_old_utilised (pc_deal_number NUMBER) is
135: select sum(nvl(hce_utilised_amount,0))
136: from XTR_MIRROR_DDA_LIMIT_ROW
137: where deal_number = pc_deal_number
138: and limit_code = p_limit_code
139: and limit_party = p_cparty_code
140: and currency = p_currency

Line 146: from XTR_MIRROR_DDA_LIMIT_ROW

142: --
143: -- bug 1687715 new cursor for ONC deals
144: cursor get_old_utilised_onc (pc_deal_number NUMBER, pc_trans_number NUMBER) is
145: select sum(nvl(hce_utilised_amount,0))
146: from XTR_MIRROR_DDA_LIMIT_ROW
147: where deal_number = pc_deal_number
148: and transaction_number = pc_trans_number
149: and limit_code = p_limit_code
150: and limit_party = p_cparty_code

Line 837: from XTR_MIRROR_DDA_LIMIT_ROW

833: where party_code = pc_party_code;
834: --
835: cursor HCE is
836: select amount,rowid row_id,DEAL_TYPE,DEAL_SUBTYPE,AMOUNT_DATE,COMPANY_CODE,CURRENCY
837: from XTR_MIRROR_DDA_LIMIT_ROW
838: for update of amount;
839: --
840: -- ER 6449996 Start
841: cursor GET_LIMIT_RELEASE_TYPE IS

Line 878: xtr_debug_pkg.debug('Before delete xtr_mirror_dda_limit_row on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

874: open CHK_UPDATE;
875: fetch CHK_UPDATE INTO l_dummy;
876: if CHK_UPDATE%FOUND or p_auto_recalc = 'Y' then
877: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
878: xtr_debug_pkg.debug('Before delete xtr_mirror_dda_limit_row on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
879: END IF;
880: delete from XTR_mirror_dda_limit_row
881: where amount_date < L_SYS_DATE
882: and deal_type not in('ONC','CA','IG', 'STOCK');

Line 880: delete from XTR_mirror_dda_limit_row

876: if CHK_UPDATE%FOUND or p_auto_recalc = 'Y' then
877: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
878: xtr_debug_pkg.debug('Before delete xtr_mirror_dda_limit_row on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
879: END IF;
880: delete from XTR_mirror_dda_limit_row
881: where amount_date < L_SYS_DATE
882: and deal_type not in('ONC','CA','IG', 'STOCK');
883: ---
884: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 885: xtr_debug_pkg.debug('After delete xtr_mirror_dda_limit_row('||to_char(sql%rowcount)||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

881: where amount_date < L_SYS_DATE
882: and deal_type not in('ONC','CA','IG', 'STOCK');
883: ---
884: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
885: xtr_debug_pkg.debug('After delete xtr_mirror_dda_limit_row('||to_char(sql%rowcount)||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
886: END IF;
887: FOR c in HCE LOOP
888: -- Calculate weighted usage for this data.
889: l_new_utilamt := XTR_LIMITS_P.WEIGHTED_USAGE(c.deal_type,c.deal_subtype,

Line 898: update XTR_mirror_dda_limit_row

894: c.company_code);
895: l_new_hce_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(c.amount,
896: c.currency,
897: c.company_code);
898: update XTR_mirror_dda_limit_row
899: set hce_amount = l_new_hce_amt,
900: hce_utilised_amount = l_new_hce_utilamt,
901: utilised_amount = l_new_utilamt
902: where rowid = c.row_id;

Line 904: xtr_debug_pkg.debug('After update xtr_mirror_dda_limit_row('||c.row_id||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

900: hce_utilised_amount = l_new_hce_utilamt,
901: utilised_amount = l_new_utilamt
902: where rowid = c.row_id;
903: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
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

Line 1049: update XTR_mirror_dda_limit_row

1045: -- X | Y | UPDATE
1046: --
1047: -- Remember: to get this far, at least one of old/new limit code is NOT null.
1048: if p_old_limit_code is null then
1049: update XTR_mirror_dda_limit_row
1050: set PRODUCT_TYPE =p_new_product_type,
1051: COMPANY_CODE = p_new_COMPANY_CODE,
1052: LIMIT_CODE =p_new_LIMIT_CODE,
1053: LIMIT_PARTY =p_new_LIMIT_PARTY,

Line 1079: insert into XTR_mirror_dda_limit_row

1075: where deal_number = p_new_deal_number
1076: and transaction_number = p_new_transaction_number ;
1077: --
1078: if SQL%NOTFOUND then -- No row was updated.
1079: insert into XTR_mirror_dda_limit_row
1080: (COMPANY_CODE,LIMIT_CODE,LIMIT_PARTY,AMOUNT_DATE,AMOUNT,
1081: HCE_AMOUNT,DEALER_CODE,COUNTRY_CODE,DEAL_NUMBER,DEAL_TYPE,
1082: TRANSACTION_NUMBER,DEAL_SUBTYPE,PORTFOLIO_CODE,STATUS_CODE,
1083: UTILISED_AMOUNT,PRODUCT_TYPE,DATE_LAST_SET,HCE_UTILISED_AMOUNT,CURRENCY,

Line 1095: delete from XTR_mirror_dda_limit_row

1091: v_amount_indic,p_transaction_rate,v_contra_ccy,p_currency_combination,p_account_no,
1092: l_commence_date,v_group_party,v_limit_type);
1093: end if;
1094: elsif p_new_limit_code is null then
1095: delete from XTR_mirror_dda_limit_row
1096: where deal_number = p_old_deal_number
1097: and transaction_number = p_old_transaction_NUMBER;
1098: else -- same as: elsif p_old_limit_code is NOT null and p_new_limit_code is NOT null then
1099: update XTR_mirror_dda_limit_row

Line 1099: update XTR_mirror_dda_limit_row

1095: delete from XTR_mirror_dda_limit_row
1096: where deal_number = p_old_deal_number
1097: and transaction_number = p_old_transaction_NUMBER;
1098: else -- same as: elsif p_old_limit_code is NOT null and p_new_limit_code is NOT null then
1099: update XTR_mirror_dda_limit_row
1100: set PRODUCT_TYPE =p_new_product_type,
1101: COMPANY_CODE = p_new_COMPANY_CODE,
1102: LIMIT_CODE =p_new_LIMIT_CODE,
1103: LIMIT_PARTY =p_new_LIMIT_PARTY,

Line 1129: insert into XTR_mirror_dda_limit_row

1125: where deal_number = p_new_deal_number
1126: and transaction_number = p_new_transaction_number ;
1127: --
1128: if SQL%NOTFOUND then -- No row was updated.
1129: insert into XTR_mirror_dda_limit_row
1130: (COMPANY_CODE,LIMIT_CODE,LIMIT_PARTY,AMOUNT_DATE,AMOUNT,
1131: HCE_AMOUNT,DEALER_CODE,COUNTRY_CODE,DEAL_NUMBER,DEAL_TYPE,
1132: TRANSACTION_NUMBER,DEAL_SUBTYPE,PORTFOLIO_CODE,STATUS_CODE,
1133: UTILISED_AMOUNT,PRODUCT_TYPE,DATE_LAST_SET,HCE_UTILISED_AMOUNT,CURRENCY,

Line 1148: insert into XTR_mirror_dda_limit_row

1144: end if;
1145: ----------------------------------------------
1146: elsif p_action = 'INSERT' then
1147:
1148: insert into XTR_mirror_dda_limit_row
1149: (COMPANY_CODE,LIMIT_CODE,LIMIT_PARTY,AMOUNT_DATE,AMOUNT,
1150: HCE_AMOUNT,DEALER_CODE,COUNTRY_CODE,DEAL_NUMBER,DEAL_TYPE,
1151: TRANSACTION_NUMBER,DEAL_SUBTYPE,PORTFOLIO_CODE,STATUS_CODE,
1152: UTILISED_AMOUNT,PRODUCT_TYPE,DATE_LAST_SET,HCE_UTILISED_AMOUNT,CURRENCY,

Line 1164: delete from XTR_mirror_dda_limit_row

1160: v_amount_indic,p_transaction_rate,v_contra_ccy,p_currency_combination,p_account_no,
1161: l_commence_date,v_group_party,v_limit_type);
1162: -----------------------------------------------------------------------------------------
1163: elsif p_action = 'DELETE' then
1164: delete from XTR_mirror_dda_limit_row
1165: where deal_number = p_old_deal_number
1166: and transaction_number = p_old_transaction_number ;
1167: end if;
1168: end;

Line 1415: from XTR_mirror_dda_limit_row

1411: p_err_code OUT NOCOPY VARCHAR2) is
1412: --
1413: cursor c_get_util (pc1_dealer_code VARCHAR2, pc1_deal_type VARCHAR2) is
1414: select nvl(sum(decode(deal_subtype,'BUY',HCE_AMOUNT,'SELL',-HCE_AMOUNT,0)),0)
1415: from XTR_mirror_dda_limit_row
1416: where dealer_code = pc1_dealer_code
1417: and deal_type = pc1_deal_type;
1418: --
1419: cursor c_get_limit (pc2_dealer_code VARCHAR2, pc2_deal_type VARCHAR2) is

Line 1432: v_used_amt XTR_MIRROR_DDA_LIMIT_ROW.utilised_amount%TYPE;

1428: where param_name = pc3_param_name;
1429: --
1430: v_ok_to_do VARCHAR2(2);
1431: v_auth XTR_DEALER_LIMITS.authorised%TYPE;
1432: v_used_amt XTR_MIRROR_DDA_LIMIT_ROW.utilised_amount%TYPE;
1433: begin
1434: -- this is not called at this stage
1435: null;
1436: /*

Line 1819: -- from XTR_MIRROR_DDA_LIMIT_ROW_V

1815: ---commit;
1816: end;
1817: ---------------------------------------------------------------
1818: -- Procedure to update all limits table with the most up-to-date information
1819: -- from XTR_MIRROR_DDA_LIMIT_ROW_V
1820: PROCEDURE reinitialize_limits (
1821: errbuf OUT NOCOPY VARCHAR2,
1822: retcode OUT NOCOPY NUMBER) IS
1823: BEGIN

Line 1855: from xtr_MIRROR_DDA_LIMIT_ROW_V;

1851: DEAL_SUBTYPE,PORTFOLIO_CODE,STATUS_CODE,CURRENCY,
1852: UTILISED_AMOUNT,HCE_UTILISED_AMOUNT,CROSS_REF_TO_OTHER_PARTY,
1853: LIMIT_TYPE,COMMENCE_DATE,CURRENCY_COMBINATION,CONTRA_CCY,
1854: TRANSACTION_RATE,AMOUNT_INDIC,ACCOUNT_NO
1855: from xtr_MIRROR_DDA_LIMIT_ROW_V;
1856: --
1857: delete from xtr_MIRROR_DDA_LIM_ROW_TMP_V;
1858: END reinitialize_limits;
1859: ---------------------------------------------------------------