DBA Data[Home] [Help]

APPS.PON_AWARD_APPROVAL_PKG dependencies on WF_ENGINE

Line 22: | Added call to wf_engine.SetItemOwner

18: | -------------------------------------------------------------------------------------------
19: | ? ? Created
20: |
21: | 25-Aug-05 sparames Bug 4295915: Missing owner in Sourcing notifications
22: | Added call to wf_engine.SetItemOwner
23: |
24: =========================================================================+*/
25:
26:

Line 380: wf_engine.SetItemAttrNumber(itemtype => p_item_type,

376:
377: l_msg_suffix := PON_AUCTION_PKG.get_message_suffix(l_doctype_group_name);
378:
379: --bug 9555176
380: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
381: itemkey => p_item_key,
382: aname => 'PREPARER_RESP_ID',
383: avalue => fnd_global.RESP_ID);
384:

Line 385: wf_engine.SetItemAttrNumber(itemtype => p_item_type,

381: itemkey => p_item_key,
382: aname => 'PREPARER_RESP_ID',
383: avalue => fnd_global.RESP_ID);
384:
385: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
386: itemkey => p_item_key,
387: aname => 'PREPARER_APPL_ID',
388: avalue => fnd_global.RESP_APPL_ID);
389:

Line 402: wf_engine.SetItemAttrNumber(itemtype => p_item_type,

398: l_document_number,
399: l_trading_partner_contact_name);
400:
401: -- set other core attributes
402: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
403: itemkey => p_item_key,
404: aname => 'AUCTION_HEADER_ID',
405: avalue => p_auction_header_id);
406:

Line 407: wf_engine.SetItemAttrNumber(itemtype => p_item_type,

403: itemkey => p_item_key,
404: aname => 'AUCTION_HEADER_ID',
405: avalue => p_auction_header_id);
406:
407: wf_engine.SetItemAttrNumber(itemtype => p_item_type,
408: itemkey => p_item_key,
409: aname => 'FIRST_AUTHORITY_APPROVER_ID',
410: avalue => p_first_authority_approver_id);
411:

Line 412: wf_engine.SetItemAttrText(itemtype => p_item_type,

408: itemkey => p_item_key,
409: aname => 'FIRST_AUTHORITY_APPROVER_ID',
410: avalue => p_first_authority_approver_id);
411:
412: wf_engine.SetItemAttrText(itemtype => p_item_type,
413: itemkey => p_item_key,
414: aname => 'AME_TRANSACTION_ID',
415: avalue => l_transaction_id);
416:

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

413: itemkey => p_item_key,
414: aname => 'AME_TRANSACTION_ID',
415: avalue => l_transaction_id);
416:
417: wf_engine.SetItemAttrText(itemtype => p_item_type,
418: itemkey => p_item_key,
419: aname => 'NOTE_TO_APPROVERS',
420: avalue => PON_AUCTION_PKG.replaceHtmlChars(p_note_to_approvers));
421:

Line 422: wf_engine.SetItemAttrText(itemtype => p_item_type,

418: itemkey => p_item_key,
419: aname => 'NOTE_TO_APPROVERS',
420: avalue => PON_AUCTION_PKG.replaceHtmlChars(p_note_to_approvers));
421:
422: wf_engine.SetItemAttrText(itemtype => p_item_type,
423: itemkey => p_item_key,
424: aname => 'AWARD_SUMMARY_URL',
425: avalue => PON_WF_UTL_PKG.get_dest_page_url('PON_AWARD_SUMM', 'BUYER'));
426:

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

423: itemkey => p_item_key,
424: aname => 'AWARD_SUMMARY_URL',
425: avalue => PON_WF_UTL_PKG.get_dest_page_url('PON_AWARD_SUMM', 'BUYER'));
426:
427: wf_engine.SetItemAttrText(itemtype => p_item_type,
428: itemkey => p_item_key,
429: aname => 'MESSAGE_SUFFIX',
430: avalue => l_msg_suffix);
431:

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

428: itemkey => p_item_key,
429: aname => 'MESSAGE_SUFFIX',
430: avalue => l_msg_suffix);
431:
432: wf_engine.SetItemAttrDate(itemtype => p_item_type,
433: itemkey => p_item_key,
434: aname => 'OPEN_BIDDING_DATE',
435: avalue => l_open_bidding_date);
436:

Line 437: wf_engine.SetItemAttrDate(itemtype => p_item_type,

433: itemkey => p_item_key,
434: aname => 'OPEN_BIDDING_DATE',
435: avalue => l_open_bidding_date);
436:
437: wf_engine.SetItemAttrDate(itemtype => p_item_type,
438: itemkey => p_item_key,
439: aname => 'CLOSE_BIDDING_DATE',
440: avalue => l_close_bidding_date);
441:

Line 442: wf_engine.SetItemAttrDate(itemtype => p_item_type,

438: itemkey => p_item_key,
439: aname => 'CLOSE_BIDDING_DATE',
440: avalue => l_close_bidding_date);
441:
442: wf_engine.SetItemAttrDate(itemtype => p_item_type,
443: itemkey => p_item_key,
444: aname => 'AWARD_BY_DATE',
445: avalue => l_award_by_date);
446:

Line 447: wf_engine.SetItemAttrDate (itemtype => p_item_type,

443: itemkey => p_item_key,
444: aname => 'AWARD_BY_DATE',
445: avalue => l_award_by_date);
446:
447: wf_engine.SetItemAttrDate (itemtype => p_item_type,
448: itemkey => p_item_key,
449: aname => 'PREVIEW_DATE',
450: avalue => l_preview_date);
451:

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

448: itemkey => p_item_key,
449: aname => 'PREVIEW_DATE',
450: avalue => l_preview_date);
451:
452: wf_engine.SetItemAttrText(itemtype => p_item_type,
453: itemkey => p_item_key,
454: aname => 'ORIGIN_USER_NAME',
455: avalue => fnd_global.user_name);
456:

Line 499: l_msg_suffix := wf_engine.getItemAttrText(itemtype => p_item_type,

495: -- set the db session language
496: PON_PROFILE_UTIL_PKG.get_wf_language(p_user_name, l_language_code);
497: PON_AUCTION_PKG.set_session_language(null, l_language_code);
498:
499: l_msg_suffix := wf_engine.getItemAttrText(itemtype => p_item_type,
500: itemkey => p_item_key,
501: aname => 'MESSAGE_SUFFIX');
502:
503: l_auction_title := wf_engine.getItemAttrText(itemtype => p_item_type,

Line 503: l_auction_title := wf_engine.getItemAttrText(itemtype => p_item_type,

499: l_msg_suffix := wf_engine.getItemAttrText(itemtype => p_item_type,
500: itemkey => p_item_key,
501: aname => 'MESSAGE_SUFFIX');
502:
503: l_auction_title := wf_engine.getItemAttrText(itemtype => p_item_type,
504: itemkey => p_item_key,
505: aname => 'AUCTION_TITLE');
506:
507: l_document_number := wf_engine.getItemAttrText(itemtype => p_item_type,

Line 507: l_document_number := wf_engine.getItemAttrText(itemtype => p_item_type,

503: l_auction_title := wf_engine.getItemAttrText(itemtype => p_item_type,
504: itemkey => p_item_key,
505: aname => 'AUCTION_TITLE');
506:
507: l_document_number := wf_engine.getItemAttrText(itemtype => p_item_type,
508: itemkey => p_item_key,
509: aname => 'DOC_NUMBER');
510:
511: -- set the notification subject

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

512: IF p_notification_type = APPROVAL_REQUEST THEN
513: -- if the notification type is APPROVAL_REQUEST
514: -- set the notification subject for the initial approval request notification
515: -- as well as the subject for the reminder notification
516: wf_engine.SetItemAttrText(itemtype => p_item_type,
517: itemkey => p_item_key,
518: aname => 'APPROVAL_REQUEST_SUBJECT',
519: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_APPROVAL_1',
520: l_msg_suffix,

Line 525: wf_engine.SetItemAttrText(itemtype => p_item_type,

521: 'DOC_NUMBER',
522: l_document_number,
523: 'DOC_TITLE',
524: l_auction_title));
525: wf_engine.SetItemAttrText(itemtype => p_item_type,
526: itemkey => p_item_key,
527: aname => 'REQUEST_REMINDER_SUBJECT',
528: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_APPROVAL_2',
529: l_msg_suffix,

Line 535: wf_engine.SetItemAttrText(itemtype => p_item_type,

531: l_document_number,
532: 'DOC_TITLE',
533: l_auction_title));
534: ELSIF p_notification_type = AWARD_APPROVED THEN
535: wf_engine.SetItemAttrText(itemtype => p_item_type,
536: itemkey => p_item_key,
537: aname => 'APPROVAL_SUBJECT',
538: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_APPROVED_1',
539: l_msg_suffix,

Line 545: wf_engine.SetItemAttrText(itemtype => p_item_type,

541: l_document_number,
542: 'DOC_TITLE',
543: l_auction_title));
544: ELSIF p_notification_type = AWARD_REJECTED THEN
545: wf_engine.SetItemAttrText(itemtype => p_item_type,
546: itemkey => p_item_key,
547: aname => 'REJECTION_SUBJECT',
548: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_AWARD_REJECTED_1',
549: l_msg_suffix,

Line 555: wf_engine.SetItemAttrText(itemtype => p_item_type,

551: l_document_number,
552: 'DOC_TITLE',
553: l_auction_title));
554: ELSIF p_notification_type = ERROR THEN
555: wf_engine.SetItemAttrText(itemtype => p_item_type,
556: itemkey => p_item_key,
557: aname => 'ERROR_SUBJECT',
558: avalue => PON_AUCTION_PKG.getMessage('PON_AWARD_REJECTED_ERROR_1',
559: l_msg_suffix,

Line 565: wf_engine.SetItemAttrText(itemtype => p_item_type,

561: l_document_number,
562: 'DOC_TITLE',
563: l_auction_title));
564: ELSIF p_notification_type = ERROR_FOR_ADMIN THEN
565: wf_engine.SetItemAttrText(itemtype => p_item_type,
566: itemkey => p_item_key,
567: aname => 'ERROR_SUBJECT_FOR_ADMIN',
568: avalue => PON_AUCTION_PKG.getMessage('PON_AWARD_REJECTED_ERROR_2',
569: l_msg_suffix,

Line 581: l_open_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

577: -- to dates in the user's timezone
578: l_user_timezone := PON_AUCTION_PKG.get_time_zone(p_user_name);
579: l_server_timezone := PON_AUCTION_PKG.get_oex_time_zone;
580:
581: l_open_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
582: itemkey => p_item_key,
583: aname => 'OPEN_BIDDING_DATE');
584:
585: l_close_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

Line 585: l_close_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

581: l_open_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
582: itemkey => p_item_key,
583: aname => 'OPEN_BIDDING_DATE');
584:
585: l_close_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
586: itemkey => p_item_key,
587: aname => 'CLOSE_BIDDING_DATE');
588:
589: l_award_by_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

Line 589: l_award_by_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

585: l_close_bidding_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
586: itemkey => p_item_key,
587: aname => 'CLOSE_BIDDING_DATE');
588:
589: l_award_by_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
590: itemkey => p_item_key,
591: aname => 'AWARD_BY_DATE');
592:
593: IF p_set_approval_date THEN

Line 594: l_approval_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

590: itemkey => p_item_key,
591: aname => 'AWARD_BY_DATE');
592:
593: IF p_set_approval_date THEN
594: l_approval_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
595: itemkey => p_item_key,
596: aname => 'APPROVAL_DATE');
597: END IF;
598:

Line 600: l_rejection_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

596: aname => 'APPROVAL_DATE');
597: END IF;
598:
599: IF p_set_rejection_date THEN
600: l_rejection_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
601: itemkey => p_item_key,
602: aname => 'REJECTION_DATE');
603: END IF;
604:

Line 605: l_preview_date := wf_engine.getItemAttrDate(itemtype => p_item_type,

601: itemkey => p_item_key,
602: aname => 'REJECTION_DATE');
603: END IF;
604:
605: l_preview_date := wf_engine.getItemAttrDate(itemtype => p_item_type,
606: itemkey => p_item_key,
607: aname => 'PREVIEW_DATE');
608:
609: IF PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1 THEN

Line 649: wf_engine.setItemAttrText(itemtype => p_item_type,

645: END IF;
646:
647: l_user_timezone_desc := PON_AUCTION_PKG.get_timezone_description(l_user_timezone, l_language_code);
648:
649: wf_engine.setItemAttrText(itemtype => p_item_type,
650: itemkey => p_item_key,
651: aname => 'USER_TIMEZONE',
652: avalue => l_user_timezone_desc);
653:

Line 654: wf_engine.setItemAttrDate(itemtype => p_item_type,

650: itemkey => p_item_key,
651: aname => 'USER_TIMEZONE',
652: avalue => l_user_timezone_desc);
653:
654: wf_engine.setItemAttrDate(itemtype => p_item_type,
655: itemkey => p_item_key,
656: aname => 'OPEN_BIDDING_DATE_TZ',
657: avalue => l_open_bidding_date_tz);
658:

Line 659: wf_engine.setItemAttrDate(itemtype => p_item_type,

655: itemkey => p_item_key,
656: aname => 'OPEN_BIDDING_DATE_TZ',
657: avalue => l_open_bidding_date_tz);
658:
659: wf_engine.setItemAttrDate(itemtype => p_item_type,
660: itemkey => p_item_key,
661: aname => 'CLOSE_BIDDING_DATE_TZ',
662: avalue => l_close_bidding_date_tz);
663:

Line 664: wf_engine.setItemAttrDate(itemtype => p_item_type,

660: itemkey => p_item_key,
661: aname => 'CLOSE_BIDDING_DATE_TZ',
662: avalue => l_close_bidding_date_tz);
663:
664: wf_engine.setItemAttrDate(itemtype => p_item_type,
665: itemkey => p_item_key,
666: aname => 'AWARD_BY_DATE_TZ',
667: avalue => l_award_by_date_tz);
668:

Line 673: wf_engine.setItemAttrText(itemtype => p_item_type,

669: -- if the award by date is not null, the timezone attribute associated with the date
670: -- must have the same value as the user's timezone attribute
671: -- otherwise, then the timezone attribute associated with the date must be null
672: IF l_award_by_date_tz IS NOT NULL THEN
673: wf_engine.setItemAttrText(itemtype => p_item_type,
674: itemkey => p_item_key,
675: aname => 'USER_TIMEZONE_AWARD_BY_DATE',
676: avalue => l_user_timezone_desc);
677: ELSE

Line 678: wf_engine.setItemAttrText(itemtype => p_item_type,

674: itemkey => p_item_key,
675: aname => 'USER_TIMEZONE_AWARD_BY_DATE',
676: avalue => l_user_timezone_desc);
677: ELSE
678: wf_engine.setItemAttrText(itemtype => p_item_type,
679: itemkey => p_item_key,
680: aname => 'USER_TIMEZONE_AWARD_BY_DATE',
681: avalue => NULL);
682: END IF;

Line 685: wf_engine.setItemAttrDate(itemtype => p_item_type,

681: avalue => NULL);
682: END IF;
683:
684: IF p_set_approval_date THEN
685: wf_engine.setItemAttrDate(itemtype => p_item_type,
686: itemkey => p_item_key,
687: aname => 'APPROVAL_DATE_TZ',
688: avalue => l_approval_date_tz);
689: END IF;

Line 692: wf_engine.setItemAttrDate(itemtype => p_item_type,

688: avalue => l_approval_date_tz);
689: END IF;
690:
691: IF p_set_rejection_date THEN
692: wf_engine.setItemAttrDate(itemtype => p_item_type,
693: itemkey => p_item_key,
694: aname => 'REJECTION_DATE_TZ',
695: avalue => l_rejection_date_tz);
696: END IF;

Line 699: wf_engine.SetItemAttrText (itemtype => p_item_type,

695: avalue => l_rejection_date_tz);
696: END IF;
697:
698: IF l_preview_date_tz IS NOT NULL THEN
699: wf_engine.SetItemAttrText (itemtype => p_item_type,
700: itemkey => p_item_key,
701: aname => 'TP_TIME_ZONE1',
702: avalue => l_user_timezone_desc);
703:

Line 704: wf_engine.SetItemAttrText (itemtype => p_item_type,

700: itemkey => p_item_key,
701: aname => 'TP_TIME_ZONE1',
702: avalue => l_user_timezone_desc);
703:
704: wf_engine.SetItemAttrText (itemtype => p_item_type,
705: itemkey => p_item_key,
706: aname => 'PREVIEW_DATE_NOTSPECIFIED',
707: avalue => null);
708: ELSE

Line 709: wf_engine.SetItemAttrText (itemtype => p_item_type,

705: itemkey => p_item_key,
706: aname => 'PREVIEW_DATE_NOTSPECIFIED',
707: avalue => null);
708: ELSE
709: wf_engine.SetItemAttrText (itemtype => p_item_type,
710: itemkey => p_item_key,
711: aname => 'TP_TIME_ZONE1',
712: avalue => null);
713:

Line 714: wf_engine.SetItemAttrText (itemtype => p_item_type,

710: itemkey => p_item_key,
711: aname => 'TP_TIME_ZONE1',
712: avalue => null);
713:
714: wf_engine.SetItemAttrText (itemtype => p_item_type,
715: itemkey => p_item_key,
716: aname => 'PREVIEW_DATE_NOTSPECIFIED',
717: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
718: END IF;

Line 747: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,

743: p_item_key IN VARCHAR2) IS
744: l_tp_contact_user_name VARCHAR2(100);
745: BEGIN
746:
747: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,
748: itemkey => p_item_key,
749: aname => 'PREPARER_TP_CONTACT_NAME');
750:
751: set_common_user_attributes(p_item_type,

Line 768: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,

764: p_item_key IN VARCHAR2) IS
765: l_tp_contact_user_name VARCHAR2(100);
766: BEGIN
767:
768: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,
769: itemkey => p_item_key,
770: aname => 'PREPARER_TP_CONTACT_NAME');
771:
772: set_common_user_attributes(p_item_type,

Line 789: l_approver_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,

785: p_item_key IN VARCHAR2) IS
786: l_approver_user_name VARCHAR2(100);
787: BEGIN
788:
789: l_approver_user_name := wf_engine.getItemAttrText(itemtype => p_item_type,
790: itemkey => p_item_key,
791: aname => 'APPROVER_USER');
792:
793: -- reset notification's Respond attributes

Line 794: wf_engine.setItemAttrText(itemtype => p_item_type,

790: itemkey => p_item_key,
791: aname => 'APPROVER_USER');
792:
793: -- reset notification's Respond attributes
794: wf_engine.setItemAttrText(itemtype => p_item_type,
795: itemkey => p_item_key,
796: aname => 'APPROVER_FORWARDEE_USER',
797: avalue => NULL);
798:

Line 799: wf_engine.setItemAttrText(itemtype => p_item_type,

795: itemkey => p_item_key,
796: aname => 'APPROVER_FORWARDEE_USER',
797: avalue => NULL);
798:
799: wf_engine.setItemAttrText(itemtype => p_item_type,
800: itemkey => p_item_key,
801: aname => 'NOTE_TO_BUYER',
802: avalue => NULL);
803:

Line 805: wf_engine.SetItemAttrDate(itemtype => p_item_type,

801: aname => 'NOTE_TO_BUYER',
802: avalue => NULL);
803:
804: -- reset approval-related attributes
805: wf_engine.SetItemAttrDate(itemtype => p_item_type,
806: itemkey => p_item_key,
807: aname => 'APPROVAL_DATE',
808: avalue => NULL);
809:

Line 810: wf_engine.SetItemAttrDate(itemtype => p_item_type,

806: itemkey => p_item_key,
807: aname => 'APPROVAL_DATE',
808: avalue => NULL);
809:
810: wf_engine.SetItemAttrDate(itemtype => p_item_type,
811: itemkey => p_item_key,
812: aname => 'REJECTION_DATE',
813: avalue => NULL);
814:

Line 837: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

833: l_tp_contact_user_id NUMBER;
834: l_tp_contact_user_name VARCHAR2(100);
835: BEGIN
836:
837: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
838: itemkey => itemkey,
839: aname => 'AUCTION_HEADER_ID');
840:
841: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 841: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

837: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
838: itemkey => itemkey,
839: aname => 'AUCTION_HEADER_ID');
840:
841: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
842: itemkey => itemkey,
843: aname => 'AME_TRANSACTION_ID');
844:
845: l_tp_contact_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 845: l_tp_contact_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

841: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
842: itemkey => itemkey,
843: aname => 'AME_TRANSACTION_ID');
844:
845: l_tp_contact_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,
846: itemkey => itemkey,
847: aname => 'PREPARER_TP_CONTACT_NAME');
848:
849: SELECT user_id

Line 908: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

904: l_statement_log_level NUMBER := FND_LOG.LEVEL_STATEMENT;
905: l_module_name VARCHAR2(80) := 'pon.plsql.PON_AWARD_APPROVAL_PKG.GET_NEXT_APPROVER';
906: BEGIN
907:
908: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
909: itemkey => itemkey,
910: aname => 'AME_TRANSACTION_ID');
911: l_success_flag := TRUE;
912:

Line 933: wf_engine.SetItemAttrText(itemtype => itemtype,

929:
930: -- if the OAM API call raises an exception,
931: -- set the Application Error and OAM Error workflow attributes
932: -- this message is internal and can be seen only by the OAM administrator
933: wf_engine.SetItemAttrText(itemtype => itemtype,
934: itemkey => itemkey,
935: aname => 'OAM_ERROR',
936: avalue => SQLERRM);
937:

Line 939: wf_engine.SetItemAttrText(itemtype => itemtype,

935: aname => 'OAM_ERROR',
936: avalue => SQLERRM);
937:
938: -- this message can be seen by any buyer
939: wf_engine.SetItemAttrText(itemtype => itemtype,
940: itemkey => itemkey,
941: aname => 'APPLICATION_ERROR',
942: avalue => PON_AUCTION_PKG.getMessage('PON_OAM_ERROR_OCCURRED'));
943:

Line 953: wf_engine.SetItemAttrText(itemtype => itemtype,

949: resultout := 'OAM_API_ERROR';
950: l_success_flag := FALSE;
951:
952: -- this message can be seen only by admin.
953: wf_engine.SetItemAttrText(itemtype => itemtype,
954: itemkey => itemkey,
955: aname => 'OAM_ERROR',
956: avalue => PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
957:

Line 959: wf_engine.SetItemAttrText(itemtype => itemtype,

955: aname => 'OAM_ERROR',
956: avalue => PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
957:
958: -- this message can be seen by any buyer.
959: wf_engine.SetItemAttrText(itemtype => itemtype,
960: itemkey => itemkey,
961: aname => 'APPLICATION_ERROR',
962: avalue => PON_AUCTION_PKG.getMessage('PON_AME_PARALLEL_NOT_SUPPORTED'));
963:

Line 988: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

984: ruleIdListOut => l_idList);
985:
986: IF( l_next_approver.api_insertion = ame_util.apiAuthorityInsertion AND
987: l_source_type_out <> ame_util.forwardeeSource ) THEN
988: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
989: itemkey => itemkey,
990: aname => 'FIRST_AUTHORITY_APPROVER_ID');
991: END IF;
992: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN

Line 1016: wf_engine.SetItemAttrText(itemtype => itemtype,

1012: resultout := 'OAM_API_ERROR';
1013: l_success_flag := FALSE;
1014:
1015: -- this message can be seen only by admin.
1016: wf_engine.SetItemAttrText(itemtype => itemtype,
1017: itemkey => itemkey,
1018: aname => 'OAM_ERROR',
1019: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1020:

Line 1022: wf_engine.SetItemAttrText(itemtype => itemtype,

1018: aname => 'OAM_ERROR',
1019: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1020:
1021: -- this message can be seen by any buyer.
1022: wf_engine.SetItemAttrText(itemtype => itemtype,
1023: itemkey => itemkey,
1024: aname => 'APPLICATION_ERROR',
1025: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_next_approver.display_name ));
1026:

Line 1047: wf_engine.SetItemAttrText(itemtype => itemtype,

1043: -- if next approver is valid
1044: IF l_next_approver_employee.user_id IS NOT NULL AND l_next_approver_employee.person_id IS NOT NULL THEN
1045:
1046: -- set the approver username attribute
1047: wf_engine.SetItemAttrText(itemtype => itemtype,
1048: itemkey => itemkey,
1049: aname => 'APPROVER_USER',
1050: avalue => l_next_approver_employee.user_name);
1051:

Line 1055: wf_engine.SetItemAttrText(itemtype => itemtype,

1051:
1052: l_next_approver_string := format_ame_approver(l_next_approver);
1053:
1054: -- set the approver record string atttribute
1055: wf_engine.SetItemAttrText(itemtype => itemtype,
1056: itemkey => itemkey,
1057: aname => 'APPROVER_STRING',
1058: avalue => l_next_approver_string);
1059:

Line 1064: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1060: -- set attributes specific to approval request notification
1061: set_notify_approver_attributes(itemtype, itemkey);
1062:
1063: -- get the auction header id workflow attribute
1064: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1065: itemkey => itemkey,
1066: aname => 'AUCTION_HEADER_ID');
1067:
1068: -- record that approval response is pending for this approver

Line 1090: wf_engine.SetItemAttrText(itemtype => itemtype,

1086: l_next_approver_name := get_display_name_for_person(l_next_approver.orig_system_id);
1087: ELSE
1088: l_next_approver_name := get_display_name_for_user(l_next_approver.orig_system_id);
1089: END IF;
1090: wf_engine.SetItemAttrText(itemtype => itemtype,
1091: itemkey => itemkey,
1092: aname => 'APPLICATION_ERROR',
1093: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_NEXT_APPROVER',
1094: NULL,

Line 1123: wf_engine.SetItemAttrDate(itemtype => itemtype,

1119:
1120: -- set rejection date attribute
1121: l_error_date := SYSDATE;
1122:
1123: wf_engine.SetItemAttrDate(itemtype => itemtype,
1124: itemkey => itemkey,
1125: aname => 'REJECTION_DATE',
1126: avalue => l_error_date);
1127:

Line 1129: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => itemtype,

1125: aname => 'REJECTION_DATE',
1126: avalue => l_error_date);
1127:
1128: -- set attributes specific to OAM error notification
1129: l_tp_contact_user_name := wf_engine.getItemAttrText(itemtype => itemtype,
1130: itemkey => itemkey,
1131: aname => 'PREPARER_TP_CONTACT_NAME');
1132:
1133: set_common_user_attributes(itemtype,

Line 1140: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1136: ERROR,
1137: FALSE,
1138: TRUE);
1139:
1140: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1141: itemkey => itemkey,
1142: aname => 'AUCTION_HEADER_ID');
1143:
1144: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1144: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1140: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1141: itemkey => itemkey,
1142: aname => 'AUCTION_HEADER_ID');
1143:
1144: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1145: itemkey => itemkey,
1146: aname => 'AME_TRANSACTION_ID');
1147:
1148: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1148: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,

1144: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1145: itemkey => itemkey,
1146: aname => 'AME_TRANSACTION_ID');
1147:
1148: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,
1149: itemkey => itemkey,
1150: aname => 'APPLICATION_ERROR');
1151:
1152: SELECT user_id

Line 1186: IF wf_engine.GetItemAttrText(itemtype => itemtype,

1182: funcmode IN VARCHAR2,
1183: resultout OUT NOCOPY VARCHAR2) IS
1184: BEGIN
1185:
1186: IF wf_engine.GetItemAttrText(itemtype => itemtype,
1187: itemkey => itemkey,
1188: aname => 'OAM_ERROR') <> 'NO' THEN
1189: resultout := 'Y';
1190: ELSE

Line 1246: wf_engine.setItemAttrText(itemtype => itemtype,

1242:
1243: -- if the OAM administrator could be determined
1244: IF l_oam_admin_user_name IS NOT NULL THEN
1245: -- set OAM Administrator attribute
1246: wf_engine.setItemAttrText(itemtype => itemtype,
1247: itemkey => itemkey,
1248: aname => 'OAM_ADMIN_USER',
1249: avalue => l_oam_admin_user_name);
1250:

Line 1280: IF wf_engine.GetItemAttrDate(itemtype => itemtype,

1276: l_transaction_id VARCHAR2(80);
1277: BEGIN
1278:
1279: -- if the rejection date is null, set it to the current date
1280: IF wf_engine.GetItemAttrDate(itemtype => itemtype,
1281: itemkey => itemkey,
1282: aname => 'REJECTION_DATE') IS NULL THEN
1283: wf_engine.SetItemAttrDate(itemtype => itemtype,
1284: itemkey => itemkey,

Line 1283: wf_engine.SetItemAttrDate(itemtype => itemtype,

1279: -- if the rejection date is null, set it to the current date
1280: IF wf_engine.GetItemAttrDate(itemtype => itemtype,
1281: itemkey => itemkey,
1282: aname => 'REJECTION_DATE') IS NULL THEN
1283: wf_engine.SetItemAttrDate(itemtype => itemtype,
1284: itemkey => itemkey,
1285: aname => 'REJECTION_DATE',
1286: avalue => SYSDATE);
1287: END IF;

Line 1292: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1288:
1289: -- set attributes specific to award rejected notification
1290: set_award_rejected_attributes(itemtype, itemkey);
1291:
1292: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => 'AUCTION_HEADER_ID');
1295:
1296: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1296: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1292: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => 'AUCTION_HEADER_ID');
1295:
1296: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => 'AME_TRANSACTION_ID');
1299:
1300: -- change the approval status of the transaction to REJECTED

Line 1324: l_approval_date := wf_engine.GetItemAttrDate(itemtype => itemtype,

1320: l_approval_date DATE;
1321: BEGIN
1322:
1323: -- if the approval date is null, set it to the current date
1324: l_approval_date := wf_engine.GetItemAttrDate(itemtype => itemtype,
1325: itemkey => itemkey,
1326: aname => 'APPROVAL_DATE');
1327:
1328: IF l_approval_date IS NULL THEN

Line 1331: wf_engine.SetItemAttrDate(itemtype => itemtype,

1327:
1328: IF l_approval_date IS NULL THEN
1329: l_approval_date := SYSDATE;
1330:
1331: wf_engine.SetItemAttrDate(itemtype => itemtype,
1332: itemkey => itemkey,
1333: aname => 'APPROVAL_DATE',
1334: avalue => l_approval_date);
1335: END IF;

Line 1340: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1336:
1337: -- set attributes specific to award approved notification
1338: set_award_approved_attributes(itemtype, itemkey);
1339:
1340: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'AUCTION_HEADER_ID');
1343:
1344: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1344: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1340: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1341: itemkey => itemkey,
1342: aname => 'AUCTION_HEADER_ID');
1343:
1344: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1345: itemkey => itemkey,
1346: aname => 'AME_TRANSACTION_ID');
1347:
1348: -- record that document as been approved (by all required approvers, if any)

Line 1410: l_preparer_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1406:
1407: BEGIN
1408:
1409: -- bug 9555176 begin
1410: l_preparer_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1411: itemkey => itemkey,
1412: aname => 'PREPARER_RESP_ID');
1413:
1414: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1414: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1410: l_preparer_resp_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1411: itemkey => itemkey,
1412: aname => 'PREPARER_RESP_ID');
1413:
1414: l_preparer_appl_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1415: itemkey => itemkey,
1416: aname => 'PREPARER_APPL_ID');
1417:
1418: --Intialize the context of the approver as that of the preparer

Line 1426: l_response_type := wf_engine.GetItemAttrText(itemtype => itemtype,

1422:
1423:
1424: --Bug 9555176 End
1425:
1426: l_response_type := wf_engine.GetItemAttrText(itemtype => itemtype,
1427: itemkey => itemkey,
1428: aname => 'RESULT');
1429:
1430: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1430: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1426: l_response_type := wf_engine.GetItemAttrText(itemtype => itemtype,
1427: itemkey => itemkey,
1428: aname => 'RESULT');
1429:
1430: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1431: itemkey => itemkey,
1432: aname => 'AUCTION_HEADER_ID');
1433:
1434: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1434: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,

1430: l_auction_header_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1431: itemkey => itemkey,
1432: aname => 'AUCTION_HEADER_ID');
1433:
1434: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1435: itemkey => itemkey,
1436: aname => 'AME_TRANSACTION_ID');
1437:
1438: l_approver_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1438: l_approver_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

1434: l_transaction_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1435: itemkey => itemkey,
1436: aname => 'AME_TRANSACTION_ID');
1437:
1438: l_approver_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,
1439: itemkey => itemkey,
1440: aname => 'APPROVER_USER');
1441:
1442: -- get the note to buyer attribute

Line 1443: l_note_to_buyer := wf_engine.GetItemAttrText(itemtype => itemtype,

1439: itemkey => itemkey,
1440: aname => 'APPROVER_USER');
1441:
1442: -- get the note to buyer attribute
1443: l_note_to_buyer := wf_engine.GetItemAttrText(itemtype => itemtype,
1444: itemkey => itemkey,
1445: aname => 'NOTE_TO_BUYER');
1446:
1447: l_response_date := SYSDATE;

Line 1461: l_approver_string := wf_engine.GetItemAttrText( itemtype => itemtype,

1457: l_action_type := 'AWARD_APPROVE_AND_FORWARD';
1458: END IF;
1459:
1460:
1461: l_approver_string := wf_engine.GetItemAttrText( itemtype => itemtype,
1462: itemkey => itemkey,
1463: aname => 'APPROVER_STRING');
1464:
1465: log_string( l_statement_log_level,

Line 1500: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1496: ruleIdListOut => l_idList);
1497:
1498: IF( l_approver.api_insertion = ame_util.apiAuthorityInsertion AND
1499: l_source_type_out <> ame_util.forwardeeSource ) THEN
1500: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1501: itemkey => itemkey,
1502: aname => 'FIRST_AUTHORITY_APPROVER_ID');
1503: END IF;
1504: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN

Line 1527: wf_engine.SetItemAttrText( itemtype => itemtype,

1523: resultout := 'OAM_API_ERROR';
1524: l_success_flag := FALSE;
1525:
1526: -- this message can be seen only by admin.
1527: wf_engine.SetItemAttrText( itemtype => itemtype,
1528: itemkey => itemkey,
1529: aname => 'OAM_ERROR',
1530: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1531:

Line 1533: wf_engine.SetItemAttrText( itemtype => itemtype,

1529: aname => 'OAM_ERROR',
1530: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1531:
1532: -- this message can be seen by any buyer.
1533: wf_engine.SetItemAttrText( itemtype => itemtype,
1534: itemkey => itemkey,
1535: aname => 'APPLICATION_ERROR',
1536: avalue => PON_AUCTION_PKG.getMessage('PON_NO_PERSON_FOR_POSITION', '', 'POSITION_NAME', l_approver.display_name ));
1537:

Line 1568: wf_engine.SetItemAttrDate(itemtype => itemtype,

1564: l_approver_employee.user_id);
1565:
1566: -- set the appropriate attributes depending on response type
1567: IF l_response_type IN ('APPROVE', 'APPROVE_AND_FORWARD') THEN
1568: wf_engine.SetItemAttrDate(itemtype => itemtype,
1569: itemkey => itemkey,
1570: aname => 'APPROVAL_DATE',
1571: avalue => l_response_date);
1572: ELSIF l_response_type = 'REJECT' THEN

Line 1573: wf_engine.SetItemAttrDate(itemtype => itemtype,

1569: itemkey => itemkey,
1570: aname => 'APPROVAL_DATE',
1571: avalue => l_response_date);
1572: ELSIF l_response_type = 'REJECT' THEN
1573: wf_engine.SetItemAttrDate(itemtype => itemtype,
1574: itemkey => itemkey,
1575: aname => 'REJECTION_DATE',
1576: avalue => l_response_date);
1577: END IF;

Line 1591: l_forwardee_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,

1587: ELSIF l_response_type = 'REJECT' THEN
1588: resultout := 'REJECTION';
1589: -- if the approver is forwarding, validate the forwardee
1590: ELSIF l_response_type IN ('FORWARD', 'APPROVE_AND_FORWARD') THEN
1591: l_forwardee_user_name := wf_engine.GetItemAttrText(itemtype => itemtype,
1592: itemkey => itemkey,
1593: aname => 'APPROVER_FORWARDEE_USER');
1594:
1595: -- if no forwardee was specified

Line 1601: wf_engine.SetItemAttrText(itemtype => itemtype,

1597: resultout := 'INVALID_FORWARD';
1598: l_valid_response := FALSE;
1599:
1600: -- set the Application Error workflow attribute
1601: wf_engine.SetItemAttrText(itemtype => itemtype,
1602: itemkey => itemkey,
1603: aname => 'APPLICATION_ERROR',
1604: avalue => PON_AUCTION_PKG.getMessage('PON_NO_FORWARDEE_SPECIFIED'));
1605: -- otherwise

Line 1619: wf_engine.SetItemAttrText(itemtype => itemtype,

1615: resultout := 'INVALID_FORWARD';
1616: l_valid_response := FALSE;
1617:
1618: -- set the Application Error workflow attribute
1619: wf_engine.SetItemAttrText(itemtype => itemtype,
1620: itemkey => itemkey,
1621: aname => 'APPLICATION_ERROR',
1622: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME', get_display_name_for_user(l_forwardee_user_name)));
1623: END IF;

Line 1675: wf_engine.SetItemAttrText( itemtype => itemtype,

1671: resultout := 'INVALID_FORWARD';
1672: l_success_flag := FALSE;
1673:
1674: -- this message can be seen only by admin.
1675: wf_engine.SetItemAttrText( itemtype => itemtype,
1676: itemkey => itemkey,
1677: aname => 'OAM_ERROR',
1678: avalue => PON_AUCTION_PKG.getMessage('PON_NO_POSITION_FOR_PERSON', '', 'PERSON_NAME', l_forwardee.display_name ));
1679:

Line 1681: wf_engine.SetItemAttrText( itemtype => itemtype,

1677: aname => 'OAM_ERROR',
1678: avalue => PON_AUCTION_PKG.getMessage('PON_NO_POSITION_FOR_PERSON', '', 'PERSON_NAME', l_forwardee.display_name ));
1679:
1680: -- this message can be seen by any buyer.
1681: wf_engine.SetItemAttrText( itemtype => itemtype,
1682: itemkey => itemkey,
1683: aname => 'APPLICATION_ERROR',
1684: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME',l_forwardee.display_name ));
1685:

Line 1705: wf_engine.SetItemAttrText( itemtype => itemtype,

1701: resultout := 'INVALID_FORWARD';
1702: l_success_flag := FALSE;
1703:
1704: -- this message can be seen only by admin.
1705: wf_engine.SetItemAttrText( itemtype => itemtype,
1706: itemkey => itemkey,
1707: aname => 'OAM_ERROR',
1708: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME',l_forwardee.display_name ));
1709:

Line 1711: wf_engine.SetItemAttrText( itemtype => itemtype,

1707: aname => 'OAM_ERROR',
1708: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME',l_forwardee.display_name ));
1709:
1710: -- this message can be seen by any buyer.
1711: wf_engine.SetItemAttrText( itemtype => itemtype,
1712: itemkey => itemkey,
1713: aname => 'APPLICATION_ERROR',
1714: avalue => PON_AUCTION_PKG.getMessage('PON_INVALID_FORWARDEE', NULL, 'NAME', l_forwardee.display_name ));
1715:

Line 1749: wf_engine.SetItemAttrText(itemtype => itemtype,

1745:
1746: -- if the OAM API call raises an exception,
1747: -- set the Application Error and OAM Error workflow attributes
1748: -- this message is internal and can be seen only by the OAM administrator
1749: wf_engine.SetItemAttrText(itemtype => itemtype,
1750: itemkey => itemkey,
1751: aname => 'OAM_ERROR',
1752: avalue => SQLERRM);
1753:

Line 1755: wf_engine.SetItemAttrText(itemtype => itemtype,

1751: aname => 'OAM_ERROR',
1752: avalue => SQLERRM);
1753:
1754: -- this message can be seen by any buyer
1755: wf_engine.SetItemAttrText(itemtype => itemtype,
1756: itemkey => itemkey,
1757: aname => 'APPLICATION_ERROR',
1758: avalue => PON_AUCTION_PKG.getMessage('PON_OAM_ERROR_OCCURRED'));
1759:

Line 1776: wf_engine.createProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,

1772: p_note_to_approvers IN VARCHAR2,
1773: p_first_authority_approver_id IN NUMBER ) IS
1774: BEGIN
1775:
1776: wf_engine.createProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1777: itemkey => p_item_key,
1778: process => 'AWARD_APPROVAL');
1779:
1780: -- set main language-independent workflow attributes

Line 1785: wf_engine.SetItemOwner(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,

1781: set_core_attributes(AWARD_APPROVAL_WF_ITEM_TYPE, p_item_key, p_auction_header_id, p_note_to_approvers, p_first_authority_approver_id);
1782:
1783:
1784: -- Bug 4295915: Set the workflow owner
1785: wf_engine.SetItemOwner(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1786: itemkey => p_item_key,
1787: owner => fnd_global.user_name);
1788:
1789: -- start workflow process

Line 1790: wf_engine.StartProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,

1786: itemkey => p_item_key,
1787: owner => fnd_global.user_name);
1788:
1789: -- start workflow process
1790: wf_engine.StartProcess(itemtype => AWARD_APPROVAL_WF_ITEM_TYPE,
1791: itemkey => p_item_key);
1792:
1793: END start_workflow_process;
1794: