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_TIMESTORE_DEPOSIT dependencies on HXC_TIME_BUILDING_BLOCKS

Line 9: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

5: g_package CONSTANT VARCHAR2 (33) := 'hxc_timestore_deposit.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7:
8: PROCEDURE get_timecard_tables (
9: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
10: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
11: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
12: p_app_blocks OUT NOCOPY hxc_block_table_type,
13: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 26: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

22: );
23: END get_timecard_tables;
24:
25: PROCEDURE get_timecard_tables (
26: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
27: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
28: p_clear_mapping_cache IN BOOLEAN DEFAULT FALSE,
29: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
30: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

89: -- first and start afresh
90: --
91: -----------------------------------------------------------------------------
92: PROCEDURE create_bb (
93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

Line 94: p_type IN hxc_time_building_blocks.TYPE%TYPE,

90: --
91: -----------------------------------------------------------------------------
92: PROCEDURE create_bb (
93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

Line 95: p_measure IN hxc_time_building_blocks.measure%TYPE,

91: -----------------------------------------------------------------------------
92: PROCEDURE create_bb (
93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

Line 96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,

92: PROCEDURE create_bb (
93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,

Line 97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

93: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

Line 98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

94: p_type IN hxc_time_building_blocks.TYPE%TYPE,
95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,

Line 99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

95: p_measure IN hxc_time_building_blocks.measure%TYPE,
96: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

Line 101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

97: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

Line 102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,

98: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

Line 103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

99: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,

Line 104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

100: p_parent_is_new IN VARCHAR2,
101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,

Line 105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

101: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

102: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

Line 107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,

103: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
111: p_new IN VARCHAR2,

Line 108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,

104: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
111: p_new IN VARCHAR2,
112: p_changed IN VARCHAR2,

Line 109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

105: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
111: p_new IN VARCHAR2,
112: p_changed IN VARCHAR2,
113: p_app_blocks IN OUT NOCOPY hxc_block_table_type

Line 110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

106: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
107: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
108: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
109: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
110: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
111: p_new IN VARCHAR2,
112: p_changed IN VARCHAR2,
113: p_app_blocks IN OUT NOCOPY hxc_block_table_type
114: )

Line 118: l_parent_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;

114: )
115: IS
116: l_proc VARCHAR2 (72);
117: l_count_building_block PLS_INTEGER;
118: l_parent_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
119: l_parent_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
120: BEGIN
121: g_debug := hr_utility.debug_enabled;
122:

Line 119: l_parent_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;

115: IS
116: l_proc VARCHAR2 (72);
117: l_count_building_block PLS_INTEGER;
118: l_parent_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
119: l_parent_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
120: BEGIN
121: g_debug := hr_utility.debug_enabled;
122:
123: IF g_debug

Line 179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

175: -- call the create_bb procedure that accepts the new TYPE
176: -- and then convert it back to the old PL/SQL table.
177: -----------------------------------------------------------------------------
178: PROCEDURE create_bb (
179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

Line 180: p_type IN hxc_time_building_blocks.TYPE%TYPE,

176: -- and then convert it back to the old PL/SQL table.
177: -----------------------------------------------------------------------------
178: PROCEDURE create_bb (
179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

Line 181: p_measure IN hxc_time_building_blocks.measure%TYPE,

177: -----------------------------------------------------------------------------
178: PROCEDURE create_bb (
179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

Line 182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,

178: PROCEDURE create_bb (
179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,

Line 183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

179: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

Line 184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

180: p_type IN hxc_time_building_blocks.TYPE%TYPE,
181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,

Line 185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

181: p_measure IN hxc_time_building_blocks.measure%TYPE,
182: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

Line 187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

183: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

Line 188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,

184: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

Line 189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

185: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,

Line 190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

186: p_parent_is_new IN VARCHAR2,
187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,

Line 191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

187: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

188: p_object_version_number IN hxc_time_building_blocks.object_version_number%TYPE,
189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

Line 193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,

189: p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
197: p_new IN VARCHAR2,

Line 194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,

190: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
197: p_new IN VARCHAR2,
198: p_changed IN VARCHAR2,

Line 195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

191: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
197: p_new IN VARCHAR2,
198: p_changed IN VARCHAR2,
199: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info

Line 196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

192: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
193: p_date_from IN hxc_time_building_blocks.date_from%TYPE,
194: p_date_to IN hxc_time_building_blocks.date_to%TYPE,
195: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
196: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
197: p_new IN VARCHAR2,
198: p_changed IN VARCHAR2,
199: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info
200: )

Line 274: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

270: -- first and start afresh
271: --
272: -----------------------------------------------------------------------------
273: PROCEDURE create_timecard_bb (
274: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
275: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 275: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

271: --
272: -----------------------------------------------------------------------------
273: PROCEDURE create_timecard_bb (
274: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
275: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
279: -- default to person because there is no other resource type at the moment.

Line 277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

273: PROCEDURE create_timecard_bb (
274: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
275: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
279: -- default to person because there is no other resource type at the moment.
280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.

Line 278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

274: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
275: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
279: -- default to person because there is no other resource type at the moment.
280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.
282: -- if NULL we will get it of the preferences

Line 280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

276: -- We will set this automatic, depending on the mode used when depositing the TC
277: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
278: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
279: -- default to person because there is no other resource type at the moment.
280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.
282: -- if NULL we will get it of the preferences
283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

279: -- default to person because there is no other resource type at the moment.
280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.
282: -- if NULL we will get it of the preferences
283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
285: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
286: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
287: )

Line 284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

280: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
281: -- We cannot use approval_style_name because that is not unique.
282: -- if NULL we will get it of the preferences
283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
285: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
286: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
287: )
288: IS

Line 286: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

282: -- if NULL we will get it of the preferences
283: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
284: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
285: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
286: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
287: )
288: IS
289: l_proc VARCHAR2 (72);
290: l_count_building_block PLS_INTEGER;

Line 292: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;

288: IS
289: l_proc VARCHAR2 (72);
290: l_count_building_block PLS_INTEGER;
291: -- l_tc_days PLS_INTEGER;
292: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
293: -- l_building_block_index PLS_INTEGER;
294: BEGIN
295: g_debug := hr_utility.debug_enabled;
296:

Line 393: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

389: -- the new TYPE and then convert it back to the old PL/SQL table.
390: --
391: -----------------------------------------------------------------------------
392: PROCEDURE create_timecard_bb (
393: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
394: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 394: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

390: --
391: -----------------------------------------------------------------------------
392: PROCEDURE create_timecard_bb (
393: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
394: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
398: -- default to person because there is no other resource type at the moment.

Line 396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

392: PROCEDURE create_timecard_bb (
393: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
394: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
398: -- default to person because there is no other resource type at the moment.
399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.

Line 397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

393: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
394: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
398: -- default to person because there is no other resource type at the moment.
399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.
401: -- if NULL we will get it of the preferences

Line 399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

395: -- We will set this automatic, depending on the mode used when depositing the TC
396: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
397: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
398: -- default to person because there is no other resource type at the moment.
399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.
401: -- if NULL we will get it of the preferences
402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

398: -- default to person because there is no other resource type at the moment.
399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.
401: -- if NULL we will get it of the preferences
402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
404: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
405: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
406: )

Line 403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

399: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
400: -- We cannot use approval_style_name because that is not unique.
401: -- if NULL we will get it of the preferences
402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
404: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
405: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
406: )
407: IS

Line 405: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

401: -- if NULL we will get it of the preferences
402: p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
403: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
404: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
405: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
406: )
407: IS
408: l_proc VARCHAR2 (72);
409: l_blocks hxc_block_table_type;

Line 470: p_day IN hxc_time_building_blocks.start_time%TYPE,

466: -- clear it first and start afresh.
467: --
468: -----------------------------------------------------------------------------
469: PROCEDURE create_day_bb (
470: p_day IN hxc_time_building_blocks.start_time%TYPE,
471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

467: --
468: -----------------------------------------------------------------------------
469: PROCEDURE create_day_bb (
470: p_day IN hxc_time_building_blocks.start_time%TYPE,
471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

468: -----------------------------------------------------------------------------
469: PROCEDURE create_day_bb (
470: p_day IN hxc_time_building_blocks.start_time%TYPE,
471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

469: PROCEDURE create_day_bb (
470: p_day IN hxc_time_building_blocks.start_time%TYPE,
471: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
477: )

Line 476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

472: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
473: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
474: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
475: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
477: )
478: IS
479: l_proc VARCHAR2 (72);
480: l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;

Line 480: l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;

476: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
477: )
478: IS
479: l_proc VARCHAR2 (72);
480: l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
481: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
482: BEGIN
483: g_debug := hr_utility.debug_enabled;
484:

Line 481: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;

477: )
478: IS
479: l_proc VARCHAR2 (72);
480: l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
481: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
482: BEGIN
483: g_debug := hr_utility.debug_enabled;
484:
485: IF g_debug

Line 539: p_day IN hxc_time_building_blocks.start_time%TYPE,

535: -- the new TYPE and then convert it back to the old PL/SQL table.
536: --
537: -----------------------------------------------------------------------------
538: PROCEDURE create_day_bb (
539: p_day IN hxc_time_building_blocks.start_time%TYPE,
540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

536: --
537: -----------------------------------------------------------------------------
538: PROCEDURE create_day_bb (
539: p_day IN hxc_time_building_blocks.start_time%TYPE,
540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
544: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

537: -----------------------------------------------------------------------------
538: PROCEDURE create_day_bb (
539: p_day IN hxc_time_building_blocks.start_time%TYPE,
540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
544: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
545: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

538: PROCEDURE create_day_bb (
539: p_day IN hxc_time_building_blocks.start_time%TYPE,
540: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
544: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
545: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
546: )

Line 545: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

541: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
542: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
543: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
544: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
545: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
546: )
547: IS
548: l_proc VARCHAR2 (72);
549: l_blocks hxc_block_table_type;

Line 615: p_day IN hxc_time_building_blocks.start_time%TYPE,

611: -- clear it first and start afresh.
612: --
613: -----------------------------------------------------------------------------
614: PROCEDURE create_day_bb (
615: p_day IN hxc_time_building_blocks.start_time%TYPE,
616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

612: --
613: -----------------------------------------------------------------------------
614: PROCEDURE create_day_bb (
615: p_day IN hxc_time_building_blocks.start_time%TYPE,
616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

613: -----------------------------------------------------------------------------
614: PROCEDURE create_day_bb (
615: p_day IN hxc_time_building_blocks.start_time%TYPE,
616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
621: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

614: PROCEDURE create_day_bb (
615: p_day IN hxc_time_building_blocks.start_time%TYPE,
616: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
621: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
622: )

Line 621: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

617: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
618: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
619: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
620: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
621: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
622: )
623: IS
624: l_proc VARCHAR2 (72);
625: l_count_building_block PLS_INTEGER;

Line 629: -- l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;

625: l_count_building_block PLS_INTEGER;
626: -- l_building_block_index PLS_INTEGER;
627: l_parent_building_block_index PLS_INTEGER;
628: l_parent_is_new VARCHAR2 (1);
629: -- l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
630: -- l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
631: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
632: BEGIN
633: g_debug := hr_utility.debug_enabled;

Line 630: -- l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;

626: -- l_building_block_index PLS_INTEGER;
627: l_parent_building_block_index PLS_INTEGER;
628: l_parent_is_new VARCHAR2 (1);
629: -- l_timecard_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
630: -- l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
631: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
632: BEGIN
633: g_debug := hr_utility.debug_enabled;
634:

Line 761: p_day IN hxc_time_building_blocks.start_time%TYPE,

757: -- the new TYPE and then convert it back to the old PL/SQL table.
758: --
759: -----------------------------------------------------------------------------
760: PROCEDURE create_day_bb (
761: p_day IN hxc_time_building_blocks.start_time%TYPE,
762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

758: --
759: -----------------------------------------------------------------------------
760: PROCEDURE create_day_bb (
761: p_day IN hxc_time_building_blocks.start_time%TYPE,
762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
766: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

759: -----------------------------------------------------------------------------
760: PROCEDURE create_day_bb (
761: p_day IN hxc_time_building_blocks.start_time%TYPE,
762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
766: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

760: PROCEDURE create_day_bb (
761: p_day IN hxc_time_building_blocks.start_time%TYPE,
762: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
766: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
768: )

Line 767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

763: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
764: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
765: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
766: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
767: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
768: )
769: IS
770: l_proc VARCHAR2 (72);
771: l_blocks hxc_block_table_type;

Line 834: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

830: -- TBB, with a start date = the day passed in.
831: --
832: -----------------------------------------------------------------------------
833: PROCEDURE auto_create_timecard (
834: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
835: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
836: p_day IN hxc_time_building_blocks.start_time%TYPE,
837: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 835: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

831: --
832: -----------------------------------------------------------------------------
833: PROCEDURE auto_create_timecard (
834: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
835: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
836: p_day IN hxc_time_building_blocks.start_time%TYPE,
837: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
839: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

Line 836: p_day IN hxc_time_building_blocks.start_time%TYPE,

832: -----------------------------------------------------------------------------
833: PROCEDURE auto_create_timecard (
834: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
835: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
836: p_day IN hxc_time_building_blocks.start_time%TYPE,
837: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
839: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
840: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 840: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

836: p_day IN hxc_time_building_blocks.start_time%TYPE,
837: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
838: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
839: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
840: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
841: )
842: IS
843: l_proc VARCHAR2 (72);
844: l_timecard_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 844: l_timecard_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;

840: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
841: )
842: IS
843: l_proc VARCHAR2 (72);
844: l_timecard_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
845: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
846: l_period_start DATE;
847: l_period_end DATE;
848: l_tc_days PLS_INTEGER;

Line 845: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;

841: )
842: IS
843: l_proc VARCHAR2 (72);
844: l_timecard_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE;
845: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
846: l_period_start DATE;
847: l_period_end DATE;
848: l_tc_days PLS_INTEGER;
849: l_start_time hxc_time_building_blocks.start_time%TYPE;

Line 849: l_start_time hxc_time_building_blocks.start_time%TYPE;

845: l_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
846: l_period_start DATE;
847: l_period_end DATE;
848: l_tc_days PLS_INTEGER;
849: l_start_time hxc_time_building_blocks.start_time%TYPE;
850: l_stop_time hxc_time_building_blocks.stop_time%TYPE;
851: BEGIN
852: IF g_debug
853: THEN

Line 850: l_stop_time hxc_time_building_blocks.stop_time%TYPE;

846: l_period_start DATE;
847: l_period_end DATE;
848: l_tc_days PLS_INTEGER;
849: l_start_time hxc_time_building_blocks.start_time%TYPE;
850: l_stop_time hxc_time_building_blocks.stop_time%TYPE;
851: BEGIN
852: IF g_debug
853: THEN
854: l_proc := g_package || 'auto_create_timecard';

Line 956: p_type IN hxc_time_building_blocks.TYPE%TYPE,

952: -- clear it first and start afresh.
953: --
954: -----------------------------------------------------------------------------
955: PROCEDURE create_detail_bb (
956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

Line 957: p_measure IN hxc_time_building_blocks.measure%TYPE,

953: --
954: -----------------------------------------------------------------------------
955: PROCEDURE create_detail_bb (
956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,

Line 958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

954: -----------------------------------------------------------------------------
955: PROCEDURE create_detail_bb (
956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.

Line 959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

955: PROCEDURE create_detail_bb (
956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

Line 960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

956: p_type IN hxc_time_building_blocks.TYPE%TYPE,
957: p_measure IN hxc_time_building_blocks.measure%TYPE,
958: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

959: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

960: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

Line 965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

961: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

962: -- the user cannot manipulate this.
963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,

Line 967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

963: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

964: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
965: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
972: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

Line 970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,

966: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
967: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
968: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
972: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
973: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
974: )

Line 973: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

969: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
970: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
971: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
972: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
973: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
974: )
975: IS
976: l_proc VARCHAR2 (72);
977: l_count_building_block PLS_INTEGER;

Line 980: l_unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE;

976: l_proc VARCHAR2 (72);
977: l_count_building_block PLS_INTEGER;
978: l_parent_building_block_index PLS_INTEGER;
979: l_parent_is_new VARCHAR2 (1);
980: l_unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE;
981: BEGIN
982: g_debug := hr_utility.debug_enabled;
983:
984: IF g_debug

Line 1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,

1107: -- the new TYPE and then convert it back to the old PL/SQL table.
1108: --
1109: -----------------------------------------------------------------------------
1110: PROCEDURE create_detail_bb (
1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

Line 1112: p_measure IN hxc_time_building_blocks.measure%TYPE,

1108: --
1109: -----------------------------------------------------------------------------
1110: PROCEDURE create_detail_bb (
1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,

Line 1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

1109: -----------------------------------------------------------------------------
1110: PROCEDURE create_detail_bb (
1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.

Line 1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

1110: PROCEDURE create_detail_bb (
1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

Line 1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,

1111: p_type IN hxc_time_building_blocks.TYPE%TYPE,
1112: p_measure IN hxc_time_building_blocks.measure%TYPE,
1113: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

Line 1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,

1114: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1115: p_parent_building_block_id IN hxc_time_building_blocks.parent_building_block_id%TYPE,
1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

Line 1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

1116: -- For now, these need to be the same as the parent BB (the TIMECARD BB). We set this in the code,
1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,

1117: -- the user cannot manipulate this.
1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,

Line 1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

1118: -- p_approval_status IN hxc_time_building_blocks.approval_status%TYPE,
1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,

1119: -- p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1120: -- p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1127: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

Line 1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,

1121: -- p_approval_style_id IN hxc_time_building_blocks.approval_style_id%TYPE,
1122: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1123: p_parent_building_block_ovn IN hxc_time_building_blocks.parent_building_block_ovn%TYPE,
1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1127: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1128: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1129: )

Line 1128: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

1124: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1125: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1126: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1127: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1128: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1129: )
1130: IS
1131: l_proc VARCHAR2 (72);
1132: l_blocks hxc_block_table_type;

Line 1209: p_measure IN hxc_time_building_blocks.measure%TYPE,

1205: -- clear it first and start afresh.
1206: --
1207: -----------------------------------------------------------------------------
1208: PROCEDURE create_time_entry (
1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 1210: p_day IN hxc_time_building_blocks.start_time%TYPE,

1206: --
1207: -----------------------------------------------------------------------------
1208: PROCEDURE create_time_entry (
1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1207: -----------------------------------------------------------------------------
1208: PROCEDURE create_time_entry (
1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

1208: PROCEDURE create_time_entry (
1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1216: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

Line 1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

1209: p_measure IN hxc_time_building_blocks.measure%TYPE,
1210: p_day IN hxc_time_building_blocks.start_time%TYPE,
1211: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1212: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1216: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1217: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 1217: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

1213: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1214: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1215: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1216: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1217: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1218: )
1219: IS
1220: l_proc VARCHAR2 (72);
1221: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;

Line 1221: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;

1217: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1218: )
1219: IS
1220: l_proc VARCHAR2 (72);
1221: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1222: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1223: BEGIN
1224: g_debug := hr_utility.debug_enabled;
1225:

Line 1222: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;

1218: )
1219: IS
1220: l_proc VARCHAR2 (72);
1221: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1222: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1223: BEGIN
1224: g_debug := hr_utility.debug_enabled;
1225:
1226: IF g_debug

Line 1302: p_measure IN hxc_time_building_blocks.measure%TYPE,

1298: -- the new TYPE and then convert it back to the old PL/SQL table.
1299: --
1300: -----------------------------------------------------------------------------
1301: PROCEDURE create_time_entry (
1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 1303: p_day IN hxc_time_building_blocks.start_time%TYPE,

1299: --
1300: -----------------------------------------------------------------------------
1301: PROCEDURE create_time_entry (
1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1300: -----------------------------------------------------------------------------
1301: PROCEDURE create_time_entry (
1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

1301: PROCEDURE create_time_entry (
1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1309: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

Line 1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

1302: p_measure IN hxc_time_building_blocks.measure%TYPE,
1303: p_day IN hxc_time_building_blocks.start_time%TYPE,
1304: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1305: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1309: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1310: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 1310: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

1306: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1307: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1308: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1309: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1310: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1311: )
1312: IS
1313: l_proc VARCHAR2 (72);
1314: l_blocks hxc_block_table_type;

Line 1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

1378: -- clear it first and start afresh.
1379: --
1380: -----------------------------------------------------------------------------
1381: PROCEDURE create_time_entry (
1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,

1379: --
1380: -----------------------------------------------------------------------------
1381: PROCEDURE create_time_entry (
1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1380: -----------------------------------------------------------------------------
1381: PROCEDURE create_time_entry (
1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

1381: PROCEDURE create_time_entry (
1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1389: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

Line 1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

1382: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1383: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1384: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1385: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1389: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1390: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 1390: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

1386: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1387: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1388: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1389: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1390: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1391: )
1392: IS
1393: l_proc VARCHAR2 (72);
1394: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;

Line 1394: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;

1390: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1391: )
1392: IS
1393: l_proc VARCHAR2 (72);
1394: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1395: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1396: BEGIN
1397: g_debug := hr_utility.debug_enabled;
1398:

Line 1395: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;

1391: )
1392: IS
1393: l_proc VARCHAR2 (72);
1394: l_time_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE;
1395: l_timecard_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE;
1396: BEGIN
1397: g_debug := hr_utility.debug_enabled;
1398:
1399: IF g_debug

Line 1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

1471: -- the new TYPE and then convert it back to the old PL/SQL table.
1472: --
1473: -----------------------------------------------------------------------------
1474: PROCEDURE create_time_entry (
1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,

1472: --
1473: -----------------------------------------------------------------------------
1474: PROCEDURE create_time_entry (
1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1473: -----------------------------------------------------------------------------
1474: PROCEDURE create_time_entry (
1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

1474: PROCEDURE create_time_entry (
1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1482: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

Line 1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

1475: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1476: p_stop_time IN hxc_time_building_blocks.start_time%TYPE,
1477: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1478: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1482: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1483: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

Line 1483: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE

1479: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1480: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1481: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1482: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1483: p_time_building_block_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE
1484: )
1485: IS
1486: l_proc VARCHAR2 (72);
1487: l_blocks hxc_block_table_type;

Line 1557: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1553: -- belongs to the same group, this needs to be the same id.
1554: --
1555: -----------------------------------------------------------------------------
1556: PROCEDURE create_attribute (
1557: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1558: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
1559: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
1560: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1561: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1681: -- on another timecard, please clear it first and start afresh.
1682: --
1683: -----------------------------------------------------------------------------
1684: PROCEDURE update_building_block (
1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

Line 1686: p_measure IN hxc_time_building_blocks.measure%TYPE,

1682: --
1683: -----------------------------------------------------------------------------
1684: PROCEDURE update_building_block (
1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,

1683: -----------------------------------------------------------------------------
1684: PROCEDURE update_building_block (
1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1691: -- p_time_recipient_id IN NUMBER,

Line 1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

1684: PROCEDURE update_building_block (
1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1691: -- p_time_recipient_id IN NUMBER,
1692: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

1685: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1691: -- p_time_recipient_id IN NUMBER,
1692: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1693: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

1686: p_measure IN hxc_time_building_blocks.measure%TYPE,
1687: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1688: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1689: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1690: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1691: -- p_time_recipient_id IN NUMBER,
1692: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1693: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1694: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1832: -- the new TYPE and then convert it back to the old PL/SQL table.
1833: --
1834: -----------------------------------------------------------------------------
1835: PROCEDURE update_building_block (
1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

Line 1837: p_measure IN hxc_time_building_blocks.measure%TYPE,

1833: --
1834: -----------------------------------------------------------------------------
1835: PROCEDURE update_building_block (
1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

Line 1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,

1834: -----------------------------------------------------------------------------
1835: PROCEDURE update_building_block (
1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,

Line 1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

1835: PROCEDURE update_building_block (
1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,
1843: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,

Line 1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,

1836: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,
1843: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1844: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,

1837: p_measure IN hxc_time_building_blocks.measure%TYPE,
1838: p_unit_of_measure IN hxc_time_building_blocks.unit_of_measure%TYPE,
1839: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
1840: p_stop_time IN hxc_time_building_blocks.stop_time%TYPE,
1841: p_comment_text IN hxc_time_building_blocks.comment_text%TYPE,
1842: -- p_time_recipient_id IN NUMBER,
1843: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1844: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1845: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 1906: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1902: -- have to perform a deposit to get the delete through.
1903: --
1904: -----------------------------------------------------------------------------
1905: PROCEDURE delete_detail_bb (
1906: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1907: -- p_time_recipient_id IN NUMBER,
1908: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1909: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1910: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 1909: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,

1905: PROCEDURE delete_detail_bb (
1906: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1907: -- p_time_recipient_id IN NUMBER,
1908: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1909: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1910: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
1911: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1912: )
1913: IS

Line 1975: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

1971: -- the new TYPE and then convert it back to the old PL/SQL table.
1972: --
1973: -----------------------------------------------------------------------------
1974: PROCEDURE delete_detail_bb (
1975: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1976: -- p_time_recipient_id IN NUMBER,
1977: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1978: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1979: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 1978: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,

1974: PROCEDURE delete_detail_bb (
1975: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1976: -- p_time_recipient_id IN NUMBER,
1977: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1978: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
1979: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1980: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1981: )
1982: IS

Line 2038: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

2034: -- in this case).
2035: --
2036: -----------------------------------------------------------------------------
2037: PROCEDURE delete_timecard (
2038: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2039: p_mode IN VARCHAR2,
2040: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2041: -- Not used anymore, left in for backwards compatibility
2042: p_retrieval_process IN VARCHAR2,

Line 2044: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,

2040: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2041: -- Not used anymore, left in for backwards compatibility
2042: p_retrieval_process IN VARCHAR2,
2043: -- Not used anymore, left in for backwards compatibility
2044: p_effective_date IN hxc_time_building_blocks.stop_time%TYPE,
2045: -- Not used anymore, left in for backwards compatibility
2046: p_template IN VARCHAR2
2047: )
2048: IS

Line 2101: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

2097: --
2098: -----------------------------------------------------------------------------
2099: PROCEDURE update_attribute (
2100: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
2101: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2102: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2103: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
2104: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
2105: -- p_time_recipient_id IN NUMBER,

Line 2124: l_tbb_id hxc_time_building_blocks.time_building_block_id%TYPE;

2120: SELECT time_building_block_id
2121: FROM hxc_time_attribute_usages
2122: WHERE time_attribute_id = v_time_attribute_id;
2123:
2124: l_tbb_id hxc_time_building_blocks.time_building_block_id%TYPE;
2125: --csr_tbb_id%ROWTYPE;
2126: BEGIN
2127: g_debug := hr_utility.debug_enabled;
2128:

Line 2270: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

2266: --
2267: -----------------------------------------------------------------------------
2268: PROCEDURE update_attribute (
2269: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
2270: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2271: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2272: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
2273: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
2274: -- p_time_recipient_id IN NUMBER,

Line 2343: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

2339: p_app_blocks IN OUT NOCOPY hxc_block_table_type,
2340: -- hxc_self_service_time_deposit.timecard_info,
2341: p_messages OUT NOCOPY hxc_message_table_type,
2342: -- hxc_self_service_time_deposit.message_table,
2343: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2344: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2345: p_template IN VARCHAR2,
2346: p_item_type IN wf_items.item_type%TYPE,
2347: p_approval_prc IN wf_process_activities.process_name%TYPE,

Line 2344: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,

2340: -- hxc_self_service_time_deposit.timecard_info,
2341: p_messages OUT NOCOPY hxc_message_table_type,
2342: -- hxc_self_service_time_deposit.message_table,
2343: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2344: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2345: p_template IN VARCHAR2,
2346: p_item_type IN wf_items.item_type%TYPE,
2347: p_approval_prc IN wf_process_activities.process_name%TYPE,
2348: p_process_terminated_employees IN BOOLEAN,

Line 2634: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

2630: -- p_add_security IN BOOLEAN DEFAULT TRUE,
2631: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2632: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2633: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
2634: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2635: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2636: p_template IN VARCHAR2,
2637: p_item_type IN wf_items.item_type%TYPE,
2638: p_approval_prc IN wf_process_activities.process_name%TYPE,

Line 2635: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,

2631: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
2632: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
2633: p_messages OUT NOCOPY hxc_self_service_time_deposit.message_table,
2634: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
2635: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
2636: p_template IN VARCHAR2,
2637: p_item_type IN wf_items.item_type%TYPE,
2638: p_approval_prc IN wf_process_activities.process_name%TYPE,
2639: p_process_terminated_employees IN BOOLEAN,