DBA Data[Home] [Help]

APPS.PAY_US_TAX_WF dependencies on WF_ENGINE

Line 88: wf_engine.createProcess(itemtype => gv_itemtype

84: hr_utility.set_location('Entering: ' || l_proc,5);
85:
86: lv_itemkey := to_char(p_transaction_id);
87:
88: wf_engine.createProcess(itemtype => gv_itemtype
89: ,itemkey => lv_itemkey
90: ,process => p_process
91: );
92:

Line 93: wf_engine.SetItemAttrNumber(itemtype => gv_itemtype

89: ,itemkey => lv_itemkey
90: ,process => p_process
91: );
92:
93: wf_engine.SetItemAttrNumber(itemtype => gv_itemtype
94: ,itemkey => lv_itemkey
95: ,aname => 'TRANSACTION_ID'
96: ,avalue => p_transaction_id
97: );

Line 99: wf_engine.startProcess(itemtype => gv_itemtype

95: ,aname => 'TRANSACTION_ID'
96: ,avalue => p_transaction_id
97: );
98:
99: wf_engine.startProcess(itemtype => gv_itemtype
100: ,itemkey => lv_itemkey
101: );
102:
103: hr_utility.set_location('Leaving: ' || l_proc,20);

Line 165: ln_transaction_id := wf_engine.GetItemAttrNumber(

161: hr_utility.set_location('Entering: ' || l_proc,5);
162:
163: if funcmode = 'RUN' then
164: -- get the transaction
165: ln_transaction_id := wf_engine.GetItemAttrNumber(
166: itemtype => itemtype
167: ,itemkey => itemkey
168: ,aname => 'TRANSACTION_ID'
169: );

Line 181: wf_engine.SetItemAttrText(itemtype => itemtype

177: p_orig_system_id => r_trans_rec.person_id,
178: p_name => lv_username,
179: p_display_name => lv_disp_name );
180:
181: wf_engine.SetItemAttrText(itemtype => itemtype
182: ,itemkey => itemkey
183: ,aname => 'EMPLOYEE_USERNAME'
184: ,avalue => lv_username
185: );

Line 187: wf_engine.SetItemAttrNumber(itemtype => itemtype

183: ,aname => 'EMPLOYEE_USERNAME'
184: ,avalue => lv_username
185: );
186:
187: wf_engine.SetItemAttrNumber(itemtype => itemtype
188: ,itemkey => itemkey
189: ,aname => 'EMPLOYEE_PERSON_ID'
190: ,avalue => r_trans_rec.person_id);
191:

Line 192: wf_engine.SetItemAttrText(itemtype => itemtype

188: ,itemkey => itemkey
189: ,aname => 'EMPLOYEE_PERSON_ID'
190: ,avalue => r_trans_rec.person_id);
191:
192: wf_engine.SetItemAttrText(itemtype => itemtype
193: ,itemkey => itemkey
194: ,aname => 'EMPLOYEE_DISPLAY_NAME'
195: ,avalue => lv_disp_name
196: );

Line 198: wf_engine.SetItemAttrNumber(itemtype => itemtype

194: ,aname => 'EMPLOYEE_DISPLAY_NAME'
195: ,avalue => lv_disp_name
196: );
197:
198: wf_engine.SetItemAttrNumber(itemtype => itemtype
199: ,itemkey => itemkey
200: ,aname => 'CURRENT_ASSIGNMENT_ID'
201: ,avalue => 0
202: );

Line 204: wf_engine.SetItemAttrText(itemtype => itemtype

200: ,aname => 'CURRENT_ASSIGNMENT_ID'
201: ,avalue => 0
202: );
203:
204: wf_engine.SetItemAttrText(itemtype => itemtype
205: ,itemkey => itemkey
206: ,aname => 'TRANSACTION_SOURCE'
207: ,avalue => r_trans_rec.source3
208: );

Line 210: wf_engine.SetItemAttrDate(itemtype => itemtype

206: ,aname => 'TRANSACTION_SOURCE'
207: ,avalue => r_trans_rec.source3
208: );
209:
210: wf_engine.SetItemAttrDate(itemtype => itemtype
211: ,itemkey => itemkey
212: ,aname => 'TRANSACTION_DATE'
213: ,avalue => r_trans_rec.transaction_date
214: );

Line 229: wf_engine.SetItemAttrText(

225: lv_status := lv_status_code;
226: end if;
227: close c_fed_filing_status_code;
228:
229: wf_engine.SetItemAttrText(
230: itemtype => itemtype
231: ,itemkey => itemkey
232: ,aname => 'FILING_STATUS_LABEL'
233: ,avalue => lv_status

Line 236: wf_engine.SetItemAttrText(

232: ,aname => 'FILING_STATUS_LABEL'
233: ,avalue => lv_status
234: );
235:
236: wf_engine.SetItemAttrText(
237: itemtype => itemtype
238: ,itemkey => itemkey
239: ,aname => 'ALLOWANCES'
240: ,avalue => r_trans_rec.audit_information2

Line 243: wf_engine.SetItemAttrText(

239: ,aname => 'ALLOWANCES'
240: ,avalue => r_trans_rec.audit_information2
241: );
242:
243: wf_engine.SetItemAttrText(
244: itemtype => itemtype
245: ,itemkey => itemkey
246: ,aname => 'ADDITIONAL_TAX'
247: ,avalue => r_trans_rec.audit_information3

Line 250: wf_engine.SetItemAttrText(

246: ,aname => 'ADDITIONAL_TAX'
247: ,avalue => r_trans_rec.audit_information3
248: );
249:
250: wf_engine.SetItemAttrText(
251: itemtype => itemtype
252: ,itemkey => itemkey
253: ,aname => 'FIT_EXEMPT'
254: ,avalue => r_trans_rec.audit_information4

Line 269: wf_engine.SetItemAttrText(itemtype => itemtype

265: fetch c_state_list into lv_state_name;
266: end loop;
267:
268: -- put the state list details in
269: wf_engine.SetItemAttrText(itemtype => itemtype
270: ,itemkey => itemkey
271: ,aname => 'STATE_LIST'
272: ,avalue => lv_state_list
273: );

Line 348: ln_transaction_id := wf_engine.GetItemAttrNumber

344:
345: if ( funcmode = 'RUN' ) then
346: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
347:
348: ln_transaction_id := wf_engine.GetItemAttrNumber
349: (itemtype => itemtype
350: ,itemkey => itemkey
351: ,aname => 'TRANSACTION_ID'
352: );

Line 354: ln_current_assignment_id := wf_engine.GetItemAttrNumber

350: ,itemkey => itemkey
351: ,aname => 'TRANSACTION_ID'
352: );
353:
354: ln_current_assignment_id := wf_engine.GetItemAttrNumber
355: (itemtype => itemtype
356: ,itemkey => itemkey
357: ,aname => 'CURRENT_ASSIGNMENT_ID'
358: );

Line 360: ln_contact_person_id := wf_engine.GetItemAttrNumber

356: ,itemkey => itemkey
357: ,aname => 'CURRENT_ASSIGNMENT_ID'
358: );
359:
360: ln_contact_person_id := wf_engine.GetItemAttrNumber
361: (itemtype => itemtype
362: ,itemkey => itemkey
363: ,aname => 'CONTACT_PERSON_ID'
364: );

Line 366: ln_employee_person_id := wf_engine.GetItemAttrNumber

362: ,itemkey => itemkey
363: ,aname => 'CONTACT_PERSON_ID'
364: );
365:
366: ln_employee_person_id := wf_engine.GetItemAttrNumber
367: (itemtype => itemtype
368: ,itemkey => itemkey
369: ,aname => 'EMPLOYEE_PERSON_ID'
370: );

Line 497: ln_transaction_id := wf_engine.GetItemAttrNumber

493: hr_utility.set_location('Entering: ' || l_proc || ':'|| funcmode,5);
494: if ( funcmode = 'RUN' ) then
495: lv_contact_source := fnd_profile.value('HR_PAYROLL_CONTACT_SOURCE');
496:
497: ln_transaction_id := wf_engine.GetItemAttrNumber
498: (itemtype => itemtype
499: ,itemkey => itemkey
500: ,aname => 'TRANSACTION_ID'
501: );

Line 503: ln_current_assignment_id := wf_engine.GetItemAttrNumber

499: ,itemkey => itemkey
500: ,aname => 'TRANSACTION_ID'
501: );
502:
503: ln_current_assignment_id := wf_engine.GetItemAttrNumber
504: (itemtype => itemtype
505: ,itemkey => itemkey
506: ,aname => 'CURRENT_ASSIGNMENT_ID'
507: );

Line 509: lv_curr_contact_user := wf_engine.GetItemAttrText

505: ,itemkey => itemkey
506: ,aname => 'CURRENT_ASSIGNMENT_ID'
507: );
508:
509: lv_curr_contact_user := wf_engine.GetItemAttrText
510: (itemtype => itemtype
511: ,itemkey => itemkey
512: ,aname => 'CONTACT_USERNAME'
513: );

Line 515: ln_curr_contact_person_id := wf_engine.GetItemAttrNumber

511: ,itemkey => itemkey
512: ,aname => 'CONTACT_USERNAME'
513: );
514:
515: ln_curr_contact_person_id := wf_engine.GetItemAttrNumber
516: (itemtype => itemtype
517: ,itemkey => itemkey
518: ,aname => 'CONTACT_PERSON_ID'
519: );

Line 560: wf_engine.SetItemAttrNumber

556: ,p_orig_system_id => ln_next_contact_person_id
557: ,p_name => lv_next_contact_user
558: ,p_display_name => lv_dummy);
559:
560: wf_engine.SetItemAttrNumber
561: (itemtype => itemtype
562: ,itemkey => itemkey
563: ,aname => 'CONTACT_PERSON_ID'
564: ,avalue => ln_next_contact_person_id);

Line 566: wf_engine.SetItemAttrNumber

562: ,itemkey => itemkey
563: ,aname => 'CONTACT_PERSON_ID'
564: ,avalue => ln_next_contact_person_id);
565:
566: wf_engine.SetItemAttrNumber
567: (itemtype => itemtype
568: ,itemkey => itemkey
569: ,aname => 'CURRENT_ASSIGNMENT_ID'
570: ,avalue => ln_current_assignment_id);

Line 572: wf_engine.SetItemAttrText

568: ,itemkey => itemkey
569: ,aname => 'CURRENT_ASSIGNMENT_ID'
570: ,avalue => ln_current_assignment_id);
571:
572: wf_engine.SetItemAttrText
573: (itemtype => itemtype
574: ,itemkey => itemkey
575: ,aname => 'CONTACT_USERNAME'
576: ,avalue => lv_next_contact_user);

Line 636: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype

632:
633: BEGIN
634: hr_utility.set_location('Entering: ' || l_proc || ':' || funcmode,5);
635: if (funcmode = 'RUN') then
636: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype
637: ,itemkey => itemkey
638: ,aname => 'TRANSACTION_ID');
639: open c_transaction;
640: fetch c_transaction into lr_trans_rec;

Line 660: wf_engine.SetItemAttrText(itemtype => itemtype

656: (to_number(lr_trans_rec.audit_information2) >
657: to_number(lr_fed_rec.fed_information1)) then
658: hr_utility.set_message(801,'PAY_US_OTF_W4_FED_OVERALLOW');
659:
660: wf_engine.SetItemAttrText(itemtype => itemtype
661: ,itemkey => itemkey
662: ,aname => 'EXCEPTION_REASON'
663: ,avalue => hr_utility.get_message);
664: result := 'COMPLETE:Y';

Line 669: wf_engine.SetItemAttrText(itemtype => itemtype

665:
666: elsif lr_trans_rec.audit_information4 = 'Y' then
667: hr_utility.set_message(801,'PAY_US_OTF_FED_EXEMPTWARN');
668:
669: wf_engine.SetItemAttrText(itemtype => itemtype
670: ,itemkey => itemkey
671: ,aname => 'EXCEPTION_REASON'
672: ,avalue => hr_utility.get_message);
673: result := 'COMPLETE:Y';