[Home] [Help]
PACKAGE: APPS.HXC_USER_TYPE_DEFINITION_GRP
Source
1 PACKAGE HXC_USER_TYPE_DEFINITION_GRP AS
2 /* $Header: hxcusertypedef.pkh 120.1 2005/12/05 14:19:00 arundell noship $ */
3
4 --
5 -- TIMECARD
6 --
7 TYPE building_block_info IS RECORD (
8 time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
9 TYPE hxc_time_building_blocks.TYPE%TYPE,
10 measure hxc_time_building_blocks.measure%TYPE,
11 unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,
12 start_time hxc_time_building_blocks.start_time%TYPE,
13 stop_time hxc_time_building_blocks.stop_time%TYPE,
14 parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,
15 parent_is_new VARCHAR2 (1),
16 SCOPE hxc_time_building_blocks.SCOPE%TYPE,
17 object_version_number hxc_time_building_blocks.object_version_number%TYPE,
18 approval_status hxc_time_building_blocks.approval_status%TYPE,
19 resource_id hxc_time_building_blocks.resource_id%TYPE,
20 resource_type hxc_time_building_blocks.resource_type%TYPE,
21 approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,
22 date_from hxc_time_building_blocks.date_from%TYPE,
23 date_to hxc_time_building_blocks.date_to%TYPE,
24 comment_text hxc_time_building_blocks.comment_text%TYPE,
25 parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE,
26 NEW VARCHAR2 (30),
27 changed VARCHAR2 (30),
28 process VARCHAR2 (30),
29 application_set_id hxc_time_building_blocks.application_set_id%type);
30
31 TYPE timecard_info IS TABLE OF building_block_info
32 INDEX BY BINARY_INTEGER;
33
34 --
35 -- MESSAGE
36 --
37 TYPE message_info IS RECORD (
38 message_name fnd_new_messages.message_name%TYPE,
39 message_level VARCHAR2 (30),
40 message_field VARCHAR2(2000),
41 message_tokens VARCHAR2 (240), -- Bug 3036930
42 application_short_name fnd_application.application_short_name%TYPE,
43 time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
44 time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
45 time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
46 time_attribute_ovn hxc_time_attributes.object_version_number%TYPE,
47 on_oa_msg_stack BOOLEAN := FALSE, --AI5
48 message_extent VARCHAR2 (20) --Bug#2873563
49 );
50
51 TYPE message_table IS TABLE OF message_info
52 INDEX BY BINARY_INTEGER;
53
54
55 --
56 -- APP_ATTRIBUTES
57 --
58 TYPE app_attributes IS RECORD (
59 time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
60 building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
61 attribute_name hxc_mapping_components.field_name%TYPE,
62 attribute_value hxc_time_attributes.attribute1%TYPE,
63 attribute_index number,
64 segment hxc_mapping_components.segment%type,
65 bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
66 CATEGORY hxc_bld_blk_info_type_usages.building_block_category%TYPE,
67 updated VARCHAR2 (30),
68 changed VARCHAR2 (30),
69 process VARCHAR2 (30));
70
71 TYPE app_attributes_info IS TABLE OF app_attributes
72 INDEX BY BINARY_INTEGER;
73
74
75 --
76 -- ATTRIBUTES
77 --
78 TYPE attribute_info IS RECORD (
79 time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
80 building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
81 bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
82 attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
83 attribute1 hxc_time_attributes.attribute1%TYPE,
84 attribute2 hxc_time_attributes.attribute2%TYPE,
85 attribute3 hxc_time_attributes.attribute3%TYPE,
86 attribute4 hxc_time_attributes.attribute4%TYPE,
87 attribute5 hxc_time_attributes.attribute5%TYPE,
88 attribute6 hxc_time_attributes.attribute6%TYPE,
89 attribute7 hxc_time_attributes.attribute7%TYPE,
90 attribute8 hxc_time_attributes.attribute8%TYPE,
91 attribute9 hxc_time_attributes.attribute9%TYPE,
92 attribute10 hxc_time_attributes.attribute10%TYPE,
93 attribute11 hxc_time_attributes.attribute11%TYPE,
94 attribute12 hxc_time_attributes.attribute12%TYPE,
95 attribute13 hxc_time_attributes.attribute13%TYPE,
96 attribute14 hxc_time_attributes.attribute14%TYPE,
97 attribute15 hxc_time_attributes.attribute15%TYPE,
98 attribute16 hxc_time_attributes.attribute16%TYPE,
99 attribute17 hxc_time_attributes.attribute17%TYPE,
100 attribute18 hxc_time_attributes.attribute18%TYPE,
101 attribute19 hxc_time_attributes.attribute19%TYPE,
102 attribute20 hxc_time_attributes.attribute20%TYPE,
103 attribute21 hxc_time_attributes.attribute21%TYPE,
104 attribute22 hxc_time_attributes.attribute22%TYPE,
105 attribute23 hxc_time_attributes.attribute23%TYPE,
106 attribute24 hxc_time_attributes.attribute24%TYPE,
107 attribute25 hxc_time_attributes.attribute25%TYPE,
108 attribute26 hxc_time_attributes.attribute26%TYPE,
109 attribute27 hxc_time_attributes.attribute27%TYPE,
110 attribute28 hxc_time_attributes.attribute28%TYPE,
111 attribute29 hxc_time_attributes.attribute29%TYPE,
112 attribute30 hxc_time_attributes.attribute30%TYPE,
113 bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE,
114 object_version_number hxc_time_attributes.object_version_number%TYPE,
115 NEW VARCHAR2 (30),
116 changed VARCHAR2 (30),
117 process VARCHAR2 (30));
118
119 TYPE building_block_attribute_info IS TABLE OF attribute_info
120 INDEX BY BINARY_INTEGER;
121
122 --
123 --
124 -- GENERIC RETRIEVAL
125 --
126 --
127 TYPE t_status
128 IS TABLE OF hxc_transaction_details.status%TYPE INDEX BY BINARY_INTEGER;
129 TYPE t_exception_description
130 IS TABLE OF hxc_transaction_details.exception_description%TYPE INDEX BY BINARY_INTEGER;
131
132 TYPE r_building_blocks IS RECORD (
133 bb_id hxc_time_building_blocks.time_building_block_id%TYPE
134 ,type hxc_time_building_blocks.type%TYPE
135 ,measure hxc_time_building_blocks.measure%TYPE
136 ,start_time hxc_time_building_blocks.start_time%TYPE
137 ,stop_time hxc_time_building_blocks.stop_time%TYPE
138 ,parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
139 ,scope hxc_time_building_blocks.scope%TYPE
140 ,resource_id hxc_time_building_blocks.resource_id%TYPE
141 ,resource_type hxc_time_building_blocks.resource_type%TYPE
142 ,comment_text hxc_time_building_blocks.comment_text%TYPE
143 ,uom hxc_time_building_blocks.unit_of_measure%TYPE
144 ,ovn hxc_time_building_blocks.object_version_number%TYPE
145 ,changed VARCHAR2(1)
146 ,deleted VARCHAR2(1)
147 ,timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
148 ,timecard_ovn hxc_time_building_blocks.object_version_number%TYPE );
149
150 TYPE t_building_blocks
151 IS TABLE OF r_building_blocks INDEX BY BINARY_INTEGER;
152
153 TYPE r_time_attributes IS RECORD (
154 bb_id hxc_time_building_blocks.time_building_block_id%TYPE
155 ,field_name hxc_mapping_components.field_name%TYPE
156 ,value hxc_time_attributes.attribute1%TYPE
157 ,context hxc_bld_blk_info_types.bld_blk_info_type%TYPE
158 ,category hxc_bld_blk_info_type_usages.building_block_category%TYPE );
159
160 TYPE t_time_attribute
161 IS TABLE OF r_time_attributes INDEX BY BINARY_INTEGER;
162
163 TYPE t_time_building_block_ovn
164 IS TABLE OF hxc_transaction_details.time_building_block_ovn%TYPE INDEX BY BINARY_INTEGER;
165
166 TYPE t_time_building_block_id
167 IS TABLE OF hxc_transaction_details.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
168
169 TYPE r_timecard_block IS RECORD (
170 start_time hxc_time_building_blocks.start_time%TYPE
171 ,stop_time hxc_time_building_blocks.stop_time%TYPE
172 ,comment_text hxc_time_building_blocks.comment_text%TYPE );
173
174 TYPE t_timecard_blocks IS TABLE OF r_timecard_block INDEX BY BINARY_INTEGER;
175
176 t_tx_detail_status t_status;
177
178 t_tx_detail_exception t_exception_description;
179
180 t_detail_bld_blks t_building_blocks;
181 t_day_bld_blks t_building_blocks;
182 t_old_detail_bld_blks t_building_blocks;
183 t_old_day_bld_blks t_building_blocks;
184
185 t_time_bld_blks t_timecard_blocks;
186
187 t_detail_attributes t_time_attribute;
188 t_old_detail_attributes t_time_attribute;
189
190 t_tx_day_bb_ovn t_time_building_block_ovn;
191 t_tx_time_bb_ovn t_time_building_block_ovn;
192 t_tx_day_parent_id t_time_building_block_id;
193 t_tx_detail_bb_id t_time_building_block_id;
194
195 --
196 -- TIMECARD
197 --
198 c_error CONSTANT VARCHAR2(5) := 'ERROR';
199 c_warning CONSTANT VARCHAR2(7) := 'WARNING';
200 c_blk_children_extent CONSTANT VARCHAR2(16):= 'BLK_AND_CHILDREN';
201
202
203
204 END HXC_USER_TYPE_DEFINITION_GRP;