[Home] [Help]
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
98: from fa_transaction_headers
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
854: from fa_transaction_headers
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
3142: , trx.last_update_date
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
3612: , trx.transaction_date_entered
5399: , p_trans_rec.mass_transaction_id
5400: ) RETURNING transaction_header_id BULK COLLECT INTO t_thid;
5401: ELSE --Fetch all primary transaction hedaers for mrc
5402: /* Bug 10087923, there are potential errors, mismatch in transaction headers if
5403: we use bulk collect here. Better to use individual cursor
5404: */
5405: FOR ind in t_asset_id.first..l_th_count
5406: loop
5407: if(p_mode <> 'RECURR') 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 */
5596: INSERT INTO FA_TRANSACTION_HEADERS(
5597: TRANSACTION_HEADER_ID