1 PACKAGE HR_CAED_SS AUTHID CURRENT_USER as
2 /* $Header: hrcaedw.pkh 115.7 2002/12/04 15:25:19 hjonnala noship $*/
3
4 PROCEDURE Create_transaction(
5 p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE ,
6 p_item_key IN WF_ITEMS.ITEM_KEY%TYPE ,
7 p_act_id IN NUMBER ,
8 p_transaction_id IN OUT NOCOPY NUMBER ,
9 p_transaction_step_id IN OUT NOCOPY NUMBER,
10 p_login_person_id IN NUMBER ) ;
11
12 Procedure process_api (
13 p_transaction_step_id IN
14 hr_api_transaction_steps.transaction_step_id%type,
15 p_validate BOOLEAN default FALSE ) ;
16
17 PROCEDURE write_transaction (
18 p_transaction_step_id NUMBER ,
19 p_login_person_id NUMBER ,
20 p_emp_person_id NUMBER ,
21 p_action VARCHAR2 ,
22 p_granted_emp_name VARCHAR2 DEFAULT NULL ,
23 p_granted_emp_id NUMBER DEFAULT NULL ,
24 p_granted_user_id NUMBER DEFAULT NULL ,
25 p_deleted_emp_name VARCHAR2 DEFAULT NULL,
26 p_deleted_emp_id NUMBER DEFAULT NULL,
27 p_deleted_emp_user_id NUMBER DEFAULT NULL ,
28 p_review_proc_call varchar2 DEFAULT NULL) ;
29
30 PROCEDURE get_transaction_step(
31 p_transaction_id in NUMBER ,
32 p_item_type in varchar2,
33 p_item_key in varchar2,
34 p_transaction_step_id out nocopy NUMBER ) ;
35
36 PROCEDURE grant_access (
37 p_validate in number default 1
38 ,p_item_type in varchar2
39 ,p_item_key in varchar2
40 ,p_actid in number
41 ,p_emp_person_id in number
42 ,p_login_person_id in number
43 ,p_action_type in varchar2
44 ,p_granted_emp_name in varchar2 default null
45 ,p_granted_emp_id in number default null
46 ,p_granted_user_id in number default null
47 ,p_review_proc_call in varchar2 default null
48 ,p_transaction_id out nocopy number
49 ,p_transaction_step_id out nocopy number);
50
51
52 PROCEDURE revoke_access (
53 p_validate in number default 1
54 ,p_item_type in varchar2
55 ,p_item_key in varchar2
56 ,p_actid in number
57 ,p_emp_person_id in number
58 ,p_login_person_id in number
59 ,p_action_type in varchar2
60 ,p_granted_user_id in number
61 ,p_deleted_emp_name in varchar2 default null
62 ,p_deleted_emp_id in number default null
63 ,p_deleted_emp_user_id in number default null
64 ,p_review_proc_call in varchar2 default null
65 ,p_transaction_id out nocopy number
66 ,p_transaction_step_id out nocopy number);
67
68
69 END hr_caed_ss;