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;