APPS.HXC_APPROVAL_UTILITIES dependencies on HXC_DEPOSIT_WRAPPER_UTILITIES

Line 29: p_selected_ids IN hxc_deposit_wrapper_utilities.t_simple_table

25: g_package VARCHAR2(100) := 'hxc_approval_utilities.';
26: g_debug BOOLEAN := hr_utility.debug_enabled;
27:
28: FUNCTION is_selected(
29: p_selected_ids IN hxc_deposit_wrapper_utilities.t_simple_table
30: ,p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
31: )
32: RETURN BOOLEAN
33: IS

Line 373: ,p_selected_ids OUT NOCOPY hxc_deposit_wrapper_utilities.t_simple_table

369:
370: PROCEDURE adv_search(
371: p_block_ids IN VARCHAR2
372: ,p_adv_search IN VARCHAR2
373: ,p_selected_ids OUT NOCOPY hxc_deposit_wrapper_utilities.t_simple_table
374: )
375: IS
376:
377: l_adv_table hxc_deposit_wrapper_utilities.t_simple_table;

Line 377: l_adv_table hxc_deposit_wrapper_utilities.t_simple_table;

373: ,p_selected_ids OUT NOCOPY hxc_deposit_wrapper_utilities.t_simple_table
374: )
375: IS
376:
377: l_adv_table hxc_deposit_wrapper_utilities.t_simple_table;
378:
379: l_search_by VARCHAR2(100);
380: l_search_operator VARCHAR2(30);
381: l_search_value VARCHAR2(1000);

Line 411: hxc_deposit_wrapper_utilities.string_to_table(

407: l_proc := 'adv_search';
408: hr_utility.set_location(g_package||l_proc, 10);
409: end if;
410: --Setting the MOAC params as part of R12 changes.
411: hxc_deposit_wrapper_utilities.string_to_table(
412: p_separator => '|'
413: ,p_string => p_adv_search
414: ,p_table => l_adv_table
415: );

Line 697: l_selected_ids hxc_deposit_wrapper_utilities.t_simple_table;

693: l_resource_id NUMBER := -1;
694: l_start_date DATE;
695: l_end_date DATE;
696: l_approval_array HXC_NOTIFICATION_TABLE_TYPE;
697: l_selected_ids hxc_deposit_wrapper_utilities.t_simple_table;
698: l_index NUMBER;
699:
700: l_messages HXC_MESSAGE_TABLE_TYPE;
701: l_lock_id ROWID;

Line 1074: l_selected_ids hxc_deposit_wrapper_utilities.t_simple_table;

1070:
1071: l_approval_record approval_notification;
1072: l_approval_array HXC_NOTIFICATION_TABLE_TYPE;
1073: l_array_index NUMBER := 0;
1074: l_selected_ids hxc_deposit_wrapper_utilities.t_simple_table;
1075: l_index NUMBER;
1076:
1077: l_proc VARCHAR2(500);
1078: BEGIN