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.

APPS.HXC_USER_TYPE_DEFINITION_GRP dependencies on HXC_TIME_BUILDING_BLOCKS

Line 8: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,

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,

Line 9: TYPE hxc_time_building_blocks.TYPE%TYPE,

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,

Line 10: measure hxc_time_building_blocks.measure%TYPE,

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,

Line 11: unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,

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),

Line 12: start_time hxc_time_building_blocks.start_time%TYPE,

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,

Line 13: stop_time hxc_time_building_blocks.stop_time%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,

Line 14: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%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,

Line 16: SCOPE hxc_time_building_blocks.SCOPE%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,

Line 17: object_version_number hxc_time_building_blocks.object_version_number%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,

Line 18: approval_status hxc_time_building_blocks.approval_status%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,

Line 19: resource_id hxc_time_building_blocks.resource_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,

Line 20: resource_type hxc_time_building_blocks.resource_type%TYPE,

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,

Line 21: approval_style_id hxc_time_building_blocks.approval_style_id%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,

Line 22: date_from hxc_time_building_blocks.date_from%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),

Line 23: date_to hxc_time_building_blocks.date_to%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),

Line 24: comment_text hxc_time_building_blocks.comment_text%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),

Line 25: parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%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);

Line 29: application_set_id hxc_time_building_blocks.application_set_id%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:

Line 43: time_building_block_id hxc_time_building_blocks.time_building_block_id%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

Line 44: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,

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

Line 60: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,

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,

Line 80: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,

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,

Line 133: bb_id hxc_time_building_blocks.time_building_block_id%TYPE

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

Line 134: ,type hxc_time_building_blocks.type%TYPE

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

Line 135: ,measure hxc_time_building_blocks.measure%TYPE

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

Line 136: ,start_time hxc_time_building_blocks.start_time%TYPE

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

Line 137: ,stop_time hxc_time_building_blocks.stop_time%TYPE

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

Line 138: ,parent_bb_id hxc_time_building_blocks.parent_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

Line 139: ,scope hxc_time_building_blocks.scope%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

Line 140: ,resource_id hxc_time_building_blocks.resource_id%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

Line 141: ,resource_type hxc_time_building_blocks.resource_type%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)

Line 142: ,comment_text hxc_time_building_blocks.comment_text%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)

Line 143: ,uom hxc_time_building_blocks.unit_of_measure%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

Line 144: ,ovn hxc_time_building_blocks.object_version_number%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 );

Line 147: ,timecard_bb_id hxc_time_building_blocks.time_building_block_id%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;

Line 148: ,timecard_ovn hxc_time_building_blocks.object_version_number%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:

Line 154: bb_id hxc_time_building_blocks.time_building_block_id%TYPE

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 );

Line 170: start_time hxc_time_building_blocks.start_time%TYPE

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;

Line 171: ,stop_time hxc_time_building_blocks.stop_time%TYPE

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:

Line 172: ,comment_text hxc_time_building_blocks.comment_text%TYPE );

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;