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.FTP_IRC_ADI_MIGRATE dependencies on FTP_IRC_ADI_PARAM_T

Line 31: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.EFFECTIVE_DATE%TYPE;

27: p_int_rate_code IN NUMBER
28: )
29: IS
30:
31: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.EFFECTIVE_DATE%TYPE;
32: TYPE t_mean_rev_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.MEAN_REVERSION_SPEED%TYPE;
33: TYPE t_long_rr_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.LONG_RUN_RATE%TYPE;
34: TYPE t_vol_merton_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_MERTON%TYPE;
35: TYPE t_vol_vasicek_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_VASICEK%TYPE;

Line 32: TYPE t_mean_rev_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.MEAN_REVERSION_SPEED%TYPE;

28: )
29: IS
30:
31: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.EFFECTIVE_DATE%TYPE;
32: TYPE t_mean_rev_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.MEAN_REVERSION_SPEED%TYPE;
33: TYPE t_long_rr_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.LONG_RUN_RATE%TYPE;
34: TYPE t_vol_merton_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_MERTON%TYPE;
35: TYPE t_vol_vasicek_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_VASICEK%TYPE;
36:

Line 33: TYPE t_long_rr_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.LONG_RUN_RATE%TYPE;

29: IS
30:
31: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.EFFECTIVE_DATE%TYPE;
32: TYPE t_mean_rev_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.MEAN_REVERSION_SPEED%TYPE;
33: TYPE t_long_rr_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.LONG_RUN_RATE%TYPE;
34: TYPE t_vol_merton_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_MERTON%TYPE;
35: TYPE t_vol_vasicek_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_VASICEK%TYPE;
36:
37: l_eff_date_tbl t_eff_date_tbl;

Line 34: TYPE t_vol_merton_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_MERTON%TYPE;

30:
31: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.EFFECTIVE_DATE%TYPE;
32: TYPE t_mean_rev_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.MEAN_REVERSION_SPEED%TYPE;
33: TYPE t_long_rr_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.LONG_RUN_RATE%TYPE;
34: TYPE t_vol_merton_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_MERTON%TYPE;
35: TYPE t_vol_vasicek_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_VASICEK%TYPE;
36:
37: l_eff_date_tbl t_eff_date_tbl;
38: l_mean_rev_tbl t_mean_rev_tbl;

Line 35: TYPE t_vol_vasicek_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_VASICEK%TYPE;

31: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.EFFECTIVE_DATE%TYPE;
32: TYPE t_mean_rev_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.MEAN_REVERSION_SPEED%TYPE;
33: TYPE t_long_rr_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.LONG_RUN_RATE%TYPE;
34: TYPE t_vol_merton_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_MERTON%TYPE;
35: TYPE t_vol_vasicek_tbl IS TABLE OF FTP_IRC_ADI_PARAM_T.VOLATILITY_VASICEK%TYPE;
36:
37: l_eff_date_tbl t_eff_date_tbl;
38: l_mean_rev_tbl t_mean_rev_tbl;
39: l_long_rr_tbl t_long_rr_tbl;

Line 57: from FTP_IRC_ADI_PARAM_T where

53: select EFFECTIVE_DATE,MEAN_REVERSION_SPEED,
54: LONG_RUN_RATE,VOLATILITY_MERTON,VOLATILITY_VASICEK
55: bulk collect into l_eff_date_tbl,l_mean_rev_tbl,l_long_rr_tbl,
56: l_vol_merton_tbl,l_vol_vasicek_tbl
57: from FTP_IRC_ADI_PARAM_T where
58: INTEREST_RATE_CODE = p_int_rate_code;
59:
60: FOR i in 1..l_mean_rev_tbl.COUNT LOOP
61: BEGIN

Line 81: update FTP_IRC_ADI_PARAM_T set STATUS ='INSERT'

77: VALUES(l_eff_date_tbl(i),p_int_rate_code,l_mean_rev_tbl(i),l_long_rr_tbl(i),
78: l_vol_merton_tbl(i),l_vol_vasicek_tbl(i),1,1,sysdate,sysdate,1,1,sysdate);
79:
80: --Karen added for testing
81: update FTP_IRC_ADI_PARAM_T set STATUS ='INSERT'
82: where EFFECTIVE_DATE = l_eff_date_tbl(i)
83: AND INTEREST_RATE_CODE = p_int_rate_code;
84: ELSE
85: -- it has updated. so set the status to UPDATE

Line 87: update FTP_IRC_ADI_PARAM_T set STATUS ='UPDATE'

83: AND INTEREST_RATE_CODE = p_int_rate_code;
84: ELSE
85: -- it has updated. so set the status to UPDATE
86: --Karen added for testing
87: update FTP_IRC_ADI_PARAM_T set STATUS ='UPDATE'
88: where EFFECTIVE_DATE = l_eff_date_tbl(i)
89: AND INTEREST_RATE_CODE = p_int_rate_code;
90:
91: END IF;

Line 96: update FTP_IRC_ADI_PARAM_T set STATUS ='FTP_PARAM_MIGRATE_ERR' where EFFECTIVE_DATE = l_eff_date_tbl(i)

92: EXCEPTION
93: when others then
94: --Karen added
95: --set status to 'F'
96: update FTP_IRC_ADI_PARAM_T set STATUS ='FTP_PARAM_MIGRATE_ERR' where EFFECTIVE_DATE = l_eff_date_tbl(i)
97: AND INTEREST_RATE_CODE = p_int_rate_code;
98:
99: --put message on the message stack for calling program to handle
100: FEM_ENGINES_PKG.Put_Message(

Line 161: DELETE FROM FTP_IRC_ADI_PARAM_T WHERE

157: p_module => l_block||'.interest_rate_code',
158: p_msg_text => p_int_rate_code
159: );
160:
161: DELETE FROM FTP_IRC_ADI_PARAM_T WHERE
162: INTEREST_RATE_CODE = p_int_rate_code and STATUS IN ('INSERT','UPDATE');
163:
164: FEM_ENGINES_PKG.TECH_MESSAGE(
165: p_severity => c_log_level_2,