[Home] [Help]
267: BEGIN
268:
269: x_progress := '010';
270:
271: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
272: itemkey => p_itemkey,
273: aname => 'AUCTION_ID');
274:
275: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
271: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
272: itemkey => p_itemkey,
273: aname => 'AUCTION_ID');
274:
275: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
276: itemkey => p_itemkey,
277: aname => 'ORIGIN_USER_NAME');
278:
279: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => p_itemtype,
275: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
276: itemkey => p_itemkey,
277: aname => 'ORIGIN_USER_NAME');
278:
279: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => p_itemtype,
280: itemkey => p_itemkey,
281: aname => 'AUCTION_ID_ENCRYPTED');
282:
283: -- x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
279: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => p_itemtype,
280: itemkey => p_itemkey,
281: aname => 'AUCTION_ID_ENCRYPTED');
282:
283: -- x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
284: -- itemkey => p_itemkey,
285: -- aname => 'PREPARER_TP_CONTACT_NAME');
286:
287: x_doctype_group_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
283: -- x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
284: -- itemkey => p_itemkey,
285: -- aname => 'PREPARER_TP_CONTACT_NAME');
286:
287: x_doctype_group_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
288: itemkey => p_itemkey,
289: aname => 'DOC_INTERNAL_NAME');
290:
291: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => p_itemtype,
287: x_doctype_group_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
288: itemkey => p_itemkey,
289: aname => 'DOC_INTERNAL_NAME');
290:
291: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => p_itemtype,
292: itemkey => p_itemkey,
293: aname => 'DOC_NUMBER');
294:
295: x_preview_date := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
291: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => p_itemtype,
292: itemkey => p_itemkey,
293: aname => 'DOC_NUMBER');
294:
295: x_preview_date := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
296: itemkey => p_itemkey,
297: aname => 'PREVIEW_DATE');
298:
299:
331:
332:
333: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
334:
335: wf_engine.CreateProcess(itemtype => x_itemtype,
336: itemkey => x_itemkey,
337: process => 'PUBLISH_MAIN');
338:
339: --
342:
343: x_progress := '022';
344:
345:
346: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
347: itemkey => x_itemkey,
348: aname => 'ORIGINAL_AUCTION_CLOSE_DATE',
349: avalue => x_original_close_bidding_date);
350:
347: itemkey => x_itemkey,
348: aname => 'ORIGINAL_AUCTION_CLOSE_DATE',
349: avalue => x_original_close_bidding_date);
350:
351: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
352: itemkey => x_itemkey,
353: aname => 'AUCTION_ID',
354: avalue => x_auction_header_id); /* using auction_id instead of
355: auction_number as a standard
354: avalue => x_auction_header_id); /* using auction_id instead of
355: auction_number as a standard
356: across item types */
357:
358: wf_engine.SetItemAttrText (itemtype => x_itemtype,
359: itemkey => x_itemkey,
360: aname => 'DOC_NUMBER',
361: avalue => x_doc_number_dsp);
362:
359: itemkey => x_itemkey,
360: aname => 'DOC_NUMBER',
361: avalue => x_doc_number_dsp);
362:
363: wf_engine.SetItemAttrText (itemtype => x_itemtype,
364: itemkey => x_itemkey,
365: aname => 'ORIGIN_USER_NAME',
366: avalue => l_origin_user_name);
367:
364: itemkey => x_itemkey,
365: aname => 'ORIGIN_USER_NAME',
366: avalue => l_origin_user_name);
367:
368: wf_engine.SetItemAttrText (itemtype => x_itemtype,
369: itemkey => x_itemkey,
370: aname => 'NOTE_TO_BIDDERS',
371: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
372: itemkey => p_itemkey,
367:
368: wf_engine.SetItemAttrText (itemtype => x_itemtype,
369: itemkey => x_itemkey,
370: aname => 'NOTE_TO_BIDDERS',
371: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
372: itemkey => p_itemkey,
373: aname => 'NOTE_TO_BIDDERS')));
374:
375: x_auction_title := wf_engine.GetItemAttrText(itemtype => p_itemtype,
371: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
372: itemkey => p_itemkey,
373: aname => 'NOTE_TO_BIDDERS')));
374:
375: x_auction_title := wf_engine.GetItemAttrText(itemtype => p_itemtype,
376: itemkey => p_itemkey,
377: aname => 'AUCTION_TITLE');
378:
379: wf_engine.SetItemAttrText (itemtype => x_itemtype,
375: x_auction_title := wf_engine.GetItemAttrText(itemtype => p_itemtype,
376: itemkey => p_itemkey,
377: aname => 'AUCTION_TITLE');
378:
379: wf_engine.SetItemAttrText (itemtype => x_itemtype,
380: itemkey => x_itemkey,
381: aname => 'AUCTION_TITLE',
382: avalue => replaceHtmlChars(x_auction_title));
383:
380: itemkey => x_itemkey,
381: aname => 'AUCTION_TITLE',
382: avalue => replaceHtmlChars(x_auction_title));
383:
384: x_auction_owner_tp_name := wf_engine.GetItemAttrText(itemtype => p_itemtype,
385: itemkey => p_itemkey,
386: aname => 'PREPARER_TP_NAME');
387:
388: wf_engine.SetItemAttrText (itemtype => x_itemtype,
384: x_auction_owner_tp_name := wf_engine.GetItemAttrText(itemtype => p_itemtype,
385: itemkey => p_itemkey,
386: aname => 'PREPARER_TP_NAME');
387:
388: wf_engine.SetItemAttrText (itemtype => x_itemtype,
389: itemkey => x_itemkey,
390: aname => 'PREPARER_TP_NAME',
391: avalue => x_auction_owner_tp_name);
392:
389: itemkey => x_itemkey,
390: aname => 'PREPARER_TP_NAME',
391: avalue => x_auction_owner_tp_name);
392:
393: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
394: itemkey => x_itemkey,
395: aname => 'NUMBER_OF_ITEMS',
396: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
397: itemkey => p_itemkey,
392:
393: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
394: itemkey => x_itemkey,
395: aname => 'NUMBER_OF_ITEMS',
396: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
397: itemkey => p_itemkey,
398: aname => 'NUMBER_OF_ITEMS'));
399: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
400: itemkey => x_itemkey,
395: aname => 'NUMBER_OF_ITEMS',
396: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
397: itemkey => p_itemkey,
398: aname => 'NUMBER_OF_ITEMS'));
399: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
400: itemkey => x_itemkey,
401: aname => 'TRADING_PARTNER_ID',
402: avalue => bidder.trading_partner_id);
403:
400: itemkey => x_itemkey,
401: aname => 'TRADING_PARTNER_ID',
402: avalue => bidder.trading_partner_id);
403:
404: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
405: itemkey => x_itemkey,
406: aname => 'DOC_ROUND_NUMBER',
407: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
408: itemkey => p_itemkey,
403:
404: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
405: itemkey => x_itemkey,
406: aname => 'DOC_ROUND_NUMBER',
407: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
408: itemkey => p_itemkey,
409: aname => 'DOC_ROUND_NUMBER'));
410:
411:
408: itemkey => p_itemkey,
409: aname => 'DOC_ROUND_NUMBER'));
410:
411:
412: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
413: itemkey => x_itemkey,
414: aname => 'DOC_AMENDMENT_NUMBER',
415: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
416: itemkey => p_itemkey,
411:
412: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
413: itemkey => x_itemkey,
414: aname => 'DOC_AMENDMENT_NUMBER',
415: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
416: itemkey => p_itemkey,
417: aname => 'DOC_AMENDMENT_NUMBER'));
418:
419: begin
417: aname => 'DOC_AMENDMENT_NUMBER'));
418:
419: begin
420:
421: wf_engine.SetItemAttrText (itemtype => x_itemtype,
422: itemkey => x_itemkey,
423: aname => '#WFM_HTMLAGENT',
424: avalue => pon_wf_utl_pkg.get_base_external_supplier_url);
425: exception when others then
426: null;
427: end;
428:
429:
430: wf_engine.setItemAttrNumber (itemtype => x_itemtype,
431: itemkey => x_itemkey,
432: aname => 'VENDOR_SITE_ID',
433: avalue => bidder.vendor_site_id);
434:
432: aname => 'VENDOR_SITE_ID',
433: avalue => bidder.vendor_site_id);
434:
435:
436: wf_engine.SetItemAttrText (itemtype => x_itemtype,
437: itemkey => x_itemkey,
438: aname => 'PREPARER_TP_CONTACT_NAME',
439: avalue => x_auctioneer_user_name);
440:
444: x_staggered_close_note := wf_core.newline || wf_core.newline ||
445: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
446: wf_core.newline || wf_core.newline;
447: END IF;
448: wf_engine.SetItemAttrText( itemtype => x_itemtype,
449: itemkey => x_itemkey,
450: aname => 'STAGGERED_CLOSE_NOTE',
451: avalue => x_staggered_close_note);
452: EXCEPTION
455: END;
456:
457: begin
458: if (x_event_id is not null) then
459: wf_engine.SetItemAttrText (itemtype => x_itemtype,
460: itemkey => x_itemkey,
461: aname => 'EVENT_TITLE',
462: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
463: itemkey => p_itemkey,
458: if (x_event_id is not null) then
459: wf_engine.SetItemAttrText (itemtype => x_itemtype,
460: itemkey => x_itemkey,
461: aname => 'EVENT_TITLE',
462: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
463: itemkey => p_itemkey,
464: aname => 'EVENT_TITLE')));
465: end if;
466: exception
473: --
474: -- Get the dates from the auction workflow
475: --
476:
477: x_startdate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
478: itemkey => p_itemkey,
479: aname => 'AUCTION_START_DATE');
480:
481: x_enddate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
477: x_startdate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
478: itemkey => p_itemkey,
479: aname => 'AUCTION_START_DATE');
480:
481: x_enddate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
482: itemkey => p_itemkey,
483: aname => 'AUCTION_END_DATE');
484:
485:
527:
528: END;
529:
530:
531: wf_engine.SetItemAttrText (itemtype => x_itemtype,
532: itemkey => x_itemkey,
533: aname => 'BIDDER_TP_CONTACT_NAME',
534: avalue => x_user_name);
535:
592: PON_PROFILE_UTIL_PKG.GET_WF_LANGUAGE(x_auctioneer_user_name,x_language_code);
593:
594: -- add requested supplier info if specified
595: if (bidder.requested_supplier_contact_id is not null) then --{
596: wf_engine.SetItemAttrText (itemtype => x_itemtype,
597: itemkey => x_itemkey,
598: aname => 'REQ_SUPPLIER_CONTACT_NAME',
599: avalue => bidder.requested_supp_contact_NAME);
600:
597: itemkey => x_itemkey,
598: aname => 'REQ_SUPPLIER_CONTACT_NAME',
599: avalue => bidder.requested_supp_contact_NAME);
600:
601: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
602: itemkey => x_itemkey,
603: aname => 'REQ_SUPPLIER_CONTACT_ID',
604: avalue => bidder.requested_supplier_contact_id);
605:
602: itemkey => x_itemkey,
603: aname => 'REQ_SUPPLIER_CONTACT_ID',
604: avalue => bidder.requested_supplier_contact_id);
605:
606: wf_engine.SetItemAttrText (itemtype => x_itemtype,
607: itemkey => x_itemkey,
608: aname => 'BIDDER_TP_CONTACT_NAME',
609: avalue => bidder.requested_supp_contact_name);
610:
607: itemkey => x_itemkey,
608: aname => 'BIDDER_TP_CONTACT_NAME',
609: avalue => bidder.requested_supp_contact_name);
610:
611: wf_engine.SetItemAttrText (itemtype => x_itemtype,
612: itemkey => x_itemkey,
613: aname => 'REQ_SUPPLIER_USERNAME',
614: avalue => bidder.wf_user_name); --(performer)
615:
624:
625: x_timezone_disp := Get_TimeZone_Description(x_timezone, x_language_code);
626:
627:
628: wf_engine.SetItemAttrText (itemtype => x_itemtype,
629: itemkey => x_itemkey,
630: aname => 'TP_TIME_ZONE',
631: avalue => x_timezone_disp);
632:
638:
639: -- Bug 4304399: Set the values of AUCTION_START_DATE and AUCTION_END_DATE
640: -- as the end_date is used to determine the timeout for the notifications
641: -- sent to the supplier
642: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
643: itemkey => x_itemkey,
644: aname => 'AUCTION_START_DATE',
645: avalue => x_startdate);
646:
643: itemkey => x_itemkey,
644: aname => 'AUCTION_START_DATE',
645: avalue => x_startdate);
646:
647: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
648: itemkey => x_itemkey,
649: aname => 'AUCTION_END_DATE',
650: avalue => x_enddate);
651:
648: itemkey => x_itemkey,
649: aname => 'AUCTION_END_DATE',
650: avalue => x_enddate);
651:
652: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
653: itemkey => x_itemkey,
654: aname => 'AUCTION_START_DATE_TZ',
655: avalue => x_newstarttime);
656:
654: aname => 'AUCTION_START_DATE_TZ',
655: avalue => x_newstarttime);
656:
657:
658: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
659: itemkey => x_itemkey,
660: aname => 'AUCTION_END_DATE_TZ',
661: avalue => x_newendtime);
662:
663: --
664: -- Set the Languague code base on the user's language or auctioneer's language if bidder contact id is null
665: --
666:
667: wf_engine.SetItemAttrText (itemtype => x_itemtype,
668: itemkey => x_itemkey,
669: aname => 'TP_LANGUAGE_CODE',
670: avalue => x_language_code);
671:
682: --Bug 6472383 : Shifted the setting of preview date to this place so that the recipient's language, instead
683: --of the sender's language is taken into account when setting the preview date to 'Not Specified'
684:
685: IF (x_newpreviewtime is not null) THEN
686: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
687: itemkey => x_itemkey,
688: aname => 'PREVIEW_DATE_TZ',
689: avalue => x_newpreviewtime);
690:
687: itemkey => x_itemkey,
688: aname => 'PREVIEW_DATE_TZ',
689: avalue => x_newpreviewtime);
690:
691: wf_engine.SetItemAttrText (itemtype => x_itemtype,
692: itemkey => x_itemkey,
693: aname => 'TP_TIME_ZONE1',
694: avalue => x_timezone1_disp);
695:
692: itemkey => x_itemkey,
693: aname => 'TP_TIME_ZONE1',
694: avalue => x_timezone1_disp);
695:
696: wf_engine.SetItemAttrText (itemtype => x_itemtype,
697: itemkey => x_itemkey,
698: aname => 'PREVIEW_DATE_NOTSPECIFIED',
699: avalue => null);
700: ELSE
697: itemkey => x_itemkey,
698: aname => 'PREVIEW_DATE_NOTSPECIFIED',
699: avalue => null);
700: ELSE
701: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
702: itemkey => x_itemkey,
703: aname => 'PREVIEW_DATE_TZ',
704: avalue => null);
705:
702: itemkey => x_itemkey,
703: aname => 'PREVIEW_DATE_TZ',
704: avalue => null);
705:
706: wf_engine.SetItemAttrText (itemtype => x_itemtype,
707: itemkey => x_itemkey,
708: aname => 'TP_TIME_ZONE1',
709: avalue => x_timezone1_disp);
710:
707: itemkey => x_itemkey,
708: aname => 'TP_TIME_ZONE1',
709: avalue => x_timezone1_disp);
710:
711: wf_engine.SetItemAttrText (itemtype => x_itemtype,
712: itemkey => x_itemkey,
713: aname => 'PREVIEW_DATE_NOTSPECIFIED',
714: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
715: END IF;
729: p_dest_func => 'PONINQ_NEW_ROUND_SUM'
730: ,p_notif_performer => 'SUPPLIER');
731: end if;
732:
733: wf_engine.SetItemAttrText (itemtype => x_itemtype,
734: itemkey => x_itemkey,
735: aname => 'NET_CHANGES_URL',
736: avalue => x_net_changes_url_supplier);
737:
744: p_dest_func => 'PON_NEG_SUMMARY'
745: ,p_notif_performer => 'SUPPLIER');
746:
747:
748: wf_engine.SetItemAttrText (itemtype => x_itemtype,
749: itemkey => x_itemkey,
750: aname => 'NEG_SUMMARY_URL',
751: avalue => x_neg_summary_url_supplier);
752:
758: x_ack_part_url_supplier := pon_wf_utl_pkg.get_dest_page_url (
759: p_dest_func => 'PONRESAPN_ACKPARTICIPATN'
760: ,p_notif_performer => 'SUPPLIER');
761:
762: wf_engine.SetItemAttrText (itemtype => x_itemtype,
763: itemkey => x_itemkey,
764: aname => 'ACK_PARTICIPATION_URL',
765: avalue => x_ack_part_url_supplier);
766:
766:
767:
768: x_tp_display_name := nvl(bidder.trading_partner_name, bidder.requested_supplier_name);
769:
770: wf_engine.SetItemAttrText (itemtype => x_itemtype,
771: itemkey => x_itemkey,
772: aname => 'TP_DISPLAY_NAME',
773: avalue => x_tp_display_name);
774:
771: itemkey => x_itemkey,
772: aname => 'TP_DISPLAY_NAME',
773: avalue => x_tp_display_name);
774:
775: wf_engine.SetItemAttrText (itemtype => x_itemtype,
776: itemkey => x_itemkey,
777: aname => 'BIDDER_TP_NAME',
778: avalue => x_tp_display_name);
779:
776: itemkey => x_itemkey,
777: aname => 'BIDDER_TP_NAME',
778: avalue => x_tp_display_name);
779:
780: wf_engine.SetItemAttrText (itemtype => x_itemtype,
781: itemkey => x_itemkey,
782: aname => 'BIDDER_TP_ADDRESS_NAME',
783: avalue => bidder.vendor_site_code);
784:
782: aname => 'BIDDER_TP_ADDRESS_NAME',
783: avalue => bidder.vendor_site_code);
784:
785:
786: wf_engine.SetItemAttrText (itemtype => x_itemtype,
787: itemkey => x_itemkey,
788: aname => 'DOC_INTERNAL_NAME',
789: avalue => x_doctype_group_name);
790:
796: from pon_auction_headers_all
797: where auction_header_id = x_auction_header_id_orig_amend;
798:
799:
800: wf_engine.SetItemAttrText (itemtype => x_itemtype,
801: itemkey => x_itemkey,
802: aname => 'AMENDMENT_START_SUB',
803: avalue => getMessage('PON_AUC_WF_PUB_AMEND_RG_S', x_msg_suffix,
804: 'AMENDMENT_NUMBER', x_amendment_number,
805: 'ORIG_NUMBER', x_orig_document_number,
806: 'AUCTION_TITLE', replaceHtmlChars(x_auction_title)));
807:
808:
809: wf_engine.SetItemAttrText (itemtype => x_itemtype,
810: itemkey => x_itemkey,
811: aname => 'INVITE_NEW_ROUND_START_SUB',
812: avalue => getMessage('PON_AUC_WF_PUB_NEWRND_RG_S', x_msg_suffix,
813: 'DOC_NUMBER', x_doc_number_dsp,
812: avalue => getMessage('PON_AUC_WF_PUB_NEWRND_RG_S', x_msg_suffix,
813: 'DOC_NUMBER', x_doc_number_dsp,
814: 'AUCTION_TITLE', replaceHtmlChars(x_auction_title)));
815:
816: wf_engine.SetItemAttrText (itemtype => x_itemtype,
817: itemkey => x_itemkey,
818: aname => 'INVITE_RESPONSE_SUB',
819: avalue => getMessage('PON_AUC_WF_PUB_OPEN_RG_S', x_msg_suffix,
820: 'DOC_NUMBER', x_doc_number_dsp,
832: -- In FPH, we provide a registration link to the additional contact.
833:
834: if (bidder.additional_contact_email is not null) then
835:
836: wf_engine.SetItemAttrText (itemtype => x_itemtype,
837: itemkey => x_itemkey,
838: aname => 'ADDITIONAL_CONTACT_USERNAME',
839: avalue => bidder.wf_user_name);
840:
852: -- call to notification utility package to get the iSupplier registration page url
853: x_isp_supplier_register_url := pon_wf_utl_pkg.get_isp_supplier_register_url(p_registration_key => x_registration_key
854: ,p_language_code => x_language_code);
855:
856: wf_engine.SetItemAttrText (itemtype => x_itemtype,
857: itemkey => x_itemkey,
858: aname => 'ISP_SUPPLIER_REG_URL',
859: avalue => x_isp_supplier_register_url);
860:
860:
861: end if;
862:
863: -- Bug 4295915: Set the workflow owner
864: wf_engine.SetItemOwner(itemtype => x_itemtype,
865: itemkey => x_itemkey,
866: owner => fnd_global.user_name);
867:
868: wf_engine.StartProcess(itemtype => x_itemtype,
864: wf_engine.SetItemOwner(itemtype => x_itemtype,
865: itemkey => x_itemkey,
866: owner => fnd_global.user_name);
867:
868: wf_engine.StartProcess(itemtype => x_itemtype,
869: itemkey => x_itemkey );
870:
871: update pon_bidding_parties
872: set wf_item_key = x_itemkey
900: BEGIN
901:
902: x_progress := '010';
903:
904: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
905: itemkey => p_itemkey,
906: aname => 'AUCTION_ID');
907:
908: x_progress := '020';
910: FOR bidder IN bidder_list LOOP
911:
912: x_progress := '030';
913:
914: wf_engine.SetItemAttrText (itemtype => p_itemtype,
915: itemkey => p_itemkey,
916: aname => 'BIDDER_DISPLAY_NAME',
917: avalue => bidder.trading_partner_contact_name);
918:
1028: --
1029: -- Create the wf process
1030: --
1031:
1032: wf_engine.CreateProcess(itemtype => x_itemtype,
1033: itemkey => x_itemkey,
1034: process => 'AUCTION_ENGINE');
1035:
1036:
1051:
1052: x_progress := '022';
1053:
1054:
1055: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1056: itemkey => x_itemkey,
1057: aname => 'AUCTION_REMINDER_DATE',
1058: avalue => x_reminder_date);
1059:
1056: itemkey => x_itemkey,
1057: aname => 'AUCTION_REMINDER_DATE',
1058: avalue => x_reminder_date);
1059:
1060: wf_engine.SetItemAttrText(itemtype => x_itemtype,
1061: itemkey => x_itemkey,
1062: aname => 'AUCTION_ID_ENCRYPTED',
1063: avalue => p_auction_header_id_encrypted);
1064:
1061: itemkey => x_itemkey,
1062: aname => 'AUCTION_ID_ENCRYPTED',
1063: avalue => p_auction_header_id_encrypted);
1064:
1065: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1066: itemkey => x_itemkey,
1067: aname => 'AUCTION_ID',
1068: avalue => p_auction_header_id);
1069:
1067: aname => 'AUCTION_ID',
1068: avalue => p_auction_header_id);
1069:
1070:
1071: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1072: itemkey => x_itemkey,
1073: aname => 'ORIGIN_USER_NAME',
1074: avalue => fnd_global.user_name);
1075:
1073: aname => 'ORIGIN_USER_NAME',
1074: avalue => fnd_global.user_name);
1075:
1076:
1077: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1078: itemkey => x_itemkey,
1079: aname => 'PREPARER_TP_CONTACT_ID',
1080: avalue => p_trading_partner_contact_id);
1081:
1078: itemkey => x_itemkey,
1079: aname => 'PREPARER_TP_CONTACT_ID',
1080: avalue => p_trading_partner_contact_id);
1081:
1082: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1083: itemkey => x_itemkey,
1084: aname => 'PREPARER_TP_ID',
1085: avalue => p_trading_partner_id);
1086:
1083: itemkey => x_itemkey,
1084: aname => 'PREPARER_TP_ID',
1085: avalue => p_trading_partner_id);
1086:
1087: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1088: itemkey => x_itemkey,
1089: aname => 'AUCTION_START_DATE',
1090: avalue => p_open_bidding_date);
1091:
1088: itemkey => x_itemkey,
1089: aname => 'AUCTION_START_DATE',
1090: avalue => p_open_bidding_date);
1091:
1092: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1093: itemkey => x_itemkey,
1094: aname => 'AUCTION_END_DATE',
1095: avalue => p_close_bidding_date);
1096:
1093: itemkey => x_itemkey,
1094: aname => 'AUCTION_END_DATE',
1095: avalue => p_close_bidding_date);
1096:
1097: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1098: itemkey => x_itemkey,
1099: aname => 'AUCTION_AWARD_DATE',
1100: avalue => p_award_by_date);
1101:
1103: select nvl(view_by_date,open_bidding_date)
1104: into x_notification_date
1105: from pon_auction_headers_all where auction_header_id = p_auction_header_id;
1106:
1107: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1108: itemkey => x_itemkey,
1109: aname => 'AUCTION_NOTIFICATION_DATE',
1110: avalue => x_notification_date);
1111:
1114: ELSE
1115: x_bid_list := 'Y';
1116: END IF;
1117:
1118: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1119: itemkey => x_itemkey,
1120: aname => 'BIDDER_LIST_FLAG',
1121: avalue => x_bid_list);
1122:
1131: END;
1132:
1133: END IF;
1134:
1135: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1136: itemkey => x_itemkey,
1137: aname => 'NEW_BIDDERS_FLAG',
1138: avalue => x_new_bidders_flag);
1139:
1136: itemkey => x_itemkey,
1137: aname => 'NEW_BIDDERS_FLAG',
1138: avalue => x_new_bidders_flag);
1139:
1140: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1141: itemkey => x_itemkey,
1142: aname => 'NOTE_TO_BIDDERS',
1143: avalue => replaceHtmlChars(p_note_to_bidders));
1144:
1141: itemkey => x_itemkey,
1142: aname => 'NOTE_TO_BIDDERS',
1143: avalue => replaceHtmlChars(p_note_to_bidders));
1144:
1145: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1146: itemkey => x_itemkey,
1147: aname => 'NUMBER_OF_ITEMS',
1148: avalue => p_number_of_items);
1149:
1156: ,p_auction_tp_contact_name => p_trading_partner_contact_name
1157: );
1158:
1159: -- added the contact display name
1160: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1161: itemkey => x_itemkey,
1162: aname => 'PREPARER_CONTACT_DP_NAME',
1163: avalue => x_preparer_contact_dp_name);
1164:
1174: else
1175: x_difference := 0;
1176: end if;
1177:
1178: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1179: itemkey => x_itemkey,
1180: aname => 'PREVIEW_DATE',
1181: avalue => x_preview_date);
1182:
1219: END IF;
1220:
1221: x_timezone_disp:= Get_TimeZone_Description(x_timezone, x_language_code);
1222:
1223: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1224: itemkey => x_itemkey,
1225: aname => 'TP_TIME_ZONE',
1226: avalue => x_timezone_disp);
1227:
1224: itemkey => x_itemkey,
1225: aname => 'TP_TIME_ZONE',
1226: avalue => x_timezone_disp);
1227:
1228: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1229: itemkey => x_itemkey,
1230: aname => 'AUCTION_START_DATE_TZ',
1231: avalue => x_newstarttime);
1232:
1229: itemkey => x_itemkey,
1230: aname => 'AUCTION_START_DATE_TZ',
1231: avalue => x_newstarttime);
1232:
1233: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1234: itemkey => x_itemkey,
1235: aname => 'AUCTION_END_DATE_TZ',
1236: avalue => x_newendtime);
1237:
1235: aname => 'AUCTION_END_DATE_TZ',
1236: avalue => x_newendtime);
1237:
1238: IF (x_newpreviewtime is not null) THEN
1239: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1240: itemkey => x_itemkey,
1241: aname => 'PREVIEW_DATE_TZ',
1242: avalue => x_newpreviewtime);
1243:
1242: avalue => x_newpreviewtime);
1243:
1244: x_timezone1_disp := Get_TimeZone_Description(x_timezone1, x_language_code);
1245:
1246: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1247: itemkey => x_itemkey,
1248: aname => 'TP_TIME_ZONE1',
1249: avalue => x_timezone1_disp);
1250:
1247: itemkey => x_itemkey,
1248: aname => 'TP_TIME_ZONE1',
1249: avalue => x_timezone1_disp);
1250:
1251: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1252: itemkey => x_itemkey,
1253: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1254: avalue => null);
1255: ELSE
1252: itemkey => x_itemkey,
1253: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1254: avalue => null);
1255: ELSE
1256: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1257: itemkey => x_itemkey,
1258: aname => 'PREVIEW_DATE_TZ',
1259: avalue => null);
1260:
1257: itemkey => x_itemkey,
1258: aname => 'PREVIEW_DATE_TZ',
1259: avalue => null);
1260:
1261: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1262: itemkey => x_itemkey,
1263: aname => 'TP_TIME_ZONE1',
1264: avalue => null);
1265:
1262: itemkey => x_itemkey,
1263: aname => 'TP_TIME_ZONE1',
1264: avalue => null);
1265:
1266: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1267: itemkey => x_itemkey,
1268: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1269: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
1270: END IF;
1271:
1272:
1273: if (p_event_id is not null) then
1274: x_event_title := getEventTitle (p_auction_header_id);
1275: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1276: itemkey => x_itemkey,
1277: aname => 'EVENT_TITLE',
1278: avalue => replaceHtmlChars(x_event_title));
1279: end if;
1279: end if;
1280:
1281: -- new 6.2 attributes.
1282:
1283: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1284: itemkey => x_itemkey,
1285: aname => 'DOC_INTERNAL_NAME',
1286: avalue => x_doctype_group_name);
1287:
1284: itemkey => x_itemkey,
1285: aname => 'DOC_INTERNAL_NAME',
1286: avalue => x_doctype_group_name);
1287:
1288: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1289: itemkey => x_itemkey,
1290: aname => 'DOC_ROUND_NUMBER',
1291: avalue => x_auction_round_number);
1292:
1291: avalue => x_auction_round_number);
1292:
1293: -- amendment attribute
1294:
1295: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1296: itemkey => x_itemkey,
1297: aname => 'DOC_AMENDMENT_NUMBER',
1298: avalue => x_amendment_number);
1299:
1298: avalue => x_amendment_number);
1299:
1300: -- New attribute to hold the vendor site id. Attribute value is going
1301: -- to be used as a parameter to access Negotiation Summary page
1302: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1303: itemkey => x_itemkey,
1304: aname => 'VENDOR_SITE_ID',
1305: avalue => -1);
1306:
1312: x_neg_summary_url_buyer := pon_wf_utl_pkg.get_dest_page_url (
1313: p_dest_func => 'PON_NEG_SUMMARY'
1314: ,p_notif_performer => 'BUYER');
1315:
1316: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1317: itemkey => x_itemkey,
1318: aname => 'NEG_SUMMARY_URL',
1319: avalue => x_neg_summary_url_buyer);
1320:
1334: ,p_notif_performer => 'BUYER');
1335: end if;
1336:
1337:
1338: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1339: itemkey => x_itemkey,
1340: aname => 'NET_CHANGES_URL',
1341: avalue => x_net_changes_url_buyer);
1342:
1379: end if;
1380: end if;
1381:
1382:
1383: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1384: itemkey => x_itemkey,
1385: aname => 'AUCTION_STARTED_SUB',
1386: avalue => x_notif_subject);
1387:
1392: -- Start the workflow
1393: --
1394:
1395: -- Bug 4295915: Set the workflow owner
1396: wf_engine.SetItemOwner(itemtype => x_itemtype,
1397: itemkey => x_itemkey,
1398: owner => fnd_global.user_name);
1399:
1400: wf_engine.StartProcess(itemtype => x_itemtype,
1396: wf_engine.SetItemOwner(itemtype => x_itemtype,
1397: itemkey => x_itemkey,
1398: owner => fnd_global.user_name);
1399:
1400: wf_engine.StartProcess(itemtype => x_itemtype,
1401: itemkey => x_itemkey );
1402:
1403:
1404: UPDATE pon_auction_headers_all set
1463: --
1464: -- Create the wf process
1465: --
1466:
1467: wf_engine.CreateProcess(itemtype => x_itemtype,
1468: itemkey => x_itemkey,
1469: process => 'PON_AUCTION_BID');
1470:
1471: --
1474:
1475: x_progress := '025';
1476:
1477:
1478: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1479: itemkey => x_itemkey,
1480: aname => 'BID_ID',
1481: avalue => p_bid_id);
1482:
1479: itemkey => x_itemkey,
1480: aname => 'BID_ID',
1481: avalue => p_bid_id);
1482:
1483: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1484: itemkey => x_itemkey,
1485: aname => 'AUCTION_ID',
1486: avalue => p_auction_header_id);
1487:
1484: itemkey => x_itemkey,
1485: aname => 'AUCTION_ID',
1486: avalue => p_auction_header_id);
1487:
1488: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1489: itemkey => x_itemkey,
1490: aname => 'AUCTION_TP_NAME',
1491: avalue => p_auction_tp_name);
1492:
1490: aname => 'AUCTION_TP_NAME',
1491: avalue => p_auction_tp_name);
1492:
1493:
1494: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1495: itemkey => x_itemkey,
1496: aname => 'AUCTION_START_DATE',
1497: avalue => p_auction_open_bidding_date);
1498:
1495: itemkey => x_itemkey,
1496: aname => 'AUCTION_START_DATE',
1497: avalue => p_auction_open_bidding_date);
1498:
1499: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1500: itemkey => x_itemkey,
1501: aname => 'AUCTION_END_DATE',
1502: avalue => p_auction_close_bidding_date);
1503:
1505: IF (p_visibility_code = 'SEALED_BIDDING') THEN
1506: x_sealed_flag := 'Y';
1507: END IF;
1508:
1509: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1510: itemkey => x_itemkey,
1511: aname => 'SEALED_FLAG',
1512: avalue => x_sealed_flag);
1513:
1513:
1514: x_progress := '028';
1515:
1516:
1517: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1518: itemkey => x_itemkey,
1519: aname => 'OUTBID_TP_CONTACT_NAME',
1520: avalue => p_bid_tp_contact_name);
1521:
1520: avalue => p_bid_tp_contact_name);
1521:
1522:
1523:
1524: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1525: itemkey => x_itemkey,
1526: aname => 'ITEM_DESCRIPTION',
1527: avalue => replaceHtmlChars(p_item_description));
1528:
1525: itemkey => x_itemkey,
1526: aname => 'ITEM_DESCRIPTION',
1527: avalue => replaceHtmlChars(p_item_description));
1528:
1529: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1530: itemkey => x_itemkey,
1531: aname => 'OLD_BID',
1532: avalue => p_old_price);
1533:
1530: itemkey => x_itemkey,
1531: aname => 'OLD_BID',
1532: avalue => p_old_price);
1533:
1534: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1535: itemkey => x_itemkey,
1536: aname => 'NEW_BID',
1537: avalue => p_new_price);
1538:
1535: itemkey => x_itemkey,
1536: aname => 'NEW_BID',
1537: avalue => p_new_price);
1538:
1539: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1540: itemkey => x_itemkey,
1541: aname => 'AUCTION_TITLE',
1542: avalue => replaceHtmlChars(p_auction_title));
1543: /*
1540: itemkey => x_itemkey,
1541: aname => 'AUCTION_TITLE',
1542: avalue => replaceHtmlChars(p_auction_title));
1543: /*
1544: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1545: itemkey => x_itemkey,
1546: aname => 'OEX_OPERATION',
1547: avalue => p_oex_operation);
1548: */
1545: itemkey => x_itemkey,
1546: aname => 'OEX_OPERATION',
1547: avalue => p_oex_operation);
1548: */
1549: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1550: itemkey => x_itemkey,
1551: aname => 'OEX_OPERATION_URL',
1552: avalue => p_oex_operation_url);
1553:
1551: aname => 'OEX_OPERATION_URL',
1552: avalue => p_oex_operation_url);
1553:
1554: -- Bug 4295915: Set the workflow owner
1555: wf_engine.SetItemOwner(itemtype => x_itemtype,
1556: itemkey => x_itemkey,
1557: owner => fnd_global.user_name);
1558:
1559: --
1558:
1559: --
1560: -- Start the workflow
1561: --
1562: wf_engine.StartProcess(itemtype => x_itemtype,
1563: itemkey => x_itemkey );
1564:
1565: x_progress := '029';
1566:
1712: --
1713: -- Create the wf process
1714: --
1715:
1716: wf_engine.CreateProcess(itemtype => x_itemtype,
1717: itemkey => x_itemkey,
1718: process => 'PON_DISQUALIFY_BID');
1719:
1720: --
1724: x_progress := '025';
1725:
1726: x_msg_suffix := GET_MESSAGE_SUFFIX (x_doctype_group_name);
1727:
1728: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1729: itemkey => x_itemkey,
1730: aname => 'DOC_NUMBER',
1731: avalue => p_doc_number_dsp);
1732:
1729: itemkey => x_itemkey,
1730: aname => 'DOC_NUMBER',
1731: avalue => p_doc_number_dsp);
1732:
1733: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1734: itemkey => x_itemkey,
1735: aname => 'AUCTION_ID',
1736: avalue => p_auction_header_id);
1737:
1734: itemkey => x_itemkey,
1735: aname => 'AUCTION_ID',
1736: avalue => p_auction_header_id);
1737:
1738: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1739: itemkey => x_itemkey,
1740: aname => 'ORIGIN_USER_NAME',
1741: avalue => fnd_global.user_name);
1742:
1740: aname => 'ORIGIN_USER_NAME',
1741: avalue => fnd_global.user_name);
1742:
1743: -- Item attribute value is going to be used as a parameter to View Quote page
1744: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
1745: itemkey => x_itemkey,
1746: aname => 'BID_ID',
1747: avalue => p_bid_id);
1748:
1745: itemkey => x_itemkey,
1746: aname => 'BID_ID',
1747: avalue => p_bid_id);
1748:
1749: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1750: itemkey => x_itemkey,
1751: aname => 'BIDDER_TP_NAME',
1752: avalue => x_tp_display_name);
1753:
1750: itemkey => x_itemkey,
1751: aname => 'BIDDER_TP_NAME',
1752: avalue => x_tp_display_name);
1753:
1754: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1755: itemkey => x_itemkey,
1756: aname => 'BIDDER_TP_ADDRESS_NAME',
1757: avalue => x_tp_address_name);
1758:
1755: itemkey => x_itemkey,
1756: aname => 'BIDDER_TP_ADDRESS_NAME',
1757: avalue => x_tp_address_name);
1758:
1759: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1760: itemkey => x_itemkey,
1761: aname => 'DOC_INTERNAL_NAME',
1762: avalue => x_doctype_group_name);
1763:
1767: x_staggered_close_note := wf_core.newline || wf_core.newline ||
1768: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
1769: wf_core.newline || wf_core.newline;
1770: END IF;
1771: wf_engine.SetItemAttrText( itemtype => x_itemtype,
1772: itemkey => x_itemkey,
1773: aname => 'STAGGERED_CLOSE_NOTE',
1774: avalue => x_staggered_close_note);
1775: EXCEPTION
1777: NULL;
1778: END;
1779:
1780: BEGIN
1781: wf_engine.SetItemAttrText(itemtype => x_itemtype,
1782: itemkey => x_itemkey,
1783: aname => '#WFM_HTMLAGENT',
1784: avalue => pon_wf_utl_pkg.get_base_external_supplier_url);
1785: EXCEPTION
1789:
1790: -- Bug 7156205. Get the value for p_bid_name from getMessage instead of hardcoding the message
1791: p_bid_name := getMessage('PON_AUC_BID_L', x_msg_suffix);
1792:
1793: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1794: itemkey => x_itemkey,
1795: aname => 'BID',
1796: avalue => p_bid_name);
1797:
1794: itemkey => x_itemkey,
1795: aname => 'BID',
1796: avalue => p_bid_name);
1797:
1798: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1799: itemkey => x_itemkey,
1800: aname => 'BIDDER_TP_CONTACT_NAME',
1801: avalue => p_bid_tp_contact_name);
1802:
1800: aname => 'BIDDER_TP_CONTACT_NAME',
1801: avalue => p_bid_tp_contact_name);
1802:
1803:
1804: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1805: itemkey => x_itemkey,
1806: aname => 'DISQUALIFY_REASON',
1807: avalue => replaceHtmlChars(p_disqualify_reason));
1808: --
1813: into x_startdate, x_enddate, x_auction_tp_contact_name
1814: from pon_auction_headers_all
1815: where auction_header_id = p_auction_header_id;
1816:
1817: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1818: itemkey => x_itemkey,
1819: aname => 'AUCTION_START_DATE',
1820: avalue => x_startdate);
1821:
1818: itemkey => x_itemkey,
1819: aname => 'AUCTION_START_DATE',
1820: avalue => x_startdate);
1821:
1822: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1823: itemkey => x_itemkey,
1824: aname => 'AUCTION_END_DATE',
1825: avalue => x_enddate);
1826:
1823: itemkey => x_itemkey,
1824: aname => 'AUCTION_END_DATE',
1825: avalue => x_enddate);
1826:
1827: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1828: itemkey => x_itemkey,
1829: aname => 'PREVIEW_DATE',
1830: avalue => x_preview_date);
1831:
1846: x_timezone_bidder := x_oex_timezone;
1847: x_preview_date_in_tz := x_preview_date;
1848: END IF;
1849:
1850: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1851: itemkey => x_itemkey,
1852: aname => 'BIDDER_DISQUALIFY_DATE',
1853: avalue => x_new_disqualify_date_bidder);
1854:
1853: avalue => x_new_disqualify_date_bidder);
1854:
1855: x_timezone_disp_bidder := Get_TimeZone_Description(x_timezone_bidder, x_language_code);
1856:
1857: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1858: itemkey => x_itemkey,
1859: aname => 'TP_TIME_ZONE',
1860: avalue => x_timezone_disp_bidder);
1861:
1858: itemkey => x_itemkey,
1859: aname => 'TP_TIME_ZONE',
1860: avalue => x_timezone_disp_bidder);
1861:
1862: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1863: itemkey => x_itemkey,
1864: aname => 'AUCTION_START_DATE_BIDDER',
1865: avalue => x_newstarttime_bidder);
1866:
1863: itemkey => x_itemkey,
1864: aname => 'AUCTION_START_DATE_BIDDER',
1865: avalue => x_newstarttime_bidder);
1866:
1867: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1868: itemkey => x_itemkey,
1869: aname => 'AUCTION_END_DATE_BIDDER',
1870: avalue => x_newendtime_bidder);
1871:
1882: --
1883: -- Set the attributes
1884: --
1885:
1886: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1887: itemkey => x_itemkey,
1888: aname => 'NEW_BIDDER_ROLE',
1889: avalue => x_role_name);
1890:
1887: itemkey => x_itemkey,
1888: aname => 'NEW_BIDDER_ROLE',
1889: avalue => x_role_name);
1890:
1891: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1892: itemkey => x_itemkey,
1893: aname => 'SEALED_FLAG',
1894: avalue => x_sealed_flag);
1895:
1894: avalue => x_sealed_flag);
1895:
1896: -- added the contact display name and the auction type ( sellers or buyers)
1897:
1898: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1899: itemkey => x_itemkey,
1900: aname => 'BID_CONTACT_DP_NAME',
1901: avalue => x_bid_contact_dp_name);
1902:
1903:
1904: IF (x_preview_date_in_tz IS NULL) THEN
1905: x_timezone1_disp := null;
1906:
1907: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1908: itemkey => x_itemkey,
1909: aname => 'PREVIEW_DATE_TZ',
1910: avalue => null);
1911:
1908: itemkey => x_itemkey,
1909: aname => 'PREVIEW_DATE_TZ',
1910: avalue => null);
1911:
1912: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1913: itemkey => x_itemkey,
1914: aname => 'TP_TIME_ZONE1',
1915: avalue => null);
1916:
1913: itemkey => x_itemkey,
1914: aname => 'TP_TIME_ZONE1',
1915: avalue => null);
1916:
1917: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1918: itemkey => x_itemkey,
1919: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1920: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
1921: ELSE
1920: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
1921: ELSE
1922: x_timezone1_disp := x_timezone_disp;
1923:
1924: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1925: itemkey => x_itemkey,
1926: aname => 'PREVIEW_DATE_TZ',
1927: avalue => x_preview_date_in_tz);
1928:
1925: itemkey => x_itemkey,
1926: aname => 'PREVIEW_DATE_TZ',
1927: avalue => x_preview_date_in_tz);
1928:
1929: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1930: itemkey => x_itemkey,
1931: aname => 'TP_TIME_ZONE1',
1932: avalue => x_timezone1_disp);
1933:
1930: itemkey => x_itemkey,
1931: aname => 'TP_TIME_ZONE1',
1932: avalue => x_timezone1_disp);
1933:
1934: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1935: itemkey => x_itemkey,
1936: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1937: avalue => null);
1938: END IF;
1954: p_view_quote_url := pon_wf_utl_pkg.get_dest_page_url (
1955: p_dest_func => 'PONRESENQ_VIEWBID'
1956: ,p_notif_performer => 'SUPPLIER');
1957:
1958: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1959: itemkey => x_itemkey,
1960: aname => 'VIEW_QUOTE_URL',
1961: avalue => p_view_quote_url);
1962:
1968:
1969:
1970:
1971: --- 000001
1972: wf_engine.SetItemAttrText ( itemtype => x_itemtype,
1973: itemkey => x_itemkey,
1974: aname => 'PON_WF_AUC_DSQBID_SUB',
1975: avalue => getMessage('PON_WF_AUC_DSQBID_SUB', x_msg_suffix,
1976: 'BID_ID', p_bid_id,
1983:
1984: x_progress := '027';
1985:
1986: -- Bug 4295915: Set the workflow owner
1987: wf_engine.SetItemOwner(itemtype => x_itemtype,
1988: itemkey => x_itemkey,
1989: owner => fnd_global.user_name);
1990:
1991: --
1991: --
1992: -- Start the workflow
1993: --
1994:
1995: wf_engine.StartProcess(itemtype => x_itemtype,
1996: itemkey => x_itemkey );
1997:
1998: x_progress := '029';
1999:
2050: --
2051: -- Create the wf process
2052: --
2053:
2054: wf_engine.CreateProcess(itemtype => x_itemtype,
2055: itemkey => x_itemkey,
2056: process => 'PON_BID_CANCEL');
2057:
2058: --
2061:
2062: x_progress := '025';
2063:
2064:
2065: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
2066: itemkey => x_itemkey,
2067: aname => 'AUCTION_ID',
2068: avalue => p_auction_header_id);
2069:
2067: aname => 'AUCTION_ID',
2068: avalue => p_auction_header_id);
2069:
2070:
2071: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
2072: itemkey => x_itemkey,
2073: aname => 'BID_ID',
2074: avalue => p_bid_id);
2075:
2072: itemkey => x_itemkey,
2073: aname => 'BID_ID',
2074: avalue => p_bid_id);
2075:
2076: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2077: itemkey => x_itemkey,
2078: aname => 'PREPARER_TP_CONTACT_NAME',
2079: avalue => p_auction_tp_contact_name);
2080:
2077: itemkey => x_itemkey,
2078: aname => 'PREPARER_TP_CONTACT_NAME',
2079: avalue => p_auction_tp_contact_name);
2080:
2081: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
2082: itemkey => x_itemkey,
2083: aname => 'PREPARER_TP_CONTACT_ID',
2084: avalue => p_auction_tp_contact_id);
2085:
2082: itemkey => x_itemkey,
2083: aname => 'PREPARER_TP_CONTACT_ID',
2084: avalue => p_auction_tp_contact_id);
2085:
2086: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2087: itemkey => x_itemkey,
2088: aname => 'ORIGIN_USER_NAME',
2089: avalue => fnd_global.user_name);
2090: x_progress := '026';
2089: avalue => fnd_global.user_name);
2090: x_progress := '026';
2091:
2092:
2093: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2094: itemkey => x_itemkey,
2095: aname => 'BIDDER_TP_CONTACT_NAME',
2096: avalue => p_bid_tp_contact_name);
2097:
2094: itemkey => x_itemkey,
2095: aname => 'BIDDER_TP_CONTACT_NAME',
2096: avalue => p_bid_tp_contact_name);
2097:
2098: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
2099: itemkey => x_itemkey,
2100: aname => 'BIDDER_TP_CONTACT_ID',
2101: avalue => p_bid_tp_contact_id);
2102:
2100: aname => 'BIDDER_TP_CONTACT_ID',
2101: avalue => p_bid_tp_contact_id);
2102:
2103:
2104: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2105: itemkey => x_itemkey,
2106: aname => 'AUCTION_START_DATE',
2107: avalue => p_auction_open_bidding_date);
2108:
2105: itemkey => x_itemkey,
2106: aname => 'AUCTION_START_DATE',
2107: avalue => p_auction_open_bidding_date);
2108:
2109: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2110: itemkey => x_itemkey,
2111: aname => 'AUCTION_END_DATE',
2112: avalue => p_auction_close_bidding_date);
2113:
2111: aname => 'AUCTION_END_DATE',
2112: avalue => p_auction_close_bidding_date);
2113:
2114:
2115: -- wf_engine.SetItemAttrText (itemtype => x_itemtype,
2116: -- itemkey => x_itemkey,
2117: -- aname => 'OEX_OPERATION',
2118: -- avalue => p_oex_operation);
2119:
2116: -- itemkey => x_itemkey,
2117: -- aname => 'OEX_OPERATION',
2118: -- avalue => p_oex_operation);
2119:
2120: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2121: itemkey => x_itemkey,
2122: aname => 'OEX_OPERATION_URL',
2123: avalue => 'p_oex_operation_url');
2124: x_progress := '027';
2124: x_progress := '027';
2125:
2126:
2127: -- Bug 4295915: Set the workflow owner
2128: wf_engine.SetItemOwner(itemtype => x_itemtype,
2129: itemkey => x_itemkey,
2130: owner => fnd_global.user_name);
2131:
2132: --
2131:
2132: --
2133: -- Start the workflow
2134: --
2135: wf_engine.StartProcess(itemtype => x_itemtype,
2136: itemkey => x_itemkey );
2137:
2138: x_progress := '029';
2139:
2287: --
2288: -- Create the wf process
2289: --
2290:
2291: wf_engine.CreateProcess(itemtype => x_itemtype,
2292: itemkey => x_itemkey,
2293: process => 'PON_AWARD_BID');
2294:
2295: --
2295: --
2296: -- Set all the item attributes
2297: --
2298:
2299: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2300: itemkey => x_itemkey,
2301: aname => 'DOC_NUMBER',
2302: avalue => x_doc_number_dsp);
2303:
2307: x_view_quote_url_supplier := pon_wf_utl_pkg.get_dest_page_url (
2308: p_dest_func => 'PONRESENQ_VIEWBID'
2309: ,p_notif_performer => 'SUPPLIER');
2310:
2311: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2312: itemkey => x_itemkey,
2313: aname => 'VIEW_QUOTE_URL',
2314: avalue => x_view_quote_url_supplier);
2315:
2312: itemkey => x_itemkey,
2313: aname => 'VIEW_QUOTE_URL',
2314: avalue => x_view_quote_url_supplier);
2315:
2316: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2317: itemkey => x_itemkey,
2318: aname => 'BIDDER_TP_NAME',
2319: avalue => x_tp_display_name);
2320:
2317: itemkey => x_itemkey,
2318: aname => 'BIDDER_TP_NAME',
2319: avalue => x_tp_display_name);
2320:
2321: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2322: itemkey => x_itemkey,
2323: aname => 'HAS_ITEMS_FLAG',
2324: avalue => x_has_items_flag);
2325:
2322: itemkey => x_itemkey,
2323: aname => 'HAS_ITEMS_FLAG',
2324: avalue => x_has_items_flag);
2325:
2326: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2327: itemkey => x_itemkey,
2328: aname => 'BIDDER_TP_ADDRESS_NAME',
2329: avalue => x_tp_address_name);
2330:
2334: x_staggered_close_note := wf_core.newline || wf_core.newline ||
2335: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
2336: wf_core.newline || wf_core.newline;
2337: END IF;
2338: wf_engine.SetItemAttrText( itemtype => x_itemtype,
2339: itemkey => x_itemkey,
2340: aname => 'STAGGERED_CLOSE_NOTE',
2341: avalue => x_staggered_close_note);
2342: EXCEPTION
2344: NULL;
2345: END;
2346:
2347: BEGIN
2348: wf_engine.SetItemAttrText(itemtype => x_itemtype,
2349: itemkey => x_itemkey,
2350: aname => '#WFM_HTMLAGENT',
2351: avalue => pon_wf_utl_pkg.get_base_external_supplier_url);
2352: EXCEPTION
2383: and pbip.bid_number = p_bid_id
2384: and nvl(pbip.award_status,'NONE')= 'REJECTED'
2385: and paip.group_type in ('LINE', 'LOT', 'GROUP_LINE');
2386:
2387: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
2388: itemkey => x_itemkey,
2389: aname => 'NUMBER_AWARDED',
2390: avalue => x_number_awarded);
2391:
2388: itemkey => x_itemkey,
2389: aname => 'NUMBER_AWARDED',
2390: avalue => x_number_awarded);
2391:
2392: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
2393: itemkey => x_itemkey,
2394: aname => 'NUMBER_REJECTED',
2395: avalue => x_number_rejected);
2396: END IF;
2395: avalue => x_number_rejected);
2396: END IF;
2397:
2398:
2399: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
2400: itemkey => x_itemkey,
2401: aname => 'AUCTION_ID',
2402: avalue => p_auction_header_id);
2403:
2401: aname => 'AUCTION_ID',
2402: avalue => p_auction_header_id);
2403:
2404: -- Item attribute value is going to be used as a parameter to View Quote page
2405: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
2406: itemkey => x_itemkey,
2407: aname => 'BID_ID',
2408: avalue => p_bid_id);
2409:
2406: itemkey => x_itemkey,
2407: aname => 'BID_ID',
2408: avalue => p_bid_id);
2409:
2410: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2411: itemkey => x_itemkey,
2412: aname => 'BIDDER_TP_CONTACT_NAME',
2413: avalue => p_bid_tp_contact_name);
2414:
2411: itemkey => x_itemkey,
2412: aname => 'BIDDER_TP_CONTACT_NAME',
2413: avalue => p_bid_tp_contact_name);
2414:
2415: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2416: itemkey => x_itemkey,
2417: aname => 'ORIGIN_USER_NAME',
2418: avalue => fnd_global.user_name);
2419:
2416: itemkey => x_itemkey,
2417: aname => 'ORIGIN_USER_NAME',
2418: avalue => fnd_global.user_name);
2419:
2420: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2421: itemkey => x_itemkey,
2422: aname => 'BID',
2423: avalue => x_bid);
2424:
2421: itemkey => x_itemkey,
2422: aname => 'BID',
2423: avalue => x_bid);
2424:
2425: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2426: itemkey => x_itemkey,
2427: aname => 'BID_CAPS',
2428: avalue => x_bid_caps);
2429:
2426: itemkey => x_itemkey,
2427: aname => 'BID_CAPS',
2428: avalue => x_bid_caps);
2429:
2430: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2431: itemkey => x_itemkey,
2432: aname => 'NOTE_TO_SUPPLIER',
2433: avalue => x_note_to_supplier);
2434:
2433: avalue => x_note_to_supplier);
2434:
2435: -- added the contact display name and the auction type ( sellers or buyers)
2436:
2437: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2438: itemkey => x_itemkey,
2439: aname => 'BID_CONTACT_TP_DP_NAME',
2440: avalue => x_bid_contact_tp_dp_name);
2441:
2438: itemkey => x_itemkey,
2439: aname => 'BID_CONTACT_TP_DP_NAME',
2440: avalue => x_bid_contact_tp_dp_name);
2441:
2442: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2443: itemkey => x_itemkey,
2444: aname => 'AUCTION_TYPE_NAME',
2445: avalue => x_auction_type_name);
2446:
2448: into x_auction_open_bidding_date, x_auction_close_bidding_date, x_award_date, x_event_id
2449: from pon_auction_headers_all
2450: where auction_header_id = p_auction_header_id;
2451:
2452: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2453: itemkey => x_itemkey,
2454: aname => 'AWARD_DATE',
2455: avalue => x_award_date);
2456:
2455: avalue => x_award_date);
2456:
2457: if (x_event_id is not null) then
2458: x_event_title := getEventTitle (p_auction_header_id);
2459: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2460: itemkey => x_itemkey,
2461: aname => 'EVENT_TITLE',
2462: avalue => replaceHtmlChars(x_event_title));
2463: end if;
2506:
2507: x_timezone_disp := Get_TimeZone_Description(x_timezone, x_language_code);
2508:
2509:
2510: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2511: itemkey => x_itemkey,
2512: aname => 'TP_TIME_ZONE_AUCTION',
2513: avalue => x_timezone_disp);
2514:
2511: itemkey => x_itemkey,
2512: aname => 'TP_TIME_ZONE_AUCTION',
2513: avalue => x_timezone_disp);
2514:
2515: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2516: itemkey => x_itemkey,
2517: aname => 'AUCTION_START_DATE_TZ',
2518: avalue => x_newstarttime);
2519:
2516: itemkey => x_itemkey,
2517: aname => 'AUCTION_START_DATE_TZ',
2518: avalue => x_newstarttime);
2519:
2520: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2521: itemkey => x_itemkey,
2522: aname => 'AUCTION_END_DATE_TZ',
2523: avalue => x_newendtime);
2524:
2521: itemkey => x_itemkey,
2522: aname => 'AUCTION_END_DATE_TZ',
2523: avalue => x_newendtime);
2524:
2525: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2526: itemkey => x_itemkey,
2527: aname => 'AWARD_DATE_TZ',
2528: avalue => x_newawardtime);
2529:
2530: IF (x_preview_date_in_tz IS NULL) THEN
2531:
2532: x_timezone1_disp := null;
2533:
2534: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2535: itemkey => x_itemkey,
2536: aname => 'PREVIEW_DATE_TZ',
2537: avalue => null);
2538:
2535: itemkey => x_itemkey,
2536: aname => 'PREVIEW_DATE_TZ',
2537: avalue => null);
2538:
2539: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2540: itemkey => x_itemkey,
2541: aname => 'TP_TIME_ZONE1',
2542: avalue => null);
2543:
2540: itemkey => x_itemkey,
2541: aname => 'TP_TIME_ZONE1',
2542: avalue => null);
2543:
2544: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2545: itemkey => x_itemkey,
2546: aname => 'PREVIEW_DATE_NOTSPECIFIED',
2547: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
2548: ELSE
2547: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
2548: ELSE
2549: x_timezone1_disp := x_timezone_disp;
2550:
2551: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2552: itemkey => x_itemkey,
2553: aname => 'PREVIEW_DATE_TZ',
2554: avalue => x_preview_date_in_tz);
2555:
2552: itemkey => x_itemkey,
2553: aname => 'PREVIEW_DATE_TZ',
2554: avalue => x_preview_date_in_tz);
2555:
2556: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2557: itemkey => x_itemkey,
2558: aname => 'TP_TIME_ZONE1',
2559: avalue => x_timezone1_disp);
2560:
2557: itemkey => x_itemkey,
2558: aname => 'TP_TIME_ZONE1',
2559: avalue => x_timezone1_disp);
2560:
2561: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2562: itemkey => x_itemkey,
2563: aname => 'PREVIEW_DATE_NOTSPECIFIED',
2564: avalue => null);
2565: END IF;
2577:
2578:
2579: if (x_event_title is not null) then
2580:
2581: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2582: itemkey => x_itemkey,
2583: aname => 'PON_AUC_WF_AWARD_SUBJECT',
2584: avalue => getMessage('PON_AUC_WF_AWARD_EVENT_SUB', x_msg_suffix,
2585: 'DOC_NUMBER', x_doc_number_dsp,
2587: 'EVENT_TITLE', x_event_title));
2588:
2589: else
2590:
2591: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2592: itemkey => x_itemkey,
2593: aname => 'PON_AUC_WF_AWARD_SUBJECT',
2594: avalue => getMessage('PON_AUC_WF_AWARD_SUBJECT', x_msg_suffix,
2595: 'DOC_NUMBER', x_doc_number_dsp,
2599:
2600: UNSET_SESSION_LANGUAGE;
2601:
2602: -- Bug 4295915: Set the workflow owner
2603: wf_engine.SetItemOwner(itemtype => x_itemtype,
2604: itemkey => x_itemkey,
2605: owner => fnd_global.user_name);
2606:
2607: --
2607: --
2608: -- Start the workflow
2609: --
2610:
2611: wf_engine.StartProcess(itemtype => x_itemtype,
2612: itemkey => x_itemkey );
2613:
2614: x_progress := '029';
2615:
2623:
2624: x_flag VARCHAR2(1);
2625: BEGIN
2626:
2627: x_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
2628: itemkey => itemkey,
2629: aname => 'NEW_BIDDERS_FLAG');
2630:
2631:
2646:
2647: x_flag VARCHAR2(1);
2648: BEGIN
2649:
2650: x_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
2651: itemkey => itemkey,
2652: aname => 'BIDDER_LIST_FLAG');
2653:
2654:
2670: x_doc_header_id number;
2671: x_itemkey varchar2(240);
2672: BEGIN
2673:
2674: x_doc_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2675: itemkey => p_itemkey,
2676: aname => 'AUCTION_ID');
2677:
2678: begin
2680: from pon_auction_headers_all
2681: where auction_header_id = (select auction_header_id_prev_round
2682: from pon_auction_headers_all where auction_header_id = x_doc_header_id);
2683:
2684: wf_engine.completeActivity('PONAUCT', x_itemkey, 'WAIT_FOR_AUCTION_COMPLETE', 'PREPARER_COMPLETE');
2685:
2686: exception
2687: when others then
2688: null;
2702: x_itemkey varchar2(240);
2703: x_current_activity VARCHAR2(30);
2704: BEGIN
2705:
2706: x_doc_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2707: itemkey => p_itemkey,
2708: aname => 'AUCTION_ID');
2709:
2710: begin
2738: EXCEPTION WHEN no_data_found THEN
2739: RETURN;
2740: END;
2741:
2742: wf_engine.CompleteActivity(x_itemtype,x_itemkey,x_current_activity,'PREPARER_COMPLETE');
2743:
2744: exception
2745: when others then
2746: null;
2768:
2769: x_itemkey := item_key.wf_item_key;
2770: x_current_activity := item_key.activity_label;
2771:
2772: wf_engine.CompleteActivity(x_itemtype,x_itemkey,x_current_activity,'PREPARER_COMPLETE');
2773:
2774: END LOOP;
2775:
2776: END;
2853: begin
2854:
2855: if (p_action_code = 'CANCEL') then
2856:
2857: x_cancel_reason := wf_engine.GetItemAttrText(itemtype => itemtype,
2858: itemkey => itemkey,
2859: aname => 'CANCEL_REASON');
2860:
2861: x_cancel_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
2857: x_cancel_reason := wf_engine.GetItemAttrText(itemtype => itemtype,
2858: itemkey => itemkey,
2859: aname => 'CANCEL_REASON');
2860:
2861: x_cancel_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
2862: itemkey => itemkey,
2863: aname => 'CANCEL_DATE');
2864:
2865: elsif (p_action_code = 'DISQUALIFY_BID') then
2863: aname => 'CANCEL_DATE');
2864:
2865: elsif (p_action_code = 'DISQUALIFY_BID') then
2866:
2867: x_disqualify_reason := wf_engine.GetItemAttrText(itemtype => itemtype,
2868: itemkey => itemkey,
2869: aname => 'DISQUALIFY_REASON');
2870:
2871: x_bid_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2867: x_disqualify_reason := wf_engine.GetItemAttrText(itemtype => itemtype,
2868: itemkey => itemkey,
2869: aname => 'DISQUALIFY_REASON');
2870:
2871: x_bid_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2872: itemkey => itemkey,
2873: aname => 'BID_ID');
2874:
2875:
2872: itemkey => itemkey,
2873: aname => 'BID_ID');
2874:
2875:
2876: x_disqualify_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
2877: itemkey => itemkey,
2878: aname => 'BIDDER_DISQUALIFY_DATE');
2879:
2880: x_bid_name := wf_engine.GetItemAttrText (itemtype => itemtype,
2876: x_disqualify_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
2877: itemkey => itemkey,
2878: aname => 'BIDDER_DISQUALIFY_DATE');
2879:
2880: x_bid_name := wf_engine.GetItemAttrText (itemtype => itemtype,
2881: itemkey => itemkey,
2882: aname => 'BID');
2883:
2884: end if;
2883:
2884: end if;
2885:
2886:
2887: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
2888: itemkey => itemkey,
2889: aname => 'ORIGIN_USER_NAME');
2890:
2891: x_msg_suffix := GET_MESSAGE_SUFFIX (wf_engine.GetItemAttrText (itemtype => itemtype,
2887: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
2888: itemkey => itemkey,
2889: aname => 'ORIGIN_USER_NAME');
2890:
2891: x_msg_suffix := GET_MESSAGE_SUFFIX (wf_engine.GetItemAttrText (itemtype => itemtype,
2892: itemkey => itemkey,
2893: aname => 'DOC_INTERNAL_NAME'));
2894:
2895: UNSET_SESSION_LANGUAGE;
2935: elsif (p_action_code = 'CLOSECHANGED') then
2936:
2937: x_close_date_changed := p_auction_end_date;
2938:
2939: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => itemtype,
2940: itemkey => itemkey,
2941: aname => 'AUCTION_ID_ENCRYPTED');
2942:
2943: -- call to notification utility package to get the redirect page url that
3007: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3008: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3009: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3010: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3011: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3012: itemkey => itemkey,
3013: aname =>'PREPARER_TP_NAME'));
3014:
3015: wf_Notification.setAttrText(x_nid, '#FROM_ROLE', l_origin_user_name);
3017: IF (x_new_auction_preview_date is null) THEN
3018: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3019:
3020: ELSE
3021: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', wf_engine.GetItemAttrText (itemtype => itemtype,
3022: itemkey => itemkey,
3023: aname => 'PREVIEW_DATE_NOTSPECIFIED'));
3024: END IF;
3025:
3032:
3033: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3034: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);
3035: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);
3036: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3037: itemkey => itemkey,
3038: aname => 'CLOSECHANGED_REASON'));
3039: ELSIF (p_action_code = 'CLOSECHANGED') then
3040:
3044: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3045: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3046:
3047: IF p_change_type <> 1 THEN --i.e if it is 'NEGOTIATION_SHORTENED'
3048: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3049: itemkey => itemkey,
3050: aname => 'CLOSECHANGED_REASON'));
3051: END IF;
3052:
3215: l_origin_user_name fnd_user.user_name%TYPE;
3216:
3217: BEGIN
3218:
3219: x_doc_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3220: itemkey => p_itemkey,
3221: aname => 'AUCTION_ID');
3222:
3223: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3219: x_doc_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
3220: itemkey => p_itemkey,
3221: aname => 'AUCTION_ID');
3222:
3223: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3224: itemkey => p_itemkey,
3225: aname => 'ORIGIN_USER_NAME');
3226:
3227: x_doctype_group_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3223: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3224: itemkey => p_itemkey,
3225: aname => 'ORIGIN_USER_NAME');
3226:
3227: x_doctype_group_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3228: itemkey => p_itemkey,
3229: aname => 'DOC_INTERNAL_NAME');
3230:
3231: x_startdate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
3227: x_doctype_group_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3228: itemkey => p_itemkey,
3229: aname => 'DOC_INTERNAL_NAME');
3230:
3231: x_startdate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
3232: itemkey => p_itemkey,
3233: aname => 'AUCTION_START_DATE');
3234:
3235: x_enddate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
3231: x_startdate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
3232: itemkey => p_itemkey,
3233: aname => 'AUCTION_START_DATE');
3234:
3235: x_enddate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
3236: itemkey => p_itemkey,
3237: aname => 'AUCTION_END_DATE');
3238:
3239: -- x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3235: x_enddate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
3236: itemkey => p_itemkey,
3237: aname => 'AUCTION_END_DATE');
3238:
3239: -- x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3240: -- itemkey => p_itemkey,
3241: -- aname => 'PREPARER_TP_CONTACT_NAME');
3242:
3243: x_preview_date := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
3239: -- x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3240: -- itemkey => p_itemkey,
3241: -- aname => 'PREPARER_TP_CONTACT_NAME');
3242:
3243: x_preview_date := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
3244: itemkey => p_itemkey,
3245: aname => 'PREVIEW_DATE');
3246:
3247: select auction_header_id_prev_round, trading_partner_contact_name,
3292: FROM dual;
3293:
3294: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
3295:
3296: wf_engine.CreateProcess(itemtype => x_itemtype,
3297: itemkey => x_itemkey,
3298: process => x_process_name);
3299:
3300: --
3300: --
3301: -- Set all the item attributes
3302: --
3303:
3304: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
3305: itemkey => x_itemkey,
3306: aname => 'AUCTION_START_DATE',
3307: avalue => x_startdate);
3308:
3305: itemkey => x_itemkey,
3306: aname => 'AUCTION_START_DATE',
3307: avalue => x_startdate);
3308:
3309: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
3310: itemkey => x_itemkey,
3311: aname => 'AUCTION_END_DATE',
3312: avalue => x_enddate);
3313:
3310: itemkey => x_itemkey,
3311: aname => 'AUCTION_END_DATE',
3312: avalue => x_enddate);
3313:
3314: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
3315: itemkey => x_itemkey,
3316: aname => 'PREVIEW_DATE',
3317: avalue => x_preview_date);
3318:
3315: itemkey => x_itemkey,
3316: aname => 'PREVIEW_DATE',
3317: avalue => x_preview_date);
3318:
3319: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3320: itemkey => x_itemkey,
3321: aname => 'PREPARER_TP_CONTACT_NAME',
3322: avalue => x_auctioneer_user_name);
3323:
3320: itemkey => x_itemkey,
3321: aname => 'PREPARER_TP_CONTACT_NAME',
3322: avalue => x_auctioneer_user_name);
3323:
3324: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3325: itemkey => x_itemkey,
3326: aname => 'BIDDER_TP_NAME',
3327: avalue => x_prev_supplier_name);
3328:
3325: itemkey => x_itemkey,
3326: aname => 'BIDDER_TP_NAME',
3327: avalue => x_prev_supplier_name);
3328:
3329: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3330: itemkey => x_itemkey,
3331: aname => 'BIDDER_TP_ADDRESS_NAME',
3332: avalue => x_prev_supplier_site_code);
3333:
3330: itemkey => x_itemkey,
3331: aname => 'BIDDER_TP_ADDRESS_NAME',
3332: avalue => x_prev_supplier_site_code);
3333:
3334: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3335: itemkey => x_itemkey,
3336: aname => 'ORIGIN_USER_NAME',
3337: avalue => l_origin_user_name);
3338:
3336: aname => 'ORIGIN_USER_NAME',
3337: avalue => l_origin_user_name);
3338:
3339:
3340: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
3341: itemkey => x_itemkey,
3342: aname => 'AUCTION_ID',
3343: avalue => x_doc_header_id); /* using auction_id instead of
3344: auction_number as a standard
3343: avalue => x_doc_header_id); /* using auction_id instead of
3344: auction_number as a standard
3345: across item types */
3346:
3347: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3348: itemkey => p_itemkey,
3349: aname => 'DOC_NUMBER');
3350:
3351: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3347: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3348: itemkey => p_itemkey,
3349: aname => 'DOC_NUMBER');
3350:
3351: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3352: itemkey => x_itemkey,
3353: aname => 'DOC_NUMBER',
3354: avalue => x_doc_number_dsp);
3355:
3352: itemkey => x_itemkey,
3353: aname => 'DOC_NUMBER',
3354: avalue => x_doc_number_dsp);
3355:
3356: x_auction_title := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3357: itemkey => p_itemkey,
3358: aname => 'AUCTION_TITLE');
3359:
3360:
3357: itemkey => p_itemkey,
3358: aname => 'AUCTION_TITLE');
3359:
3360:
3361: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3362: itemkey => x_itemkey,
3363: aname => 'AUCTION_TITLE',
3364: avalue => replaceHtmlChars(x_auction_title));
3365:
3362: itemkey => x_itemkey,
3363: aname => 'AUCTION_TITLE',
3364: avalue => replaceHtmlChars(x_auction_title));
3365:
3366: x_auction_owner_tp_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3367: itemkey => p_itemkey,
3368: aname => 'PREPARER_TP_NAME');
3369:
3370: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3366: x_auction_owner_tp_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
3367: itemkey => p_itemkey,
3368: aname => 'PREPARER_TP_NAME');
3369:
3370: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3371: itemkey => x_itemkey,
3372: aname => 'PREPARER_TP_NAME',
3373: avalue => x_auction_owner_tp_name);
3374:
3371: itemkey => x_itemkey,
3372: aname => 'PREPARER_TP_NAME',
3373: avalue => x_auction_owner_tp_name);
3374:
3375: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3376: itemkey => x_itemkey,
3377: aname => 'DOC_INTERNAL_NAME',
3378: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
3379: itemkey => p_itemkey,
3374:
3375: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3376: itemkey => x_itemkey,
3377: aname => 'DOC_INTERNAL_NAME',
3378: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
3379: itemkey => p_itemkey,
3380: aname => 'DOC_INTERNAL_NAME'));
3381:
3382:
3386: x_staggered_close_note := wf_core.newline || wf_core.newline ||
3387: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
3388: wf_core.newline || wf_core.newline;
3389: END IF;
3390: wf_engine.SetItemAttrText( itemtype => x_itemtype,
3391: itemkey => x_itemkey,
3392: aname => 'STAGGERED_CLOSE_NOTE',
3393: avalue => x_staggered_close_note);
3394: EXCEPTION
3397: END;
3398:
3399: begin
3400:
3401: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3402: itemkey => x_itemkey,
3403: aname => '#WFM_HTMLAGENT',
3404: avalue => pon_wf_utl_pkg.get_base_external_supplier_url);
3405: exception when others then
3409: -- Use the language of the user to send the notification.
3410:
3411: x_bidder_username := prevBidder.user_name;
3412:
3413: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3414: itemkey => x_itemkey,
3415: aname => 'BIDDER_TP_CONTACT_NAME',
3416: avalue => x_bidder_username);
3417:
3465: ELSE
3466: x_timezone1_disp := x_timezone_disp;
3467: END IF;
3468:
3469: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
3470: itemkey => x_itemkey,
3471: aname => 'AUCTION_START_DATE_TZ',
3472: avalue => x_newstarttime);
3473:
3470: itemkey => x_itemkey,
3471: aname => 'AUCTION_START_DATE_TZ',
3472: avalue => x_newstarttime);
3473:
3474: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
3475: itemkey => x_itemkey,
3476: aname => 'AUCTION_END_DATE_TZ',
3477: avalue => x_newendtime);
3478:
3475: itemkey => x_itemkey,
3476: aname => 'AUCTION_END_DATE_TZ',
3477: avalue => x_newendtime);
3478:
3479: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
3480: itemkey => x_itemkey,
3481: aname => 'PREVIEW_DATE_TZ',
3482: avalue => x_newpreviewtime);
3483:
3515: if (x_bidder_name is null or x_bidder_name = '') then
3516: x_bidder_name := prevBidder.user_name;
3517: end if;
3518:
3519: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3520: itemkey => x_itemkey,
3521: aname => 'TP_DISPLAY_NAME',
3522: avalue => x_bidder_name);
3523:
3531: --Bug 6472383 : Shifted the setting of preview date to this place so that the recipient's language, instead
3532: --of the sender's language is taken into account when setting the preview date to 'Not Specified'
3533:
3534: IF (x_newpreviewtime is not null) THEN
3535: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
3536: itemkey => x_itemkey,
3537: aname => 'PREVIEW_DATE_TZ',
3538: avalue => x_newpreviewtime);
3539:
3536: itemkey => x_itemkey,
3537: aname => 'PREVIEW_DATE_TZ',
3538: avalue => x_newpreviewtime);
3539:
3540: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3541: itemkey => x_itemkey,
3542: aname => 'TP_TIME_ZONE1',
3543: avalue => x_timezone1_disp);
3544:
3541: itemkey => x_itemkey,
3542: aname => 'TP_TIME_ZONE1',
3543: avalue => x_timezone1_disp);
3544:
3545: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3546: itemkey => x_itemkey,
3547: aname => 'PREVIEW_DATE_NOTSPECIFIED',
3548: avalue => null);
3549: ELSE
3546: itemkey => x_itemkey,
3547: aname => 'PREVIEW_DATE_NOTSPECIFIED',
3548: avalue => null);
3549: ELSE
3550: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
3551: itemkey => x_itemkey,
3552: aname => 'PREVIEW_DATE_TZ',
3553: avalue => null);
3554:
3551: itemkey => x_itemkey,
3552: aname => 'PREVIEW_DATE_TZ',
3553: avalue => null);
3554:
3555: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3556: itemkey => x_itemkey,
3557: aname => 'TP_TIME_ZONE1',
3558: avalue => x_timezone1_disp);
3559:
3556: itemkey => x_itemkey,
3557: aname => 'TP_TIME_ZONE1',
3558: avalue => x_timezone1_disp);
3559:
3560: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3561: itemkey => x_itemkey,
3562: aname => 'PREVIEW_DATE_NOTSPECIFIED',
3563: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3564: END IF;
3566: x_msg_suffix := GET_MESSAGE_SUFFIX (x_doctype_group_name);
3567:
3568:
3569:
3570: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3571: itemkey => x_itemkey,
3572: aname => 'NON_INVITE_NEW_ROUND_START_SUB',
3573: avalue => getMessage('PON_AUC_WF_PUB_NEWRND_NI_S', x_msg_suffix,
3574: 'DOC_NUMBER', x_doc_number_dsp,
3575: 'AUCTION_TITLE', x_auction_title));
3576:
3577:
3578: -- Bug 4295915: Set the workflow owner
3579: wf_engine.SetItemOwner(itemtype => x_itemtype,
3580: itemkey => x_itemkey,
3581: owner => fnd_global.user_name);
3582:
3583: wf_engine.StartProcess(itemtype => x_itemtype,
3579: wf_engine.SetItemOwner(itemtype => x_itemtype,
3580: itemkey => x_itemkey,
3581: owner => fnd_global.user_name);
3582:
3583: wf_engine.StartProcess(itemtype => x_itemtype,
3584: itemkey => x_itemkey);
3585: end if;
3586:
3587: close c2_inv_list;
3602:
3603: x_flag VARCHAR2(1);
3604: BEGIN
3605:
3606: x_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
3607: itemkey => itemkey,
3608: aname => 'REGISTERED');
3609:
3610:
3639:
3640: BEGIN
3641: x_progress := '010';
3642:
3643: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3644: itemkey => itemkey,
3645: aname => 'AUCTION_ID');
3646:
3647: x_progress := '020';
3673: UPDATE pon_auction_headers_all set
3674: wf_role_name = x_role_name
3675: WHERE auction_header_id = x_auction_header_id;
3676:
3677: wf_engine.SetItemAttrText (itemtype => itemtype,
3678: itemkey => itemkey,
3679: aname => 'NEW_BIDDER_ROLE',
3680: avalue => x_role_name);
3681: x_progress := '030';
3703: BEGIN
3704:
3705: x_progress := '010';
3706:
3707: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3708: itemkey => itemkey,
3709: aname => 'AUCTION_ID');
3710:
3711: x_progress := '20';
3719:
3720:
3721: x_progress := '30';
3722:
3723: x_role_name := wf_engine.GetItemAttrText (itemtype => itemtype,
3724: itemkey => itemkey,
3725: aname => 'NEW_BIDDER_ROLE');
3726:
3727: x_progress := '40';
3797: and rownum = 1;
3798:
3799: BEGIN
3800: x_progress := '010';
3801: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3802: itemkey => itemkey,
3803: aname => 'AUCTION_ID');
3804:
3805: x_progress := '020';
3802: itemkey => itemkey,
3803: aname => 'AUCTION_ID');
3804:
3805: x_progress := '020';
3806: x_role_name := wf_engine.GetItemAttrText (itemtype => itemtype,
3807: itemkey => itemkey,
3808: aname => 'NEW_BIDDER_ROLE');
3809: x_progress := '021';
3810:
4032: BEGIN
4033:
4034: x_progress := '010';
4035:
4036: x_start_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
4037: itemkey => itemkey,
4038: aname => 'AUCTION_NOTIFICATION_DATE');
4039: x_progress := '020';
4040:
4067: BEGIN
4068:
4069: x_progress := '010';
4070:
4071: x_end_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
4072: itemkey => itemkey,
4073: aname => 'AUCTION_END_DATE');
4074: x_progress := '020';
4075:
4101: BEGIN
4102:
4103: x_progress := '010';
4104:
4105: x_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
4106: itemkey => itemkey,
4107: aname => 'BIDDER_LIST_FLAG');
4108:
4109: x_progress := '020';
4293: BEGIN
4294:
4295: x_progress := '010';
4296:
4297: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
4298: itemkey => itemkey,
4299: aname => 'AUCTION_ID');
4300:
4301: x_bidder_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
4297: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
4298: itemkey => itemkey,
4299: aname => 'AUCTION_ID');
4300:
4301: x_bidder_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
4302: itemkey => itemkey,
4303: aname => 'PREPARER_TP_CONTACT_ID');
4304:
4305: x_progress := '020';
4362: BEGIN
4363:
4364: x_progress := '010';
4365:
4366: x_flag := wf_engine.GetItemAttrText (itemtype => itemtype,
4367: itemkey => itemkey,
4368: aname => 'SEALED_FLAG');
4369:
4370: x_progress := '020';
4439: -- Set the workflow attribute
4440: --
4441:
4442: if (x_cancel_reason is null) then
4443: wf_engine.SetItemAttrText(itemtype => x_itemtype,
4444: itemkey => x_itemkey,
4445: aname => 'CANCEL_REASON',
4446: avalue => getMessage('PON_AUC_WF_NO_REASON', ''));
4447: else
4444: itemkey => x_itemkey,
4445: aname => 'CANCEL_REASON',
4446: avalue => getMessage('PON_AUC_WF_NO_REASON', ''));
4447: else
4448: wf_engine.SetItemAttrText(itemtype => x_itemtype,
4449: itemkey => x_itemkey,
4450: aname => 'CANCEL_REASON',
4451: avalue => x_cancel_reason);
4452: end if;
4452: end if;
4453:
4454:
4455: if (x_cancel_date is not null) then
4456: wf_engine.SetItemAttrDate(itemtype => x_itemtype,
4457: itemkey => x_itemkey,
4458: aname => 'CANCEL_DATE',
4459: avalue => x_cancel_date);
4460:
4467: -- 2) Pre 6.1 - waiting for the end of the auction
4468: -- Post 6.1 - waiting for user to complete the auction
4469: --
4470:
4471: wf_engine.CompleteActivity(x_itemtype,x_itemkey,x_current_activity,'PREPARER_CANCEL');
4472:
4473: END;
4474:
4475: FUNCTION GET_CLOSE_BIDDING_DATE(p_auction_header_id IN NUMBER) RETURN DATE
4906: BEGIN
4907:
4908: x_progress := '010';
4909:
4910: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
4911: itemkey => itemkey,
4912: aname => 'AUCTION_ID');
4913:
4914: x_progress := '020';
4936: BEGIN
4937:
4938: x_progress := '010';
4939:
4940: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
4941: itemkey => itemkey,
4942: aname => 'AUCTION_ID');
4943:
4944: x_progress := '020';
5032: x_auction_number NUMBER;
5033:
5034: BEGIN
5035:
5036: x_auction_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5037: itemkey => itemkey,
5038: aname => 'AUCTION_NUMBER');
5039:
5040:
5054: x_auction_number NUMBER;
5055:
5056: BEGIN
5057:
5058: x_auction_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
5059: itemkey => itemkey,
5060: aname => 'AUCTION_ID');
5061:
5062: resultout := is_event_auction(x_auction_number);
5098: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE;
5099:
5100: BEGIN
5101:
5102: x_cancel_reason := wf_engine.GetItemAttrText (itemtype => itemtype,
5103: itemkey => itemkey,
5104: aname => 'CANCEL_REASON');
5105:
5106:
5119: x_closechanged_reason VARCHAR2(2000);
5120:
5121: BEGIN
5122:
5123: x_closechanged_reason := wf_engine.GetItemAttrText (itemtype => itemtype,
5124: itemkey => itemkey,
5125: aname => 'CLOSECHANGED_REASON');
5126:
5127: resultout := empty_reason(x_closechanged_reason);
5139: x_disqualify_reason VARCHAR2(2000);
5140:
5141: BEGIN
5142:
5143: x_disqualify_reason := wf_engine.GetItemAttrText (itemtype => itemtype,
5144: itemkey => itemkey,
5145: aname => 'DISQUALIFY_REASON');
5146:
5147:
5207: -- Otherwise we have an active workflow, so go ahead and complete it
5208: --
5209: -- Get the notification date from the workflow
5210: --
5211: x_notification_date := wf_engine.GetItemAttrDate (itemtype => x_itemtype,
5212: itemkey => x_itemkey,
5213: aname => 'AUCTION_NOTIFICATION_DATE');
5214:
5215: --
5219: -- exception.
5220: --
5221:
5222: IF(x_now > x_notification_date AND x_current_activity = 'WAIT_FOR_AUCTION_COMPLETE') THEN
5223: wf_engine.CompleteActivity(x_itemtype,x_itemkey,'WAIT_FOR_AUCTION_COMPLETE','PREPARER_COMPLETE');
5224: END IF;
5225:
5226: END;
5227:
5376:
5377: --
5378: -- Set the auction end date
5379: --
5380: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
5381: itemkey => x_itemkey,
5382: aname => 'AUCTION_END_DATE',
5383: avalue => p_new_close_date);
5384:
5382: aname => 'AUCTION_END_DATE',
5383: avalue => p_new_close_date);
5384:
5385:
5386: wf_engine.SetItemAttrText(itemtype => x_itemtype,
5387: itemkey => x_itemkey,
5388: aname => 'CLOSECHANGED_REASON',
5389: avalue => replaceHtmlChars(p_closeearly_reason));
5390:
5397: -- 1) Waiting for the start of the auction
5398: -- 2) Pre 6.1 - waiting for the end of the auction
5399: -- Post 6.1 - waiting for user to complete the auction
5400: --
5401: wf_engine.CompleteActivity(x_itemtype,x_itemkey,x_current_activity,'PREPARER_CLOSEEARLY');
5402:
5403: END;
5404:
5405:
5483:
5484: --
5485: -- Set the auction end date
5486: --
5487: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
5488: itemkey => x_itemkey,
5489: aname => 'AUCTION_END_DATE',
5490: avalue => p_new_close_date);
5491:
5490: avalue => p_new_close_date);
5491:
5492: begin
5493:
5494: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
5495: itemkey => x_itemkey,
5496: aname => 'CHANGE_TYPE',
5497: avalue => p_change_type);
5498:
5501: null; -- for auctions created before version 115.20 of ponwfau1.wft this attribute did not exist
5502: end;
5503:
5504: IF p_closechanged_reason IS NOT NULL THEN
5505: wf_engine.SetItemAttrText (itemtype => x_itemtype,
5506: itemkey => x_itemkey,
5507: aname => 'CLOSECHANGED_REASON',
5508: avalue => replaceHtmlChars(p_closechanged_reason));
5509: END IF;
5514: -- 1) Waiting for the start of the auction
5515: -- 2) Pre 6.1 - waiting for the end of the auction
5516: -- Post 6.1 - waiting for user to complete the auction
5517: --
5518: wf_engine.CompleteActivity(x_itemtype,x_itemkey,x_current_activity,'PREPARER_CLOSECHANGED');
5519:
5520:
5521:
5522:
6078:
6079:
6080: begin
6081:
6082: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
6083: itemkey => itemkey,
6084: aname => 'AUCTION_ID');
6085:
6086: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => itemtype,
6082: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
6083: itemkey => itemkey,
6084: aname => 'AUCTION_ID');
6085:
6086: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => itemtype,
6087: itemkey => itemkey,
6088: aname => 'DOC_NUMBER');
6089:
6090: x_auction_title := wf_engine.GetItemAttrText (itemtype => itemtype,
6086: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => itemtype,
6087: itemkey => itemkey,
6088: aname => 'DOC_NUMBER');
6089:
6090: x_auction_title := wf_engine.GetItemAttrText (itemtype => itemtype,
6091: itemkey => itemkey,
6092: aname => 'AUCTION_TITLE');
6093:
6094: x_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
6090: x_auction_title := wf_engine.GetItemAttrText (itemtype => itemtype,
6091: itemkey => itemkey,
6092: aname => 'AUCTION_TITLE');
6093:
6094: x_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
6095: itemkey => itemkey,
6096: aname => 'AUCTION_START_DATE');
6097:
6098: x_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
6094: x_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
6095: itemkey => itemkey,
6096: aname => 'AUCTION_START_DATE');
6097:
6098: x_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
6099: itemkey => itemkey,
6100: aname => 'AUCTION_END_DATE');
6101:
6102: -- Bug 3824928: added below
6099: itemkey => itemkey,
6100: aname => 'AUCTION_END_DATE');
6101:
6102: -- Bug 3824928: added below
6103: -- x_tp_contact_name := wf_engine.GetItemAttrText (itemtype => itemtype,
6104: -- itemkey => itemkey,
6105: -- aname => 'PREPARER_TP_CONTACT_NAME');
6106:
6107:
6105: -- aname => 'PREPARER_TP_CONTACT_NAME');
6106:
6107:
6108:
6109: x_preview_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
6110: itemkey => itemkey,
6111: aname => 'PREVIEW_DATE_TZ');
6112:
6113:
6131: x_message_name := 'NEGOTIATION_CLOSED_EARLY';
6132: elsif (action_code = 'CLOSECHANGED') then
6133:
6134: begin
6135: x_change_type := wf_engine.GetItemAttrNumber (itemtype => itemtype,
6136: itemkey => itemkey,
6137: aname => 'CHANGE_TYPE');
6138: exception
6139: when others then
6341: where auction_header_id = p_auction_id;
6342:
6343: x_progress := '010';
6344:
6345: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
6346: itemkey => p_itemkey,
6347: aname => 'AUCTION_ID');
6348:
6349: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6345: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
6346: itemkey => p_itemkey,
6347: aname => 'AUCTION_ID');
6348:
6349: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6350: itemkey => p_itemkey,
6351: aname => 'AUCTION_ID_ENCRYPTED');
6352:
6353: x_preview_date := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
6349: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6350: itemkey => p_itemkey,
6351: aname => 'AUCTION_ID_ENCRYPTED');
6352:
6353: x_preview_date := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
6354: itemkey => p_itemkey,
6355: aname => 'PREVIEW_DATE');
6356:
6357: x_preview_date_notspec := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6353: x_preview_date := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
6354: itemkey => p_itemkey,
6355: aname => 'PREVIEW_DATE');
6356:
6357: x_preview_date_notspec := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6358: itemkey => p_itemkey,
6359: aname => 'PREVIEW_DATE_NOTSPECIFIED');
6360:
6361: BEGIN
6358: itemkey => p_itemkey,
6359: aname => 'PREVIEW_DATE_NOTSPECIFIED');
6360:
6361: BEGIN
6362: x_doctype_group_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6363: itemkey => p_itemkey,
6364: aname => 'DOC_INTERNAL_NAME');
6365: EXCEPTION
6366: WHEN OTHERS THEN
6371: and auh.doctype_id = dt.doctype_id;
6372: END;
6373:
6374: BEGIN
6375: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6376: itemkey => p_itemkey,
6377: aname => 'DOC_NUMBER');
6378: EXCEPTION
6379: WHEN OTHERS THEN
6392:
6393:
6394: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
6395:
6396: wf_engine.CreateProcess(itemtype => x_itemtype,
6397: itemkey => x_itemkey,
6398: process => 'ADDED_INVITEES_MESSAGE');
6399:
6400: --
6402: --
6403:
6404: x_progress := '022';
6405:
6406: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
6407: itemkey => x_itemkey,
6408: aname => 'AUCTION_ID',
6409: avalue => x_auction_header_id); /* using auction_id instead of
6410: auction_number as a standard
6409: avalue => x_auction_header_id); /* using auction_id instead of
6410: auction_number as a standard
6411: across item types */
6412:
6413: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6414: itemkey => x_itemkey,
6415: aname => 'DOC_NUMBER',
6416: avalue => x_doc_number_dsp);
6417:
6414: itemkey => x_itemkey,
6415: aname => 'DOC_NUMBER',
6416: avalue => x_doc_number_dsp);
6417:
6418: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6419: itemkey => x_itemkey,
6420: aname => 'ORIGIN_USER_NAME',
6421: avalue => fnd_global.user_name);
6422:
6419: itemkey => x_itemkey,
6420: aname => 'ORIGIN_USER_NAME',
6421: avalue => fnd_global.user_name);
6422:
6423: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6424: itemkey => x_itemkey,
6425: aname => 'NOTE_TO_BIDDERS',
6426: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
6427: itemkey => p_itemkey,
6422:
6423: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6424: itemkey => x_itemkey,
6425: aname => 'NOTE_TO_BIDDERS',
6426: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
6427: itemkey => p_itemkey,
6428: aname => 'NOTE_TO_BIDDERS')));
6429:
6430: select view_by_date
6430: select view_by_date
6431: into x_preview_date
6432: from pon_auction_headers_all where auction_header_id = x_auction_header_id;
6433:
6434: x_auction_title := wf_engine.GetItemAttrText(itemtype => p_itemtype,
6435: itemkey => p_itemkey,
6436: aname => 'AUCTION_TITLE');
6437:
6438: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6434: x_auction_title := wf_engine.GetItemAttrText(itemtype => p_itemtype,
6435: itemkey => p_itemkey,
6436: aname => 'AUCTION_TITLE');
6437:
6438: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6439: itemkey => x_itemkey,
6440: aname => 'AUCTION_TITLE',
6441: avalue => replaceHtmlChars(x_auction_title));
6442:
6439: itemkey => x_itemkey,
6440: aname => 'AUCTION_TITLE',
6441: avalue => replaceHtmlChars(x_auction_title));
6442:
6443: x_auction_owner_tp_name := wf_engine.GetItemAttrText(itemtype => p_itemtype,
6444: itemkey => p_itemkey,
6445: aname => 'PREPARER_TP_NAME');
6446:
6447: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6443: x_auction_owner_tp_name := wf_engine.GetItemAttrText(itemtype => p_itemtype,
6444: itemkey => p_itemkey,
6445: aname => 'PREPARER_TP_NAME');
6446:
6447: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6448: itemkey => x_itemkey,
6449: aname => 'PREPARER_TP_NAME',
6450: avalue => x_auction_owner_tp_name);
6451:
6448: itemkey => x_itemkey,
6449: aname => 'PREPARER_TP_NAME',
6450: avalue => x_auction_owner_tp_name);
6451:
6452: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
6453: itemkey => x_itemkey,
6454: aname => 'NUMBER_OF_ITEMS',
6455: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
6456: itemkey => p_itemkey,
6451:
6452: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
6453: itemkey => x_itemkey,
6454: aname => 'NUMBER_OF_ITEMS',
6455: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
6456: itemkey => p_itemkey,
6457: aname => 'NUMBER_OF_ITEMS'));
6458: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
6459: itemkey => x_itemkey,
6454: aname => 'NUMBER_OF_ITEMS',
6455: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
6456: itemkey => p_itemkey,
6457: aname => 'NUMBER_OF_ITEMS'));
6458: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
6459: itemkey => x_itemkey,
6460: aname => 'PREVIEW_DATE',
6461: avalue => x_preview_date);
6462:
6459: itemkey => x_itemkey,
6460: aname => 'PREVIEW_DATE',
6461: avalue => x_preview_date);
6462:
6463: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6464: itemkey => x_itemkey,
6465: aname => 'PREVIEW_DATE_NOTSPECIFIED',
6466: avalue => x_preview_date_notspec);
6467:
6465: aname => 'PREVIEW_DATE_NOTSPECIFIED',
6466: avalue => x_preview_date_notspec);
6467:
6468: BEGIN
6469: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
6470: itemkey => x_itemkey,
6471: aname => 'DOC_ROUND_NUMBER',
6472: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
6473: itemkey => p_itemkey,
6468: BEGIN
6469: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
6470: itemkey => x_itemkey,
6471: aname => 'DOC_ROUND_NUMBER',
6472: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
6473: itemkey => p_itemkey,
6474: aname => 'DOC_ROUND_NUMBER'));
6475: EXCEPTION
6476: WHEN OTHERS THEN
6473: itemkey => p_itemkey,
6474: aname => 'DOC_ROUND_NUMBER'));
6475: EXCEPTION
6476: WHEN OTHERS THEN
6477: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
6478: itemkey => x_itemkey,
6479: aname => 'DOC_ROUND_NUMBER',
6480: avalue => 1);
6481: END;
6479: aname => 'DOC_ROUND_NUMBER',
6480: avalue => 1);
6481: END;
6482:
6483: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6484: itemkey => x_itemkey,
6485: aname => 'DOC_INTERNAL_NAME',
6486: avalue => x_doctype_group_name);
6487:
6486: avalue => x_doctype_group_name);
6487:
6488: begin
6489:
6490: wf_engine.SetItemAttrText (itemtype => x_itemtype,
6491: itemkey => x_itemkey,
6492: aname => '#WFM_HTMLAGENT',
6493: avalue => pon_wf_utl_pkg.get_base_external_supplier_url);
6494: exception when others then
6495: null;
6496: end;
6497:
6498: -- Bug 4295915: Set the workflow owner
6499: wf_engine.SetItemOwner(itemtype => x_itemtype,
6500: itemkey => x_itemkey,
6501: owner => fnd_global.user_name);
6502:
6503: --
6503: --
6504: -- Start the workflow
6505: --
6506:
6507: wf_engine.StartProcess(itemtype => x_itemtype,
6508: itemkey => x_itemkey );
6509:
6510: END;
6511:
6636: from pon_auction_headers_all
6637: where auction_header_id = x_auction_header_id;
6638:
6639: BEGIN
6640: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => x_itemtype,
6641: itemkey => x_itemkey,
6642: aname => 'AUCTION_ID'); /* using auction_id instead of
6643: auction_number as a standard
6644: across item types */
6646: select wf_item_key , trading_partner_contact_name into p_itemkey, x_auctioneer_user_name
6647: from pon_auction_headers_all
6648: where auction_header_id = x_auction_header_id;
6649:
6650: -- x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6651: -- itemkey => p_itemkey,
6652: -- aname => 'PREPARER_TP_CONTACT_NAME');
6653:
6654: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6650: -- x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6651: -- itemkey => p_itemkey,
6652: -- aname => 'PREPARER_TP_CONTACT_NAME');
6653:
6654: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6655: itemkey => p_itemkey,
6656: aname => 'AUCTION_ID_ENCRYPTED');
6657:
6658: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6654: x_auction_header_id_encrypted := wf_engine.GetItemAttrText (itemtype => p_itemtype,
6655: itemkey => p_itemkey,
6656: aname => 'AUCTION_ID_ENCRYPTED');
6657:
6658: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6659: itemkey => x_itemkey,
6660: aname => 'DOC_NUMBER');
6661:
6662: x_auction_owner_tp_name := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6658: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6659: itemkey => x_itemkey,
6660: aname => 'DOC_NUMBER');
6661:
6662: x_auction_owner_tp_name := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6663: itemkey => x_itemkey,
6664: aname => 'PREPARER_TP_NAME');
6665:
6666: x_auction_title := wf_engine.GetItemAttrText(itemtype => x_itemtype,
6662: x_auction_owner_tp_name := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6663: itemkey => x_itemkey,
6664: aname => 'PREPARER_TP_NAME');
6665:
6666: x_auction_title := wf_engine.GetItemAttrText(itemtype => x_itemtype,
6667: itemkey => x_itemkey,
6668: aname => 'AUCTION_TITLE');
6669:
6670:
6667: itemkey => x_itemkey,
6668: aname => 'AUCTION_TITLE');
6669:
6670:
6671: x_preview_date := wf_engine.GetItemAttrDate (itemtype => x_itemtype,
6672: itemkey => x_itemkey,
6673: aname => 'PREVIEW_DATE');
6674:
6675: x_preview_date_notspec := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6671: x_preview_date := wf_engine.GetItemAttrDate (itemtype => x_itemtype,
6672: itemkey => x_itemkey,
6673: aname => 'PREVIEW_DATE');
6674:
6675: x_preview_date_notspec := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6676: itemkey => x_itemkey,
6677: aname => 'PREVIEW_DATE_NOTSPECIFIED');
6678:
6679:
6676: itemkey => x_itemkey,
6677: aname => 'PREVIEW_DATE_NOTSPECIFIED');
6678:
6679:
6680: x_doctype_group_name := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6681: itemkey => x_itemkey,
6682: aname => 'DOC_INTERNAL_NAME');
6683:
6684: x_startdate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
6680: x_doctype_group_name := wf_engine.GetItemAttrText (itemtype => x_itemtype,
6681: itemkey => x_itemkey,
6682: aname => 'DOC_INTERNAL_NAME');
6683:
6684: x_startdate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
6685: itemkey => p_itemkey,
6686: aname => 'AUCTION_START_DATE');
6687:
6688: x_enddate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
6684: x_startdate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
6685: itemkey => p_itemkey,
6686: aname => 'AUCTION_START_DATE');
6687:
6688: x_enddate := wf_engine.GetItemAttrDate (itemtype => p_itemtype,
6689: itemkey => p_itemkey,
6690: aname => 'AUCTION_END_DATE');
6691:
6692: x_msg_suffix := GET_MESSAGE_SUFFIX (x_doctype_group_name);
6812: FROM dual;
6813:
6814: t_itemkey := (x_itemkey||'-'||to_char(x_sequence));
6815:
6816: wf_engine.CreateProcess(itemtype => t_itemtype,
6817: itemkey => t_itemkey,
6818: process => 'SEND_ADDED_INVITEES');
6819:
6820: IF (l_requested_supplier) THEN
6818: process => 'SEND_ADDED_INVITEES');
6819:
6820: IF (l_requested_supplier) THEN
6821:
6822: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6823: itemkey => t_itemkey,
6824: aname => 'REQ_SUPPLIER_CONTACT_NAME',
6825: avalue => bidder.requested_supp_contact_name);
6826: ELSE
6823: itemkey => t_itemkey,
6824: aname => 'REQ_SUPPLIER_CONTACT_NAME',
6825: avalue => bidder.requested_supp_contact_name);
6826: ELSE
6827: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6828: itemkey => t_itemkey,
6829: aname => 'BIDDER_TP_CONTACT_NAME',
6830: avalue => x_user_name);
6831: END IF;
6829: aname => 'BIDDER_TP_CONTACT_NAME',
6830: avalue => x_user_name);
6831: END IF;
6832:
6833: wf_engine.SetItemAttrNumber (itemtype => t_itemtype,
6834: itemkey => t_itemkey,
6835: aname => 'TRADING_PARTNER_ID',
6836: avalue => bidder.trading_partner_id);
6837:
6834: itemkey => t_itemkey,
6835: aname => 'TRADING_PARTNER_ID',
6836: avalue => bidder.trading_partner_id);
6837:
6838: wf_engine.SetItemAttrNumber (itemtype => t_itemtype,
6839: itemkey => t_itemkey,
6840: aname => 'AUCTION_ID',
6841: avalue => x_auction_header_id); /* using auction_id instead of
6842: auction_number as a standard
6848: x_staggered_close_note := wf_core.newline || wf_core.newline ||
6849: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
6850: wf_core.newline || wf_core.newline;
6851: END IF;
6852: wf_engine.SetItemAttrText( itemtype => t_itemtype,
6853: itemkey => t_itemkey,
6854: aname => 'STAGGERED_CLOSE_NOTE',
6855: avalue => x_staggered_close_note);
6856: EXCEPTION WHEN OTHERS THEN NULL;
6869:
6870:
6871: --- 000001
6872:
6873: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6874: itemkey => t_itemkey,
6875: aname => 'INVITE_RESPONSE_SUB',
6876: avalue => getMessage('PON_AUC_WF_PUB_OPEN_RG_S', x_msg_suffix,
6877: 'DOC_NUMBER', x_doc_number_dsp,
6876: avalue => getMessage('PON_AUC_WF_PUB_OPEN_RG_S', x_msg_suffix,
6877: 'DOC_NUMBER', x_doc_number_dsp,
6878: 'AUCTION_TITLE', replaceHtmlChars(x_auction_title)));
6879:
6880: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6881: itemkey => t_itemkey,
6882: aname => 'PREPARER_TP_CONTACT_NAME',
6883: avalue => x_auctioneer_user_name);
6884:
6881: itemkey => t_itemkey,
6882: aname => 'PREPARER_TP_CONTACT_NAME',
6883: avalue => x_auctioneer_user_name);
6884:
6885: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6886: itemkey => t_itemkey,
6887: aname => 'TP_DISPLAY_NAME',
6888: avalue => x_tp_display_name);
6889:
6886: itemkey => t_itemkey,
6887: aname => 'TP_DISPLAY_NAME',
6888: avalue => x_tp_display_name);
6889:
6890: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6891: itemkey => t_itemkey,
6892: aname => 'BIDDER_TP_NAME',
6893: avalue => x_tp_display_name);
6894:
6891: itemkey => t_itemkey,
6892: aname => 'BIDDER_TP_NAME',
6893: avalue => x_tp_display_name);
6894:
6895: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6896: itemkey => t_itemkey,
6897: aname => 'BIDDER_TP_ADDRESS_NAME',
6898: avalue => x_vendor_site_code);
6899:
6897: aname => 'BIDDER_TP_ADDRESS_NAME',
6898: avalue => x_vendor_site_code);
6899:
6900: -- Item attribute value is going to be used as a parameter to Acknowledge Participation page
6901: wf_engine.SetItemAttrNumber (itemtype => t_itemtype,
6902: itemkey => t_itemkey,
6903: aname => 'VENDOR_SITE_ID',
6904: avalue => x_vendor_site_id);
6905:
6908: x_neg_summary_url_supplier := pon_wf_utl_pkg.get_dest_page_url (
6909: p_dest_func => 'PON_NEG_SUMMARY'
6910: ,p_notif_performer => 'SUPPLIER');
6911:
6912: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6913: itemkey => t_itemkey,
6914: aname => 'NEG_SUMMARY_URL',
6915: avalue => x_neg_summary_url_supplier);
6916:
6914: aname => 'NEG_SUMMARY_URL',
6915: avalue => x_neg_summary_url_supplier);
6916:
6917: begin
6918: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6919: itemkey => t_itemkey,
6920: aname => '#WFM_HTMLAGENT',
6921: avalue => pon_wf_utl_pkg.get_base_external_supplier_url);
6922: exception
6926:
6927: if (x_open_bidding_date < sysdate) then
6928:
6929:
6930: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6931: itemkey => t_itemkey,
6932: aname => 'PON_AUC_WF_DOC_IN_PR0G',
6933: avalue => getMessage('PON_AUC_WF_DOC_IN_PR0G', x_msg_suffix));
6934:
6934:
6935: end if;
6936:
6937:
6938: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6939: itemkey => t_itemkey,
6940: aname => 'PREPARER_TP_NAME',
6941: avalue => x_auction_owner_tp_name);
6942:
6940: aname => 'PREPARER_TP_NAME',
6941: avalue => x_auction_owner_tp_name);
6942:
6943:
6944: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6945: itemkey => t_itemkey,
6946: aname => 'AUCTION_TITLE',
6947: avalue => replaceHtmlChars(x_auction_title));
6948:
6946: aname => 'AUCTION_TITLE',
6947: avalue => replaceHtmlChars(x_auction_title));
6948:
6949:
6950: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6951: itemkey => t_itemkey,
6952: aname => 'DOC_NUMBER',
6953: avalue => x_doc_number_dsp);
6954:
6959: x_timezone1_disp := x_timezone_disp;
6960: END IF;
6961:
6962: IF (x_preview_date is not null) THEN
6963: wf_engine.SetItemAttrDate (itemtype => t_itemtype,
6964: itemkey => t_itemkey,
6965: aname => 'PREVIEW_DATE',
6966: avalue => x_newpreviewtime);
6967:
6964: itemkey => t_itemkey,
6965: aname => 'PREVIEW_DATE',
6966: avalue => x_newpreviewtime);
6967:
6968: wf_engine.SetItemAttrDate (itemtype => t_itemtype,
6969: itemkey => t_itemkey,
6970: aname => 'PREVIEW_DATE_TZ',
6971: avalue => x_newpreviewtime);
6972:
6969: itemkey => t_itemkey,
6970: aname => 'PREVIEW_DATE_TZ',
6971: avalue => x_newpreviewtime);
6972:
6973: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6974: itemkey => t_itemkey,
6975: aname => 'TP_TIME_ZONE1',
6976: avalue => x_timezone1_disp);
6977:
6974: itemkey => t_itemkey,
6975: aname => 'TP_TIME_ZONE1',
6976: avalue => x_timezone1_disp);
6977:
6978: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6979: itemkey => t_itemkey,
6980: aname => 'PREVIEW_DATE_NOTSPECIFIED',
6981: avalue => null);
6982: ELSE
6979: itemkey => t_itemkey,
6980: aname => 'PREVIEW_DATE_NOTSPECIFIED',
6981: avalue => null);
6982: ELSE
6983: wf_engine.SetItemAttrDate (itemtype => t_itemtype,
6984: itemkey => t_itemkey,
6985: aname => 'PREVIEW_DATE',
6986: avalue => null);
6987:
6984: itemkey => t_itemkey,
6985: aname => 'PREVIEW_DATE',
6986: avalue => null);
6987:
6988: wf_engine.SetItemAttrDate (itemtype => t_itemtype,
6989: itemkey => t_itemkey,
6990: aname => 'PREVIEW_DATE_TZ',
6991: avalue => null);
6992:
6989: itemkey => t_itemkey,
6990: aname => 'PREVIEW_DATE_TZ',
6991: avalue => null);
6992:
6993: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6994: itemkey => t_itemkey,
6995: aname => 'TP_TIME_ZONE1',
6996: avalue => x_timezone1_disp);
6997:
6994: itemkey => t_itemkey,
6995: aname => 'TP_TIME_ZONE1',
6996: avalue => x_timezone1_disp);
6997:
6998: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6999: itemkey => t_itemkey,
7000: aname => 'PREVIEW_DATE_NOTSPECIFIED',
7001: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
7002:
7001: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
7002:
7003: END IF;
7004:
7005: wf_engine.SetItemAttrDate (itemtype => t_itemtype,
7006: itemkey => t_itemkey,
7007: aname => 'AUCTION_START_DATE_TZ',
7008: avalue => x_newstarttime);
7009:
7006: itemkey => t_itemkey,
7007: aname => 'AUCTION_START_DATE_TZ',
7008: avalue => x_newstarttime);
7009:
7010: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7011: itemkey => t_itemkey,
7012: aname => 'TP_TIME_ZONE',
7013: avalue => x_timezone_disp);
7014:
7012: aname => 'TP_TIME_ZONE',
7013: avalue => x_timezone_disp);
7014:
7015:
7016: wf_engine.SetItemAttrDate (itemtype => t_itemtype,
7017: itemkey => t_itemkey,
7018: aname => 'AUCTION_END_DATE_TZ',
7019: avalue => x_newendtime);
7020:
7017: itemkey => t_itemkey,
7018: aname => 'AUCTION_END_DATE_TZ',
7019: avalue => x_newendtime);
7020:
7021: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7022: itemkey => t_itemkey,
7023: aname => 'ORIGIN_USER_NAME',
7024: avalue => fnd_global.user_name);
7025:
7048:
7049:
7050: x_additional_user_name := ('WF_PON_USER_'||to_char(x_sequence));
7051:
7052: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7053: itemkey => t_itemkey,
7054: aname => 'ADDITIONAL_CONTACT_USERNAME',
7055: avalue => x_additional_user_name);
7056:
7069: x_isp_supplier_register_url := pon_wf_utl_pkg.get_isp_supplier_register_url(p_registration_key => x_registration_key
7070: ,p_language_code => x_language_code);
7071:
7072:
7073: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7074: itemkey => t_itemkey,
7075: aname => 'ISP_SUPPLIER_REG_URL',
7076: avalue => x_isp_supplier_register_url);
7077:
7080: x_ack_part_url_supplier := pon_wf_utl_pkg.get_dest_page_url (
7081: p_dest_func => 'PONRESAPN_ACKPARTICIPATN'
7082: ,p_notif_performer => 'SUPPLIER');
7083:
7084: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7085: itemkey => t_itemkey,
7086: aname => 'ACK_PARTICIPATION_URL',
7087: avalue => x_ack_part_url_supplier);
7088:
7139:
7140: IF (x_bidder_count < 1) THEN --{
7141:
7142: x_rs_user_name := ('WF_PON_USER_'||to_char(x_sequence));
7143: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7144: itemkey => t_itemkey,
7145: aname => 'REQ_SUPPLIER_USERNAME',
7146: avalue => x_rs_user_name); --(performer)
7147:
7148: x_ack_part_url_supplier := pon_wf_utl_pkg.get_dest_page_url (
7149: p_dest_func => 'PONRESAPN_ACKPARTICIPATN'
7150: ,p_notif_performer => 'SUPPLIER');
7151:
7152: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7153: itemkey => t_itemkey,
7154: aname => 'ACK_PARTICIPATION_URL',
7155: avalue => x_ack_part_url_supplier);
7156:
7181:
7182: END IF; --} if requested supplier
7183:
7184: -- Bug 4295915: Set the workflow owner
7185: wf_engine.SetItemOwner(itemtype => t_itemtype,
7186: itemkey => t_itemkey,
7187: owner => fnd_global.user_name);
7188:
7189: wf_engine.StartProcess(itemtype => t_itemtype,
7185: wf_engine.SetItemOwner(itemtype => t_itemtype,
7186: itemkey => t_itemkey,
7187: owner => fnd_global.user_name);
7188:
7189: wf_engine.StartProcess(itemtype => t_itemtype,
7190: itemkey => t_itemkey );
7191:
7192: -- Bug 3709564
7193: -- If this update is not performed here, wf_engine.abort_process call
7189: wf_engine.StartProcess(itemtype => t_itemtype,
7190: itemkey => t_itemkey );
7191:
7192: -- Bug 3709564
7193: -- If this update is not performed here, wf_engine.abort_process call
7194: -- in notify_bidder_list_reminder will fail, as wf_item_key will be null
7195: update pon_bidding_parties
7196: set wf_item_key = t_itemkey
7197: where auction_header_id = x_auction_header_id and
7216: select wf_item_key into x_item_key
7217: from pon_auction_headers_all
7218: where auction_header_id = p_auction_header_id;
7219:
7220: wf_engine.SetItemAttrText (itemtype => 'PONAUCT',
7221: itemkey => x_item_key,
7222: aname => 'BIDDER_LIST_FLAG',
7223: avalue => 'Y');
7224: END;
7531: -- Hardcoded sequence number not acceptable
7532: l_seq := 9999;
7533: l_itemkey := to_char (document_id)|| '-' || l_seq;
7534:
7535: wf_engine.createProcess ( ItemType => l_ItemType,
7536: ItemKey => l_ItemKey,
7537: Process => 'MAIN_AUCTION_PROCESS');
7538:
7539: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7535: wf_engine.createProcess ( ItemType => l_ItemType,
7536: ItemKey => l_ItemKey,
7537: Process => 'MAIN_AUCTION_PROCESS');
7538:
7539: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7540: itemkey => l_ItemKey,
7541: aname => 'XML_EVENT_KEY',
7542: avalue => l_itemkey);
7543:
7540: itemkey => l_ItemKey,
7541: aname => 'XML_EVENT_KEY',
7542: avalue => l_itemkey);
7543:
7544: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7545: itemkey => l_ItemKey,
7546: aname => 'ECX_TRANSACTION_TYPE',
7547: avalue => 'PON_AUPO');
7548: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7544: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7545: itemkey => l_ItemKey,
7546: aname => 'ECX_TRANSACTION_TYPE',
7547: avalue => 'PON_AUPO');
7548: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7549: itemkey => l_ItemKey,
7550: aname => 'ECX_TRANSACTION_SUBTYPE',
7551: avalue => 'AUPO');
7552:
7549: itemkey => l_ItemKey,
7550: aname => 'ECX_TRANSACTION_SUBTYPE',
7551: avalue => 'AUPO');
7552:
7553: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7554: itemkey => l_ItemKey,
7555: aname => 'ECX_DOCUMENT_ID',
7556: avalue => document_id);
7557:
7554: itemkey => l_ItemKey,
7555: aname => 'ECX_DOCUMENT_ID',
7556: avalue => document_id);
7557:
7558: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7559: itemkey => l_ItemKey,
7560: aname => 'ECX_PARTY_ID',
7561: avalue => party_id);
7562:
7559: itemkey => l_ItemKey,
7560: aname => 'ECX_PARTY_ID',
7561: avalue => party_id);
7562:
7563: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7564: itemkey => l_ItemKey,
7565: aname => 'ECX_PARTY_SITE_ID',
7566: avalue => party_id);
7567:
7564: itemkey => l_ItemKey,
7565: aname => 'ECX_PARTY_SITE_ID',
7566: avalue => party_id);
7567:
7568: wf_engine.SetItemAttrText ( itemtype => l_ItemType,
7569: itemkey => l_ItemKey,
7570: aname => 'ECX_DEBUG_LEVEL',
7571: avalue => l_debug_level );
7572:
7570: aname => 'ECX_DEBUG_LEVEL',
7571: avalue => l_debug_level );
7572:
7573: -- Bug 4295915: Set the workflow owner
7574: wf_engine.SetItemOwner(itemtype => l_itemtype,
7575: itemkey => l_itemkey,
7576: owner => fnd_global.user_name);
7577:
7578: wf_engine.StartProcess ( ItemType => l_ItemType,
7574: wf_engine.SetItemOwner(itemtype => l_itemtype,
7575: itemkey => l_itemkey,
7576: owner => fnd_global.user_name);
7577:
7578: wf_engine.StartProcess ( ItemType => l_ItemType,
7579: ItemKey => l_ItemKey );
7580:
7581: END AUCTION_PO_SEND;
7582:
7589: l_doc_id number;
7590: l_xml_event_key varchar2(100);
7591: l_wf_item_seq number;
7592: BEGIN
7593: if (funcmode <> wf_engine.eng_run) then
7594: resultout := wf_engine.eng_null;
7595: return; --do not raise the exception, as it would end the wflow.
7596: end if;
7597: l_doc_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
7590: l_xml_event_key varchar2(100);
7591: l_wf_item_seq number;
7592: BEGIN
7593: if (funcmode <> wf_engine.eng_run) then
7594: resultout := wf_engine.eng_null;
7595: return; --do not raise the exception, as it would end the wflow.
7596: end if;
7597: l_doc_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
7598: 'ECX_DOCUMENT_ID');
7593: if (funcmode <> wf_engine.eng_run) then
7594: resultout := wf_engine.eng_null;
7595: return; --do not raise the exception, as it would end the wflow.
7596: end if;
7597: l_doc_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
7598: 'ECX_DOCUMENT_ID');
7599: /* sequence number hardcoded
7600: select PON_PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;
7601: */
7602: l_wf_item_seq := 9999;
7603:
7604: l_xml_event_key := to_char(l_doc_id) || '-' || to_char(l_wf_item_seq);
7605:
7606: wf_engine.SetItemAttrText ( itemtype => itemType,
7607: itemkey => itemkey,
7608: aname => 'XML_EVENT_KEY',
7609: avalue => l_xml_event_key);
7610:
7627: x_this_auction_header_id NUMBER;
7628:
7629: BEGIN
7630:
7631: x_this_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7632: itemkey => itemkey,
7633: aname => 'AUCTION_ID');
7634:
7635: SELECT close_bidding_date, reminder_date
7666:
7667: BEGIN
7668:
7669:
7670: x_wf_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
7671: itemkey => itemkey,
7672: aname => 'BIDDER_TP_CONTACT_NAME');
7673:
7674: x_trading_partner_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7670: x_wf_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
7671: itemkey => itemkey,
7672: aname => 'BIDDER_TP_CONTACT_NAME');
7673:
7674: x_trading_partner_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7675: itemkey => itemkey,
7676: aname => 'TRADING_PARTNER_ID');
7677:
7678: x_vendor_site_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7674: x_trading_partner_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7675: itemkey => itemkey,
7676: aname => 'TRADING_PARTNER_ID');
7677:
7678: x_vendor_site_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7679: itemkey => itemkey,
7680: aname => 'VENDOR_SITE_ID');
7681:
7682: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7678: x_vendor_site_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7679: itemkey => itemkey,
7680: aname => 'VENDOR_SITE_ID');
7681:
7682: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7683: itemkey => itemkey,
7684: aname => 'AUCTION_ID'); /* using auction_id instead of
7685: auction_number as a standard
7686: across item types */
7685: auction_number as a standard
7686: across item types */
7687:
7688:
7689: x_note := wf_engine.GetItemAttrText (itemtype => itemtype,
7690: itemkey => itemkey,
7691: aname => 'NOTE_TO_BUYER');
7692:
7693: SELECT close_bidding_date,auction_status
7738:
7739: BEGIN
7740:
7741:
7742: x_wf_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
7743: itemkey => itemkey,
7744: aname => 'BIDDER_TP_CONTACT_NAME');
7745:
7746: x_trading_partner_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7742: x_wf_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
7743: itemkey => itemkey,
7744: aname => 'BIDDER_TP_CONTACT_NAME');
7745:
7746: x_trading_partner_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7747: itemkey => itemkey,
7748: aname => 'TRADING_PARTNER_ID');
7749:
7750: x_vendor_site_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7746: x_trading_partner_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7747: itemkey => itemkey,
7748: aname => 'TRADING_PARTNER_ID');
7749:
7750: x_vendor_site_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7751: itemkey => itemkey,
7752: aname => 'VENDOR_SITE_ID');
7753:
7754: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7750: x_vendor_site_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7751: itemkey => itemkey,
7752: aname => 'VENDOR_SITE_ID');
7753:
7754: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
7755: itemkey => itemkey,
7756: aname => 'AUCTION_ID'); /* using auction_id instead of
7757: auction_number as a standard
7758: across item types */
7756: aname => 'AUCTION_ID'); /* using auction_id instead of
7757: auction_number as a standard
7758: across item types */
7759:
7760: x_note := wf_engine.GetItemAttrText (itemtype => itemtype,
7761: itemkey => itemkey,
7762: aname => 'NOTE_TO_BUYER');
7763:
7764: SELECT close_bidding_date,auction_status
7934: INTO x_sequence
7935: FROM dual;
7936: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
7937:
7938: wf_engine.CreateProcess(itemtype => x_itemtype,
7939: itemkey => x_itemkey,
7940: process => p_process);
7941:
7942: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7938: wf_engine.CreateProcess(itemtype => x_itemtype,
7939: itemkey => x_itemkey,
7940: process => p_process);
7941:
7942: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7943: itemkey => x_itemkey,
7944: aname => 'BIDDER_TP_CONTACT_NAME',
7945: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
7946: itemkey => p_itemkey,
7941:
7942: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7943: itemkey => x_itemkey,
7944: aname => 'BIDDER_TP_CONTACT_NAME',
7945: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
7946: itemkey => p_itemkey,
7947: aname => 'BIDDER_TP_CONTACT_NAME'));
7948:
7949: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7945: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
7946: itemkey => p_itemkey,
7947: aname => 'BIDDER_TP_CONTACT_NAME'));
7948:
7949: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7950: itemkey => x_itemkey,
7951: aname => 'ORIGIN_USER_NAME',
7952: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
7953: itemkey => p_itemkey,
7948:
7949: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7950: itemkey => x_itemkey,
7951: aname => 'ORIGIN_USER_NAME',
7952: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
7953: itemkey => p_itemkey,
7954: aname => 'ORIGIN_USER_NAME'));
7955:
7956: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
7952: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
7953: itemkey => p_itemkey,
7954: aname => 'ORIGIN_USER_NAME'));
7955:
7956: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
7957: itemkey => x_itemkey,
7958: aname => 'AUCTION_ID',
7959: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
7960: itemkey => p_itemkey,
7955:
7956: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
7957: itemkey => x_itemkey,
7958: aname => 'AUCTION_ID',
7959: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
7960: itemkey => p_itemkey,
7961: aname => 'AUCTION_ID')); /* using auction_id instead of
7962: auction_number as a standard
7963: across item types */
7961: aname => 'AUCTION_ID')); /* using auction_id instead of
7962: auction_number as a standard
7963: across item types */
7964:
7965: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
7966: itemkey => x_itemkey,
7967: aname => 'INVITATION_ID',
7968: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
7969: itemkey => p_itemkey,
7964:
7965: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
7966: itemkey => x_itemkey,
7967: aname => 'INVITATION_ID',
7968: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
7969: itemkey => p_itemkey,
7970: aname => 'INVITATION_ID'));
7971:
7972: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7968: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
7969: itemkey => p_itemkey,
7970: aname => 'INVITATION_ID'));
7971:
7972: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7973: itemkey => x_itemkey,
7974: aname => 'EVENT_TITLE',
7975: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
7976: itemkey => p_itemkey,
7971:
7972: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7973: itemkey => x_itemkey,
7974: aname => 'EVENT_TITLE',
7975: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
7976: itemkey => p_itemkey,
7977: aname => 'EVENT_TITLE')));
7978:
7979: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7975: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
7976: itemkey => p_itemkey,
7977: aname => 'EVENT_TITLE')));
7978:
7979: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7980: itemkey => x_itemkey,
7981: aname => 'AUCTION_DESCRIPTION',
7982: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
7983: itemkey => p_itemkey,
7978:
7979: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7980: itemkey => x_itemkey,
7981: aname => 'AUCTION_DESCRIPTION',
7982: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
7983: itemkey => p_itemkey,
7984: aname => 'AUCTION_DESCRIPTION')));
7985:
7986: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
7982: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
7983: itemkey => p_itemkey,
7984: aname => 'AUCTION_DESCRIPTION')));
7985:
7986: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
7987: itemkey => x_itemkey,
7988: aname => 'AUCTION_START_DATE',
7989: avalue => wf_engine.GetItemAttrDate (itemtype => p_itemtype,
7990: itemkey => p_itemkey,
7985:
7986: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
7987: itemkey => x_itemkey,
7988: aname => 'AUCTION_START_DATE',
7989: avalue => wf_engine.GetItemAttrDate (itemtype => p_itemtype,
7990: itemkey => p_itemkey,
7991: aname => 'AUCTION_START_DATE'));
7992:
7993: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
7989: avalue => wf_engine.GetItemAttrDate (itemtype => p_itemtype,
7990: itemkey => p_itemkey,
7991: aname => 'AUCTION_START_DATE'));
7992:
7993: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
7994: itemkey => x_itemkey,
7995: aname => 'AUCTION_END_DATE',
7996: avalue => wf_engine.GetItemAttrDate (itemtype => p_itemtype,
7997: itemkey => p_itemkey,
7992:
7993: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
7994: itemkey => x_itemkey,
7995: aname => 'AUCTION_END_DATE',
7996: avalue => wf_engine.GetItemAttrDate (itemtype => p_itemtype,
7997: itemkey => p_itemkey,
7998: aname => 'AUCTION_END_DATE'));
7999:
8000: wf_engine.SetItemAttrText (itemtype => x_itemtype,
7996: avalue => wf_engine.GetItemAttrDate (itemtype => p_itemtype,
7997: itemkey => p_itemkey,
7998: aname => 'AUCTION_END_DATE'));
7999:
8000: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8001: itemkey => x_itemkey,
8002: aname => 'NOTE_TO_BIDDERS',
8003: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
8004: itemkey => p_itemkey,
7999:
8000: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8001: itemkey => x_itemkey,
8002: aname => 'NOTE_TO_BIDDERS',
8003: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
8004: itemkey => p_itemkey,
8005: aname => 'NOTE_TO_BIDDERS')));
8006:
8007: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8003: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
8004: itemkey => p_itemkey,
8005: aname => 'NOTE_TO_BIDDERS')));
8006:
8007: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8008: itemkey => x_itemkey,
8009: aname => 'TP_DISPLAY_NAME',
8010: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8011: itemkey => p_itemkey,
8006:
8007: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8008: itemkey => x_itemkey,
8009: aname => 'TP_DISPLAY_NAME',
8010: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8011: itemkey => p_itemkey,
8012: aname => 'TP_DISPLAY_NAME'));
8013:
8014:
8011: itemkey => p_itemkey,
8012: aname => 'TP_DISPLAY_NAME'));
8013:
8014:
8015: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8016: itemkey => x_itemkey,
8017: aname => 'PON_AUC_WF_DOC_TYPE_OPEN',
8018: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8019: itemkey => p_itemkey,
8014:
8015: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8016: itemkey => x_itemkey,
8017: aname => 'PON_AUC_WF_DOC_TYPE_OPEN',
8018: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8019: itemkey => p_itemkey,
8020: aname => 'PON_AUC_WF_DOC_TYPE_OPEN'));
8021:
8022: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8018: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8019: itemkey => p_itemkey,
8020: aname => 'PON_AUC_WF_DOC_TYPE_OPEN'));
8021:
8022: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8023: itemkey => x_itemkey,
8024: aname => 'PON_AUC_WF_DOC_TYPE_CLOSE',
8025: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8026: itemkey => p_itemkey,
8021:
8022: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8023: itemkey => x_itemkey,
8024: aname => 'PON_AUC_WF_DOC_TYPE_CLOSE',
8025: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8026: itemkey => p_itemkey,
8027: aname => 'PON_AUC_WF_DOC_TYPE_CLOSE'));
8028:
8029: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8025: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8026: itemkey => p_itemkey,
8027: aname => 'PON_AUC_WF_DOC_TYPE_CLOSE'));
8028:
8029: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8030: itemkey => x_itemkey,
8031: aname => 'PON_AUC_WF_PUB_OPEN_RG_S',
8032: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8033: itemkey => p_itemkey,
8028:
8029: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8030: itemkey => x_itemkey,
8031: aname => 'PON_AUC_WF_PUB_OPEN_RG_S',
8032: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8033: itemkey => p_itemkey,
8034: aname => 'PON_AUC_WF_PUB_OPEN_RG_S'));
8035:
8036: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8032: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8033: itemkey => p_itemkey,
8034: aname => 'PON_AUC_WF_PUB_OPEN_RG_S'));
8035:
8036: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8037: itemkey => x_itemkey,
8038: aname => 'PON_AUC_WF_PUB_OPEN_RG_M1',
8039: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8040: itemkey => p_itemkey,
8035:
8036: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8037: itemkey => x_itemkey,
8038: aname => 'PON_AUC_WF_PUB_OPEN_RG_M1',
8039: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8040: itemkey => p_itemkey,
8041: aname => 'PON_AUC_WF_PUB_OPEN_RG_M1'));
8042:
8043: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8039: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8040: itemkey => p_itemkey,
8041: aname => 'PON_AUC_WF_PUB_OPEN_RG_M1'));
8042:
8043: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8044: itemkey => x_itemkey,
8045: aname => 'PLACE_BID',
8046: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8047: itemkey =>p_itemkey,
8042:
8043: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8044: itemkey => x_itemkey,
8045: aname => 'PLACE_BID',
8046: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8047: itemkey =>p_itemkey,
8048: aname => 'PLACE_BID'));
8049:
8050: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8046: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8047: itemkey =>p_itemkey,
8048: aname => 'PLACE_BID'));
8049:
8050: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8051: itemkey => x_itemkey,
8052: aname => 'PON_AUC_WF_TOACKNOWLEDGE',
8053: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8054: itemkey => p_itemkey,
8049:
8050: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8051: itemkey => x_itemkey,
8052: aname => 'PON_AUC_WF_TOACKNOWLEDGE',
8053: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8054: itemkey => p_itemkey,
8055: aname => 'PON_AUC_WF_TOACKNOWLEDGE'));
8056:
8057: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8053: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8054: itemkey => p_itemkey,
8055: aname => 'PON_AUC_WF_TOACKNOWLEDGE'));
8056:
8057: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8058: itemkey => x_itemkey,
8059: aname => 'PREPARER_TP_NAME',
8060: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8061: itemkey => p_itemkey,
8056:
8057: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8058: itemkey => x_itemkey,
8059: aname => 'PREPARER_TP_NAME',
8060: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8061: itemkey => p_itemkey,
8062: aname => 'PREPARER_TP_NAME'));
8063:
8064:
8061: itemkey => p_itemkey,
8062: aname => 'PREPARER_TP_NAME'));
8063:
8064:
8065: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
8066: itemkey => x_itemkey,
8067: aname => 'NUMBER_OF_ITEMS',
8068: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
8069: itemkey => p_itemkey,
8064:
8065: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
8066: itemkey => x_itemkey,
8067: aname => 'NUMBER_OF_ITEMS',
8068: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
8069: itemkey => p_itemkey,
8070: aname => 'NUMBER_OF_ITEMS'));
8071: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8072: itemkey => x_itemkey,
8067: aname => 'NUMBER_OF_ITEMS',
8068: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
8069: itemkey => p_itemkey,
8070: aname => 'NUMBER_OF_ITEMS'));
8071: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8072: itemkey => x_itemkey,
8073: aname => 'AUCTION_TITLE',
8074: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
8075: itemkey => p_itemkey,
8070: aname => 'NUMBER_OF_ITEMS'));
8071: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8072: itemkey => x_itemkey,
8073: aname => 'AUCTION_TITLE',
8074: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
8075: itemkey => p_itemkey,
8076: aname => 'AUCTION_TITLE')));
8077:
8078: -- wf_engine.SetItemAttrText (itemtype => x_itemtype,
8074: avalue => replaceHtmlChars(wf_engine.GetItemAttrText (itemtype => p_itemtype,
8075: itemkey => p_itemkey,
8076: aname => 'AUCTION_TITLE')));
8077:
8078: -- wf_engine.SetItemAttrText (itemtype => x_itemtype,
8079: -- itemkey => x_itemkey,
8080: -- aname => 'OEX_OPERATION',
8081: -- avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8082: -- itemkey => p_itemkey,
8077:
8078: -- wf_engine.SetItemAttrText (itemtype => x_itemtype,
8079: -- itemkey => x_itemkey,
8080: -- aname => 'OEX_OPERATION',
8081: -- avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8082: -- itemkey => p_itemkey,
8083: -- aname => 'OEX_OPERATION'));
8084:
8085: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8081: -- avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8082: -- itemkey => p_itemkey,
8083: -- aname => 'OEX_OPERATION'));
8084:
8085: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8086: itemkey => x_itemkey,
8087: aname => 'OEX_OPERATION_URL',
8088: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8089: itemkey => p_itemkey,
8084:
8085: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8086: itemkey => x_itemkey,
8087: aname => 'OEX_OPERATION_URL',
8088: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8089: itemkey => p_itemkey,
8090: aname => 'OEX_OPERATION_URL'));
8091: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8092: itemkey => x_itemkey,
8087: aname => 'OEX_OPERATION_URL',
8088: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8089: itemkey => p_itemkey,
8090: aname => 'OEX_OPERATION_URL'));
8091: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8092: itemkey => x_itemkey,
8093: aname => 'TP_TIME_ZONE',
8094: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8095: itemkey => p_itemkey,
8090: aname => 'OEX_OPERATION_URL'));
8091: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8092: itemkey => x_itemkey,
8093: aname => 'TP_TIME_ZONE',
8094: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8095: itemkey => p_itemkey,
8096: aname => 'TP_TIME_ZONE'));
8097:
8098: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8094: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8095: itemkey => p_itemkey,
8096: aname => 'TP_TIME_ZONE'));
8097:
8098: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8099: itemkey => x_itemkey,
8100: aname => 'AUCTION_TYPE_NAME',
8101: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8102: itemkey => p_itemkey,
8097:
8098: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8099: itemkey => x_itemkey,
8100: aname => 'AUCTION_TYPE_NAME',
8101: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8102: itemkey => p_itemkey,
8103: aname => 'AUCTION_TYPE_NAME'));
8104:
8105: /*
8102: itemkey => p_itemkey,
8103: aname => 'AUCTION_TYPE_NAME'));
8104:
8105: /*
8106: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8107: itemkey => x_itemkey,
8108: aname => 'OEX_OPERATION_START',
8109: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8110: itemkey => p_itemkey,
8105: /*
8106: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8107: itemkey => x_itemkey,
8108: aname => 'OEX_OPERATION_START',
8109: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8110: itemkey => p_itemkey,
8111: aname => 'OEX_OPERATION_START'));
8112:
8113:
8110: itemkey => p_itemkey,
8111: aname => 'OEX_OPERATION_START'));
8112:
8113:
8114: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8115: itemkey => x_itemkey,
8116: aname => 'TEXT_HEADER',
8117: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8118: itemkey => p_itemkey,
8113:
8114: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8115: itemkey => x_itemkey,
8116: aname => 'TEXT_HEADER',
8117: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8118: itemkey => p_itemkey,
8119: aname => 'TEXT_HEADER'));
8120:
8121: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8117: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8118: itemkey => p_itemkey,
8119: aname => 'TEXT_HEADER'));
8120:
8121: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8122: itemkey => x_itemkey,
8123: aname => 'TEXT_FOOTER',
8124: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8125: itemkey => p_itemkey,
8120:
8121: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8122: itemkey => x_itemkey,
8123: aname => 'TEXT_FOOTER',
8124: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8125: itemkey => p_itemkey,
8126: aname => 'TEXT_FOOTER'));
8127:
8128:
8125: itemkey => p_itemkey,
8126: aname => 'TEXT_FOOTER'));
8127:
8128:
8129: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8130: itemkey => x_itemkey,
8131: aname => 'HTML_HEADER',
8132: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8133: itemkey => p_itemkey,
8128:
8129: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8130: itemkey => x_itemkey,
8131: aname => 'HTML_HEADER',
8132: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8133: itemkey => p_itemkey,
8134: aname => 'HTML_HEADER'));
8135:
8136: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8132: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8133: itemkey => p_itemkey,
8134: aname => 'HTML_HEADER'));
8135:
8136: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8137: itemkey => x_itemkey,
8138: aname => 'HTML_FOOTER',
8139: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8140: itemkey => p_itemkey,
8135:
8136: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8137: itemkey => x_itemkey,
8138: aname => 'HTML_FOOTER',
8139: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8140: itemkey => p_itemkey,
8141: aname => 'HTML_FOOTER'));
8142: */
8143: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8139: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8140: itemkey => p_itemkey,
8141: aname => 'HTML_FOOTER'));
8142: */
8143: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8144: itemkey => x_itemkey,
8145: aname => 'TP_LANGUAGE_CODE',
8146: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8147: itemkey => p_itemkey,
8142: */
8143: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8144: itemkey => x_itemkey,
8145: aname => 'TP_LANGUAGE_CODE',
8146: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8147: itemkey => p_itemkey,
8148: aname => 'TP_LANGUAGE_CODE'));
8149:
8150: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8146: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8147: itemkey => p_itemkey,
8148: aname => 'TP_LANGUAGE_CODE'));
8149:
8150: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8151: itemkey => x_itemkey,
8152: aname => 'PON_AUC_WF_DOC_TITLE',
8153: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8154: itemkey => p_itemkey,
8149:
8150: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8151: itemkey => x_itemkey,
8152: aname => 'PON_AUC_WF_DOC_TITLE',
8153: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8154: itemkey => p_itemkey,
8155: aname => 'PON_AUC_WF_DOC_TITLE'));
8156:
8157:
8154: itemkey => p_itemkey,
8155: aname => 'PON_AUC_WF_DOC_TITLE'));
8156:
8157:
8158: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8159: itemkey => x_itemkey,
8160: aname => 'PON_AUC_WF_DOC_NUM',
8161: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8162: itemkey => p_itemkey,
8157:
8158: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8159: itemkey => x_itemkey,
8160: aname => 'PON_AUC_WF_DOC_NUM',
8161: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8162: itemkey => p_itemkey,
8163: aname => 'PON_AUC_WF_DOC_NUM'));
8164:
8165: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8161: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8162: itemkey => p_itemkey,
8163: aname => 'PON_AUC_WF_DOC_NUM'));
8164:
8165: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8166: itemkey => x_itemkey,
8167: aname => 'PON_AUC_WF_DOC_EVENT',
8168: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8169: itemkey => p_itemkey,
8164:
8165: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8166: itemkey => x_itemkey,
8167: aname => 'PON_AUC_WF_DOC_EVENT',
8168: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8169: itemkey => p_itemkey,
8170: aname => 'PON_AUC_WF_DOC_EVENT'));
8171:
8172: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8168: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8169: itemkey => p_itemkey,
8170: aname => 'PON_AUC_WF_DOC_EVENT'));
8171:
8172: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8173: itemkey => x_itemkey,
8174: aname => 'PON_AUC_WF_PUB_NEWRND_M1',
8175: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8176: itemkey => p_itemkey,
8171:
8172: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8173: itemkey => x_itemkey,
8174: aname => 'PON_AUC_WF_PUB_NEWRND_M1',
8175: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8176: itemkey => p_itemkey,
8177: aname => 'PON_AUC_WF_PUB_NEWRND_M1'));
8178:
8179: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8175: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8176: itemkey => p_itemkey,
8177: aname => 'PON_AUC_WF_PUB_NEWRND_M1'));
8178:
8179: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8180: itemkey => x_itemkey,
8181: aname => 'PON_AUC_WF_PUB_NEWRND_M2',
8182: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8183: itemkey => p_itemkey,
8178:
8179: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8180: itemkey => x_itemkey,
8181: aname => 'PON_AUC_WF_PUB_NEWRND_M2',
8182: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8183: itemkey => p_itemkey,
8184: aname => 'PON_AUC_WF_PUB_NEWRND_M2'));
8185:
8186: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8182: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8183: itemkey => p_itemkey,
8184: aname => 'PON_AUC_WF_PUB_NEWRND_M2'));
8185:
8186: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8187: itemkey => x_itemkey,
8188: aname => 'PON_AUC_WF_PUB_NEWRND_RG_S',
8189: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8190: itemkey => p_itemkey,
8185:
8186: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8187: itemkey => x_itemkey,
8188: aname => 'PON_AUC_WF_PUB_NEWRND_RG_S',
8189: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8190: itemkey => p_itemkey,
8191: aname => 'PON_AUC_WF_PUB_NEWRND_RG_S'));
8192:
8193: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8189: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8190: itemkey => p_itemkey,
8191: aname => 'PON_AUC_WF_PUB_NEWRND_RG_S'));
8192:
8193: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8194: itemkey => x_itemkey,
8195: aname => 'PON_AUC_WF_AUCTIONEER',
8196: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8197: itemkey => p_itemkey,
8192:
8193: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8194: itemkey => x_itemkey,
8195: aname => 'PON_AUC_WF_AUCTIONEER',
8196: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8197: itemkey => p_itemkey,
8198: aname => 'PON_AUC_WF_AUCTIONEER'));
8199:
8200: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8196: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8197: itemkey => p_itemkey,
8198: aname => 'PON_AUC_WF_AUCTIONEER'));
8199:
8200: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8201: itemkey => x_itemkey,
8202: aname => 'PREVIEW_MESSAGE',
8203: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8204: itemkey => p_itemkey,
8199:
8200: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8201: itemkey => x_itemkey,
8202: aname => 'PREVIEW_MESSAGE',
8203: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8204: itemkey => p_itemkey,
8205: aname => 'PREVIEW_MESSAGE'));
8206:
8207: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
8203: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8204: itemkey => p_itemkey,
8205: aname => 'PREVIEW_MESSAGE'));
8206:
8207: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
8208: itemkey => x_itemkey,
8209: aname => 'AUCTION_NOTIFICATION_DATE',
8210: avalue => wf_engine.GetItemAttrDate (itemtype => p_itemtype,
8211: itemkey => p_itemkey,
8206:
8207: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
8208: itemkey => x_itemkey,
8209: aname => 'AUCTION_NOTIFICATION_DATE',
8210: avalue => wf_engine.GetItemAttrDate (itemtype => p_itemtype,
8211: itemkey => p_itemkey,
8212: aname => 'AUCTION_NOTIFICATION_DATE'));
8213:
8214: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8210: avalue => wf_engine.GetItemAttrDate (itemtype => p_itemtype,
8211: itemkey => p_itemkey,
8212: aname => 'AUCTION_NOTIFICATION_DATE'));
8213:
8214: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8215: itemkey => x_itemkey,
8216: aname => 'TP_TIME_ZONE1',
8217: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8218: itemkey => p_itemkey,
8213:
8214: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8215: itemkey => x_itemkey,
8216: aname => 'TP_TIME_ZONE1',
8217: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8218: itemkey => p_itemkey,
8219: aname => 'TP_TIME_ZONE1'));
8220:
8221: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8217: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8218: itemkey => p_itemkey,
8219: aname => 'TP_TIME_ZONE1'));
8220:
8221: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8222: itemkey => x_itemkey,
8223: aname => 'ARTICLE_DOC_TYPE',
8224: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8225: itemkey => p_itemkey,
8220:
8221: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8222: itemkey => x_itemkey,
8223: aname => 'ARTICLE_DOC_TYPE',
8224: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8225: itemkey => p_itemkey,
8226: aname => 'ARTICLE_DOC_TYPE'));
8227: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8228: itemkey => x_itemkey,
8223: aname => 'ARTICLE_DOC_TYPE',
8224: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8225: itemkey => p_itemkey,
8226: aname => 'ARTICLE_DOC_TYPE'));
8227: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8228: itemkey => x_itemkey,
8229: aname => 'APPSTR',
8230: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8231: itemkey => p_itemkey,
8226: aname => 'ARTICLE_DOC_TYPE'));
8227: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8228: itemkey => x_itemkey,
8229: aname => 'APPSTR',
8230: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8231: itemkey => p_itemkey,
8232: aname => 'APPSTR'));
8233:
8234:
8231: itemkey => p_itemkey,
8232: aname => 'APPSTR'));
8233:
8234:
8235: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8236: itemkey => x_itemkey,
8237: aname => 'APP',
8238: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8239: itemkey => p_itemkey,
8234:
8235: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8236: itemkey => x_itemkey,
8237: aname => 'APP',
8238: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8239: itemkey => p_itemkey,
8240: aname => 'APP'));
8241:
8242: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8238: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8239: itemkey => p_itemkey,
8240: aname => 'APP'));
8241:
8242: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8243: itemkey => x_itemkey,
8244: aname => 'DOC_NUMBER',
8245: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8246: itemkey => p_itemkey,
8241:
8242: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8243: itemkey => x_itemkey,
8244: aname => 'DOC_NUMBER',
8245: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8246: itemkey => p_itemkey,
8247: aname => 'DOC_NUMBER'));
8248:
8249: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
8245: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8246: itemkey => p_itemkey,
8247: aname => 'DOC_NUMBER'));
8248:
8249: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
8250: itemkey => x_itemkey,
8251: aname => 'TRADING_PARTNER_ID',
8252: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
8253: itemkey => p_itemkey,
8248:
8249: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
8250: itemkey => x_itemkey,
8251: aname => 'TRADING_PARTNER_ID',
8252: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
8253: itemkey => p_itemkey,
8254: aname => 'TRADING_PARTNER_ID'));
8255:
8256: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8252: avalue => wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
8253: itemkey => p_itemkey,
8254: aname => 'TRADING_PARTNER_ID'));
8255:
8256: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8257: itemkey => x_itemkey,
8258: aname => 'ADDITIONAL_CONTACT_USERNAME',
8259: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8260: itemkey => p_itemkey,
8255:
8256: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8257: itemkey => x_itemkey,
8258: aname => 'ADDITIONAL_CONTACT_USERNAME',
8259: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8260: itemkey => p_itemkey,
8261: aname => 'ADDITIONAL_CONTACT_USERNAME'));
8262:
8263: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8259: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8260: itemkey => p_itemkey,
8261: aname => 'ADDITIONAL_CONTACT_USERNAME'));
8262:
8263: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8264: itemkey => x_itemkey,
8265: aname => 'PON_AUC_WF_DOC_IN_PR0G',
8266: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8267: itemkey => p_itemkey,
8262:
8263: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8264: itemkey => x_itemkey,
8265: aname => 'PON_AUC_WF_DOC_IN_PR0G',
8266: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8267: itemkey => p_itemkey,
8268: aname => 'PON_AUC_WF_DOC_IN_PR0G'));
8269:
8270: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8266: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8267: itemkey => p_itemkey,
8268: aname => 'PON_AUC_WF_DOC_IN_PR0G'));
8269:
8270: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8271: itemkey => x_itemkey,
8272: aname => 'PON_AUC_WF_LOGON_BEFORE',
8273: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8274: itemkey => p_itemkey,
8269:
8270: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8271: itemkey => x_itemkey,
8272: aname => 'PON_AUC_WF_LOGON_BEFORE',
8273: avalue => wf_engine.GetItemAttrText (itemtype => p_itemtype,
8274: itemkey => p_itemkey,
8275: aname => 'PON_AUC_WF_LOGON_BEFORE'));
8276:
8277: -- Bug 4295915: Set the workflow owner
8274: itemkey => p_itemkey,
8275: aname => 'PON_AUC_WF_LOGON_BEFORE'));
8276:
8277: -- Bug 4295915: Set the workflow owner
8278: wf_engine.SetItemOwner(itemtype => x_itemtype,
8279: itemkey => x_itemkey,
8280: owner => fnd_global.user_name);
8281:
8282: wf_engine.StartProcess(itemtype => x_itemtype,
8278: wf_engine.SetItemOwner(itemtype => x_itemtype,
8279: itemkey => x_itemkey,
8280: owner => fnd_global.user_name);
8281:
8282: wf_engine.StartProcess(itemtype => x_itemtype,
8283: itemkey => x_itemkey );
8284:
8285: -- For members, store item key in pom_bidding_parties
8286: x_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
8282: wf_engine.StartProcess(itemtype => x_itemtype,
8283: itemkey => x_itemkey );
8284:
8285: -- For members, store item key in pom_bidding_parties
8286: x_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => p_itemtype,
8287: itemkey => p_itemkey,
8288: aname => 'AUCTION_ID'); /* using auction_id instead of
8289: auction_number as a standard
8290: across item types */
8288: aname => 'AUCTION_ID'); /* using auction_id instead of
8289: auction_number as a standard
8290: across item types */
8291:
8292: x_tp_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
8293: itemkey => p_itemkey,
8294: aname => 'TRADING_PARTNER_ID');
8295:
8296:
8389: l_origin_user_name fnd_user.user_name%TYPE;
8390:
8391: BEGIN
8392:
8393: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
8394: itemkey => itemkey,
8395: aname => 'AUCTION_ID');
8396:
8397: x_doc_internal_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8393: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,
8394: itemkey => itemkey,
8395: aname => 'AUCTION_ID');
8396:
8397: x_doc_internal_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8398: itemkey => itemkey,
8399: aname => 'DOC_INTERNAL_NAME');
8400:
8401: BEGIN
8398: itemkey => itemkey,
8399: aname => 'DOC_INTERNAL_NAME');
8400:
8401: BEGIN
8402: x_preview_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
8403: itemkey => itemkey,
8404: aname => 'PREVIEW_DATE');
8405:
8406: x_preview_date_notspec := wf_engine.GetItemAttrText (itemtype => itemtype,
8402: x_preview_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
8403: itemkey => itemkey,
8404: aname => 'PREVIEW_DATE');
8405:
8406: x_preview_date_notspec := wf_engine.GetItemAttrText (itemtype => itemtype,
8407: itemkey => itemkey,
8408: aname => 'PREVIEW_DATE_NOTSPECIFIED');
8409: EXCEPTION
8410: WHEN NO_DATA_FOUND
8418: END;
8419:
8420: x_msg_suffix := GET_MESSAGE_SUFFIX (x_doc_internal_name);
8421:
8422: x_doc_number_dsp := wf_engine.GetItemAttrText (itemtype => itemtype,
8423: itemkey => itemkey,
8424: aname => 'DOC_NUMBER');
8425: x_oex_timezone := Get_Oex_Time_Zone;
8426:
8423: itemkey => itemkey,
8424: aname => 'DOC_NUMBER');
8425: x_oex_timezone := Get_Oex_Time_Zone;
8426:
8427: -- x_auction_tp_contact_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8428: -- itemkey => itemkey,
8429: -- aname => 'PREPARER_TP_CONTACT_NAME');
8430:
8431:
8428: -- itemkey => itemkey,
8429: -- aname => 'PREPARER_TP_CONTACT_NAME');
8430:
8431:
8432: x_auction_tp_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8433: itemkey => itemkey,
8434: aname => 'PREPARER_TP_NAME');
8435:
8436: x_auction_contact_dp_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8432: x_auction_tp_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8433: itemkey => itemkey,
8434: aname => 'PREPARER_TP_NAME');
8435:
8436: x_auction_contact_dp_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8437: itemkey => itemkey,
8438: aname => 'PREPARER_CONTACT_DP_NAME');
8439:
8440: x_auction_title := wf_engine.GetItemAttrText (itemtype => itemtype,
8436: x_auction_contact_dp_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8437: itemkey => itemkey,
8438: aname => 'PREPARER_CONTACT_DP_NAME');
8439:
8440: x_auction_title := wf_engine.GetItemAttrText (itemtype => itemtype,
8441: itemkey => itemkey,
8442: aname => 'AUCTION_TITLE');
8443:
8444: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8440: x_auction_title := wf_engine.GetItemAttrText (itemtype => itemtype,
8441: itemkey => itemkey,
8442: aname => 'AUCTION_TITLE');
8443:
8444: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8445: itemkey => itemkey,
8446: aname => 'ORIGIN_USER_NAME');
8447:
8448: x_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
8444: l_origin_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
8445: itemkey => itemkey,
8446: aname => 'ORIGIN_USER_NAME');
8447:
8448: x_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
8449: itemkey => itemkey,
8450: aname => 'AUCTION_START_DATE');
8451:
8452: x_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
8448: x_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
8449: itemkey => itemkey,
8450: aname => 'AUCTION_START_DATE');
8451:
8452: x_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemtype,
8453: itemkey => itemkey,
8454: aname => 'AUCTION_END_DATE');
8455:
8456: begin
8525: if bidder.additional_contact_email is not null then -- {
8526:
8527: if bidder.trading_partner_contact_id is null then -- {
8528: -- use auctioneer's language
8529: --x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => 'PONAUCT',
8530: -- itemkey => x_wf_item_key,
8531: -- aname => 'PREPARER_TP_CONTACT_NAME');
8532: x_auctioneer_user_name := x_auction_tp_contact_name;
8533:
8570: x_tp_display_name := bidder.my_user_display_name;
8571:
8572: x_itemkey := (itemkey||'-'||to_char(x_sequence));
8573:
8574: wf_engine.CreateProcess(itemtype => x_itemtype,
8575: itemkey => x_itemkey,
8576: process => x_process_name);
8577:
8578: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8574: wf_engine.CreateProcess(itemtype => x_itemtype,
8575: itemkey => x_itemkey,
8576: process => x_process_name);
8577:
8578: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8579: itemkey => x_itemkey,
8580: aname => 'PREPARER_TP_CONTACT_NAME',
8581: avalue => x_auction_tp_contact_name);
8582:
8579: itemkey => x_itemkey,
8580: aname => 'PREPARER_TP_CONTACT_NAME',
8581: avalue => x_auction_tp_contact_name);
8582:
8583: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8584: itemkey => x_itemkey,
8585: aname => 'ORIGIN_USER_NAME',
8586: avalue => l_origin_user_name);
8587:
8584: itemkey => x_itemkey,
8585: aname => 'ORIGIN_USER_NAME',
8586: avalue => l_origin_user_name);
8587:
8588: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8589: itemkey => x_itemkey,
8590: aname => 'BIDDER_TP_NAME',
8591: avalue => bidder.my_user_display_name);
8592:
8589: itemkey => x_itemkey,
8590: aname => 'BIDDER_TP_NAME',
8591: avalue => bidder.my_user_display_name);
8592:
8593: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8594: itemkey => x_itemkey,
8595: aname => 'BIDDER_TP_ADDRESS_NAME',
8596: avalue => bidder.vendor_site_code);
8597:
8595: aname => 'BIDDER_TP_ADDRESS_NAME',
8596: avalue => bidder.vendor_site_code);
8597:
8598:
8599: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8600: itemkey => x_itemkey,
8601: aname => 'REGISTERED',
8602: avalue => x_member_flag);
8603:
8600: itemkey => x_itemkey,
8601: aname => 'REGISTERED',
8602: avalue => x_member_flag);
8603:
8604: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8605: itemkey => x_itemkey,
8606: aname => 'DOC_NUMBER',
8607: avalue => x_doc_number_dsp);
8608:
8606: aname => 'DOC_NUMBER',
8607: avalue => x_doc_number_dsp);
8608:
8609:
8610: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8611: itemkey => x_itemkey,
8612: aname => 'BIDDER_TP_CONTACT_NAME',
8613: avalue => bidder.my_user_name);
8614:
8612: aname => 'BIDDER_TP_CONTACT_NAME',
8613: avalue => bidder.my_user_name);
8614:
8615:
8616: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8617: itemkey => x_itemkey,
8618: aname=> 'PREPARER_TP_NAME',
8619: avalue => x_auction_tp_name);
8620:
8618: aname=> 'PREPARER_TP_NAME',
8619: avalue => x_auction_tp_name);
8620:
8621:
8622: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
8623: itemkey => x_itemkey,
8624: aname => 'TRADING_PARTNER_ID',
8625: avalue => bidder.trading_partner_id);
8626:
8624: aname => 'TRADING_PARTNER_ID',
8625: avalue => bidder.trading_partner_id);
8626:
8627:
8628: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8629: itemkey => x_itemkey,
8630: aname => 'PREPARER_CONTACT_DP_NAME',
8631: avalue => x_auction_contact_dp_name);
8632:
8630: aname => 'PREPARER_CONTACT_DP_NAME',
8631: avalue => x_auction_contact_dp_name);
8632:
8633:
8634: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8635: itemkey => x_itemkey,
8636: aname => 'INVITE_REMINDER_SUB',
8637: avalue => getMessage('PON_AUC_WF_REQA', x_msg_suffix,
8638: 'DOC_NUMBER', x_doc_number_dsp,
8641: -- Set the values of AUCTION_START_DATE and AUCTION_END_DATE
8642: -- as the end_date is used to determine the timeout for the notifications
8643: -- sent to the supplier
8644:
8645: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
8646: itemkey => x_itemkey,
8647: aname => 'AUCTION_START_DATE',
8648: avalue => x_auction_start_date);
8649:
8646: itemkey => x_itemkey,
8647: aname => 'AUCTION_START_DATE',
8648: avalue => x_auction_start_date);
8649:
8650: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
8651: itemkey => x_itemkey,
8652: aname => 'AUCTION_END_DATE',
8653: avalue => x_auction_end_date);
8654:
8653: avalue => x_auction_end_date);
8654:
8655: -- Bug 6965954: End of Code Fix
8656:
8657: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8658: itemkey => x_itemkey,
8659: aname => 'TP_DISPLAY_NAME',
8660: avalue => x_tp_display_name);
8661:
8659: aname => 'TP_DISPLAY_NAME',
8660: avalue => x_tp_display_name);
8661:
8662:
8663: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8664: itemkey => x_itemkey,
8665: aname => 'AUCTION_TITLE',
8666: avalue => replaceHtmlChars(x_auction_title));
8667:
8665: aname => 'AUCTION_TITLE',
8666: avalue => replaceHtmlChars(x_auction_title));
8667:
8668:
8669: wf_engine.SetItemAttrNumber (itemtype => x_itemtype,
8670: itemkey => x_itemkey,
8671: aname => 'AUCTION_ID',
8672: avalue => x_doc_number); /* using auction_id instead of
8673: auction_number as a standard
8673: auction_number as a standard
8674: across item types */
8675:
8676:
8677: wf_engine.SetItemAttrDate(itemtype => x_itemtype,
8678: itemkey => x_itemkey,
8679: aname => 'AUCTION_END_DATE_TZ',
8680: avalue => x_newendtime);
8681:
8678: itemkey => x_itemkey,
8679: aname => 'AUCTION_END_DATE_TZ',
8680: avalue => x_newendtime);
8681:
8682: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
8683: itemkey => x_itemkey,
8684: aname => 'AUCTION_START_DATE_TZ',
8685: avalue => x_newstarttime);
8686:
8689: x_neg_summary_url_supplier := pon_wf_utl_pkg.get_dest_page_url (
8690: p_dest_func => 'PON_NEG_SUMMARY'
8691: ,p_notif_performer => 'SUPPLIER');
8692:
8693: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8694: itemkey => x_itemkey,
8695: aname => 'NEG_SUMMARY_URL',
8696: avalue => x_neg_summary_url_supplier);
8697:
8701: p_dest_func => 'PONRESAPN_ACKPARTICIPATN'
8702: ,p_notif_performer => 'SUPPLIER');
8703:
8704: begin
8705: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8706: itemkey => x_itemkey,
8707: aname => '#WFM_HTMLAGENT',
8708: avalue => pon_wf_utl_pkg.get_base_external_supplier_url);
8709: exception
8711: null;
8712: end;
8713:
8714:
8715: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8716: itemkey => x_itemkey,
8717: aname => 'ACK_PARTICIPATION_URL',
8718: avalue => x_ack_part_url_supplier);
8719:
8723: ELSE
8724: x_timezone1_disp := x_timezone_disp;
8725: END IF;
8726:
8727: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8728: itemkey => x_itemkey,
8729: aname => 'TP_TIME_ZONE',
8730: avalue => x_timezone_disp);
8731:
8729: aname => 'TP_TIME_ZONE',
8730: avalue => x_timezone_disp);
8731:
8732: IF (x_preview_date is not null) THEN
8733: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
8734: itemkey => x_itemkey,
8735: aname => 'PREVIEW_DATE_TZ',
8736: avalue => x_newpreviewtime);
8737:
8734: itemkey => x_itemkey,
8735: aname => 'PREVIEW_DATE_TZ',
8736: avalue => x_newpreviewtime);
8737:
8738: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8739: itemkey => x_itemkey,
8740: aname => 'TP_TIME_ZONE1',
8741: avalue => x_timezone1_disp);
8742:
8739: itemkey => x_itemkey,
8740: aname => 'TP_TIME_ZONE1',
8741: avalue => x_timezone1_disp);
8742:
8743: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8744: itemkey => x_itemkey,
8745: aname => 'PREVIEW_DATE_NOTSPECIFIED',
8746: avalue => null);
8747:
8745: aname => 'PREVIEW_DATE_NOTSPECIFIED',
8746: avalue => null);
8747:
8748: ELSE
8749: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
8750: itemkey => x_itemkey,
8751: aname => 'PREVIEW_DATE_TZ',
8752: avalue => null);
8753:
8750: itemkey => x_itemkey,
8751: aname => 'PREVIEW_DATE_TZ',
8752: avalue => null);
8753:
8754: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8755: itemkey => x_itemkey,
8756: aname => 'TP_TIME_ZONE1',
8757: avalue => x_timezone1_disp);
8758:
8755: itemkey => x_itemkey,
8756: aname => 'TP_TIME_ZONE1',
8757: avalue => x_timezone1_disp);
8758:
8759: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8760: itemkey => x_itemkey,
8761: aname => 'PREVIEW_DATE_NOTSPECIFIED',
8762: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
8763:
8766:
8767:
8768: if (bidder.additional_contact_email is not null) then
8769:
8770: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8771: itemkey => x_itemkey,
8772: aname => 'ADDITIONAL_CONTACT_USERNAME',
8773: avalue => bidder.additional_name);
8774:
8786: -- call to notification utility package to get the iSupplier registration page url
8787: x_isp_supplier_register_url := pon_wf_utl_pkg.get_isp_supplier_register_url(p_registration_key => x_registration_key
8788: ,p_language_code => x_language_code);
8789:
8790: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8791: itemkey => x_itemkey,
8792: aname => 'ISP_SUPPLIER_REG_URL',
8793: avalue => x_isp_supplier_register_url);
8794:
8795: end if;
8796:
8797:
8798: -- Bug 4295915: Set the workflow owner
8799: wf_engine.SetItemOwner(itemtype => x_itemtype,
8800: itemkey => x_itemkey,
8801: owner => fnd_global.user_name);
8802:
8803: wf_engine.StartProcess(itemtype => x_itemtype,
8799: wf_engine.SetItemOwner(itemtype => x_itemtype,
8800: itemkey => x_itemkey,
8801: owner => fnd_global.user_name);
8802:
8803: wf_engine.StartProcess(itemtype => x_itemtype,
8804: itemkey => x_itemkey );
8805:
8806: -- Bug 3824928: replacing if x_member_flag ='Y' with IF trading
8807: -- partner contact id is not null
8809: IF bidder.trading_partner_contact_id IS NOT NULL THEN -- {
8810:
8811: -- For members, store item key in pon_bidding_parties
8812: -- End the previous waiting process
8813: Wf_Engine.AbortProcess(x_itemtype, bidder.wf_item_key, '', null);
8814:
8815: UPDATE pon_bidding_parties set
8816: wf_item_key = x_itemkey
8817: WHERE trading_partner_id = bidder.trading_partner_id
9986: FROM dual;
9987:
9988: x_itemkey := p_auction_header_id||'-'|| l_sequence;
9989:
9990: wf_engine.CreateProcess(itemtype => x_itemtype,
9991: itemkey => x_itemkey,
9992: process => 'TEAM_MEM_TASK_ASSIGNED');
9993: l_progress := '060';
9994:
10025: p_timezone_disp => l_timezone_disp);
10026:
10027: l_progress := '090';
10028:
10029: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10030: itemkey => x_itemkey,
10031: aname => 'DOC_NUMBER',
10032: avalue => l_doc_number);
10033:
10030: itemkey => x_itemkey,
10031: aname => 'DOC_NUMBER',
10032: avalue => l_doc_number);
10033:
10034: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10035: itemkey => x_itemkey,
10036: aname => 'AUCTION_TITLE',
10037: avalue => l_auction_title);
10038:
10035: itemkey => x_itemkey,
10036: aname => 'AUCTION_TITLE',
10037: avalue => l_auction_title);
10038:
10039: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10040: itemkey => x_itemkey,
10041: aname => 'PREPARER_TP_CONTACT_NAME',
10042: avalue => l_auctioneer_user_name);
10043:
10040: itemkey => x_itemkey,
10041: aname => 'PREPARER_TP_CONTACT_NAME',
10042: avalue => l_auctioneer_user_name);
10043:
10044: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10045: itemkey => x_itemkey,
10046: aname => 'ORIGIN_USER_NAME',
10047: avalue => fnd_global.user_name);
10048:
10045: itemkey => x_itemkey,
10046: aname => 'ORIGIN_USER_NAME',
10047: avalue => fnd_global.user_name);
10048:
10049: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10050: itemkey => x_itemkey,
10051: aname => 'RECIPIENT_ROLE',
10052: avalue => l_user_name);
10053:
10050: itemkey => x_itemkey,
10051: aname => 'RECIPIENT_ROLE',
10052: avalue => l_user_name);
10053:
10054: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10055: itemkey => x_itemkey,
10056: aname => 'PREPARER_TP_NAME',
10057: avalue => l_preparer_tp_name);
10058:
10055: itemkey => x_itemkey,
10056: aname => 'PREPARER_TP_NAME',
10057: avalue => l_preparer_tp_name);
10058:
10059: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
10060: itemkey => x_itemkey,
10061: aname => 'TASK_TARGET_DATE',
10062: avalue => l_task_target_date);
10063:
10060: itemkey => x_itemkey,
10061: aname => 'TASK_TARGET_DATE',
10062: avalue => l_task_target_date);
10063:
10064: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10065: itemkey => x_itemkey,
10066: aname => 'TASK_NAME',
10067: avalue => l_task_name);
10068:
10065: itemkey => x_itemkey,
10066: aname => 'TASK_NAME',
10067: avalue => l_task_name);
10068:
10069: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10070: itemkey => x_itemkey,
10071: aname => 'TASK_ASSIGNED_SUBJECT',
10072: avalue => l_task_assigned_subject);
10073:
10070: itemkey => x_itemkey,
10071: aname => 'TASK_ASSIGNED_SUBJECT',
10072: avalue => l_task_assigned_subject);
10073:
10074: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10075: itemkey => x_itemkey,
10076: aname => 'AUCTION_ID',
10077: avalue => p_auction_header_id);
10078:
10078:
10079: l_progress := '100';
10080:
10081: -- Bug 4295915: Set the workflow owner
10082: wf_engine.SetItemOwner(itemtype => x_itemtype,
10083: itemkey => x_itemkey,
10084: owner => fnd_global.user_name);
10085:
10086: wf_engine.StartProcess(itemtype => x_itemtype,
10082: wf_engine.SetItemOwner(itemtype => x_itemtype,
10083: itemkey => x_itemkey,
10084: owner => fnd_global.user_name);
10085:
10086: wf_engine.StartProcess(itemtype => x_itemtype,
10087: itemkey => x_itemkey );
10088:
10089:
10090: l_progress := 'END';
10388: FROM dual;
10389:
10390: x_itemkey := p_auction_header_id||'-'|| l_sequence;
10391:
10392: wf_engine.CreateProcess(itemtype => x_itemtype,
10393: itemkey => x_itemkey,
10394: process => 'TEAM_MEM_TASK_COMPLTD');
10395: l_progress := '060';
10396:
10426: p_timezone_disp => l_timezone_disp);
10427:
10428: l_progress := '091';
10429:
10430: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10431: itemkey => x_itemkey,
10432: aname => 'DOC_NUMBER',
10433: avalue => l_doc_number);
10434:
10431: itemkey => x_itemkey,
10432: aname => 'DOC_NUMBER',
10433: avalue => l_doc_number);
10434:
10435: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10436: itemkey => x_itemkey,
10437: aname => 'AUCTION_TITLE',
10438: avalue => l_auction_title);
10439:
10436: itemkey => x_itemkey,
10437: aname => 'AUCTION_TITLE',
10438: avalue => l_auction_title);
10439:
10440: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10441: itemkey => x_itemkey,
10442: aname => 'PREPARER_TP_CONTACT_NAME',
10443: avalue => l_auctioneer_user_name);
10444:
10441: itemkey => x_itemkey,
10442: aname => 'PREPARER_TP_CONTACT_NAME',
10443: avalue => l_auctioneer_user_name);
10444:
10445: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10446: itemkey => x_itemkey,
10447: aname => 'RECIPIENT_ROLE',
10448: avalue => l_user_name);
10449:
10446: itemkey => x_itemkey,
10447: aname => 'RECIPIENT_ROLE',
10448: avalue => l_user_name);
10449:
10450: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10451: itemkey => x_itemkey,
10452: aname => 'PREPARER_TP_NAME',
10453: avalue => l_preparer_tp_name);
10454:
10451: itemkey => x_itemkey,
10452: aname => 'PREPARER_TP_NAME',
10453: avalue => l_preparer_tp_name);
10454:
10455: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
10456: itemkey => x_itemkey,
10457: aname => 'TASK_TARGET_DATE',
10458: avalue => l_task_target_date);
10459:
10456: itemkey => x_itemkey,
10457: aname => 'TASK_TARGET_DATE',
10458: avalue => l_task_target_date);
10459:
10460: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10461: itemkey => x_itemkey,
10462: aname => 'TASK_NAME',
10463: avalue => l_task_name);
10464:
10461: itemkey => x_itemkey,
10462: aname => 'TASK_NAME',
10463: avalue => l_task_name);
10464:
10465: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10466: itemkey => x_itemkey,
10467: aname => 'TASK_COMPLETED_SUBJECT',
10468: avalue => l_task_completed_subject);
10469:
10466: itemkey => x_itemkey,
10467: aname => 'TASK_COMPLETED_SUBJECT',
10468: avalue => l_task_completed_subject);
10469:
10470: wf_engine.SetItemAttrText (itemtype => x_itemtype,
10471: itemkey => x_itemkey,
10472: aname => 'AUCTION_ID',
10473: avalue => p_auction_header_id);
10474:
10472: aname => 'AUCTION_ID',
10473: avalue => p_auction_header_id);
10474:
10475: -- Bug 4295915: Set the workflow owner
10476: wf_engine.SetItemOwner(itemtype => x_itemtype,
10477: itemkey => x_itemkey,
10478: owner => fnd_global.user_name);
10479:
10480: l_progress := '100';
10478: owner => fnd_global.user_name);
10479:
10480: l_progress := '100';
10481:
10482: wf_engine.StartProcess(itemtype => x_itemtype,
10483: itemkey => x_itemkey );
10484:
10485:
10486: l_progress := 'END';
10764:
10765: l_response_type_name := PON_AUCTION_PKG.getMessage( msg => 'PON_AUCTS_BID',
10766: msg_suffix => '_'||l_msg_suffix);
10767:
10768: wf_engine.CreateProcess(itemtype => l_itemtype,
10769: itemkey => l_itemkey,
10770: process => 'RESPONSE_PUBLISH');
10771: l_progress := '060';
10772:
10780: END IF;
10781:
10782: IF (l_preview_date is not null) THEN
10783: l_progress := '070';
10784: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
10785: itemkey => l_itemkey,
10786: aname => 'PREVIEW_DATE',
10787: avalue => l_preview_date);
10788:
10785: itemkey => l_itemkey,
10786: aname => 'PREVIEW_DATE',
10787: avalue => l_preview_date);
10788:
10789: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10790: itemkey => l_itemkey,
10791: aname => 'TP_TIME_ZONE1',
10792: avalue => l_timezone_disp);
10793:
10790: itemkey => l_itemkey,
10791: aname => 'TP_TIME_ZONE1',
10792: avalue => l_timezone_disp);
10793:
10794: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10795: itemkey => l_itemkey,
10796: aname => 'PREVIEW_DATE_NOTSPECIFIED',
10797: avalue => null);
10798: ELSE
10796: aname => 'PREVIEW_DATE_NOTSPECIFIED',
10797: avalue => null);
10798: ELSE
10799: l_progress := '080';
10800: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
10801: itemkey => l_itemkey,
10802: aname => 'PREVIEW_DATE',
10803: avalue => null);
10804:
10801: itemkey => l_itemkey,
10802: aname => 'PREVIEW_DATE',
10803: avalue => null);
10804:
10805: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10806: itemkey => l_itemkey,
10807: aname => 'TP_TIME_ZONE1',
10808: avalue => null);
10809:
10806: itemkey => l_itemkey,
10807: aname => 'TP_TIME_ZONE1',
10808: avalue => null);
10809:
10810: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10811: itemkey => l_itemkey,
10812: aname => 'PREVIEW_DATE_NOTSPECIFIED',
10813: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
10814: END IF;
10814: END IF;
10815:
10816: l_progress := '090';
10817:
10818: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
10819: itemkey => l_itemkey,
10820: aname => 'BID_ID',
10821: avalue => p_bid_number);
10822:
10819: itemkey => l_itemkey,
10820: aname => 'BID_ID',
10821: avalue => p_bid_number);
10822:
10823: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10824: itemkey => l_itemkey,
10825: aname => 'DOC_NUMBER',
10826: avalue => l_doc_number);
10827:
10824: itemkey => l_itemkey,
10825: aname => 'DOC_NUMBER',
10826: avalue => l_doc_number);
10827:
10828: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10829: itemkey => l_itemkey,
10830: aname => 'TP_TIME_ZONE',
10831: avalue => l_timezone_disp);
10832:
10829: itemkey => l_itemkey,
10830: aname => 'TP_TIME_ZONE',
10831: avalue => l_timezone_disp);
10832:
10833: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
10834: itemkey => l_itemkey,
10835: aname => 'AUCTION_START_DATE',
10836: avalue => l_auction_start_date);
10837:
10834: itemkey => l_itemkey,
10835: aname => 'AUCTION_START_DATE',
10836: avalue => l_auction_start_date);
10837:
10838: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
10839: itemkey => l_itemkey,
10840: aname => 'AUCTION_END_DATE',
10841: avalue => l_auction_end_date);
10842:
10839: itemkey => l_itemkey,
10840: aname => 'AUCTION_END_DATE',
10841: avalue => l_auction_end_date);
10842:
10843: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10844: itemkey => l_itemkey,
10845: aname => 'AUCTION_TITLE',
10846: avalue => l_auction_title);
10847:
10847:
10848: /* Set value for Role - PREPARER_TP_CONTACT_NAME,
10849: this will be set as performer i.e. Notification Recipient
10850: */
10851: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10852: itemkey => l_itemkey,
10853: aname => 'PREPARER_TP_CONTACT_NAME',
10854: avalue => l_auctioneer_user_name);
10855:
10859: -- Set the sender as the current logged in user
10860: -- This is so that if a surrogate bid is being created,
10861: -- then the sender is the buyer creating the surrogate bid
10862:
10863: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10864: itemkey => l_itemkey,
10865: aname => 'RECIPIENT_ROLE',
10866: avalue => fnd_global.user_name);
10867:
10865: aname => 'RECIPIENT_ROLE',
10866: avalue => fnd_global.user_name);
10867:
10868:
10869: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10870: itemkey => l_itemkey,
10871: aname => 'PREPARER_TP_NAME',
10872: avalue => l_preparer_tp_name);
10873:
10870: itemkey => l_itemkey,
10871: aname => 'PREPARER_TP_NAME',
10872: avalue => l_preparer_tp_name);
10873:
10874: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
10875: itemkey => l_itemkey,
10876: aname => 'BID_PUBLISH_DATE',
10877: avalue => l_bid_publish_date);
10878:
10875: itemkey => l_itemkey,
10876: aname => 'BID_PUBLISH_DATE',
10877: avalue => l_bid_publish_date);
10878:
10879: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10880: itemkey => l_itemkey,
10881: aname => 'BIDDER_TP_NAME',
10882: avalue => l_bidder_tp_name);
10883:
10880: itemkey => l_itemkey,
10881: aname => 'BIDDER_TP_NAME',
10882: avalue => l_bidder_tp_name);
10883:
10884: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10885: itemkey => l_itemkey,
10886: aname => 'SUPPLIER_SITE_NAME',
10887: avalue => l_supplier_site_name);
10888:
10885: itemkey => l_itemkey,
10886: aname => 'SUPPLIER_SITE_NAME',
10887: avalue => l_supplier_site_name);
10888:
10889: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10890: itemkey => l_itemkey,
10891: aname => 'RESP_PUBLISH_SUBJECT',
10892: avalue => l_resp_publish_sub);
10893:
10890: itemkey => l_itemkey,
10891: aname => 'RESP_PUBLISH_SUBJECT',
10892: avalue => l_resp_publish_sub);
10893:
10894: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10895: itemkey => l_itemkey,
10896: aname => 'RESPONSE_TYPE',
10897: avalue => l_response_type_name);
10898:
10895: itemkey => l_itemkey,
10896: aname => 'RESPONSE_TYPE',
10897: avalue => l_response_type_name);
10898:
10899: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10900: itemkey => l_itemkey,
10901: aname => 'RESPONSE_URL',
10902: avalue => l_response_url);
10903:
10900: itemkey => l_itemkey,
10901: aname => 'RESPONSE_URL',
10902: avalue => l_response_url);
10903:
10904: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10905: itemkey => l_itemkey,
10906: aname => 'AUCTION_ID',
10907: avalue => l_auction_header_id);
10908:
10906: aname => 'AUCTION_ID',
10907: avalue => l_auction_header_id);
10908:
10909: -- Bug 4295915: Set the workflow owner
10910: wf_engine.SetItemOwner(itemtype => l_itemtype,
10911: itemkey => l_itemkey,
10912: owner => fnd_global.user_name);
10913:
10914: l_progress := '100';
10912: owner => fnd_global.user_name);
10913:
10914: l_progress := '100';
10915:
10916: wf_engine.StartProcess(itemtype => l_itemtype,
10917: itemkey => l_itemkey );
10918:
10919:
10920: l_progress := 'END';
11604: --
11605: -- Get the auction_header_id depending on the different itemtype possible
11606: --
11607: IF (itemtype = 'PONAPPRV' OR itemtype = 'PONAWAPR') THEN
11608: l_negotiation_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
11609: itemkey => itemkey,
11610: aname => 'AUCTION_HEADER_ID');
11611: ELSE
11612: l_negotiation_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
11608: l_negotiation_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
11609: itemkey => itemkey,
11610: aname => 'AUCTION_HEADER_ID');
11611: ELSE
11612: l_negotiation_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
11613: itemkey => itemkey,
11614: aname => 'AUCTION_ID');
11615: END IF;
11616:
11617: --
11618: -- Get the Function Attribute for this call. It will pass the
11619: -- WF_MESSAGE_NAME attribute associated with a notification
11620: --
11621: l_wf_message_name := Wf_Engine.GetActivityAttrText( itemtype,
11622: itemkey,
11623: actid,
11624: 'PON_WF_MESSAGE_NAME');
11625:
11643: -- can change the message name as the workflow progresses
11644: --
11645: IF (l_wf_message_name= 'CLOSECHANGED') THEN
11646: BEGIN
11647: l_change_type := wf_engine.GetItemAttrNumber (itemtype => itemtype,
11648: itemkey => itemkey,
11649: aname => 'CHANGE_TYPE');
11650: EXCEPTION
11651: WHEN OTHERS THEN
11686: --
11687:
11688: IF (l_wf_message_name = 'DISCUSSIONMESSAGE') THEN
11689:
11690: l_tp_type := wf_engine.GetItemAttrText (itemtype => itemtype,
11691: itemkey => itemkey,
11692: aname => 'TRADING_PARTNER_TYPE');
11693:
11694: IF (l_tp_type = 'BUYER') THEN
11966:
11967: END IF;
11968:
11969:
11970: wf_engine.CreateProcess(itemtype => l_itemtype,
11971: itemkey => l_itemkey,
11972: process => 'DISC_MESSAGE_SENT');
11973:
11974: l_progress := '070';
11999: p_itemkey =>l_itemkey,
12000: p_auction_end_date => l_auction_end_date,
12001: p_timezone_disp => l_timezone_disp);
12002:
12003: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12004: itemkey => l_itemkey,
12005: aname => 'DOC_NUMBER',
12006: avalue => p_doc_number);
12007:
12004: itemkey => l_itemkey,
12005: aname => 'DOC_NUMBER',
12006: avalue => p_doc_number);
12007:
12008: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12009: itemkey => l_itemkey,
12010: aname => 'STAGGERED_CLOSE_NOTE',
12011: avalue => l_staggered_close_note);
12012:
12009: itemkey => l_itemkey,
12010: aname => 'STAGGERED_CLOSE_NOTE',
12011: avalue => l_staggered_close_note);
12012:
12013: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12014: itemkey => l_itemkey,
12015: aname => 'AUCTION_TITLE',
12016: avalue => p_auction_title);
12017:
12014: itemkey => l_itemkey,
12015: aname => 'AUCTION_TITLE',
12016: avalue => p_auction_title);
12017:
12018: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12019: itemkey => l_itemkey,
12020: aname => 'MSG_RECIPIENT_NAME',
12021: avalue => l_recipient_name);
12022:
12019: itemkey => l_itemkey,
12020: aname => 'MSG_RECIPIENT_NAME',
12021: avalue => l_recipient_name);
12022:
12023: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12024: itemkey => l_itemkey,
12025: aname => 'MSG_SENDER_NAME',
12026: avalue => l_sender_name);
12027:
12024: itemkey => l_itemkey,
12025: aname => 'MSG_SENDER_NAME',
12026: avalue => l_sender_name);
12027:
12028: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12029: itemkey => l_itemkey,
12030: aname => 'VIEW_MESSAGE_URL',
12031: avalue => l_page_url);
12032:
12029: itemkey => l_itemkey,
12030: aname => 'VIEW_MESSAGE_URL',
12031: avalue => l_page_url);
12032:
12033: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12034: itemkey => l_itemkey,
12035: aname => 'MESSAGE_TYPE',
12036: avalue => p_message_type);
12037:
12034: itemkey => l_itemkey,
12035: aname => 'MESSAGE_TYPE',
12036: avalue => p_message_type);
12037:
12038: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12039: itemkey => l_itemkey,
12040: aname => 'MSG_SENDER_COMP_NAME',
12041: avalue => p_fromCompanyName);
12042:
12039: itemkey => l_itemkey,
12040: aname => 'MSG_SENDER_COMP_NAME',
12041: avalue => p_fromCompanyName);
12042:
12043: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12044: itemkey => l_itemkey,
12045: aname => 'MESSAGE_SENT_SUBJECT',
12046: avalue => l_msg_sent_subject);
12047:
12044: itemkey => l_itemkey,
12045: aname => 'MESSAGE_SENT_SUBJECT',
12046: avalue => l_msg_sent_subject);
12047:
12048: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12049: itemkey => l_itemkey,
12050: aname => 'MESSAGE_POSTED_DATE',
12051: avalue => p_msg_sent_date);
12052:
12049: itemkey => l_itemkey,
12050: aname => 'MESSAGE_POSTED_DATE',
12051: avalue => p_msg_sent_date);
12052:
12053: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12054: itemkey => l_itemkey,
12055: aname => 'MESSAGE_SUBJECT',
12056: avalue => p_subject);
12057:
12054: itemkey => l_itemkey,
12055: aname => 'MESSAGE_SUBJECT',
12056: avalue => p_subject);
12057:
12058: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12059: itemkey => l_itemkey,
12060: aname => 'PREPARER_TP_CONTACT_NAME',
12061: avalue => l_sender_user);
12062:
12059: itemkey => l_itemkey,
12060: aname => 'PREPARER_TP_CONTACT_NAME',
12061: avalue => l_sender_user);
12062:
12063: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12064: itemkey => l_itemkey,
12065: aname => 'RECIPIENT_ROLE',
12066: avalue => l_user_name);
12067:
12064: itemkey => l_itemkey,
12065: aname => 'RECIPIENT_ROLE',
12066: avalue => l_user_name);
12067:
12068: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12069: itemkey => l_itemkey,
12070: aname => 'TRADING_PARTNER_TYPE',
12071: avalue => p_notif_performer);
12072:
12069: itemkey => l_itemkey,
12070: aname => 'TRADING_PARTNER_TYPE',
12071: avalue => p_notif_performer);
12072:
12073: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12074: itemkey => l_itemkey,
12075: aname => 'AUCTION_ID',
12076: avalue => p_auction_header_id);
12077:
12074: itemkey => l_itemkey,
12075: aname => 'AUCTION_ID',
12076: avalue => p_auction_header_id);
12077:
12078: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
12079: itemkey => l_itemkey,
12080: aname => 'MESSAGE_ENTRY_ID',
12081: avalue => p_entryid);
12082:
12079: itemkey => l_itemkey,
12080: aname => 'MESSAGE_ENTRY_ID',
12081: avalue => p_entryid);
12082:
12083: wf_engine.SetItemAttrNumber (itemtype => l_itemtype,
12084: itemkey => l_itemkey,
12085: aname => 'DISCUSSION_ID',
12086: avalue => p_discussion_id);
12087:
12084: itemkey => l_itemkey,
12085: aname => 'DISCUSSION_ID',
12086: avalue => p_discussion_id);
12087:
12088: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12089: itemkey => l_itemkey,
12090: aname => 'ORIGIN_USER_NAME',
12091: avalue => fnd_global.user_name);
12092:
12090: aname => 'ORIGIN_USER_NAME',
12091: avalue => fnd_global.user_name);
12092:
12093: -- Bug 4295915: Set the workflow owner
12094: wf_engine.SetItemOwner(itemtype => l_itemtype,
12095: itemkey => l_itemkey,
12096: owner => fnd_global.user_name);
12097:
12098: BEGIN
12096: owner => fnd_global.user_name);
12097:
12098: BEGIN
12099:
12100: wf_engine.SetItemAttrText (itemtype => l_itemtype,
12101: itemkey => l_itemkey,
12102: aname => '#WFM_HTMLAGENT',
12103: avalue => l_wfm_htmlagent);
12104: EXCEPTION
12105: WHEN OTHERS THEN
12106: null;
12107: END;
12108:
12109: wf_engine.StartProcess(itemtype => l_itemtype,
12110: itemkey => l_itemkey );
12111:
12112: l_progress := '080';
12113:
12227: END IF;
12228:
12229: IF (p_publish_auction_now_flag = 'Y') THEN --if Immediately is selected
12230:
12231: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12232: itemkey => p_itemkey,
12233: aname => 'PREVIEW_DATE',
12234: avalue => null);
12235:
12232: itemkey => p_itemkey,
12233: aname => 'PREVIEW_DATE',
12234: avalue => null);
12235:
12236: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12237: itemkey => p_itemkey,
12238: aname => 'TP_TIME_ZONE1',
12239: avalue => null);
12240:
12237: itemkey => p_itemkey,
12238: aname => 'TP_TIME_ZONE1',
12239: avalue => null);
12240:
12241: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12242: itemkey => p_itemkey,
12243: aname => 'PREVIEW_DATE_NOTSPECIFIED',
12244: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));
12245:
12244: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));
12245:
12246: ELSIF (p_preview_date is NULL) THEN --if Not specified
12247:
12248: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12249: itemkey => p_itemkey,
12250: aname => 'PREVIEW_DATE',
12251: avalue => null);
12252:
12249: itemkey => p_itemkey,
12250: aname => 'PREVIEW_DATE',
12251: avalue => null);
12252:
12253: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12254: itemkey => p_itemkey,
12255: aname => 'TP_TIME_ZONE1',
12256: avalue => null);
12257:
12254: itemkey => p_itemkey,
12255: aname => 'TP_TIME_ZONE1',
12256: avalue => null);
12257:
12258: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12259: itemkey => p_itemkey,
12260: aname => 'PREVIEW_DATE_NOTSPECIFIED',
12261: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
12262:
12260: aname => 'PREVIEW_DATE_NOTSPECIFIED',
12261: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
12262:
12263: ELSE
12264: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12265: itemkey => p_itemkey,
12266: aname => 'PREVIEW_DATE',
12267: avalue => p_preview_date);
12268:
12265: itemkey => p_itemkey,
12266: aname => 'PREVIEW_DATE',
12267: avalue => p_preview_date);
12268:
12269: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12270: itemkey => p_itemkey,
12271: aname => 'TP_TIME_ZONE1',
12272: avalue => p_timezone_disp);
12273:
12270: itemkey => p_itemkey,
12271: aname => 'TP_TIME_ZONE1',
12272: avalue => p_timezone_disp);
12273:
12274: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12275: itemkey => p_itemkey,
12276: aname => 'PREVIEW_DATE_NOTSPECIFIED',
12277: avalue => null);
12278: END IF;
12312: END IF;
12313:
12314: IF (p_open_auction_now_flag = 'Y') THEN --if Immediately is selected
12315:
12316: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12317: itemkey => p_itemkey,
12318: aname => 'AUCTION_START_DATE',
12319: avalue => null);
12320:
12317: itemkey => p_itemkey,
12318: aname => 'AUCTION_START_DATE',
12319: avalue => null);
12320:
12321: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12322: itemkey => p_itemkey,
12323: aname => 'TP_TIME_ZONE',
12324: avalue => null);
12325:
12322: itemkey => p_itemkey,
12323: aname => 'TP_TIME_ZONE',
12324: avalue => null);
12325:
12326: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12327: itemkey => p_itemkey,
12328: aname => 'OPEN_DATE_NOT_SPECIFIED',
12329: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));
12330:
12328: aname => 'OPEN_DATE_NOT_SPECIFIED',
12329: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));
12330:
12331: ELSIF(p_auction_start_date is NULL) THEN --if not specified
12332: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12333: itemkey => p_itemkey,
12334: aname => 'AUCTION_START_DATE',
12335: avalue => null);
12336:
12333: itemkey => p_itemkey,
12334: aname => 'AUCTION_START_DATE',
12335: avalue => null);
12336:
12337: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12338: itemkey => p_itemkey,
12339: aname => 'TP_TIME_ZONE',
12340: avalue => null);
12341:
12338: itemkey => p_itemkey,
12339: aname => 'TP_TIME_ZONE',
12340: avalue => null);
12341:
12342: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12343: itemkey => p_itemkey,
12344: aname => 'OPEN_DATE_NOT_SPECIFIED',
12345: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
12346:
12344: aname => 'OPEN_DATE_NOT_SPECIFIED',
12345: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
12346:
12347: ELSE
12348: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12349: itemkey => p_itemkey,
12350: aname => 'AUCTION_START_DATE',
12351: avalue => p_auction_start_date);
12352:
12349: itemkey => p_itemkey,
12350: aname => 'AUCTION_START_DATE',
12351: avalue => p_auction_start_date);
12352:
12353: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12354: itemkey => p_itemkey,
12355: aname => 'TP_TIME_ZONE',
12356: avalue => p_timezone_disp);
12357:
12354: itemkey => p_itemkey,
12355: aname => 'TP_TIME_ZONE',
12356: avalue => p_timezone_disp);
12357:
12358: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12359: itemkey => p_itemkey,
12360: aname => 'OPEN_DATE_NOT_SPECIFIED',
12361: avalue => null);
12362:
12394: END IF;
12395:
12396:
12397: IF (p_auction_end_date is NULL) THEN --if not specified
12398: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12399: itemkey => p_itemkey,
12400: aname => 'AUCTION_END_DATE',
12401: avalue => null);
12402:
12399: itemkey => p_itemkey,
12400: aname => 'AUCTION_END_DATE',
12401: avalue => null);
12402:
12403: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12404: itemkey => p_itemkey,
12405: aname => 'TP_TIME_ZONE2',
12406: avalue => null);
12407:
12404: itemkey => p_itemkey,
12405: aname => 'TP_TIME_ZONE2',
12406: avalue => null);
12407:
12408: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12409: itemkey => p_itemkey,
12410: aname => 'CLOSE_DATE_NOT_SPECIFIED',
12411: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
12412:
12411: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
12412:
12413:
12414: ELSE
12415: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12416: itemkey => p_itemkey,
12417: aname => 'AUCTION_END_DATE',
12418: avalue => p_auction_end_date);
12419:
12416: itemkey => p_itemkey,
12417: aname => 'AUCTION_END_DATE',
12418: avalue => p_auction_end_date);
12419:
12420: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12421: itemkey => p_itemkey,
12422: aname => 'TP_TIME_ZONE2',
12423: avalue => p_timezone_disp);
12424:
12421: itemkey => p_itemkey,
12422: aname => 'TP_TIME_ZONE2',
12423: avalue => p_timezone_disp);
12424:
12425: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12426: itemkey => p_itemkey,
12427: aname => 'CLOSE_DATE_NOT_SPECIFIED',
12428: avalue => null);
12429:
13028: -- bidder name: this is the person who gets the notification
13029: l_bidder_name := bidder.trading_partner_contact_name;
13030:
13031: -- create workflow process
13032: wf_engine.CreateProcess(itemtype => x_item_type,
13033: itemkey => x_item_key,
13034: process => 'PON_TECH_SHORTLIST_NOTIFY');
13035:
13036: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13040: || x_item_key);
13041: END IF;
13042:
13043: -- bidder trading party contact name
13044: wf_engine.SetItemAttrText( itemtype => x_item_type,
13045: itemkey => x_item_key,
13046: aname => 'BIDDER_TP_CONTACT_NAME',
13047: avalue => l_bidder_name);
13048:
13046: aname => 'BIDDER_TP_CONTACT_NAME',
13047: avalue => l_bidder_name);
13048:
13049: -- auctioneer trading party name
13050: wf_engine.SetItemAttrText( itemtype => x_item_type,
13051: itemkey => x_item_key,
13052: aname => 'PREPARER_TP_NAME',
13053: avalue => l_trading_partner_name);
13054:
13052: aname => 'PREPARER_TP_NAME',
13053: avalue => l_trading_partner_name);
13054:
13055: -- auction header id
13056: wf_engine.SetItemAttrText( itemtype => x_item_type,
13057: itemkey => x_item_key,
13058: aname => 'AUCTION_ID',
13059: avalue => p_auction_header_id);
13060:
13058: aname => 'AUCTION_ID',
13059: avalue => p_auction_header_id);
13060:
13061: -- bid id
13062: wf_engine.SetItemAttrText( itemtype => x_item_type,
13063: itemkey => x_item_key,
13064: aname => 'BID_ID',
13065: avalue => bidder.bid_number);
13066:
13064: aname => 'BID_ID',
13065: avalue => bidder.bid_number);
13066:
13067: -- auction title
13068: wf_engine.SetItemAttrText( itemtype => x_item_type,
13069: itemkey => x_item_key,
13070: aname => 'AUCTION_TITLE',
13071: avalue => l_auction_title);
13072:
13070: aname => 'AUCTION_TITLE',
13071: avalue => l_auction_title);
13072:
13073: -- bid technically shortlisted flag
13074: wf_engine.SetItemAttrText( itemtype => x_item_type,
13075: itemkey => x_item_key,
13076: aname => 'BID_TECH_SHORTLISTED',
13077: avalue => bidder.shortlist_flag);
13078:
13076: aname => 'BID_TECH_SHORTLISTED',
13077: avalue => bidder.shortlist_flag);
13078:
13079: -- document number (display value)
13080: wf_engine.SetItemAttrText( itemtype => x_item_type,
13081: itemkey => x_item_key,
13082: aname => 'DOC_NUMBER',
13083: avalue => l_document_number);
13084:
13082: aname => 'DOC_NUMBER',
13083: avalue => l_document_number);
13084:
13085: -- meaning of Technical
13086: wf_engine.SetItemAttrText( itemtype => x_item_type,
13087: itemkey => x_item_key,
13088: aname => 'TECHNICAL',
13089: avalue => get_technical_meaning);
13090:
13088: aname => 'TECHNICAL',
13089: avalue => get_technical_meaning);
13090:
13091: -- meaning of Commercial
13092: wf_engine.SetItemAttrText( itemtype => x_item_type,
13093: itemkey => x_item_key,
13094: aname => 'COMMERCIAL',
13095: avalue => get_commercial_meaning);
13096:
13094: aname => 'COMMERCIAL',
13095: avalue => get_commercial_meaning);
13096:
13097: -- origin user name
13098: wf_engine.SetItemAttrText( itemtype => x_item_type,
13099: itemkey => x_item_key,
13100: aname => 'ORIGIN_USER_NAME',
13101: avalue => fnd_global.user_name);
13102:
13110: ' TECHNICAL :' || get_technical_meaning || ' COMMERCIAL :' || get_commercial_meaning);
13111: END IF;
13112:
13113: -- start the workflow
13114: wf_engine.StartProcess( itemtype => x_item_type,
13115: itemkey => x_item_key);
13116:
13117: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13118: FND_LOG.string (log_level => FND_LOG.level_statement,