DBA Data[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