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_PVT dependencies on FA_TRANSACTION_HEADERS

Line 78: select fa_transaction_headers_s.nextval

74: and period_counter_fully_retired is null
75: and transaction_header_id_out is null;
76:
77: CURSOR c_get_thid is
78: select fa_transaction_headers_s.nextval
79: from dual;
80:
81: CURSOR c_get_primary_thid is
82: select transaction_header_id

Line 83: from fa_transaction_headers

79: from dual;
80:
81: CURSOR c_get_primary_thid is
82: select transaction_header_id
83: from fa_transaction_headers
84: where asset_id = p_asset_fin_rec.group_asset_id
85: and book_type_code = p_asset_hdr_rec.book_type_code
86: and member_transaction_header_id = p_trans_rec.transaction_header_id;
87:

Line 90: l_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE;

86: and member_transaction_header_id = p_trans_rec.transaction_header_id;
87:
88: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.do_retirement';
89:
90: l_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE;
91:
92: l_asset_desc_rec_m FA_API_TYPES.asset_desc_rec_type;
93: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
94: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 637: from fa_transaction_headers

633: return boolean IS
634:
635: CURSOR c_get_thid IS
636: select transaction_header_id
637: from fa_transaction_headers
638: where asset_id = p_group_asset_id
639: and book_type_code = p_asset_hdr_rec.book_type_code
640: and member_transaction_header_id = p_transaction_header_id;
641:

Line 780: select fa_transaction_headers_s.nextval

776: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
777:
778:
779: CURSOR c_get_thid is
780: select fa_transaction_headers_s.nextval
781: from dual;
782:
783: CURSOR c_get_primary_thid is
784: select transaction_header_id

Line 785: from fa_transaction_headers

781: from dual;
782:
783: CURSOR c_get_primary_thid is
784: select transaction_header_id
785: from fa_transaction_headers
786: where asset_id = p_asset_fin_rec.group_asset_id
787: and book_type_code = p_asset_hdr_rec.book_type_code
788: and member_transaction_header_id = p_trans_rec.transaction_header_id;
789:

Line 2218: FROM fa_transaction_headers

2214: CURSOR c_get_group_thid IS
2215: SELECT transaction_header_id,
2216: asset_id,
2217: date_effective
2218: FROM fa_transaction_headers
2219: WHERE member_transaction_header_id =
2220: p_asset_retire_rec.detail_info.transaction_header_id_in
2221: AND asset_id = p_asset_fin_rec.group_asset_id
2222: AND book_type_code = p_asset_hdr_rec.book_type_code;

Line 2859: select fa_transaction_headers_s.nextval

2855: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
2856: return boolean IS
2857:
2858: CURSOR c_get_thid is
2859: select fa_transaction_headers_s.nextval
2860: from dual;
2861:
2862: /* Bug - 7011548 Cursor Added to fetch Current value of the Sequence for MRC book.
2863: Earlier the Transaction_Header_id was missing for MRC Book. For MRC it

Line 2867: select fa_transaction_headers_s.currval

2863: Earlier the Transaction_Header_id was missing for MRC Book. For MRC it
2864: is the Current Value of the Sequence.
2865: */
2866: CURSOR c_get_thid_mrc is
2867: select fa_transaction_headers_s.currval
2868: from dual;
2869:
2870: CURSOR c_get_thx is
2871: select trx.transaction_date_entered

Line 2879: from fa_transaction_headers trx

2875: , trx.mass_transaction_id
2876: , trx.calling_interface
2877: , trx.mass_reference_id
2878: , nvl(trx.amortization_start_date, trx.transaction_date_entered)
2879: from fa_transaction_headers trx
2880: where trx.transaction_header_id = p_ret.th_id_in;
2881:
2882: CURSOR c_member_exists IS
2883: select 'Y'

Line 3428: select fa_transaction_headers_s.nextval

3424: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
3425: return boolean IS
3426:
3427: CURSOR c_get_thid is
3428: select fa_transaction_headers_s.nextval
3429: from dual;
3430:
3431: CURSOR c_get_thx is
3432: select trx.transaction_header_id

Line 3442: , fa_transaction_headers trx

3438: , trx.calling_interface
3439: , trx.mass_reference_id
3440: , nvl(trx.amortization_start_date, trx.transaction_date_entered)
3441: from fa_retirements ret
3442: , fa_transaction_headers trx
3443: where ret.retirement_id = p_ret.retirement_id
3444: and ret.transaction_header_id_out = trx.transaction_header_id;
3445:
3446: l_calling_fn VARCHAR2(100) := 'fa_retirement_pvt.Do_Reinstatement_in_CGL';

Line 3692: from fa_transaction_headers gth,

3688: and transaction_header_id_out is null;
3689:
3690: cursor c_max_ret_thid is
3691: select max(gth.transaction_header_id)
3692: from fa_transaction_headers gth,
3693: fa_transaction_headers mth,
3694: fa_retirements ret,
3695: fa_books bk
3696: where bk.group_asset_id = p_asset_id

Line 3693: fa_transaction_headers mth,

3689:
3690: cursor c_max_ret_thid is
3691: select max(gth.transaction_header_id)
3692: from fa_transaction_headers gth,
3693: fa_transaction_headers mth,
3694: fa_retirements ret,
3695: fa_books bk
3696: where bk.group_asset_id = p_asset_id
3697: and bk.book_type_code = p_book_type_code

Line 3717: from fa_transaction_headers gth,

3713: and transaction_header_id_out is null;
3714:
3715: cursor c_max_mc_ret_thid is
3716: select max(gth.transaction_header_id)
3717: from fa_transaction_headers gth,
3718: fa_transaction_headers mth,
3719: fa_retirements_mrc_v ret,
3720: fa_books_mrc_v bk
3721: where bk.group_asset_id = p_asset_id

Line 3718: fa_transaction_headers mth,

3714:
3715: cursor c_max_mc_ret_thid is
3716: select max(gth.transaction_header_id)
3717: from fa_transaction_headers gth,
3718: fa_transaction_headers mth,
3719: fa_retirements_mrc_v ret,
3720: fa_books_mrc_v bk
3721: where bk.group_asset_id = p_asset_id
3722: and bk.book_type_code = p_book_type_code

Line 4462: from fa_transaction_headers th -- member

4458: , ad.current_units
4459: , ad.asset_category_id
4460: , bk.adjusted_recoverable_cost
4461: , sum(aj.adjustment_amount)
4462: from fa_transaction_headers th -- member
4463: , fa_transaction_headers gth -- group
4464: , fa_adjustments aj
4465: , fa_deprn_periods dp
4466: , fa_additions_b ad

Line 4463: , fa_transaction_headers gth -- group

4459: , ad.asset_category_id
4460: , bk.adjusted_recoverable_cost
4461: , sum(aj.adjustment_amount)
4462: from fa_transaction_headers th -- member
4463: , fa_transaction_headers gth -- group
4464: , fa_adjustments aj
4465: , fa_deprn_periods dp
4466: , fa_additions_b ad
4467: , fa_books bk

Line 4718: INSERT INTO FA_TRANSACTION_HEADERS(

4714:
4715: l_loc := 'Before Insert TH';
4716:
4717: FORALL i in t_asset_id.first..t_asset_id.last
4718: INSERT INTO FA_TRANSACTION_HEADERS(
4719: TRANSACTION_HEADER_ID
4720: , BOOK_TYPE_CODE
4721: , ASSET_ID
4722: , TRANSACTION_TYPE_CODE

Line 4736: FA_TRANSACTION_HEADERS_S.NEXTVAL

4732: , AMORTIZATION_START_DATE
4733: , CALLING_INTERFACE
4734: , MASS_TRANSACTION_ID
4735: ) VALUES (
4736: FA_TRANSACTION_HEADERS_S.NEXTVAL
4737: , p_asset_hdr_rec.book_type_code
4738: , t_asset_id(i)
4739: , 'ADJUSTMENT'
4740: , p_trans_rec.transaction_date_entered