APPS.FTP_IRC_ADI_MIGRATE dependencies on FTP_IRC_ADI_RATE_T

Line 219: TYPE t_int_rates_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.INTEREST_RATE1%TYPE;

215: l_int_term FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;
216: l_int_mult FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;
217: l_indx NUMBER;
218:
219: TYPE t_int_rates_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.INTEREST_RATE1%TYPE;
220: TYPE t_int_terms_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;
221: TYPE t_int_mults_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;
222: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.EFFECTIVE_DATE%TYPE;
223:

Line 222: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.EFFECTIVE_DATE%TYPE;

218:
219: TYPE t_int_rates_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.INTEREST_RATE1%TYPE;
220: TYPE t_int_terms_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;
221: TYPE t_int_mults_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;
222: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.EFFECTIVE_DATE%TYPE;
223:
224: l_int_rates_tbl t_int_rates_tbl;
225: l_int_terms_tbl t_int_terms_tbl;
226: l_int_mults_tbl t_int_mults_tbl;

Line 294: from FTP_IRC_ADI_RATE_T, TABLE(FTP_MULTI_TABLE_F())

290: 93,INTEREST_RATE93, 94,INTEREST_RATE94,
291: 95,INTEREST_RATE95, 96,INTEREST_RATE96, 97,INTEREST_RATE97,
292: 98,INTEREST_RATE98, 99,INTEREST_RATE99, 100,INTEREST_RATE100
293: ) int_rate
294: from FTP_IRC_ADI_RATE_T, TABLE(FTP_MULTI_TABLE_F())
295: --Bobby20050719 - Interest rate should be in the same order as it interface table - Bug 4494361
296: where INTEREST_RATE_CODE = p_int_rate_code order by EFFECTIVE_DATE,COLUMN_VALUE )
297: where INT_RATE is not null;
298:

Line 332: update FTP_IRC_ADI_RATE_T set STATUS ='INSERT'

328: values(l_eff_date_tbl(i),p_int_rate_code,l_int_term,
329: l_int_mult,l_int_rates_tbl(i),1,sysdate,sysdate,1,1,sysdate );
330:
331: --Karen added for testing
332: update FTP_IRC_ADI_RATE_T set STATUS ='INSERT'
333: where EFFECTIVE_DATE = l_eff_date_tbl(i)
334: AND INTEREST_RATE_CODE = p_int_rate_code;
335: ELSE
336: -- it has updated. so set the status to UPDATE

Line 338: update FTP_IRC_ADI_RATE_T set STATUS ='UPDATE'

334: AND INTEREST_RATE_CODE = p_int_rate_code;
335: ELSE
336: -- it has updated. so set the status to UPDATE
337: --Karen added for testing
338: update FTP_IRC_ADI_RATE_T set STATUS ='UPDATE'
339: where EFFECTIVE_DATE = l_eff_date_tbl(i)
340: AND INTEREST_RATE_CODE = p_int_rate_code;
341: END IF;
342: EXCEPTION

Line 407: DELETE FROM FTP_IRC_ADI_RATE_T WHERE INTEREST_RATE_CODE = p_int_rate_code and

403: p_module => l_block||'.interest_rate_code',
404: p_msg_text => p_int_rate_code
405: );
406:
407: DELETE FROM FTP_IRC_ADI_RATE_T WHERE INTEREST_RATE_CODE = p_int_rate_code and
408: STATUS IN ('INSERT','UPDATE');
409:
410: FEM_ENGINES_PKG.TECH_MESSAGE(
411: p_severity => c_log_level_2,