DBA Data[Home] [Help]

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TRANSACTIONS

Line 198: g_transaction_id hxc_transactions.transaction_id%TYPE;

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

Line 199: g_retrieval_process_id hxc_transactions.transaction_process_id%TYPE;

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:

Line 213: G_TRANS_CODE hxc_transactions.transaction_code%TYPE;

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:

Line 248: , p_status hxc_transactions.status%TYPE

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:

Line 249: , p_exception_description hxc_transactions.exception_description%TYPE

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;