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

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

397: if p_itemtype = 'OZFSPBEN' then
398: ozf_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );
399: ozf_utility_pvt.debug_message( 'Phone number is ' || l_partner_cont_phone );
400:
401: wf_engine.SetItemAttrText( itemtype => p_itemtype,
402: itemkey => p_itemKey,
403: aname => 'REQUEST_NUMBER',
404: avalue => l_request_number);
405:

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

402: itemkey => p_itemKey,
403: aname => 'REQUEST_NUMBER',
404: avalue => l_request_number);
405:
406: wf_engine.SetItemAttrText( itemtype => p_itemtype,
407: itemkey => p_itemKey,
408: aname => 'REQUEST_NAME',
409: avalue => l_request_name);
410:

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

407: itemkey => p_itemKey,
408: aname => 'REQUEST_NAME',
409: avalue => l_request_name);
410:
411: wf_engine.SetItemAttrText( itemtype => p_itemtype,
412: itemkey => p_itemKey,
413: aname => 'REQUESTER_NAME',
414: avalue => l_partner_cont_name --l_creator_name -- Bug 4460277
415: );

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

413: aname => 'REQUESTER_NAME',
414: avalue => l_partner_cont_name --l_creator_name -- Bug 4460277
415: );
416:
417: wf_engine.SetItemAttrText( itemtype => p_itemtype,
418: itemkey => p_itemKey,
419: aname => 'REQUEST_STATUS',
420: avalue => l_entity_status);
421: wf_engine.SetItemAttrDate( itemtype => p_itemtype,

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

417: wf_engine.SetItemAttrText( itemtype => p_itemtype,
418: itemkey => p_itemKey,
419: aname => 'REQUEST_STATUS',
420: avalue => l_entity_status);
421: wf_engine.SetItemAttrDate( itemtype => p_itemtype,
422: itemkey => p_itemKey,
423: aname => 'REQUEST_CREATION_DATE',
424: avalue => l_entity_creation_date);
425:

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

422: itemkey => p_itemKey,
423: aname => 'REQUEST_CREATION_DATE',
424: avalue => l_entity_creation_date);
425:
426: wf_engine.SetItemAttrText( itemtype => p_itemtype,
427: itemkey => p_itemKey,
428: aname => 'REQUEST_AMOUNT',
429: avalue => l_comp_amount);
430: wf_engine.SetItemAttrText( itemtype => p_itemtype,

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

426: wf_engine.SetItemAttrText( itemtype => p_itemtype,
427: itemkey => p_itemKey,
428: aname => 'REQUEST_AMOUNT',
429: avalue => l_comp_amount);
430: wf_engine.SetItemAttrText( itemtype => p_itemtype,
431: itemkey => p_itemKey,
432: aname => 'PARTNER_ORG_NAME',
433: avalue => l_partner_org_name);
434:

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

431: itemkey => p_itemKey,
432: aname => 'PARTNER_ORG_NAME',
433: avalue => l_partner_org_name);
434:
435: wf_engine.SetItemAttrText( itemtype => p_itemtype,
436: itemkey => p_itemKey,
437: aname => 'PARTNER_CONTACT',
438: avalue => l_partner_cont_name);
439: wf_engine.SetItemAttrText( itemtype => p_itemtype,

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

435: wf_engine.SetItemAttrText( itemtype => p_itemtype,
436: itemkey => p_itemKey,
437: aname => 'PARTNER_CONTACT',
438: avalue => l_partner_cont_name);
439: wf_engine.SetItemAttrText( itemtype => p_itemtype,
440: itemkey => p_itemKey,
441: aname => 'PARTNER_CONTACT_PHONE',
442: avalue => l_partner_cont_phone);
443: wf_engine.SetItemAttrText( itemtype => p_itemtype,

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

439: wf_engine.SetItemAttrText( itemtype => p_itemtype,
440: itemkey => p_itemKey,
441: aname => 'PARTNER_CONTACT_PHONE',
442: avalue => l_partner_cont_phone);
443: wf_engine.SetItemAttrText( itemtype => p_itemtype,
444: itemkey => p_itemKey,
445: aname => 'PARTNER_CONTACT_EMAIL',
446: avalue => l_partner_cont_email);
447:

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

444: itemkey => p_itemKey,
445: aname => 'PARTNER_CONTACT_EMAIL',
446: avalue => l_partner_cont_email);
447:
448: wf_engine.SetItemAttrText( itemtype => p_itemtype,
449: itemkey => p_itemKey,
450: aname => 'LAST_APPROVER_NAME',
451: avalue => l_last_approver_name);
452:

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

449: itemkey => p_itemKey,
450: aname => 'LAST_APPROVER_NAME',
451: avalue => l_last_approver_name);
452:
453: wf_engine.SetItemAttrText( itemtype => p_itemtype,
454: itemkey => p_itemKey,
455: aname => 'AGREEMENT NUMBER',
456: avalue => l_agreement_number);
457:

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

454: itemkey => p_itemKey,
455: aname => 'AGREEMENT NUMBER',
456: avalue => l_agreement_number);
457:
458: wf_engine.SetItemAttrText( itemtype => p_itemtype,
459: itemkey => p_itemKey,
460: aname => 'AUTHORIZATION_CODE',
461: avalue => l_authorization_code);
462:

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

459: itemkey => p_itemKey,
460: aname => 'AUTHORIZATION_CODE',
461: avalue => l_authorization_code);
462:
463: wf_engine.SetItemAttrText( itemtype => p_itemtype,
464: itemkey => p_itemKey,
465: aname => 'REQUEST_START_DATE',
466: avalue => l_start_date);
467:

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

464: itemkey => p_itemKey,
465: aname => 'REQUEST_START_DATE',
466: avalue => l_start_date);
467:
468: wf_engine.SetItemAttrText( itemtype => p_itemtype,
469: itemkey => p_itemKey,
470: aname => 'REQUEST_END_DATE',
471: avalue => l_end_date);
472:

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

469: itemkey => p_itemKey,
470: aname => 'REQUEST_END_DATE',
471: avalue => l_end_date);
472:
473: wf_engine.SetItemAttrText( itemtype => p_itemtype,
474: itemkey => p_itemKey,
475: aname => 'LAST_NOTE',
476: avalue => l_notes_varchar);
477:

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

474: itemkey => p_itemKey,
475: aname => 'LAST_NOTE',
476: avalue => l_notes_varchar);
477:
478: wf_engine.SetItemAttrText( itemtype => p_itemtype,
479: itemkey => p_itemKey,
480: aname => 'VENDOR_ORG_NAME',
481: avalue => l_vendor_name);
482:

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

494: 'RequestTypeCode=' || l_request_type_code || '&'||
495: 'OzfPartnerUser=N' || '&'||
496: 'FromPage=Dtail');
497:
498: wf_engine.SetItemAttrText( itemtype => p_itemtype,
499: itemkey => p_itemKey,
500: aname => 'VENDOR_LOGIN_URL',
501: avalue => l_vendor_url );
502:

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

526: l_partner_url := l_partner_profile_url || substr(l_partner_url, instr(l_partner_url,'/',1,3));
527: end if;
528:
529:
530: wf_engine.SetItemAttrText( itemtype => p_itemtype,
531: itemkey => p_itemKey,
532: aname => 'PARTNER_LOGIN_URL',
533: avalue => l_partner_url );
534:

Line 553: wf_engine.SetItemAttrText

549:
550:
551:
552: -- Setting the attribute value for updated projects URL
553: wf_engine.SetItemAttrText
554: ( itemtype => p_itemtype,
555: itemkey => p_itemKey,
556: aname => 'VENDOR_DTAIL_URL',
557: avalue => l_vendor_dtail_url

Line 560: wf_engine.SetItemAttrText

556: aname => 'VENDOR_DTAIL_URL',
557: avalue => l_vendor_dtail_url
558: );
559:
560: wf_engine.SetItemAttrText
561: ( itemtype => p_itemtype,
562: itemkey => p_itemKey,
563: aname => 'PARTNER_DTAIL_URL',
564: avalue => l_partner_dtail_url

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

566:
567:
568: if l_decline_code IS NOT NULL THEN
569: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SP_REQUEST_DECLINE_CODE',l_decline_code);
570: wf_engine.SetItemAttrText( itemtype => p_itemtype,
571: itemkey => p_itemKey,
572: aname => 'DECLINE_REASON',
573: avalue => l_decline_meaning);
574: END IF;

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

579: fetch lc_media_name into l_activity_name;
580: close lc_media_name;
581:
582:
583: wf_engine.SetItemAttrText( itemtype => p_itemtype,
584: itemkey => p_itemKey,
585: aname => 'REQUEST_NUMBER',
586: avalue => l_request_number);
587:

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

584: itemkey => p_itemKey,
585: aname => 'REQUEST_NUMBER',
586: avalue => l_request_number);
587:
588: wf_engine.SetItemAttrText( itemtype => p_itemtype,
589: itemkey => p_itemKey,
590: aname => 'REQUEST_NAME',
591: avalue => l_request_name);
592:

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

589: itemkey => p_itemKey,
590: aname => 'REQUEST_NAME',
591: avalue => l_request_name);
592:
593: wf_engine.SetItemAttrText( itemtype => p_itemtype,
594: itemkey => p_itemKey,
595: aname => 'REQUESTER_NAME',
596: avalue => l_partner_cont_name); --l_creator_name -- Bug 4460277
597:

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

594: itemkey => p_itemKey,
595: aname => 'REQUESTER_NAME',
596: avalue => l_partner_cont_name); --l_creator_name -- Bug 4460277
597:
598: wf_engine.SetItemAttrText( itemtype => p_itemtype,
599: itemkey => p_itemKey,
600: aname => 'REQUEST_STATUS',
601: avalue => l_entity_status);
602:

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

599: itemkey => p_itemKey,
600: aname => 'REQUEST_STATUS',
601: avalue => l_entity_status);
602:
603: wf_engine.SetItemAttrDate( itemtype => p_itemtype,
604: itemkey => p_itemKey,
605: aname => 'REQUEST_CREATION_DATE',
606: avalue => l_entity_creation_date);
607:

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

604: itemkey => p_itemKey,
605: aname => 'REQUEST_CREATION_DATE',
606: avalue => l_entity_creation_date);
607:
608: wf_engine.SetItemAttrText( itemtype => p_itemtype,
609: itemkey => p_itemKey,
610: aname => 'REQUEST_AMOUNT',
611: avalue => l_comp_amount);
612:

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

609: itemkey => p_itemKey,
610: aname => 'REQUEST_AMOUNT',
611: avalue => l_comp_amount);
612:
613: wf_engine.SetItemAttrText( itemtype => p_itemtype,
614: itemkey => p_itemKey,
615: aname => 'PARTNER_ORG_NAME',
616: avalue => l_partner_org_name);
617:

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

614: itemkey => p_itemKey,
615: aname => 'PARTNER_ORG_NAME',
616: avalue => l_partner_org_name);
617:
618: wf_engine.SetItemAttrText( itemtype => p_itemtype,
619: itemkey => p_itemKey,
620: aname => 'PARTNER_CONTACT',
621: avalue => l_partner_cont_name);
622:

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

620: aname => 'PARTNER_CONTACT',
621: avalue => l_partner_cont_name);
622:
623:
624: wf_engine.SetItemAttrText( itemtype => p_itemtype,
625: itemkey => p_itemKey,
626: aname => 'LAST_APPROVER_NAME',
627: avalue => l_last_approver_name);
628:

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

625: itemkey => p_itemKey,
626: aname => 'LAST_APPROVER_NAME',
627: avalue => l_last_approver_name);
628:
629: wf_engine.SetItemAttrText( itemtype => p_itemtype,
630: itemkey => p_itemKey,
631: aname => 'REQUEST_START_DATE',
632: avalue => l_start_date);
633:

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

630: itemkey => p_itemKey,
631: aname => 'REQUEST_START_DATE',
632: avalue => l_start_date);
633:
634: wf_engine.SetItemAttrText( itemtype => p_itemtype,
635: itemkey => p_itemKey,
636: aname => 'REQUEST_END_DATE',
637: avalue => l_end_date);
638:

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

635: itemkey => p_itemKey,
636: aname => 'REQUEST_END_DATE',
637: avalue => l_end_date);
638:
639: wf_engine.SetItemAttrText( itemtype => p_itemtype,
640: itemkey => p_itemKey,
641: aname => 'LAST_NOTE',
642: avalue => l_notes_varchar);
643:

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

640: itemkey => p_itemKey,
641: aname => 'LAST_NOTE',
642: avalue => l_notes_varchar);
643:
644: wf_engine.SetItemAttrText( itemtype => p_itemtype,
645: itemkey => p_itemKey,
646: aname => 'ACTIVITY_NAME',
647: avalue => l_activity_name);
648:

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

645: itemkey => p_itemKey,
646: aname => 'ACTIVITY_NAME',
647: avalue => l_activity_name);
648:
649: wf_engine.SetItemAttrText( itemtype => p_itemtype,
650: itemkey => p_itemKey,
651: aname => 'VENDOR_ORG_NAME',
652: avalue => l_vendor_name);
653:

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

666: 'OfferId=' || l_offer_id || '&'||
667: 'StatusCode=' || p_status || '&'||
668: 'ApprovePriv=1' || '&' || 'pgMode=VDT');
669:
670: wf_engine.SetItemAttrText( itemtype => p_itemtype,
671: itemkey => p_itemKey,
672: aname => 'VENDOR_LOGIN_URL',
673: avalue => l_vendor_url );
674:

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

692: if length(l_partner_profile_url) > 0 then -- if profile is set, use it for partner URL
693: l_partner_url := l_partner_profile_url || substr(l_partner_url, instr(l_partner_url,'/',1,3));
694: end if;
695:
696: wf_engine.SetItemAttrText( itemtype => p_itemtype,
697: itemkey => p_itemKey,
698: aname => 'PARTNER_LOGIN_URL',
699: avalue => l_partner_url );
700:

Line 715: wf_engine.SetItemAttrText

711: 'pgMode=PDT';
712:
713:
714: -- Setting the attribute value for updated projects URL
715: wf_engine.SetItemAttrText
716: ( itemtype => p_itemtype,
717: itemkey => p_itemKey,
718: aname => 'VENDOR_DTAIL_URL',
719: avalue => l_vendor_dtail_url

Line 722: wf_engine.SetItemAttrText

718: aname => 'VENDOR_DTAIL_URL',
719: avalue => l_vendor_dtail_url
720: );
721:
722: wf_engine.SetItemAttrText
723: ( itemtype => p_itemtype,
724: itemkey => p_itemKey,
725: aname => 'PARTNER_DTAIL_URL',
726: avalue => l_partner_dtail_url

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

728:
729:
730: if l_decline_code IS NOT NULL THEN
731: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_DECLINE_CODE',l_decline_code);
732: wf_engine.SetItemAttrText( itemtype => p_itemtype,
733: itemkey => p_itemKey,
734: aname => 'DECLINE_REASON',
735: avalue => l_decline_meaning);
736: ozf_utility_pvt.debug_message( l_decline_meaning||': l_decline_meaning');

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

738: END IF;
739:
740: if l_return_code IS NOT NULL AND l_return_code <> '' THEN
741: l_return_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_RETURN_CODE',l_return_code);
742: wf_engine.SetItemAttrText( itemtype => p_itemtype,
743: itemkey => p_itemKey,
744: aname => 'RETURN_REASON',
745: avalue => l_return_code);
746: END IF;