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

Line 29: (TIME_BUILDING_BLOCK_ID HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,

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,

Line 30: OBJECT_VERSION_NUMBER HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%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,

Line 31: TYPE HXC_TIME_BUILDING_BLOCKS.TYPE%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,

Line 32: START_TIME HXC_TIME_BUILDING_BLOCKS.START_TIME%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,

Line 33: STOP_TIME HXC_TIME_BUILDING_BLOCKS.STOP_TIME%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,

Line 34: RESOURCE_ID HXC_TIME_BUILDING_BLOCKS.RESOURCE_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

Line 35: RESOURCE_TYPE HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%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: );

Line 36: APPROVAL_STYLE_ID HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID%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: );
40:

Line 37: APPLICATION_SET_ID HXC_TIME_BUILDING_BLOCKS.APPLICATION_SET_ID%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:
41: g_light_approval_style_id number := -99;

Line 38: CREATION_DATE HXC_TIME_BUILDING_BLOCKS.CREATION_DATE%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;
42:

Line 55: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,

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

Line 56: p_timecard_ovn in hxc_time_building_blocks.object_version_number%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

Line 57: p_resource_id in hxc_time_building_blocks.resource_id%type,

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:

Line 58: p_start_time in hxc_time_building_blocks.start_time%type,

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

Line 59: p_stop_time in hxc_time_building_blocks.stop_time%type

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,

Line 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

Line 64: p_max_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%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
68: where time_building_block_id = p_timecard_id

Line 67: from hxc_time_building_blocks

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:

Line 73: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,

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

Line 74: p_resource_id in hxc_time_building_blocks.resource_id%type,

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'

Line 75: p_start_time in hxc_time_building_blocks.start_time%type,

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

Line 76: p_stop_time in hxc_time_building_blocks.stop_time%type

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

Line 79: from hxc_time_building_blocks

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

Line 115: p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type,

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

Line 116: p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type,

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;

Line 155: (l_app_id hxc_time_building_blocks.time_building_block_id%TYPE,

151: from hxc_tc_ap_links
152: where timecard_id = p_tc_bb_id;
153:
154: Cursor c_creation_date
155: (l_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
156: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE
157: ) is
158: select creation_date
159: from hxc_time_building_blocks

Line 156: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE

152: where timecard_id = p_tc_bb_id;
153:
154: Cursor c_creation_date
155: (l_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
156: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE
157: ) is
158: select creation_date
159: from hxc_time_building_blocks
160: where time_building_block_id = l_app_id

Line 159: from hxc_time_building_blocks

155: (l_app_id hxc_time_building_blocks.time_building_block_id%TYPE,
156: l_app_ovn hxc_time_building_blocks.object_version_number%TYPE
157: ) is
158: select creation_date
159: from hxc_time_building_blocks
160: where time_building_block_id = l_app_id
161: and object_version_number = l_app_ovn;
162:
163: cursor c_app_period

Line 164: (p_resource_id hxc_time_building_blocks.resource_id%TYPE,

160: where time_building_block_id = l_app_id
161: and object_version_number = l_app_ovn;
162:
163: cursor c_app_period
164: (p_resource_id hxc_time_building_blocks.resource_id%TYPE,
165: p_start_time hxc_time_building_blocks.start_time%TYPE,
166: p_stop_time hxc_time_building_blocks.stop_time%TYPE,
167: p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
168: ) is

Line 165: p_start_time hxc_time_building_blocks.start_time%TYPE,

161: and object_version_number = l_app_ovn;
162:
163: cursor c_app_period
164: (p_resource_id hxc_time_building_blocks.resource_id%TYPE,
165: p_start_time hxc_time_building_blocks.start_time%TYPE,
166: p_stop_time hxc_time_building_blocks.stop_time%TYPE,
167: p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
168: ) is
169: select application_period_id

Line 166: p_stop_time hxc_time_building_blocks.stop_time%TYPE,

162:
163: cursor c_app_period
164: (p_resource_id hxc_time_building_blocks.resource_id%TYPE,
165: p_start_time hxc_time_building_blocks.start_time%TYPE,
166: p_stop_time hxc_time_building_blocks.stop_time%TYPE,
167: p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
168: ) is
169: select application_period_id
170: from hxc_app_period_summary

Line 192: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;

188: and hasc.time_recipient_id = htr.time_recipient_id;
189:
190: l_application_set_id HXC_APPLICATION_SETS_V.APPLICATION_SET_ID%TYPE;
191: l_appl_recipients time_recipient_table;
192: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
193: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
194: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
195: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;

Line 193: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;

189:
190: l_application_set_id HXC_APPLICATION_SETS_V.APPLICATION_SET_ID%TYPE;
191: l_appl_recipients time_recipient_table;
192: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
193: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
194: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
195: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
197: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;

Line 194: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;

190: l_application_set_id HXC_APPLICATION_SETS_V.APPLICATION_SET_ID%TYPE;
191: l_appl_recipients time_recipient_table;
192: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
193: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
194: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
195: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
197: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
198: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;

Line 195: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;

191: l_appl_recipients time_recipient_table;
192: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
193: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
194: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
195: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
197: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
198: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
199: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;

Line 196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;

192: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
193: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
194: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
195: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
197: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
198: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
199: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
200: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;

Line 197: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;

193: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
194: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
195: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
197: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
198: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
199: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
200: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
201: l_tc_ap_links_table tc_ap_links_table;

Line 198: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;

194: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;
195: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
197: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
198: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
199: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
200: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
201: l_tc_ap_links_table tc_ap_links_table;
202: l_index number ;

Line 199: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;

195: l_resource_type HXC_TIME_BUILDING_BLOCKS.RESOURCE_TYPE%TYPE ;
196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
197: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
198: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
199: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
200: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
201: l_tc_ap_links_table tc_ap_links_table;
202: l_index number ;
203: l_assignment_periods hxc_timecard_utilities.periods;

Line 200: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;

196: l_timecard_type HXC_TIME_BUILDING_BLOCKS.TYPE%TYPE ;
197: l_timecard_start_time HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
198: l_timecard_stop_time HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
199: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
200: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
201: l_tc_ap_links_table tc_ap_links_table;
202: l_index number ;
203: l_assignment_periods hxc_timecard_utilities.periods;
204: l_app_period_info application_period_table;

Line 205: l_creation_date hxc_time_building_blocks.creation_date%TYPE := NULL;

201: l_tc_ap_links_table tc_ap_links_table;
202: l_index number ;
203: l_assignment_periods hxc_timecard_utilities.periods;
204: l_app_period_info application_period_table;
205: l_creation_date hxc_time_building_blocks.creation_date%TYPE := NULL;
206: l_dup_index number;
207: l_detail_array ap_detail_links_rec;
208: l_index_1 number;
209: l_index_2 number;

Line 325: /* Call to create an Application period in hxc_time_building blocks table */

321: hr_utility.set_location('Processing '||l_proc, 80);
322: end if;
323:
324: for l_index IN l_appl_recipients.first .. l_appl_recipients.last LOOP
325: /* Call to create an Application period in hxc_time_building blocks table */
326: l_time_building_block_id := null;
327: l_object_version_number := null;
328:
329: if g_debug then

Line 490: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;

486: p_messages in out nocopy hxc_message_table_type
487: ) return VARCHAR2 is
488:
489: l_item_key number;
490: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
491: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
492: l_new_building_blocks varchar2(3) := 'NO';
493: l_proc varchar2(70);
494: l_dummy varchar2(1);

Line 491: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;

487: ) return VARCHAR2 is
488:
489: l_item_key number;
490: l_timecard_id hxc_time_building_blocks.time_building_block_id%type;
491: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
492: l_new_building_blocks varchar2(3) := 'NO';
493: l_proc varchar2(70);
494: l_dummy varchar2(1);
495: l_active_asg boolean := true;