APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXC_TRANSACTIONS

Line 71: g_trx_success CONSTANT hxc_transactions.status%TYPE

67: := 'I';
68: g_time_store_batch_source CONSTANT pay_batch_headers.batch_source%TYPE
69: := 'Time Store';
70: g_max_message_size CONSTANT PLS_INTEGER := 2000;
71: g_trx_success CONSTANT hxc_transactions.status%TYPE
72: := 'SUCCESS';
73: g_trx_error CONSTANT hxc_transactions.status%TYPE
74: := 'ERRORS';
75: g_hxc_app_short_name CONSTANT fnd_application.application_short_name%TYPE

Line 73: g_trx_error CONSTANT hxc_transactions.status%TYPE

69: := 'Time Store';
70: g_max_message_size CONSTANT PLS_INTEGER := 2000;
71: g_trx_success CONSTANT hxc_transactions.status%TYPE
72: := 'SUCCESS';
73: g_trx_error CONSTANT hxc_transactions.status%TYPE
74: := 'ERRORS';
75: g_hxc_app_short_name CONSTANT fnd_application.application_short_name%TYPE
76: := 'HXC';
77: g_trx_detail_success_msg CONSTANT fnd_new_messages.message_name%TYPE

Line 115: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

111: p_session_date IN DATE,
112: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,
113: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,
114: p_where_clause IN hxt_interface_utilities.max_varchar,
115: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
116: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
117: p_unique_params IN hxt_interface_utilities.max_varchar,
118: p_incremental IN hxt_interface_utilities.flag_varchar
119: DEFAULT 'Y', -- We don't allow this anymore so set to Y always