APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXC_TRANSACTIONS

Line 415: p_status IN hxc_transactions.status%TYPE,

411: END where_clause;
412:
413: PROCEDURE set_transaction_detail (
414: p_tbb_idx IN PLS_INTEGER,
415: p_status IN hxc_transactions.status%TYPE,
416: p_exception IN hxc_transactions.exception_description%TYPE
417: )
418: IS
419: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';

Line 416: p_exception IN hxc_transactions.exception_description%TYPE

412:
413: PROCEDURE set_transaction_detail (
414: p_tbb_idx IN PLS_INTEGER,
415: p_status IN hxc_transactions.status%TYPE,
416: p_exception IN hxc_transactions.exception_description%TYPE
417: )
418: IS
419: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';
420: BEGIN

Line 430: p_status IN hxc_transactions.status%TYPE,

426: END set_transaction_detail;
427:
428: PROCEDURE set_transaction (
429: p_process_name IN hxc_retrieval_processes.NAME%TYPE,
430: p_status IN hxc_transactions.status%TYPE,
431: p_exception IN hxc_transactions.exception_description%TYPE
432: )
433: IS
434: l_proc CONSTANT proc_name := g_package || 'set_transaction';

Line 431: p_exception IN hxc_transactions.exception_description%TYPE

427:
428: PROCEDURE set_transaction (
429: p_process_name IN hxc_retrieval_processes.NAME%TYPE,
430: p_status IN hxc_transactions.status%TYPE,
431: p_exception IN hxc_transactions.exception_description%TYPE
432: )
433: IS
434: l_proc CONSTANT proc_name := g_package || 'set_transaction';
435: BEGIN

Line 521: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

517: --hxc_time_building_blocks.start_time%TYPE,
518: p_end_date IN VARCHAR2,
519: --hxc_time_building_blocks.stop_time%TYPE,
520: p_where_clause IN hxt_interface_utilities.max_varchar,
521: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
522: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
523: p_unique_params IN hxt_interface_utilities.max_varchar,
524: p_incremental IN hxt_interface_utilities.flag_varchar
525: DEFAULT 'Y',

Line 1402: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,

1398: p_start_date IN hxc_time_building_blocks.start_time%TYPE,
1399: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,
1400: p_session_date IN DATE,
1401: p_where_clause IN hxt_interface_utilities.max_varchar,
1402: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
1403: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
1404: p_unique_params IN hxt_interface_utilities.max_varchar,
1405: p_status_in_bee IN VARCHAR2,
1406: p_incremental IN hxt_interface_utilities.flag_varchar