APPS.HXC_APPROVAL_UTILITIES dependencies on HXC_TIME_BUILDING_BLOCKS

Line 18: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

14: ,p_mode IN VARCHAR2 DEFAULT 'PENDING'
15: );
16:
17: FUNCTION attribute_search(
18: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
19: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
20: ,p_search_by IN VARCHAR2
21: ,p_search_value IN VARCHAR2
22: ,p_search_operator IN VARCHAR2

Line 19: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE

15: );
16:
17: FUNCTION attribute_search(
18: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
19: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
20: ,p_search_by IN VARCHAR2
21: ,p_search_value IN VARCHAR2
22: ,p_search_operator IN VARCHAR2
23: ,p_resource_id IN VARCHAR2

Line 28: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

24: ) RETURN VARCHAR2;
25:
26:
27: FUNCTION has_detail_comment(
28: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
29: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
30: ,p_operator IN VARCHAR2
31: ,p_comment IN VARCHAR2
32:

Line 29: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE

25:
26:
27: FUNCTION has_detail_comment(
28: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
29: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
30: ,p_operator IN VARCHAR2
31: ,p_comment IN VARCHAR2
32:
33: ) RETURN VARCHAR2;

Line 36: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

32:
33: ) RETURN VARCHAR2;
34:
35: FUNCTION has_comment(
36: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
37: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
38: ,p_operator IN VARCHAR2
39: ,p_comment IN VARCHAR2
40:

Line 37: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE

33: ) RETURN VARCHAR2;
34:
35: FUNCTION has_comment(
36: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
37: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
38: ,p_operator IN VARCHAR2
39: ,p_comment IN VARCHAR2
40:
41: ) RETURN VARCHAR2;