1 package hxc_approval_report_pkg AUTHID CURRENT_USER as
2 /* $Header: hxcaprrp.pkh 115.4 2002/06/10 00:36:12 pkm ship $ */
3 -- get_employee_name
4 --
5 -- procedure
6 -- Brings back the employee name for a given person id
7 -- description
8 --
9 -- parameters
10 -- p_person_id - person Id
11 --
12 function get_employee_name(
13 p_person_id in varchar2
14 ) return varchar2;
15
16
17
18 -- get_last_aprv
19 --
20 -- procedure
21 -- Brings back the last approver for a given Approval timecard ID and OVN
22 -- parameters
23 -- p_timecard_id - Application Period Building Block Id
24 -- p_timecard_ovn - Application Period Building Block Ovn
25 --
26
27
28 function get_last_aprv(
29 p_timecard_id in number,
30 p_timecard_ovn in number)
31 return varchar2;
32
33
34 -- get_project_name
35 --
36 -- procedure
37 -- Brings back the project name for a given project number
38 -- description
39 --
40 -- parameters
41 -- p_project_number - project number
42 --
43
44 function get_project_name(
45 p_project_number in varchar2
46 ) return varchar2 ;
47
48 -- get_task_name
49 --
50 -- procedure
51 -- Brings back the task name for a given task number
52 -- description
53 --
54 -- parameters
55 -- p_task_number - Task number
56 --
57 function get_task_name(
58 p_task_number in varchar2
59 ) return varchar2 ;
60
61 -- get_element_name
62 --
63 -- procedure
64 -- Brings back the element name for a given element type id
65 --
66 -- parameters
67 -- p_element_type_id - element type id
68 --
69 -- returns
70 -- varchar2 - element name
71
72 function get_element_name(
73 p_element_type_id varchar2) return varchar2;
74
75 -- get_application_name
76 --
77 -- procedure
78 -- Brings back the application name for a given time recipient id
79 --
80 -- parameters
81 -- p_time_recipient_id - Time Recipient Id
82 --
83 -- returns
84 -- varchar2 - application Name
85
86
87 function get_application_name(
88 p_time_recipient_id varchar2) return varchar2;
89
90 -- get_supervisor_name
91 --
92 -- procedure
93 -- Brings back the supervior for a given person
94 --
95 -- parameters
96 -- p_person_id - person id
97 --
98 -- returns
99 -- varchar2 - supervisor full name
100
101
102 function get_supervisor_name(
103 p_person_id in number
104 ) return varchar2;
105
106 -- get_organization_name
107 --
108 -- procedure
109 -- Brings back the organization name for a given person
110 --
111 -- parameters
112 -- p_person_id - person id
113 --
114 -- returns
115 -- varchar2 - organization name
116
117 function get_organization_name(
118 p_person_id in number
119 ) return varchar2;
120
121 -- get_cost_center
122 --
123 -- procedure
124 -- Brings back the cost center for a given person
125 --
126 -- parameters
127 -- p_person_id - person id
128 --
129 -- returns
130 -- varchar2 - cost center
131
132 function get_cost_center(
133 p_person_id in number
134 ) return varchar2;
135
136 -- get_cost_center
137 --
138 -- procedure
139 -- Brings back the payroll for a given person
140 --
141 -- parameters
142 -- p_person_id - person id
143 --
144 -- returns
145 -- varchar2 - payroll_name
146
147 function get_payroll_name(
148 p_person_id in number
149 ) return varchar2;
150
151 -- get_business_group
152 --
153 -- procedure
154 -- Brings back the business group name for a given person
155 --
156 -- parameters
157 -- p_person_id - person id
158 --
159 -- returns
160 -- varchar2 - business_group_name
161
162 function get_business_group_name(
163 p_person_id in number
164 ) return varchar2;
165
166 end hxc_approval_report_pkg;
167