APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXC_TRANSACTIONS

Line 511: p_status IN hxc_transactions.status%TYPE,

507: END where_clause;
508:
509: PROCEDURE set_transaction_detail (
510: p_tbb_idx IN PLS_INTEGER,
511: p_status IN hxc_transactions.status%TYPE,
512: p_exception IN hxc_transactions.exception_description%TYPE
513: )
514: IS
515: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';

Line 512: p_exception IN hxc_transactions.exception_description%TYPE

508:
509: PROCEDURE set_transaction_detail (
510: p_tbb_idx IN PLS_INTEGER,
511: p_status IN hxc_transactions.status%TYPE,
512: p_exception IN hxc_transactions.exception_description%TYPE
513: )
514: IS
515: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';
516: BEGIN

Line 526: p_status IN hxc_transactions.status%TYPE,

522: END set_transaction_detail;
523:
524: PROCEDURE set_transaction (
525: p_process_name IN hxc_retrieval_processes.NAME%TYPE,
526: p_status IN hxc_transactions.status%TYPE,
527: p_exception IN hxc_transactions.exception_description%TYPE
528: )
529: IS
530: l_proc CONSTANT proc_name := g_package || 'set_transaction';

Line 527: p_exception IN hxc_transactions.exception_description%TYPE

523:
524: PROCEDURE set_transaction (
525: p_process_name IN hxc_retrieval_processes.NAME%TYPE,
526: p_status IN hxc_transactions.status%TYPE,
527: p_exception IN hxc_transactions.exception_description%TYPE
528: )
529: IS
530: l_proc CONSTANT proc_name := g_package || 'set_transaction';
531: BEGIN

Line 737: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

733: --hxc_time_building_blocks.start_time%TYPE,
734: p_end_date IN VARCHAR2,
735: --hxc_time_building_blocks.stop_time%TYPE,
736: p_where_clause IN hxt_interface_utilities.max_varchar,
737: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
738: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
739: p_unique_params IN hxt_interface_utilities.max_varchar,
740: p_incremental IN hxt_interface_utilities.flag_varchar
741: DEFAULT 'Y',

Line 2119: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

2115: p_start_date IN hxc_time_building_blocks.start_time%TYPE,
2116: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,
2117: p_session_date IN DATE,
2118: p_where_clause IN hxt_interface_utilities.max_varchar,
2119: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
2120: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
2121: p_unique_params IN hxt_interface_utilities.max_varchar,
2122: p_status_in_bee IN VARCHAR2,
2123: p_incremental IN hxt_interface_utilities.flag_varchar