25: TIME_BUILDING_BLOCK_OVN time_building_block_ovn_arr
26: );
27:
28: TYPE timecard_info IS RECORD
29: (TIME_BUILDING_BLOCK_ID HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
30: OBJECT_VERSION_NUMBER HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE,
31: TYPE HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE,
32: START_TIME HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE,
33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE,
26: );
27:
28: TYPE timecard_info IS RECORD
29: (TIME_BUILDING_BLOCK_ID HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
30: OBJECT_VERSION_NUMBER HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE,
31: TYPE HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE,
32: START_TIME HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE,
33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE,
34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE,
27:
28: TYPE timecard_info IS RECORD
29: (TIME_BUILDING_BLOCK_ID HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
30: OBJECT_VERSION_NUMBER HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE,
31: TYPE HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE,
32: START_TIME HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE,
33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE,
34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE,
35: RESOURCE_TYPE HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE,
28: TYPE timecard_info IS RECORD
29: (TIME_BUILDING_BLOCK_ID HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
30: OBJECT_VERSION_NUMBER HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE,
31: TYPE HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE,
32: START_TIME HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE,
33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE,
34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE,
35: RESOURCE_TYPE HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE,
36: APPROVAL_STYLE_ID HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID%TYPE,
29: (TIME_BUILDING_BLOCK_ID HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
30: OBJECT_VERSION_NUMBER HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE,
31: TYPE HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE,
32: START_TIME HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE,
33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE,
34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE,
35: RESOURCE_TYPE HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE,
36: APPROVAL_STYLE_ID HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID%TYPE,
37: APPLICATION_SET_ID HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE,
30: OBJECT_VERSION_NUMBER HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE,
31: TYPE HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE,
32: START_TIME HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE,
33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE,
34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE,
35: RESOURCE_TYPE HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE,
36: APPROVAL_STYLE_ID HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID%TYPE,
37: APPLICATION_SET_ID HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE,
38: CREATION_DATE HXC_TIME_BUILDING_BLOCKS.CREATION_DATE%TYPE
31: TYPE HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE,
32: START_TIME HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE,
33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE,
34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE,
35: RESOURCE_TYPE HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE,
36: APPROVAL_STYLE_ID HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID%TYPE,
37: APPLICATION_SET_ID HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE,
38: CREATION_DATE HXC_TIME_BUILDING_BLOCKS.CREATION_DATE%TYPE
39: );
32: START_TIME HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE,
33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE,
34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE,
35: RESOURCE_TYPE HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE,
36: APPROVAL_STYLE_ID HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID%TYPE,
37: APPLICATION_SET_ID HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE,
38: CREATION_DATE HXC_TIME_BUILDING_BLOCKS.CREATION_DATE%TYPE
39: );
40:
33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE,
34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE,
35: RESOURCE_TYPE HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE,
36: APPROVAL_STYLE_ID HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID%TYPE,
37: APPLICATION_SET_ID HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE,
38: CREATION_DATE HXC_TIME_BUILDING_BLOCKS.CREATION_DATE%TYPE
39: );
40:
41: g_light_approval_style_id number := -99;
34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE,
35: RESOURCE_TYPE HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE,
36: APPROVAL_STYLE_ID HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID%TYPE,
37: APPLICATION_SET_ID HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%TYPE,
38: CREATION_DATE HXC_TIME_BUILDING_BLOCKS.CREATION_DATE%TYPE
39: );
40:
41: g_light_approval_style_id number := -99;
42:
51:
52: End get_item_key;
53:
54: Function is_timecard_resubmitted
55: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
56: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
57: p_resource_id in hxc_time_building_blocks.resource_id%type,
58: p_start_time in hxc_time_building_blocks.start_time%type,
59: p_stop_time in hxc_time_building_blocks.stop_time%type
52: End get_item_key;
53:
54: Function is_timecard_resubmitted
55: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
56: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
57: p_resource_id in hxc_time_building_blocks.resource_id%type,
58: p_start_time in hxc_time_building_blocks.start_time%type,
59: p_stop_time in hxc_time_building_blocks.stop_time%type
60: ) return varchar2 is
53:
54: Function is_timecard_resubmitted
55: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
56: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
57: p_resource_id in hxc_time_building_blocks.resource_id%type,
58: p_start_time in hxc_time_building_blocks.start_time%type,
59: p_stop_time in hxc_time_building_blocks.stop_time%type
60: ) return varchar2 is
61:
54: Function is_timecard_resubmitted
55: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
56: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
57: p_resource_id in hxc_time_building_blocks.resource_id%type,
58: p_start_time in hxc_time_building_blocks.start_time%type,
59: p_stop_time in hxc_time_building_blocks.stop_time%type
60: ) return varchar2 is
61:
62: cursor csr_resubmitted
55: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
56: p_timecard_ovn in hxc_time_building_blocks.object_version_number%type,
57: p_resource_id in hxc_time_building_blocks.resource_id%type,
58: p_start_time in hxc_time_building_blocks.start_time%type,
59: p_stop_time in hxc_time_building_blocks.stop_time%type
60: ) return varchar2 is
61:
62: cursor csr_resubmitted
63: (p_timecard_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
59: p_stop_time in hxc_time_building_blocks.stop_time%type
60: ) return varchar2 is
61:
62: cursor csr_resubmitted
63: (p_timecard_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
64: p_max_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
65: ) is
66: select 'YES'
67: from hxc_time_building_blocks
60: ) return varchar2 is
61:
62: cursor csr_resubmitted
63: (p_timecard_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
64: p_max_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
65: ) is
66: select 'YES'
67: from hxc_time_building_blocks
68: where time_building_block_id = p_timecard_id
63: (p_timecard_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
64: p_max_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
65: ) is
66: select 'YES'
67: from hxc_time_building_blocks
68: where time_building_block_id = p_timecard_id
69: and object_version_number <= p_max_ovn
70: and approval_status = 'SUBMITTED';
71:
69: and object_version_number <= p_max_ovn
70: and approval_status = 'SUBMITTED';
71:
72: cursor csr_further_check
73: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
74: p_resource_id in hxc_time_building_blocks.resource_id%type,
75: p_start_time in hxc_time_building_blocks.start_time%type,
76: p_stop_time in hxc_time_building_blocks.stop_time%type
77: ) is
70: and approval_status = 'SUBMITTED';
71:
72: cursor csr_further_check
73: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
74: p_resource_id in hxc_time_building_blocks.resource_id%type,
75: p_start_time in hxc_time_building_blocks.start_time%type,
76: p_stop_time in hxc_time_building_blocks.stop_time%type
77: ) is
78: select 'YES'
71:
72: cursor csr_further_check
73: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
74: p_resource_id in hxc_time_building_blocks.resource_id%type,
75: p_start_time in hxc_time_building_blocks.start_time%type,
76: p_stop_time in hxc_time_building_blocks.stop_time%type
77: ) is
78: select 'YES'
79: from hxc_time_building_blocks
72: cursor csr_further_check
73: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
74: p_resource_id in hxc_time_building_blocks.resource_id%type,
75: p_start_time in hxc_time_building_blocks.start_time%type,
76: p_stop_time in hxc_time_building_blocks.stop_time%type
77: ) is
78: select 'YES'
79: from hxc_time_building_blocks
80: where time_building_block_id <> p_timecard_id
75: p_start_time in hxc_time_building_blocks.start_time%type,
76: p_stop_time in hxc_time_building_blocks.stop_time%type
77: ) is
78: select 'YES'
79: from hxc_time_building_blocks
80: where time_building_block_id <> p_timecard_id
81: and approval_status = 'SUBMITTED'
82: and start_time <= p_stop_time
83: and stop_time >= p_start_time
111: End is_timecard_resubmitted;
112:
113: Procedure get_timecard_information
114: (p_blocks in hxc_block_table_type,
115: p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type,
116: p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type,
117: p_new_blocks out nocopy varchar2,
118: p_timecard_info out nocopy timecard_info
119: ) is
112:
113: Procedure get_timecard_information
114: (p_blocks in hxc_block_table_type,
115: p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type,
116: p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type,
117: p_new_blocks out nocopy varchar2,
118: p_timecard_info out nocopy timecard_info
119: ) is
120: l_timecard_index number;
150: from hxc_tc_ap_links
151: where timecard_id = p_tc_bb_id;
152:
153: Cursor c_creation_date
154: (l_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
155: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE
156: ) is
157: select creation_date
158: from hxc_time_building_blocks
151: where timecard_id = p_tc_bb_id;
152:
153: Cursor c_creation_date
154: (l_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
155: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE
156: ) is
157: select creation_date
158: from hxc_time_building_blocks
159: where time_building_block_id = l_app_id
154: (l_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
155: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE
156: ) is
157: select creation_date
158: from hxc_time_building_blocks
159: where time_building_block_id = l_app_id
160: and object_version_number = l_app_ovn;
161:
162: cursor c_app_period
159: where time_building_block_id = l_app_id
160: and object_version_number = l_app_ovn;
161:
162: cursor c_app_period
163: (p_resource_id hxc_time_building_blocks.resource_id%TYPE,
164: p_start_time hxc_time_building_blocks.start_time%TYPE,
165: p_stop_time hxc_time_building_blocks.stop_time%TYPE,
166: p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
167: ) is
160: and object_version_number = l_app_ovn;
161:
162: cursor c_app_period
163: (p_resource_id hxc_time_building_blocks.resource_id%TYPE,
164: p_start_time hxc_time_building_blocks.start_time%TYPE,
165: p_stop_time hxc_time_building_blocks.stop_time%TYPE,
166: p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
167: ) is
168: select application_period_id
161:
162: cursor c_app_period
163: (p_resource_id hxc_time_building_blocks.resource_id%TYPE,
164: p_start_time hxc_time_building_blocks.start_time%TYPE,
165: p_stop_time hxc_time_building_blocks.stop_time%TYPE,
166: p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
167: ) is
168: select application_period_id
169: from hxc_app_period_summary
187: and hasc.time_recipient_id = htr.time_recipient_id;
188:
189: l_application_set_id HXC_APPLICATION_SETS_V.APPLICATION_SET_ID%TYPE;
190: l_appl_recipients time_recipient_table;
191: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
192: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
193: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
194: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
195: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
188:
189: l_application_set_id HXC_APPLICATION_SETS_V.APPLICATION_SET_ID%TYPE;
190: l_appl_recipients time_recipient_table;
191: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
192: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
193: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
194: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
195: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
196: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
189: l_application_set_id HXC_APPLICATION_SETS_V.APPLICATION_SET_ID%TYPE;
190: l_appl_recipients time_recipient_table;
191: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
192: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
193: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
194: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
195: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
196: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
197: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
190: l_appl_recipients time_recipient_table;
191: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
192: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
193: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
194: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
195: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
196: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
197: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
198: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
191: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
192: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
193: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
194: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
195: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
196: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
197: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
198: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
199: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
192: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
193: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
194: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
195: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
196: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
197: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
198: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
199: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
200: l_tc_ap_links_table tc_ap_links_table;
193: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
194: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
195: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
196: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
197: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
198: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
199: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
200: l_tc_ap_links_table tc_ap_links_table;
201: l_index number ;
194: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
195: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
196: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
197: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
198: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
199: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
200: l_tc_ap_links_table tc_ap_links_table;
201: l_index number ;
202: l_assignment_periods hxc_timecard_utilities.periods;
195: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
196: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
197: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
198: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
199: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
200: l_tc_ap_links_table tc_ap_links_table;
201: l_index number ;
202: l_assignment_periods hxc_timecard_utilities.periods;
203: l_app_period_info application_period_table;
200: l_tc_ap_links_table tc_ap_links_table;
201: l_index number ;
202: l_assignment_periods hxc_timecard_utilities.periods;
203: l_app_period_info application_period_table;
204: l_creation_date hxc_time_building_blocks.creation_date%TYPE := NULL;
205: l_dup_index number;
206: l_detail_array ap_detail_links_rec;
207: l_index_1 number;
208: l_index_2 number;
320: hr_utility.set_location('Processing '||l_proc, 80);
321: end if;
322:
323: for l_index IN l_appl_recipients.first .. l_appl_recipients.last LOOP
324: /* Call to create an Application period in hxc_time_building blocks table */
325: l_time_building_block_id := null;
326: l_object_version_number := null;
327:
328: if g_debug then
469: p_messages in out nocopy hxc_message_table_type
470: ) return VARCHAR2 is
471:
472: l_item_key number;
473: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
474: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
475: l_new_building_blocks varchar2(3) := 'NO';
476: l_proc varchar2(70);
477: l_dummy varchar2(1);
470: ) return VARCHAR2 is
471:
472: l_item_key number;
473: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
474: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
475: l_new_building_blocks varchar2(3) := 'NO';
476: l_proc varchar2(70);
477: l_dummy varchar2(1);
478: l_active_asg boolean := true;