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.OZF_REQUEST_STATUS_PVT dependencies on WF_ENGINE

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

407:
408: ozf_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );
409: ozf_utility_pvt.debug_message( 'Phone number is ' || l_partner_cont_phone );
410:
411: wf_engine.SetItemAttrText( itemtype => p_itemtype,
412: itemkey => p_itemKey,
413: aname => 'REQUEST_NUMBER',
414: avalue => l_request_number);
415:

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

412: itemkey => p_itemKey,
413: aname => 'REQUEST_NUMBER',
414: avalue => l_request_number);
415:
416: wf_engine.SetItemAttrText( itemtype => p_itemtype,
417: itemkey => p_itemKey,
418: aname => 'REQUEST_NAME',
419: avalue => l_request_name);
420:

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

417: itemkey => p_itemKey,
418: aname => 'REQUEST_NAME',
419: avalue => l_request_name);
420:
421: wf_engine.SetItemAttrText( itemtype => p_itemtype,
422: itemkey => p_itemKey,
423: aname => 'REQUESTER_NAME',
424: avalue => l_partner_cont_name --l_creator_name -- Bug 4460277
425: );

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

423: aname => 'REQUESTER_NAME',
424: avalue => l_partner_cont_name --l_creator_name -- Bug 4460277
425: );
426:
427: wf_engine.SetItemAttrText( itemtype => p_itemtype,
428: itemkey => p_itemKey,
429: aname => 'REQUEST_STATUS',
430: avalue => l_entity_status);
431:

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

428: itemkey => p_itemKey,
429: aname => 'REQUEST_STATUS',
430: avalue => l_entity_status);
431:
432: wf_engine.SetItemAttrDate( itemtype => p_itemtype,
433: itemkey => p_itemKey,
434: aname => 'REQUEST_CREATION_DATE',
435: avalue => l_entity_creation_date);
436:

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

433: itemkey => p_itemKey,
434: aname => 'REQUEST_CREATION_DATE',
435: avalue => l_entity_creation_date);
436:
437: wf_engine.SetItemAttrText( itemtype => p_itemtype,
438: itemkey => p_itemKey,
439: aname => 'REQUEST_AMOUNT',
440: avalue => l_comp_amount);
441:

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

438: itemkey => p_itemKey,
439: aname => 'REQUEST_AMOUNT',
440: avalue => l_comp_amount);
441:
442: wf_engine.SetItemAttrText( itemtype => p_itemtype,
443: itemkey => p_itemKey,
444: aname => 'PARTNER_ORG_NAME',
445: avalue => l_partner_org_name);
446:

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

443: itemkey => p_itemKey,
444: aname => 'PARTNER_ORG_NAME',
445: avalue => l_partner_org_name);
446:
447: wf_engine.SetItemAttrText( itemtype => p_itemtype,
448: itemkey => p_itemKey,
449: aname => 'PARTNER_CONTACT',
450: avalue => l_partner_cont_name);
451:

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

448: itemkey => p_itemKey,
449: aname => 'PARTNER_CONTACT',
450: avalue => l_partner_cont_name);
451:
452: wf_engine.SetItemAttrText( itemtype => p_itemtype,
453: itemkey => p_itemKey,
454: aname => 'PARTNER_CONTACT_PHONE',
455: avalue => l_partner_cont_phone);
456:

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

453: itemkey => p_itemKey,
454: aname => 'PARTNER_CONTACT_PHONE',
455: avalue => l_partner_cont_phone);
456:
457: wf_engine.SetItemAttrText( itemtype => p_itemtype,
458: itemkey => p_itemKey,
459: aname => 'PARTNER_CONTACT_EMAIL',
460: avalue => l_partner_cont_email);
461:

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

458: itemkey => p_itemKey,
459: aname => 'PARTNER_CONTACT_EMAIL',
460: avalue => l_partner_cont_email);
461:
462: wf_engine.SetItemAttrText( itemtype => p_itemtype,
463: itemkey => p_itemKey,
464: aname => 'LAST_APPROVER_NAME',
465: avalue => l_last_approver_name);
466:

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

463: itemkey => p_itemKey,
464: aname => 'LAST_APPROVER_NAME',
465: avalue => l_last_approver_name);
466:
467: wf_engine.SetItemAttrText( itemtype => p_itemtype,
468: itemkey => p_itemKey,
469: aname => 'AGREEMENT NUMBER',
470: avalue => l_agreement_number);
471:

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

468: itemkey => p_itemKey,
469: aname => 'AGREEMENT NUMBER',
470: avalue => l_agreement_number);
471:
472: wf_engine.SetItemAttrText( itemtype => p_itemtype,
473: itemkey => p_itemKey,
474: aname => 'AUTHORIZATION_CODE',
475: avalue => l_authorization_code);
476:

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

473: itemkey => p_itemKey,
474: aname => 'AUTHORIZATION_CODE',
475: avalue => l_authorization_code);
476:
477: wf_engine.SetItemAttrText( itemtype => p_itemtype,
478: itemkey => p_itemKey,
479: aname => 'REQUEST_START_DATE',
480: avalue => l_start_date);
481:

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

478: itemkey => p_itemKey,
479: aname => 'REQUEST_START_DATE',
480: avalue => l_start_date);
481:
482: wf_engine.SetItemAttrText( itemtype => p_itemtype,
483: itemkey => p_itemKey,
484: aname => 'REQUEST_END_DATE',
485: avalue => l_end_date);
486:

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

483: itemkey => p_itemKey,
484: aname => 'REQUEST_END_DATE',
485: avalue => l_end_date);
486:
487: wf_engine.SetItemAttrText( itemtype => p_itemtype,
488: itemkey => p_itemKey,
489: aname => 'LAST_NOTE',
490: avalue => l_notes_varchar);
491:

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

488: itemkey => p_itemKey,
489: aname => 'LAST_NOTE',
490: avalue => l_notes_varchar);
491:
492: wf_engine.SetItemAttrText( itemtype => p_itemtype,
493: itemkey => p_itemKey,
494: aname => 'VENDOR_ORG_NAME',
495: avalue => l_vendor_name);
496:

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

512: 'clickNotifLink=Y' || '&' ||
513: 'addBreadCrumb=Y');
514: --Bug# 8208686 fixed by ateotia(-)
515:
516: wf_engine.SetItemAttrText( itemtype => p_itemtype,
517: itemkey => p_itemKey,
518: aname => 'VENDOR_LOGIN_URL',
519: avalue => l_vendor_url );
520:

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

544: if length(l_partner_profile_url) > 0 then -- if profile is set, use it for partner URL
545: l_partner_url := l_partner_profile_url || substr(l_partner_url, instr(l_partner_url,'/',1,3));
546: end if;
547:
548: wf_engine.SetItemAttrText( itemtype => p_itemtype,
549: itemkey => p_itemKey,
550: aname => 'PARTNER_LOGIN_URL',
551: avalue => l_partner_url );
552:

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

574: 'addBreadCrumb=Y';
575: --Bug# 8208686 fixed by ateotia(-)
576:
577: -- Setting the attribute value for updated projects URL
578: wf_engine.SetItemAttrText( itemtype => p_itemtype,
579: itemkey => p_itemKey,
580: aname => 'VENDOR_DTAIL_URL',
581: avalue => l_vendor_dtail_url);
582:

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

579: itemkey => p_itemKey,
580: aname => 'VENDOR_DTAIL_URL',
581: avalue => l_vendor_dtail_url);
582:
583: wf_engine.SetItemAttrText( itemtype => p_itemtype,
584: itemkey => p_itemKey,
585: aname => 'PARTNER_DTAIL_URL',
586: avalue => l_partner_dtail_url);
587:

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

587:
588:
589: IF l_decline_code IS NOT NULL THEN
590: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SP_REQUEST_DECLINE_CODE',l_decline_code);
591: wf_engine.SetItemAttrText( itemtype => p_itemtype,
592: itemkey => p_itemKey,
593: aname => 'DECLINE_REASON',
594: avalue => l_decline_meaning);
595: END IF;

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

600: open lc_media_name(pc_media_id => l_activity_media_id);
601: fetch lc_media_name into l_activity_name;
602: close lc_media_name;
603:
604: wf_engine.SetItemAttrText( itemtype => p_itemtype,
605: itemkey => p_itemKey,
606: aname => 'REQUEST_NUMBER',
607: avalue => l_request_number);
608:

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

605: itemkey => p_itemKey,
606: aname => 'REQUEST_NUMBER',
607: avalue => l_request_number);
608:
609: wf_engine.SetItemAttrText( itemtype => p_itemtype,
610: itemkey => p_itemKey,
611: aname => 'REQUEST_NAME',
612: avalue => l_request_name);
613:

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

610: itemkey => p_itemKey,
611: aname => 'REQUEST_NAME',
612: avalue => l_request_name);
613:
614: wf_engine.SetItemAttrText( itemtype => p_itemtype,
615: itemkey => p_itemKey,
616: aname => 'REQUESTER_NAME',
617: avalue => l_partner_cont_name); --l_creator_name -- Bug 4460277
618:

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

615: itemkey => p_itemKey,
616: aname => 'REQUESTER_NAME',
617: avalue => l_partner_cont_name); --l_creator_name -- Bug 4460277
618:
619: wf_engine.SetItemAttrText( itemtype => p_itemtype,
620: itemkey => p_itemKey,
621: aname => 'REQUEST_STATUS',
622: avalue => l_entity_status);
623:

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

620: itemkey => p_itemKey,
621: aname => 'REQUEST_STATUS',
622: avalue => l_entity_status);
623:
624: wf_engine.SetItemAttrDate( itemtype => p_itemtype,
625: itemkey => p_itemKey,
626: aname => 'REQUEST_CREATION_DATE',
627: avalue => l_entity_creation_date);
628:

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

625: itemkey => p_itemKey,
626: aname => 'REQUEST_CREATION_DATE',
627: avalue => l_entity_creation_date);
628:
629: wf_engine.SetItemAttrText( itemtype => p_itemtype,
630: itemkey => p_itemKey,
631: aname => 'REQUEST_AMOUNT',
632: avalue => l_comp_amount);
633:

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

630: itemkey => p_itemKey,
631: aname => 'REQUEST_AMOUNT',
632: avalue => l_comp_amount);
633:
634: wf_engine.SetItemAttrText( itemtype => p_itemtype,
635: itemkey => p_itemKey,
636: aname => 'PARTNER_ORG_NAME',
637: avalue => l_partner_org_name);
638:

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

635: itemkey => p_itemKey,
636: aname => 'PARTNER_ORG_NAME',
637: avalue => l_partner_org_name);
638:
639: wf_engine.SetItemAttrText( itemtype => p_itemtype,
640: itemkey => p_itemKey,
641: aname => 'PARTNER_CONTACT',
642: avalue => l_partner_cont_name);
643:

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

640: itemkey => p_itemKey,
641: aname => 'PARTNER_CONTACT',
642: avalue => l_partner_cont_name);
643:
644: wf_engine.SetItemAttrText( itemtype => p_itemtype,
645: itemkey => p_itemKey,
646: aname => 'LAST_APPROVER_NAME',
647: avalue => l_last_approver_name);
648:

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

645: itemkey => p_itemKey,
646: aname => 'LAST_APPROVER_NAME',
647: avalue => l_last_approver_name);
648:
649: wf_engine.SetItemAttrText( itemtype => p_itemtype,
650: itemkey => p_itemKey,
651: aname => 'REQUEST_START_DATE',
652: avalue => l_start_date);
653:

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

650: itemkey => p_itemKey,
651: aname => 'REQUEST_START_DATE',
652: avalue => l_start_date);
653:
654: wf_engine.SetItemAttrText( itemtype => p_itemtype,
655: itemkey => p_itemKey,
656: aname => 'REQUEST_END_DATE',
657: avalue => l_end_date);
658:

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

655: itemkey => p_itemKey,
656: aname => 'REQUEST_END_DATE',
657: avalue => l_end_date);
658:
659: wf_engine.SetItemAttrText( itemtype => p_itemtype,
660: itemkey => p_itemKey,
661: aname => 'LAST_NOTE',
662: avalue => l_notes_varchar);
663:

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

660: itemkey => p_itemKey,
661: aname => 'LAST_NOTE',
662: avalue => l_notes_varchar);
663:
664: wf_engine.SetItemAttrText( itemtype => p_itemtype,
665: itemkey => p_itemKey,
666: aname => 'ACTIVITY_NAME',
667: avalue => l_activity_name);
668:

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

665: itemkey => p_itemKey,
666: aname => 'ACTIVITY_NAME',
667: avalue => l_activity_name);
668:
669: wf_engine.SetItemAttrText( itemtype => p_itemtype,
670: itemkey => p_itemKey,
671: aname => 'VENDOR_ORG_NAME',
672: avalue => l_vendor_name);
673:

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

685: 'OfferId=' || l_offer_id || '&' ||
686: 'StatusCode=' || p_status || '&' ||
687: 'ApprovePriv=1' || '&' || 'pgMode=VDT');
688:
689: wf_engine.SetItemAttrText( itemtype => p_itemtype,
690: itemkey => p_itemKey,
691: aname => 'VENDOR_LOGIN_URL',
692: avalue => l_vendor_url );
693:

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

709: if length(l_partner_profile_url) > 0 then -- if profile is set, use it for partner URL
710: l_partner_url := l_partner_profile_url || substr(l_partner_url, instr(l_partner_url,'/',1,3));
711: end if;
712:
713: wf_engine.SetItemAttrText( itemtype => p_itemtype,
714: itemkey => p_itemKey,
715: aname => 'PARTNER_LOGIN_URL',
716: avalue => l_partner_url );
717:

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

728: 'pgMode=PDT';
729:
730:
731: -- Setting the attribute value for updated projects URL
732: wf_engine.SetItemAttrText( itemtype => p_itemtype,
733: itemkey => p_itemKey,
734: aname => 'VENDOR_DTAIL_URL',
735: avalue => l_vendor_dtail_url);
736:

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

733: itemkey => p_itemKey,
734: aname => 'VENDOR_DTAIL_URL',
735: avalue => l_vendor_dtail_url);
736:
737: wf_engine.SetItemAttrText( itemtype => p_itemtype,
738: itemkey => p_itemKey,
739: aname => 'PARTNER_DTAIL_URL',
740: avalue => l_partner_dtail_url);
741:

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

740: avalue => l_partner_dtail_url);
741:
742: IF l_decline_code IS NOT NULL THEN
743: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_DECLINE_CODE',l_decline_code);
744: wf_engine.SetItemAttrText( itemtype => p_itemtype,
745: itemkey => p_itemKey,
746: aname => 'DECLINE_REASON',
747: avalue => l_decline_meaning);
748: ozf_utility_pvt.debug_message( l_decline_meaning||': l_decline_meaning');

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

749: END IF;
750:
751: IF l_return_code IS NOT NULL AND l_return_code <> '' THEN
752: l_return_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_RETURN_CODE',l_return_code);
753: wf_engine.SetItemAttrText( itemtype => p_itemtype,
754: itemkey => p_itemKey,
755: aname => 'RETURN_REASON',
756: avalue => l_return_code);
757: END IF;