APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_MAPPINGS

Line 2880: p_mapping_id IN OUT NOCOPY hxc_mappings.mapping_id%TYPE

2876: PROCEDURE chk_retrieval_process (
2877: p_retrieval_process hxc_retrieval_processes.NAME%TYPE,
2878: p_retrieval_process_id IN OUT NOCOPY hxc_retrieval_processes.retrieval_process_id%TYPE,
2879: p_retrieval_tr_id IN OUT NOCOPY hxc_retrieval_processes.time_recipient_id%TYPE,
2880: p_mapping_id IN OUT NOCOPY hxc_mappings.mapping_id%TYPE
2881: )
2882: IS
2883: --
2884: l_proc VARCHAR2 (72);

Line 6835: l_mapping_id hxc_mappings.mapping_id%TYPE := NULL;

6831: l_sql VARCHAR2 (2000);
6832: l_since_date VARCHAR2 (100);
6833: l_proc VARCHAR2 (72)
6834: := g_package || 'execute_retrieval_process';
6835: l_mapping_id hxc_mappings.mapping_id%TYPE := NULL;
6836: l_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
6837: e_retrieval_not_registered EXCEPTION;
6838: e_process_already_running EXCEPTION;
6839: l_where_clause_blk VARCHAR2 (2000);

Line 7750: FUNCTION get_field_mappings (p_mapping_id hxc_mappings.mapping_id%TYPE)

7746: -- table
7747: --
7748: -- parameters
7749: -- p_mapping_id - mapping_id
7750: FUNCTION get_field_mappings (p_mapping_id hxc_mappings.mapping_id%TYPE)
7751: RETURN t_field_mappings
7752: IS
7753: --
7754: l_mapping_record r_field_mappings;

Line 7767: hxc_mappings MAP

7763: FROM hxc_bld_blk_info_type_usages bbitu,
7764: hxc_bld_blk_info_types bbit,
7765: hxc_mapping_components mpc,
7766: hxc_mapping_comp_usages mcu,
7767: hxc_mappings MAP
7768: WHERE MAP.mapping_id = p_mapping_id
7769: AND mcu.mapping_id = MAP.mapping_id
7770: AND mpc.mapping_component_id = mcu.mapping_component_id
7771: AND bbit.bld_blk_info_type_id = mpc.bld_blk_info_type_id

Line 8932: l_mapping_id hxc_mappings.mapping_id%TYPE;

8928: )
8929: IS
8930: -- going to call the chk_retrieval_process procedure - do not need mapping id
8931: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
8932: l_mapping_id hxc_mappings.mapping_id%TYPE;
8933: l_tx_id hxc_transactions.transaction_id%TYPE;
8934: l_proc VARCHAR2 (72);
8935: l_time_max INTEGER;
8936: l_day_max INTEGER;