[Home] [Help]
23: glb_debug BOOLEAN := FALSE;
24: g_debug BOOLEAN := hr_utility.debug_enabled;
25: -- Used for conditionally enabling hr_utility calls
26: -- variables for storing the old bld blk information
27: t_old_time_seq DBMS_SQL.number_table;
28: t_old_day_seq DBMS_SQL.number_table;
29: t_old_detail_seq DBMS_SQL.number_table;
30: t_old_time_bb_id DBMS_SQL.number_table;
31: t_old_day_bb_id DBMS_SQL.number_table;
24: g_debug BOOLEAN := hr_utility.debug_enabled;
25: -- Used for conditionally enabling hr_utility calls
26: -- variables for storing the old bld blk information
27: t_old_time_seq DBMS_SQL.number_table;
28: t_old_day_seq DBMS_SQL.number_table;
29: t_old_detail_seq DBMS_SQL.number_table;
30: t_old_time_bb_id DBMS_SQL.number_table;
31: t_old_day_bb_id DBMS_SQL.number_table;
32: t_old_detail_bb_id DBMS_SQL.number_table;
25: -- Used for conditionally enabling hr_utility calls
26: -- variables for storing the old bld blk information
27: t_old_time_seq DBMS_SQL.number_table;
28: t_old_day_seq DBMS_SQL.number_table;
29: t_old_detail_seq DBMS_SQL.number_table;
30: t_old_time_bb_id DBMS_SQL.number_table;
31: t_old_day_bb_id DBMS_SQL.number_table;
32: t_old_detail_bb_id DBMS_SQL.number_table;
33: t_old_time_ovn DBMS_SQL.number_table;
26: -- variables for storing the old bld blk information
27: t_old_time_seq DBMS_SQL.number_table;
28: t_old_day_seq DBMS_SQL.number_table;
29: t_old_detail_seq DBMS_SQL.number_table;
30: t_old_time_bb_id DBMS_SQL.number_table;
31: t_old_day_bb_id DBMS_SQL.number_table;
32: t_old_detail_bb_id DBMS_SQL.number_table;
33: t_old_time_ovn DBMS_SQL.number_table;
34: t_old_day_ovn DBMS_SQL.number_table;
27: t_old_time_seq DBMS_SQL.number_table;
28: t_old_day_seq DBMS_SQL.number_table;
29: t_old_detail_seq DBMS_SQL.number_table;
30: t_old_time_bb_id DBMS_SQL.number_table;
31: t_old_day_bb_id DBMS_SQL.number_table;
32: t_old_detail_bb_id DBMS_SQL.number_table;
33: t_old_time_ovn DBMS_SQL.number_table;
34: t_old_day_ovn DBMS_SQL.number_table;
35: t_old_detail_ovn DBMS_SQL.number_table;
28: t_old_day_seq DBMS_SQL.number_table;
29: t_old_detail_seq DBMS_SQL.number_table;
30: t_old_time_bb_id DBMS_SQL.number_table;
31: t_old_day_bb_id DBMS_SQL.number_table;
32: t_old_detail_bb_id DBMS_SQL.number_table;
33: t_old_time_ovn DBMS_SQL.number_table;
34: t_old_day_ovn DBMS_SQL.number_table;
35: t_old_detail_ovn DBMS_SQL.number_table;
36: -- dynamic SQL arrays
29: t_old_detail_seq DBMS_SQL.number_table;
30: t_old_time_bb_id DBMS_SQL.number_table;
31: t_old_day_bb_id DBMS_SQL.number_table;
32: t_old_detail_bb_id DBMS_SQL.number_table;
33: t_old_time_ovn DBMS_SQL.number_table;
34: t_old_day_ovn DBMS_SQL.number_table;
35: t_old_detail_ovn DBMS_SQL.number_table;
36: -- dynamic SQL arrays
37: t_timecard_bb_id DBMS_SQL.number_table;
30: t_old_time_bb_id DBMS_SQL.number_table;
31: t_old_day_bb_id DBMS_SQL.number_table;
32: t_old_detail_bb_id DBMS_SQL.number_table;
33: t_old_time_ovn DBMS_SQL.number_table;
34: t_old_day_ovn DBMS_SQL.number_table;
35: t_old_detail_ovn DBMS_SQL.number_table;
36: -- dynamic SQL arrays
37: t_timecard_bb_id DBMS_SQL.number_table;
38: t_timecard_ovn DBMS_SQL.number_table;
31: t_old_day_bb_id DBMS_SQL.number_table;
32: t_old_detail_bb_id DBMS_SQL.number_table;
33: t_old_time_ovn DBMS_SQL.number_table;
34: t_old_day_ovn DBMS_SQL.number_table;
35: t_old_detail_ovn DBMS_SQL.number_table;
36: -- dynamic SQL arrays
37: t_timecard_bb_id DBMS_SQL.number_table;
38: t_timecard_ovn DBMS_SQL.number_table;
39: t_timecard_max_ovn DBMS_SQL.number_table;
33: t_old_time_ovn DBMS_SQL.number_table;
34: t_old_day_ovn DBMS_SQL.number_table;
35: t_old_detail_ovn DBMS_SQL.number_table;
36: -- dynamic SQL arrays
37: t_timecard_bb_id DBMS_SQL.number_table;
38: t_timecard_ovn DBMS_SQL.number_table;
39: t_timecard_max_ovn DBMS_SQL.number_table;
40: t_timecard_start_time DBMS_SQL.date_table;
41: t_timecard_stop_time DBMS_SQL.date_table;
34: t_old_day_ovn DBMS_SQL.number_table;
35: t_old_detail_ovn DBMS_SQL.number_table;
36: -- dynamic SQL arrays
37: t_timecard_bb_id DBMS_SQL.number_table;
38: t_timecard_ovn DBMS_SQL.number_table;
39: t_timecard_max_ovn DBMS_SQL.number_table;
40: t_timecard_start_time DBMS_SQL.date_table;
41: t_timecard_stop_time DBMS_SQL.date_table;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;
35: t_old_detail_ovn DBMS_SQL.number_table;
36: -- dynamic SQL arrays
37: t_timecard_bb_id DBMS_SQL.number_table;
38: t_timecard_ovn DBMS_SQL.number_table;
39: t_timecard_max_ovn DBMS_SQL.number_table;
40: t_timecard_start_time DBMS_SQL.date_table;
41: t_timecard_stop_time DBMS_SQL.date_table;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;
43: t_timecard_deleted DBMS_SQL.varchar2_table;
36: -- dynamic SQL arrays
37: t_timecard_bb_id DBMS_SQL.number_table;
38: t_timecard_ovn DBMS_SQL.number_table;
39: t_timecard_max_ovn DBMS_SQL.number_table;
40: t_timecard_start_time DBMS_SQL.date_table;
41: t_timecard_stop_time DBMS_SQL.date_table;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;
43: t_timecard_deleted DBMS_SQL.varchar2_table;
44: t_day_bb_id DBMS_SQL.number_table;
37: t_timecard_bb_id DBMS_SQL.number_table;
38: t_timecard_ovn DBMS_SQL.number_table;
39: t_timecard_max_ovn DBMS_SQL.number_table;
40: t_timecard_start_time DBMS_SQL.date_table;
41: t_timecard_stop_time DBMS_SQL.date_table;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;
43: t_timecard_deleted DBMS_SQL.varchar2_table;
44: t_day_bb_id DBMS_SQL.number_table;
45: t_day_ovn DBMS_SQL.number_table;
38: t_timecard_ovn DBMS_SQL.number_table;
39: t_timecard_max_ovn DBMS_SQL.number_table;
40: t_timecard_start_time DBMS_SQL.date_table;
41: t_timecard_stop_time DBMS_SQL.date_table;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;
43: t_timecard_deleted DBMS_SQL.varchar2_table;
44: t_day_bb_id DBMS_SQL.number_table;
45: t_day_ovn DBMS_SQL.number_table;
46: t_day_start_time DBMS_SQL.date_table;
39: t_timecard_max_ovn DBMS_SQL.number_table;
40: t_timecard_start_time DBMS_SQL.date_table;
41: t_timecard_stop_time DBMS_SQL.date_table;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;
43: t_timecard_deleted DBMS_SQL.varchar2_table;
44: t_day_bb_id DBMS_SQL.number_table;
45: t_day_ovn DBMS_SQL.number_table;
46: t_day_start_time DBMS_SQL.date_table;
47: t_day_stop_time DBMS_SQL.date_table;
40: t_timecard_start_time DBMS_SQL.date_table;
41: t_timecard_stop_time DBMS_SQL.date_table;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;
43: t_timecard_deleted DBMS_SQL.varchar2_table;
44: t_day_bb_id DBMS_SQL.number_table;
45: t_day_ovn DBMS_SQL.number_table;
46: t_day_start_time DBMS_SQL.date_table;
47: t_day_stop_time DBMS_SQL.date_table;
48: t_day_max_ovn DBMS_SQL.number_table;
41: t_timecard_stop_time DBMS_SQL.date_table;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;
43: t_timecard_deleted DBMS_SQL.varchar2_table;
44: t_day_bb_id DBMS_SQL.number_table;
45: t_day_ovn DBMS_SQL.number_table;
46: t_day_start_time DBMS_SQL.date_table;
47: t_day_stop_time DBMS_SQL.date_table;
48: t_day_max_ovn DBMS_SQL.number_table;
49: t_detail_bb_id DBMS_SQL.number_table;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;
43: t_timecard_deleted DBMS_SQL.varchar2_table;
44: t_day_bb_id DBMS_SQL.number_table;
45: t_day_ovn DBMS_SQL.number_table;
46: t_day_start_time DBMS_SQL.date_table;
47: t_day_stop_time DBMS_SQL.date_table;
48: t_day_max_ovn DBMS_SQL.number_table;
49: t_detail_bb_id DBMS_SQL.number_table;
50: t_detail_parent_id DBMS_SQL.number_table;
43: t_timecard_deleted DBMS_SQL.varchar2_table;
44: t_day_bb_id DBMS_SQL.number_table;
45: t_day_ovn DBMS_SQL.number_table;
46: t_day_start_time DBMS_SQL.date_table;
47: t_day_stop_time DBMS_SQL.date_table;
48: t_day_max_ovn DBMS_SQL.number_table;
49: t_detail_bb_id DBMS_SQL.number_table;
50: t_detail_parent_id DBMS_SQL.number_table;
51: t_detail_resource_type DBMS_SQL.varchar2_table;
44: t_day_bb_id DBMS_SQL.number_table;
45: t_day_ovn DBMS_SQL.number_table;
46: t_day_start_time DBMS_SQL.date_table;
47: t_day_stop_time DBMS_SQL.date_table;
48: t_day_max_ovn DBMS_SQL.number_table;
49: t_detail_bb_id DBMS_SQL.number_table;
50: t_detail_parent_id DBMS_SQL.number_table;
51: t_detail_resource_type DBMS_SQL.varchar2_table;
52: t_detail_resource_id DBMS_SQL.number_table;
45: t_day_ovn DBMS_SQL.number_table;
46: t_day_start_time DBMS_SQL.date_table;
47: t_day_stop_time DBMS_SQL.date_table;
48: t_day_max_ovn DBMS_SQL.number_table;
49: t_detail_bb_id DBMS_SQL.number_table;
50: t_detail_parent_id DBMS_SQL.number_table;
51: t_detail_resource_type DBMS_SQL.varchar2_table;
52: t_detail_resource_id DBMS_SQL.number_table;
53: t_detail_comment_text DBMS_SQL.varchar2_table;
46: t_day_start_time DBMS_SQL.date_table;
47: t_day_stop_time DBMS_SQL.date_table;
48: t_day_max_ovn DBMS_SQL.number_table;
49: t_detail_bb_id DBMS_SQL.number_table;
50: t_detail_parent_id DBMS_SQL.number_table;
51: t_detail_resource_type DBMS_SQL.varchar2_table;
52: t_detail_resource_id DBMS_SQL.number_table;
53: t_detail_comment_text DBMS_SQL.varchar2_table;
54: t_detail_start_time DBMS_SQL.date_table;
47: t_day_stop_time DBMS_SQL.date_table;
48: t_day_max_ovn DBMS_SQL.number_table;
49: t_detail_bb_id DBMS_SQL.number_table;
50: t_detail_parent_id DBMS_SQL.number_table;
51: t_detail_resource_type DBMS_SQL.varchar2_table;
52: t_detail_resource_id DBMS_SQL.number_table;
53: t_detail_comment_text DBMS_SQL.varchar2_table;
54: t_detail_start_time DBMS_SQL.date_table;
55: t_detail_stop_time DBMS_SQL.date_table;
48: t_day_max_ovn DBMS_SQL.number_table;
49: t_detail_bb_id DBMS_SQL.number_table;
50: t_detail_parent_id DBMS_SQL.number_table;
51: t_detail_resource_type DBMS_SQL.varchar2_table;
52: t_detail_resource_id DBMS_SQL.number_table;
53: t_detail_comment_text DBMS_SQL.varchar2_table;
54: t_detail_start_time DBMS_SQL.date_table;
55: t_detail_stop_time DBMS_SQL.date_table;
56: t_detail_measure DBMS_SQL.number_table;
49: t_detail_bb_id DBMS_SQL.number_table;
50: t_detail_parent_id DBMS_SQL.number_table;
51: t_detail_resource_type DBMS_SQL.varchar2_table;
52: t_detail_resource_id DBMS_SQL.number_table;
53: t_detail_comment_text DBMS_SQL.varchar2_table;
54: t_detail_start_time DBMS_SQL.date_table;
55: t_detail_stop_time DBMS_SQL.date_table;
56: t_detail_measure DBMS_SQL.number_table;
57: t_detail_scope DBMS_SQL.varchar2_table;
50: t_detail_parent_id DBMS_SQL.number_table;
51: t_detail_resource_type DBMS_SQL.varchar2_table;
52: t_detail_resource_id DBMS_SQL.number_table;
53: t_detail_comment_text DBMS_SQL.varchar2_table;
54: t_detail_start_time DBMS_SQL.date_table;
55: t_detail_stop_time DBMS_SQL.date_table;
56: t_detail_measure DBMS_SQL.number_table;
57: t_detail_scope DBMS_SQL.varchar2_table;
58: t_detail_type DBMS_SQL.varchar2_table;
51: t_detail_resource_type DBMS_SQL.varchar2_table;
52: t_detail_resource_id DBMS_SQL.number_table;
53: t_detail_comment_text DBMS_SQL.varchar2_table;
54: t_detail_start_time DBMS_SQL.date_table;
55: t_detail_stop_time DBMS_SQL.date_table;
56: t_detail_measure DBMS_SQL.number_table;
57: t_detail_scope DBMS_SQL.varchar2_table;
58: t_detail_type DBMS_SQL.varchar2_table;
59: t_detail_ta_id DBMS_SQL.number_table;
52: t_detail_resource_id DBMS_SQL.number_table;
53: t_detail_comment_text DBMS_SQL.varchar2_table;
54: t_detail_start_time DBMS_SQL.date_table;
55: t_detail_stop_time DBMS_SQL.date_table;
56: t_detail_measure DBMS_SQL.number_table;
57: t_detail_scope DBMS_SQL.varchar2_table;
58: t_detail_type DBMS_SQL.varchar2_table;
59: t_detail_ta_id DBMS_SQL.number_table;
60: t_detail_bld_blk_info_type_id DBMS_SQL.number_table;
53: t_detail_comment_text DBMS_SQL.varchar2_table;
54: t_detail_start_time DBMS_SQL.date_table;
55: t_detail_stop_time DBMS_SQL.date_table;
56: t_detail_measure DBMS_SQL.number_table;
57: t_detail_scope DBMS_SQL.varchar2_table;
58: t_detail_type DBMS_SQL.varchar2_table;
59: t_detail_ta_id DBMS_SQL.number_table;
60: t_detail_bld_blk_info_type_id DBMS_SQL.number_table;
61: t_detail_attribute1 DBMS_SQL.varchar2_table;
54: t_detail_start_time DBMS_SQL.date_table;
55: t_detail_stop_time DBMS_SQL.date_table;
56: t_detail_measure DBMS_SQL.number_table;
57: t_detail_scope DBMS_SQL.varchar2_table;
58: t_detail_type DBMS_SQL.varchar2_table;
59: t_detail_ta_id DBMS_SQL.number_table;
60: t_detail_bld_blk_info_type_id DBMS_SQL.number_table;
61: t_detail_attribute1 DBMS_SQL.varchar2_table;
62: t_detail_attribute2 DBMS_SQL.varchar2_table;
55: t_detail_stop_time DBMS_SQL.date_table;
56: t_detail_measure DBMS_SQL.number_table;
57: t_detail_scope DBMS_SQL.varchar2_table;
58: t_detail_type DBMS_SQL.varchar2_table;
59: t_detail_ta_id DBMS_SQL.number_table;
60: t_detail_bld_blk_info_type_id DBMS_SQL.number_table;
61: t_detail_attribute1 DBMS_SQL.varchar2_table;
62: t_detail_attribute2 DBMS_SQL.varchar2_table;
63: t_detail_attribute3 DBMS_SQL.varchar2_table;
56: t_detail_measure DBMS_SQL.number_table;
57: t_detail_scope DBMS_SQL.varchar2_table;
58: t_detail_type DBMS_SQL.varchar2_table;
59: t_detail_ta_id DBMS_SQL.number_table;
60: t_detail_bld_blk_info_type_id DBMS_SQL.number_table;
61: t_detail_attribute1 DBMS_SQL.varchar2_table;
62: t_detail_attribute2 DBMS_SQL.varchar2_table;
63: t_detail_attribute3 DBMS_SQL.varchar2_table;
64: t_detail_attribute4 DBMS_SQL.varchar2_table;
57: t_detail_scope DBMS_SQL.varchar2_table;
58: t_detail_type DBMS_SQL.varchar2_table;
59: t_detail_ta_id DBMS_SQL.number_table;
60: t_detail_bld_blk_info_type_id DBMS_SQL.number_table;
61: t_detail_attribute1 DBMS_SQL.varchar2_table;
62: t_detail_attribute2 DBMS_SQL.varchar2_table;
63: t_detail_attribute3 DBMS_SQL.varchar2_table;
64: t_detail_attribute4 DBMS_SQL.varchar2_table;
65: t_detail_attribute5 DBMS_SQL.varchar2_table;
58: t_detail_type DBMS_SQL.varchar2_table;
59: t_detail_ta_id DBMS_SQL.number_table;
60: t_detail_bld_blk_info_type_id DBMS_SQL.number_table;
61: t_detail_attribute1 DBMS_SQL.varchar2_table;
62: t_detail_attribute2 DBMS_SQL.varchar2_table;
63: t_detail_attribute3 DBMS_SQL.varchar2_table;
64: t_detail_attribute4 DBMS_SQL.varchar2_table;
65: t_detail_attribute5 DBMS_SQL.varchar2_table;
66: t_detail_attribute6 DBMS_SQL.varchar2_table;
59: t_detail_ta_id DBMS_SQL.number_table;
60: t_detail_bld_blk_info_type_id DBMS_SQL.number_table;
61: t_detail_attribute1 DBMS_SQL.varchar2_table;
62: t_detail_attribute2 DBMS_SQL.varchar2_table;
63: t_detail_attribute3 DBMS_SQL.varchar2_table;
64: t_detail_attribute4 DBMS_SQL.varchar2_table;
65: t_detail_attribute5 DBMS_SQL.varchar2_table;
66: t_detail_attribute6 DBMS_SQL.varchar2_table;
67: t_detail_attribute7 DBMS_SQL.varchar2_table;
60: t_detail_bld_blk_info_type_id DBMS_SQL.number_table;
61: t_detail_attribute1 DBMS_SQL.varchar2_table;
62: t_detail_attribute2 DBMS_SQL.varchar2_table;
63: t_detail_attribute3 DBMS_SQL.varchar2_table;
64: t_detail_attribute4 DBMS_SQL.varchar2_table;
65: t_detail_attribute5 DBMS_SQL.varchar2_table;
66: t_detail_attribute6 DBMS_SQL.varchar2_table;
67: t_detail_attribute7 DBMS_SQL.varchar2_table;
68: t_detail_attribute8 DBMS_SQL.varchar2_table;
61: t_detail_attribute1 DBMS_SQL.varchar2_table;
62: t_detail_attribute2 DBMS_SQL.varchar2_table;
63: t_detail_attribute3 DBMS_SQL.varchar2_table;
64: t_detail_attribute4 DBMS_SQL.varchar2_table;
65: t_detail_attribute5 DBMS_SQL.varchar2_table;
66: t_detail_attribute6 DBMS_SQL.varchar2_table;
67: t_detail_attribute7 DBMS_SQL.varchar2_table;
68: t_detail_attribute8 DBMS_SQL.varchar2_table;
69: t_detail_attribute9 DBMS_SQL.varchar2_table;
62: t_detail_attribute2 DBMS_SQL.varchar2_table;
63: t_detail_attribute3 DBMS_SQL.varchar2_table;
64: t_detail_attribute4 DBMS_SQL.varchar2_table;
65: t_detail_attribute5 DBMS_SQL.varchar2_table;
66: t_detail_attribute6 DBMS_SQL.varchar2_table;
67: t_detail_attribute7 DBMS_SQL.varchar2_table;
68: t_detail_attribute8 DBMS_SQL.varchar2_table;
69: t_detail_attribute9 DBMS_SQL.varchar2_table;
70: t_detail_attribute10 DBMS_SQL.varchar2_table;
63: t_detail_attribute3 DBMS_SQL.varchar2_table;
64: t_detail_attribute4 DBMS_SQL.varchar2_table;
65: t_detail_attribute5 DBMS_SQL.varchar2_table;
66: t_detail_attribute6 DBMS_SQL.varchar2_table;
67: t_detail_attribute7 DBMS_SQL.varchar2_table;
68: t_detail_attribute8 DBMS_SQL.varchar2_table;
69: t_detail_attribute9 DBMS_SQL.varchar2_table;
70: t_detail_attribute10 DBMS_SQL.varchar2_table;
71: t_detail_attribute11 DBMS_SQL.varchar2_table;
64: t_detail_attribute4 DBMS_SQL.varchar2_table;
65: t_detail_attribute5 DBMS_SQL.varchar2_table;
66: t_detail_attribute6 DBMS_SQL.varchar2_table;
67: t_detail_attribute7 DBMS_SQL.varchar2_table;
68: t_detail_attribute8 DBMS_SQL.varchar2_table;
69: t_detail_attribute9 DBMS_SQL.varchar2_table;
70: t_detail_attribute10 DBMS_SQL.varchar2_table;
71: t_detail_attribute11 DBMS_SQL.varchar2_table;
72: t_detail_attribute12 DBMS_SQL.varchar2_table;
65: t_detail_attribute5 DBMS_SQL.varchar2_table;
66: t_detail_attribute6 DBMS_SQL.varchar2_table;
67: t_detail_attribute7 DBMS_SQL.varchar2_table;
68: t_detail_attribute8 DBMS_SQL.varchar2_table;
69: t_detail_attribute9 DBMS_SQL.varchar2_table;
70: t_detail_attribute10 DBMS_SQL.varchar2_table;
71: t_detail_attribute11 DBMS_SQL.varchar2_table;
72: t_detail_attribute12 DBMS_SQL.varchar2_table;
73: t_detail_attribute13 DBMS_SQL.varchar2_table;
66: t_detail_attribute6 DBMS_SQL.varchar2_table;
67: t_detail_attribute7 DBMS_SQL.varchar2_table;
68: t_detail_attribute8 DBMS_SQL.varchar2_table;
69: t_detail_attribute9 DBMS_SQL.varchar2_table;
70: t_detail_attribute10 DBMS_SQL.varchar2_table;
71: t_detail_attribute11 DBMS_SQL.varchar2_table;
72: t_detail_attribute12 DBMS_SQL.varchar2_table;
73: t_detail_attribute13 DBMS_SQL.varchar2_table;
74: t_detail_attribute14 DBMS_SQL.varchar2_table;
67: t_detail_attribute7 DBMS_SQL.varchar2_table;
68: t_detail_attribute8 DBMS_SQL.varchar2_table;
69: t_detail_attribute9 DBMS_SQL.varchar2_table;
70: t_detail_attribute10 DBMS_SQL.varchar2_table;
71: t_detail_attribute11 DBMS_SQL.varchar2_table;
72: t_detail_attribute12 DBMS_SQL.varchar2_table;
73: t_detail_attribute13 DBMS_SQL.varchar2_table;
74: t_detail_attribute14 DBMS_SQL.varchar2_table;
75: t_detail_attribute15 DBMS_SQL.varchar2_table;
68: t_detail_attribute8 DBMS_SQL.varchar2_table;
69: t_detail_attribute9 DBMS_SQL.varchar2_table;
70: t_detail_attribute10 DBMS_SQL.varchar2_table;
71: t_detail_attribute11 DBMS_SQL.varchar2_table;
72: t_detail_attribute12 DBMS_SQL.varchar2_table;
73: t_detail_attribute13 DBMS_SQL.varchar2_table;
74: t_detail_attribute14 DBMS_SQL.varchar2_table;
75: t_detail_attribute15 DBMS_SQL.varchar2_table;
76: t_detail_attribute16 DBMS_SQL.varchar2_table;
69: t_detail_attribute9 DBMS_SQL.varchar2_table;
70: t_detail_attribute10 DBMS_SQL.varchar2_table;
71: t_detail_attribute11 DBMS_SQL.varchar2_table;
72: t_detail_attribute12 DBMS_SQL.varchar2_table;
73: t_detail_attribute13 DBMS_SQL.varchar2_table;
74: t_detail_attribute14 DBMS_SQL.varchar2_table;
75: t_detail_attribute15 DBMS_SQL.varchar2_table;
76: t_detail_attribute16 DBMS_SQL.varchar2_table;
77: t_detail_attribute17 DBMS_SQL.varchar2_table;
70: t_detail_attribute10 DBMS_SQL.varchar2_table;
71: t_detail_attribute11 DBMS_SQL.varchar2_table;
72: t_detail_attribute12 DBMS_SQL.varchar2_table;
73: t_detail_attribute13 DBMS_SQL.varchar2_table;
74: t_detail_attribute14 DBMS_SQL.varchar2_table;
75: t_detail_attribute15 DBMS_SQL.varchar2_table;
76: t_detail_attribute16 DBMS_SQL.varchar2_table;
77: t_detail_attribute17 DBMS_SQL.varchar2_table;
78: t_detail_attribute18 DBMS_SQL.varchar2_table;
71: t_detail_attribute11 DBMS_SQL.varchar2_table;
72: t_detail_attribute12 DBMS_SQL.varchar2_table;
73: t_detail_attribute13 DBMS_SQL.varchar2_table;
74: t_detail_attribute14 DBMS_SQL.varchar2_table;
75: t_detail_attribute15 DBMS_SQL.varchar2_table;
76: t_detail_attribute16 DBMS_SQL.varchar2_table;
77: t_detail_attribute17 DBMS_SQL.varchar2_table;
78: t_detail_attribute18 DBMS_SQL.varchar2_table;
79: t_detail_attribute19 DBMS_SQL.varchar2_table;
72: t_detail_attribute12 DBMS_SQL.varchar2_table;
73: t_detail_attribute13 DBMS_SQL.varchar2_table;
74: t_detail_attribute14 DBMS_SQL.varchar2_table;
75: t_detail_attribute15 DBMS_SQL.varchar2_table;
76: t_detail_attribute16 DBMS_SQL.varchar2_table;
77: t_detail_attribute17 DBMS_SQL.varchar2_table;
78: t_detail_attribute18 DBMS_SQL.varchar2_table;
79: t_detail_attribute19 DBMS_SQL.varchar2_table;
80: t_detail_attribute20 DBMS_SQL.varchar2_table;
73: t_detail_attribute13 DBMS_SQL.varchar2_table;
74: t_detail_attribute14 DBMS_SQL.varchar2_table;
75: t_detail_attribute15 DBMS_SQL.varchar2_table;
76: t_detail_attribute16 DBMS_SQL.varchar2_table;
77: t_detail_attribute17 DBMS_SQL.varchar2_table;
78: t_detail_attribute18 DBMS_SQL.varchar2_table;
79: t_detail_attribute19 DBMS_SQL.varchar2_table;
80: t_detail_attribute20 DBMS_SQL.varchar2_table;
81: t_detail_attribute21 DBMS_SQL.varchar2_table;
74: t_detail_attribute14 DBMS_SQL.varchar2_table;
75: t_detail_attribute15 DBMS_SQL.varchar2_table;
76: t_detail_attribute16 DBMS_SQL.varchar2_table;
77: t_detail_attribute17 DBMS_SQL.varchar2_table;
78: t_detail_attribute18 DBMS_SQL.varchar2_table;
79: t_detail_attribute19 DBMS_SQL.varchar2_table;
80: t_detail_attribute20 DBMS_SQL.varchar2_table;
81: t_detail_attribute21 DBMS_SQL.varchar2_table;
82: t_detail_attribute22 DBMS_SQL.varchar2_table;
75: t_detail_attribute15 DBMS_SQL.varchar2_table;
76: t_detail_attribute16 DBMS_SQL.varchar2_table;
77: t_detail_attribute17 DBMS_SQL.varchar2_table;
78: t_detail_attribute18 DBMS_SQL.varchar2_table;
79: t_detail_attribute19 DBMS_SQL.varchar2_table;
80: t_detail_attribute20 DBMS_SQL.varchar2_table;
81: t_detail_attribute21 DBMS_SQL.varchar2_table;
82: t_detail_attribute22 DBMS_SQL.varchar2_table;
83: t_detail_attribute23 DBMS_SQL.varchar2_table;
76: t_detail_attribute16 DBMS_SQL.varchar2_table;
77: t_detail_attribute17 DBMS_SQL.varchar2_table;
78: t_detail_attribute18 DBMS_SQL.varchar2_table;
79: t_detail_attribute19 DBMS_SQL.varchar2_table;
80: t_detail_attribute20 DBMS_SQL.varchar2_table;
81: t_detail_attribute21 DBMS_SQL.varchar2_table;
82: t_detail_attribute22 DBMS_SQL.varchar2_table;
83: t_detail_attribute23 DBMS_SQL.varchar2_table;
84: t_detail_attribute24 DBMS_SQL.varchar2_table;
77: t_detail_attribute17 DBMS_SQL.varchar2_table;
78: t_detail_attribute18 DBMS_SQL.varchar2_table;
79: t_detail_attribute19 DBMS_SQL.varchar2_table;
80: t_detail_attribute20 DBMS_SQL.varchar2_table;
81: t_detail_attribute21 DBMS_SQL.varchar2_table;
82: t_detail_attribute22 DBMS_SQL.varchar2_table;
83: t_detail_attribute23 DBMS_SQL.varchar2_table;
84: t_detail_attribute24 DBMS_SQL.varchar2_table;
85: t_detail_attribute25 DBMS_SQL.varchar2_table;
78: t_detail_attribute18 DBMS_SQL.varchar2_table;
79: t_detail_attribute19 DBMS_SQL.varchar2_table;
80: t_detail_attribute20 DBMS_SQL.varchar2_table;
81: t_detail_attribute21 DBMS_SQL.varchar2_table;
82: t_detail_attribute22 DBMS_SQL.varchar2_table;
83: t_detail_attribute23 DBMS_SQL.varchar2_table;
84: t_detail_attribute24 DBMS_SQL.varchar2_table;
85: t_detail_attribute25 DBMS_SQL.varchar2_table;
86: t_detail_attribute26 DBMS_SQL.varchar2_table;
79: t_detail_attribute19 DBMS_SQL.varchar2_table;
80: t_detail_attribute20 DBMS_SQL.varchar2_table;
81: t_detail_attribute21 DBMS_SQL.varchar2_table;
82: t_detail_attribute22 DBMS_SQL.varchar2_table;
83: t_detail_attribute23 DBMS_SQL.varchar2_table;
84: t_detail_attribute24 DBMS_SQL.varchar2_table;
85: t_detail_attribute25 DBMS_SQL.varchar2_table;
86: t_detail_attribute26 DBMS_SQL.varchar2_table;
87: t_detail_attribute27 DBMS_SQL.varchar2_table;
80: t_detail_attribute20 DBMS_SQL.varchar2_table;
81: t_detail_attribute21 DBMS_SQL.varchar2_table;
82: t_detail_attribute22 DBMS_SQL.varchar2_table;
83: t_detail_attribute23 DBMS_SQL.varchar2_table;
84: t_detail_attribute24 DBMS_SQL.varchar2_table;
85: t_detail_attribute25 DBMS_SQL.varchar2_table;
86: t_detail_attribute26 DBMS_SQL.varchar2_table;
87: t_detail_attribute27 DBMS_SQL.varchar2_table;
88: t_detail_attribute28 DBMS_SQL.varchar2_table;
81: t_detail_attribute21 DBMS_SQL.varchar2_table;
82: t_detail_attribute22 DBMS_SQL.varchar2_table;
83: t_detail_attribute23 DBMS_SQL.varchar2_table;
84: t_detail_attribute24 DBMS_SQL.varchar2_table;
85: t_detail_attribute25 DBMS_SQL.varchar2_table;
86: t_detail_attribute26 DBMS_SQL.varchar2_table;
87: t_detail_attribute27 DBMS_SQL.varchar2_table;
88: t_detail_attribute28 DBMS_SQL.varchar2_table;
89: t_detail_attribute29 DBMS_SQL.varchar2_table;
82: t_detail_attribute22 DBMS_SQL.varchar2_table;
83: t_detail_attribute23 DBMS_SQL.varchar2_table;
84: t_detail_attribute24 DBMS_SQL.varchar2_table;
85: t_detail_attribute25 DBMS_SQL.varchar2_table;
86: t_detail_attribute26 DBMS_SQL.varchar2_table;
87: t_detail_attribute27 DBMS_SQL.varchar2_table;
88: t_detail_attribute28 DBMS_SQL.varchar2_table;
89: t_detail_attribute29 DBMS_SQL.varchar2_table;
90: t_detail_attribute30 DBMS_SQL.varchar2_table;
83: t_detail_attribute23 DBMS_SQL.varchar2_table;
84: t_detail_attribute24 DBMS_SQL.varchar2_table;
85: t_detail_attribute25 DBMS_SQL.varchar2_table;
86: t_detail_attribute26 DBMS_SQL.varchar2_table;
87: t_detail_attribute27 DBMS_SQL.varchar2_table;
88: t_detail_attribute28 DBMS_SQL.varchar2_table;
89: t_detail_attribute29 DBMS_SQL.varchar2_table;
90: t_detail_attribute30 DBMS_SQL.varchar2_table;
91: t_detail_attribute_category DBMS_SQL.varchar2_table;
84: t_detail_attribute24 DBMS_SQL.varchar2_table;
85: t_detail_attribute25 DBMS_SQL.varchar2_table;
86: t_detail_attribute26 DBMS_SQL.varchar2_table;
87: t_detail_attribute27 DBMS_SQL.varchar2_table;
88: t_detail_attribute28 DBMS_SQL.varchar2_table;
89: t_detail_attribute29 DBMS_SQL.varchar2_table;
90: t_detail_attribute30 DBMS_SQL.varchar2_table;
91: t_detail_attribute_category DBMS_SQL.varchar2_table;
92: t_detail_ovn DBMS_SQL.number_table;
85: t_detail_attribute25 DBMS_SQL.varchar2_table;
86: t_detail_attribute26 DBMS_SQL.varchar2_table;
87: t_detail_attribute27 DBMS_SQL.varchar2_table;
88: t_detail_attribute28 DBMS_SQL.varchar2_table;
89: t_detail_attribute29 DBMS_SQL.varchar2_table;
90: t_detail_attribute30 DBMS_SQL.varchar2_table;
91: t_detail_attribute_category DBMS_SQL.varchar2_table;
92: t_detail_ovn DBMS_SQL.number_table;
93: t_detail_max_ovn DBMS_SQL.number_table;
86: t_detail_attribute26 DBMS_SQL.varchar2_table;
87: t_detail_attribute27 DBMS_SQL.varchar2_table;
88: t_detail_attribute28 DBMS_SQL.varchar2_table;
89: t_detail_attribute29 DBMS_SQL.varchar2_table;
90: t_detail_attribute30 DBMS_SQL.varchar2_table;
91: t_detail_attribute_category DBMS_SQL.varchar2_table;
92: t_detail_ovn DBMS_SQL.number_table;
93: t_detail_max_ovn DBMS_SQL.number_table;
94: t_detail_deleted DBMS_SQL.varchar2_table;
87: t_detail_attribute27 DBMS_SQL.varchar2_table;
88: t_detail_attribute28 DBMS_SQL.varchar2_table;
89: t_detail_attribute29 DBMS_SQL.varchar2_table;
90: t_detail_attribute30 DBMS_SQL.varchar2_table;
91: t_detail_attribute_category DBMS_SQL.varchar2_table;
92: t_detail_ovn DBMS_SQL.number_table;
93: t_detail_max_ovn DBMS_SQL.number_table;
94: t_detail_deleted DBMS_SQL.varchar2_table;
95: t_detail_uom DBMS_SQL.varchar2_table;
88: t_detail_attribute28 DBMS_SQL.varchar2_table;
89: t_detail_attribute29 DBMS_SQL.varchar2_table;
90: t_detail_attribute30 DBMS_SQL.varchar2_table;
91: t_detail_attribute_category DBMS_SQL.varchar2_table;
92: t_detail_ovn DBMS_SQL.number_table;
93: t_detail_max_ovn DBMS_SQL.number_table;
94: t_detail_deleted DBMS_SQL.varchar2_table;
95: t_detail_uom DBMS_SQL.varchar2_table;
96: t_detail_date_from DBMS_SQL.date_table;
89: t_detail_attribute29 DBMS_SQL.varchar2_table;
90: t_detail_attribute30 DBMS_SQL.varchar2_table;
91: t_detail_attribute_category DBMS_SQL.varchar2_table;
92: t_detail_ovn DBMS_SQL.number_table;
93: t_detail_max_ovn DBMS_SQL.number_table;
94: t_detail_deleted DBMS_SQL.varchar2_table;
95: t_detail_uom DBMS_SQL.varchar2_table;
96: t_detail_date_from DBMS_SQL.date_table;
97: t_detail_date_to DBMS_SQL.date_table;
90: t_detail_attribute30 DBMS_SQL.varchar2_table;
91: t_detail_attribute_category DBMS_SQL.varchar2_table;
92: t_detail_ovn DBMS_SQL.number_table;
93: t_detail_max_ovn DBMS_SQL.number_table;
94: t_detail_deleted DBMS_SQL.varchar2_table;
95: t_detail_uom DBMS_SQL.varchar2_table;
96: t_detail_date_from DBMS_SQL.date_table;
97: t_detail_date_to DBMS_SQL.date_table;
98: t_detail_approval_status DBMS_SQL.varchar2_table;
91: t_detail_attribute_category DBMS_SQL.varchar2_table;
92: t_detail_ovn DBMS_SQL.number_table;
93: t_detail_max_ovn DBMS_SQL.number_table;
94: t_detail_deleted DBMS_SQL.varchar2_table;
95: t_detail_uom DBMS_SQL.varchar2_table;
96: t_detail_date_from DBMS_SQL.date_table;
97: t_detail_date_to DBMS_SQL.date_table;
98: t_detail_approval_status DBMS_SQL.varchar2_table;
99: t_detail_approval_style_id DBMS_SQL.number_table;
92: t_detail_ovn DBMS_SQL.number_table;
93: t_detail_max_ovn DBMS_SQL.number_table;
94: t_detail_deleted DBMS_SQL.varchar2_table;
95: t_detail_uom DBMS_SQL.varchar2_table;
96: t_detail_date_from DBMS_SQL.date_table;
97: t_detail_date_to DBMS_SQL.date_table;
98: t_detail_approval_status DBMS_SQL.varchar2_table;
99: t_detail_approval_style_id DBMS_SQL.number_table;
100:
93: t_detail_max_ovn DBMS_SQL.number_table;
94: t_detail_deleted DBMS_SQL.varchar2_table;
95: t_detail_uom DBMS_SQL.varchar2_table;
96: t_detail_date_from DBMS_SQL.date_table;
97: t_detail_date_to DBMS_SQL.date_table;
98: t_detail_approval_status DBMS_SQL.varchar2_table;
99: t_detail_approval_style_id DBMS_SQL.number_table;
100:
101: -- time attribute types
94: t_detail_deleted DBMS_SQL.varchar2_table;
95: t_detail_uom DBMS_SQL.varchar2_table;
96: t_detail_date_from DBMS_SQL.date_table;
97: t_detail_date_to DBMS_SQL.date_table;
98: t_detail_approval_status DBMS_SQL.varchar2_table;
99: t_detail_approval_style_id DBMS_SQL.number_table;
100:
101: -- time attribute types
102: TYPE tab_ta_fk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
95: t_detail_uom DBMS_SQL.varchar2_table;
96: t_detail_date_from DBMS_SQL.date_table;
97: t_detail_date_to DBMS_SQL.date_table;
98: t_detail_approval_status DBMS_SQL.varchar2_table;
99: t_detail_approval_style_id DBMS_SQL.number_table;
100:
101: -- time attribute types
102: TYPE tab_ta_fk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
103: INDEX BY BINARY_INTEGER;
577: t_range_stop tab_range_stop;
578: t_seq tab_seq;
579: t_where_clause tab_where_clause;
580: t_resource_id_bulk tab_resource_id;
581: t_resource_id DBMS_SQL.number_table;
582: t_retrieval_range_id DBMS_SQL.number_table;
583: l_resource_list DBMS_SQL.number_table;
584: l_rows_fetched INTEGER;
585: l_csr INTEGER;
578: t_seq tab_seq;
579: t_where_clause tab_where_clause;
580: t_resource_id_bulk tab_resource_id;
581: t_resource_id DBMS_SQL.number_table;
582: t_retrieval_range_id DBMS_SQL.number_table;
583: l_resource_list DBMS_SQL.number_table;
584: l_rows_fetched INTEGER;
585: l_csr INTEGER;
586: l_since_date DATE;
579: t_where_clause tab_where_clause;
580: t_resource_id_bulk tab_resource_id;
581: t_resource_id DBMS_SQL.number_table;
582: t_retrieval_range_id DBMS_SQL.number_table;
583: l_resource_list DBMS_SQL.number_table;
584: l_rows_fetched INTEGER;
585: l_csr INTEGER;
586: l_since_date DATE;
587: x PLS_INTEGER := 0;
1201:
1202: END generate_resource_sql;
1203:
1204: PROCEDURE insert_rr_resources (
1205: p_resource_list IN DBMS_SQL.number_table,
1206: p_rr_id IN OUT NOCOPY NUMBER
1207: )
1208: IS
1209: CURSOR csr_get_rr_id
1392: END IF;
1393:
1394: -- use dynamic SQL BULK FETCH to generate resource list
1395: l_rows_fetched := l_chunk_size;
1396: l_csr := DBMS_SQL.open_cursor;
1397: DBMS_SQL.parse (l_csr, l_dynamic_sql, DBMS_SQL.native);
1398: -- bind variables needed by all queries
1399: DBMS_SQL.bind_variable (l_csr,
1400: ':p_since_date',
1393:
1394: -- use dynamic SQL BULK FETCH to generate resource list
1395: l_rows_fetched := l_chunk_size;
1396: l_csr := DBMS_SQL.open_cursor;
1397: DBMS_SQL.parse (l_csr, l_dynamic_sql, DBMS_SQL.native);
1398: -- bind variables needed by all queries
1399: DBMS_SQL.bind_variable (l_csr,
1400: ':p_since_date',
1401: g_params.since_date
1395: l_rows_fetched := l_chunk_size;
1396: l_csr := DBMS_SQL.open_cursor;
1397: DBMS_SQL.parse (l_csr, l_dynamic_sql, DBMS_SQL.native);
1398: -- bind variables needed by all queries
1399: DBMS_SQL.bind_variable (l_csr,
1400: ':p_since_date',
1401: g_params.since_date
1402: );
1403: -- define arrays for each item in the select list
1400: ':p_since_date',
1401: g_params.since_date
1402: );
1403: -- define arrays for each item in the select list
1404: DBMS_SQL.define_array (c => l_csr,
1405: POSITION => 1,
1406: n_tab => t_resource_id,
1407: cnt => l_chunk_size,
1408: lower_bound => 1
1406: n_tab => t_resource_id,
1407: cnt => l_chunk_size,
1408: lower_bound => 1
1409: );
1410: l_dummy := DBMS_SQL.EXECUTE (l_csr);
1411:
1412: -- loop to ensure we fetch all the rows
1413: WHILE (l_rows_fetched = l_chunk_size)
1414: LOOP
1416: THEN
1417: hr_utility.TRACE ('in loop');
1418: END IF;
1419:
1420: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
1421:
1422: IF g_debug
1423: THEN
1424: hr_utility.TRACE ( 'rows fetched is '
1432: THEN
1433: hr_utility.TRACE ('No ranges !!!');
1434: END IF;
1435:
1436: DBMS_SQL.close_cursor (l_csr);
1437: RAISE e_no_ranges;
1438: ELSIF (l_rows_fetched > 0)
1439: THEN
1440: DBMS_SQL.column_value (c => l_csr,
1436: DBMS_SQL.close_cursor (l_csr);
1437: RAISE e_no_ranges;
1438: ELSIF (l_rows_fetched > 0)
1439: THEN
1440: DBMS_SQL.column_value (c => l_csr,
1441: POSITION => 1,
1442: n_tab => t_resource_id
1443: );
1444: -- populate retrieval range resources
1483: THEN
1484: hr_utility.TRACE ('Leaving loop');
1485: END IF;
1486:
1487: DBMS_SQL.close_cursor (l_csr);
1488: -- now insert retrieval ranges
1489: FORALL rrx IN 1 .. x
1490: INSERT INTO hxc_retrieval_ranges
1491: (retrieval_range_id,
1803: AND tx.transaction_id = txd.transaction_id
1804: AND txd.status = ''SUCCESS''
1805: AND txd.time_building_block_id = tbb_latest.time_building_block_id
1806: AND txd.time_building_block_ovn = tbb_latest.object_version_number) ';
1807: t_tbb_id DBMS_SQL.number_table;
1808: t_tbb_ovn DBMS_SQL.number_table;
1809: l_start_date DATE;
1810: l_end_date DATE;
1811: l_csr INTEGER;
1804: AND txd.status = ''SUCCESS''
1805: AND txd.time_building_block_id = tbb_latest.time_building_block_id
1806: AND txd.time_building_block_ovn = tbb_latest.object_version_number) ';
1807: t_tbb_id DBMS_SQL.number_table;
1808: t_tbb_ovn DBMS_SQL.number_table;
1809: l_start_date DATE;
1810: l_end_date DATE;
1811: l_csr INTEGER;
1812: l_rows_fetched INTEGER;
2038:
2039: insert_query (l_ret_range_query, 'RET_RANGE_BLKS');
2040: -- now fetch and insert the rows
2041: l_rows_fetched := 100;
2042: l_csr := DBMS_SQL.open_cursor;
2043: DBMS_SQL.parse (l_csr, l_ret_range_query, DBMS_SQL.native);
2044:
2045: -- Bug 9394444
2046: IF ( g_params.p_process = 'Projects Retrieval Process'
2039: insert_query (l_ret_range_query, 'RET_RANGE_BLKS');
2040: -- now fetch and insert the rows
2041: l_rows_fetched := 100;
2042: l_csr := DBMS_SQL.open_cursor;
2043: DBMS_SQL.parse (l_csr, l_ret_range_query, DBMS_SQL.native);
2044:
2045: -- Bug 9394444
2046: IF ( g_params.p_process = 'Projects Retrieval Process'
2047: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PA')
2051: AND NVL(FND_PROFILE.VALUE('HXC_USE_UPGRADED_RETRIEVAL_PROCESS'),'N') = 'Y' )
2052: THEN
2053: NULL;
2054: ELSE
2055: DBMS_SQL.bind_variable (l_csr,
2056: ':p_process_id',
2057: g_retrieval_process_id
2058: );
2059: END IF;
2057: g_retrieval_process_id
2058: );
2059: END IF;
2060:
2061: DBMS_SQL.bind_variable (l_csr, ':p_since_date', g_params.since_date);
2062: DBMS_SQL.bind_variable (l_csr, ':p_rr_id', l_pkg_retrieval_range_id);
2063:
2064: IF (g_params.l_using_dates)
2065: THEN
2058: );
2059: END IF;
2060:
2061: DBMS_SQL.bind_variable (l_csr, ':p_since_date', g_params.since_date);
2062: DBMS_SQL.bind_variable (l_csr, ':p_rr_id', l_pkg_retrieval_range_id);
2063:
2064: IF (g_params.l_using_dates)
2065: THEN
2066: DBMS_SQL.bind_variable (l_csr, ':p_start_date', l_start_date);
2062: DBMS_SQL.bind_variable (l_csr, ':p_rr_id', l_pkg_retrieval_range_id);
2063:
2064: IF (g_params.l_using_dates)
2065: THEN
2066: DBMS_SQL.bind_variable (l_csr, ':p_start_date', l_start_date);
2067: DBMS_SQL.bind_variable (l_csr, ':p_end_date', l_end_date);
2068: END IF;
2069:
2070: IF g_ret_criteria.gre_id IS NOT NULL
2063:
2064: IF (g_params.l_using_dates)
2065: THEN
2066: DBMS_SQL.bind_variable (l_csr, ':p_start_date', l_start_date);
2067: DBMS_SQL.bind_variable (l_csr, ':p_end_date', l_end_date);
2068: END IF;
2069:
2070: IF g_ret_criteria.gre_id IS NOT NULL
2071: THEN
2068: END IF;
2069:
2070: IF g_ret_criteria.gre_id IS NOT NULL
2071: THEN
2072: DBMS_SQL.bind_variable (l_csr, ':p_gre_id',
2073: g_ret_criteria.gre_id);
2074: END IF;
2075:
2076: IF g_ret_criteria.payroll_id IS NOT NULL
2074: END IF;
2075:
2076: IF g_ret_criteria.payroll_id IS NOT NULL
2077: THEN
2078: DBMS_SQL.bind_variable (l_csr,
2079: ':p_payroll_id',
2080: g_ret_criteria.payroll_id
2081: );
2082: END IF;
2082: END IF;
2083:
2084: IF g_ret_criteria.location_id IS NOT NULL
2085: THEN
2086: DBMS_SQL.bind_variable (l_csr,
2087: ':p_location_id',
2088: g_ret_criteria.location_id
2089: );
2090: END IF;
2090: END IF;
2091:
2092: IF g_ret_criteria.organization_id IS NOT NULL
2093: THEN
2094: DBMS_SQL.bind_variable (l_csr,
2095: ':p_org_id',
2096: g_ret_criteria.organization_id
2097: );
2098: END IF;
2096: g_ret_criteria.organization_id
2097: );
2098: END IF;
2099:
2100: DBMS_SQL.define_array (c => l_csr,
2101: POSITION => 1,
2102: n_tab => t_tbb_id,
2103: cnt => 100,
2104: lower_bound => 1
2102: n_tab => t_tbb_id,
2103: cnt => 100,
2104: lower_bound => 1
2105: );
2106: DBMS_SQL.define_array (c => l_csr,
2107: POSITION => 2,
2108: n_tab => t_tbb_ovn,
2109: cnt => 100,
2110: lower_bound => 1
2108: n_tab => t_tbb_ovn,
2109: cnt => 100,
2110: lower_bound => 1
2111: );
2112: l_dummy := DBMS_SQL.EXECUTE (l_csr);
2113:
2114: -- loop to ensure we fetch all the rows
2115: WHILE (l_rows_fetched = 100)
2116: LOOP
2113:
2114: -- loop to ensure we fetch all the rows
2115: WHILE (l_rows_fetched = 100)
2116: LOOP
2117: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
2118:
2119: IF (l_rows_fetched > 0)
2120: THEN
2121: DBMS_SQL.column_value (c => l_csr,
2117: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
2118:
2119: IF (l_rows_fetched > 0)
2120: THEN
2121: DBMS_SQL.column_value (c => l_csr,
2122: POSITION => 1,
2123: n_tab => t_tbb_id
2124: );
2125: DBMS_SQL.column_value (c => l_csr,
2121: DBMS_SQL.column_value (c => l_csr,
2122: POSITION => 1,
2123: n_tab => t_tbb_id
2124: );
2125: DBMS_SQL.column_value (c => l_csr,
2126: POSITION => 2,
2127: n_tab => t_tbb_ovn
2128: );
2129: -- populate retrieval range blks
2137: t_tbb_ovn.DELETE;
2138: END IF; -- l_rows_fetch = 0
2139: END LOOP; -- dynamic fetch of resources
2140:
2141: DBMS_SQL.close_cursor (l_csr);
2142: ELSE
2143: -- Retrievals which do not loop do not use
2144: -- this new table
2145: NULL;
4365: -- description
4366: -- This is the heart of the retrieval process. It retrieves and sorts the time
4367: -- building blocks.
4368: -- Retrieval:
4369: -- The dynanmic SQL is parsed and executed and the dbms_sql arrays defined
4370: -- and initialised. Once all the rows have been fetched the data is moved into
4371: -- one PL/SQL table (see populate_query_table).
4372: -- Sorting:
4373: -- Since the bld blks are retrieved in one query there is some data repetition.
4811: THEN
4812: hr_utility.set_location ('Processing ' || l_proc, 20);
4813: END IF;
4814:
4815: l_csr := DBMS_SQL.open_cursor;
4816:
4817: IF g_debug
4818: THEN
4819: hr_utility.set_location ('Processing ' || l_proc, 30);
4818: THEN
4819: hr_utility.set_location ('Processing ' || l_proc, 30);
4820: END IF;
4821:
4822: DBMS_SQL.parse (l_csr, l_query_text, DBMS_SQL.native);
4823:
4824: -- bind variables needed by all queries
4825: IF (g_params.p_process IN
4826: ('Projects Retrieval Process',
4831: )
4832: THEN
4833: NULL; -- no more binds - bound in pop ret range blks
4834: ELSE
4835: DBMS_SQL.bind_variable (l_csr, ':p_lower_range', l_pkg_range_start);
4836: DBMS_SQL.bind_variable (l_csr, ':p_upper_range', l_pkg_range_stop);
4837:
4838: IF (g_params.p_incremental = 'Y')
4839: THEN
4832: THEN
4833: NULL; -- no more binds - bound in pop ret range blks
4834: ELSE
4835: DBMS_SQL.bind_variable (l_csr, ':p_lower_range', l_pkg_range_start);
4836: DBMS_SQL.bind_variable (l_csr, ':p_upper_range', l_pkg_range_stop);
4837:
4838: IF (g_params.p_incremental = 'Y')
4839: THEN
4840: DBMS_SQL.bind_variable (l_csr,
4836: DBMS_SQL.bind_variable (l_csr, ':p_upper_range', l_pkg_range_stop);
4837:
4838: IF (g_params.p_incremental = 'Y')
4839: THEN
4840: DBMS_SQL.bind_variable (l_csr,
4841: ':p_process_id',
4842: g_retrieval_process_id
4843: );
4844: END IF;
4854: )
4855: AND (g_params.p_rerun_flag = 'N')
4856: )
4857: THEN
4858: DBMS_SQL.bind_variable (l_csr,
4859: ':p_start_date',
4860: g_params.p_start_date
4861: );
4862: DBMS_SQL.bind_variable (l_csr, ':p_end_date', g_params.p_end_date);
4858: DBMS_SQL.bind_variable (l_csr,
4859: ':p_start_date',
4860: g_params.p_start_date
4861: );
4862: DBMS_SQL.bind_variable (l_csr, ':p_end_date', g_params.p_end_date);
4863: END IF;
4864: END IF;
4865:
4866: IF g_debug
4869: END IF;
4870:
4871: IF (g_params.p_rerun_flag = 'Y')
4872: THEN
4873: DBMS_SQL.bind_variable (l_csr,
4874: ':p_transaction_code',
4875: g_params.p_transaction_code
4876: );
4877: END IF;
4881: THEN
4882: hr_utility.set_location ('Processing ' || l_proc, 40);
4883: END IF;
4884:
4885: DBMS_SQL.define_array (c => l_csr,
4886: POSITION => 1,
4887: n_tab => t_timecard_bb_id,
4888: cnt => l_max_array_size,
4889: lower_bound => 1
4887: n_tab => t_timecard_bb_id,
4888: cnt => l_max_array_size,
4889: lower_bound => 1
4890: );
4891: DBMS_SQL.define_array (c => l_csr,
4892: POSITION => 2,
4893: n_tab => t_timecard_ovn,
4894: cnt => l_max_array_size,
4895: lower_bound => 1
4893: n_tab => t_timecard_ovn,
4894: cnt => l_max_array_size,
4895: lower_bound => 1
4896: );
4897: DBMS_SQL.define_array (c => l_csr,
4898: POSITION => 3,
4899: n_tab => t_day_bb_id,
4900: cnt => l_max_array_size,
4901: lower_bound => 1
4899: n_tab => t_day_bb_id,
4900: cnt => l_max_array_size,
4901: lower_bound => 1
4902: );
4903: DBMS_SQL.define_array (c => l_csr,
4904: POSITION => 4,
4905: n_tab => t_day_ovn,
4906: cnt => l_max_array_size,
4907: lower_bound => 1
4905: n_tab => t_day_ovn,
4906: cnt => l_max_array_size,
4907: lower_bound => 1
4908: );
4909: DBMS_SQL.define_array (c => l_csr,
4910: POSITION => 5,
4911: d_tab => t_day_start_time,
4912: cnt => l_max_array_size,
4913: lower_bound => 1
4911: d_tab => t_day_start_time,
4912: cnt => l_max_array_size,
4913: lower_bound => 1
4914: );
4915: DBMS_SQL.define_array (c => l_csr,
4916: POSITION => 6,
4917: d_tab => t_day_stop_time,
4918: cnt => l_max_array_size,
4919: lower_bound => 1
4917: d_tab => t_day_stop_time,
4918: cnt => l_max_array_size,
4919: lower_bound => 1
4920: );
4921: DBMS_SQL.define_array (c => l_csr,
4922: POSITION => 7,
4923: n_tab => t_detail_bb_id,
4924: cnt => l_max_array_size,
4925: lower_bound => 1
4923: n_tab => t_detail_bb_id,
4924: cnt => l_max_array_size,
4925: lower_bound => 1
4926: );
4927: DBMS_SQL.define_array (c => l_csr,
4928: POSITION => 8,
4929: n_tab => t_detail_ovn,
4930: cnt => l_max_array_size,
4931: lower_bound => 1
4929: n_tab => t_detail_ovn,
4930: cnt => l_max_array_size,
4931: lower_bound => 1
4932: );
4933: DBMS_SQL.define_array (c => l_csr,
4934: POSITION => 9,
4935: n_tab => t_detail_parent_id,
4936: cnt => l_max_array_size,
4937: lower_bound => 1
4935: n_tab => t_detail_parent_id,
4936: cnt => l_max_array_size,
4937: lower_bound => 1
4938: );
4939: DBMS_SQL.define_array (c => l_csr,
4940: POSITION => 10,
4941: c_tab => t_detail_resource_type,
4942: cnt => l_max_array_size,
4943: lower_bound => 1
4941: c_tab => t_detail_resource_type,
4942: cnt => l_max_array_size,
4943: lower_bound => 1
4944: );
4945: DBMS_SQL.define_array (c => l_csr,
4946: POSITION => 11,
4947: n_tab => t_detail_resource_id,
4948: cnt => l_max_array_size,
4949: lower_bound => 1
4947: n_tab => t_detail_resource_id,
4948: cnt => l_max_array_size,
4949: lower_bound => 1
4950: );
4951: DBMS_SQL.define_array (c => l_csr,
4952: POSITION => 12,
4953: c_tab => t_detail_comment_text,
4954: cnt => l_max_array_size,
4955: lower_bound => 1
4953: c_tab => t_detail_comment_text,
4954: cnt => l_max_array_size,
4955: lower_bound => 1
4956: );
4957: DBMS_SQL.define_array (c => l_csr,
4958: POSITION => 13,
4959: d_tab => t_detail_start_time,
4960: cnt => l_max_array_size,
4961: lower_bound => 1
4959: d_tab => t_detail_start_time,
4960: cnt => l_max_array_size,
4961: lower_bound => 1
4962: );
4963: DBMS_SQL.define_array (c => l_csr,
4964: POSITION => 14,
4965: d_tab => t_detail_stop_time,
4966: cnt => l_max_array_size,
4967: lower_bound => 1
4965: d_tab => t_detail_stop_time,
4966: cnt => l_max_array_size,
4967: lower_bound => 1
4968: );
4969: DBMS_SQL.define_array (c => l_csr,
4970: POSITION => 15,
4971: n_tab => t_detail_measure,
4972: cnt => l_max_array_size,
4973: lower_bound => 1
4971: n_tab => t_detail_measure,
4972: cnt => l_max_array_size,
4973: lower_bound => 1
4974: );
4975: DBMS_SQL.define_array (c => l_csr,
4976: POSITION => 16,
4977: c_tab => t_detail_scope,
4978: cnt => l_max_array_size,
4979: lower_bound => 1
4977: c_tab => t_detail_scope,
4978: cnt => l_max_array_size,
4979: lower_bound => 1
4980: );
4981: DBMS_SQL.define_array (c => l_csr,
4982: POSITION => 17,
4983: c_tab => t_detail_type,
4984: cnt => l_max_array_size,
4985: lower_bound => 1
4983: c_tab => t_detail_type,
4984: cnt => l_max_array_size,
4985: lower_bound => 1
4986: );
4987: DBMS_SQL.define_array (c => l_csr,
4988: POSITION => 18,
4989: n_tab => t_detail_ta_id,
4990: cnt => l_max_array_size,
4991: lower_bound => 1
4989: n_tab => t_detail_ta_id,
4990: cnt => l_max_array_size,
4991: lower_bound => 1
4992: );
4993: DBMS_SQL.define_array (c => l_csr,
4994: POSITION => 19,
4995: n_tab => t_detail_bld_blk_info_type_id,
4996: cnt => l_max_array_size,
4997: lower_bound => 1
4995: n_tab => t_detail_bld_blk_info_type_id,
4996: cnt => l_max_array_size,
4997: lower_bound => 1
4998: );
4999: DBMS_SQL.define_array (c => l_csr,
5000: POSITION => 20,
5001: c_tab => t_detail_attribute1,
5002: cnt => l_max_array_size,
5003: lower_bound => 1
5001: c_tab => t_detail_attribute1,
5002: cnt => l_max_array_size,
5003: lower_bound => 1
5004: );
5005: DBMS_SQL.define_array (c => l_csr,
5006: POSITION => 21,
5007: c_tab => t_detail_attribute2,
5008: cnt => l_max_array_size,
5009: lower_bound => 1
5007: c_tab => t_detail_attribute2,
5008: cnt => l_max_array_size,
5009: lower_bound => 1
5010: );
5011: DBMS_SQL.define_array (c => l_csr,
5012: POSITION => 22,
5013: c_tab => t_detail_attribute3,
5014: cnt => l_max_array_size,
5015: lower_bound => 1
5013: c_tab => t_detail_attribute3,
5014: cnt => l_max_array_size,
5015: lower_bound => 1
5016: );
5017: DBMS_SQL.define_array (c => l_csr,
5018: POSITION => 23,
5019: c_tab => t_detail_attribute4,
5020: cnt => l_max_array_size,
5021: lower_bound => 1
5019: c_tab => t_detail_attribute4,
5020: cnt => l_max_array_size,
5021: lower_bound => 1
5022: );
5023: DBMS_SQL.define_array (c => l_csr,
5024: POSITION => 24,
5025: c_tab => t_detail_attribute5,
5026: cnt => l_max_array_size,
5027: lower_bound => 1
5025: c_tab => t_detail_attribute5,
5026: cnt => l_max_array_size,
5027: lower_bound => 1
5028: );
5029: DBMS_SQL.define_array (c => l_csr,
5030: POSITION => 25,
5031: c_tab => t_detail_attribute6,
5032: cnt => l_max_array_size,
5033: lower_bound => 1
5031: c_tab => t_detail_attribute6,
5032: cnt => l_max_array_size,
5033: lower_bound => 1
5034: );
5035: DBMS_SQL.define_array (c => l_csr,
5036: POSITION => 26,
5037: c_tab => t_detail_attribute7,
5038: cnt => l_max_array_size,
5039: lower_bound => 1
5037: c_tab => t_detail_attribute7,
5038: cnt => l_max_array_size,
5039: lower_bound => 1
5040: );
5041: DBMS_SQL.define_array (c => l_csr,
5042: POSITION => 27,
5043: c_tab => t_detail_attribute8,
5044: cnt => l_max_array_size,
5045: lower_bound => 1
5043: c_tab => t_detail_attribute8,
5044: cnt => l_max_array_size,
5045: lower_bound => 1
5046: );
5047: DBMS_SQL.define_array (c => l_csr,
5048: POSITION => 28,
5049: c_tab => t_detail_attribute9,
5050: cnt => l_max_array_size,
5051: lower_bound => 1
5049: c_tab => t_detail_attribute9,
5050: cnt => l_max_array_size,
5051: lower_bound => 1
5052: );
5053: DBMS_SQL.define_array (c => l_csr,
5054: POSITION => 29,
5055: c_tab => t_detail_attribute10,
5056: cnt => l_max_array_size,
5057: lower_bound => 1
5055: c_tab => t_detail_attribute10,
5056: cnt => l_max_array_size,
5057: lower_bound => 1
5058: );
5059: DBMS_SQL.define_array (c => l_csr,
5060: POSITION => 30,
5061: c_tab => t_detail_attribute11,
5062: cnt => l_max_array_size,
5063: lower_bound => 1
5061: c_tab => t_detail_attribute11,
5062: cnt => l_max_array_size,
5063: lower_bound => 1
5064: );
5065: DBMS_SQL.define_array (c => l_csr,
5066: POSITION => 31,
5067: c_tab => t_detail_attribute12,
5068: cnt => l_max_array_size,
5069: lower_bound => 1
5067: c_tab => t_detail_attribute12,
5068: cnt => l_max_array_size,
5069: lower_bound => 1
5070: );
5071: DBMS_SQL.define_array (c => l_csr,
5072: POSITION => 32,
5073: c_tab => t_detail_attribute13,
5074: cnt => l_max_array_size,
5075: lower_bound => 1
5073: c_tab => t_detail_attribute13,
5074: cnt => l_max_array_size,
5075: lower_bound => 1
5076: );
5077: DBMS_SQL.define_array (c => l_csr,
5078: POSITION => 33,
5079: c_tab => t_detail_attribute14,
5080: cnt => l_max_array_size,
5081: lower_bound => 1
5079: c_tab => t_detail_attribute14,
5080: cnt => l_max_array_size,
5081: lower_bound => 1
5082: );
5083: DBMS_SQL.define_array (c => l_csr,
5084: POSITION => 34,
5085: c_tab => t_detail_attribute15,
5086: cnt => l_max_array_size,
5087: lower_bound => 1
5085: c_tab => t_detail_attribute15,
5086: cnt => l_max_array_size,
5087: lower_bound => 1
5088: );
5089: DBMS_SQL.define_array (c => l_csr,
5090: POSITION => 35,
5091: c_tab => t_detail_attribute16,
5092: cnt => l_max_array_size,
5093: lower_bound => 1
5091: c_tab => t_detail_attribute16,
5092: cnt => l_max_array_size,
5093: lower_bound => 1
5094: );
5095: DBMS_SQL.define_array (c => l_csr,
5096: POSITION => 36,
5097: c_tab => t_detail_attribute17,
5098: cnt => l_max_array_size,
5099: lower_bound => 1
5097: c_tab => t_detail_attribute17,
5098: cnt => l_max_array_size,
5099: lower_bound => 1
5100: );
5101: DBMS_SQL.define_array (c => l_csr,
5102: POSITION => 37,
5103: c_tab => t_detail_attribute18,
5104: cnt => l_max_array_size,
5105: lower_bound => 1
5103: c_tab => t_detail_attribute18,
5104: cnt => l_max_array_size,
5105: lower_bound => 1
5106: );
5107: DBMS_SQL.define_array (c => l_csr,
5108: POSITION => 38,
5109: c_tab => t_detail_attribute19,
5110: cnt => l_max_array_size,
5111: lower_bound => 1
5109: c_tab => t_detail_attribute19,
5110: cnt => l_max_array_size,
5111: lower_bound => 1
5112: );
5113: DBMS_SQL.define_array (c => l_csr,
5114: POSITION => 39,
5115: c_tab => t_detail_attribute20,
5116: cnt => l_max_array_size,
5117: lower_bound => 1
5115: c_tab => t_detail_attribute20,
5116: cnt => l_max_array_size,
5117: lower_bound => 1
5118: );
5119: DBMS_SQL.define_array (c => l_csr,
5120: POSITION => 40,
5121: c_tab => t_detail_attribute21,
5122: cnt => l_max_array_size,
5123: lower_bound => 1
5121: c_tab => t_detail_attribute21,
5122: cnt => l_max_array_size,
5123: lower_bound => 1
5124: );
5125: DBMS_SQL.define_array (c => l_csr,
5126: POSITION => 41,
5127: c_tab => t_detail_attribute22,
5128: cnt => l_max_array_size,
5129: lower_bound => 1
5127: c_tab => t_detail_attribute22,
5128: cnt => l_max_array_size,
5129: lower_bound => 1
5130: );
5131: DBMS_SQL.define_array (c => l_csr,
5132: POSITION => 42,
5133: c_tab => t_detail_attribute23,
5134: cnt => l_max_array_size,
5135: lower_bound => 1
5133: c_tab => t_detail_attribute23,
5134: cnt => l_max_array_size,
5135: lower_bound => 1
5136: );
5137: DBMS_SQL.define_array (c => l_csr,
5138: POSITION => 43,
5139: c_tab => t_detail_attribute24,
5140: cnt => l_max_array_size,
5141: lower_bound => 1
5139: c_tab => t_detail_attribute24,
5140: cnt => l_max_array_size,
5141: lower_bound => 1
5142: );
5143: DBMS_SQL.define_array (c => l_csr,
5144: POSITION => 44,
5145: c_tab => t_detail_attribute25,
5146: cnt => l_max_array_size,
5147: lower_bound => 1
5145: c_tab => t_detail_attribute25,
5146: cnt => l_max_array_size,
5147: lower_bound => 1
5148: );
5149: DBMS_SQL.define_array (c => l_csr,
5150: POSITION => 45,
5151: c_tab => t_detail_attribute26,
5152: cnt => l_max_array_size,
5153: lower_bound => 1
5151: c_tab => t_detail_attribute26,
5152: cnt => l_max_array_size,
5153: lower_bound => 1
5154: );
5155: DBMS_SQL.define_array (c => l_csr,
5156: POSITION => 46,
5157: c_tab => t_detail_attribute27,
5158: cnt => l_max_array_size,
5159: lower_bound => 1
5157: c_tab => t_detail_attribute27,
5158: cnt => l_max_array_size,
5159: lower_bound => 1
5160: );
5161: DBMS_SQL.define_array (c => l_csr,
5162: POSITION => 47,
5163: c_tab => t_detail_attribute28,
5164: cnt => l_max_array_size,
5165: lower_bound => 1
5163: c_tab => t_detail_attribute28,
5164: cnt => l_max_array_size,
5165: lower_bound => 1
5166: );
5167: DBMS_SQL.define_array (c => l_csr,
5168: POSITION => 48,
5169: c_tab => t_detail_attribute29,
5170: cnt => l_max_array_size,
5171: lower_bound => 1
5169: c_tab => t_detail_attribute29,
5170: cnt => l_max_array_size,
5171: lower_bound => 1
5172: );
5173: DBMS_SQL.define_array (c => l_csr,
5174: POSITION => 49,
5175: c_tab => t_detail_attribute30,
5176: cnt => l_max_array_size,
5177: lower_bound => 1
5175: c_tab => t_detail_attribute30,
5176: cnt => l_max_array_size,
5177: lower_bound => 1
5178: );
5179: DBMS_SQL.define_array (c => l_csr,
5180: POSITION => 50,
5181: d_tab => t_detail_date_from,
5182: cnt => l_max_array_size,
5183: lower_bound => 1
5181: d_tab => t_detail_date_from,
5182: cnt => l_max_array_size,
5183: lower_bound => 1
5184: );
5185: DBMS_SQL.define_array (c => l_csr,
5186: POSITION => 51,
5187: d_tab => t_detail_date_to,
5188: cnt => l_max_array_size,
5189: lower_bound => 1
5187: d_tab => t_detail_date_to,
5188: cnt => l_max_array_size,
5189: lower_bound => 1
5190: );
5191: DBMS_SQL.define_array (c => l_csr,
5192: POSITION => 52,
5193: c_tab => t_detail_approval_status,
5194: cnt => l_max_array_size,
5195: lower_bound => 1
5193: c_tab => t_detail_approval_status,
5194: cnt => l_max_array_size,
5195: lower_bound => 1
5196: );
5197: DBMS_SQL.define_array (c => l_csr,
5198: POSITION => 53,
5199: n_tab => t_detail_approval_style_id,
5200: cnt => l_max_array_size,
5201: lower_bound => 1
5199: n_tab => t_detail_approval_style_id,
5200: cnt => l_max_array_size,
5201: lower_bound => 1
5202: );
5203: DBMS_SQL.define_array (c => l_csr,
5204: POSITION => 54,
5205: c_tab => t_detail_deleted,
5206: cnt => l_max_array_size,
5207: lower_bound => 1
5205: c_tab => t_detail_deleted,
5206: cnt => l_max_array_size,
5207: lower_bound => 1
5208: );
5209: DBMS_SQL.define_array (c => l_csr,
5210: POSITION => 55,
5211: c_tab => t_detail_attribute_category,
5212: cnt => l_max_array_size,
5213: lower_bound => 1
5211: c_tab => t_detail_attribute_category,
5212: cnt => l_max_array_size,
5213: lower_bound => 1
5214: );
5215: DBMS_SQL.define_array (c => l_csr,
5216: POSITION => 56,
5217: n_tab => t_timecard_max_ovn,
5218: cnt => l_max_array_size,
5219: lower_bound => 1
5217: n_tab => t_timecard_max_ovn,
5218: cnt => l_max_array_size,
5219: lower_bound => 1
5220: );
5221: DBMS_SQL.define_array (c => l_csr,
5222: POSITION => 57,
5223: n_tab => t_day_max_ovn,
5224: cnt => l_max_array_size,
5225: lower_bound => 1
5223: n_tab => t_day_max_ovn,
5224: cnt => l_max_array_size,
5225: lower_bound => 1
5226: );
5227: DBMS_SQL.define_array (c => l_csr,
5228: POSITION => 58,
5229: n_tab => t_detail_max_ovn,
5230: cnt => l_max_array_size,
5231: lower_bound => 1
5229: n_tab => t_detail_max_ovn,
5230: cnt => l_max_array_size,
5231: lower_bound => 1
5232: );
5233: DBMS_SQL.define_array (c => l_csr,
5234: POSITION => 59,
5235: c_tab => t_detail_uom,
5236: cnt => l_max_array_size,
5237: lower_bound => 1
5235: c_tab => t_detail_uom,
5236: cnt => l_max_array_size,
5237: lower_bound => 1
5238: );
5239: DBMS_SQL.define_array (c => l_csr,
5240: POSITION => 60,
5241: d_tab => t_timecard_start_time,
5242: cnt => l_max_array_size,
5243: lower_bound => 1
5241: d_tab => t_timecard_start_time,
5242: cnt => l_max_array_size,
5243: lower_bound => 1
5244: );
5245: DBMS_SQL.define_array (c => l_csr,
5246: POSITION => 61,
5247: d_tab => t_timecard_stop_time,
5248: cnt => l_max_array_size,
5249: lower_bound => 1
5247: d_tab => t_timecard_stop_time,
5248: cnt => l_max_array_size,
5249: lower_bound => 1
5250: );
5251: DBMS_SQL.define_array (c => l_csr,
5252: POSITION => 62,
5253: c_tab => t_timecard_comment_text,
5254: cnt => l_max_array_size,
5255: lower_bound => 1
5253: c_tab => t_timecard_comment_text,
5254: cnt => l_max_array_size,
5255: lower_bound => 1
5256: );
5257: DBMS_SQL.define_array (c => l_csr,
5258: POSITION => 63,
5259: c_tab => t_timecard_deleted,
5260: cnt => l_max_array_size,
5261: lower_bound => 1
5265: THEN
5266: hr_utility.set_location ('Processing ' || l_proc, 50);
5267: END IF;
5268:
5269: l_dummy := DBMS_SQL.EXECUTE (l_csr);
5270:
5271: IF g_debug
5272: THEN
5273: hr_utility.set_location ('Processing ' || l_proc, 60);
5275:
5276: -- loop to ensure we fetch all the rows
5277: WHILE (l_rows_fetched = l_max_array_size)
5278: LOOP
5279: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
5280:
5281: IF (l_rows_fetched = 0 AND t_bb.COUNT = 0)
5282: THEN
5283: DBMS_SQL.close_cursor (l_csr);
5279: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
5280:
5281: IF (l_rows_fetched = 0 AND t_bb.COUNT = 0)
5282: THEN
5283: DBMS_SQL.close_cursor (l_csr);
5284: -- Bug 8888911
5285: -- Marking that this is an empty chunk.
5286: put_log(' ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
5287: put_log(' This is an empty chunk : No records relevant for these resources ');
5292: END IF;
5293: RAISE e_no_timecards;
5294: END IF;
5295:
5296: DBMS_SQL.column_value (c => l_csr,
5297: POSITION => 1,
5298: n_tab => t_timecard_bb_id
5299: );
5300: DBMS_SQL.column_value (c => l_csr,
5296: DBMS_SQL.column_value (c => l_csr,
5297: POSITION => 1,
5298: n_tab => t_timecard_bb_id
5299: );
5300: DBMS_SQL.column_value (c => l_csr,
5301: POSITION => 2,
5302: n_tab => t_timecard_ovn
5303: );
5304: DBMS_SQL.column_value (c => l_csr,
5300: DBMS_SQL.column_value (c => l_csr,
5301: POSITION => 2,
5302: n_tab => t_timecard_ovn
5303: );
5304: DBMS_SQL.column_value (c => l_csr,
5305: POSITION => 3,
5306: n_tab => t_day_bb_id
5307: );
5308: DBMS_SQL.column_value (c => l_csr, POSITION => 4,
5304: DBMS_SQL.column_value (c => l_csr,
5305: POSITION => 3,
5306: n_tab => t_day_bb_id
5307: );
5308: DBMS_SQL.column_value (c => l_csr, POSITION => 4,
5309: n_tab => t_day_ovn);
5310: DBMS_SQL.column_value (c => l_csr,
5311: POSITION => 5,
5312: d_tab => t_day_start_time
5306: n_tab => t_day_bb_id
5307: );
5308: DBMS_SQL.column_value (c => l_csr, POSITION => 4,
5309: n_tab => t_day_ovn);
5310: DBMS_SQL.column_value (c => l_csr,
5311: POSITION => 5,
5312: d_tab => t_day_start_time
5313: );
5314: DBMS_SQL.column_value (c => l_csr,
5310: DBMS_SQL.column_value (c => l_csr,
5311: POSITION => 5,
5312: d_tab => t_day_start_time
5313: );
5314: DBMS_SQL.column_value (c => l_csr,
5315: POSITION => 6,
5316: d_tab => t_day_stop_time
5317: );
5318: DBMS_SQL.column_value (c => l_csr,
5314: DBMS_SQL.column_value (c => l_csr,
5315: POSITION => 6,
5316: d_tab => t_day_stop_time
5317: );
5318: DBMS_SQL.column_value (c => l_csr,
5319: POSITION => 7,
5320: n_tab => t_detail_bb_id
5321: );
5322: DBMS_SQL.column_value (c => l_csr,
5318: DBMS_SQL.column_value (c => l_csr,
5319: POSITION => 7,
5320: n_tab => t_detail_bb_id
5321: );
5322: DBMS_SQL.column_value (c => l_csr,
5323: POSITION => 8,
5324: n_tab => t_detail_ovn
5325: );
5326: DBMS_SQL.column_value (c => l_csr,
5322: DBMS_SQL.column_value (c => l_csr,
5323: POSITION => 8,
5324: n_tab => t_detail_ovn
5325: );
5326: DBMS_SQL.column_value (c => l_csr,
5327: POSITION => 9,
5328: n_tab => t_detail_parent_id
5329: );
5330: DBMS_SQL.column_value (c => l_csr,
5326: DBMS_SQL.column_value (c => l_csr,
5327: POSITION => 9,
5328: n_tab => t_detail_parent_id
5329: );
5330: DBMS_SQL.column_value (c => l_csr,
5331: POSITION => 10,
5332: c_tab => t_detail_resource_type
5333: );
5334: DBMS_SQL.column_value (c => l_csr,
5330: DBMS_SQL.column_value (c => l_csr,
5331: POSITION => 10,
5332: c_tab => t_detail_resource_type
5333: );
5334: DBMS_SQL.column_value (c => l_csr,
5335: POSITION => 11,
5336: n_tab => t_detail_resource_id
5337: );
5338: DBMS_SQL.column_value (c => l_csr,
5334: DBMS_SQL.column_value (c => l_csr,
5335: POSITION => 11,
5336: n_tab => t_detail_resource_id
5337: );
5338: DBMS_SQL.column_value (c => l_csr,
5339: POSITION => 12,
5340: c_tab => t_detail_comment_text
5341: );
5342: DBMS_SQL.column_value (c => l_csr,
5338: DBMS_SQL.column_value (c => l_csr,
5339: POSITION => 12,
5340: c_tab => t_detail_comment_text
5341: );
5342: DBMS_SQL.column_value (c => l_csr,
5343: POSITION => 13,
5344: d_tab => t_detail_start_time
5345: );
5346: DBMS_SQL.column_value (c => l_csr,
5342: DBMS_SQL.column_value (c => l_csr,
5343: POSITION => 13,
5344: d_tab => t_detail_start_time
5345: );
5346: DBMS_SQL.column_value (c => l_csr,
5347: POSITION => 14,
5348: d_tab => t_detail_stop_time
5349: );
5350: DBMS_SQL.column_value (c => l_csr,
5346: DBMS_SQL.column_value (c => l_csr,
5347: POSITION => 14,
5348: d_tab => t_detail_stop_time
5349: );
5350: DBMS_SQL.column_value (c => l_csr,
5351: POSITION => 15,
5352: n_tab => t_detail_measure
5353: );
5354: DBMS_SQL.column_value (c => l_csr,
5350: DBMS_SQL.column_value (c => l_csr,
5351: POSITION => 15,
5352: n_tab => t_detail_measure
5353: );
5354: DBMS_SQL.column_value (c => l_csr,
5355: POSITION => 16,
5356: c_tab => t_detail_scope
5357: );
5358: DBMS_SQL.column_value (c => l_csr,
5354: DBMS_SQL.column_value (c => l_csr,
5355: POSITION => 16,
5356: c_tab => t_detail_scope
5357: );
5358: DBMS_SQL.column_value (c => l_csr,
5359: POSITION => 17,
5360: c_tab => t_detail_type
5361: );
5362: DBMS_SQL.column_value (c => l_csr,
5358: DBMS_SQL.column_value (c => l_csr,
5359: POSITION => 17,
5360: c_tab => t_detail_type
5361: );
5362: DBMS_SQL.column_value (c => l_csr,
5363: POSITION => 18,
5364: n_tab => t_detail_ta_id
5365: );
5366: DBMS_SQL.column_value (c => l_csr,
5362: DBMS_SQL.column_value (c => l_csr,
5363: POSITION => 18,
5364: n_tab => t_detail_ta_id
5365: );
5366: DBMS_SQL.column_value (c => l_csr,
5367: POSITION => 19,
5368: n_tab => t_detail_bld_blk_info_type_id
5369: );
5370: DBMS_SQL.column_value (c => l_csr,
5366: DBMS_SQL.column_value (c => l_csr,
5367: POSITION => 19,
5368: n_tab => t_detail_bld_blk_info_type_id
5369: );
5370: DBMS_SQL.column_value (c => l_csr,
5371: POSITION => 20,
5372: c_tab => t_detail_attribute1
5373: );
5374: DBMS_SQL.column_value (c => l_csr,
5370: DBMS_SQL.column_value (c => l_csr,
5371: POSITION => 20,
5372: c_tab => t_detail_attribute1
5373: );
5374: DBMS_SQL.column_value (c => l_csr,
5375: POSITION => 21,
5376: c_tab => t_detail_attribute2
5377: );
5378: DBMS_SQL.column_value (c => l_csr,
5374: DBMS_SQL.column_value (c => l_csr,
5375: POSITION => 21,
5376: c_tab => t_detail_attribute2
5377: );
5378: DBMS_SQL.column_value (c => l_csr,
5379: POSITION => 22,
5380: c_tab => t_detail_attribute3
5381: );
5382: DBMS_SQL.column_value (c => l_csr,
5378: DBMS_SQL.column_value (c => l_csr,
5379: POSITION => 22,
5380: c_tab => t_detail_attribute3
5381: );
5382: DBMS_SQL.column_value (c => l_csr,
5383: POSITION => 23,
5384: c_tab => t_detail_attribute4
5385: );
5386: DBMS_SQL.column_value (c => l_csr,
5382: DBMS_SQL.column_value (c => l_csr,
5383: POSITION => 23,
5384: c_tab => t_detail_attribute4
5385: );
5386: DBMS_SQL.column_value (c => l_csr,
5387: POSITION => 24,
5388: c_tab => t_detail_attribute5
5389: );
5390: DBMS_SQL.column_value (c => l_csr,
5386: DBMS_SQL.column_value (c => l_csr,
5387: POSITION => 24,
5388: c_tab => t_detail_attribute5
5389: );
5390: DBMS_SQL.column_value (c => l_csr,
5391: POSITION => 25,
5392: c_tab => t_detail_attribute6
5393: );
5394: DBMS_SQL.column_value (c => l_csr,
5390: DBMS_SQL.column_value (c => l_csr,
5391: POSITION => 25,
5392: c_tab => t_detail_attribute6
5393: );
5394: DBMS_SQL.column_value (c => l_csr,
5395: POSITION => 26,
5396: c_tab => t_detail_attribute7
5397: );
5398: DBMS_SQL.column_value (c => l_csr,
5394: DBMS_SQL.column_value (c => l_csr,
5395: POSITION => 26,
5396: c_tab => t_detail_attribute7
5397: );
5398: DBMS_SQL.column_value (c => l_csr,
5399: POSITION => 27,
5400: c_tab => t_detail_attribute8
5401: );
5402: DBMS_SQL.column_value (c => l_csr,
5398: DBMS_SQL.column_value (c => l_csr,
5399: POSITION => 27,
5400: c_tab => t_detail_attribute8
5401: );
5402: DBMS_SQL.column_value (c => l_csr,
5403: POSITION => 28,
5404: c_tab => t_detail_attribute9
5405: );
5406: DBMS_SQL.column_value (c => l_csr,
5402: DBMS_SQL.column_value (c => l_csr,
5403: POSITION => 28,
5404: c_tab => t_detail_attribute9
5405: );
5406: DBMS_SQL.column_value (c => l_csr,
5407: POSITION => 29,
5408: c_tab => t_detail_attribute10
5409: );
5410: DBMS_SQL.column_value (c => l_csr,
5406: DBMS_SQL.column_value (c => l_csr,
5407: POSITION => 29,
5408: c_tab => t_detail_attribute10
5409: );
5410: DBMS_SQL.column_value (c => l_csr,
5411: POSITION => 30,
5412: c_tab => t_detail_attribute11
5413: );
5414: DBMS_SQL.column_value (c => l_csr,
5410: DBMS_SQL.column_value (c => l_csr,
5411: POSITION => 30,
5412: c_tab => t_detail_attribute11
5413: );
5414: DBMS_SQL.column_value (c => l_csr,
5415: POSITION => 31,
5416: c_tab => t_detail_attribute12
5417: );
5418: DBMS_SQL.column_value (c => l_csr,
5414: DBMS_SQL.column_value (c => l_csr,
5415: POSITION => 31,
5416: c_tab => t_detail_attribute12
5417: );
5418: DBMS_SQL.column_value (c => l_csr,
5419: POSITION => 32,
5420: c_tab => t_detail_attribute13
5421: );
5422: DBMS_SQL.column_value (c => l_csr,
5418: DBMS_SQL.column_value (c => l_csr,
5419: POSITION => 32,
5420: c_tab => t_detail_attribute13
5421: );
5422: DBMS_SQL.column_value (c => l_csr,
5423: POSITION => 33,
5424: c_tab => t_detail_attribute14
5425: );
5426: DBMS_SQL.column_value (c => l_csr,
5422: DBMS_SQL.column_value (c => l_csr,
5423: POSITION => 33,
5424: c_tab => t_detail_attribute14
5425: );
5426: DBMS_SQL.column_value (c => l_csr,
5427: POSITION => 34,
5428: c_tab => t_detail_attribute15
5429: );
5430: DBMS_SQL.column_value (c => l_csr,
5426: DBMS_SQL.column_value (c => l_csr,
5427: POSITION => 34,
5428: c_tab => t_detail_attribute15
5429: );
5430: DBMS_SQL.column_value (c => l_csr,
5431: POSITION => 35,
5432: c_tab => t_detail_attribute16
5433: );
5434: DBMS_SQL.column_value (c => l_csr,
5430: DBMS_SQL.column_value (c => l_csr,
5431: POSITION => 35,
5432: c_tab => t_detail_attribute16
5433: );
5434: DBMS_SQL.column_value (c => l_csr,
5435: POSITION => 36,
5436: c_tab => t_detail_attribute17
5437: );
5438: DBMS_SQL.column_value (c => l_csr,
5434: DBMS_SQL.column_value (c => l_csr,
5435: POSITION => 36,
5436: c_tab => t_detail_attribute17
5437: );
5438: DBMS_SQL.column_value (c => l_csr,
5439: POSITION => 37,
5440: c_tab => t_detail_attribute18
5441: );
5442: DBMS_SQL.column_value (c => l_csr,
5438: DBMS_SQL.column_value (c => l_csr,
5439: POSITION => 37,
5440: c_tab => t_detail_attribute18
5441: );
5442: DBMS_SQL.column_value (c => l_csr,
5443: POSITION => 38,
5444: c_tab => t_detail_attribute19
5445: );
5446: DBMS_SQL.column_value (c => l_csr,
5442: DBMS_SQL.column_value (c => l_csr,
5443: POSITION => 38,
5444: c_tab => t_detail_attribute19
5445: );
5446: DBMS_SQL.column_value (c => l_csr,
5447: POSITION => 39,
5448: c_tab => t_detail_attribute20
5449: );
5450: DBMS_SQL.column_value (c => l_csr,
5446: DBMS_SQL.column_value (c => l_csr,
5447: POSITION => 39,
5448: c_tab => t_detail_attribute20
5449: );
5450: DBMS_SQL.column_value (c => l_csr,
5451: POSITION => 40,
5452: c_tab => t_detail_attribute21
5453: );
5454: DBMS_SQL.column_value (c => l_csr,
5450: DBMS_SQL.column_value (c => l_csr,
5451: POSITION => 40,
5452: c_tab => t_detail_attribute21
5453: );
5454: DBMS_SQL.column_value (c => l_csr,
5455: POSITION => 41,
5456: c_tab => t_detail_attribute22
5457: );
5458: DBMS_SQL.column_value (c => l_csr,
5454: DBMS_SQL.column_value (c => l_csr,
5455: POSITION => 41,
5456: c_tab => t_detail_attribute22
5457: );
5458: DBMS_SQL.column_value (c => l_csr,
5459: POSITION => 42,
5460: c_tab => t_detail_attribute23
5461: );
5462: DBMS_SQL.column_value (c => l_csr,
5458: DBMS_SQL.column_value (c => l_csr,
5459: POSITION => 42,
5460: c_tab => t_detail_attribute23
5461: );
5462: DBMS_SQL.column_value (c => l_csr,
5463: POSITION => 43,
5464: c_tab => t_detail_attribute24
5465: );
5466: DBMS_SQL.column_value (c => l_csr,
5462: DBMS_SQL.column_value (c => l_csr,
5463: POSITION => 43,
5464: c_tab => t_detail_attribute24
5465: );
5466: DBMS_SQL.column_value (c => l_csr,
5467: POSITION => 44,
5468: c_tab => t_detail_attribute25
5469: );
5470: DBMS_SQL.column_value (c => l_csr,
5466: DBMS_SQL.column_value (c => l_csr,
5467: POSITION => 44,
5468: c_tab => t_detail_attribute25
5469: );
5470: DBMS_SQL.column_value (c => l_csr,
5471: POSITION => 45,
5472: c_tab => t_detail_attribute26
5473: );
5474: DBMS_SQL.column_value (c => l_csr,
5470: DBMS_SQL.column_value (c => l_csr,
5471: POSITION => 45,
5472: c_tab => t_detail_attribute26
5473: );
5474: DBMS_SQL.column_value (c => l_csr,
5475: POSITION => 46,
5476: c_tab => t_detail_attribute27
5477: );
5478: DBMS_SQL.column_value (c => l_csr,
5474: DBMS_SQL.column_value (c => l_csr,
5475: POSITION => 46,
5476: c_tab => t_detail_attribute27
5477: );
5478: DBMS_SQL.column_value (c => l_csr,
5479: POSITION => 47,
5480: c_tab => t_detail_attribute28
5481: );
5482: DBMS_SQL.column_value (c => l_csr,
5478: DBMS_SQL.column_value (c => l_csr,
5479: POSITION => 47,
5480: c_tab => t_detail_attribute28
5481: );
5482: DBMS_SQL.column_value (c => l_csr,
5483: POSITION => 48,
5484: c_tab => t_detail_attribute29
5485: );
5486: DBMS_SQL.column_value (c => l_csr,
5482: DBMS_SQL.column_value (c => l_csr,
5483: POSITION => 48,
5484: c_tab => t_detail_attribute29
5485: );
5486: DBMS_SQL.column_value (c => l_csr,
5487: POSITION => 49,
5488: c_tab => t_detail_attribute30
5489: );
5490: DBMS_SQL.column_value (c => l_csr,
5486: DBMS_SQL.column_value (c => l_csr,
5487: POSITION => 49,
5488: c_tab => t_detail_attribute30
5489: );
5490: DBMS_SQL.column_value (c => l_csr,
5491: POSITION => 50,
5492: d_tab => t_detail_date_from
5493: );
5494: DBMS_SQL.column_value (c => l_csr,
5490: DBMS_SQL.column_value (c => l_csr,
5491: POSITION => 50,
5492: d_tab => t_detail_date_from
5493: );
5494: DBMS_SQL.column_value (c => l_csr,
5495: POSITION => 51,
5496: d_tab => t_detail_date_to
5497: );
5498: DBMS_SQL.column_value (c => l_csr,
5494: DBMS_SQL.column_value (c => l_csr,
5495: POSITION => 51,
5496: d_tab => t_detail_date_to
5497: );
5498: DBMS_SQL.column_value (c => l_csr,
5499: POSITION => 52,
5500: c_tab => t_detail_approval_status
5501: );
5502: DBMS_SQL.column_value (c => l_csr,
5498: DBMS_SQL.column_value (c => l_csr,
5499: POSITION => 52,
5500: c_tab => t_detail_approval_status
5501: );
5502: DBMS_SQL.column_value (c => l_csr,
5503: POSITION => 53,
5504: n_tab => t_detail_approval_style_id
5505: );
5506: DBMS_SQL.column_value (c => l_csr,
5502: DBMS_SQL.column_value (c => l_csr,
5503: POSITION => 53,
5504: n_tab => t_detail_approval_style_id
5505: );
5506: DBMS_SQL.column_value (c => l_csr,
5507: POSITION => 54,
5508: c_tab => t_detail_deleted
5509: );
5510: DBMS_SQL.column_value (c => l_csr,
5506: DBMS_SQL.column_value (c => l_csr,
5507: POSITION => 54,
5508: c_tab => t_detail_deleted
5509: );
5510: DBMS_SQL.column_value (c => l_csr,
5511: POSITION => 55,
5512: c_tab => t_detail_attribute_category
5513: );
5514: DBMS_SQL.column_value (c => l_csr,
5510: DBMS_SQL.column_value (c => l_csr,
5511: POSITION => 55,
5512: c_tab => t_detail_attribute_category
5513: );
5514: DBMS_SQL.column_value (c => l_csr,
5515: POSITION => 56,
5516: n_tab => t_timecard_max_ovn
5517: );
5518: DBMS_SQL.column_value (c => l_csr,
5514: DBMS_SQL.column_value (c => l_csr,
5515: POSITION => 56,
5516: n_tab => t_timecard_max_ovn
5517: );
5518: DBMS_SQL.column_value (c => l_csr,
5519: POSITION => 57,
5520: n_tab => t_day_max_ovn
5521: );
5522: DBMS_SQL.column_value (c => l_csr,
5518: DBMS_SQL.column_value (c => l_csr,
5519: POSITION => 57,
5520: n_tab => t_day_max_ovn
5521: );
5522: DBMS_SQL.column_value (c => l_csr,
5523: POSITION => 58,
5524: n_tab => t_detail_max_ovn
5525: );
5526: DBMS_SQL.column_value (c => l_csr,
5522: DBMS_SQL.column_value (c => l_csr,
5523: POSITION => 58,
5524: n_tab => t_detail_max_ovn
5525: );
5526: DBMS_SQL.column_value (c => l_csr,
5527: POSITION => 59,
5528: c_tab => t_detail_uom
5529: );
5530: DBMS_SQL.column_value (c => l_csr,
5526: DBMS_SQL.column_value (c => l_csr,
5527: POSITION => 59,
5528: c_tab => t_detail_uom
5529: );
5530: DBMS_SQL.column_value (c => l_csr,
5531: POSITION => 60,
5532: d_tab => t_timecard_start_time
5533: );
5534: DBMS_SQL.column_value (c => l_csr,
5530: DBMS_SQL.column_value (c => l_csr,
5531: POSITION => 60,
5532: d_tab => t_timecard_start_time
5533: );
5534: DBMS_SQL.column_value (c => l_csr,
5535: POSITION => 61,
5536: d_tab => t_timecard_stop_time
5537: );
5538: DBMS_SQL.column_value (c => l_csr,
5534: DBMS_SQL.column_value (c => l_csr,
5535: POSITION => 61,
5536: d_tab => t_timecard_stop_time
5537: );
5538: DBMS_SQL.column_value (c => l_csr,
5539: POSITION => 62,
5540: c_tab => t_timecard_comment_text
5541: );
5542: DBMS_SQL.column_value (c => l_csr,
5538: DBMS_SQL.column_value (c => l_csr,
5539: POSITION => 62,
5540: c_tab => t_timecard_comment_text
5541: );
5542: DBMS_SQL.column_value (c => l_csr,
5543: POSITION => 63,
5544: c_tab => t_timecard_deleted
5545: );
5546: -- to make the data more manageable copy the arrays into PL/SQL tables
5547: -- and save space
5548: populate_query_table;
5549: END LOOP;
5550:
5551: DBMS_SQL.close_cursor (l_csr);
5552:
5553: IF g_debug
5554: THEN
5555: hr_utility.set_location ('Processing ' || l_proc, 110);