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_RETIREMENT_PUB dependencies on DUAL

Line 225: -- local individual variables

221: lv_dist_trans_rec FA_API_TYPES.trans_rec_type;
222: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
223: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
224:
225: -- local individual variables
226: l_transaction_type varchar2(30) := null;
227: l_reporting_flag varchar2(1);
228: l_retirement_id number(15);
229: l_calculate_gain_loss_flag varchar2(1);

Line 1086: -- local individual variables

1082: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1083:
1084: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1085:
1086: -- local individual variables
1087: l_latest_trans_date date;
1088: l_ret_prorate_date date;
1089: l_prorate_calendar varchar2(15);
1090: l_fiscal_year_name varchar2(30);

Line 1460: from dual;

1456:
1457: -- Pop the transaction_header_id for the RETIREMENT row
1458: select fa_transaction_headers_s.nextval
1459: into l_trans_rec.transaction_header_id
1460: from dual;
1461:
1462: /* Bug# 4370014: Direct fetch for THID, RETID */
1463: select fa_retirements_s.nextval
1464: into l_asset_retire_rec.retirement_id

Line 1465: from dual;

1461:
1462: /* Bug# 4370014: Direct fetch for THID, RETID */
1463: select fa_retirements_s.nextval
1464: into l_asset_retire_rec.retirement_id
1465: from dual;
1466:
1467:
1468: -- SLA UPTAKE
1469: -- assign an event for the transaction

Line 1830: FROM dual;

1826:
1827: --Need this for selection_thid
1828: SELECT fa_transaction_headers_s.nextval
1829: into l_dist_trans_rec.transaction_header_id /* 3513319 */
1830: FROM dual;
1831:
1832: if (l_asset_fin_rec.group_asset_id is not null) and
1833: (l_asset_retire_rec.recognize_gain_loss = 'NO') then
1834:

Line 4684: -- local individual variables

4680: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
4681: l_inv_tbl FA_API_TYPES.inv_tbl_type;
4682: l_period_rec FA_API_TYPES.period_rec_type;
4683:
4684: -- local individual variables
4685: l_latest_trans_date date;
4686:
4687: -- local conversion rate
4688: l_exchange_date date;

Line 4796: from dual;

4792:
4793: -- Pop the transaction_header_id for the REINSTATEMENT row
4794: select fa_transaction_headers_s.nextval
4795: into l_trans_rec.transaction_header_id
4796: from dual;
4797:
4798: -- SLA UPTAKE
4799: -- moving original event creation into do_sub_regular_reinstatement
4800: