194: t_tx_error_transaction_id t_transaction_id;
195: t_tx_error_status t_status;
196: t_tx_error_exception t_exception_description;
197:
198: g_transaction_id hxc_transactions.transaction_id%TYPE;
199: g_retrieval_process_id hxc_transactions.transaction_process_id%TYPE;
200: g_retrieval_tr_id hxc_time_recipients.time_recipient_id%TYPE;
201:
202: g_lock_type varchar2(35);
195: t_tx_error_status t_status;
196: t_tx_error_exception t_exception_description;
197:
198: g_transaction_id hxc_transactions.transaction_id%TYPE;
199: g_retrieval_process_id hxc_transactions.transaction_process_id%TYPE;
200: g_retrieval_tr_id hxc_time_recipients.time_recipient_id%TYPE;
201:
202: g_lock_type varchar2(35);
203:
209: G_LAST_CHUNK BOOLEAN := FALSE;
210: G_NO_TIMECARDS BOOLEAN := TRUE;
211: G_OVERALL_NO_TIMECARDS BOOLEAN := TRUE;
212: G_CHUNK_NUMBER NUMBER := 0;
213: G_TRANS_CODE hxc_transactions.transaction_code%TYPE;
214: G_TRANS_PREFIX varchar2(11);
215:
216: -- new globals for skipped records
217:
244: , p_since_date in VARCHAR2 default null
245: );
246:
247: Procedure Update_Transaction_Status ( p_process hxc_retrieval_processes.name%TYPE
248: , p_status hxc_transactions.status%TYPE
249: , p_exception_description hxc_transactions.exception_description%TYPE
250: , p_rollback BOOLEAN DEFAULT FALSE );
251:
252:
245: );
246:
247: Procedure Update_Transaction_Status ( p_process hxc_retrieval_processes.name%TYPE
248: , p_status hxc_transactions.status%TYPE
249: , p_exception_description hxc_transactions.exception_description%TYPE
250: , p_rollback BOOLEAN DEFAULT FALSE );
251:
252:
253: end hxc_generic_retrieval_pkg;