APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on HXC_DEPOSIT_PROCESSES

Line 2709: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE

2705: -- in.
2706: --
2707: -----------------------------------------------------------------------------
2708: FUNCTION get_deposit_process_id (
2709: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE
2710: )
2711: RETURN hxc_deposit_processes.deposit_process_id%TYPE
2712: IS
2713: l_proc VARCHAR2 (72);

Line 2711: RETURN hxc_deposit_processes.deposit_process_id%TYPE

2707: -----------------------------------------------------------------------------
2708: FUNCTION get_deposit_process_id (
2709: p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE
2710: )
2711: RETURN hxc_deposit_processes.deposit_process_id%TYPE
2712: IS
2713: l_proc VARCHAR2 (72);
2714:
2715: CURSOR csr_deposit_process_id (v_deposit_process_name IN VARCHAR2)

Line 2718: FROM hxc_deposit_processes

2714:
2715: CURSOR csr_deposit_process_id (v_deposit_process_name IN VARCHAR2)
2716: IS
2717: SELECT deposit_process_id
2718: FROM hxc_deposit_processes
2719: WHERE NAME = v_deposit_process_name;
2720:
2721: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE;
2722: BEGIN

Line 2721: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE;

2717: SELECT deposit_process_id
2718: FROM hxc_deposit_processes
2719: WHERE NAME = v_deposit_process_name;
2720:
2721: l_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE;
2722: BEGIN
2723: g_debug := hr_utility.debug_enabled;
2724:
2725: IF g_debug

Line 2911: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

2907: -----------------------------------------------------------------------------
2908: PROCEDURE get_timecard_tables
2909: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2910: -- p_time_recipient_id IN NUMBER,
2911: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2912: p_clear_mapping_cache IN BOOLEAN default false,
2913: p_app_blocks OUT NOCOPY hxc_block_table_type,
2914: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2915: )

Line 2987: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

2983: -----------------------------------------------------------------------------
2984: PROCEDURE get_timecard_tables
2985: (p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2986: -- p_time_recipient_id IN NUMBER,
2987: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2988: p_clear_mapping_cache IN BOOLEAN default false,
2989: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2990: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
2991: )

Line 3041: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

3037: --
3038: -----------------------------------------------------------------------------
3039: PROCEDURE get_bld_blk_info_type (
3040: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
3041: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
3042: p_bld_blk_info_type OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
3043: p_segment OUT NOCOPY hxc_mapping_components.SEGMENT%TYPE
3044: )
3045: IS

Line 3050: v_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE

3046: l_proc VARCHAR2 (72);
3047:
3048: CURSOR csr_bld_blk_info_type (
3049: v_field_name hxc_mapping_components.field_name%TYPE,
3050: v_deposit_process_id hxc_deposit_processes.deposit_process_id%TYPE
3051: )
3052: IS
3053: SELECT bbit.bld_blk_info_type, mc.SEGMENT
3054: FROM hxc_mapping_components mc,

Line 3057: hxc_deposit_processes dp,

3053: SELECT bbit.bld_blk_info_type, mc.SEGMENT
3054: FROM hxc_mapping_components mc,
3055: hxc_mapping_comp_usages mcu,
3056: hxc_mappings m,
3057: hxc_deposit_processes dp,
3058: hxc_bld_blk_info_types bbit,
3059: hxc_bld_blk_info_type_usages bbui
3060: WHERE dp.mapping_id = m.mapping_id
3061: AND m.mapping_id = mcu.mapping_id