eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

PACKAGE: APPS.HXC_SELF_SERVICE_TIMECARD

Source


1 PACKAGE hxc_self_service_timecard AUTHID CURRENT_USER AS
2 /* $Header: hxctctprt.pkh 120.3.12020000.1 2012/06/28 05:42:53 appldev ship $ */
3 
4 
5 PROCEDURE fetch_blocks_and_attributes(
6   p_resource_id      IN     VARCHAR2
7  ,p_resource_type    IN     VARCHAR2
8  ,p_start_time       IN     VARCHAR2
9  ,p_stop_time        IN     VARCHAR2
10  ,p_timecard_id      IN     VARCHAR2
11  ,p_template_code    IN     VARCHAR2
12  ,p_approval_status  IN     VARCHAR2
13  ,p_create_template  IN     VARCHAR2
14  ,p_block_array      IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
15  ,p_attribute_array  IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
16  ,p_messages         IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
17  ,p_message_string      OUT NOCOPY VARCHAR2
18  ,p_overwrite        IN     VARCHAR2
19  ,p_review           IN     VARCHAR2
20  ,p_lock_rowid       IN OUT NOCOPY ROWID
21  ,p_timecard_action  in     VARCHAR2
22  );
23 
24 PROCEDURE fetch_blocks_and_attributes(
25   p_resource_id      IN     VARCHAR2
26  ,p_resource_type    IN     VARCHAR2
27  ,p_start_time       IN     VARCHAR2
28  ,p_stop_time        IN     VARCHAR2
29  ,p_timecard_id      IN     VARCHAR2
30  ,p_template_code    IN     VARCHAR2
31  ,p_approval_status  IN     VARCHAR2
32  ,p_create_template  IN     VARCHAR2
33  ,p_block_array      IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
34  ,p_attribute_array  IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
35  ,p_messages         IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
36  ,p_message_string      OUT NOCOPY VARCHAR2
37  ,p_overwrite        IN     VARCHAR2
38  ,p_review           IN     VARCHAR2
39  ,p_lock_rowid       IN OUT NOCOPY ROWID
40  ,p_timecard_action  in     VARCHAR2
41  ,p_exclude_hours_template in VARCHAR2
42  );
43 
44 PROCEDURE fetch_blocks_and_attributes(
45   p_resource_id      IN     VARCHAR2
46  ,p_resource_type    IN     VARCHAR2
47  ,p_start_time       IN     VARCHAR2
48  ,p_stop_time        IN     VARCHAR2
49  ,p_timecard_id      IN     VARCHAR2
50  ,p_template_code    IN     VARCHAR2
51  ,p_approval_status  IN     VARCHAR2
52  ,p_create_template  IN     VARCHAR2
53  ,p_block_array      IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
54  ,p_attribute_array  IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
55  ,p_messages         IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
56  ,p_message_string      OUT NOCOPY VARCHAR2
57  ,p_overwrite        IN     VARCHAR2
58  ,p_review           IN     VARCHAR2
59  ,p_lock_rowid       IN OUT NOCOPY ROWID
60  ,p_timecard_action  in     VARCHAR2
61  ,p_exclude_hours_template in VARCHAR2
62  ,p_notif_id         in varchar2);
63 
64 
65 PROCEDURE fetch_appl_periods(
66   p_resource_id      IN VARCHAR2
67  ,p_resource_type    IN VARCHAR2
68  ,p_timecard_id      IN VARCHAR2
69  ,p_block_array     OUT NOCOPY HXC_BLOCK_TABLE_TYPE
70  ,p_attribute_array OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
71  ,p_message_string  OUT NOCOPY VARCHAR2
72  );
73 
74 PROCEDURE check_blocks_from_template(
75   p_resource_id      IN     VARCHAR2
76  ,p_resource_type    IN     VARCHAR2
77  ,p_start_time       IN     VARCHAR2
78  ,p_stop_time        IN     VARCHAR2
79  ,p_template_code    IN     VARCHAR2
80  ,p_messages         IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
81 );
82 
83 FUNCTION get_timecard_transferred_to(
84   f_timecard_id HXC_TIMECARD_SUMMARY.TIMECARD_ID%TYPE
85  ,f_timecard_ovn HXC_TIMECARD_SUMMARY.TIMECARD_OVN%TYPE) RETURN varchar2;
86 
87 
88 END hxc_self_service_timecard;