APPS.FA_RETIREMENT_PVT dependencies on FA_TRANSACTION_HEADERS_S

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 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 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 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 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