APPS.HXC_TIME_APPROVAL_INFO dependencies on HXC_TIMECARD_SUMMARY

Line 10: (timecard_id hxc_timecard_summary.timecard_id%type,

6: c_pa constant varchar2(8) := 'Projects';
7: c_po constant varchar2(10) := 'Purchasing';
8:
9: type timecard_info is record
10: (timecard_id hxc_timecard_summary.timecard_id%type,
11: approval_status hxc_timecard_summary.approval_status%type,
12: approval_date hxc_timecard_summary.submission_date%type,
13: recorded_hours hxc_timecard_summary.recorded_hours%type,
14: audit_data_exists hxc_timecard_summary.has_reasons%type,

Line 11: approval_status hxc_timecard_summary.approval_status%type,

7: c_po constant varchar2(10) := 'Purchasing';
8:
9: type timecard_info is record
10: (timecard_id hxc_timecard_summary.timecard_id%type,
11: approval_status hxc_timecard_summary.approval_status%type,
12: approval_date hxc_timecard_summary.submission_date%type,
13: recorded_hours hxc_timecard_summary.recorded_hours%type,
14: audit_data_exists hxc_timecard_summary.has_reasons%type,
15: submission_date hxc_timecard_summary.submission_date%type

Line 12: approval_date hxc_timecard_summary.submission_date%type,

8:
9: type timecard_info is record
10: (timecard_id hxc_timecard_summary.timecard_id%type,
11: approval_status hxc_timecard_summary.approval_status%type,
12: approval_date hxc_timecard_summary.submission_date%type,
13: recorded_hours hxc_timecard_summary.recorded_hours%type,
14: audit_data_exists hxc_timecard_summary.has_reasons%type,
15: submission_date hxc_timecard_summary.submission_date%type
16: );

Line 13: recorded_hours hxc_timecard_summary.recorded_hours%type,

9: type timecard_info is record
10: (timecard_id hxc_timecard_summary.timecard_id%type,
11: approval_status hxc_timecard_summary.approval_status%type,
12: approval_date hxc_timecard_summary.submission_date%type,
13: recorded_hours hxc_timecard_summary.recorded_hours%type,
14: audit_data_exists hxc_timecard_summary.has_reasons%type,
15: submission_date hxc_timecard_summary.submission_date%type
16: );
17:

Line 14: audit_data_exists hxc_timecard_summary.has_reasons%type,

10: (timecard_id hxc_timecard_summary.timecard_id%type,
11: approval_status hxc_timecard_summary.approval_status%type,
12: approval_date hxc_timecard_summary.submission_date%type,
13: recorded_hours hxc_timecard_summary.recorded_hours%type,
14: audit_data_exists hxc_timecard_summary.has_reasons%type,
15: submission_date hxc_timecard_summary.submission_date%type
16: );
17:
18: type application_info is record

Line 15: submission_date hxc_timecard_summary.submission_date%type

11: approval_status hxc_timecard_summary.approval_status%type,
12: approval_date hxc_timecard_summary.submission_date%type,
13: recorded_hours hxc_timecard_summary.recorded_hours%type,
14: audit_data_exists hxc_timecard_summary.has_reasons%type,
15: submission_date hxc_timecard_summary.submission_date%type
16: );
17:
18: type application_info is record
19: (time_recipient_id hxc_app_period_summary.time_recipient_id%type,

Line 30: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

26: type application_info_table is table of application_info
27: index by binary_integer;
28:
29: function get_timecard_approval_status
30: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
31: return hxc_timecard_summary.approval_status%type;
32:
33: function get_timecard_approval_status
34: (p_resource_id in hxc_timecard_summary.resource_id%type,

Line 31: return hxc_timecard_summary.approval_status%type;

27: index by binary_integer;
28:
29: function get_timecard_approval_status
30: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
31: return hxc_timecard_summary.approval_status%type;
32:
33: function get_timecard_approval_status
34: (p_resource_id in hxc_timecard_summary.resource_id%type,
35: p_start_time in hxc_timecard_summary.start_time%type,

Line 34: (p_resource_id in hxc_timecard_summary.resource_id%type,

30: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
31: return hxc_timecard_summary.approval_status%type;
32:
33: function get_timecard_approval_status
34: (p_resource_id in hxc_timecard_summary.resource_id%type,
35: p_start_time in hxc_timecard_summary.start_time%type,
36: p_stop_time in hxc_timecard_summary.stop_time%type)
37: return hxc_timecard_summary.approval_status%type;
38:

Line 35: p_start_time in hxc_timecard_summary.start_time%type,

31: return hxc_timecard_summary.approval_status%type;
32:
33: function get_timecard_approval_status
34: (p_resource_id in hxc_timecard_summary.resource_id%type,
35: p_start_time in hxc_timecard_summary.start_time%type,
36: p_stop_time in hxc_timecard_summary.stop_time%type)
37: return hxc_timecard_summary.approval_status%type;
38:
39: function get_timecard_approval_date

Line 36: p_stop_time in hxc_timecard_summary.stop_time%type)

32:
33: function get_timecard_approval_status
34: (p_resource_id in hxc_timecard_summary.resource_id%type,
35: p_start_time in hxc_timecard_summary.start_time%type,
36: p_stop_time in hxc_timecard_summary.stop_time%type)
37: return hxc_timecard_summary.approval_status%type;
38:
39: function get_timecard_approval_date
40: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

Line 37: return hxc_timecard_summary.approval_status%type;

33: function get_timecard_approval_status
34: (p_resource_id in hxc_timecard_summary.resource_id%type,
35: p_start_time in hxc_timecard_summary.start_time%type,
36: p_stop_time in hxc_timecard_summary.stop_time%type)
37: return hxc_timecard_summary.approval_status%type;
38:
39: function get_timecard_approval_date
40: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
41: return hxc_timecard_summary.submission_date%type;

Line 40: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

36: p_stop_time in hxc_timecard_summary.stop_time%type)
37: return hxc_timecard_summary.approval_status%type;
38:
39: function get_timecard_approval_date
40: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
41: return hxc_timecard_summary.submission_date%type;
42:
43: function get_timecard_approval_date
44: (p_resource_id in hxc_timecard_summary.resource_id%type,

Line 41: return hxc_timecard_summary.submission_date%type;

37: return hxc_timecard_summary.approval_status%type;
38:
39: function get_timecard_approval_date
40: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
41: return hxc_timecard_summary.submission_date%type;
42:
43: function get_timecard_approval_date
44: (p_resource_id in hxc_timecard_summary.resource_id%type,
45: p_start_time in hxc_timecard_summary.start_time%type,

Line 44: (p_resource_id in hxc_timecard_summary.resource_id%type,

40: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
41: return hxc_timecard_summary.submission_date%type;
42:
43: function get_timecard_approval_date
44: (p_resource_id in hxc_timecard_summary.resource_id%type,
45: p_start_time in hxc_timecard_summary.start_time%type,
46: p_stop_time in hxc_timecard_summary.stop_time%type)
47: return hxc_timecard_summary.submission_date%type;
48:

Line 45: p_start_time in hxc_timecard_summary.start_time%type,

41: return hxc_timecard_summary.submission_date%type;
42:
43: function get_timecard_approval_date
44: (p_resource_id in hxc_timecard_summary.resource_id%type,
45: p_start_time in hxc_timecard_summary.start_time%type,
46: p_stop_time in hxc_timecard_summary.stop_time%type)
47: return hxc_timecard_summary.submission_date%type;
48:
49: function get_timecard_recorded_hours

Line 46: p_stop_time in hxc_timecard_summary.stop_time%type)

42:
43: function get_timecard_approval_date
44: (p_resource_id in hxc_timecard_summary.resource_id%type,
45: p_start_time in hxc_timecard_summary.start_time%type,
46: p_stop_time in hxc_timecard_summary.stop_time%type)
47: return hxc_timecard_summary.submission_date%type;
48:
49: function get_timecard_recorded_hours
50: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

Line 47: return hxc_timecard_summary.submission_date%type;

43: function get_timecard_approval_date
44: (p_resource_id in hxc_timecard_summary.resource_id%type,
45: p_start_time in hxc_timecard_summary.start_time%type,
46: p_stop_time in hxc_timecard_summary.stop_time%type)
47: return hxc_timecard_summary.submission_date%type;
48:
49: function get_timecard_recorded_hours
50: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
51: return hxc_timecard_summary.recorded_hours%type;

Line 50: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

46: p_stop_time in hxc_timecard_summary.stop_time%type)
47: return hxc_timecard_summary.submission_date%type;
48:
49: function get_timecard_recorded_hours
50: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
51: return hxc_timecard_summary.recorded_hours%type;
52:
53: function get_timecard_recorded_hours
54: (p_resource_id in hxc_timecard_summary.resource_id%type,

Line 51: return hxc_timecard_summary.recorded_hours%type;

47: return hxc_timecard_summary.submission_date%type;
48:
49: function get_timecard_recorded_hours
50: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
51: return hxc_timecard_summary.recorded_hours%type;
52:
53: function get_timecard_recorded_hours
54: (p_resource_id in hxc_timecard_summary.resource_id%type,
55: p_start_time in hxc_timecard_summary.start_time%type,

Line 54: (p_resource_id in hxc_timecard_summary.resource_id%type,

50: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
51: return hxc_timecard_summary.recorded_hours%type;
52:
53: function get_timecard_recorded_hours
54: (p_resource_id in hxc_timecard_summary.resource_id%type,
55: p_start_time in hxc_timecard_summary.start_time%type,
56: p_stop_time in hxc_timecard_summary.stop_time%type)
57: return hxc_timecard_summary.recorded_hours%type;
58:

Line 55: p_start_time in hxc_timecard_summary.start_time%type,

51: return hxc_timecard_summary.recorded_hours%type;
52:
53: function get_timecard_recorded_hours
54: (p_resource_id in hxc_timecard_summary.resource_id%type,
55: p_start_time in hxc_timecard_summary.start_time%type,
56: p_stop_time in hxc_timecard_summary.stop_time%type)
57: return hxc_timecard_summary.recorded_hours%type;
58:
59: function get_timecard_audit_data_exists

Line 56: p_stop_time in hxc_timecard_summary.stop_time%type)

52:
53: function get_timecard_recorded_hours
54: (p_resource_id in hxc_timecard_summary.resource_id%type,
55: p_start_time in hxc_timecard_summary.start_time%type,
56: p_stop_time in hxc_timecard_summary.stop_time%type)
57: return hxc_timecard_summary.recorded_hours%type;
58:
59: function get_timecard_audit_data_exists
60: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

Line 57: return hxc_timecard_summary.recorded_hours%type;

53: function get_timecard_recorded_hours
54: (p_resource_id in hxc_timecard_summary.resource_id%type,
55: p_start_time in hxc_timecard_summary.start_time%type,
56: p_stop_time in hxc_timecard_summary.stop_time%type)
57: return hxc_timecard_summary.recorded_hours%type;
58:
59: function get_timecard_audit_data_exists
60: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
61: return hxc_timecard_summary.has_reasons%type;

Line 60: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

56: p_stop_time in hxc_timecard_summary.stop_time%type)
57: return hxc_timecard_summary.recorded_hours%type;
58:
59: function get_timecard_audit_data_exists
60: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
61: return hxc_timecard_summary.has_reasons%type;
62:
63: function get_timecard_audit_data_exists
64: (p_resource_id in hxc_timecard_summary.resource_id%type,

Line 61: return hxc_timecard_summary.has_reasons%type;

57: return hxc_timecard_summary.recorded_hours%type;
58:
59: function get_timecard_audit_data_exists
60: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
61: return hxc_timecard_summary.has_reasons%type;
62:
63: function get_timecard_audit_data_exists
64: (p_resource_id in hxc_timecard_summary.resource_id%type,
65: p_start_time in hxc_timecard_summary.start_time%type,

Line 64: (p_resource_id in hxc_timecard_summary.resource_id%type,

60: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
61: return hxc_timecard_summary.has_reasons%type;
62:
63: function get_timecard_audit_data_exists
64: (p_resource_id in hxc_timecard_summary.resource_id%type,
65: p_start_time in hxc_timecard_summary.start_time%type,
66: p_stop_time in hxc_timecard_summary.stop_time%type)
67: return hxc_timecard_summary.has_reasons%type;
68:

Line 65: p_start_time in hxc_timecard_summary.start_time%type,

61: return hxc_timecard_summary.has_reasons%type;
62:
63: function get_timecard_audit_data_exists
64: (p_resource_id in hxc_timecard_summary.resource_id%type,
65: p_start_time in hxc_timecard_summary.start_time%type,
66: p_stop_time in hxc_timecard_summary.stop_time%type)
67: return hxc_timecard_summary.has_reasons%type;
68:
69: function get_timecard_submission_date

Line 66: p_stop_time in hxc_timecard_summary.stop_time%type)

62:
63: function get_timecard_audit_data_exists
64: (p_resource_id in hxc_timecard_summary.resource_id%type,
65: p_start_time in hxc_timecard_summary.start_time%type,
66: p_stop_time in hxc_timecard_summary.stop_time%type)
67: return hxc_timecard_summary.has_reasons%type;
68:
69: function get_timecard_submission_date
70: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

Line 67: return hxc_timecard_summary.has_reasons%type;

63: function get_timecard_audit_data_exists
64: (p_resource_id in hxc_timecard_summary.resource_id%type,
65: p_start_time in hxc_timecard_summary.start_time%type,
66: p_stop_time in hxc_timecard_summary.stop_time%type)
67: return hxc_timecard_summary.has_reasons%type;
68:
69: function get_timecard_submission_date
70: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
71: return hxc_timecard_summary.submission_date%type;

Line 70: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

66: p_stop_time in hxc_timecard_summary.stop_time%type)
67: return hxc_timecard_summary.has_reasons%type;
68:
69: function get_timecard_submission_date
70: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
71: return hxc_timecard_summary.submission_date%type;
72:
73: function get_timecard_submission_date
74: (p_resource_id in hxc_timecard_summary.resource_id%type,

Line 71: return hxc_timecard_summary.submission_date%type;

67: return hxc_timecard_summary.has_reasons%type;
68:
69: function get_timecard_submission_date
70: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
71: return hxc_timecard_summary.submission_date%type;
72:
73: function get_timecard_submission_date
74: (p_resource_id in hxc_timecard_summary.resource_id%type,
75: p_start_time in hxc_timecard_summary.start_time%type,

Line 74: (p_resource_id in hxc_timecard_summary.resource_id%type,

70: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
71: return hxc_timecard_summary.submission_date%type;
72:
73: function get_timecard_submission_date
74: (p_resource_id in hxc_timecard_summary.resource_id%type,
75: p_start_time in hxc_timecard_summary.start_time%type,
76: p_stop_time in hxc_timecard_summary.stop_time%type)
77: return hxc_timecard_summary.submission_date%type;
78:

Line 75: p_start_time in hxc_timecard_summary.start_time%type,

71: return hxc_timecard_summary.submission_date%type;
72:
73: function get_timecard_submission_date
74: (p_resource_id in hxc_timecard_summary.resource_id%type,
75: p_start_time in hxc_timecard_summary.start_time%type,
76: p_stop_time in hxc_timecard_summary.stop_time%type)
77: return hxc_timecard_summary.submission_date%type;
78:
79: function get_app_approval_status

Line 76: p_stop_time in hxc_timecard_summary.stop_time%type)

72:
73: function get_timecard_submission_date
74: (p_resource_id in hxc_timecard_summary.resource_id%type,
75: p_start_time in hxc_timecard_summary.start_time%type,
76: p_stop_time in hxc_timecard_summary.stop_time%type)
77: return hxc_timecard_summary.submission_date%type;
78:
79: function get_app_approval_status
80: (p_application_period_id in hxc_app_period_summary.application_period_id%type)

Line 77: return hxc_timecard_summary.submission_date%type;

73: function get_timecard_submission_date
74: (p_resource_id in hxc_timecard_summary.resource_id%type,
75: p_start_time in hxc_timecard_summary.start_time%type,
76: p_stop_time in hxc_timecard_summary.stop_time%type)
77: return hxc_timecard_summary.submission_date%type;
78:
79: function get_app_approval_status
80: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
81: return hxc_app_period_summary.approval_status%type;