1 PACKAGE psp_wf_eff_pkg AUTHID CURRENT_USER AS
2 /* $Header: PSPWFEFS.pls 115.6 2002/11/18 13:31:28 ddubey ship $ */
3
4 /**********************************************************************************
5 **Function INIT_WORKFLOW is called when an effort report is created. It is called**
6 **from package psp_efforts_pkg.crt. This creates the workflow process,populates **
7 **attributes, and starts the process. **
8 ***********************************************************************************/
9 function INIT_WORKFLOW(a_template_id IN NUMBER) return NUMBER;
10
11 /*********************************************************
12 **Procedure OMIT_APPROVAL_STEP checks the value of the **
13 **attribute by the same name in the workflow process and**
14 **sends the result. This procedure is called by the **
15 **workflow activity OMIT_APPROVAL_STEP. **
16 **********************************************************/
17 procedure OMIT_APPROVAL_STEP (itemtype in varchar2,
18 itemkey in varchar2,
19 actid in number,
20 funcmode in varchar2,
21 result out NOCOPY varchar2);
22
23 /**************************************************************
24 **Procedure CAN_EMPLOYEE_APPROVE checks the value of the item**
25 **attribute CAN_EMPLOYEE_APPROVE and sends the result to **
26 **workflow process. This procedure is called by the **
27 **workflow activity "Can Employee Approve". **
28 ***************************************************************/
29 procedure CAN_EMPLOYEE_APPROVE (itemtype in varchar2,
30 itemkey in varchar2,
31 actid in number,
32 funcmode in varchar2,
33 result out NOCOPY varchar2);
34
35 /************************************************************
36 **PROCEDURE CAN_SUPERVISOR_CERTIFY checks if supervisor can**
37 **certify the effort report. If yes, set the certifier's **
38 **display name and username. **
39 *************************************************************/
40 procedure CAN_SUPERVISOR_CERTIFY(itemtype in varchar2,
41 itemkey in varchar2,
42 actid in number,
43 funcmode in varchar2,
44 result out NOCOPY varchar2);
45
46
47 /************************************************************
48 **Procedure VERIFY_EMPLOYEE checks if the employee username**
49 **exists and populates the item attriutes **
50 **APPROVER_USERNAME and APPROVER_DISPLAY_NAME with the **
51 **employee's. username and display name. This procedure is **
52 **called by the workflow activity VERIFY_EMPLOYEE. **
53 *************************************************************/
54 procedure VERIFY_EMPLOYEE(itemtype in varchar2,
55 itemkey in varchar2,
56 actid in number,
57 funcmode in varchar2,
58 result out NOCOPY varchar2);
59
60 /*******************************************************************************
61 *Procedure VERIFY_SUPERVISOR is called by workflow activity VERIFY SUPERVISOR.*
62 *It finds the supervisor for EMPLOYEE and populdate item attributes: *
63 *certifier_username and certifier_display_name. The procedure returns *
64 *COMPLETE:Found if the supervisor is found; returns COMPLETE:Not Found, if *
65 *the supervisor cannot be found. *
66 *******************************************************************************/
67 procedure VERIFY_SUPERVISOR(itemtype in varchar2,
68 itemkey in varchar2,
69 actid in number,
70 funcmode in varchar2,
71 result out NOCOPY varchar2);
72
73 /*****************************************************************
74 **PROCEDURE STATUS_APPROVED updates the status of effort **
75 **report to 'A'. It is called in the workflow activity UPDATE_EF**
76 **FORT_REPORT_STATUS_TO_APPROVED. **
77 ******************************************************************/
78 procedure STATUS_APPROVED(itemtype in varchar2,
79 itemkey in varchar2,
80 actid in number,
81 funcmode in varchar2,
82 result out NOCOPY varchar2);
83
84 /************************************************************
85 **PROCEDURE STATUS_SUPERSEDED updates the status of effort **
86 **report to 'S'. It is called in workflow activity **
87 **UPDATE_EFFORT_REPORT_STATUS_TO_SUPERSEDED. **
88 *************************************************************/
89 procedure STATUS_SUPERSEDED(itemtype in varchar2,
90 itemkey in varchar2,
91 actid in number,
92 funcmode in varchar2,
93 result out NOCOPY varchar2);
94
95 /**********************************************************
96 **PROCEDURE STATUS_CERTIFIED updates the status of effort**
97 **report to 'C'. It is called in workflow activity **
98 **"UPDATE EFFORT REPORT STATUS TO CERTIFIED". **
99 ***********************************************************/
100 procedure STATUS_CERTIFIED(itemtype in varchar2,
101 itemkey in varchar2,
102 actid in number,
103 funcmode in varchar2,
104 result out NOCOPY varchar2);
105
106 /*********************************************************
107 **PROCEDURE STATUS_REJECTED updates the status of effort**
108 **report to 'R'. It is called by a workflow activity **
109 **"Update Effort Report Status to Rejected". **
110 **********************************************************/
111 procedure STATUS_REJECTED (itemtype in varchar2,
112 itemkey in varchar2,
113 actid in number,
114 funcmode in varchar2,
115 result out NOCOPY varchar2);
116
117 /***********************************************************************
118 **Procedure SELECT_CERTIFIER is called by a workflow process "Select **
119 **Certifier". It is invoked if user profile option "PSP:Can Supervisor**
120 **Certify" is set to "No". Procedure SELECT_CERTIFIER makes a call to **
121 **PSP_WF_CUSTOM.SELECT_CERTIFIER, where users can customize who the **
122 **certifer is. **
123 ************************************************************************/
124 procedure SELECT_CERTIFIER(itemtype in varchar2,
125 itemkey in varchar2,
126 actid in number,
127 funcmode in varchar2,
128 result out NOCOPY varchar2);
129
130 /***********************************************************************
131 **Procedure SELECT_APPROVER is called by a workflow process "Select **
132 **Approver". It is invoked if user profile option "PSP:Can Employee **
133 **Approve" is set to "No". Procedure SELECT_APPROVER makes a call to **
134 **PSP_WF_CUSTOM.SELECT_APPROVER, where users can customize who the **
135 **approver is. **
136 ************************************************************************/
137 procedure SELECT_APPROVER(itemtype in varchar2,
138 itemkey in varchar2,
139 actid in number,
140 funcmode in varchar2,
141 result out NOCOPY varchar2);
142
143 /***********************************************************************
144 **Procedure GET_APPROVAL_RESPONDER is called by a workflow process **
145 **"Get Final Approver's Name". **
146 ************************************************************************/
147 procedure GET_APPROVAL_RESPONDER(itemtype in varchar2,
148 itemkey in varchar2,
149 actid in number,
150 funcmode in varchar2,
151 result out NOCOPY varchar2);
152
153 /****************************************************************************
154 **Procedure GET_CERTIFICATION_RESPONDER is called by a workflow process **
155 **"Get Final Certifier's Name". **
156 *****************************************************************************/
157 procedure GET_CERTIFICATION_RESPONDER(itemtype in varchar2,
158 itemkey in varchar2,
159 actid in number,
160 funcmode in varchar2,
161 result out NOCOPY varchar2);
162
163
164 /*********************************************************
165 **Procedure VERIFY_TERM_EMPLOYEEchecks the value of the **
166 **current_employee_flag of a person to determine whether**
167 **the person is terminated or not **
168 **For Enhancement Zero Work Days -skotwal **
169 **********************************************************/
170 procedure VERIFY_TERM_EMPLOYEE(itemtype in varchar2,
171 itemkey in varchar2,
172 actid in number,
173 funcmode in varchar2,
174 result out NOCOPY varchar2);
175
176
177
178 END psp_wf_eff_pkg;
179