APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_MAPPINGS

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

2246: PROCEDURE chk_retrieval_process (
2247: p_retrieval_process hxc_retrieval_processes.NAME%TYPE,
2248: p_retrieval_process_id IN OUT NOCOPY hxc_retrieval_processes.retrieval_process_id%TYPE,
2249: p_retrieval_tr_id IN OUT NOCOPY hxc_retrieval_processes.time_recipient_id%TYPE,
2250: p_mapping_id IN OUT NOCOPY hxc_mappings.mapping_id%TYPE
2251: )
2252: IS
2253: --
2254: l_proc VARCHAR2 (72);

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

6096: l_sql VARCHAR2 (2000);
6097: l_since_date VARCHAR2 (100);
6098: l_proc VARCHAR2 (72)
6099: := g_package || 'execute_retrieval_process';
6100: l_mapping_id hxc_mappings.mapping_id%TYPE := NULL;
6101: l_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
6102: e_retrieval_not_registered EXCEPTION;
6103: e_process_already_running EXCEPTION;
6104: l_where_clause_blk VARCHAR2 (2000);

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

6861: -- table
6862: --
6863: -- parameters
6864: -- p_mapping_id - mapping_id
6865: FUNCTION get_field_mappings (p_mapping_id hxc_mappings.mapping_id%TYPE)
6866: RETURN t_field_mappings
6867: IS
6868: --
6869: l_mapping_record r_field_mappings;

Line 6882: hxc_mappings MAP

6878: FROM hxc_bld_blk_info_type_usages bbitu,
6879: hxc_bld_blk_info_types bbit,
6880: hxc_mapping_components mpc,
6881: hxc_mapping_comp_usages mcu,
6882: hxc_mappings MAP
6883: WHERE MAP.mapping_id = p_mapping_id
6884: AND mcu.mapping_id = MAP.mapping_id
6885: AND mpc.mapping_component_id = mcu.mapping_component_id
6886: AND bbit.bld_blk_info_type_id = mpc.bld_blk_info_type_id

Line 7827: l_mapping_id hxc_mappings.mapping_id%TYPE;

7823: )
7824: IS
7825: -- going to call the chk_retrieval_process procedure - do not need mapping id
7826: l_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
7827: l_mapping_id hxc_mappings.mapping_id%TYPE;
7828: l_tx_id hxc_transactions.transaction_id%TYPE;
7829: l_proc VARCHAR2 (72);
7830: l_time_max INTEGER;
7831: l_day_max INTEGER;