[Home] [Help]
PACKAGE: APPS.HXC_TIME_APPROVAL_INFO
Source
1 Package hxc_time_approval_info AUTHID CURRENT_USER AS
2 /* $Header: hxctcapinfo.pkh 115.2 2004/07/05 02:36:37 dragarwa noship $ */
3
4 c_pay constant varchar2(7) := 'Payroll';
5 c_per constant varchar2(15) := 'Human Resources';
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,
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,
20 approval_status hxc_app_period_summary.approval_status%type,
21 creation_date hxc_app_period_summary.creation_date%type,
22 notification_status hxc_app_period_summary.notification_status%type,
23 approver varchar2(360)
24 );
25
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,
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;
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)
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
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
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,
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;
82
83 function get_app_approval_status
84 (p_resource_id in hxc_app_period_summary.resource_id%type,
85 p_start_time in hxc_app_period_summary.start_time%type,
86 p_stop_time in hxc_app_period_summary.stop_time%type,
87 p_application_name in hxc_time_recipients.name%type
88 )
89 return hxc_app_period_summary.approval_status%type;
90
91 function get_app_approval_status
92 (p_resource_id in hxc_app_period_summary.resource_id%type,
93 p_start_time in hxc_app_period_summary.start_time%type,
94 p_stop_time in hxc_app_period_summary.stop_time%type,
95 p_application_name in hxc_time_recipients.name%type,
96 p_time_category_name in hxc_time_categories.time_category_name%type
97 )
98 return hxc_app_period_summary.approval_status%type;
99
100 function get_app_creation_date
101 (p_application_period_id in hxc_app_period_summary.application_period_id%type)
102 return hxc_app_period_summary.creation_date%type;
103
104 function get_app_creation_date
105 (p_resource_id in hxc_app_period_summary.resource_id%type,
106 p_start_time in hxc_app_period_summary.start_time%type,
107 p_stop_time in hxc_app_period_summary.stop_time%type,
108 p_application_name in hxc_time_recipients.name%type
109 )
110 return hxc_app_period_summary.creation_date%type;
111
112 function get_app_creation_date
113 (p_resource_id in hxc_app_period_summary.resource_id%type,
114 p_start_time in hxc_app_period_summary.start_time%type,
115 p_stop_time in hxc_app_period_summary.stop_time%type,
116 p_application_name in hxc_time_recipients.name%type,
117 p_time_category_name in hxc_time_categories.time_category_name%type
118 )
119 return hxc_app_period_summary.creation_date%type;
120
121 function get_app_approver
122 (p_application_period_id in hxc_app_period_summary.application_period_id%type)
123 return varchar2;
124
125 function get_app_approver
126 (p_resource_id in hxc_app_period_summary.resource_id%type,
127 p_start_time in hxc_app_period_summary.start_time%type,
128 p_stop_time in hxc_app_period_summary.stop_time%type,
129 p_application_name in hxc_time_recipients.name%type
130 )
131 return varchar2;
132
133 function get_app_approver
134 (p_resource_id in hxc_app_period_summary.resource_id%type,
135 p_start_time in hxc_app_period_summary.start_time%type,
136 p_stop_time in hxc_app_period_summary.stop_time%type,
137 p_application_name in hxc_time_recipients.name%type,
138 p_time_category_name in hxc_time_categories.time_category_name%type
139 )
140 return varchar2;
141
142 END hxc_time_approval_info;