APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on HXC_DEPOSIT_PROCESSES

Line 2067: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE

2063: -- in.
2064: --
2065: -----------------------------------------------------------------------------
2066: FUNCTION get_deposit_process_id (
2067: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE
2068: )
2069: RETURN hxc_deposit_processes.deposit_process_id%TYPE
2070: IS
2071: l_proc VARCHAR2 (72);

Line 2069: RETURN hxc_deposit_processes.deposit_process_id%TYPE

2065: -----------------------------------------------------------------------------
2066: FUNCTION get_deposit_process_id (
2067: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE
2068: )
2069: RETURN hxc_deposit_processes.deposit_process_id%TYPE
2070: IS
2071: l_proc VARCHAR2 (72);
2072:
2073: CURSOR csr_deposit_process_id (v_deposit_process_name IN VARCHAR2)

Line 2076: FROM hxc_deposit_processes

2072:
2073: CURSOR csr_deposit_process_id (v_deposit_process_name IN VARCHAR2)
2074: IS
2075: SELECT deposit_process_id
2076: FROM hxc_deposit_processes
2077: WHERE NAME = v_deposit_process_name;
2078:
2079: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE;
2080: BEGIN

Line 2079: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE;

2075: SELECT deposit_process_id
2076: FROM hxc_deposit_processes
2077: WHERE NAME = v_deposit_process_name;
2078:
2079: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE;
2080: BEGIN
2081: g_debug := hr_utility.debug_enabled;
2082:
2083: IF g_debug

Line 2269: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

2265: -----------------------------------------------------------------------------
2266: PROCEDURE get_timecard_tables
2267: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2268: -- p_time_recipient_id IN NUMBER,
2269: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2270: p_clear_mapping_cache IN BOOLEAN default false,
2271: p_app_blocks OUT NOCOPY hxc_block_table_type,
2272: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2273: )

Line 2345: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

2341: -----------------------------------------------------------------------------
2342: PROCEDURE get_timecard_tables
2343: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2344: -- p_time_recipient_id IN NUMBER,
2345: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2346: p_clear_mapping_cache IN BOOLEAN default false,
2347: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2348: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2349: )

Line 2399: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

2395: --
2396: -----------------------------------------------------------------------------
2397: PROCEDURE get_bld_blk_info_type (
2398: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2399: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2400: p_bld_blk_info_type OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
2401: p_segment OUT NOCOPY hxc_mapping_components.SEGMENT%TYPE
2402: )
2403: IS

Line 2408: v_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE

2404: l_proc VARCHAR2 (72);
2405:
2406: CURSOR csr_bld_blk_info_type (
2407: v_field_name hxc_mapping_components.field_name%TYPE,
2408: v_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE
2409: )
2410: IS
2411: SELECT bbit.bld_blk_info_type, mc.SEGMENT
2412: FROM hxc_mapping_components mc,

Line 2415: hxc_deposit_processes dp,

2411: SELECT bbit.bld_blk_info_type, mc.SEGMENT
2412: FROM hxc_mapping_components mc,
2413: hxc_mapping_comp_usages mcu,
2414: hxc_mappings m,
2415: hxc_deposit_processes dp,
2416: hxc_bld_blk_info_types bbit,
2417: hxc_bld_blk_info_type_usages bbui
2418: WHERE dp.mapping_id = m.mapping_id
2419: AND m.mapping_id = mcu.mapping_id