DBA Data[Home] [Help]

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TRANSACTIONS

Line 211: g_transaction_id hxc_transactions.transaction_id%TYPE;

207: t_tx_error_transaction_id t_transaction_id;
208: t_tx_error_status t_status;
209: t_tx_error_exception t_exception_description;
210:
211: g_transaction_id hxc_transactions.transaction_id%TYPE;
212: g_retrieval_process_id hxc_transactions.transaction_process_id%TYPE;
213: g_retrieval_tr_id hxc_time_recipients.time_recipient_id%TYPE;
214:
215: g_lock_type varchar2(35);

Line 212: g_retrieval_process_id hxc_transactions.transaction_process_id%TYPE;

208: t_tx_error_status t_status;
209: t_tx_error_exception t_exception_description;
210:
211: g_transaction_id hxc_transactions.transaction_id%TYPE;
212: g_retrieval_process_id hxc_transactions.transaction_process_id%TYPE;
213: g_retrieval_tr_id hxc_time_recipients.time_recipient_id%TYPE;
214:
215: g_lock_type varchar2(35);
216:

Line 226: G_TRANS_CODE hxc_transactions.transaction_code%TYPE;

222: G_LAST_CHUNK BOOLEAN := FALSE;
223: G_NO_TIMECARDS BOOLEAN := TRUE;
224: G_OVERALL_NO_TIMECARDS BOOLEAN := TRUE;
225: G_CHUNK_NUMBER NUMBER := 0;
226: G_TRANS_CODE hxc_transactions.transaction_code%TYPE;
227: G_TRANS_PREFIX varchar2(11);
228:
229: -- new globals for skipped records
230:

Line 289: , p_status hxc_transactions.status%TYPE

285: , p_since_date in VARCHAR2 default null
286: );
287:
288: Procedure Update_Transaction_Status ( p_process hxc_retrieval_processes.name%TYPE
289: , p_status hxc_transactions.status%TYPE
290: , p_exception_description hxc_transactions.exception_description%TYPE
291: , p_rollback BOOLEAN DEFAULT FALSE );
292:
293: --Bug 8888911

Line 290: , p_exception_description hxc_transactions.exception_description%TYPE

286: );
287:
288: Procedure Update_Transaction_Status ( p_process hxc_retrieval_processes.name%TYPE
289: , p_status hxc_transactions.status%TYPE
290: , p_exception_description hxc_transactions.exception_description%TYPE
291: , p_rollback BOOLEAN DEFAULT FALSE );
292:
293: --Bug 8888911
294: --Added the new function to help easily write to