1 PACKAGE PO_REQAPPROVAL_FINDAPPRV1 AUTHID CURRENT_USER AS
2 /* $Header: POXWPA3S.pls 115.3 2002/11/22 22:11:28 sbull ship $ */
3
4 /*=======================================================================+
5 | FILENAME
6 | POXWPAS3.sql
7 |
8 | DESCRIPTION
9 | PL/SQL spec for package: PO_REQAPPROVAL_FINDAPPRV1
10 |
11 | NOTES
12 | MODIFIED Ben Chihaoui (06/15/97)
13 *=====================================================================*/
14
15
16 /*
17 -- Record variable ReqHdr_rec
18 -- Public record variable used to hold the Requisition_header columns
19
20 TYPE ReqHdrRecord IS RECORD(
21 REQUISITION_HEADER_ID NUMBER,
22
23 ReqHdr_rec ReqHdrRecord;
24
25 -- Record variable ReqLine_rec
26 -- Public record variable used to hold the Requisition_line columns.
27
28 TYPE ReqLineRecord IS RECORD(
29 REQUESTOR_FULL_NAME VARCHAR2(240));
30
31 ReqLine_rec ReqLineRecord;
32
33 -- Cursor GetRecHdr_csr
34 -- Public cursor used to get the Requisition_header columns.
35
36 CURSOR GetRecHdr_csr(p_requisition_header_id NUMBER) RETURN ReqHdrRecord;
37
38 -- Cursor GetRecLines_csr
39 -- Public cursor used to get the Requisition Lines columns.
40
41 CURSOR GetRecLines_csr(p_requisition_header_id NUMBER) RETURN ReqLineRecord;
42
43 */
44
45 -- Set_Forward_To_From_App_fwd
46 -- Reset the Forward-to and forward-from
47 --
48 -- IN
49 -- itemtype -- itemkey -- actid -- funcmode
50 -- OUT
51 -- Resultout
52 -- - None
53 --
54 procedure Set_Forward_To_From_App_fwd( itemtype in varchar2,
55 itemkey in varchar2,
56 actid in number,
57 funcmode in varchar2,
58 resultout out NOCOPY varchar2 );
59 --
60
61 -- Set_Forward_To_From_App_fwd
62 -- Reset the Forward-to and forward-from
63 --
64 -- IN
65 -- itemtype -- itemkey -- actid -- funcmode
66 -- OUT
67 -- Resultout
68 -- - None
69 --
70 procedure Set_Fwd_To_From_App_timeout( itemtype in varchar2,
71 itemkey in varchar2,
72 actid in number,
73 funcmode in varchar2,
74 resultout out NOCOPY varchar2 );
75 --
76
77 -- Is_Forward_To_Valid
78 -- Is Forward-To userame entered in the Forward-To field in response to the
79 -- the approval notification, a valid username. If not resend the
80 -- notification back to the user.
81 --
82 -- IN
83 -- itemtype -- itemkey -- actid -- funcmode
84 -- OUT
85 -- Resultout
86 -- - Y/N
87 --
88 procedure Is_Forward_To_Valid( itemtype in varchar2,
89 itemkey in varchar2,
90 actid in number,
91 funcmode in varchar2,
92 resultout out NOCOPY varchar2 );
93 --
94
95
96 -- Is_forward_to_provided
97 -- Did the submitter or the approver provide a forward to username.
98 --
99 -- IN
100 -- itemtype -- itemkey -- actid -- funcmode
101 -- OUT
102 -- Resultout
103 -- - Y/N Performed - Activity was completed without any errors.
104 --
105 procedure Is_forward_to_provided( itemtype in varchar2,
106 itemkey in varchar2,
107 actid in number,
108 funcmode in varchar2,
109 resultout out NOCOPY varchar2 );
110
111
112 -- Is_Forward_To_User_Name_Valid
113 -- Is the user_name valid for the next approver?
114 --
115 -- IN
116 -- itemtype -- itemkey -- actid -- funcmode
117 -- OUT
118 -- Resultout
119 -- - Y/N
120 procedure Is_Forward_To_User_Name_Valid(itemtype in varchar2,
121 itemkey in varchar2,
122 actid in number,
123 funcmode in varchar2,
124 resultout out NOCOPY varchar2 );
125
126
127 --
128 -- Get_approval_path_id
129 -- If the submitter of the document did not provide a specific hierarchy, the
130 -- Get the default Approval Hierarchy from the setup.
131 -- IN
132 -- itemtype -- itemkey -- actid -- funcmode
133 -- OUT
134 -- Resultout
135 -- - Activity Performed - Activity was completed without any errors.
136 --
137 procedure Get_approval_path_id( itemtype in varchar2,
138 itemkey in varchar2,
139 actid in number,
140 funcmode in varchar2,
141 resultout out NOCOPY varchar2 );
142
143 -- Get_Forward_mode
144 -- Is the forwarding mode DIRECT or HIERARCHY
145 -- IN
146 -- itemtype -- itemkey -- actid -- funcmode
147 -- OUT
148 -- Resultout
149 -- - Activity Performed - Activity was completed without any errors.
150 --
151 procedure Get_Forward_mode( itemtype in varchar2,
152 itemkey in varchar2,
153 actid in number,
154 funcmode in varchar2,
155 resultout out NOCOPY varchar2 );
156
157 --
158 -- Use_Position_flag
159 -- Determine if customer is using Positions in approvals.
160 --
161 -- IN
162 -- itemtype -- itemkey -- actid -- funcmode
163 -- OUT
164 -- Resultout
165 -- - Activity Performed - Activity was completed without any errors.
166 --
167 procedure Use_Position_flag( itemtype in varchar2,
168 itemkey in varchar2,
169 actid in number,
170 funcmode in varchar2,
171 resultout out NOCOPY varchar2 );
172
173 --
174 -- GetMgr_hr_hier
175 -- Get the manager of the current employee in the HR hierarchy
176 -- IN
177 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
178 -- itemkey - A string generated from the application object's primary key.
179 -- actid - The notification process activity(instance id).
180 -- funcmode - Run/Cancel
181 -- OUT
182 -- Resultout
183 -- Y - Found a manager for this employee in the HR Hierarchy
184 -- N - Did not Find a manager for this employee in the HR Hierarchy
185 --
186 procedure GetMgr_hr_hier( itemtype in varchar2,
187 itemkey in varchar2,
188 actid in number,
189 funcmode in varchar2,
190 resultout out NOCOPY varchar2 );
191 --
192
193 -- GetMgr_po_hier
194 -- Get the manager of the current employee in the HR hierarchy
195 -- IN
196 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
197 -- itemkey - A string generated from the application object's primary key.
198 -- actid - The notification process activity(instance id).
199 -- funcmode - Run/Cancel
200 -- OUT
201 -- Resultout
202 -- Y - Found a manager for this employee in the PO Hierarchy
203 -- N - Did not Find a manager for this employee in the PO Hierarchy
204 --
205 procedure GetMgr_po_hier( itemtype in varchar2,
206 itemkey in varchar2,
207 actid in number,
208 funcmode in varchar2,
209 resultout out NOCOPY varchar2 );
210 --
211 --
212 FUNCTION CheckForwardTo( p_username varchar2, x_user_id IN OUT NOCOPY number) RETURN VARCHAR2;
213
214
215 end PO_REQAPPROVAL_FINDAPPRV1;