DBA Data[Home] [Help]

APPS.PON_WF_UTL_PKG dependencies on WF_ENGINE

Line 175: wf_engine.SetItemAttrText(itemtype => p_itemtype

171: ,p_auction_tp_contact_name IN VARCHAR2) IS
172: BEGIN
173:
174: /* Setting the Company header attribute */
175: wf_engine.SetItemAttrText(itemtype => p_itemtype
176: ,itemkey => p_itemkey
177: ,aname => 'PREPARER_TP_NAME'
178: ,avalue => p_auction_tp_name);
179:

Line 181: wf_engine.SetItemAttrText(itemtype => p_itemtype

177: ,aname => 'PREPARER_TP_NAME'
178: ,avalue => p_auction_tp_name);
179:
180: /* Setting the negotiation title header attribute */
181: wf_engine.SetItemAttrText(itemtype => p_itemtype
182: ,itemkey => p_itemkey
183: ,aname => 'AUCTION_TITLE'
184: ,avalue => pon_auction_pkg.replaceHtmlChars(p_auction_title));
185:

Line 187: wf_engine.SetItemAttrText(itemtype => p_itemtype

183: ,aname => 'AUCTION_TITLE'
184: ,avalue => pon_auction_pkg.replaceHtmlChars(p_auction_title));
185:
186: /* Setting the negotiation document number attribute */
187: wf_engine.SetItemAttrText(itemtype => p_itemtype
188: ,itemkey => p_itemkey
189: ,aname => 'DOC_NUMBER'
190: ,avalue => p_document_number);
191:

Line 193: wf_engine.SetItemAttrText (itemtype => p_itemtype

189: ,aname => 'DOC_NUMBER'
190: ,avalue => p_document_number);
191:
192: /* Setting the #From role attribute */
193: wf_engine.SetItemAttrText (itemtype => p_itemtype
194: ,itemkey => p_itemkey
195: ,aname => 'PREPARER_TP_CONTACT_NAME'
196: ,avalue => p_auction_tp_contact_name);
197:

Line 398: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

394: /* Added for Federal CLM solicitation amendments project.
395: * If CONF_DOC_AUC_HEAD_ID is set, then auction_header_id to launch any other page should be
396: * that of conformed document not that of amendment.
397: */
398: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
399: itemkey => p_itemkey,
400: aname => 'CONF_DOC_AUC_HEAD_ID');
401: if nvl(x_auction_id,-1) = -1 then
402: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

Line 402: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

398: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
399: itemkey => p_itemkey,
400: aname => 'CONF_DOC_AUC_HEAD_ID');
401: if nvl(x_auction_id,-1) = -1 then
402: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
403: itemkey => p_itemkey,
404: aname => 'AUCTION_HEADER_ID');
405: else
406: x_documentnumber := wf_engine.GetItemAttrText (itemtype => p_itemtype,

Line 406: x_documentnumber := wf_engine.GetItemAttrText (itemtype => p_itemtype,

402: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
403: itemkey => p_itemkey,
404: aname => 'AUCTION_HEADER_ID');
405: else
406: x_documentnumber := wf_engine.GetItemAttrText (itemtype => p_itemtype,
407: itemkey => p_itemkey,
408: aname => 'CONF_DOC_NUMBER');
409: end if;
410: /* For QA Bug : 9182472 Added If p_itemtype = 'PONAWAPR' */

Line 412: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

408: aname => 'CONF_DOC_NUMBER');
409: end if;
410: /* For QA Bug : 9182472 Added If p_itemtype = 'PONAWAPR' */
411: ELSIF p_itemtype = 'PONAWAPR' THEN
412: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
413: itemkey => p_itemkey,
414: aname => 'AUCTION_HEADER_ID');
415: ELSE
416: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

Line 416: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

412: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
413: itemkey => p_itemkey,
414: aname => 'AUCTION_HEADER_ID');
415: ELSE
416: x_auction_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
417: itemkey => p_itemkey,
418: aname => 'AUCTION_ID');
419: END IF;
420:

Line 422: x_request_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

418: aname => 'AUCTION_ID');
419: END IF;
420:
421: IF (p_itemtype = 'PONCNCT' ) THEN
422: x_request_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
423: itemkey => p_itemkey,
424: aname => 'REQUEST_ID');
425: x_documentnumber := wf_engine.GetItemAttrText (itemtype => p_itemtype,
426: itemkey => p_itemkey,

Line 425: x_documentnumber := wf_engine.GetItemAttrText (itemtype => p_itemtype,

421: IF (p_itemtype = 'PONCNCT' ) THEN
422: x_request_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
423: itemkey => p_itemkey,
424: aname => 'REQUEST_ID');
425: x_documentnumber := wf_engine.GetItemAttrText (itemtype => p_itemtype,
426: itemkey => p_itemkey,
427: aname => 'DOC_NUMBER');
428: END IF;
429:

Line 445: x_site_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

441: name = 'VENDOR_SITE_ID';
442:
443: ELSE
444:
445: x_site_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
446: itemkey => p_itemkey,
447: aname => 'VENDOR_SITE_ID');
448: END IF;
449:

Line 455: x_bid_number := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

451:
452: -- getting parameters needed to access View Quote page
453: -- constant parameters are being set in the NotificationLinkRedirectAMImpl.java
454: IF p_dest_page = 'PONRESENQ_VIEWBID' or p_dest_page = 'PONENQMGDR_MANAGEDRAFT' or p_dest_page = 'PONENQMGDR_MANAGEDRAFT_SURROG' THEN
455: x_bid_number := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
456: itemkey => p_itemkey,
457: aname => 'BID_ID');
458: END IF;
459:

Line 463: x_bid_number := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

459:
460: -- getting parameters needed to access Concurrent Errors page
461: -- constant parameters are being set in the NotificationLinkRedirectAMImpl.java
462: IF p_dest_page = 'PON_CONCURRENT_ERRORS' THEN
463: x_bid_number := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
464: itemkey => p_itemkey,
465: aname => 'BID_ID');
466: END IF;
467:

Line 473: x_doc_type_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

469:
470: -- getting parameters to access Allocation by Item or Allocation Summary pages
471: -- constant parameters are being set in the NotificationLinkRedirectAMImpl.java
472: IF (p_dest_page = 'PONCPOABI_ALLOCATEBYITEM' or p_dest_page = 'PONCPOSUM_ALLOCSUMMARY') THEN
473: x_doc_type_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
474: itemkey => p_itemkey,
475: aname => 'DOCTYPE_ID');
476: END IF;
477:

Line 481: x_reviewpg_redirect_func := wf_engine.GetItemAttrText (itemtype => p_itemtype,

477:
478: -- getting parameters to access Review and Submit page
479: -- constant parameters are being set in the NotificationLinkRedirectAMImpl.java
480: IF (p_dest_page = 'PON_NEG_CRT_HEADER') THEN
481: x_reviewpg_redirect_func := wf_engine.GetItemAttrText (itemtype => p_itemtype,
482: itemkey => p_itemkey,
483: aname => 'REVIEWPG_REDIRECTFUNC');
484: END IF;
485:

Line 488: x_entry_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

484: END IF;
485:
486:
487: IF (p_dest_page = 'PON_VIEW_MESSAGE_DETAILS' ) THEN
488: x_entry_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
489: itemkey => p_itemkey,
490: aname => 'MESSAGE_ENTRY_ID');
491: x_message_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,
492: itemkey => p_itemkey,

Line 491: x_message_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,

487: IF (p_dest_page = 'PON_VIEW_MESSAGE_DETAILS' ) THEN
488: x_entry_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
489: itemkey => p_itemkey,
490: aname => 'MESSAGE_ENTRY_ID');
491: x_message_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,
492: itemkey => p_itemkey,
493: aname => 'MESSAGE_TYPE');
494: x_discussion_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
495: itemkey => p_itemkey,

Line 494: x_discussion_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

490: aname => 'MESSAGE_ENTRY_ID');
491: x_message_type := wf_engine.GetItemAttrText (itemtype => p_itemtype,
492: itemkey => p_itemkey,
493: aname => 'MESSAGE_TYPE');
494: x_discussion_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
495: itemkey => p_itemkey,
496: aname => 'DISCUSSION_ID');
497: END IF;
498:

Line 570: resultout := wf_engine.GetItemAttrText (itemtype => itemtype,

566: resultout out NOCOPY varchar2) IS
567:
568: BEGIN
569:
570: resultout := wf_engine.GetItemAttrText (itemtype => itemtype,
571: itemkey => itemkey,
572: aname => 'CONCPROGRAM_TYPE');
573:
574: END GetConcProgramType;

Line 637: wf_engine.CreateProcess(itemtype => l_item_type,

633: l_msg_suffix := PON_AUCTION_PKG.get_message_suffix(l_doctype_group_name);
634: l_doctypemsgval := PON_AUCTION_PKG.getmessage('PON_AUCTION',l_msg_suffix);
635: if p_messagetype ='S' then
636:
637: wf_engine.CreateProcess(itemtype => l_item_type,
638: itemkey => l_item_key,
639: process => 'REPORT_SUCCESS');
640:
641: else

Line 642: wf_engine.CreateProcess(itemtype => l_item_type,

638: itemkey => l_item_key,
639: process => 'REPORT_SUCCESS');
640:
641: else
642: wf_engine.CreateProcess(itemtype => l_item_type,
643: itemkey => l_item_key,
644: process => 'REPORT_FAILURE');
645: end if;
646: -- set standard notification header attributes

Line 655: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

651: l_document_number,
652: l_trading_partner_contact_name);
653:
654: -- set other core attributes
655: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
656: itemkey => l_item_key,
657: aname => 'AUCTION_ID',
658: avalue => p_auction_header_id);
659:

Line 660: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

656: itemkey => l_item_key,
657: aname => 'AUCTION_ID',
658: avalue => p_auction_header_id);
659:
660: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
661: itemkey => l_item_key,
662: aname => 'BID_ID',
663: avalue => p_bid_number);
664:

Line 665: wf_engine.SetItemAttrNumber(itemtype => l_item_type,

661: itemkey => l_item_key,
662: aname => 'BID_ID',
663: avalue => p_bid_number);
664:
665: wf_engine.SetItemAttrNumber(itemtype => l_item_type,
666: itemkey => l_item_key,
667: aname => 'REQUEST_ID',
668: avalue => p_request_id);
669:

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

666: itemkey => l_item_key,
667: aname => 'REQUEST_ID',
668: avalue => p_request_id);
669:
670: wf_engine.SetItemAttrText(itemtype => l_item_type,
671: itemkey => l_item_key,
672: aname => 'CONCPROGRAM_TYPE',
673: avalue => p_ProgramTypeCode);
674:

Line 675: wf_engine.SetItemAttrText(itemtype => l_item_type,

671: itemkey => l_item_key,
672: aname => 'CONCPROGRAM_TYPE',
673: avalue => p_ProgramTypeCode);
674:
675: wf_engine.SetItemAttrText(itemtype => l_item_type,
676: itemkey => l_item_key,
677: aname => 'DESTINATION_PAGE_CODE',
678: avalue => p_DestinationPageCode);
679:

Line 680: wf_engine.SetItemAttrText(itemtype => l_item_type,

676: itemkey => l_item_key,
677: aname => 'DESTINATION_PAGE_CODE',
678: avalue => p_DestinationPageCode);
679:
680: wf_engine.SetItemAttrText(itemtype => l_item_type,
681: itemkey => l_item_key,
682: aname => 'RECEPIENT_USERNAME',
683: avalue => p_RecepientUsername);
684:

Line 685: wf_engine.SetItemAttrText(itemtype => l_item_type,

681: itemkey => l_item_key,
682: aname => 'RECEPIENT_USERNAME',
683: avalue => p_RecepientUsername);
684:
685: wf_engine.SetItemAttrText(itemtype => l_item_type,
686: itemkey => l_item_key,
687: aname => 'DESTINATION_URL',
688: avalue => get_dest_page_url(p_dest_func=>p_DestinationPageCode,
689: p_notif_performer=>p_recepientType));

Line 692: wf_engine.SetItemAttrText(itemtype => l_item_type,

688: avalue => get_dest_page_url(p_dest_func=>p_DestinationPageCode,
689: p_notif_performer=>p_recepientType));
690:
691:
692: wf_engine.SetItemAttrText(itemtype => l_item_type,
693: itemkey => l_item_key,
694: aname => 'NOTIFICATION_SUBJECT',
695: avalue => PON_AUCTION_PKG.getMessage('PONCPG' || p_messagetype || '_' || p_ProgramTypeCode,
696: l_msg_suffix,

Line 707: wf_engine.SetItemAttrText(itemtype => l_item_type,

703: 'DOC_TITLE',
704: l_auction_title
705: ));
706:
707: wf_engine.SetItemAttrText(itemtype => l_item_type,
708: itemkey => l_item_key,
709: aname => 'MAX_SUCCESS_LAST_BATCH_LINE_NO',
710: avalue => to_char(p_max_good_line_num));
711:

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

709: aname => 'MAX_SUCCESS_LAST_BATCH_LINE_NO',
710: avalue => to_char(p_max_good_line_num));
711:
712:
713: wf_engine.SetItemAttrText(itemtype => l_item_type,
714: itemkey => l_item_key,
715: aname => 'LAST_SUCCESS_BATCH_WORKSHEET',
716: avalue => p_last_goodline_worksheet);
717:

Line 740: wf_engine.SetItemAttrText(itemtype => l_item_type,

736: l_rev_message := fnd_message.get;
737: fnd_message.set_name('PON','PON_AUCTION_AUCTION'||l_msg_suffix);
738: l_success_msg := fnd_message.get||' '||l_document_number||l_rev_message;
739:
740: wf_engine.SetItemAttrText(itemtype => l_item_type,
741: itemkey => l_item_key,
742: aname => 'CNF_DOCUMENT_NUMBER',
743: avalue => l_success_msg);
744:

Line 745: wf_engine.SetItemAttrText(itemtype => l_item_type,

741: itemkey => l_item_key,
742: aname => 'CNF_DOCUMENT_NUMBER',
743: avalue => l_success_msg);
744:
745: wf_engine.SetItemAttrText(itemtype => l_item_type,
746: itemkey => l_item_key,
747: aname => 'AMENDMENT_NUMBER',
748: avalue => l_amendment_number);
749: end if;

Line 751: wf_engine.StartProcess(itemtype => l_item_type,

747: aname => 'AMENDMENT_NUMBER',
748: avalue => l_amendment_number);
749: end if;
750:
751: wf_engine.StartProcess(itemtype => l_item_type,
752: itemkey => l_item_key );
753: END ReportConcProgramStatus;
754:
755:

Line 766: resultout := wf_engine.GetItemAttrText (itemtype => itemtype,

762:
763: BEGIN
764:
765: BEGIN
766: resultout := wf_engine.GetItemAttrText (itemtype => itemtype,
767: itemkey => itemkey,
768: aname => 'MAX_SUCCESS_LAST_BATCH_LINE_NO');
769: EXCEPTION
770: when others then resultout := -1;

Line 785: resultout := wf_engine.GetItemAttrText (

781: uncmode in varchar2,
782: resultout out NOCOPY varchar2) IS
783: BEGIN
784: BEGIN
785: resultout := wf_engine.GetItemAttrText (
786: itemtype => itemtype,
787: itemkey => itemkey,
788: aname => 'LAST_SUCCESS_BATCH_WORKSHEET');
789: