APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXC_TRANSACTIONS

Line 29: g_trx_success CONSTANT hxc_transactions.status%TYPE

25: := 'I';
26: g_time_store_batch_source CONSTANT pay_batch_headers.batch_source%TYPE
27: := 'Time Store';
28: g_max_message_size CONSTANT PLS_INTEGER := 2000;
29: g_trx_success CONSTANT hxc_transactions.status%TYPE
30: := 'SUCCESS';
31: g_trx_error CONSTANT hxc_transactions.status%TYPE
32: := 'ERRORS';
33: g_hxc_app_short_name CONSTANT fnd_application.application_short_name%TYPE

Line 31: g_trx_error CONSTANT hxc_transactions.status%TYPE

27: := 'Time Store';
28: g_max_message_size CONSTANT PLS_INTEGER := 2000;
29: g_trx_success CONSTANT hxc_transactions.status%TYPE
30: := 'SUCCESS';
31: g_trx_error CONSTANT hxc_transactions.status%TYPE
32: := 'ERRORS';
33: g_hxc_app_short_name CONSTANT fnd_application.application_short_name%TYPE
34: := 'HXC';
35: g_trx_detail_success_msg CONSTANT fnd_new_messages.message_name%TYPE

Line 73: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

69: p_session_date IN DATE,
70: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,
71: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,
72: p_where_clause IN hxt_interface_utilities.max_varchar,
73: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
74: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
75: p_unique_params IN hxt_interface_utilities.max_varchar,
76: p_incremental IN hxt_interface_utilities.flag_varchar
77: DEFAULT 'Y', -- We don't allow this anymore so set to Y always