1 PACKAGE hr_appraisal_workflow_ss AUTHID CURRENT_USER AS
2 /* $Header: hrapwfss.pkh 120.2 2012/02/08 13:54:38 schowdhu ship $ */
3
4
5 procedure create_hr_transaction
6 ( p_itemtype in varchar2
7 , p_itemkey in varchar2
8 , p_actid in number
9 , p_funcmode in varchar2
10 , p_result in out nocopy varchar2
11 );
12 procedure reset_main_appraiser
13 ( p_itemtype in varchar2
14 , p_itemkey in varchar2
15 , p_actid in number
16 , p_funcmode in varchar2
17 , p_result in out nocopy varchar2
18 );
19 procedure commit_transaction
20 ( p_itemtype in varchar2
21 , p_itemkey in varchar2
22 , p_actid in number
23 , p_funcmode in varchar2
24 , p_result in out nocopy varchar2
25 );
26 procedure Notify(itemtype in varchar2,
27 itemkey in varchar2,
28 actid in number,
29 funcmode in varchar2,
30 resultout in out nocopy varchar2);
31 procedure notify_appraisee_or_appraiser(itemtype in varchar2,
32 itemkey in varchar2,
33 actid in number,
34 funcmode in varchar2,
35 resultout in out nocopy varchar2);
36 procedure reset_appr_ntf_status(itemtype in varchar2,
37 itemkey in varchar2,
38 actid in number,
39 funcmode in varchar2,
40 resultout in out nocopy varchar2);
41 procedure block(itemtype in varchar2,
42 itemkey in varchar2,
43 actid in number,
44 funcmode in varchar2,
45 resultout in out nocopy varchar2);
46 procedure find_next_participant(itemtype in varchar2,
47 itemkey in varchar2,
48 actid in number,
49 funcmode in varchar2,
50 resultout in out nocopy varchar2);
51 procedure branch_on_participant_type(itemtype in varchar2,
52 itemkey in varchar2,
53 actid in number,
54 funcmode in varchar2,
55 resultout in out nocopy varchar2);
56
57 procedure start_transaction
58 (itemtype in varchar2
59 ,itemkey in varchar2
60 ,actid in number
61 ,funmode in varchar2
62 ,result in out nocopy varchar2);
63
64 procedure participants_block
65 (itemtype in varchar2
66 ,itemkey in varchar2
67 ,actid in number
68 ,funmode in varchar2
69 ,result in out nocopy varchar2);
70 procedure appraisee_or_appraiser_block
71 (itemtype in varchar2
72 ,itemkey in varchar2
73 ,actid in number
74 ,funmode in varchar2
75 ,result in out nocopy varchar2);
76 procedure approvals_block
77 (itemtype in varchar2
78 ,itemkey in varchar2
79 ,actid in number
80 ,funmode in varchar2
81 ,result in out nocopy varchar2);
82
83 procedure build_link(document_id IN Varchar2,
84 display_type IN Varchar2,
85 document IN OUT NOCOPY varchar2,
86 document_type IN OUT NOCOPY Varchar2);
87 procedure getApprovalBlockId (p_itemType in VARCHAR2
88 ,p_itemKey in VARCHAR2
89 ,p_blockId OUT NOCOPY NUMBER);
90 PROCEDURE set_appraisal_rfc_status
91 ( p_itemtype in varchar2
92 , p_itemkey in varchar2
93 , p_actid in number
94 , p_funcmode in varchar2
95 , p_result in out nocopy varchar2
96 );
97 PROCEDURE set_appraisal_reject_status
98 ( p_itemtype in varchar2
99 , p_itemkey in varchar2
100 , p_actid in number
101 , p_funcmode in varchar2
102 , p_result in out nocopy varchar2
103 );
104 PROCEDURE notify_appraisee_on_completion
105 ( p_itemtype in varchar2
106 , p_itemkey in varchar2
107 , p_actid in number
108 , p_funcmode in varchar2
109 , p_result in out nocopy varchar2
110 );
111 procedure build_ma_compl_log_msg(document_id IN Varchar2,
112 display_type IN Varchar2,
113 document IN OUT NOCOPY varchar2,
114 document_type IN OUT NOCOPY Varchar2);
115
116 PROCEDURE appraisee_feedback_allowed
117 ( p_itemtype in varchar2
118 , p_itemkey in varchar2
119 , p_actid in number
120 , p_funcmode in varchar2
121 , p_result in out nocopy varchar2
122 );
123
124 PROCEDURE appraisee_commit_aft_feedback
125 ( p_itemtype in varchar2
126 , p_itemkey in varchar2
127 , p_actid in number
128 , p_funcmode in varchar2
129 , p_result in out nocopy varchar2
130 );
131
132 PROCEDURE notify_appraisee
133 ( p_itemtype in varchar2
134 , p_itemkey in varchar2
135 , p_actid in number
136 , p_funcmode in varchar2
137 , p_result in out nocopy varchar2
138 );
139
140 FUNCTION isAppraiser
141 (
142 p_notification_id in wf_notifications.item_key%type,
143 p_loggedin_person_id in number
144 ) RETURN varchar2;
145
146 PROCEDURE send_emp_ntf_on_rejection (
147 p_itemtype IN VARCHAR2,
148 p_itemkey IN VARCHAR2,
149 p_actid IN NUMBER,
150 p_funcmode IN VARCHAR2,
151 p_result OUT NOCOPY VARCHAR2
152 );
153
154 end hr_appraisal_workflow_ss; -- Package spec
155
156