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.

APPS.JTF_RS_RESOURCE_WF_PUB dependencies on WF_ENGINE

Line 314: wf_engine.createprocess (

310: CLOSE c_support_site;
311: END IF;
312: END IF;
313:
314: wf_engine.createprocess (
315: itemtype => p_wf_item_type,
316: itemkey => l_itemkey,
317: process => p_wf_process
318: );

Line 320: wf_engine.setitemattrtext (

316: itemkey => l_itemkey,
317: process => p_wf_process
318: );
319:
320: wf_engine.setitemattrtext (
321: itemtype => p_wf_item_type,
322: itemkey => l_itemkey,
323: aname => 'P_APPROVED',
324: avalue => l_approved

Line 327: wf_engine.setitemattrtext (

323: aname => 'P_APPROVED',
324: avalue => l_approved
325: );
326:
327: wf_engine.setitemattrtext (
328: itemtype => p_wf_item_type,
329: itemkey => l_itemkey,
330: aname => 'ERROR_FLAG',
331: avalue => l_error_flag

Line 334: wf_engine.setitemattrtext (

330: aname => 'ERROR_FLAG',
331: avalue => l_error_flag
332: );
333:
334: wf_engine.setitemattrtext (
335: itemtype => p_wf_item_type,
336: itemkey => l_itemkey,
337: aname => 'USER',
338: avalue => l_approver

Line 341: wf_engine.setitemattrtext (

337: aname => 'USER',
338: avalue => l_approver
339: );
340:
341: wf_engine.setitemattrtext (
342: itemtype => p_wf_item_type,
343: itemkey => l_itemkey,
344: aname => 'REQUESTOR',
345: avalue => l_requestor

Line 348: wf_engine.setitemattrtext (

344: aname => 'REQUESTOR',
345: avalue => l_requestor
346: );
347:
348: wf_engine.setitemattrtext (
349: itemtype => p_wf_item_type,
350: itemkey => l_itemkey,
351: aname => 'ATTRIBUTE_ACCESS_LEVEL',
352: avalue => l_attr_access_level

Line 355: wf_engine.setitemattrtext (

351: aname => 'ATTRIBUTE_ACCESS_LEVEL',
352: avalue => l_attr_access_level
353: );
354:
355: wf_engine.setitemattrtext (
356: itemtype => p_wf_item_type,
357: itemkey => l_itemkey,
358: aname => 'OBJECT_VERSION_NUMBER',
359: avalue => l_object_version_number

Line 362: wf_engine.setitemattrtext (

358: aname => 'OBJECT_VERSION_NUMBER',
359: avalue => l_object_version_number
360: );
361:
362: wf_engine.setitemattrtext (
363: itemtype => p_wf_item_type,
364: itemkey => l_itemkey,
365: aname => 'CATEGORY',
366: avalue => l_category

Line 369: wf_engine.setitemattrtext (

365: aname => 'CATEGORY',
366: avalue => l_category
367: );
368:
369: wf_engine.setitemattrtext (
370: itemtype => p_wf_item_type,
371: itemkey => l_itemkey,
372: aname => 'ADDRESS_ID',
373: avalue => l_new_address_id

Line 376: wf_engine.setitemattrtext (

372: aname => 'ADDRESS_ID',
373: avalue => l_new_address_id
374: );
375:
376: wf_engine.setitemattrtext (
377: itemtype => p_wf_item_type,
378: itemkey => l_itemkey,
379: aname => 'OLD_ADDRESS',
380: avalue => l_old_address

Line 383: wf_engine.setitemattrtext (

379: aname => 'OLD_ADDRESS',
380: avalue => l_old_address
381: );
382:
383: wf_engine.setitemattrtext (
384: itemtype => p_wf_item_type,
385: itemkey => l_itemkey,
386: aname => 'NEW_ADDRESS',
387: avalue => l_new_address

Line 390: wf_engine.setitemattrtext (

386: aname => 'NEW_ADDRESS',
387: avalue => l_new_address
388: );
389:
390: wf_engine.setitemattrtext (
391: itemtype => p_wf_item_type,
392: itemkey => l_itemkey,
393: aname => 'RESOURCE_ID',
394: avalue => l_resource_id

Line 397: wf_engine.setitemattrtext (

393: aname => 'RESOURCE_ID',
394: avalue => l_resource_id
395: );
396:
397: wf_engine.setitemattrtext (
398: itemtype => p_wf_item_type,
399: itemkey => l_itemkey,
400: aname => 'RESOURCE_NUMBER',
401: avalue => l_resource_number

Line 404: wf_engine.setitemattrtext (

400: aname => 'RESOURCE_NUMBER',
401: avalue => l_resource_number
402: );
403:
404: wf_engine.setitemattrtext (
405: itemtype => p_wf_item_type,
406: itemkey => l_itemkey,
407: aname => 'SOURCE_NUMBER',
408: avalue => l_source_number

Line 411: wf_engine.setitemattrtext (

407: aname => 'SOURCE_NUMBER',
408: avalue => l_source_number
409: );
410:
411: wf_engine.setitemattrtext (
412: itemtype => p_wf_item_type,
413: itemkey => l_itemkey,
414: aname => 'SOURCE_NAME',
415: avalue => l_source_name

Line 418: wf_engine.setitemattrtext (

414: aname => 'SOURCE_NAME',
415: avalue => l_source_name
416: );
417:
418: wf_engine.setitemattrtext (
419: itemtype => p_wf_item_type,
420: itemkey => l_itemkey,
421: aname => 'RESOURCE_NAME',
422: avalue => l_old_resource_name

Line 425: wf_engine.setitemattrtext (

421: aname => 'RESOURCE_NAME',
422: avalue => l_old_resource_name
423: );
424:
425: wf_engine.setitemattrtext (
426: itemtype => p_wf_item_type,
427: itemkey => l_itemkey,
428: aname => 'RESOURCE_NAME_NEW',
429: avalue => l_new_resource_name

Line 432: wf_engine.setitemattrtext (

428: aname => 'RESOURCE_NAME_NEW',
429: avalue => l_new_resource_name
430: );
431:
432: wf_engine.setitemattrtext (
433: itemtype => p_wf_item_type,
434: itemkey => l_itemkey,
435: aname => 'PHONE_NUMBER',
436: avalue => l_old_phone_number

Line 439: wf_engine.setitemattrtext (

435: aname => 'PHONE_NUMBER',
436: avalue => l_old_phone_number
437: );
438:
439: wf_engine.setitemattrtext (
440: itemtype => p_wf_item_type,
441: itemkey => l_itemkey,
442: aname => 'PHONE_NUMBER_NEW',
443: avalue => l_new_phone_number

Line 446: wf_engine.setitemattrtext (

442: aname => 'PHONE_NUMBER_NEW',
443: avalue => l_new_phone_number
444: );
445:
446: wf_engine.setitemattrtext (
447: itemtype => p_wf_item_type,
448: itemkey => l_itemkey,
449: aname => 'EMAIL_ADDRESS',
450: avalue => l_old_email_address

Line 453: wf_engine.setitemattrtext (

449: aname => 'EMAIL_ADDRESS',
450: avalue => l_old_email_address
451: );
452:
453: wf_engine.setitemattrtext (
454: itemtype => p_wf_item_type,
455: itemkey => l_itemkey,
456: aname => 'EMAIL_ADDRESS_NEW',
457: avalue => l_new_email_address

Line 460: wf_engine.setitemattrtext (

456: aname => 'EMAIL_ADDRESS_NEW',
457: avalue => l_new_email_address
458: );
459:
460: wf_engine.setitemattrtext (
461: itemtype => p_wf_item_type,
462: itemkey => l_itemkey,
463: aname => 'SOURCE_OFFICE',
464: avalue => l_old_source_office

Line 467: wf_engine.setitemattrtext (

463: aname => 'SOURCE_OFFICE',
464: avalue => l_old_source_office
465: );
466:
467: wf_engine.setitemattrtext (
468: itemtype => p_wf_item_type,
469: itemkey => l_itemkey,
470: aname => 'SOURCE_OFFICE_NEW',
471: avalue => l_new_source_office

Line 474: wf_engine.setitemattrtext (

470: aname => 'SOURCE_OFFICE_NEW',
471: avalue => l_new_source_office
472: );
473:
474: wf_engine.setitemattrtext (
475: itemtype => p_wf_item_type,
476: itemkey => l_itemkey,
477: aname => 'SOURCE_LOCATION',
478: avalue => l_old_source_location

Line 481: wf_engine.setitemattrtext (

477: aname => 'SOURCE_LOCATION',
478: avalue => l_old_source_location
479: );
480:
481: wf_engine.setitemattrtext (
482: itemtype => p_wf_item_type,
483: itemkey => l_itemkey,
484: aname => 'SOURCE_LOCATION_NEW',
485: avalue => l_new_source_location

Line 488: wf_engine.setitemattrtext (

484: aname => 'SOURCE_LOCATION_NEW',
485: avalue => l_new_source_location
486: );
487:
488: wf_engine.setitemattrtext (
489: itemtype => p_wf_item_type,
490: itemkey => l_itemkey,
491: aname => 'SOURCE_MAILSTOP',
492: avalue => l_old_source_mailstop

Line 495: wf_engine.setitemattrtext (

491: aname => 'SOURCE_MAILSTOP',
492: avalue => l_old_source_mailstop
493: );
494:
495: wf_engine.setitemattrtext (
496: itemtype => p_wf_item_type,
497: itemkey => l_itemkey,
498: aname => 'SOURCE_MAILSTOP_NEW',
499: avalue => l_new_source_mailstop

Line 502: wf_engine.setitemattrtext (

498: aname => 'SOURCE_MAILSTOP_NEW',
499: avalue => l_new_source_mailstop
500: );
501:
502: wf_engine.setitemattrtext (
503: itemtype => p_wf_item_type,
504: itemkey => l_itemkey,
505: aname => 'SOURCE_MOBILE_PHONE',
506: avalue => l_old_source_mobile_phone

Line 509: wf_engine.setitemattrtext (

505: aname => 'SOURCE_MOBILE_PHONE',
506: avalue => l_old_source_mobile_phone
507: );
508:
509: wf_engine.setitemattrtext (
510: itemtype => p_wf_item_type,
511: itemkey => l_itemkey,
512: aname => 'SOURCE_MOBILE_PHONE_NEW',
513: avalue => l_new_source_mobile_phone

Line 516: wf_engine.setitemattrtext (

512: aname => 'SOURCE_MOBILE_PHONE_NEW',
513: avalue => l_new_source_mobile_phone
514: );
515:
516: wf_engine.setitemattrtext (
517: itemtype => p_wf_item_type,
518: itemkey => l_itemkey,
519: aname => 'SOURCE_PAGER',
520: avalue => l_old_source_pager

Line 523: wf_engine.setitemattrtext (

519: aname => 'SOURCE_PAGER',
520: avalue => l_old_source_pager
521: );
522:
523: wf_engine.setitemattrtext (
524: itemtype => p_wf_item_type,
525: itemkey => l_itemkey,
526: aname => 'SOURCE_PAGER_NEW',
527: avalue => l_new_source_pager

Line 530: wf_engine.setitemattrtext (

526: aname => 'SOURCE_PAGER_NEW',
527: avalue => l_new_source_pager
528: );
529:
530: wf_engine.setitemattrtext (
531: itemtype => p_wf_item_type,
532: itemkey => l_itemkey,
533: aname => 'TIME_ZONE',
534: avalue => l_new_time_zone

Line 537: wf_engine.setitemattrtext (

533: aname => 'TIME_ZONE',
534: avalue => l_new_time_zone
535: );
536:
537: wf_engine.setitemattrtext (
538: itemtype => p_wf_item_type,
539: itemkey => l_itemkey,
540: aname => 'TIMEZONE_NAME',
541: avalue => l_old_timezone_name

Line 544: wf_engine.setitemattrtext (

540: aname => 'TIMEZONE_NAME',
541: avalue => l_old_timezone_name
542: );
543:
544: wf_engine.setitemattrtext (
545: itemtype => p_wf_item_type,
546: itemkey => l_itemkey,
547: aname => 'TIMEZONE_NAME_NEW',
548: avalue => l_new_timezone_name

Line 551: wf_engine.setitemattrtext (

547: aname => 'TIMEZONE_NAME_NEW',
548: avalue => l_new_timezone_name
549: );
550:
551: wf_engine.setitemattrtext (
552: itemtype => p_wf_item_type,
553: itemkey => l_itemkey,
554: aname => 'SUPPORT_SITE_ID',
555: avalue => l_new_support_site_id

Line 558: wf_engine.setitemattrtext (

554: aname => 'SUPPORT_SITE_ID',
555: avalue => l_new_support_site_id
556: );
557:
558: wf_engine.setitemattrtext (
559: itemtype => p_wf_item_type,
560: itemkey => l_itemkey,
561: aname => 'SUPPORT_SITE',
562: avalue => l_old_support_site

Line 565: wf_engine.setitemattrtext (

561: aname => 'SUPPORT_SITE',
562: avalue => l_old_support_site
563: );
564:
565: wf_engine.setitemattrtext (
566: itemtype => p_wf_item_type,
567: itemkey => l_itemkey,
568: aname => 'SUPPORT_SITE_NEW',
569: avalue => l_new_support_site

Line 572: wf_engine.setitemattrtext (

568: aname => 'SUPPORT_SITE_NEW',
569: avalue => l_new_support_site
570: );
571:
572: wf_engine.setitemattrtext (
573: itemtype => p_wf_item_type,
574: itemkey => l_itemkey,
575: aname => 'PRIMARY_LANGUAGE',
576: avalue => l_old_primary_language

Line 579: wf_engine.setitemattrtext (

575: aname => 'PRIMARY_LANGUAGE',
576: avalue => l_old_primary_language
577: );
578:
579: wf_engine.setitemattrtext (
580: itemtype => p_wf_item_type,
581: itemkey => l_itemkey,
582: aname => 'PRIMARY_LANGUAGE_NEW',
583: avalue => l_new_primary_language

Line 586: wf_engine.setitemattrtext (

582: aname => 'PRIMARY_LANGUAGE_NEW',
583: avalue => l_new_primary_language
584: );
585:
586: wf_engine.setitemattrtext (
587: itemtype => p_wf_item_type,
588: itemkey => l_itemkey,
589: aname => 'SECONDARY_LANGUAGE',
590: avalue => l_old_secondary_language

Line 593: wf_engine.setitemattrtext (

589: aname => 'SECONDARY_LANGUAGE',
590: avalue => l_old_secondary_language
591: );
592:
593: wf_engine.setitemattrtext (
594: itemtype => p_wf_item_type,
595: itemkey => l_itemkey,
596: aname => 'SECONDARY_LANGUAGE_NEW',
597: avalue => l_new_secondary_language

Line 600: wf_engine.setitemattrtext (

596: aname => 'SECONDARY_LANGUAGE_NEW',
597: avalue => l_new_secondary_language
598: );
599:
600: wf_engine.setitemattrtext (
601: itemtype => p_wf_item_type,
602: itemkey => l_itemkey,
603: aname => 'COST_PER_HR',
604: avalue => l_old_cost_per_hr

Line 607: wf_engine.setitemattrtext (

603: aname => 'COST_PER_HR',
604: avalue => l_old_cost_per_hr
605: );
606:
607: wf_engine.setitemattrtext (
608: itemtype => p_wf_item_type,
609: itemkey => l_itemkey,
610: aname => 'COST_PER_HR_NEW',
611: avalue => l_new_cost_per_hr

Line 614: wf_engine.startprocess (

610: aname => 'COST_PER_HR_NEW',
611: avalue => l_new_cost_per_hr
612: );
613:
614: wf_engine.startprocess (
615: itemtype => p_wf_item_type,
616: itemkey => l_itemkey
617: );
618:

Line 675: wf_engine.getitemattrtext (

671: --
672: -- Return process to run
673: --
674: l_resultout :=
675: wf_engine.getitemattrtext (
676: itemtype => itemtype,
677: itemkey => itemkey,
678: aname => 'ERROR_FLAG'
679: );

Line 743: wf_engine.getitemattrtext (

739: --
740: -- Return process to run
741: --
742: l_resultout :=
743: wf_engine.getitemattrtext (
744: itemtype => itemtype,
745: itemkey => itemkey,
746: aname => 'ATTRIBUTE_ACCESS_LEVEL'
747: );

Line 840: wf_engine.getitemattrtext (

836: -- Return process to run
837: --
838:
839: l_resource_id :=
840: wf_engine.getitemattrtext (
841: itemtype => itemtype,
842: itemkey => itemkey,
843: aname => 'RESOURCE_ID'
844: );

Line 847: wf_engine.getitemattrtext (

843: aname => 'RESOURCE_ID'
844: );
845:
846: l_address_id :=
847: wf_engine.getitemattrtext (
848: itemtype => itemtype,
849: itemkey => itemkey,
850: aname => 'ADDRESS_ID'
851: );

Line 853: wf_engine.getitemattrtext (

849: itemkey => itemkey,
850: aname => 'ADDRESS_ID'
851: );
852: l_resource_number :=
853: wf_engine.getitemattrtext (
854: itemtype => itemtype,
855: itemkey => itemkey,
856: aname => 'RESOURCE_NUMBER'
857: );

Line 859: wf_engine.getitemattrtext (

855: itemkey => itemkey,
856: aname => 'RESOURCE_NUMBER'
857: );
858: l_source_name :=
859: wf_engine.getitemattrtext (
860: itemtype => itemtype,
861: itemkey => itemkey,
862: aname => 'SOURCE_NAME'
863: );

Line 865: wf_engine.getitemattrtext (

861: itemkey => itemkey,
862: aname => 'SOURCE_NAME'
863: );
864: l_approved :=
865: wf_engine.getitemattrtext (
866: itemtype => itemtype,
867: itemkey => itemkey,
868: aname => 'P_APPROVED'
869: );

Line 871: wf_engine.getitemattrtext (

867: itemkey => itemkey,
868: aname => 'P_APPROVED'
869: );
870: l_resource_name :=
871: wf_engine.getitemattrtext (
872: itemtype => itemtype,
873: itemkey => itemkey,
874: aname => 'RESOURCE_NAME_NEW'
875: );

Line 877: wf_engine.getitemattrtext (

873: itemkey => itemkey,
874: aname => 'RESOURCE_NAME_NEW'
875: );
876: l_source_phone :=
877: wf_engine.getitemattrtext (
878: itemtype => itemtype,
879: itemkey => itemkey,
880: aname => 'PHONE_NUMBER_NEW'
881: );

Line 883: wf_engine.getitemattrtext (

879: itemkey => itemkey,
880: aname => 'PHONE_NUMBER_NEW'
881: );
882: l_source_email :=
883: wf_engine.getitemattrtext (
884: itemtype => itemtype,
885: itemkey => itemkey,
886: aname => 'EMAIL_ADDRESS_NEW'
887: );

Line 889: wf_engine.getitemattrtext (

885: itemkey => itemkey,
886: aname => 'EMAIL_ADDRESS_NEW'
887: );
888: l_source_location :=
889: wf_engine.getitemattrtext (
890: itemtype => itemtype,
891: itemkey => itemkey,
892: aname => 'SOURCE_LOCATION_NEW'
893: );

Line 895: wf_engine.getitemattrtext (

891: itemkey => itemkey,
892: aname => 'SOURCE_LOCATION_NEW'
893: );
894: l_source_office :=
895: wf_engine.getitemattrtext (
896: itemtype => itemtype,
897: itemkey => itemkey,
898: aname => 'SOURCE_OFFICE_NEW'
899: );

Line 901: wf_engine.getitemattrtext (

897: itemkey => itemkey,
898: aname => 'SOURCE_OFFICE_NEW'
899: );
900: l_source_mailstop :=
901: wf_engine.getitemattrtext (
902: itemtype => itemtype,
903: itemkey => itemkey,
904: aname => 'SOURCE_MAILSTOP_NEW'
905: );

Line 907: wf_engine.getitemattrtext (

903: itemkey => itemkey,
904: aname => 'SOURCE_MAILSTOP_NEW'
905: );
906: l_source_mobile_phone :=
907: wf_engine.getitemattrtext (
908: itemtype => itemtype,
909: itemkey => itemkey,
910: aname => 'SOURCE_MOBILE_PHONE_NEW'
911: );

Line 913: wf_engine.getitemattrtext (

909: itemkey => itemkey,
910: aname => 'SOURCE_MOBILE_PHONE_NEW'
911: );
912: l_source_pager :=
913: wf_engine.getitemattrtext (
914: itemtype => itemtype,
915: itemkey => itemkey,
916: aname => 'SOURCE_PAGER_NEW'
917: );

Line 919: wf_engine.getitemattrtext (

915: itemkey => itemkey,
916: aname => 'SOURCE_PAGER_NEW'
917: );
918: l_time_zone :=
919: wf_engine.getitemattrtext (
920: itemtype => itemtype,
921: itemkey => itemkey,
922: aname => 'TIME_ZONE'
923: );

Line 925: wf_engine.getitemattrtext (

921: itemkey => itemkey,
922: aname => 'TIME_ZONE'
923: );
924: l_support_site_id :=
925: wf_engine.getitemattrtext (
926: itemtype => itemtype,
927: itemkey => itemkey,
928: aname => 'SUPPORT_SITE_ID'
929: );

Line 931: wf_engine.getitemattrtext (

927: itemkey => itemkey,
928: aname => 'SUPPORT_SITE_ID'
929: );
930: l_primary_language :=
931: wf_engine.getitemattrtext (
932: itemtype => itemtype,
933: itemkey => itemkey,
934: aname => 'PRIMARY_LANGUAGE_NEW'
935: );

Line 937: wf_engine.getitemattrtext (

933: itemkey => itemkey,
934: aname => 'PRIMARY_LANGUAGE_NEW'
935: );
936: l_secondary_language :=
937: wf_engine.getitemattrtext (
938: itemtype => itemtype,
939: itemkey => itemkey,
940: aname => 'SECONDARY_LANGUAGE_NEW'
941: );

Line 943: wf_engine.getitemattrtext (

939: itemkey => itemkey,
940: aname => 'SECONDARY_LANGUAGE_NEW'
941: );
942: l_cost_per_hr :=
943: wf_engine.getitemattrtext (
944: itemtype => itemtype,
945: itemkey => itemkey,
946: aname => 'COST_PER_HR_NEW'
947: );

Line 949: wf_engine.getitemattrtext (

945: itemkey => itemkey,
946: aname => 'COST_PER_HR_NEW'
947: );
948: l_object_version_number :=
949: wf_engine.getitemattrtext (
950: itemtype => itemtype,
951: itemkey => itemkey,
952: aname => 'OBJECT_VERSION_NUMBER'
953: );

Line 995: wf_engine.setitemattrtext (

991: --dbms_output.put_line(l_msg_data);
992: l_msg_data1 := l_msg_data1 ||''|| l_msg_data;
993: end loop;
994:
995: wf_engine.setitemattrtext (
996: itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'ERROR_MESSAGE',
999: avalue => l_msg_data1