[Home] [Help]
PACKAGE: APPS.PO_WF_PO_CHARGE_ACC
Source
1 PACKAGE PO_WF_PO_CHARGE_ACC AUTHID CURRENT_USER AS
2 /* $Header: POXWPCAS.pls 120.4 2008/07/17 07:14:51 mugoel ship $ */
3
4 /*=======================================================================+
5 | FILENAME
6 | POXWPCAS.pls
7 |
8 | DESCRIPTION
9 | PL/SQL spec for package: PO_WF_PO_CHARGE_ACC
10 |
11 | NOTES
12 | MODIFIED IMRAN ALI (09/02/97) - Created
13 *=====================================================================*/
14
15 --
16 -- Check Destination Type
17 -- Use work item attribute to determine this ( destination_type_code ).
18 -- IN
19 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
20 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
21 -- funcmode - Run/Cancel
22 -- OUT
23 -- Result
24 -- EXPENSE
25 -- INVENTORY
26 -- SHOP_FLOOR
27
28 procedure check_destination_type ( itemtype in varchar2,
29 itemkey in varchar2,
30 actid in number,
31 funcmode in varchar2,
32 result out NOCOPY varchar2 );
33
34 --
35
36 --
37 -- Inventory
38 -- Build inventory charge account.
39 -- IN
40 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
41 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
42 -- funcmode - Run/Cancel
43 -- OUT
44 -- Result
45 -- FAILURE - Account generation failed
46 -- SUCCESS - Account generation successful
47 --
48 procedure inventory ( itemtype in varchar2,
49 itemkey in varchar2,
50 actid in number,
51 funcmode in varchar2,
52 result out NOCOPY varchar2 );
53 --
54
55 --
56 -- Expense
57 -- Build expense charge account.
58 -- IN
59 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
60 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
61 -- funcmode - Run/Cancel
62 -- OUT
63 -- Result
64 -- FAILURE - Account generation failed
65 -- SUCCESS - Account generation successful
66 --
67 procedure expense ( itemtype in varchar2,
68 itemkey in varchar2,
69 actid in number,
70 funcmode in varchar2,
71 result out NOCOPY varchar2 );
72
73 --
74
75 --
76 -- Check type of WIP
77 -- Check WIP type
78 -- IN
79 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
80 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
81 -- funcmode - Run/Cancel
82 -- OUT
83 -- Result
84 -- JOB_WIP
85 -- SCHEDULE
86 --
87 procedure check_type_of_wip ( itemtype in varchar2,
88 itemkey in varchar2,
89 actid in number,
90 funcmode in varchar2,
91 result out NOCOPY varchar2 );
92 --
93
94 --
95 -- JOB_WIP
96 -- Check WIP type
97 -- IN
98 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
99 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
100 -- funcmode - Run/Cancel
101 -- OUT
102 -- Result
103 -- FAILURE - Account generation failed
104 -- SUCCESS - Account generation successful
105 --
106 procedure job_wip ( itemtype in varchar2,
107 itemkey in varchar2,
108 actid in number,
109 funcmode in varchar2,
110 result out NOCOPY varchar2 );
111 --
112
113 --
114 -- Schedule
115 -- Build Schedule charge account (Shop Floor)
116 -- IN
117 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
118 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
119 -- funcmode - Run/Cancel
120 -- OUT
121 -- Result
122 -- FAILURE - Account generation failed
123 -- SUCCESS - Account generation successful
124 --
125 procedure schedule ( itemtype in varchar2,
126 itemkey in varchar2,
127 actid in number,
128 funcmode in varchar2,
129 result out NOCOPY varchar2 );
130
131 --
132
133 --
134 -- IS_PO_PROJECT_RELATED
135 --
136 -- IN
137 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
138 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
139 -- actid - ID no. of activity this process is called from.
140 -- funcmode - Run/Cancel
141 -- OUT
142 -- Result
143 -- TRUE
144 -- FALSE
145 --
146 procedure is_po_project_related ( itemtype in varchar2,
147 itemkey in varchar2,
148 actid in number,
149 funcmode in varchar2,
150 result out NOCOPY varchar2 );
151 --
152
153 --
154 -- IS_ENCUMBRACE_ON
155 --
156 -- IN
157 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
158 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
159 -- actid - ID no. of activity this process is called from.
160 -- funcmode - Run/Cancel
161 -- OUT
162 -- Result
163 -- YES
164 -- NO
165 --
166 procedure is_encumbrance_on ( itemtype in varchar2,
167 itemkey in varchar2,
168 actid in number,
169 funcmode in varchar2,
170 result out NOCOPY varchar2 );
171 --
172
173 PROCEDURE debug_on;
174 PROCEDURE debug_off;
175
176 --< Shared Proc FPJ Start >
177
178 PROCEDURE is_dest_accounts_flow_type
179 (
180 itemtype IN VARCHAR2,
181 itemkey IN VARCHAR2,
182 actid IN NUMBER,
183 funcmode IN VARCHAR2,
184 result OUT NOCOPY VARCHAR2
185 );
186
187 PROCEDURE is_SPS_distribution
188 (
189 itemtype IN VARCHAR2,
190 itemkey IN VARCHAR2,
191 actid IN NUMBER,
192 funcmode IN VARCHAR2,
193 result OUT NOCOPY VARCHAR2
194 );
195
196 PROCEDURE get_SPS_charge_account
197 (
198 itemtype IN VARCHAR2,
199 itemkey IN VARCHAR2,
200 actid IN NUMBER,
201 funcmode IN VARCHAR2,
202 result OUT NOCOPY VARCHAR2
203 );
204
205 PROCEDURE is_dest_charge_acc_null
206 (
207 itemtype IN VARCHAR2,
208 itemkey IN VARCHAR2,
209 actid IN NUMBER,
210 funcmode IN VARCHAR2,
211 result OUT NOCOPY VARCHAR2
212 );
213
214 PROCEDURE are_COAs_same
215 (
216 itemtype IN VARCHAR2,
217 itemkey IN VARCHAR2,
218 actid IN NUMBER,
219 funcmode IN VARCHAR2,
220 result OUT NOCOPY VARCHAR2
221 );
222
223 --< Shared Proc FPJ End >
224
225 --Bug4033391 Start
226 PROCEDURE set_null_resp_id
227 (
228 itemtype IN VARCHAR2,
229 itemkey IN VARCHAR2,
230 actid IN NUMBER,
231 funcmode IN VARCHAR2,
232 result OUT NOCOPY VARCHAR2
233 );
234 PROCEDURE reset_resp_id
235 (
236 itemtype IN VARCHAR2,
237 itemkey IN VARCHAR2,
238 actid IN NUMBER,
239 funcmode IN VARCHAR2,
240 result OUT NOCOPY VARCHAR2
241 );
242 --Bug4033391 End
243
244 -- Bug 7260456: Added new proc to validate combination
245 PROCEDURE validate_combination(
246 itemtype IN VARCHAR2,
247 itemkey IN VARCHAR2,
248 actid IN NUMBER,
249 funcmode IN VARCHAR2,
250 result OUT NOCOPY VARCHAR2);
251
252 END PO_WF_PO_CHARGE_ACC; -- )