[Home] [Help]
223: lv_dist_trans_rec FA_API_TYPES.trans_rec_type;
224: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
225: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
226:
227: -- local individual variables
228: l_transaction_type varchar2(30) := null;
229: l_reporting_flag varchar2(1);
230: l_retirement_id number(15);
231: l_calculate_gain_loss_flag varchar2(1);
1239: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1240:
1241: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1242:
1243: -- local individual variables
1244: l_latest_trans_date date;
1245: l_ret_prorate_date date;
1246: l_prorate_calendar varchar2(15);
1247: l_fiscal_year_name varchar2(30);
1616: /*Bug#8289173 - to fetch transaction_header_id and retirement_id for the RETIREMENT row
1617: to not rely on table handler (for consistency)*/
1618: select fa_transaction_headers_s.nextval
1619: into l_trans_rec.transaction_header_id
1620: from dual;
1621:
1622: select fa_retirements_s.nextval
1623: into l_asset_retire_rec.retirement_id
1624: from dual;
1620: from dual;
1621:
1622: select fa_retirements_s.nextval
1623: into l_asset_retire_rec.retirement_id
1624: from dual;
1625: /*Bug#8289173 - end*/
1626:
1627: -- Bug 15877517 : Reinitialize who_info as well
1628: l_trans_rec.who_info.creation_date := sysdate;
2025:
2026: --Need this for selection_thid
2027: SELECT fa_transaction_headers_s.nextval
2028: into l_dist_trans_rec.transaction_header_id /* 3513319 */
2029: FROM dual; /* Do we need this ???? dist th_id is initialized again below */
2030:
2031: -- Bug 15877517 : Reinitialize who_info as well
2032: l_dist_trans_rec.who_info.creation_date := sysdate;
2033: l_dist_trans_rec.who_info.last_update_date := sysdate;
2111: end if;
2112:
2113: SELECT fa_transaction_headers_s.nextval
2114: into l_dist_trans_rec.transaction_header_id
2115: FROM dual;
2116:
2117: -- Bug 15877517 : Reinitialize who_info as well
2118: l_dist_trans_rec.who_info.creation_date := sysdate;
2119: l_dist_trans_rec.who_info.last_update_date := sysdate;
5004: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5005: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5006: l_period_rec FA_API_TYPES.period_rec_type;
5007:
5008: -- local individual variables
5009: l_latest_trans_date date;
5010:
5011: -- local conversion rate
5012: l_exchange_date date;
5114:
5115: -- Pop the transaction_header_id for the REINSTATEMENT row
5116: select fa_transaction_headers_s.nextval
5117: into l_trans_rec.transaction_header_id
5118: from dual;
5119:
5120: -- Bug 15877517 : Reinitialize who_info as well
5121: l_trans_rec.who_info.creation_date := sysdate;
5122: l_trans_rec.who_info.last_update_date := sysdate;