APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on HXC_RETRIEVAL_PROCESSES

Line 64: p_retrieval_process_name IN hxc_retrieval_processes.NAME%TYPE

60: -- passed in.
61: --
62: -----------------------------------------------------------------------------
63: FUNCTION get_retrieval_process_id (
64: p_retrieval_process_name IN hxc_retrieval_processes.NAME%TYPE
65: )
66: RETURN hxc_retrieval_processes.retrieval_process_id%TYPE
67: IS
68: l_proc VARCHAR2 (72);

Line 66: RETURN hxc_retrieval_processes.retrieval_process_id%TYPE

62: -----------------------------------------------------------------------------
63: FUNCTION get_retrieval_process_id (
64: p_retrieval_process_name IN hxc_retrieval_processes.NAME%TYPE
65: )
66: RETURN hxc_retrieval_processes.retrieval_process_id%TYPE
67: IS
68: l_proc VARCHAR2 (72);
69:
70: CURSOR csr_retrieval_process_id (v_retrieval_process_name IN VARCHAR2)

Line 73: FROM hxc_retrieval_processes

69:
70: CURSOR csr_retrieval_process_id (v_retrieval_process_name IN VARCHAR2)
71: IS
72: SELECT retrieval_process_id
73: FROM hxc_retrieval_processes
74: WHERE NAME = v_retrieval_process_name;
75:
76: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
77: BEGIN

Line 76: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;

72: SELECT retrieval_process_id
73: FROM hxc_retrieval_processes
74: WHERE NAME = v_retrieval_process_name;
75:
76: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%TYPE;
77: BEGIN
78: g_debug := hr_utility.debug_enabled;
79:
80: IF g_debug

Line 470: p_retrieval_process IN hxc_retrieval_processes.NAME%TYPE,

466: p_item_type IN wf_items.item_type%TYPE,
467: p_approval_prc IN wf_process_activities.process_name%TYPE,
468: p_template IN VARCHAR2,
469: p_mode IN VARCHAR2,
470: p_retrieval_process IN hxc_retrieval_processes.NAME%TYPE,
471: p_blocks IN OUT NOCOPY hxc_block_table_type,
472: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
473: p_messages IN OUT NOCOPY hxc_message_table_type,
474: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,