[Home] [Help]
PACKAGE: APPS.HXC_APPROVAL_UTILITIES
Source
1 PACKAGE hxc_approval_utilities AUTHID CURRENT_USER AS
2 /* $Header: hxcaprutil.pkh 115.4 2003/09/16 10:29:30 jxtan noship $ */
3
4 /*=========================================================================
5 * This procedure returns result for Mass Timecard Approval page
6 *========================================================================*/
7 PROCEDURE get_approval_notifications(
8 p_approver_id IN NUMBER
9 ,p_approval_array OUT NOCOPY HXC_NOTIFICATION_TABLE_TYPE
10 ,p_resource_id IN VARCHAR2
11 ,p_from_date IN VARCHAR2
12 ,p_to_date IN VARCHAR2
13 ,p_adv_search IN VARCHAR2
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
23 ,p_resource_id IN VARCHAR2
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
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;
42
43 PROCEDURE release_locks;
44
45
46 END hxc_approval_utilities;