APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 47: bb_id hxc_time_building_blocks.time_building_block_id%TYPE

43:
44: -- building blocks
45:
46: TYPE r_building_blocks IS RECORD (
47: bb_id hxc_time_building_blocks.time_building_block_id%TYPE
48: , type hxc_time_building_blocks.type%TYPE
49: , measure hxc_time_building_blocks.measure%TYPE
50: , start_time hxc_time_building_blocks.start_time%TYPE
51: , stop_time hxc_time_building_blocks.stop_time%TYPE

Line 48: , type hxc_time_building_blocks.type%TYPE

44: -- building blocks
45:
46: TYPE r_building_blocks IS RECORD (
47: bb_id hxc_time_building_blocks.time_building_block_id%TYPE
48: , type hxc_time_building_blocks.type%TYPE
49: , measure hxc_time_building_blocks.measure%TYPE
50: , start_time hxc_time_building_blocks.start_time%TYPE
51: , stop_time hxc_time_building_blocks.stop_time%TYPE
52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE

Line 49: , measure hxc_time_building_blocks.measure%TYPE

45:
46: TYPE r_building_blocks IS RECORD (
47: bb_id hxc_time_building_blocks.time_building_block_id%TYPE
48: , type hxc_time_building_blocks.type%TYPE
49: , measure hxc_time_building_blocks.measure%TYPE
50: , start_time hxc_time_building_blocks.start_time%TYPE
51: , stop_time hxc_time_building_blocks.stop_time%TYPE
52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
53: , scope hxc_time_building_blocks.scope%TYPE

Line 50: , start_time hxc_time_building_blocks.start_time%TYPE

46: TYPE r_building_blocks IS RECORD (
47: bb_id hxc_time_building_blocks.time_building_block_id%TYPE
48: , type hxc_time_building_blocks.type%TYPE
49: , measure hxc_time_building_blocks.measure%TYPE
50: , start_time hxc_time_building_blocks.start_time%TYPE
51: , stop_time hxc_time_building_blocks.stop_time%TYPE
52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
53: , scope hxc_time_building_blocks.scope%TYPE
54: , resource_id hxc_time_building_blocks.resource_id%TYPE

Line 51: , stop_time hxc_time_building_blocks.stop_time%TYPE

47: bb_id hxc_time_building_blocks.time_building_block_id%TYPE
48: , type hxc_time_building_blocks.type%TYPE
49: , measure hxc_time_building_blocks.measure%TYPE
50: , start_time hxc_time_building_blocks.start_time%TYPE
51: , stop_time hxc_time_building_blocks.stop_time%TYPE
52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
53: , scope hxc_time_building_blocks.scope%TYPE
54: , resource_id hxc_time_building_blocks.resource_id%TYPE
55: , resource_type hxc_time_building_blocks.resource_type%TYPE

Line 52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE

48: , type hxc_time_building_blocks.type%TYPE
49: , measure hxc_time_building_blocks.measure%TYPE
50: , start_time hxc_time_building_blocks.start_time%TYPE
51: , stop_time hxc_time_building_blocks.stop_time%TYPE
52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
53: , scope hxc_time_building_blocks.scope%TYPE
54: , resource_id hxc_time_building_blocks.resource_id%TYPE
55: , resource_type hxc_time_building_blocks.resource_type%TYPE
56: , comment_text hxc_time_building_blocks.comment_text%TYPE

Line 53: , scope hxc_time_building_blocks.scope%TYPE

49: , measure hxc_time_building_blocks.measure%TYPE
50: , start_time hxc_time_building_blocks.start_time%TYPE
51: , stop_time hxc_time_building_blocks.stop_time%TYPE
52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
53: , scope hxc_time_building_blocks.scope%TYPE
54: , resource_id hxc_time_building_blocks.resource_id%TYPE
55: , resource_type hxc_time_building_blocks.resource_type%TYPE
56: , comment_text hxc_time_building_blocks.comment_text%TYPE
57: , uom hxc_time_building_blocks.unit_of_measure%TYPE

Line 54: , resource_id hxc_time_building_blocks.resource_id%TYPE

50: , start_time hxc_time_building_blocks.start_time%TYPE
51: , stop_time hxc_time_building_blocks.stop_time%TYPE
52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
53: , scope hxc_time_building_blocks.scope%TYPE
54: , resource_id hxc_time_building_blocks.resource_id%TYPE
55: , resource_type hxc_time_building_blocks.resource_type%TYPE
56: , comment_text hxc_time_building_blocks.comment_text%TYPE
57: , uom hxc_time_building_blocks.unit_of_measure%TYPE
58: , ovn hxc_time_building_blocks.object_version_number%TYPE

Line 55: , resource_type hxc_time_building_blocks.resource_type%TYPE

51: , stop_time hxc_time_building_blocks.stop_time%TYPE
52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
53: , scope hxc_time_building_blocks.scope%TYPE
54: , resource_id hxc_time_building_blocks.resource_id%TYPE
55: , resource_type hxc_time_building_blocks.resource_type%TYPE
56: , comment_text hxc_time_building_blocks.comment_text%TYPE
57: , uom hxc_time_building_blocks.unit_of_measure%TYPE
58: , ovn hxc_time_building_blocks.object_version_number%TYPE
59: , changed VARCHAR2(1)

Line 56: , comment_text hxc_time_building_blocks.comment_text%TYPE

52: , parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
53: , scope hxc_time_building_blocks.scope%TYPE
54: , resource_id hxc_time_building_blocks.resource_id%TYPE
55: , resource_type hxc_time_building_blocks.resource_type%TYPE
56: , comment_text hxc_time_building_blocks.comment_text%TYPE
57: , uom hxc_time_building_blocks.unit_of_measure%TYPE
58: , ovn hxc_time_building_blocks.object_version_number%TYPE
59: , changed VARCHAR2(1)
60: , deleted VARCHAR2(1)

Line 57: , uom hxc_time_building_blocks.unit_of_measure%TYPE

53: , scope hxc_time_building_blocks.scope%TYPE
54: , resource_id hxc_time_building_blocks.resource_id%TYPE
55: , resource_type hxc_time_building_blocks.resource_type%TYPE
56: , comment_text hxc_time_building_blocks.comment_text%TYPE
57: , uom hxc_time_building_blocks.unit_of_measure%TYPE
58: , ovn hxc_time_building_blocks.object_version_number%TYPE
59: , changed VARCHAR2(1)
60: , deleted VARCHAR2(1)
61: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 58: , ovn hxc_time_building_blocks.object_version_number%TYPE

54: , resource_id hxc_time_building_blocks.resource_id%TYPE
55: , resource_type hxc_time_building_blocks.resource_type%TYPE
56: , comment_text hxc_time_building_blocks.comment_text%TYPE
57: , uom hxc_time_building_blocks.unit_of_measure%TYPE
58: , ovn hxc_time_building_blocks.object_version_number%TYPE
59: , changed VARCHAR2(1)
60: , deleted VARCHAR2(1)
61: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
62: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE );

Line 61: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

57: , uom hxc_time_building_blocks.unit_of_measure%TYPE
58: , ovn hxc_time_building_blocks.object_version_number%TYPE
59: , changed VARCHAR2(1)
60: , deleted VARCHAR2(1)
61: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
62: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE );
63:
64: TYPE t_building_blocks IS TABLE OF r_building_blocks INDEX BY BINARY_INTEGER;
65:

Line 62: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE );

58: , ovn hxc_time_building_blocks.object_version_number%TYPE
59: , changed VARCHAR2(1)
60: , deleted VARCHAR2(1)
61: , timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
62: , timecard_ovn hxc_time_building_blocks.object_version_number%TYPE );
63:
64: TYPE t_building_blocks IS TABLE OF r_building_blocks INDEX BY BINARY_INTEGER;
65:
66: t_day_bld_blks t_building_blocks;

Line 85: start_time hxc_time_building_blocks.start_time%TYPE

81: t_detail_rec_lines t_recipient_lines;
82: t_old_detail_rec_lines t_recipient_lines;
83:
84: TYPE r_timecard_block IS RECORD (
85: start_time hxc_time_building_blocks.start_time%TYPE
86: , stop_time hxc_time_building_blocks.stop_time%TYPE
87: , comment_text hxc_time_building_blocks.comment_text%TYPE );
88:
89: TYPE t_timecard_blocks IS TABLE OF r_building_blocks INDEX BY BINARY_INTEGER;

Line 86: , stop_time hxc_time_building_blocks.stop_time%TYPE

82: t_old_detail_rec_lines t_recipient_lines;
83:
84: TYPE r_timecard_block IS RECORD (
85: start_time hxc_time_building_blocks.start_time%TYPE
86: , stop_time hxc_time_building_blocks.stop_time%TYPE
87: , comment_text hxc_time_building_blocks.comment_text%TYPE );
88:
89: TYPE t_timecard_blocks IS TABLE OF r_building_blocks INDEX BY BINARY_INTEGER;
90:

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

83:
84: TYPE r_timecard_block IS RECORD (
85: start_time hxc_time_building_blocks.start_time%TYPE
86: , stop_time hxc_time_building_blocks.stop_time%TYPE
87: , comment_text hxc_time_building_blocks.comment_text%TYPE );
88:
89: TYPE t_timecard_blocks IS TABLE OF r_building_blocks INDEX BY BINARY_INTEGER;
90:
91: t_time_bld_blks t_timecard_blocks;

Line 96: bb_id hxc_time_building_blocks.time_building_block_id%TYPE

92:
93: -- attributes
94:
95: TYPE r_time_attributes IS RECORD (
96: bb_id hxc_time_building_blocks.time_building_block_id%TYPE
97: , field_name hxc_mapping_components.field_name%TYPE
98: , value hxc_time_attributes.attribute1%TYPE
99: , context hxc_bld_blk_info_types.bld_blk_info_type%TYPE
100: , category hxc_bld_blk_info_type_usages.building_block_category%TYPE );

Line 109: time_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

105: t_detail_attributes t_time_attribute;
106: t_old_detail_attributes t_time_attribute;
107:
108: TYPE r_all_building_blocks IS RECORD (
109: time_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
110: , time_ovn hxc_time_building_blocks.object_version_number%TYPE
111: , time_max_ovn hxc_time_building_blocks.object_version_number%TYPE
112: , time_start_time hxc_time_building_blocks.start_time%TYPE
113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE

Line 110: , time_ovn hxc_time_building_blocks.object_version_number%TYPE

106: t_old_detail_attributes t_time_attribute;
107:
108: TYPE r_all_building_blocks IS RECORD (
109: time_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
110: , time_ovn hxc_time_building_blocks.object_version_number%TYPE
111: , time_max_ovn hxc_time_building_blocks.object_version_number%TYPE
112: , time_start_time hxc_time_building_blocks.start_time%TYPE
113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE
114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE

Line 111: , time_max_ovn hxc_time_building_blocks.object_version_number%TYPE

107:
108: TYPE r_all_building_blocks IS RECORD (
109: time_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
110: , time_ovn hxc_time_building_blocks.object_version_number%TYPE
111: , time_max_ovn hxc_time_building_blocks.object_version_number%TYPE
112: , time_start_time hxc_time_building_blocks.start_time%TYPE
113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE
114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE
115: , time_deleted hxc_time_building_blocks.comment_text%TYPE

Line 112: , time_start_time hxc_time_building_blocks.start_time%TYPE

108: TYPE r_all_building_blocks IS RECORD (
109: time_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
110: , time_ovn hxc_time_building_blocks.object_version_number%TYPE
111: , time_max_ovn hxc_time_building_blocks.object_version_number%TYPE
112: , time_start_time hxc_time_building_blocks.start_time%TYPE
113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE
114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE
115: , time_deleted hxc_time_building_blocks.comment_text%TYPE
116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE

109: time_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
110: , time_ovn hxc_time_building_blocks.object_version_number%TYPE
111: , time_max_ovn hxc_time_building_blocks.object_version_number%TYPE
112: , time_start_time hxc_time_building_blocks.start_time%TYPE
113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE
114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE
115: , time_deleted hxc_time_building_blocks.comment_text%TYPE
116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
117: , day_start_time hxc_time_building_blocks.start_time%TYPE

Line 114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE

110: , time_ovn hxc_time_building_blocks.object_version_number%TYPE
111: , time_max_ovn hxc_time_building_blocks.object_version_number%TYPE
112: , time_start_time hxc_time_building_blocks.start_time%TYPE
113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE
114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE
115: , time_deleted hxc_time_building_blocks.comment_text%TYPE
116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
117: , day_start_time hxc_time_building_blocks.start_time%TYPE
118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE

Line 115: , time_deleted hxc_time_building_blocks.comment_text%TYPE

111: , time_max_ovn hxc_time_building_blocks.object_version_number%TYPE
112: , time_start_time hxc_time_building_blocks.start_time%TYPE
113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE
114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE
115: , time_deleted hxc_time_building_blocks.comment_text%TYPE
116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
117: , day_start_time hxc_time_building_blocks.start_time%TYPE
118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE
119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE

Line 116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

112: , time_start_time hxc_time_building_blocks.start_time%TYPE
113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE
114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE
115: , time_deleted hxc_time_building_blocks.comment_text%TYPE
116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
117: , day_start_time hxc_time_building_blocks.start_time%TYPE
118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE
119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE
120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE

Line 117: , day_start_time hxc_time_building_blocks.start_time%TYPE

113: , time_stop_time hxc_time_building_blocks.stop_time%TYPE
114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE
115: , time_deleted hxc_time_building_blocks.comment_text%TYPE
116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
117: , day_start_time hxc_time_building_blocks.start_time%TYPE
118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE
119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE
120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE
121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE

114: , time_comment_text hxc_time_building_blocks.comment_text%TYPE
115: , time_deleted hxc_time_building_blocks.comment_text%TYPE
116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
117: , day_start_time hxc_time_building_blocks.start_time%TYPE
118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE
119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE
120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE
121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
122: , detail_type hxc_time_building_blocks.type%TYPE

Line 119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE

115: , time_deleted hxc_time_building_blocks.comment_text%TYPE
116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
117: , day_start_time hxc_time_building_blocks.start_time%TYPE
118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE
119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE
120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE
121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
122: , detail_type hxc_time_building_blocks.type%TYPE
123: , detail_measure hxc_time_building_blocks.measure%TYPE

Line 120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE

116: , day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
117: , day_start_time hxc_time_building_blocks.start_time%TYPE
118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE
119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE
120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE
121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
122: , detail_type hxc_time_building_blocks.type%TYPE
123: , detail_measure hxc_time_building_blocks.measure%TYPE
124: , detail_start_time hxc_time_building_blocks.start_time%TYPE

Line 121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

117: , day_start_time hxc_time_building_blocks.start_time%TYPE
118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE
119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE
120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE
121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
122: , detail_type hxc_time_building_blocks.type%TYPE
123: , detail_measure hxc_time_building_blocks.measure%TYPE
124: , detail_start_time hxc_time_building_blocks.start_time%TYPE
125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE

Line 122: , detail_type hxc_time_building_blocks.type%TYPE

118: , day_stop_time hxc_time_building_blocks.stop_time%TYPE
119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE
120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE
121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
122: , detail_type hxc_time_building_blocks.type%TYPE
123: , detail_measure hxc_time_building_blocks.measure%TYPE
124: , detail_start_time hxc_time_building_blocks.start_time%TYPE
125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE
126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE

Line 123: , detail_measure hxc_time_building_blocks.measure%TYPE

119: , day_ovn hxc_time_building_blocks.object_version_number%TYPE
120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE
121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
122: , detail_type hxc_time_building_blocks.type%TYPE
123: , detail_measure hxc_time_building_blocks.measure%TYPE
124: , detail_start_time hxc_time_building_blocks.start_time%TYPE
125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE
126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
127: , detail_scope hxc_time_building_blocks.scope%TYPE

Line 124: , detail_start_time hxc_time_building_blocks.start_time%TYPE

120: , day_max_ovn hxc_time_building_blocks.object_version_number%TYPE
121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
122: , detail_type hxc_time_building_blocks.type%TYPE
123: , detail_measure hxc_time_building_blocks.measure%TYPE
124: , detail_start_time hxc_time_building_blocks.start_time%TYPE
125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE
126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
127: , detail_scope hxc_time_building_blocks.scope%TYPE
128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE

Line 125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE

121: , detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
122: , detail_type hxc_time_building_blocks.type%TYPE
123: , detail_measure hxc_time_building_blocks.measure%TYPE
124: , detail_start_time hxc_time_building_blocks.start_time%TYPE
125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE
126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
127: , detail_scope hxc_time_building_blocks.scope%TYPE
128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE
129: , detail_resource_type hxc_time_building_blocks.resource_type%TYPE

Line 126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE

122: , detail_type hxc_time_building_blocks.type%TYPE
123: , detail_measure hxc_time_building_blocks.measure%TYPE
124: , detail_start_time hxc_time_building_blocks.start_time%TYPE
125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE
126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
127: , detail_scope hxc_time_building_blocks.scope%TYPE
128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE
129: , detail_resource_type hxc_time_building_blocks.resource_type%TYPE
130: , detail_comment_text hxc_time_building_blocks.comment_text%TYPE

Line 127: , detail_scope hxc_time_building_blocks.scope%TYPE

123: , detail_measure hxc_time_building_blocks.measure%TYPE
124: , detail_start_time hxc_time_building_blocks.start_time%TYPE
125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE
126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
127: , detail_scope hxc_time_building_blocks.scope%TYPE
128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE
129: , detail_resource_type hxc_time_building_blocks.resource_type%TYPE
130: , detail_comment_text hxc_time_building_blocks.comment_text%TYPE
131: , detail_ovn hxc_time_building_blocks.object_version_number%TYPE

Line 128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE

124: , detail_start_time hxc_time_building_blocks.start_time%TYPE
125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE
126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
127: , detail_scope hxc_time_building_blocks.scope%TYPE
128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE
129: , detail_resource_type hxc_time_building_blocks.resource_type%TYPE
130: , detail_comment_text hxc_time_building_blocks.comment_text%TYPE
131: , detail_ovn hxc_time_building_blocks.object_version_number%TYPE
132: , detail_max_ovn hxc_time_building_blocks.object_version_number%TYPE

Line 129: , detail_resource_type hxc_time_building_blocks.resource_type%TYPE

125: , detail_stop_time hxc_time_building_blocks.stop_time%TYPE
126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
127: , detail_scope hxc_time_building_blocks.scope%TYPE
128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE
129: , detail_resource_type hxc_time_building_blocks.resource_type%TYPE
130: , detail_comment_text hxc_time_building_blocks.comment_text%TYPE
131: , detail_ovn hxc_time_building_blocks.object_version_number%TYPE
132: , detail_max_ovn hxc_time_building_blocks.object_version_number%TYPE
133: , detail_deleted VARCHAR2(1)

Line 130: , detail_comment_text hxc_time_building_blocks.comment_text%TYPE

126: , detail_parent_bb_id hxc_time_building_blocks.parent_building_block_id%TYPE
127: , detail_scope hxc_time_building_blocks.scope%TYPE
128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE
129: , detail_resource_type hxc_time_building_blocks.resource_type%TYPE
130: , detail_comment_text hxc_time_building_blocks.comment_text%TYPE
131: , detail_ovn hxc_time_building_blocks.object_version_number%TYPE
132: , detail_max_ovn hxc_time_building_blocks.object_version_number%TYPE
133: , detail_deleted VARCHAR2(1)
134: , detail_uom hxc_time_building_blocks.unit_of_measure%TYPE

Line 131: , detail_ovn hxc_time_building_blocks.object_version_number%TYPE

127: , detail_scope hxc_time_building_blocks.scope%TYPE
128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE
129: , detail_resource_type hxc_time_building_blocks.resource_type%TYPE
130: , detail_comment_text hxc_time_building_blocks.comment_text%TYPE
131: , detail_ovn hxc_time_building_blocks.object_version_number%TYPE
132: , detail_max_ovn hxc_time_building_blocks.object_version_number%TYPE
133: , detail_deleted VARCHAR2(1)
134: , detail_uom hxc_time_building_blocks.unit_of_measure%TYPE
135: , detail_date_from hxc_time_building_blocks.date_from%TYPE

Line 132: , detail_max_ovn hxc_time_building_blocks.object_version_number%TYPE

128: , detail_resource_id hxc_time_building_blocks.resource_id%TYPE
129: , detail_resource_type hxc_time_building_blocks.resource_type%TYPE
130: , detail_comment_text hxc_time_building_blocks.comment_text%TYPE
131: , detail_ovn hxc_time_building_blocks.object_version_number%TYPE
132: , detail_max_ovn hxc_time_building_blocks.object_version_number%TYPE
133: , detail_deleted VARCHAR2(1)
134: , detail_uom hxc_time_building_blocks.unit_of_measure%TYPE
135: , detail_date_from hxc_time_building_blocks.date_from%TYPE
136: , detail_date_to hxc_time_building_blocks.date_to%TYPE

Line 134: , detail_uom hxc_time_building_blocks.unit_of_measure%TYPE

130: , detail_comment_text hxc_time_building_blocks.comment_text%TYPE
131: , detail_ovn hxc_time_building_blocks.object_version_number%TYPE
132: , detail_max_ovn hxc_time_building_blocks.object_version_number%TYPE
133: , detail_deleted VARCHAR2(1)
134: , detail_uom hxc_time_building_blocks.unit_of_measure%TYPE
135: , detail_date_from hxc_time_building_blocks.date_from%TYPE
136: , detail_date_to hxc_time_building_blocks.date_to%TYPE
137: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE

Line 135: , detail_date_from hxc_time_building_blocks.date_from%TYPE

131: , detail_ovn hxc_time_building_blocks.object_version_number%TYPE
132: , detail_max_ovn hxc_time_building_blocks.object_version_number%TYPE
133: , detail_deleted VARCHAR2(1)
134: , detail_uom hxc_time_building_blocks.unit_of_measure%TYPE
135: , detail_date_from hxc_time_building_blocks.date_from%TYPE
136: , detail_date_to hxc_time_building_blocks.date_to%TYPE
137: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
139: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE

Line 136: , detail_date_to hxc_time_building_blocks.date_to%TYPE

132: , detail_max_ovn hxc_time_building_blocks.object_version_number%TYPE
133: , detail_deleted VARCHAR2(1)
134: , detail_uom hxc_time_building_blocks.unit_of_measure%TYPE
135: , detail_date_from hxc_time_building_blocks.date_from%TYPE
136: , detail_date_to hxc_time_building_blocks.date_to%TYPE
137: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
139: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
140: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE

Line 137: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE

133: , detail_deleted VARCHAR2(1)
134: , detail_uom hxc_time_building_blocks.unit_of_measure%TYPE
135: , detail_date_from hxc_time_building_blocks.date_from%TYPE
136: , detail_date_to hxc_time_building_blocks.date_to%TYPE
137: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
139: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
140: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
141: , detail_attribute1 hxc_time_attributes.attribute1%TYPE

Line 138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE

134: , detail_uom hxc_time_building_blocks.unit_of_measure%TYPE
135: , detail_date_from hxc_time_building_blocks.date_from%TYPE
136: , detail_date_to hxc_time_building_blocks.date_to%TYPE
137: , detail_approval_status hxc_time_building_blocks.approval_status%TYPE
138: , detail_approval_style_id hxc_time_building_blocks.approval_style_id%TYPE
139: , detail_ta_id hxc_time_attributes.time_attribute_id%TYPE
140: , detail_bld_blk_info_type_id hxc_time_attributes.bld_blk_info_type_id%TYPE
141: , detail_attribute1 hxc_time_attributes.attribute1%TYPE
142: , detail_attribute2 hxc_time_attributes.attribute1%TYPE

Line 231: TYPE r_detail_skipped IS RECORD (resource_id hxc_time_building_blocks.resource_id%TYPE,

227: G_TRANS_PREFIX varchar2(11);
228:
229: -- new globals for skipped records
230:
231: TYPE r_detail_skipped IS RECORD (resource_id hxc_time_building_blocks.resource_id%TYPE,
232: timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
233: timecard_ovn hxc_time_building_blocks.object_version_number%TYPE,
234: bb_id hxc_time_building_blocks.time_building_block_id%TYPE,
235: ovn hxc_time_building_blocks.object_version_number%TYPE,

Line 232: timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,

228:
229: -- new globals for skipped records
230:
231: TYPE r_detail_skipped IS RECORD (resource_id hxc_time_building_blocks.resource_id%TYPE,
232: timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
233: timecard_ovn hxc_time_building_blocks.object_version_number%TYPE,
234: bb_id hxc_time_building_blocks.time_building_block_id%TYPE,
235: ovn hxc_time_building_blocks.object_version_number%TYPE,
236: description VARCHAR2(80));

Line 233: timecard_ovn hxc_time_building_blocks.object_version_number%TYPE,

229: -- new globals for skipped records
230:
231: TYPE r_detail_skipped IS RECORD (resource_id hxc_time_building_blocks.resource_id%TYPE,
232: timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
233: timecard_ovn hxc_time_building_blocks.object_version_number%TYPE,
234: bb_id hxc_time_building_blocks.time_building_block_id%TYPE,
235: ovn hxc_time_building_blocks.object_version_number%TYPE,
236: description VARCHAR2(80));
237:

Line 234: bb_id hxc_time_building_blocks.time_building_block_id%TYPE,

230:
231: TYPE r_detail_skipped IS RECORD (resource_id hxc_time_building_blocks.resource_id%TYPE,
232: timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
233: timecard_ovn hxc_time_building_blocks.object_version_number%TYPE,
234: bb_id hxc_time_building_blocks.time_building_block_id%TYPE,
235: ovn hxc_time_building_blocks.object_version_number%TYPE,
236: description VARCHAR2(80));
237:
238: TYPE t_detail_skipped IS TABLE OF r_detail_skipped INDEX BY BINARY_INTEGER;

Line 235: ovn hxc_time_building_blocks.object_version_number%TYPE,

231: TYPE r_detail_skipped IS RECORD (resource_id hxc_time_building_blocks.resource_id%TYPE,
232: timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
233: timecard_ovn hxc_time_building_blocks.object_version_number%TYPE,
234: bb_id hxc_time_building_blocks.time_building_block_id%TYPE,
235: ovn hxc_time_building_blocks.object_version_number%TYPE,
236: description VARCHAR2(80));
237:
238: TYPE t_detail_skipped IS TABLE OF r_detail_skipped INDEX BY BINARY_INTEGER;
239: g_detail_skipped t_detail_skipped;