DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PVT dependencies on FA_TRANSACTION_HEADERS_S

Line 93: select fa_transaction_headers_s.nextval

89: and adjusted_cost <> 0
90: );
91:
92: CURSOR c_get_thid is
93: select fa_transaction_headers_s.nextval
94: from dual;
95:
96: CURSOR c_get_primary_thid is
97: select transaction_header_id

Line 849: select fa_transaction_headers_s.nextval

845: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
846:
847:
848: CURSOR c_get_thid is
849: select fa_transaction_headers_s.nextval
850: from dual;
851:
852: CURSOR c_get_primary_thid is
853: select transaction_header_id

Line 3137: select fa_transaction_headers_s.nextval

3133: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
3134: return boolean IS
3135:
3136: CURSOR c_get_thid is
3137: select fa_transaction_headers_s.nextval
3138: from dual;
3139:
3140: CURSOR c_get_thx is
3141: select trx.transaction_date_entered

Line 3607: select fa_transaction_headers_s.nextval

3603: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
3604: return boolean IS
3605:
3606: CURSOR c_get_thid is
3607: select fa_transaction_headers_s.nextval
3608: from dual;
3609:
3610: CURSOR c_get_thx is
3611: select trx.transaction_header_id

Line 5384: FA_TRANSACTION_HEADERS_S.NEXTVAL

5380: , AMORTIZATION_START_DATE
5381: , CALLING_INTERFACE
5382: , MASS_TRANSACTION_ID
5383: ) VALUES (
5384: FA_TRANSACTION_HEADERS_S.NEXTVAL
5385: , p_asset_hdr_rec.book_type_code
5386: , t_asset_id(i)
5387: , 'ADJUSTMENT'
5388: , p_trans_rec.transaction_date_entered

Line 5591: select FA_TRANSACTION_HEADERS_S.NEXTVAL

5587:
5588: IF (p_mrc_sob_type_code <> 'R') THEN
5589: --Bug 9076882. No need to insert transaction for MRC.This is already fethced above using c_thids cursor
5590:
5591: select FA_TRANSACTION_HEADERS_S.NEXTVAL
5592: into t_thid(i)
5593: from dual;
5594:
5595: /* Insert record into fa_transaction_headers */