DBA Data[Home] [Help]

APPS.PQP_ALIEN_EXPAT_WF_PKG dependencies on WF_ENGINE

Line 159: wf_engine.createProcess( ItemType => p_ItemType,

155: end if;
156:
157: -- Creates a new runtime process for the WF Item Type passed)
158: --
159: wf_engine.createProcess( ItemType => p_ItemType,
160: ItemKey => l_item_key,
161: process => p_process_name );
162: --
163: --

Line 164: wf_engine.SetItemAttrDate ( itemtype => p_itemtype,

160: ItemKey => l_item_key,
161: process => p_process_name );
162: --
163: --
164: wf_engine.SetItemAttrDate ( itemtype => p_itemtype,
165: itemkey => l_item_key,
166: aname => 'ERR_DATE',
167: avalue => p_tran_date );
168: --

Line 169: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

165: itemkey => l_item_key,
166: aname => 'ERR_DATE',
167: avalue => p_tran_date );
168: --
169: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
170: itemkey => l_item_key,
171: aname => 'TRAN_TYPE',
172: avalue => p_tran_type );
173: --

Line 174: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

170: itemkey => l_item_key,
171: aname => 'TRAN_TYPE',
172: avalue => p_tran_type );
173: --
174: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
175: itemkey => l_item_key,
176: aname => 'CURRENT_ASSIGNMENT_ID',
177: avalue => l_assignment_id );
178: --

Line 180: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

176: aname => 'CURRENT_ASSIGNMENT_ID',
177: avalue => l_assignment_id );
178: --
179: if p_tran_type = 'READ' then
180: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
181: itemkey => l_item_key,
182: aname => 'PROCESS_EVENT_ID',
183: avalue => p_process_event_id );
184: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

Line 184: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

180: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
181: itemkey => l_item_key,
182: aname => 'PROCESS_EVENT_ID',
183: avalue => p_process_event_id );
184: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
185: itemkey => l_item_key,
186: aname => 'ERR_MSG',
187: avalue => l_description );
188: else

Line 189: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,

185: itemkey => l_item_key,
186: aname => 'ERR_MSG',
187: avalue => l_description );
188: else
189: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,
190: itemkey => l_item_key,
191: aname => 'ERROR_INDICATOR',
192: avalue => l_error_indicator );
193: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,

Line 193: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,

189: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,
190: itemkey => l_item_key,
191: aname => 'ERROR_INDICATOR',
192: avalue => l_error_indicator );
193: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,
194: itemkey => l_item_key,
195: aname => 'ERROR_TEXT',
196: avalue => l_error_text );
197: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

Line 197: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

193: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,
194: itemkey => l_item_key,
195: aname => 'ERROR_TEXT',
196: avalue => l_error_text );
197: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
198: itemkey => l_item_key,
199: aname => 'ALIEN_TRANSACTION_ID',
200: avalue => p_alien_transaction_id );
201:

Line 202: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,

198: itemkey => l_item_key,
199: aname => 'ALIEN_TRANSACTION_ID',
200: avalue => p_alien_transaction_id );
201:
202: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,
203: itemkey => l_item_key,
204: aname => 'INCOME_CODE',
205: avalue => l_income_code ||' ('||
206: l_income_desc||')' );

Line 209: wf_engine.SetItemAttrText(

205: avalue => l_income_code ||' ('||
206: l_income_desc||')' );
207: --
208: if l_error_indicator = 'WARNING : RETRO LOSS' then
209: wf_engine.SetItemAttrText(
210: itemtype=> p_itemtype,
211: itemkey => l_item_key,
212: aname => 'IS_RETRO',
213: avalue => 'Y' );

Line 216: wf_engine.SetItemAttrText(

212: aname => 'IS_RETRO',
213: avalue => 'Y' );
214: --
215: elsif l_error_indicator = 'WARNING : CHANGED INCOME CODE' then
216: wf_engine.SetItemAttrText(
217: itemtype=> p_itemtype,
218: itemkey => l_item_key,
219: aname => 'INCOME_CODE_CHANGED',
220: avalue => 'Y' );

Line 222: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,

218: itemkey => l_item_key,
219: aname => 'INCOME_CODE_CHANGED',
220: avalue => 'Y' );
221:
222: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,
223: itemkey => l_item_key,
224: aname => 'ERROR_TEXT',
225: avalue => ' is the analyzed employment income code.'||
226: ' Please attach this earnings element for ');

Line 229: wf_engine.SetItemAttrText(

225: avalue => ' is the analyzed employment income code.'||
226: ' Please attach this earnings element for ');
227:
228: elsif l_error_indicator = 'WARNING : INVALID INCOME CODE' then
229: wf_engine.SetItemAttrText(
230: itemtype=> p_itemtype,
231: itemkey => l_item_key,
232: aname => 'INCOME_CODE_CHANGED',
233: avalue => 'Y' );

Line 235: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,

231: itemkey => l_item_key,
232: aname => 'INCOME_CODE_CHANGED',
233: avalue => 'Y' );
234:
235: wf_engine.SetItemAttrText ( itemtype=> p_itemtype,
236: itemkey => l_item_key,
237: aname => 'ERROR_TEXT',
238: avalue => ' is no longer a valid employment income'||
239: ' code for ');

Line 260: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,

256: p_display_name => l_emp_disp_name );
257: end if;
258: --
259: --
260: wf_engine.SetItemAttrNumber ( itemtype => p_itemtype,
261: itemkey => l_item_key,
262: aname => 'PERSON_ID',
263: avalue => l_person_id );
264: --

Line 274: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

270: close csr_getperdet;
271: l_emp_disp_name := l_emp_full_name;
272: end if;
273: --
274: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
275: itemkey => l_item_key,
276: aname => 'EMP_USERNAME',
277: avalue => l_emp_username );
278: --

Line 279: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

275: itemkey => l_item_key,
276: aname => 'EMP_USERNAME',
277: avalue => l_emp_username );
278: --
279: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
280: itemkey => l_item_key,
281: aname => 'PERSON_DISPLAY_NAME',
282: avalue => l_emp_disp_name );
283:

Line 287: wf_engine.SetItemAttrText ( itemtype => p_itemtype,

283:
284: --
285: -- Set HR/ Payroll Contact User Name for Notification
286: --
287: wf_engine.SetItemAttrText ( itemtype => p_itemtype,
288: itemkey => l_item_key,
289: aname => 'CONTACT_USERNAME',
290: avalue => l_contact_user_name );
291: --

Line 293: wf_engine.StartProcess ( ItemType => p_itemtype,

289: aname => 'CONTACT_USERNAME',
290: avalue => l_contact_user_name );
291: --
292: --
293: wf_engine.StartProcess ( ItemType => p_itemtype,
294: ItemKey => l_item_key );
295: --
296: --
297: end StartAlienExpatWFProcess;

Line 312: if Upper(wf_engine.GetItemAttrText

308: begin
309: --
310: --
311: if funcmode = 'RUN' then
312: if Upper(wf_engine.GetItemAttrText
313: (itemtype => itemtype,
314: itemkey => itemkey ,
315: aname => 'REQ_NTF'
316: )) = 'Y' then

Line 357: if wf_engine.GetItemAttrText

353: begin
354: --
355: --
356: if funcmode = 'RUN' then
357: if wf_engine.GetItemAttrText
358: (itemtype => itemtype,
359: itemkey => itemkey ,
360: aname => 'CONTACT_USERNAME'
361: ) Is Null then

Line 362: wf_engine.SetItemAttrText (

358: (itemtype => itemtype,
359: itemkey => itemkey ,
360: aname => 'CONTACT_USERNAME'
361: ) Is Null then
362: wf_engine.SetItemAttrText (
363: itemtype => itemtype,
364: itemkey => itemkey,
365: aname => 'CONTACT_USERNAME',
366: avalue => 'SYSADMIN' );

Line 404: if wf_engine.GetItemAttrText

400: begin
401: --
402: --
403: if funcmode = 'RUN' then
404: if wf_engine.GetItemAttrText
405: (itemtype => itemtype,
406: itemkey => itemkey ,
407: aname => 'TRAN_TYPE'
408: ) = 'READ' then

Line 453: (p_process_event_id => wf_engine.GetItemAttrNumber

449: if funcmode = 'RUN' then
450: -- Call Reset Read API
451: -- Get Process Event ID
452: pqp_alien_expat_taxation_pkg.ResetForReadAPI
453: (p_process_event_id => wf_engine.GetItemAttrNumber
454: (itemtype => itemtype,
455: itemkey => itemkey ,
456: aname => 'PROCESS_EVENT_ID'
457: )

Line 499: (p_process_event_id => wf_engine.GetItemAttrNumber

495: if funcmode = 'RUN' then
496: -- Call Abort Read API
497: --
498: pqp_alien_expat_taxation_pkg.AbortReadAPI
499: (p_process_event_id => wf_engine.GetItemAttrNumber
500: (itemtype => itemtype,
501: itemkey => itemkey ,
502: aname => 'PROCESS_EVENT_ID'
503: )

Line 539: if Upper(wf_engine.GetItemAttrText

535: begin
536: --
537: --
538: if funcmode = 'RUN' then
539: if Upper(wf_engine.GetItemAttrText
540: (itemtype => itemtype,
541: itemkey => itemkey ,
542: aname => 'IS_RETRO'
543: )) = 'Y' then

Line 582: if Upper(wf_engine.GetItemAttrText(

578: --
579: begin
580: --
581: if funcmode = 'RUN' then
582: if Upper(wf_engine.GetItemAttrText(
583: itemtype => itemtype,
584: itemkey => itemkey ,
585: aname => 'INCOME_CODE_CHANGED')) = 'Y' then
586: result := 'COMPLETE:Y';