[Home] [Help]
PACKAGE: APPS.HR_EMPL_VERF_UTIL
Source
1 PACKAGE HR_EMPL_VERF_UTIL AUTHID CURRENT_USER AS
2 /* $Header: hrevutil.pkh 120.1 2005/06/07 23:48:58 svittal noship $*/
3
4
5 FUNCTION CHECK_TICKET_STRING
6 ( p_ticket IN VARCHAR2,
7 p_operation OUT NOCOPY VARCHAR2,
8 p_argument OUT NOCOPY VARCHAR2)
9 RETURN NUMBER;
10
11 /*
12 PROCEDURE send_mail(to_address IN VARCHAR2, from_address IN VARCHAR2,
13 mail_content VARCHAR2);
14 */
15
16
17 PROCEDURE send_notification (to_address IN VARCHAR2,from_address IN VARCHAR2,
18 reply_to_address IN VARCHAR2, access_url VARCHAR2, access_days number,
19 emp_name IN VARCHAR2, access_limit NUMBER, personal_key VARCHAR2,
20 comments VARCHAR2);
21
22
23 FUNCTION CHECK_ONETIME_TICKET_STRING
24 ( p_ticket IN VARCHAR2,
25 p_operation OUT NOCOPY VARCHAR2,
26 p_argument OUT NOCOPY VARCHAR2) RETURN NUMBER;
27
28 PROCEDURE get_employee_salary
29 (p_assignment_id In Per_All_Assignments_F.ASSIGNMENT_ID%TYPE,
30 p_effective_Date In Date,
31 p_salary OUT nocopy number,
32 p_frequency OUT nocopy varchar2,
33 p_annual_salary OUT nocopy number,
34 p_pay_basis OUT nocopy varchar2,
35 p_reason_cd OUT nocopy varchar2,
36 p_currency OUT nocopy varchar2,
37 p_status OUT nocopy number,
38 p_currency_name OUT nocopy varchar2,
39 p_pay_basis_frequency OUT nocopy varchar2
40 );
41
42 FUNCTION UPDATE_TICKET_STRING(P_TICKET in varchar2,
43 P_OPERATION in varchar2,
44 P_ARGUMENT in varchar2)
45 return number;
46
47
48 END HR_EMPL_VERF_UTIL; -- Package spec
49