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_GENERIC_RETRIEVAL_PKG dependencies on DBMS_SQL

Line 27: t_old_time_seq DBMS_SQL.number_table;

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;

Line 28: t_old_day_seq 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;

Line 29: t_old_detail_seq 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;

Line 30: t_old_time_bb_id 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;

Line 31: t_old_day_bb_id 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;

Line 32: t_old_detail_bb_id 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

Line 33: t_old_time_ovn 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
37: t_timecard_bb_id DBMS_SQL.number_table;

Line 34: t_old_day_ovn 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;

Line 35: t_old_detail_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;

Line 37: t_timecard_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;
40: t_timecard_start_time DBMS_SQL.date_table;
41: t_timecard_stop_time DBMS_SQL.date_table;

Line 38: t_timecard_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;
42: t_timecard_comment_text DBMS_SQL.varchar2_table;

Line 39: t_timecard_max_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;
43: t_timecard_deleted DBMS_SQL.varchar2_table;

Line 40: t_timecard_start_time DBMS_SQL.date_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;

Line 41: t_timecard_stop_time DBMS_SQL.date_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;

Line 42: t_timecard_comment_text DBMS_SQL.varchar2_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;

Line 43: t_timecard_deleted DBMS_SQL.varchar2_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;

Line 44: t_day_bb_id 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;
48: t_day_max_ovn DBMS_SQL.number_table;

Line 45: t_day_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;

Line 46: t_day_start_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;
50: t_detail_parent_id DBMS_SQL.number_table;

Line 47: t_day_stop_time DBMS_SQL.date_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;

Line 48: t_day_max_ovn DBMS_SQL.number_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;

Line 49: t_detail_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;
53: t_detail_comment_text DBMS_SQL.varchar2_table;

Line 50: t_detail_parent_id 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;
54: t_detail_start_time DBMS_SQL.date_table;

Line 51: t_detail_resource_type DBMS_SQL.varchar2_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;

Line 52: t_detail_resource_id DBMS_SQL.number_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;

Line 53: t_detail_comment_text DBMS_SQL.varchar2_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;

Line 54: t_detail_start_time DBMS_SQL.date_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;

Line 55: t_detail_stop_time DBMS_SQL.date_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;

Line 56: t_detail_measure 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;

Line 57: t_detail_scope DBMS_SQL.varchar2_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;

Line 58: t_detail_type 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;

Line 59: t_detail_ta_id DBMS_SQL.number_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;

Line 60: t_detail_bld_blk_info_type_id DBMS_SQL.number_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;

Line 61: t_detail_attribute1 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;

Line 62: t_detail_attribute2 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;

Line 63: t_detail_attribute3 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;

Line 64: t_detail_attribute4 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;

Line 65: t_detail_attribute5 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;

Line 66: t_detail_attribute6 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;

Line 67: t_detail_attribute7 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;

Line 68: t_detail_attribute8 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;

Line 69: t_detail_attribute9 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;

Line 70: t_detail_attribute10 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;

Line 71: t_detail_attribute11 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;

Line 72: t_detail_attribute12 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;

Line 73: t_detail_attribute13 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;

Line 74: t_detail_attribute14 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;

Line 75: t_detail_attribute15 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;

Line 76: t_detail_attribute16 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;

Line 77: t_detail_attribute17 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;

Line 78: t_detail_attribute18 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;

Line 79: t_detail_attribute19 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;

Line 80: t_detail_attribute20 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;

Line 81: t_detail_attribute21 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;

Line 82: t_detail_attribute22 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;

Line 83: t_detail_attribute23 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;

Line 84: t_detail_attribute24 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;

Line 85: t_detail_attribute25 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;

Line 86: t_detail_attribute26 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;

Line 87: t_detail_attribute27 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;

Line 88: t_detail_attribute28 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;

Line 89: t_detail_attribute29 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;
93: t_detail_max_ovn DBMS_SQL.number_table;

Line 90: t_detail_attribute30 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;
94: t_detail_deleted DBMS_SQL.varchar2_table;

Line 91: t_detail_attribute_category 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;

Line 92: t_detail_ovn DBMS_SQL.number_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;

Line 93: t_detail_max_ovn DBMS_SQL.number_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;

Line 94: t_detail_deleted 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;
98: t_detail_approval_status DBMS_SQL.varchar2_table;

Line 95: t_detail_uom 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;

Line 96: t_detail_date_from DBMS_SQL.date_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:

Line 97: t_detail_date_to DBMS_SQL.date_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:
101: -- time attribute types

Line 98: t_detail_approval_status DBMS_SQL.varchar2_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
102: TYPE tab_ta_fk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE

Line 99: t_detail_approval_style_id DBMS_SQL.number_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
103: INDEX BY BINARY_INTEGER;

Line 566: t_resource_id DBMS_SQL.number_table;

562: t_range_stop tab_range_stop;
563: t_seq tab_seq;
564: t_where_clause tab_where_clause;
565: t_resource_id_bulk tab_resource_id;
566: t_resource_id DBMS_SQL.number_table;
567: t_retrieval_range_id DBMS_SQL.number_table;
568: l_resource_list DBMS_SQL.number_table;
569: l_rows_fetched INTEGER;
570: l_csr INTEGER;

Line 567: t_retrieval_range_id DBMS_SQL.number_table;

563: t_seq tab_seq;
564: t_where_clause tab_where_clause;
565: t_resource_id_bulk tab_resource_id;
566: t_resource_id DBMS_SQL.number_table;
567: t_retrieval_range_id DBMS_SQL.number_table;
568: l_resource_list DBMS_SQL.number_table;
569: l_rows_fetched INTEGER;
570: l_csr INTEGER;
571: l_since_date DATE;

Line 568: l_resource_list DBMS_SQL.number_table;

564: t_where_clause tab_where_clause;
565: t_resource_id_bulk tab_resource_id;
566: t_resource_id DBMS_SQL.number_table;
567: t_retrieval_range_id DBMS_SQL.number_table;
568: l_resource_list DBMS_SQL.number_table;
569: l_rows_fetched INTEGER;
570: l_csr INTEGER;
571: l_since_date DATE;
572: x PLS_INTEGER := 0;

Line 792: p_resource_list IN DBMS_SQL.number_table,

788: insert_query (l_dynamic_sql, 'RANGE');
789: END generate_resource_sql;
790:
791: PROCEDURE insert_rr_resources (
792: p_resource_list IN DBMS_SQL.number_table,
793: p_rr_id IN OUT NOCOPY NUMBER
794: )
795: IS
796: CURSOR csr_get_rr_id

Line 970: l_csr := DBMS_SQL.open_cursor;

966: END IF;
967:
968: -- use dynamic SQL BULK FETCH to generate resource list
969: l_rows_fetched := l_chunk_size;
970: l_csr := DBMS_SQL.open_cursor;
971: DBMS_SQL.parse (l_csr, l_dynamic_sql, DBMS_SQL.native);
972: -- bind variables needed by all queries
973: DBMS_SQL.bind_variable (l_csr,
974: ':p_since_date',

Line 971: DBMS_SQL.parse (l_csr, l_dynamic_sql, DBMS_SQL.native);

967:
968: -- use dynamic SQL BULK FETCH to generate resource list
969: l_rows_fetched := l_chunk_size;
970: l_csr := DBMS_SQL.open_cursor;
971: DBMS_SQL.parse (l_csr, l_dynamic_sql, DBMS_SQL.native);
972: -- bind variables needed by all queries
973: DBMS_SQL.bind_variable (l_csr,
974: ':p_since_date',
975: g_params.since_date

Line 973: DBMS_SQL.bind_variable (l_csr,

969: l_rows_fetched := l_chunk_size;
970: l_csr := DBMS_SQL.open_cursor;
971: DBMS_SQL.parse (l_csr, l_dynamic_sql, DBMS_SQL.native);
972: -- bind variables needed by all queries
973: DBMS_SQL.bind_variable (l_csr,
974: ':p_since_date',
975: g_params.since_date
976: );
977: -- define arrays for each item in the select list

Line 978: DBMS_SQL.define_array (c => l_csr,

974: ':p_since_date',
975: g_params.since_date
976: );
977: -- define arrays for each item in the select list
978: DBMS_SQL.define_array (c => l_csr,
979: POSITION => 1,
980: n_tab => t_resource_id,
981: cnt => l_chunk_size,
982: lower_bound => 1

Line 984: l_dummy := DBMS_SQL.EXECUTE (l_csr);

980: n_tab => t_resource_id,
981: cnt => l_chunk_size,
982: lower_bound => 1
983: );
984: l_dummy := DBMS_SQL.EXECUTE (l_csr);
985:
986: -- loop to ensure we fetch all the rows
987: WHILE (l_rows_fetched = l_chunk_size)
988: LOOP

Line 994: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);

990: THEN
991: hr_utility.TRACE ('in loop');
992: END IF;
993:
994: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
995:
996: IF g_debug
997: THEN
998: hr_utility.TRACE ( 'rows fetched is '

Line 1010: DBMS_SQL.close_cursor (l_csr);

1006: THEN
1007: hr_utility.TRACE ('No ranges !!!');
1008: END IF;
1009:
1010: DBMS_SQL.close_cursor (l_csr);
1011: RAISE e_no_ranges;
1012: ELSIF (l_rows_fetched > 0)
1013: THEN
1014: DBMS_SQL.column_value (c => l_csr,

Line 1014: DBMS_SQL.column_value (c => l_csr,

1010: DBMS_SQL.close_cursor (l_csr);
1011: RAISE e_no_ranges;
1012: ELSIF (l_rows_fetched > 0)
1013: THEN
1014: DBMS_SQL.column_value (c => l_csr,
1015: POSITION => 1,
1016: n_tab => t_resource_id
1017: );
1018: -- populate retrieval range resources

Line 1061: DBMS_SQL.close_cursor (l_csr);

1057: THEN
1058: hr_utility.TRACE ('Leaving loop');
1059: END IF;
1060:
1061: DBMS_SQL.close_cursor (l_csr);
1062: -- now insert retrieval ranges
1063: FORALL rrx IN 1 .. x
1064: INSERT INTO hxc_retrieval_ranges
1065: (retrieval_range_id,

Line 1349: t_tbb_id DBMS_SQL.number_table;

1345: AND tx.transaction_id = txd.transaction_id
1346: AND txd.status = ''SUCCESS''
1347: AND txd.time_building_block_id = tbb_latest.time_building_block_id
1348: AND txd.time_building_block_ovn = tbb_latest.object_version_number) ';
1349: t_tbb_id DBMS_SQL.number_table;
1350: t_tbb_ovn DBMS_SQL.number_table;
1351: l_start_date DATE;
1352: l_end_date DATE;
1353: l_csr INTEGER;

Line 1350: t_tbb_ovn DBMS_SQL.number_table;

1346: AND txd.status = ''SUCCESS''
1347: AND txd.time_building_block_id = tbb_latest.time_building_block_id
1348: AND txd.time_building_block_ovn = tbb_latest.object_version_number) ';
1349: t_tbb_id DBMS_SQL.number_table;
1350: t_tbb_ovn DBMS_SQL.number_table;
1351: l_start_date DATE;
1352: l_end_date DATE;
1353: l_csr INTEGER;
1354: l_rows_fetched INTEGER;

Line 1461: l_csr := DBMS_SQL.open_cursor;

1457:
1458: insert_query (l_ret_range_query, 'RET_RANGE_BLKS');
1459: -- now fetch and insert the rows
1460: l_rows_fetched := 100;
1461: l_csr := DBMS_SQL.open_cursor;
1462: DBMS_SQL.parse (l_csr, l_ret_range_query, DBMS_SQL.native);
1463: DBMS_SQL.bind_variable (l_csr,
1464: ':p_process_id',
1465: g_retrieval_process_id

Line 1462: DBMS_SQL.parse (l_csr, l_ret_range_query, DBMS_SQL.native);

1458: insert_query (l_ret_range_query, 'RET_RANGE_BLKS');
1459: -- now fetch and insert the rows
1460: l_rows_fetched := 100;
1461: l_csr := DBMS_SQL.open_cursor;
1462: DBMS_SQL.parse (l_csr, l_ret_range_query, DBMS_SQL.native);
1463: DBMS_SQL.bind_variable (l_csr,
1464: ':p_process_id',
1465: g_retrieval_process_id
1466: );

Line 1463: DBMS_SQL.bind_variable (l_csr,

1459: -- now fetch and insert the rows
1460: l_rows_fetched := 100;
1461: l_csr := DBMS_SQL.open_cursor;
1462: DBMS_SQL.parse (l_csr, l_ret_range_query, DBMS_SQL.native);
1463: DBMS_SQL.bind_variable (l_csr,
1464: ':p_process_id',
1465: g_retrieval_process_id
1466: );
1467: DBMS_SQL.bind_variable (l_csr, ':p_since_date', g_params.since_date);

Line 1467: DBMS_SQL.bind_variable (l_csr, ':p_since_date', g_params.since_date);

1463: DBMS_SQL.bind_variable (l_csr,
1464: ':p_process_id',
1465: g_retrieval_process_id
1466: );
1467: DBMS_SQL.bind_variable (l_csr, ':p_since_date', g_params.since_date);
1468: DBMS_SQL.bind_variable (l_csr, ':p_rr_id', l_pkg_retrieval_range_id);
1469:
1470: IF (g_params.l_using_dates)
1471: THEN

Line 1468: DBMS_SQL.bind_variable (l_csr, ':p_rr_id', l_pkg_retrieval_range_id);

1464: ':p_process_id',
1465: g_retrieval_process_id
1466: );
1467: DBMS_SQL.bind_variable (l_csr, ':p_since_date', g_params.since_date);
1468: DBMS_SQL.bind_variable (l_csr, ':p_rr_id', l_pkg_retrieval_range_id);
1469:
1470: IF (g_params.l_using_dates)
1471: THEN
1472: DBMS_SQL.bind_variable (l_csr, ':p_start_date', l_start_date);

Line 1472: DBMS_SQL.bind_variable (l_csr, ':p_start_date', l_start_date);

1468: DBMS_SQL.bind_variable (l_csr, ':p_rr_id', l_pkg_retrieval_range_id);
1469:
1470: IF (g_params.l_using_dates)
1471: THEN
1472: DBMS_SQL.bind_variable (l_csr, ':p_start_date', l_start_date);
1473: DBMS_SQL.bind_variable (l_csr, ':p_end_date', l_end_date);
1474: END IF;
1475:
1476: IF g_ret_criteria.gre_id IS NOT NULL

Line 1473: DBMS_SQL.bind_variable (l_csr, ':p_end_date', l_end_date);

1469:
1470: IF (g_params.l_using_dates)
1471: THEN
1472: DBMS_SQL.bind_variable (l_csr, ':p_start_date', l_start_date);
1473: DBMS_SQL.bind_variable (l_csr, ':p_end_date', l_end_date);
1474: END IF;
1475:
1476: IF g_ret_criteria.gre_id IS NOT NULL
1477: THEN

Line 1478: DBMS_SQL.bind_variable (l_csr, ':p_gre_id',

1474: END IF;
1475:
1476: IF g_ret_criteria.gre_id IS NOT NULL
1477: THEN
1478: DBMS_SQL.bind_variable (l_csr, ':p_gre_id',
1479: g_ret_criteria.gre_id);
1480: END IF;
1481:
1482: IF g_ret_criteria.payroll_id IS NOT NULL

Line 1484: DBMS_SQL.bind_variable (l_csr,

1480: END IF;
1481:
1482: IF g_ret_criteria.payroll_id IS NOT NULL
1483: THEN
1484: DBMS_SQL.bind_variable (l_csr,
1485: ':p_payroll_id',
1486: g_ret_criteria.payroll_id
1487: );
1488: END IF;

Line 1492: DBMS_SQL.bind_variable (l_csr,

1488: END IF;
1489:
1490: IF g_ret_criteria.location_id IS NOT NULL
1491: THEN
1492: DBMS_SQL.bind_variable (l_csr,
1493: ':p_location_id',
1494: g_ret_criteria.location_id
1495: );
1496: END IF;

Line 1500: DBMS_SQL.bind_variable (l_csr,

1496: END IF;
1497:
1498: IF g_ret_criteria.organization_id IS NOT NULL
1499: THEN
1500: DBMS_SQL.bind_variable (l_csr,
1501: ':p_org_id',
1502: g_ret_criteria.organization_id
1503: );
1504: END IF;

Line 1506: DBMS_SQL.define_array (c => l_csr,

1502: g_ret_criteria.organization_id
1503: );
1504: END IF;
1505:
1506: DBMS_SQL.define_array (c => l_csr,
1507: POSITION => 1,
1508: n_tab => t_tbb_id,
1509: cnt => 100,
1510: lower_bound => 1

Line 1512: DBMS_SQL.define_array (c => l_csr,

1508: n_tab => t_tbb_id,
1509: cnt => 100,
1510: lower_bound => 1
1511: );
1512: DBMS_SQL.define_array (c => l_csr,
1513: POSITION => 2,
1514: n_tab => t_tbb_ovn,
1515: cnt => 100,
1516: lower_bound => 1

Line 1518: l_dummy := DBMS_SQL.EXECUTE (l_csr);

1514: n_tab => t_tbb_ovn,
1515: cnt => 100,
1516: lower_bound => 1
1517: );
1518: l_dummy := DBMS_SQL.EXECUTE (l_csr);
1519:
1520: -- loop to ensure we fetch all the rows
1521: WHILE (l_rows_fetched = 100)
1522: LOOP

Line 1523: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);

1519:
1520: -- loop to ensure we fetch all the rows
1521: WHILE (l_rows_fetched = 100)
1522: LOOP
1523: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
1524:
1525: IF (l_rows_fetched > 0)
1526: THEN
1527: DBMS_SQL.column_value (c => l_csr,

Line 1527: DBMS_SQL.column_value (c => l_csr,

1523: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
1524:
1525: IF (l_rows_fetched > 0)
1526: THEN
1527: DBMS_SQL.column_value (c => l_csr,
1528: POSITION => 1,
1529: n_tab => t_tbb_id
1530: );
1531: DBMS_SQL.column_value (c => l_csr,

Line 1531: DBMS_SQL.column_value (c => l_csr,

1527: DBMS_SQL.column_value (c => l_csr,
1528: POSITION => 1,
1529: n_tab => t_tbb_id
1530: );
1531: DBMS_SQL.column_value (c => l_csr,
1532: POSITION => 2,
1533: n_tab => t_tbb_ovn
1534: );
1535: -- populate retrieval range blks

Line 1547: DBMS_SQL.close_cursor (l_csr);

1543: t_tbb_ovn.DELETE;
1544: END IF; -- l_rows_fetch = 0
1545: END LOOP; -- dynamic fetch of resources
1546:
1547: DBMS_SQL.close_cursor (l_csr);
1548: ELSE
1549: -- Retrievals which do not loop do not use
1550: -- this new table
1551: NULL;

Line 3739: -- The dynanmic SQL is parsed and executed and the dbms_sql arrays defined

3735: -- description
3736: -- This is the heart of the retrieval process. It retrieves and sorts the time
3737: -- building blocks.
3738: -- Retrieval:
3739: -- The dynanmic SQL is parsed and executed and the dbms_sql arrays defined
3740: -- and initialised. Once all the rows have been fetched the data is moved into
3741: -- one PL/SQL table (see populate_query_table).
3742: -- Sorting:
3743: -- Since the bld blks are retrieved in one query there is some data repetition.

Line 4150: l_csr := DBMS_SQL.open_cursor;

4146: THEN
4147: hr_utility.set_location ('Processing ' || l_proc, 20);
4148: END IF;
4149:
4150: l_csr := DBMS_SQL.open_cursor;
4151:
4152: IF g_debug
4153: THEN
4154: hr_utility.set_location ('Processing ' || l_proc, 30);

Line 4157: DBMS_SQL.parse (l_csr, l_query_text, DBMS_SQL.native);

4153: THEN
4154: hr_utility.set_location ('Processing ' || l_proc, 30);
4155: END IF;
4156:
4157: DBMS_SQL.parse (l_csr, l_query_text, DBMS_SQL.native);
4158:
4159: -- bind variables needed by all queries
4160: IF (g_params.p_process IN
4161: ('Projects Retrieval Process',

Line 4170: DBMS_SQL.bind_variable (l_csr, ':p_lower_range', l_pkg_range_start);

4166: )
4167: THEN
4168: NULL; -- no more binds - bound in pop ret range blks
4169: ELSE
4170: DBMS_SQL.bind_variable (l_csr, ':p_lower_range', l_pkg_range_start);
4171: DBMS_SQL.bind_variable (l_csr, ':p_upper_range', l_pkg_range_stop);
4172:
4173: IF (g_params.p_incremental = 'Y')
4174: THEN

Line 4171: DBMS_SQL.bind_variable (l_csr, ':p_upper_range', l_pkg_range_stop);

4167: THEN
4168: NULL; -- no more binds - bound in pop ret range blks
4169: ELSE
4170: DBMS_SQL.bind_variable (l_csr, ':p_lower_range', l_pkg_range_start);
4171: DBMS_SQL.bind_variable (l_csr, ':p_upper_range', l_pkg_range_stop);
4172:
4173: IF (g_params.p_incremental = 'Y')
4174: THEN
4175: DBMS_SQL.bind_variable (l_csr,

Line 4175: DBMS_SQL.bind_variable (l_csr,

4171: DBMS_SQL.bind_variable (l_csr, ':p_upper_range', l_pkg_range_stop);
4172:
4173: IF (g_params.p_incremental = 'Y')
4174: THEN
4175: DBMS_SQL.bind_variable (l_csr,
4176: ':p_process_id',
4177: g_retrieval_process_id
4178: );
4179: END IF;

Line 4193: DBMS_SQL.bind_variable (l_csr,

4189: )
4190: AND (g_params.p_rerun_flag = 'N')
4191: )
4192: THEN
4193: DBMS_SQL.bind_variable (l_csr,
4194: ':p_start_date',
4195: g_params.p_start_date
4196: );
4197: DBMS_SQL.bind_variable (l_csr, ':p_end_date', g_params.p_end_date);

Line 4197: DBMS_SQL.bind_variable (l_csr, ':p_end_date', g_params.p_end_date);

4193: DBMS_SQL.bind_variable (l_csr,
4194: ':p_start_date',
4195: g_params.p_start_date
4196: );
4197: DBMS_SQL.bind_variable (l_csr, ':p_end_date', g_params.p_end_date);
4198: END IF;
4199: END IF;
4200:
4201: IF g_debug

Line 4208: DBMS_SQL.bind_variable (l_csr,

4204: END IF;
4205:
4206: IF (g_params.p_rerun_flag = 'Y')
4207: THEN
4208: DBMS_SQL.bind_variable (l_csr,
4209: ':p_transaction_code',
4210: g_params.p_transaction_code
4211: );
4212: END IF;

Line 4220: DBMS_SQL.define_array (c => l_csr,

4216: THEN
4217: hr_utility.set_location ('Processing ' || l_proc, 40);
4218: END IF;
4219:
4220: DBMS_SQL.define_array (c => l_csr,
4221: POSITION => 1,
4222: n_tab => t_timecard_bb_id,
4223: cnt => l_max_array_size,
4224: lower_bound => 1

Line 4226: DBMS_SQL.define_array (c => l_csr,

4222: n_tab => t_timecard_bb_id,
4223: cnt => l_max_array_size,
4224: lower_bound => 1
4225: );
4226: DBMS_SQL.define_array (c => l_csr,
4227: POSITION => 2,
4228: n_tab => t_timecard_ovn,
4229: cnt => l_max_array_size,
4230: lower_bound => 1

Line 4232: DBMS_SQL.define_array (c => l_csr,

4228: n_tab => t_timecard_ovn,
4229: cnt => l_max_array_size,
4230: lower_bound => 1
4231: );
4232: DBMS_SQL.define_array (c => l_csr,
4233: POSITION => 3,
4234: n_tab => t_day_bb_id,
4235: cnt => l_max_array_size,
4236: lower_bound => 1

Line 4238: DBMS_SQL.define_array (c => l_csr,

4234: n_tab => t_day_bb_id,
4235: cnt => l_max_array_size,
4236: lower_bound => 1
4237: );
4238: DBMS_SQL.define_array (c => l_csr,
4239: POSITION => 4,
4240: n_tab => t_day_ovn,
4241: cnt => l_max_array_size,
4242: lower_bound => 1

Line 4244: DBMS_SQL.define_array (c => l_csr,

4240: n_tab => t_day_ovn,
4241: cnt => l_max_array_size,
4242: lower_bound => 1
4243: );
4244: DBMS_SQL.define_array (c => l_csr,
4245: POSITION => 5,
4246: d_tab => t_day_start_time,
4247: cnt => l_max_array_size,
4248: lower_bound => 1

Line 4250: DBMS_SQL.define_array (c => l_csr,

4246: d_tab => t_day_start_time,
4247: cnt => l_max_array_size,
4248: lower_bound => 1
4249: );
4250: DBMS_SQL.define_array (c => l_csr,
4251: POSITION => 6,
4252: d_tab => t_day_stop_time,
4253: cnt => l_max_array_size,
4254: lower_bound => 1

Line 4256: DBMS_SQL.define_array (c => l_csr,

4252: d_tab => t_day_stop_time,
4253: cnt => l_max_array_size,
4254: lower_bound => 1
4255: );
4256: DBMS_SQL.define_array (c => l_csr,
4257: POSITION => 7,
4258: n_tab => t_detail_bb_id,
4259: cnt => l_max_array_size,
4260: lower_bound => 1

Line 4262: DBMS_SQL.define_array (c => l_csr,

4258: n_tab => t_detail_bb_id,
4259: cnt => l_max_array_size,
4260: lower_bound => 1
4261: );
4262: DBMS_SQL.define_array (c => l_csr,
4263: POSITION => 8,
4264: n_tab => t_detail_ovn,
4265: cnt => l_max_array_size,
4266: lower_bound => 1

Line 4268: DBMS_SQL.define_array (c => l_csr,

4264: n_tab => t_detail_ovn,
4265: cnt => l_max_array_size,
4266: lower_bound => 1
4267: );
4268: DBMS_SQL.define_array (c => l_csr,
4269: POSITION => 9,
4270: n_tab => t_detail_parent_id,
4271: cnt => l_max_array_size,
4272: lower_bound => 1

Line 4274: DBMS_SQL.define_array (c => l_csr,

4270: n_tab => t_detail_parent_id,
4271: cnt => l_max_array_size,
4272: lower_bound => 1
4273: );
4274: DBMS_SQL.define_array (c => l_csr,
4275: POSITION => 10,
4276: c_tab => t_detail_resource_type,
4277: cnt => l_max_array_size,
4278: lower_bound => 1

Line 4280: DBMS_SQL.define_array (c => l_csr,

4276: c_tab => t_detail_resource_type,
4277: cnt => l_max_array_size,
4278: lower_bound => 1
4279: );
4280: DBMS_SQL.define_array (c => l_csr,
4281: POSITION => 11,
4282: n_tab => t_detail_resource_id,
4283: cnt => l_max_array_size,
4284: lower_bound => 1

Line 4286: DBMS_SQL.define_array (c => l_csr,

4282: n_tab => t_detail_resource_id,
4283: cnt => l_max_array_size,
4284: lower_bound => 1
4285: );
4286: DBMS_SQL.define_array (c => l_csr,
4287: POSITION => 12,
4288: c_tab => t_detail_comment_text,
4289: cnt => l_max_array_size,
4290: lower_bound => 1

Line 4292: DBMS_SQL.define_array (c => l_csr,

4288: c_tab => t_detail_comment_text,
4289: cnt => l_max_array_size,
4290: lower_bound => 1
4291: );
4292: DBMS_SQL.define_array (c => l_csr,
4293: POSITION => 13,
4294: d_tab => t_detail_start_time,
4295: cnt => l_max_array_size,
4296: lower_bound => 1

Line 4298: DBMS_SQL.define_array (c => l_csr,

4294: d_tab => t_detail_start_time,
4295: cnt => l_max_array_size,
4296: lower_bound => 1
4297: );
4298: DBMS_SQL.define_array (c => l_csr,
4299: POSITION => 14,
4300: d_tab => t_detail_stop_time,
4301: cnt => l_max_array_size,
4302: lower_bound => 1

Line 4304: DBMS_SQL.define_array (c => l_csr,

4300: d_tab => t_detail_stop_time,
4301: cnt => l_max_array_size,
4302: lower_bound => 1
4303: );
4304: DBMS_SQL.define_array (c => l_csr,
4305: POSITION => 15,
4306: n_tab => t_detail_measure,
4307: cnt => l_max_array_size,
4308: lower_bound => 1

Line 4310: DBMS_SQL.define_array (c => l_csr,

4306: n_tab => t_detail_measure,
4307: cnt => l_max_array_size,
4308: lower_bound => 1
4309: );
4310: DBMS_SQL.define_array (c => l_csr,
4311: POSITION => 16,
4312: c_tab => t_detail_scope,
4313: cnt => l_max_array_size,
4314: lower_bound => 1

Line 4316: DBMS_SQL.define_array (c => l_csr,

4312: c_tab => t_detail_scope,
4313: cnt => l_max_array_size,
4314: lower_bound => 1
4315: );
4316: DBMS_SQL.define_array (c => l_csr,
4317: POSITION => 17,
4318: c_tab => t_detail_type,
4319: cnt => l_max_array_size,
4320: lower_bound => 1

Line 4322: DBMS_SQL.define_array (c => l_csr,

4318: c_tab => t_detail_type,
4319: cnt => l_max_array_size,
4320: lower_bound => 1
4321: );
4322: DBMS_SQL.define_array (c => l_csr,
4323: POSITION => 18,
4324: n_tab => t_detail_ta_id,
4325: cnt => l_max_array_size,
4326: lower_bound => 1

Line 4328: DBMS_SQL.define_array (c => l_csr,

4324: n_tab => t_detail_ta_id,
4325: cnt => l_max_array_size,
4326: lower_bound => 1
4327: );
4328: DBMS_SQL.define_array (c => l_csr,
4329: POSITION => 19,
4330: n_tab => t_detail_bld_blk_info_type_id,
4331: cnt => l_max_array_size,
4332: lower_bound => 1

Line 4334: DBMS_SQL.define_array (c => l_csr,

4330: n_tab => t_detail_bld_blk_info_type_id,
4331: cnt => l_max_array_size,
4332: lower_bound => 1
4333: );
4334: DBMS_SQL.define_array (c => l_csr,
4335: POSITION => 20,
4336: c_tab => t_detail_attribute1,
4337: cnt => l_max_array_size,
4338: lower_bound => 1

Line 4340: DBMS_SQL.define_array (c => l_csr,

4336: c_tab => t_detail_attribute1,
4337: cnt => l_max_array_size,
4338: lower_bound => 1
4339: );
4340: DBMS_SQL.define_array (c => l_csr,
4341: POSITION => 21,
4342: c_tab => t_detail_attribute2,
4343: cnt => l_max_array_size,
4344: lower_bound => 1

Line 4346: DBMS_SQL.define_array (c => l_csr,

4342: c_tab => t_detail_attribute2,
4343: cnt => l_max_array_size,
4344: lower_bound => 1
4345: );
4346: DBMS_SQL.define_array (c => l_csr,
4347: POSITION => 22,
4348: c_tab => t_detail_attribute3,
4349: cnt => l_max_array_size,
4350: lower_bound => 1

Line 4352: DBMS_SQL.define_array (c => l_csr,

4348: c_tab => t_detail_attribute3,
4349: cnt => l_max_array_size,
4350: lower_bound => 1
4351: );
4352: DBMS_SQL.define_array (c => l_csr,
4353: POSITION => 23,
4354: c_tab => t_detail_attribute4,
4355: cnt => l_max_array_size,
4356: lower_bound => 1

Line 4358: DBMS_SQL.define_array (c => l_csr,

4354: c_tab => t_detail_attribute4,
4355: cnt => l_max_array_size,
4356: lower_bound => 1
4357: );
4358: DBMS_SQL.define_array (c => l_csr,
4359: POSITION => 24,
4360: c_tab => t_detail_attribute5,
4361: cnt => l_max_array_size,
4362: lower_bound => 1

Line 4364: DBMS_SQL.define_array (c => l_csr,

4360: c_tab => t_detail_attribute5,
4361: cnt => l_max_array_size,
4362: lower_bound => 1
4363: );
4364: DBMS_SQL.define_array (c => l_csr,
4365: POSITION => 25,
4366: c_tab => t_detail_attribute6,
4367: cnt => l_max_array_size,
4368: lower_bound => 1

Line 4370: DBMS_SQL.define_array (c => l_csr,

4366: c_tab => t_detail_attribute6,
4367: cnt => l_max_array_size,
4368: lower_bound => 1
4369: );
4370: DBMS_SQL.define_array (c => l_csr,
4371: POSITION => 26,
4372: c_tab => t_detail_attribute7,
4373: cnt => l_max_array_size,
4374: lower_bound => 1

Line 4376: DBMS_SQL.define_array (c => l_csr,

4372: c_tab => t_detail_attribute7,
4373: cnt => l_max_array_size,
4374: lower_bound => 1
4375: );
4376: DBMS_SQL.define_array (c => l_csr,
4377: POSITION => 27,
4378: c_tab => t_detail_attribute8,
4379: cnt => l_max_array_size,
4380: lower_bound => 1

Line 4382: DBMS_SQL.define_array (c => l_csr,

4378: c_tab => t_detail_attribute8,
4379: cnt => l_max_array_size,
4380: lower_bound => 1
4381: );
4382: DBMS_SQL.define_array (c => l_csr,
4383: POSITION => 28,
4384: c_tab => t_detail_attribute9,
4385: cnt => l_max_array_size,
4386: lower_bound => 1

Line 4388: DBMS_SQL.define_array (c => l_csr,

4384: c_tab => t_detail_attribute9,
4385: cnt => l_max_array_size,
4386: lower_bound => 1
4387: );
4388: DBMS_SQL.define_array (c => l_csr,
4389: POSITION => 29,
4390: c_tab => t_detail_attribute10,
4391: cnt => l_max_array_size,
4392: lower_bound => 1

Line 4394: DBMS_SQL.define_array (c => l_csr,

4390: c_tab => t_detail_attribute10,
4391: cnt => l_max_array_size,
4392: lower_bound => 1
4393: );
4394: DBMS_SQL.define_array (c => l_csr,
4395: POSITION => 30,
4396: c_tab => t_detail_attribute11,
4397: cnt => l_max_array_size,
4398: lower_bound => 1

Line 4400: DBMS_SQL.define_array (c => l_csr,

4396: c_tab => t_detail_attribute11,
4397: cnt => l_max_array_size,
4398: lower_bound => 1
4399: );
4400: DBMS_SQL.define_array (c => l_csr,
4401: POSITION => 31,
4402: c_tab => t_detail_attribute12,
4403: cnt => l_max_array_size,
4404: lower_bound => 1

Line 4406: DBMS_SQL.define_array (c => l_csr,

4402: c_tab => t_detail_attribute12,
4403: cnt => l_max_array_size,
4404: lower_bound => 1
4405: );
4406: DBMS_SQL.define_array (c => l_csr,
4407: POSITION => 32,
4408: c_tab => t_detail_attribute13,
4409: cnt => l_max_array_size,
4410: lower_bound => 1

Line 4412: DBMS_SQL.define_array (c => l_csr,

4408: c_tab => t_detail_attribute13,
4409: cnt => l_max_array_size,
4410: lower_bound => 1
4411: );
4412: DBMS_SQL.define_array (c => l_csr,
4413: POSITION => 33,
4414: c_tab => t_detail_attribute14,
4415: cnt => l_max_array_size,
4416: lower_bound => 1

Line 4418: DBMS_SQL.define_array (c => l_csr,

4414: c_tab => t_detail_attribute14,
4415: cnt => l_max_array_size,
4416: lower_bound => 1
4417: );
4418: DBMS_SQL.define_array (c => l_csr,
4419: POSITION => 34,
4420: c_tab => t_detail_attribute15,
4421: cnt => l_max_array_size,
4422: lower_bound => 1

Line 4424: DBMS_SQL.define_array (c => l_csr,

4420: c_tab => t_detail_attribute15,
4421: cnt => l_max_array_size,
4422: lower_bound => 1
4423: );
4424: DBMS_SQL.define_array (c => l_csr,
4425: POSITION => 35,
4426: c_tab => t_detail_attribute16,
4427: cnt => l_max_array_size,
4428: lower_bound => 1

Line 4430: DBMS_SQL.define_array (c => l_csr,

4426: c_tab => t_detail_attribute16,
4427: cnt => l_max_array_size,
4428: lower_bound => 1
4429: );
4430: DBMS_SQL.define_array (c => l_csr,
4431: POSITION => 36,
4432: c_tab => t_detail_attribute17,
4433: cnt => l_max_array_size,
4434: lower_bound => 1

Line 4436: DBMS_SQL.define_array (c => l_csr,

4432: c_tab => t_detail_attribute17,
4433: cnt => l_max_array_size,
4434: lower_bound => 1
4435: );
4436: DBMS_SQL.define_array (c => l_csr,
4437: POSITION => 37,
4438: c_tab => t_detail_attribute18,
4439: cnt => l_max_array_size,
4440: lower_bound => 1

Line 4442: DBMS_SQL.define_array (c => l_csr,

4438: c_tab => t_detail_attribute18,
4439: cnt => l_max_array_size,
4440: lower_bound => 1
4441: );
4442: DBMS_SQL.define_array (c => l_csr,
4443: POSITION => 38,
4444: c_tab => t_detail_attribute19,
4445: cnt => l_max_array_size,
4446: lower_bound => 1

Line 4448: DBMS_SQL.define_array (c => l_csr,

4444: c_tab => t_detail_attribute19,
4445: cnt => l_max_array_size,
4446: lower_bound => 1
4447: );
4448: DBMS_SQL.define_array (c => l_csr,
4449: POSITION => 39,
4450: c_tab => t_detail_attribute20,
4451: cnt => l_max_array_size,
4452: lower_bound => 1

Line 4454: DBMS_SQL.define_array (c => l_csr,

4450: c_tab => t_detail_attribute20,
4451: cnt => l_max_array_size,
4452: lower_bound => 1
4453: );
4454: DBMS_SQL.define_array (c => l_csr,
4455: POSITION => 40,
4456: c_tab => t_detail_attribute21,
4457: cnt => l_max_array_size,
4458: lower_bound => 1

Line 4460: DBMS_SQL.define_array (c => l_csr,

4456: c_tab => t_detail_attribute21,
4457: cnt => l_max_array_size,
4458: lower_bound => 1
4459: );
4460: DBMS_SQL.define_array (c => l_csr,
4461: POSITION => 41,
4462: c_tab => t_detail_attribute22,
4463: cnt => l_max_array_size,
4464: lower_bound => 1

Line 4466: DBMS_SQL.define_array (c => l_csr,

4462: c_tab => t_detail_attribute22,
4463: cnt => l_max_array_size,
4464: lower_bound => 1
4465: );
4466: DBMS_SQL.define_array (c => l_csr,
4467: POSITION => 42,
4468: c_tab => t_detail_attribute23,
4469: cnt => l_max_array_size,
4470: lower_bound => 1

Line 4472: DBMS_SQL.define_array (c => l_csr,

4468: c_tab => t_detail_attribute23,
4469: cnt => l_max_array_size,
4470: lower_bound => 1
4471: );
4472: DBMS_SQL.define_array (c => l_csr,
4473: POSITION => 43,
4474: c_tab => t_detail_attribute24,
4475: cnt => l_max_array_size,
4476: lower_bound => 1

Line 4478: DBMS_SQL.define_array (c => l_csr,

4474: c_tab => t_detail_attribute24,
4475: cnt => l_max_array_size,
4476: lower_bound => 1
4477: );
4478: DBMS_SQL.define_array (c => l_csr,
4479: POSITION => 44,
4480: c_tab => t_detail_attribute25,
4481: cnt => l_max_array_size,
4482: lower_bound => 1

Line 4484: DBMS_SQL.define_array (c => l_csr,

4480: c_tab => t_detail_attribute25,
4481: cnt => l_max_array_size,
4482: lower_bound => 1
4483: );
4484: DBMS_SQL.define_array (c => l_csr,
4485: POSITION => 45,
4486: c_tab => t_detail_attribute26,
4487: cnt => l_max_array_size,
4488: lower_bound => 1

Line 4490: DBMS_SQL.define_array (c => l_csr,

4486: c_tab => t_detail_attribute26,
4487: cnt => l_max_array_size,
4488: lower_bound => 1
4489: );
4490: DBMS_SQL.define_array (c => l_csr,
4491: POSITION => 46,
4492: c_tab => t_detail_attribute27,
4493: cnt => l_max_array_size,
4494: lower_bound => 1

Line 4496: DBMS_SQL.define_array (c => l_csr,

4492: c_tab => t_detail_attribute27,
4493: cnt => l_max_array_size,
4494: lower_bound => 1
4495: );
4496: DBMS_SQL.define_array (c => l_csr,
4497: POSITION => 47,
4498: c_tab => t_detail_attribute28,
4499: cnt => l_max_array_size,
4500: lower_bound => 1

Line 4502: DBMS_SQL.define_array (c => l_csr,

4498: c_tab => t_detail_attribute28,
4499: cnt => l_max_array_size,
4500: lower_bound => 1
4501: );
4502: DBMS_SQL.define_array (c => l_csr,
4503: POSITION => 48,
4504: c_tab => t_detail_attribute29,
4505: cnt => l_max_array_size,
4506: lower_bound => 1

Line 4508: DBMS_SQL.define_array (c => l_csr,

4504: c_tab => t_detail_attribute29,
4505: cnt => l_max_array_size,
4506: lower_bound => 1
4507: );
4508: DBMS_SQL.define_array (c => l_csr,
4509: POSITION => 49,
4510: c_tab => t_detail_attribute30,
4511: cnt => l_max_array_size,
4512: lower_bound => 1

Line 4514: DBMS_SQL.define_array (c => l_csr,

4510: c_tab => t_detail_attribute30,
4511: cnt => l_max_array_size,
4512: lower_bound => 1
4513: );
4514: DBMS_SQL.define_array (c => l_csr,
4515: POSITION => 50,
4516: d_tab => t_detail_date_from,
4517: cnt => l_max_array_size,
4518: lower_bound => 1

Line 4520: DBMS_SQL.define_array (c => l_csr,

4516: d_tab => t_detail_date_from,
4517: cnt => l_max_array_size,
4518: lower_bound => 1
4519: );
4520: DBMS_SQL.define_array (c => l_csr,
4521: POSITION => 51,
4522: d_tab => t_detail_date_to,
4523: cnt => l_max_array_size,
4524: lower_bound => 1

Line 4526: DBMS_SQL.define_array (c => l_csr,

4522: d_tab => t_detail_date_to,
4523: cnt => l_max_array_size,
4524: lower_bound => 1
4525: );
4526: DBMS_SQL.define_array (c => l_csr,
4527: POSITION => 52,
4528: c_tab => t_detail_approval_status,
4529: cnt => l_max_array_size,
4530: lower_bound => 1

Line 4532: DBMS_SQL.define_array (c => l_csr,

4528: c_tab => t_detail_approval_status,
4529: cnt => l_max_array_size,
4530: lower_bound => 1
4531: );
4532: DBMS_SQL.define_array (c => l_csr,
4533: POSITION => 53,
4534: n_tab => t_detail_approval_style_id,
4535: cnt => l_max_array_size,
4536: lower_bound => 1

Line 4538: DBMS_SQL.define_array (c => l_csr,

4534: n_tab => t_detail_approval_style_id,
4535: cnt => l_max_array_size,
4536: lower_bound => 1
4537: );
4538: DBMS_SQL.define_array (c => l_csr,
4539: POSITION => 54,
4540: c_tab => t_detail_deleted,
4541: cnt => l_max_array_size,
4542: lower_bound => 1

Line 4544: DBMS_SQL.define_array (c => l_csr,

4540: c_tab => t_detail_deleted,
4541: cnt => l_max_array_size,
4542: lower_bound => 1
4543: );
4544: DBMS_SQL.define_array (c => l_csr,
4545: POSITION => 55,
4546: c_tab => t_detail_attribute_category,
4547: cnt => l_max_array_size,
4548: lower_bound => 1

Line 4550: DBMS_SQL.define_array (c => l_csr,

4546: c_tab => t_detail_attribute_category,
4547: cnt => l_max_array_size,
4548: lower_bound => 1
4549: );
4550: DBMS_SQL.define_array (c => l_csr,
4551: POSITION => 56,
4552: n_tab => t_timecard_max_ovn,
4553: cnt => l_max_array_size,
4554: lower_bound => 1

Line 4556: DBMS_SQL.define_array (c => l_csr,

4552: n_tab => t_timecard_max_ovn,
4553: cnt => l_max_array_size,
4554: lower_bound => 1
4555: );
4556: DBMS_SQL.define_array (c => l_csr,
4557: POSITION => 57,
4558: n_tab => t_day_max_ovn,
4559: cnt => l_max_array_size,
4560: lower_bound => 1

Line 4562: DBMS_SQL.define_array (c => l_csr,

4558: n_tab => t_day_max_ovn,
4559: cnt => l_max_array_size,
4560: lower_bound => 1
4561: );
4562: DBMS_SQL.define_array (c => l_csr,
4563: POSITION => 58,
4564: n_tab => t_detail_max_ovn,
4565: cnt => l_max_array_size,
4566: lower_bound => 1

Line 4568: DBMS_SQL.define_array (c => l_csr,

4564: n_tab => t_detail_max_ovn,
4565: cnt => l_max_array_size,
4566: lower_bound => 1
4567: );
4568: DBMS_SQL.define_array (c => l_csr,
4569: POSITION => 59,
4570: c_tab => t_detail_uom,
4571: cnt => l_max_array_size,
4572: lower_bound => 1

Line 4574: DBMS_SQL.define_array (c => l_csr,

4570: c_tab => t_detail_uom,
4571: cnt => l_max_array_size,
4572: lower_bound => 1
4573: );
4574: DBMS_SQL.define_array (c => l_csr,
4575: POSITION => 60,
4576: d_tab => t_timecard_start_time,
4577: cnt => l_max_array_size,
4578: lower_bound => 1

Line 4580: DBMS_SQL.define_array (c => l_csr,

4576: d_tab => t_timecard_start_time,
4577: cnt => l_max_array_size,
4578: lower_bound => 1
4579: );
4580: DBMS_SQL.define_array (c => l_csr,
4581: POSITION => 61,
4582: d_tab => t_timecard_stop_time,
4583: cnt => l_max_array_size,
4584: lower_bound => 1

Line 4586: DBMS_SQL.define_array (c => l_csr,

4582: d_tab => t_timecard_stop_time,
4583: cnt => l_max_array_size,
4584: lower_bound => 1
4585: );
4586: DBMS_SQL.define_array (c => l_csr,
4587: POSITION => 62,
4588: c_tab => t_timecard_comment_text,
4589: cnt => l_max_array_size,
4590: lower_bound => 1

Line 4592: DBMS_SQL.define_array (c => l_csr,

4588: c_tab => t_timecard_comment_text,
4589: cnt => l_max_array_size,
4590: lower_bound => 1
4591: );
4592: DBMS_SQL.define_array (c => l_csr,
4593: POSITION => 63,
4594: c_tab => t_timecard_deleted,
4595: cnt => l_max_array_size,
4596: lower_bound => 1

Line 4604: l_dummy := DBMS_SQL.EXECUTE (l_csr);

4600: THEN
4601: hr_utility.set_location ('Processing ' || l_proc, 50);
4602: END IF;
4603:
4604: l_dummy := DBMS_SQL.EXECUTE (l_csr);
4605:
4606: IF g_debug
4607: THEN
4608: hr_utility.set_location ('Processing ' || l_proc, 60);

Line 4614: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);

4610:
4611: -- loop to ensure we fetch all the rows
4612: WHILE (l_rows_fetched = l_max_array_size)
4613: LOOP
4614: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
4615:
4616: IF (l_rows_fetched = 0 AND t_bb.COUNT = 0)
4617: THEN
4618: DBMS_SQL.close_cursor (l_csr);

Line 4618: DBMS_SQL.close_cursor (l_csr);

4614: l_rows_fetched := DBMS_SQL.fetch_rows (l_csr);
4615:
4616: IF (l_rows_fetched = 0 AND t_bb.COUNT = 0)
4617: THEN
4618: DBMS_SQL.close_cursor (l_csr);
4619: RAISE e_no_timecards;
4620: END IF;
4621:
4622: DBMS_SQL.column_value (c => l_csr,

Line 4622: DBMS_SQL.column_value (c => l_csr,

4618: DBMS_SQL.close_cursor (l_csr);
4619: RAISE e_no_timecards;
4620: END IF;
4621:
4622: DBMS_SQL.column_value (c => l_csr,
4623: POSITION => 1,
4624: n_tab => t_timecard_bb_id
4625: );
4626: DBMS_SQL.column_value (c => l_csr,

Line 4626: DBMS_SQL.column_value (c => l_csr,

4622: DBMS_SQL.column_value (c => l_csr,
4623: POSITION => 1,
4624: n_tab => t_timecard_bb_id
4625: );
4626: DBMS_SQL.column_value (c => l_csr,
4627: POSITION => 2,
4628: n_tab => t_timecard_ovn
4629: );
4630: DBMS_SQL.column_value (c => l_csr,

Line 4630: DBMS_SQL.column_value (c => l_csr,

4626: DBMS_SQL.column_value (c => l_csr,
4627: POSITION => 2,
4628: n_tab => t_timecard_ovn
4629: );
4630: DBMS_SQL.column_value (c => l_csr,
4631: POSITION => 3,
4632: n_tab => t_day_bb_id
4633: );
4634: DBMS_SQL.column_value (c => l_csr, POSITION => 4,

Line 4634: DBMS_SQL.column_value (c => l_csr, POSITION => 4,

4630: DBMS_SQL.column_value (c => l_csr,
4631: POSITION => 3,
4632: n_tab => t_day_bb_id
4633: );
4634: DBMS_SQL.column_value (c => l_csr, POSITION => 4,
4635: n_tab => t_day_ovn);
4636: DBMS_SQL.column_value (c => l_csr,
4637: POSITION => 5,
4638: d_tab => t_day_start_time

Line 4636: DBMS_SQL.column_value (c => l_csr,

4632: n_tab => t_day_bb_id
4633: );
4634: DBMS_SQL.column_value (c => l_csr, POSITION => 4,
4635: n_tab => t_day_ovn);
4636: DBMS_SQL.column_value (c => l_csr,
4637: POSITION => 5,
4638: d_tab => t_day_start_time
4639: );
4640: DBMS_SQL.column_value (c => l_csr,

Line 4640: DBMS_SQL.column_value (c => l_csr,

4636: DBMS_SQL.column_value (c => l_csr,
4637: POSITION => 5,
4638: d_tab => t_day_start_time
4639: );
4640: DBMS_SQL.column_value (c => l_csr,
4641: POSITION => 6,
4642: d_tab => t_day_stop_time
4643: );
4644: DBMS_SQL.column_value (c => l_csr,

Line 4644: DBMS_SQL.column_value (c => l_csr,

4640: DBMS_SQL.column_value (c => l_csr,
4641: POSITION => 6,
4642: d_tab => t_day_stop_time
4643: );
4644: DBMS_SQL.column_value (c => l_csr,
4645: POSITION => 7,
4646: n_tab => t_detail_bb_id
4647: );
4648: DBMS_SQL.column_value (c => l_csr,

Line 4648: DBMS_SQL.column_value (c => l_csr,

4644: DBMS_SQL.column_value (c => l_csr,
4645: POSITION => 7,
4646: n_tab => t_detail_bb_id
4647: );
4648: DBMS_SQL.column_value (c => l_csr,
4649: POSITION => 8,
4650: n_tab => t_detail_ovn
4651: );
4652: DBMS_SQL.column_value (c => l_csr,

Line 4652: DBMS_SQL.column_value (c => l_csr,

4648: DBMS_SQL.column_value (c => l_csr,
4649: POSITION => 8,
4650: n_tab => t_detail_ovn
4651: );
4652: DBMS_SQL.column_value (c => l_csr,
4653: POSITION => 9,
4654: n_tab => t_detail_parent_id
4655: );
4656: DBMS_SQL.column_value (c => l_csr,

Line 4656: DBMS_SQL.column_value (c => l_csr,

4652: DBMS_SQL.column_value (c => l_csr,
4653: POSITION => 9,
4654: n_tab => t_detail_parent_id
4655: );
4656: DBMS_SQL.column_value (c => l_csr,
4657: POSITION => 10,
4658: c_tab => t_detail_resource_type
4659: );
4660: DBMS_SQL.column_value (c => l_csr,

Line 4660: DBMS_SQL.column_value (c => l_csr,

4656: DBMS_SQL.column_value (c => l_csr,
4657: POSITION => 10,
4658: c_tab => t_detail_resource_type
4659: );
4660: DBMS_SQL.column_value (c => l_csr,
4661: POSITION => 11,
4662: n_tab => t_detail_resource_id
4663: );
4664: DBMS_SQL.column_value (c => l_csr,

Line 4664: DBMS_SQL.column_value (c => l_csr,

4660: DBMS_SQL.column_value (c => l_csr,
4661: POSITION => 11,
4662: n_tab => t_detail_resource_id
4663: );
4664: DBMS_SQL.column_value (c => l_csr,
4665: POSITION => 12,
4666: c_tab => t_detail_comment_text
4667: );
4668: DBMS_SQL.column_value (c => l_csr,

Line 4668: DBMS_SQL.column_value (c => l_csr,

4664: DBMS_SQL.column_value (c => l_csr,
4665: POSITION => 12,
4666: c_tab => t_detail_comment_text
4667: );
4668: DBMS_SQL.column_value (c => l_csr,
4669: POSITION => 13,
4670: d_tab => t_detail_start_time
4671: );
4672: DBMS_SQL.column_value (c => l_csr,

Line 4672: DBMS_SQL.column_value (c => l_csr,

4668: DBMS_SQL.column_value (c => l_csr,
4669: POSITION => 13,
4670: d_tab => t_detail_start_time
4671: );
4672: DBMS_SQL.column_value (c => l_csr,
4673: POSITION => 14,
4674: d_tab => t_detail_stop_time
4675: );
4676: DBMS_SQL.column_value (c => l_csr,

Line 4676: DBMS_SQL.column_value (c => l_csr,

4672: DBMS_SQL.column_value (c => l_csr,
4673: POSITION => 14,
4674: d_tab => t_detail_stop_time
4675: );
4676: DBMS_SQL.column_value (c => l_csr,
4677: POSITION => 15,
4678: n_tab => t_detail_measure
4679: );
4680: DBMS_SQL.column_value (c => l_csr,

Line 4680: DBMS_SQL.column_value (c => l_csr,

4676: DBMS_SQL.column_value (c => l_csr,
4677: POSITION => 15,
4678: n_tab => t_detail_measure
4679: );
4680: DBMS_SQL.column_value (c => l_csr,
4681: POSITION => 16,
4682: c_tab => t_detail_scope
4683: );
4684: DBMS_SQL.column_value (c => l_csr,

Line 4684: DBMS_SQL.column_value (c => l_csr,

4680: DBMS_SQL.column_value (c => l_csr,
4681: POSITION => 16,
4682: c_tab => t_detail_scope
4683: );
4684: DBMS_SQL.column_value (c => l_csr,
4685: POSITION => 17,
4686: c_tab => t_detail_type
4687: );
4688: DBMS_SQL.column_value (c => l_csr,

Line 4688: DBMS_SQL.column_value (c => l_csr,

4684: DBMS_SQL.column_value (c => l_csr,
4685: POSITION => 17,
4686: c_tab => t_detail_type
4687: );
4688: DBMS_SQL.column_value (c => l_csr,
4689: POSITION => 18,
4690: n_tab => t_detail_ta_id
4691: );
4692: DBMS_SQL.column_value (c => l_csr,

Line 4692: DBMS_SQL.column_value (c => l_csr,

4688: DBMS_SQL.column_value (c => l_csr,
4689: POSITION => 18,
4690: n_tab => t_detail_ta_id
4691: );
4692: DBMS_SQL.column_value (c => l_csr,
4693: POSITION => 19,
4694: n_tab => t_detail_bld_blk_info_type_id
4695: );
4696: DBMS_SQL.column_value (c => l_csr,

Line 4696: DBMS_SQL.column_value (c => l_csr,

4692: DBMS_SQL.column_value (c => l_csr,
4693: POSITION => 19,
4694: n_tab => t_detail_bld_blk_info_type_id
4695: );
4696: DBMS_SQL.column_value (c => l_csr,
4697: POSITION => 20,
4698: c_tab => t_detail_attribute1
4699: );
4700: DBMS_SQL.column_value (c => l_csr,

Line 4700: DBMS_SQL.column_value (c => l_csr,

4696: DBMS_SQL.column_value (c => l_csr,
4697: POSITION => 20,
4698: c_tab => t_detail_attribute1
4699: );
4700: DBMS_SQL.column_value (c => l_csr,
4701: POSITION => 21,
4702: c_tab => t_detail_attribute2
4703: );
4704: DBMS_SQL.column_value (c => l_csr,

Line 4704: DBMS_SQL.column_value (c => l_csr,

4700: DBMS_SQL.column_value (c => l_csr,
4701: POSITION => 21,
4702: c_tab => t_detail_attribute2
4703: );
4704: DBMS_SQL.column_value (c => l_csr,
4705: POSITION => 22,
4706: c_tab => t_detail_attribute3
4707: );
4708: DBMS_SQL.column_value (c => l_csr,

Line 4708: DBMS_SQL.column_value (c => l_csr,

4704: DBMS_SQL.column_value (c => l_csr,
4705: POSITION => 22,
4706: c_tab => t_detail_attribute3
4707: );
4708: DBMS_SQL.column_value (c => l_csr,
4709: POSITION => 23,
4710: c_tab => t_detail_attribute4
4711: );
4712: DBMS_SQL.column_value (c => l_csr,

Line 4712: DBMS_SQL.column_value (c => l_csr,

4708: DBMS_SQL.column_value (c => l_csr,
4709: POSITION => 23,
4710: c_tab => t_detail_attribute4
4711: );
4712: DBMS_SQL.column_value (c => l_csr,
4713: POSITION => 24,
4714: c_tab => t_detail_attribute5
4715: );
4716: DBMS_SQL.column_value (c => l_csr,

Line 4716: DBMS_SQL.column_value (c => l_csr,

4712: DBMS_SQL.column_value (c => l_csr,
4713: POSITION => 24,
4714: c_tab => t_detail_attribute5
4715: );
4716: DBMS_SQL.column_value (c => l_csr,
4717: POSITION => 25,
4718: c_tab => t_detail_attribute6
4719: );
4720: DBMS_SQL.column_value (c => l_csr,

Line 4720: DBMS_SQL.column_value (c => l_csr,

4716: DBMS_SQL.column_value (c => l_csr,
4717: POSITION => 25,
4718: c_tab => t_detail_attribute6
4719: );
4720: DBMS_SQL.column_value (c => l_csr,
4721: POSITION => 26,
4722: c_tab => t_detail_attribute7
4723: );
4724: DBMS_SQL.column_value (c => l_csr,

Line 4724: DBMS_SQL.column_value (c => l_csr,

4720: DBMS_SQL.column_value (c => l_csr,
4721: POSITION => 26,
4722: c_tab => t_detail_attribute7
4723: );
4724: DBMS_SQL.column_value (c => l_csr,
4725: POSITION => 27,
4726: c_tab => t_detail_attribute8
4727: );
4728: DBMS_SQL.column_value (c => l_csr,

Line 4728: DBMS_SQL.column_value (c => l_csr,

4724: DBMS_SQL.column_value (c => l_csr,
4725: POSITION => 27,
4726: c_tab => t_detail_attribute8
4727: );
4728: DBMS_SQL.column_value (c => l_csr,
4729: POSITION => 28,
4730: c_tab => t_detail_attribute9
4731: );
4732: DBMS_SQL.column_value (c => l_csr,

Line 4732: DBMS_SQL.column_value (c => l_csr,

4728: DBMS_SQL.column_value (c => l_csr,
4729: POSITION => 28,
4730: c_tab => t_detail_attribute9
4731: );
4732: DBMS_SQL.column_value (c => l_csr,
4733: POSITION => 29,
4734: c_tab => t_detail_attribute10
4735: );
4736: DBMS_SQL.column_value (c => l_csr,

Line 4736: DBMS_SQL.column_value (c => l_csr,

4732: DBMS_SQL.column_value (c => l_csr,
4733: POSITION => 29,
4734: c_tab => t_detail_attribute10
4735: );
4736: DBMS_SQL.column_value (c => l_csr,
4737: POSITION => 30,
4738: c_tab => t_detail_attribute11
4739: );
4740: DBMS_SQL.column_value (c => l_csr,

Line 4740: DBMS_SQL.column_value (c => l_csr,

4736: DBMS_SQL.column_value (c => l_csr,
4737: POSITION => 30,
4738: c_tab => t_detail_attribute11
4739: );
4740: DBMS_SQL.column_value (c => l_csr,
4741: POSITION => 31,
4742: c_tab => t_detail_attribute12
4743: );
4744: DBMS_SQL.column_value (c => l_csr,

Line 4744: DBMS_SQL.column_value (c => l_csr,

4740: DBMS_SQL.column_value (c => l_csr,
4741: POSITION => 31,
4742: c_tab => t_detail_attribute12
4743: );
4744: DBMS_SQL.column_value (c => l_csr,
4745: POSITION => 32,
4746: c_tab => t_detail_attribute13
4747: );
4748: DBMS_SQL.column_value (c => l_csr,

Line 4748: DBMS_SQL.column_value (c => l_csr,

4744: DBMS_SQL.column_value (c => l_csr,
4745: POSITION => 32,
4746: c_tab => t_detail_attribute13
4747: );
4748: DBMS_SQL.column_value (c => l_csr,
4749: POSITION => 33,
4750: c_tab => t_detail_attribute14
4751: );
4752: DBMS_SQL.column_value (c => l_csr,

Line 4752: DBMS_SQL.column_value (c => l_csr,

4748: DBMS_SQL.column_value (c => l_csr,
4749: POSITION => 33,
4750: c_tab => t_detail_attribute14
4751: );
4752: DBMS_SQL.column_value (c => l_csr,
4753: POSITION => 34,
4754: c_tab => t_detail_attribute15
4755: );
4756: DBMS_SQL.column_value (c => l_csr,

Line 4756: DBMS_SQL.column_value (c => l_csr,

4752: DBMS_SQL.column_value (c => l_csr,
4753: POSITION => 34,
4754: c_tab => t_detail_attribute15
4755: );
4756: DBMS_SQL.column_value (c => l_csr,
4757: POSITION => 35,
4758: c_tab => t_detail_attribute16
4759: );
4760: DBMS_SQL.column_value (c => l_csr,

Line 4760: DBMS_SQL.column_value (c => l_csr,

4756: DBMS_SQL.column_value (c => l_csr,
4757: POSITION => 35,
4758: c_tab => t_detail_attribute16
4759: );
4760: DBMS_SQL.column_value (c => l_csr,
4761: POSITION => 36,
4762: c_tab => t_detail_attribute17
4763: );
4764: DBMS_SQL.column_value (c => l_csr,

Line 4764: DBMS_SQL.column_value (c => l_csr,

4760: DBMS_SQL.column_value (c => l_csr,
4761: POSITION => 36,
4762: c_tab => t_detail_attribute17
4763: );
4764: DBMS_SQL.column_value (c => l_csr,
4765: POSITION => 37,
4766: c_tab => t_detail_attribute18
4767: );
4768: DBMS_SQL.column_value (c => l_csr,

Line 4768: DBMS_SQL.column_value (c => l_csr,

4764: DBMS_SQL.column_value (c => l_csr,
4765: POSITION => 37,
4766: c_tab => t_detail_attribute18
4767: );
4768: DBMS_SQL.column_value (c => l_csr,
4769: POSITION => 38,
4770: c_tab => t_detail_attribute19
4771: );
4772: DBMS_SQL.column_value (c => l_csr,

Line 4772: DBMS_SQL.column_value (c => l_csr,

4768: DBMS_SQL.column_value (c => l_csr,
4769: POSITION => 38,
4770: c_tab => t_detail_attribute19
4771: );
4772: DBMS_SQL.column_value (c => l_csr,
4773: POSITION => 39,
4774: c_tab => t_detail_attribute20
4775: );
4776: DBMS_SQL.column_value (c => l_csr,

Line 4776: DBMS_SQL.column_value (c => l_csr,

4772: DBMS_SQL.column_value (c => l_csr,
4773: POSITION => 39,
4774: c_tab => t_detail_attribute20
4775: );
4776: DBMS_SQL.column_value (c => l_csr,
4777: POSITION => 40,
4778: c_tab => t_detail_attribute21
4779: );
4780: DBMS_SQL.column_value (c => l_csr,

Line 4780: DBMS_SQL.column_value (c => l_csr,

4776: DBMS_SQL.column_value (c => l_csr,
4777: POSITION => 40,
4778: c_tab => t_detail_attribute21
4779: );
4780: DBMS_SQL.column_value (c => l_csr,
4781: POSITION => 41,
4782: c_tab => t_detail_attribute22
4783: );
4784: DBMS_SQL.column_value (c => l_csr,

Line 4784: DBMS_SQL.column_value (c => l_csr,

4780: DBMS_SQL.column_value (c => l_csr,
4781: POSITION => 41,
4782: c_tab => t_detail_attribute22
4783: );
4784: DBMS_SQL.column_value (c => l_csr,
4785: POSITION => 42,
4786: c_tab => t_detail_attribute23
4787: );
4788: DBMS_SQL.column_value (c => l_csr,

Line 4788: DBMS_SQL.column_value (c => l_csr,

4784: DBMS_SQL.column_value (c => l_csr,
4785: POSITION => 42,
4786: c_tab => t_detail_attribute23
4787: );
4788: DBMS_SQL.column_value (c => l_csr,
4789: POSITION => 43,
4790: c_tab => t_detail_attribute24
4791: );
4792: DBMS_SQL.column_value (c => l_csr,

Line 4792: DBMS_SQL.column_value (c => l_csr,

4788: DBMS_SQL.column_value (c => l_csr,
4789: POSITION => 43,
4790: c_tab => t_detail_attribute24
4791: );
4792: DBMS_SQL.column_value (c => l_csr,
4793: POSITION => 44,
4794: c_tab => t_detail_attribute25
4795: );
4796: DBMS_SQL.column_value (c => l_csr,

Line 4796: DBMS_SQL.column_value (c => l_csr,

4792: DBMS_SQL.column_value (c => l_csr,
4793: POSITION => 44,
4794: c_tab => t_detail_attribute25
4795: );
4796: DBMS_SQL.column_value (c => l_csr,
4797: POSITION => 45,
4798: c_tab => t_detail_attribute26
4799: );
4800: DBMS_SQL.column_value (c => l_csr,

Line 4800: DBMS_SQL.column_value (c => l_csr,

4796: DBMS_SQL.column_value (c => l_csr,
4797: POSITION => 45,
4798: c_tab => t_detail_attribute26
4799: );
4800: DBMS_SQL.column_value (c => l_csr,
4801: POSITION => 46,
4802: c_tab => t_detail_attribute27
4803: );
4804: DBMS_SQL.column_value (c => l_csr,

Line 4804: DBMS_SQL.column_value (c => l_csr,

4800: DBMS_SQL.column_value (c => l_csr,
4801: POSITION => 46,
4802: c_tab => t_detail_attribute27
4803: );
4804: DBMS_SQL.column_value (c => l_csr,
4805: POSITION => 47,
4806: c_tab => t_detail_attribute28
4807: );
4808: DBMS_SQL.column_value (c => l_csr,

Line 4808: DBMS_SQL.column_value (c => l_csr,

4804: DBMS_SQL.column_value (c => l_csr,
4805: POSITION => 47,
4806: c_tab => t_detail_attribute28
4807: );
4808: DBMS_SQL.column_value (c => l_csr,
4809: POSITION => 48,
4810: c_tab => t_detail_attribute29
4811: );
4812: DBMS_SQL.column_value (c => l_csr,

Line 4812: DBMS_SQL.column_value (c => l_csr,

4808: DBMS_SQL.column_value (c => l_csr,
4809: POSITION => 48,
4810: c_tab => t_detail_attribute29
4811: );
4812: DBMS_SQL.column_value (c => l_csr,
4813: POSITION => 49,
4814: c_tab => t_detail_attribute30
4815: );
4816: DBMS_SQL.column_value (c => l_csr,

Line 4816: DBMS_SQL.column_value (c => l_csr,

4812: DBMS_SQL.column_value (c => l_csr,
4813: POSITION => 49,
4814: c_tab => t_detail_attribute30
4815: );
4816: DBMS_SQL.column_value (c => l_csr,
4817: POSITION => 50,
4818: d_tab => t_detail_date_from
4819: );
4820: DBMS_SQL.column_value (c => l_csr,

Line 4820: DBMS_SQL.column_value (c => l_csr,

4816: DBMS_SQL.column_value (c => l_csr,
4817: POSITION => 50,
4818: d_tab => t_detail_date_from
4819: );
4820: DBMS_SQL.column_value (c => l_csr,
4821: POSITION => 51,
4822: d_tab => t_detail_date_to
4823: );
4824: DBMS_SQL.column_value (c => l_csr,

Line 4824: DBMS_SQL.column_value (c => l_csr,

4820: DBMS_SQL.column_value (c => l_csr,
4821: POSITION => 51,
4822: d_tab => t_detail_date_to
4823: );
4824: DBMS_SQL.column_value (c => l_csr,
4825: POSITION => 52,
4826: c_tab => t_detail_approval_status
4827: );
4828: DBMS_SQL.column_value (c => l_csr,

Line 4828: DBMS_SQL.column_value (c => l_csr,

4824: DBMS_SQL.column_value (c => l_csr,
4825: POSITION => 52,
4826: c_tab => t_detail_approval_status
4827: );
4828: DBMS_SQL.column_value (c => l_csr,
4829: POSITION => 53,
4830: n_tab => t_detail_approval_style_id
4831: );
4832: DBMS_SQL.column_value (c => l_csr,

Line 4832: DBMS_SQL.column_value (c => l_csr,

4828: DBMS_SQL.column_value (c => l_csr,
4829: POSITION => 53,
4830: n_tab => t_detail_approval_style_id
4831: );
4832: DBMS_SQL.column_value (c => l_csr,
4833: POSITION => 54,
4834: c_tab => t_detail_deleted
4835: );
4836: DBMS_SQL.column_value (c => l_csr,

Line 4836: DBMS_SQL.column_value (c => l_csr,

4832: DBMS_SQL.column_value (c => l_csr,
4833: POSITION => 54,
4834: c_tab => t_detail_deleted
4835: );
4836: DBMS_SQL.column_value (c => l_csr,
4837: POSITION => 55,
4838: c_tab => t_detail_attribute_category
4839: );
4840: DBMS_SQL.column_value (c => l_csr,

Line 4840: DBMS_SQL.column_value (c => l_csr,

4836: DBMS_SQL.column_value (c => l_csr,
4837: POSITION => 55,
4838: c_tab => t_detail_attribute_category
4839: );
4840: DBMS_SQL.column_value (c => l_csr,
4841: POSITION => 56,
4842: n_tab => t_timecard_max_ovn
4843: );
4844: DBMS_SQL.column_value (c => l_csr,

Line 4844: DBMS_SQL.column_value (c => l_csr,

4840: DBMS_SQL.column_value (c => l_csr,
4841: POSITION => 56,
4842: n_tab => t_timecard_max_ovn
4843: );
4844: DBMS_SQL.column_value (c => l_csr,
4845: POSITION => 57,
4846: n_tab => t_day_max_ovn
4847: );
4848: DBMS_SQL.column_value (c => l_csr,

Line 4848: DBMS_SQL.column_value (c => l_csr,

4844: DBMS_SQL.column_value (c => l_csr,
4845: POSITION => 57,
4846: n_tab => t_day_max_ovn
4847: );
4848: DBMS_SQL.column_value (c => l_csr,
4849: POSITION => 58,
4850: n_tab => t_detail_max_ovn
4851: );
4852: DBMS_SQL.column_value (c => l_csr,

Line 4852: DBMS_SQL.column_value (c => l_csr,

4848: DBMS_SQL.column_value (c => l_csr,
4849: POSITION => 58,
4850: n_tab => t_detail_max_ovn
4851: );
4852: DBMS_SQL.column_value (c => l_csr,
4853: POSITION => 59,
4854: c_tab => t_detail_uom
4855: );
4856: DBMS_SQL.column_value (c => l_csr,

Line 4856: DBMS_SQL.column_value (c => l_csr,

4852: DBMS_SQL.column_value (c => l_csr,
4853: POSITION => 59,
4854: c_tab => t_detail_uom
4855: );
4856: DBMS_SQL.column_value (c => l_csr,
4857: POSITION => 60,
4858: d_tab => t_timecard_start_time
4859: );
4860: DBMS_SQL.column_value (c => l_csr,

Line 4860: DBMS_SQL.column_value (c => l_csr,

4856: DBMS_SQL.column_value (c => l_csr,
4857: POSITION => 60,
4858: d_tab => t_timecard_start_time
4859: );
4860: DBMS_SQL.column_value (c => l_csr,
4861: POSITION => 61,
4862: d_tab => t_timecard_stop_time
4863: );
4864: DBMS_SQL.column_value (c => l_csr,

Line 4864: DBMS_SQL.column_value (c => l_csr,

4860: DBMS_SQL.column_value (c => l_csr,
4861: POSITION => 61,
4862: d_tab => t_timecard_stop_time
4863: );
4864: DBMS_SQL.column_value (c => l_csr,
4865: POSITION => 62,
4866: c_tab => t_timecard_comment_text
4867: );
4868: DBMS_SQL.column_value (c => l_csr,

Line 4868: DBMS_SQL.column_value (c => l_csr,

4864: DBMS_SQL.column_value (c => l_csr,
4865: POSITION => 62,
4866: c_tab => t_timecard_comment_text
4867: );
4868: DBMS_SQL.column_value (c => l_csr,
4869: POSITION => 63,
4870: c_tab => t_timecard_deleted
4871: );
4872: -- to make the data more manageable copy the arrays into PL/SQL tables

Line 4877: DBMS_SQL.close_cursor (l_csr);

4873: -- and save space
4874: populate_query_table;
4875: END LOOP;
4876:
4877: DBMS_SQL.close_cursor (l_csr);
4878:
4879: IF g_debug
4880: THEN
4881: hr_utility.set_location ('Processing ' || l_proc, 110);