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.FA_PROCESS_IMPAIRMENT_PKG dependencies on FA_MC_IMPAIRMENTS

Line 633: UPDATE FA_MC_IMPAIRMENTS imp

629: -- ************* *****************
630: -- ************
631: --8666930
632: if l_mrc_sob_type_code = 'R' then
633: UPDATE FA_MC_IMPAIRMENTS imp
634: SET imp.STATUS = l_internal_mode
635: , imp.REQUEST_ID = l_request_id
636: , imp.PERIOD_COUNTER_IMPAIRED = l_period_rec.PERIOD_COUNTER
637: WHERE imp.SET_OF_BOOKS_ID = l_set_of_books_id

Line 663: UPDATE FA_MC_IMPAIRMENTS imp

659:
660: elsif p_mode = 'ROLLBACK' then
661: --8666930
662: if l_mrc_sob_type_code = 'R' then
663: UPDATE FA_MC_IMPAIRMENTS imp
664: SET imp.STATUS = l_internal_mode
665: , imp.REQUEST_ID = l_request_id
666: , imp.PERIOD_COUNTER_IMPAIRED = l_period_rec.PERIOD_COUNTER
667: WHERE imp.SET_OF_BOOKS_ID = l_set_of_books_id

Line 898: UPDATE FA_MC_IMPAIRMENTS

894: l_set_of_books_id := l_sob_tbl(l_sob_index);
895: end if;
896: /* bug #6658765 - added if condition*/
897: if l_mrc_sob_type_code = 'R' then
898: UPDATE FA_MC_IMPAIRMENTS
899: SET STATUS = l_internal_mode
900: WHERE REQUEST_ID = l_request_id
901: AND PERIOD_COUNTER_IMPAIRED = l_imp_period_rec.period_counter
902: AND SET_OF_BOOKS_ID = l_set_of_books_id;

Line 905: UPDATE FA_MC_IMPAIRMENTS IMP

901: AND PERIOD_COUNTER_IMPAIRED = l_imp_period_rec.period_counter
902: AND SET_OF_BOOKS_ID = l_set_of_books_id;
903:
904: --Bug# 7045739 start to update status to Deprn Failed if multiple rows are uploaded.
905: UPDATE FA_MC_IMPAIRMENTS IMP
906: SET STATUS='RUNNING DEPRN FAILED'
907: WHERE REQUEST_ID = l_request_id
908: AND SET_OF_BOOKS_ID = l_set_of_books_id
909: AND IMPAIRMENT_ID IN

Line 1208: insert into fa_mc_impairments(

1204:
1205:
1206: -- round values
1207:
1208: insert into fa_mc_impairments(
1209: IMPAIRMENT_ID
1210: , IMPAIRMENT_NAME
1211: , DESCRIPTION
1212: , REQUEST_ID

Line 1290: from fa_impairments -- 8666930 changed to fa_impairments from fa_mc_impairments

1286: , SPLIT3_IMPAIR_CLASS
1287: , SPLIT3_REASON
1288: , SPLIT3_PERCENT
1289: , SPLIT3_LOSS_ACCT -- End of Bug 6666666
1290: from fa_impairments -- 8666930 changed to fa_impairments from fa_mc_impairments
1291: where request_id = p_request_id
1292: and book_type_code = p_book_type_code
1293: and PERIOD_COUNTER_IMPAIRED = p_period_rec.period_counter
1294: -- and set_of_books_id = p_set_of_books_id --8666930 commented

Line 1308: from fa_mc_books bk , fa_mc_impairments imp

1304: delete from fa_mc_itf_impairments itmp
1305: where set_of_books_id = p_set_of_books_id
1306: and exists
1307: (select 'Uploaded impairment'
1308: from fa_mc_books bk , fa_mc_impairments imp
1309: where imp.book_type_code = p_book_type_code
1310: and imp.status = l_mode
1311: and imp.request_id = p_request_id
1312: and imp.set_of_books_id = p_set_of_books_id

Line 1398: , fa_mc_impairments imp

1394: , imp.SPLIT3_REASON
1395: , imp.SPLIT3_PERCENT
1396: , imp.SPLIT3_LOSS_ACCT -- End of Bug 6666666
1397: from fa_mc_books bk
1398: , fa_mc_impairments imp
1399: where imp.book_type_code = p_book_type_code
1400: and imp.status = l_mode
1401: and imp.request_id = p_request_id
1402: and imp.set_of_books_id = p_set_of_books_id

Line 1432: from fa_mc_books bk , fa_mc_impairments imp

1428: delete from fa_mc_itf_impairments itmp
1429: where set_of_books_id = p_set_of_books_id
1430: and exists
1431: (select 'Uploaded impairment'
1432: from fa_mc_books bk , fa_mc_impairments imp
1433: where imp.book_type_code = p_book_type_code
1434: and imp.status = l_mode
1435: and imp.request_id = p_request_id
1436: and imp.set_of_books_id = p_set_of_books_id

Line 1522: , fa_mc_impairments imp

1518: , imp.SPLIT3_REASON
1519: , imp.SPLIT3_PERCENT
1520: , imp.SPLIT3_LOSS_ACCT -- End of Bug 6666666
1521: from fa_mc_books bk
1522: , fa_mc_impairments imp
1523: where imp.book_type_code = p_book_type_code
1524: and imp.status = l_mode
1525: and imp.request_id = p_request_id
1526: and imp.set_of_books_id = p_set_of_books_id

Line 1977: update fa_mc_impairments

1973: where status = l_status
1974: and request_id = p_request_id;
1975:
1976: if p_mrc_sob_type_code = 'R' then /* Bug 6437003 added condition to check for set of books type code*/
1977: update fa_mc_impairments
1978: set status = l_new_status
1979: where status = l_status
1980: and request_id = p_request_id
1981: and set_of_books_id = p_set_of_books_id;