1 package PAY_ASSG_COST_WF as
2 /* $Header: pyacoswf.pkh 120.0.12010000.2 2008/11/29 21:26:12 pgongada noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< CHECK_APPROVERS_EXIST >-----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start Of Comments}
7 --
8 -- Description:
9 -- This API creates finds if any approvers exists and populate the out
10 -- parameter accrodingly.
11 --
12 -- Prerequisites:
13 -- The workflow must have started.
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- itemtype Yes varchar2 Itemtype of the workflow process.
18 -- itemkey Yes varchar2 Instance of the workflow process.
19 -- actid Yes Number The ID number of the activity that this
20 -- procedure is called from.
21 -- funmode Yes varchar2 Function mode either CANCEL or RUN.
22 --
23 -- Post Success:
24 -- Assign true/false to out parameter depening upon the approvers exists or not.
25 --
26 -- Out Parameters
27 -- resultout Yes varchar2 Either true/false depending on the approvers
28 -- exists or not.
29 -- Post Failure:
30 -- An exception is raised and nothing will be set to out parameter.
31 --
32 -- Access Status:
33 -- Internal Development Use Only.
34 --
35 -- {End Of Comments}
36 --
37 procedure check_approvers_exist(
38 itemtype in varchar2,
39 itemkey in varchar2,
40 actid in number,
41 funcmode in varchar2,
42 resultout out nocopy varchar2);
43
44 -- -------------------------------------------------------------------------
45 -- |-------------------------< GET_NEXT_APPROVER >-------------------------|
46 -- -------------------------------------------------------------------------
47 -- {Start Of Comments}
48 --
49 -- Description:
50 -- Control comes to this procedure once the previous approver approves the
51 -- notification. This function set the previous approver's approval status
52 -- to true and then get the next approver.
53 --
54 -- Prerequisites:
55 -- The workflow must have started.
56 --
57 -- In Parameters:
58 -- Name Reqd Type Description
59 -- itemtype Yes varchar2 Itemtype of the workflow process.
60 -- itemkey Yes varchar2 Instance of the workflow process.
61 -- actid Yes Number The ID number of the activity that this
62 -- procedure is called from.
63 -- funmode Yes varchar2 Function mode either CANCEL or RUN.
64 --
65 --
66 -- Post Success:
67 -- Find out the next approver and send the same to workflow. If no approvers
68 -- are there then notify the workflow that there are no approvers.
69 --
70 -- Out Parameters
71 -- resultout : Set to 'T' if any approver and 'F' if no approver.
72 -- Post Failure:
73 -- An exception is raised.
74 --
75 -- Access Status:
76 -- Internal Development Use Only.
77 --
78 -- {End Of Comments}
79 --
80 procedure get_next_approver
81 (itemtype in varchar2,
82 itemkey in varchar2,
83 actid in number,
84 funcmode in varchar2,
85 resultout out nocopy varchar2);
86 -- ----------------------------------------------------------------------------
87 -- |----------------------------< START_WF_PROCESS >--------------------------|
88 -- ----------------------------------------------------------------------------
89 -- {Start Of Comments}
90 --
91 -- Description:
92 -- This API initialize the Assignment Costing Workflow process.
93 --
94 -- Prerequisites:
95 -- The workflow must have started.
96 --
97 -- In Parameters:
98 -- Name Reqd Type Description
99 -- p_person_id Yes Number Person ID
100 -- p_assignment_id Yes varchar2 Assignment ID
101 -- p_performer_name Yes Number Performer login name who is
102 -- changing costing details.
103 -- p_performer_display_name Yes varchar2 Disply name of the performer.
104 -- p_effective_date Yed Date Effective Date.
105 -- Post Success:
106 -- Initializes the Assignment Costing workflow process.
107 --
108 -- Out Parameters
109 -- N/A
110 -- Post Failure:
111 -- An exception is raised and no workflow starts.
112 --
113 -- Access Status:
114 -- Internal Development Use Only.
115 --
116 -- {End Of Comments}
117 --
118 procedure START_WF_PROCESS ( p_person_id in number
119 ,p_assignment_id in number
120 ,p_item_key in varchar2
121 ,p_performer_login_name in varchar2
122 ,P_PERFORMER_ID in number
123 ,P_EFFECTIVE_DATE in date
124 );
125 -- ----------------------------------------------------------------------------
126 -- |------------------------------< APPROVE_PROCESS >--------------------------|
127 -- ----------------------------------------------------------------------------
128 -- {Start Of Comments}
129 --
130 -- Description:
131 -- This API delete the transaction, transaction steps
132 -- and transaction values pertaining the item type and item key.
133 --
134 -- Prerequisites:
135 -- The transaction must exist.
136 --
137 -- In Parameters:
138 -- Name Reqd Type Description
139 -- p_item_type Yes varchar2 Identifies Item type
140 -- p_item_key Yes varchar2 Identifies Item key
141 -- p_actid Yes number The ID number of the activity that this procedure is
142 -- called from.
143 -- p_funmode Yes varchar2 The mode of the function activity. Either 'RUN' or 'CANCEL'.
144
145 -- Post Success:
146 -- The data pertaining to item key and item type will be deleted from the
147 -- transaction tables completely.
148 --
149 -- Out Parameters:
150 -- p_result varchar2 Gets 'SUCCESS' if the transaction successfully deleted.
151 -- Post Failure:
152 -- An exception is raised and nothing will be created.
153 --
154 -- Access Status:
155 -- Internal Development Use Only.
156 --
157 -- {End Of Comments}
158 --
159 PROCEDURE APPROVE_PROCESS(
160 itemtype in varchar2
161 ,itemkey in varchar2
162 ,actid in number
163 ,funmode in varchar2
164 ,result out nocopy varchar2);
165 -- ----------------------------------------------------------------------------
166 -- |------------------------------< REJECT_PROCESS >--------------------------|
170 -- Description:
167 -- ----------------------------------------------------------------------------
168 -- {Start Of Comments}
169 --
171 -- This API delete the transaction, transaction steps
172 -- and transaction values pertaining the item type and item key.
173 --
174 -- Prerequisites:
175 -- The transaction must exist.
176 --
177 -- In Parameters:
178 -- Name Reqd Type Description
179 -- p_item_type Yes varchar2 Identifies Item type
180 -- p_item_key Yes varchar2 Identifies Item key
181 -- p_actid Yes number The ID number of the activity that this procedure is
182 -- called from.
183 -- p_funmode Yes varchar2 The mode of the function activity. Either 'RUN' or 'CANCEL'.
184
185 -- Post Success:
186 -- The data pertaining to item key and item type will be deleted from the
187 -- transaction tables completely.
188 --
189 -- Out Parameters:
190 -- p_result varchar2 Gets 'SUCCESS' if the transaction successfully deleted.
191 -- Post Failure:
192 -- An exception is raised and nothing will be created.
193 --
194 -- Access Status:
195 -- Internal Development Use Only.
196 --
197 -- {End Of Comments}
198 --
199 PROCEDURE REJECT_PROCESS(
200 itemtype in varchar2
201 ,itemkey in varchar2
202 ,actid in number
203 ,funmode in varchar2
204 ,result out nocopy varchar2);
205
206 END PAY_ASSG_COST_WF;