eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_PE_WF_GEN dependencies on WF_ENGINE

Line 148: l_res_dtls_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'RES_DTLS_ID');

144: l_message := fnd_message.get;
145:
146: -- Getting the paremeter values from the workflow
147:
148: l_res_dtls_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'RES_DTLS_ID');
149: l_action := Wf_Engine.GetItemAttrText(itemtype,itemkey,'ACTION');
150: l_date := Wf_Engine.GetItemAttrText(itemtype,itemkey,'OLD_EVAL_DATE');
151:
152: OPEN res_dtl_cur(l_res_dtls_id);

Line 149: l_action := Wf_Engine.GetItemAttrText(itemtype,itemkey,'ACTION');

145:
146: -- Getting the paremeter values from the workflow
147:
148: l_res_dtls_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'RES_DTLS_ID');
149: l_action := Wf_Engine.GetItemAttrText(itemtype,itemkey,'ACTION');
150: l_date := Wf_Engine.GetItemAttrText(itemtype,itemkey,'OLD_EVAL_DATE');
151:
152: OPEN res_dtl_cur(l_res_dtls_id);
153: FETCH res_dtl_cur INTO res_dtl_rec;

Line 150: l_date := Wf_Engine.GetItemAttrText(itemtype,itemkey,'OLD_EVAL_DATE');

146: -- Getting the paremeter values from the workflow
147:
148: l_res_dtls_id := Wf_Engine.GetItemAttrText(itemtype,itemkey,'RES_DTLS_ID');
149: l_action := Wf_Engine.GetItemAttrText(itemtype,itemkey,'ACTION');
150: l_date := Wf_Engine.GetItemAttrText(itemtype,itemkey,'OLD_EVAL_DATE');
151:
152: OPEN res_dtl_cur(l_res_dtls_id);
153: FETCH res_dtl_cur INTO res_dtl_rec;
154: CLOSE res_dtl_cur;

Line 161: Wf_Engine.SetItemAttrText(

157: OPEN c_get_person_name(res_dtl_rec.person_id);
158: FETCH c_get_person_name INTO l_name,l_person_number;
159: CLOSE c_get_person_name;
160:
161: Wf_Engine.SetItemAttrText(
162: ItemType => itemtype,
163: ItemKey => itemkey,
164: aname => 'PERSON_ID',
165: avalue => res_dtl_rec.person_id

Line 168: Wf_Engine.SetItemAttrText(

164: aname => 'PERSON_ID',
165: avalue => res_dtl_rec.person_id
166: );
167:
168: Wf_Engine.SetItemAttrText(
169: ItemType => itemtype,
170: ItemKey => itemkey,
171: aname => 'RES_CLASS',
172: avalue => res_dtl_rec.residency_class

Line 175: Wf_Engine.SetItemAttrText(

171: aname => 'RES_CLASS',
172: avalue => res_dtl_rec.residency_class
173: );
174:
175: Wf_Engine.SetItemAttrText(
176: ItemType => itemtype,
177: ItemKey => itemkey,
178: aname => 'NEW_RES_STATUS',
179: avalue => res_dtl_rec.residency_status_desc

Line 182: Wf_Engine.SetItemAttrText(

178: aname => 'NEW_RES_STATUS',
179: avalue => res_dtl_rec.residency_status_desc
180: );
181:
182: Wf_Engine.SetItemAttrText(
183: ItemType => itemtype,
184: ItemKey => itemkey,
185: aname => 'NEW_EVAL_DATE',
186: avalue => res_dtl_rec.evaluation_date

Line 189: Wf_Engine.SetItemAttrText(

185: aname => 'NEW_EVAL_DATE',
186: avalue => res_dtl_rec.evaluation_date
187: );
188:
189: Wf_Engine.SetItemAttrText(
190: ItemType => itemtype,
191: ItemKey => itemkey,
192: aname => 'CALENDAR_DESC',
193: avalue => res_dtl_rec.calendar_desc

Line 196: Wf_Engine.SetItemAttrText(

192: aname => 'CALENDAR_DESC',
193: avalue => res_dtl_rec.calendar_desc
194: );
195:
196: Wf_Engine.SetItemAttrText(
197: ItemType => itemtype,
198: ItemKey => itemkey,
199: aname => 'NEW_EVALUATOR',
200: avalue => res_dtl_rec.evaluator

Line 202: Wf_Engine.SetItemAttrText(

198: ItemKey => itemkey,
199: aname => 'NEW_EVALUATOR',
200: avalue => res_dtl_rec.evaluator
201: );
202: Wf_Engine.SetItemAttrText(
203: ItemType => itemtype,
204: ItemKey => itemkey,
205: aname => 'PERSON_NUMBER',
206: avalue => l_person_number

Line 208: Wf_Engine.SetItemAttrText(

204: ItemKey => itemkey,
205: aname => 'PERSON_NUMBER',
206: avalue => l_person_number
207: );
208: Wf_Engine.SetItemAttrText(
209: ItemType => itemtype,
210: ItemKey => itemkey,
211: aname => 'NAME',
212: avalue => l_name

Line 215: Wf_Engine.SetItemAttrText(

211: aname => 'NAME',
212: avalue => l_name
213: );
214:
215: Wf_Engine.SetItemAttrText(
216: ItemType => itemtype,
217: ItemKey => itemkey,
218: aname => 'RES_CLASS_DESC',
219: avalue => res_dtl_rec.residency_class_desc

Line 222: Wf_Engine.SetItemAttrText(

218: aname => 'RES_CLASS_DESC',
219: avalue => res_dtl_rec.residency_class_desc
220: );
221:
222: Wf_Engine.SetItemAttrText(
223: ItemType => itemtype,
224: ItemKey => itemkey,
225: aname => 'NEW_COMMENTS',
226: avalue => res_dtl_rec.comments

Line 228: Wf_Engine.SetItemAttrText(

224: ItemKey => itemkey,
225: aname => 'NEW_COMMENTS',
226: avalue => res_dtl_rec.comments
227: );
228: Wf_Engine.SetItemAttrText(
229: ItemType => itemtype,
230: ItemKey => itemkey,
231: aname => 'SUBJECT',
232: avalue => l_message

Line 239: Wf_Engine.SetItemAttrText(

235: OPEN updated_by_cur(res_dtl_rec.last_updated_by);
236: FETCH updated_by_cur INTO l_user_name;
237: CLOSE updated_by_cur;
238:
239: Wf_Engine.SetItemAttrText(
240: ItemType => itemtype,
241: ItemKey => itemkey,
242: aname => 'UPDATED_BY',
243: avalue => l_user_name

Line 248: l_old_res_status := Wf_Engine.GetItemAttrText(itemtype,itemkey,'OLD_RES_STATUS');

244: );
245:
246: IF l_action='U' THEN
247:
248: l_old_res_status := Wf_Engine.GetItemAttrText(itemtype,itemkey,'OLD_RES_STATUS');
249:
250: OPEN res_status_cur('PE_RES_STATUS', l_old_res_status);
251: FETCH res_status_cur INTO l_res_status_desc;
252: CLOSE res_status_cur;

Line 254: Wf_Engine.SetItemAttrText(

250: OPEN res_status_cur('PE_RES_STATUS', l_old_res_status);
251: FETCH res_status_cur INTO l_res_status_desc;
252: CLOSE res_status_cur;
253:
254: Wf_Engine.SetItemAttrText(
255: ItemType => itemtype,
256: ItemKey => itemkey,
257: aname => 'OLD_RES_STATUS',
258: avalue => l_res_status_desc

Line 363: l_party_site_id := wf_engine.getitemattrtext(itemtype,itemkey,'PARTY_SITE_ID');

359: get_effective_dates_rec get_effective_dates_cur%ROWTYPE;
360:
361: BEGIN
362: -- get the party side ID from the business event generated.
363: l_party_site_id := wf_engine.getitemattrtext(itemtype,itemkey,'PARTY_SITE_ID');
364: -- check if this ID is for any PERSON. If not set the outcome status to FAIL otherwise process.
365: OPEN cur_get_party_id(l_party_site_id);
366: FETCH cur_get_party_id INTO cur_get_party_id_rec;
367: IF (cur_get_party_id%FOUND) THEN

Line 388: Wf_Engine.SetItemAttrText(

384:
385: fnd_message.set_name('IGS','IGS_PE_ADDR_CHG_MES_SUBJ');
386: l_message := fnd_message.get;
387:
388: Wf_Engine.SetItemAttrText(
389: ItemType => itemtype,
390: ItemKey => itemkey,
391: aname => 'PERSON_NUMBER',
392: avalue => get_location_dets_rec.party_number

Line 395: Wf_Engine.SetItemAttrText(

391: aname => 'PERSON_NUMBER',
392: avalue => get_location_dets_rec.party_number
393: );
394:
395: Wf_Engine.SetItemAttrText(
396: ItemType => itemtype,
397: ItemKey => itemkey,
398: aname => 'NAME',
399: avalue => get_location_dets_rec.party_name

Line 402: Wf_Engine.SetItemAttrText(

398: aname => 'NAME',
399: avalue => get_location_dets_rec.party_name
400: );
401:
402: Wf_Engine.SetItemAttrText(
403: ItemType => itemtype,
404: ItemKey => itemkey,
405: aname => 'NEW_ADDRESS1',
406: avalue => get_location_dets_rec.address1

Line 408: Wf_Engine.SetItemAttrText(

404: ItemKey => itemkey,
405: aname => 'NEW_ADDRESS1',
406: avalue => get_location_dets_rec.address1
407: );
408: Wf_Engine.SetItemAttrText(
409: ItemType => itemtype,
410: ItemKey => itemkey,
411: aname => 'NEW_ADDRESS2',
412: avalue => get_location_dets_rec.address2

Line 414: Wf_Engine.SetItemAttrText(

410: ItemKey => itemkey,
411: aname => 'NEW_ADDRESS2',
412: avalue => get_location_dets_rec.address2
413: );
414: Wf_Engine.SetItemAttrText(
415: ItemType => itemtype,
416: ItemKey => itemkey,
417: aname => 'NEW_ADDRESS3',
418: avalue => get_location_dets_rec.address3

Line 420: Wf_Engine.SetItemAttrText(

416: ItemKey => itemkey,
417: aname => 'NEW_ADDRESS3',
418: avalue => get_location_dets_rec.address3
419: );
420: Wf_Engine.SetItemAttrText(
421: ItemType => itemtype,
422: ItemKey => itemkey,
423: aname => 'NEW_ADDRESS4',
424: avalue => get_location_dets_rec.address4

Line 426: Wf_Engine.SetItemAttrText(

422: ItemKey => itemkey,
423: aname => 'NEW_ADDRESS4',
424: avalue => get_location_dets_rec.address4
425: );
426: Wf_Engine.SetItemAttrText(
427: ItemType => itemtype,
428: ItemKey => itemkey,
429: aname => 'NEW_CITY',
430: avalue => get_location_dets_rec.city

Line 432: Wf_Engine.SetItemAttrText(

428: ItemKey => itemkey,
429: aname => 'NEW_CITY',
430: avalue => get_location_dets_rec.city
431: );
432: Wf_Engine.SetItemAttrText(
433: ItemType => itemtype,
434: ItemKey => itemkey,
435: aname => 'NEW_STATE',
436: avalue => get_location_dets_rec.state

Line 438: Wf_Engine.SetItemAttrText(

434: ItemKey => itemkey,
435: aname => 'NEW_STATE',
436: avalue => get_location_dets_rec.state
437: );
438: Wf_Engine.SetItemAttrText(
439: ItemType => itemtype,
440: ItemKey => itemkey,
441: aname => 'NEW_COUNTY',
442: avalue => get_location_dets_rec.county

Line 444: Wf_Engine.SetItemAttrText(

440: ItemKey => itemkey,
441: aname => 'NEW_COUNTY',
442: avalue => get_location_dets_rec.county
443: );
444: Wf_Engine.SetItemAttrText(
445: ItemType => itemtype,
446: ItemKey => itemkey,
447: aname => 'NEW_POSTAL_CODE',
448: avalue => get_location_dets_rec.postal_code

Line 451: Wf_Engine.SetItemAttrText(

447: aname => 'NEW_POSTAL_CODE',
448: avalue => get_location_dets_rec.postal_code
449: );
450:
451: Wf_Engine.SetItemAttrText(
452: ItemType => itemtype,
453: ItemKey => itemkey,
454: aname => 'NEW_PROVINCE',
455: avalue => get_location_dets_rec.province

Line 462: Wf_Engine.SetItemAttrText(

458: OPEN get_country(get_location_dets_rec.country);
459: FETCH get_country INTO l_country_desc;
460: CLOSE get_country;
461:
462: Wf_Engine.SetItemAttrText(
463: ItemType => itemtype,
464: ItemKey => itemkey,
465: aname => 'NEW_COUNTRY',
466: avalue => l_country_desc

Line 468: Wf_Engine.SetItemAttrText(

464: ItemKey => itemkey,
465: aname => 'NEW_COUNTRY',
466: avalue => l_country_desc
467: );
468: Wf_Engine.SetItemAttrText(
469: ItemType => itemtype,
470: ItemKey => itemkey,
471: aname => 'NEW_DEL_POINT',
472: avalue => get_location_dets_rec.delivery_point_code

Line 479: Wf_Engine.SetItemAttrText(

475: OPEN get_effective_dates_cur(l_party_site_id);
476: FETCH get_effective_dates_cur INTO get_effective_dates_rec;
477: CLOSE get_effective_dates_cur;
478:
479: Wf_Engine.SetItemAttrText(
480: ItemType => itemtype,
481: ItemKey => itemkey,
482: aname => 'NEW_FROM_DATE',
483: avalue => get_effective_dates_rec.start_date

Line 485: Wf_Engine.SetItemAttrText(

481: ItemKey => itemkey,
482: aname => 'NEW_FROM_DATE',
483: avalue => get_effective_dates_rec.start_date
484: );
485: Wf_Engine.SetItemAttrText(
486: ItemType => itemtype,
487: ItemKey => itemkey,
488: aname => 'NEW_TO_DATE',
489: avalue => get_effective_dates_rec.end_date

Line 496: Wf_Engine.SetItemAttrText(

492: OPEN get_lkup_meaning(get_location_dets_rec.identifying_address_flag);
493: FETCH get_lkup_meaning INTO l_lkup_meaning;
494: CLOSE get_lkup_meaning;
495:
496: Wf_Engine.SetItemAttrText(
497: ItemType => itemtype,
498: ItemKey => itemkey,
499: aname => 'NEW_PRIMARY_ADDRESS',
500: avalue => l_lkup_meaning

Line 502: Wf_Engine.SetItemAttrText(

498: ItemKey => itemkey,
499: aname => 'NEW_PRIMARY_ADDRESS',
500: avalue => l_lkup_meaning
501: );
502: Wf_Engine.SetItemAttrText(
503: ItemType => itemtype,
504: ItemKey => itemkey,
505: aname => 'SUBJECT',
506: avalue => l_message

Line 529: Wf_Engine.SetItemAttrText(

525: END IF;
526: END IF;
527: END IF;
528:
529: Wf_Engine.SetItemAttrText(
530: ItemType => itemtype,
531: ItemKey => itemkey,
532: aname => 'PARTY_TYPE',
533: avalue => l_message

Line 616: l_party_site_id := wf_engine.getitemattrtext(itemtype,itemkey,'PARTY_SITE_ID');

612: BEGIN
613:
614: --get Party Site ID from the business event that was raised.
615:
616: l_party_site_id := wf_engine.getitemattrtext(itemtype,itemkey,'PARTY_SITE_ID');
617:
618: --Check whether the party site is of an OSS party. If not then set the result to FAIL and stop processing.
619: OPEN chk_oss_party(l_party_site_id);
620: FETCH chk_oss_party INTO rec_chk_oss_party;

Line 634: Wf_Engine.SetItemAttrText(

630: IF rec_chk_oss_party.identifying_address_flag = 'Y' THEN
631: fnd_message.set_name('IGS','IGS_PE_PRIM_ADDR_MSG');
632: l_message := fnd_message.get;
633:
634: Wf_Engine.SetItemAttrText(
635: ItemType => itemtype,
636: ItemKey => itemkey,
637: aname => 'P_PRIM_ADDR_MSG',
638: avalue => l_message

Line 642: Wf_Engine.SetItemAttrText(

638: avalue => l_message
639: );
640: END IF;
641:
642: Wf_Engine.SetItemAttrText(
643: ItemType => itemtype,
644: ItemKey => itemkey,
645: aname => 'NAME',
646: avalue => rec_chk_oss_party.party_name

Line 654: Wf_Engine.SetItemAttrText(

650: OPEN get_location_dtls(rec_chk_oss_party.location_id);
651: FETCH get_location_dtls INTO rec_location_dtls;
652: CLOSE get_location_dtls;
653:
654: Wf_Engine.SetItemAttrText(
655: ItemType => itemtype,
656: ItemKey => itemkey,
657: aname => 'NEW_ADDRESS1',
658: avalue => rec_location_dtls.ADDRESS1

Line 660: Wf_Engine.SetItemAttrText(

656: ItemKey => itemkey,
657: aname => 'NEW_ADDRESS1',
658: avalue => rec_location_dtls.ADDRESS1
659: );
660: Wf_Engine.SetItemAttrText(
661: ItemType => itemtype,
662: ItemKey => itemkey,
663: aname => 'NEW_ADDRESS2',
664: avalue => rec_location_dtls.ADDRESS2

Line 666: Wf_Engine.SetItemAttrText(

662: ItemKey => itemkey,
663: aname => 'NEW_ADDRESS2',
664: avalue => rec_location_dtls.ADDRESS2
665: );
666: Wf_Engine.SetItemAttrText(
667: ItemType => itemtype,
668: ItemKey => itemkey,
669: aname => 'NEW_ADDRESS3',
670: avalue => rec_location_dtls.ADDRESS3

Line 672: Wf_Engine.SetItemAttrText(

668: ItemKey => itemkey,
669: aname => 'NEW_ADDRESS3',
670: avalue => rec_location_dtls.ADDRESS3
671: );
672: Wf_Engine.SetItemAttrText(
673: ItemType => itemtype,
674: ItemKey => itemkey,
675: aname => 'NEW_ADDRESS4',
676: avalue => rec_location_dtls.ADDRESS4

Line 678: Wf_Engine.SetItemAttrText(

674: ItemKey => itemkey,
675: aname => 'NEW_ADDRESS4',
676: avalue => rec_location_dtls.ADDRESS4
677: );
678: Wf_Engine.SetItemAttrText(
679: ItemType => itemtype,
680: ItemKey => itemkey,
681: aname => 'NEW_CITY',
682: avalue => rec_location_dtls.CITY

Line 684: Wf_Engine.SetItemAttrText(

680: ItemKey => itemkey,
681: aname => 'NEW_CITY',
682: avalue => rec_location_dtls.CITY
683: );
684: Wf_Engine.SetItemAttrText(
685: ItemType => itemtype,
686: ItemKey => itemkey,
687: aname => 'NEW_STATE',
688: avalue => rec_location_dtls.STATE

Line 690: Wf_Engine.SetItemAttrText(

686: ItemKey => itemkey,
687: aname => 'NEW_STATE',
688: avalue => rec_location_dtls.STATE
689: );
690: Wf_Engine.SetItemAttrText(
691: ItemType => itemtype,
692: ItemKey => itemkey,
693: aname => 'NEW_COUNTY',
694: avalue => rec_location_dtls.COUNTY

Line 696: Wf_Engine.SetItemAttrText(

692: ItemKey => itemkey,
693: aname => 'NEW_COUNTY',
694: avalue => rec_location_dtls.COUNTY
695: );
696: Wf_Engine.SetItemAttrText(
697: ItemType => itemtype,
698: ItemKey => itemkey,
699: aname => 'NEW_POSTAL_CODE',
700: avalue => rec_location_dtls.POSTAL_CODE

Line 702: Wf_Engine.SetItemAttrText(

698: ItemKey => itemkey,
699: aname => 'NEW_POSTAL_CODE',
700: avalue => rec_location_dtls.POSTAL_CODE
701: );
702: Wf_Engine.SetItemAttrText(
703: ItemType => itemtype,
704: ItemKey => itemkey,
705: aname => 'NEW_PROVINCE',
706: avalue => rec_location_dtls.PROVINCE

Line 713: Wf_Engine.SetItemAttrText(

709: OPEN get_country(rec_location_dtls.country);
710: FETCH get_country INTO l_new_country_desc;
711: CLOSE get_country;
712:
713: Wf_Engine.SetItemAttrText(
714: ItemType => itemtype,
715: ItemKey => itemkey,
716: aname => 'NEW_COUNTRY',
717: avalue => l_new_country_desc

Line 719: Wf_Engine.SetItemAttrText(

715: ItemKey => itemkey,
716: aname => 'NEW_COUNTRY',
717: avalue => l_new_country_desc
718: );
719: Wf_Engine.SetItemAttrText(
720: ItemType => itemtype,
721: ItemKey => itemkey,
722: aname => 'NEW_DEL_POINT',
723: avalue => rec_location_dtls.DELIVERY_POINT_CODE

Line 731: Wf_Engine.SetItemAttrText(

727: OPEN get_effective_dates(l_party_site_id);
728: FETCH get_effective_dates INTO rec_effective_dates;
729: CLOSE get_effective_dates;
730:
731: Wf_Engine.SetItemAttrText(
732: ItemType => itemtype,
733: ItemKey => itemkey,
734: aname => 'NEW_FROM_DATE',
735: avalue => rec_effective_dates.start_date

Line 737: Wf_Engine.SetItemAttrText(

733: ItemKey => itemkey,
734: aname => 'NEW_FROM_DATE',
735: avalue => rec_effective_dates.start_date
736: );
737: Wf_Engine.SetItemAttrText(
738: ItemType => itemtype,
739: ItemKey => itemkey,
740: aname => 'NEW_TO_DATE',
741: avalue => rec_effective_dates.end_date

Line 749: Wf_Engine.SetItemAttrText(

745: OPEN get_old_addr_dtls(rec_chk_oss_party.location_id);
746: FETCH get_old_addr_dtls INTO rec_old_addr_dtls;
747: CLOSE get_old_addr_dtls;
748:
749: Wf_Engine.SetItemAttrText(
750: ItemType => itemtype,
751: ItemKey => itemkey,
752: aname => 'OLD_ADDRESS1',
753: avalue => rec_old_addr_dtls.ADDRESS1

Line 755: Wf_Engine.SetItemAttrText(

751: ItemKey => itemkey,
752: aname => 'OLD_ADDRESS1',
753: avalue => rec_old_addr_dtls.ADDRESS1
754: );
755: Wf_Engine.SetItemAttrText(
756: ItemType => itemtype,
757: ItemKey => itemkey,
758: aname => 'OLD_ADDRESS2',
759: avalue => rec_old_addr_dtls.ADDRESS2

Line 761: Wf_Engine.SetItemAttrText(

757: ItemKey => itemkey,
758: aname => 'OLD_ADDRESS2',
759: avalue => rec_old_addr_dtls.ADDRESS2
760: );
761: Wf_Engine.SetItemAttrText(
762: ItemType => itemtype,
763: ItemKey => itemkey,
764: aname => 'OLD_ADDRESS3',
765: avalue => rec_old_addr_dtls.ADDRESS3

Line 767: Wf_Engine.SetItemAttrText(

763: ItemKey => itemkey,
764: aname => 'OLD_ADDRESS3',
765: avalue => rec_old_addr_dtls.ADDRESS3
766: );
767: Wf_Engine.SetItemAttrText(
768: ItemType => itemtype,
769: ItemKey => itemkey,
770: aname => 'OLD_ADDRESS4',
771: avalue => rec_old_addr_dtls.ADDRESS4

Line 773: Wf_Engine.SetItemAttrText(

769: ItemKey => itemkey,
770: aname => 'OLD_ADDRESS4',
771: avalue => rec_old_addr_dtls.ADDRESS4
772: );
773: Wf_Engine.SetItemAttrText(
774: ItemType => itemtype,
775: ItemKey => itemkey,
776: aname => 'OLD_CITY',
777: avalue => rec_old_addr_dtls.CITY

Line 779: Wf_Engine.SetItemAttrText(

775: ItemKey => itemkey,
776: aname => 'OLD_CITY',
777: avalue => rec_old_addr_dtls.CITY
778: );
779: Wf_Engine.SetItemAttrText(
780: ItemType => itemtype,
781: ItemKey => itemkey,
782: aname => 'OLD_STATE',
783: avalue => rec_old_addr_dtls.PROV_STATE_ADMIN_CODE

Line 785: Wf_Engine.SetItemAttrText(

781: ItemKey => itemkey,
782: aname => 'OLD_STATE',
783: avalue => rec_old_addr_dtls.PROV_STATE_ADMIN_CODE
784: );
785: Wf_Engine.SetItemAttrText(
786: ItemType => itemtype,
787: ItemKey => itemkey,
788: aname => 'OLD_COUNTY',
789: avalue => rec_old_addr_dtls.COUNTY

Line 792: Wf_Engine.SetItemAttrText(

788: aname => 'OLD_COUNTY',
789: avalue => rec_old_addr_dtls.COUNTY
790: );
791:
792: Wf_Engine.SetItemAttrText(
793: ItemType => itemtype,
794: ItemKey => itemkey,
795: aname => 'OLD_POSTAL_CODE',
796: avalue => rec_old_addr_dtls.POSTAL_CODE

Line 801: Wf_Engine.SetItemAttrText(

797: );
798: -- Set the SUBJECT with message IGS_PE_ADDR_CHG_MES_SUBJ -Address Change Notification
799: fnd_message.set_name('IGS','IGS_PE_ADDR_CHG_MES_SUBJ');
800: l_message := fnd_message.get;
801: Wf_Engine.SetItemAttrText(
802: ItemType => itemtype,
803: ItemKey => itemkey,
804: aname => 'SUBJECT',
805: avalue => l_message

Line 813: Wf_Engine.SetItemAttrText(

809: OPEN get_country(rec_old_addr_dtls.country);
810: FETCH get_country INTO l_country_desc;
811: CLOSE get_country;
812:
813: Wf_Engine.SetItemAttrText(
814: ItemType => itemtype,
815: ItemKey => itemkey,
816: aname => 'OLD_COUNTRY',
817: avalue => l_country_desc

Line 825: Wf_Engine.SetItemAttrText(

821: IF rec_chk_oss_party.inst_org_ind IS NULL THEN
822:
823: fnd_message.set_name('IGS','IGS_PR_PERSON_ID');
824: l_message := fnd_message.get;
825: Wf_Engine.SetItemAttrText(
826: ItemType => itemtype,
827: ItemKey => itemkey,
828: aname => 'PARTY_TYPE',
829: avalue => l_message

Line 831: Wf_Engine.SetItemAttrText(

827: ItemKey => itemkey,
828: aname => 'PARTY_TYPE',
829: avalue => l_message
830: );
831: Wf_Engine.SetItemAttrText(
832: ItemType => itemtype,
833: ItemKey => itemkey,
834: aname => 'PERSON_NUMBER',
835: avalue => rec_chk_oss_party.PARTY_NUMBER

Line 841: Wf_Engine.SetItemAttrText(

837: ELSIF rec_chk_oss_party.inst_org_ind = 'I' THEN
838: fnd_message.set_name('IGS','IGS_OR_INSTITUTION_CODE');
839: l_message := fnd_message.get;
840:
841: Wf_Engine.SetItemAttrText(
842: ItemType => itemtype,
843: ItemKey => itemkey,
844: aname => 'PARTY_TYPE',
845: avalue => l_message

Line 847: Wf_Engine.SetItemAttrText(

843: ItemKey => itemkey,
844: aname => 'PARTY_TYPE',
845: avalue => l_message
846: );
847: Wf_Engine.SetItemAttrText(
848: ItemType => itemtype,
849: ItemKey => itemkey,
850: aname => 'PERSON_NUMBER',
851: avalue => rec_chk_oss_party.OSS_ORG_UNIT_CD

Line 857: Wf_Engine.SetItemAttrText(

853: ELSIF rec_chk_oss_party.inst_org_ind = 'O' THEN
854: fnd_message.set_name('IGS','IGS_RE_ORG_UNIT_CD');
855: l_message := fnd_message.get;
856:
857: Wf_Engine.SetItemAttrText(
858: ItemType => itemtype,
859: ItemKey => itemkey,
860: aname => 'PARTY_TYPE',
861: avalue => l_message

Line 863: Wf_Engine.SetItemAttrText(

859: ItemKey => itemkey,
860: aname => 'PARTY_TYPE',
861: avalue => l_message
862: );
863: Wf_Engine.SetItemAttrText(
864: ItemType => itemtype,
865: ItemKey => itemkey,
866: aname => 'PERSON_NUMBER',
867: avalue => rec_chk_oss_party.OSS_ORG_UNIT_CD

Line 988: l_c_per_org := wf_engine.GetItemAttrText (

984: BEGIN
985:
986: IF (funcmode = 'RUN') THEN
987:
988: l_c_per_org := wf_engine.GetItemAttrText (
989: itemtype => itemtype,
990: itemkey => itemkey,
991: aname => 'P_BULK_PROC_CONTEXT');
992:

Line 1012: wf_engine.SetItemAttrText (itemtype => itemtype,

1008: FETCH cur_message_text INTO l_message_text;
1009: CLOSE cur_message_text;
1010: END IF;
1011:
1012: wf_engine.SetItemAttrText (itemtype => itemtype,
1013: itemkey => itemkey,
1014: aname => 'P_PARTY_TYPE_TITLE',
1015: avalue => l_party_type);
1016:

Line 1019: wf_engine.SetItemAttrText (itemtype => itemtype,

1015: avalue => l_party_type);
1016:
1017:
1018:
1019: wf_engine.SetItemAttrText (itemtype => itemtype,
1020: itemkey => itemkey,
1021: aname => 'PARTY_TYPE',
1022: avalue => l_message_text);
1023:

Line 1024: wf_engine.SetItemAttrText(itemtype => itemtype,

1020: itemkey => itemkey,
1021: aname => 'PARTY_TYPE',
1022: avalue => l_message_text);
1023:
1024: wf_engine.SetItemAttrText(itemtype => itemtype,
1025: itemkey => itemkey,
1026: aname => 'P_ADDR_SYNC_MSG_TEXT',
1027: avalue => 'PLSQLCLOB:igs_pe_wf_gen.write_addr_sync_message/'|| itemtype || ':' || itemkey);
1028:

Line 1148: i_event := Wf_Engine.GetItemAttrEvent(l_c_itemtype, l_c_itemkey, 'P_EVENT_DATA');

1144: l_c_itemkey := SUBSTR(document_id, instr(document_id, ':') + 1, length(document_id));
1145:
1146:
1147: -- get the handle of the event instance, and get the value of the event data.
1148: i_event := Wf_Engine.GetItemAttrEvent(l_c_itemtype, l_c_itemkey, 'P_EVENT_DATA');
1149: l_clob_data := i_event.event_data;
1150: --Prepare the pl-sql table from the clob object
1151: prepare_plsql_table(l_clob_data);
1152:

Line 1155: l_c_per_org := wf_engine.GetItemAttrText (

1151: prepare_plsql_table(l_clob_data);
1152:
1153:
1154:
1155: l_c_per_org := wf_engine.GetItemAttrText (
1156: itemtype => l_c_itemtype,
1157: itemkey => l_c_itemkey,
1158: aname => 'P_BULK_PROC_CONTEXT');
1159:

Line 1368: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');

1364: person_dtl_rec person_dtl_cur%ROWTYPE;
1365:
1366: BEGIN
1367:
1368: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
1369: l_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_INTENT_CODE');
1370: l_old_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_OLD_ACAD_INTENT_CODE');
1371: l_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_CAL_TYPE');
1372: l_cal_seq_num := wf_engine.getitemattrnumber(itemtype,itemkey,'P_CAL_SEQ_NUMBER');

Line 1369: l_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_INTENT_CODE');

1365:
1366: BEGIN
1367:
1368: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
1369: l_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_INTENT_CODE');
1370: l_old_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_OLD_ACAD_INTENT_CODE');
1371: l_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_CAL_TYPE');
1372: l_cal_seq_num := wf_engine.getitemattrnumber(itemtype,itemkey,'P_CAL_SEQ_NUMBER');
1373:

Line 1370: l_old_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_OLD_ACAD_INTENT_CODE');

1366: BEGIN
1367:
1368: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
1369: l_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_INTENT_CODE');
1370: l_old_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_OLD_ACAD_INTENT_CODE');
1371: l_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_CAL_TYPE');
1372: l_cal_seq_num := wf_engine.getitemattrnumber(itemtype,itemkey,'P_CAL_SEQ_NUMBER');
1373:
1374: OPEN person_dtl_cur(l_person_id);

Line 1371: l_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_CAL_TYPE');

1367:
1368: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
1369: l_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_INTENT_CODE');
1370: l_old_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_OLD_ACAD_INTENT_CODE');
1371: l_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_CAL_TYPE');
1372: l_cal_seq_num := wf_engine.getitemattrnumber(itemtype,itemkey,'P_CAL_SEQ_NUMBER');
1373:
1374: OPEN person_dtl_cur(l_person_id);
1375: FETCH person_dtl_cur INTO person_dtl_rec;

Line 1372: l_cal_seq_num := wf_engine.getitemattrnumber(itemtype,itemkey,'P_CAL_SEQ_NUMBER');

1368: l_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'P_PERSON_ID');
1369: l_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_ACAD_INTENT_CODE');
1370: l_old_acad_intent_code := wf_engine.getitemattrtext(itemtype,itemkey,'P_OLD_ACAD_INTENT_CODE');
1371: l_cal_type := wf_engine.getitemattrtext(itemtype,itemkey,'P_CAL_TYPE');
1372: l_cal_seq_num := wf_engine.getitemattrnumber(itemtype,itemkey,'P_CAL_SEQ_NUMBER');
1373:
1374: OPEN person_dtl_cur(l_person_id);
1375: FETCH person_dtl_cur INTO person_dtl_rec;
1376: CLOSE person_dtl_cur;

Line 1378: Wf_Engine.SetItemAttrText(

1374: OPEN person_dtl_cur(l_person_id);
1375: FETCH person_dtl_cur INTO person_dtl_rec;
1376: CLOSE person_dtl_cur;
1377:
1378: Wf_Engine.SetItemAttrText(
1379: ItemType => itemtype,
1380: ItemKey => itemkey,
1381: aname => 'P_PERSON_NUMBER',
1382: avalue => person_dtl_rec.person_number

Line 1385: Wf_Engine.SetItemAttrText(

1381: aname => 'P_PERSON_NUMBER',
1382: avalue => person_dtl_rec.person_number
1383: );
1384:
1385: Wf_Engine.SetItemAttrText(
1386: ItemType => itemtype,
1387: ItemKey => itemkey,
1388: aname => 'P_PERSON_NAME',
1389: avalue => person_dtl_rec.full_name

Line 1396: Wf_Engine.SetItemAttrText(

1392: OPEN acad_intent_dtl_cur(l_acad_intent_code,'PE_ACAD_INTENTS');
1393: FETCH acad_intent_dtl_cur INTO l_acad_intent_desc;
1394: CLOSE acad_intent_dtl_cur;
1395:
1396: Wf_Engine.SetItemAttrText(
1397: ItemType => itemtype,
1398: ItemKey => itemkey,
1399: aname => 'P_ACAD_INTENT_DESC',
1400: avalue => l_acad_intent_desc

Line 1408: Wf_Engine.SetItemAttrText(

1404: OPEN acad_intent_dtl_cur(l_old_acad_intent_code, 'PE_ACAD_INTENTS');
1405: FETCH acad_intent_dtl_cur INTO l_old_acad_intent_desc;
1406: CLOSE acad_intent_dtl_cur;
1407:
1408: Wf_Engine.SetItemAttrText(
1409: ItemType => itemtype,
1410: ItemKey => itemkey,
1411: aname => 'P_OLD_ACAD_INTENT_DESC',
1412: avalue => l_old_acad_intent_desc

Line 1420: Wf_Engine.SetItemAttrText(

1416: OPEN term_desc_cur(l_cal_type, l_cal_seq_num);
1417: FETCH term_desc_cur INTO l_term_desc;
1418: CLOSE term_desc_cur;
1419:
1420: Wf_Engine.SetItemAttrText(
1421: ItemType => itemtype,
1422: ItemKey => itemkey,
1423: aname => 'P_CAL_DESC',
1424: avalue => l_term_desc