[Home] [Help]
PACKAGE: APPS.HXT_TIMECARD_INFO
Source
1 PACKAGE HXT_TIMECARD_INFO AUTHID CURRENT_USER AS
2 /* $Header: hxctimotm.pkh 115.8 2004/04/14 16:15:37 mhanda noship $ */
3
4 -----------------------------------------------------------------
5 PROCEDURE Gen_Work_Plan( p_start DATE
6 , p_end DATE
7 , p_tws_id NUMBER
8 , p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
9 , p_timecard IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info
10 );
11
12 ------------------------------------------------------------------
13
14 PROCEDURE Gen_Rot_Plan( p_start DATE
15 , p_end DATE
16 , p_rtp_id NUMBER
17 , p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
18 , p_timecard OUT NOCOPY hxc_self_service_time_deposit.timecard_info
19 );
20 ------------------------------------------------------------------
21 PROCEDURE Get_Work_Day( p_date IN DATE
22 , p_work_id IN NUMBER
23 , p_standard_start OUT NOCOPY NUMBER
24 , p_standard_stop OUT NOCOPY NUMBER
25 , p_hours OUT NOCOPY NUMBER);
26 ------------------------------------------------------------------
27 /*
28 TYPE attribute_info is RECORD
29 (TIME_ATTRIBUTE_ID hxc_time_attributes.time_attribute_id%TYPE
30 ,BUILDING_BLOCK_ID hxc_time_building_blocks.time_building_block_id%TYPE
31 ,ATTRIBUTE_CATEGORY hxc_time_attributes.attribute_category%TYPE
32 ,ATTRIBUTE1 hxc_time_attributes.attribute1%TYPE
33 ,ATTRIBUTE2 hxc_time_attributes.attribute2%TYPE
34 ,ATTRIBUTE3 hxc_time_attributes.attribute3%TYPE
35 ,ATTRIBUTE4 hxc_time_attributes.attribute4%TYPE
36 ,ATTRIBUTE5 hxc_time_attributes.attribute5%TYPE
37 ,ATTRIBUTE6 hxc_time_attributes.attribute6%TYPE
38 ,ATTRIBUTE7 hxc_time_attributes.attribute7%TYPE
39 ,ATTRIBUTE8 hxc_time_attributes.attribute8%TYPE
40 ,ATTRIBUTE9 hxc_time_attributes.attribute9%TYPE
41 ,ATTRIBUTE10 hxc_time_attributes.attribute10%TYPE
42 ,ATTRIBUTE11 hxc_time_attributes.attribute11%TYPE
43 ,ATTRIBUTE12 hxc_time_attributes.attribute12%TYPE
44 ,ATTRIBUTE13 hxc_time_attributes.attribute13%TYPE
45 ,ATTRIBUTE14 hxc_time_attributes.attribute14%TYPE
46 ,ATTRIBUTE15 hxc_time_attributes.attribute15%TYPE
47 ,ATTRIBUTE16 hxc_time_attributes.attribute16%TYPE
48 ,ATTRIBUTE17 hxc_time_attributes.attribute17%TYPE
49 ,ATTRIBUTE18 hxc_time_attributes.attribute18%TYPE
50 ,ATTRIBUTE19 hxc_time_attributes.attribute19%TYPE
51 ,ATTRIBUTE20 hxc_time_attributes.attribute20%TYPE
52 ,ATTRIBUTE21 hxc_time_attributes.attribute21%TYPE
53 ,ATTRIBUTE22 hxc_time_attributes.attribute22%TYPE
54 ,ATTRIBUTE23 hxc_time_attributes.attribute23%TYPE
55 ,ATTRIBUTE24 hxc_time_attributes.attribute24%TYPE
56 ,ATTRIBUTE25 hxc_time_attributes.attribute25%TYPE
57 ,ATTRIBUTE26 hxc_time_attributes.attribute26%TYPE
58 ,ATTRIBUTE27 hxc_time_attributes.attribute27%TYPE
59 ,ATTRIBUTE28 hxc_time_attributes.attribute28%TYPE
60 ,ATTRIBUTE29 hxc_time_attributes.attribute29%TYPE
61 ,ATTRIBUTE30 hxc_time_attributes.attribute30%TYPE
62 ,BLD_BLK_INFO_TYPE_ID hxc_time_attributes.bld_blk_info_type_id%TYPE
63 ,OBJECT_VERSION_NUMBER hxc_time_attributes.object_version_number%TYPE
64 ,NEW VARCHAR2(1)
65 );
66
67 TYPE building_block_attribute_info is TABLE OF
68 attribute_info
69 INDEX BY binary_integer;
70
71 TYPE building_block_info is RECORD
72 (TIME_BUILDING_BLOCK_ID hxc_time_building_blocks.time_building_block_id%TYPE
73 ,TYPE hxc_time_building_blocks.type%TYPE
74 ,MEASURE hxc_time_building_blocks.measure%TYPE
75 ,UNIT_OF_MEASURE hxc_time_building_blocks.unit_of_measure%TYPE
76 ,START_TIME hxc_time_building_blocks.start_time%TYPE
77 ,STOP_TIME hxc_time_building_blocks.stop_time%TYPE
78 ,PARENT_BUILDING_BLOCK_ID hxc_time_building_blocks.parent_building_block_id%TYPE
79 ,PARENT_IS_NEW VARCHAR2(1)
80 ,SCOPE hxc_time_building_blocks.scope%TYPE
81 ,OBJECT_VERSION_NUMBER hxc_time_building_blocks.object_version_number%TYPE
82 ,APPROVAL_STATUS hxc_time_building_blocks.approval_status%TYPE
83 ,RESOURCE_ID hxc_time_building_blocks.resource_id%TYPE
84 ,RESOURCE_TYPE hxc_time_building_blocks.resource_type%TYPE
85 ,APPROVAL_STYLE_ID hxc_time_building_blocks.approval_style_id%TYPE
86 ,DATE_FROM hxc_time_building_blocks.date_from%TYPE
87 ,DATE_TO hxc_time_building_blocks.date_to%TYPE
88 ,COMMENT_TEXT hxc_time_building_blocks.comment_text%TYPE
89 ,PARENT_BUILDING_BLOCK_OVN hxc_time_building_blocks.parent_building_block_ovn%TYPE
90 ,NEW VARCHAR2(1)
91 );
92
93 TYPE timecard_info is TABLE OF
94 building_block_info
95 INDEX BY binary_integer;
96 */
97 p_app_attributes hxc_self_service_time_deposit.app_attributes_info;
98 p_timecard hxc_self_service_time_deposit.timecard_info;
99 -------------------------------------------------------------------------------
100 PROCEDURE Generate_Time(
101 p_resource_id IN NUMBER
102 ,p_start_time IN DATE
103 ,p_stop_time IN DATE
104 ,p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
105 ,p_timecard OUT NOCOPY hxc_self_service_time_deposit.timecard_info
106 ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
107 );
108
109 -------------------------------------------------------------------------------
110
111 END hxt_timecard_info;