eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_APPROVAL_PKG dependencies on WF_ENGINE

Line 21: | Added call to wf_engine.SetItemOwner

17: | Date UserName Description
18: | -------------------------------------------------------------------------------------------
19: |
20: | 25-Aug-05 sparames Bug 4295915: Missing owner in Sourcing notifications
21: | Added call to wf_engine.SetItemOwner
22: |
23: | 09-Sep-05 120.25 sparames ECO 4456420: Added setting of ORIGIN_USER_NAME to the
24: | current user for most operations
25: |

Line 68: wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'APPROVED');

64: end;
65: -- time to move the parent activity to the approved state
66: if l_activity_status = 'WAITFOR APPROVALS' then
67: if (l_auction_approval_status = 'APPROVED') then
68: wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'APPROVED');
69: else wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'NOT_REQUIRED');
70: end if;
71: end if;
72: end if; -- APPROVED

Line 69: else wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'NOT_REQUIRED');

65: -- time to move the parent activity to the approved state
66: if l_activity_status = 'WAITFOR APPROVALS' then
67: if (l_auction_approval_status = 'APPROVED') then
68: wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'APPROVED');
69: else wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'NOT_REQUIRED');
70: end if;
71: end if;
72: end if; -- APPROVED
73: End Process_If_Doc_Approved;

Line 91: wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'REJECTED');

87: l_activity_status := 'DO Nothing';
88: end;
89: -- time to move the parent activity to the rejected state
90: if l_activity_status = 'WAITFOR APPROVALS' then
91: wf_engine.CompleteActivity(l_item_type,p_top_process_item_key,l_activity_status,'REJECTED');
92: end if;
93: End Process_Doc_Rejected;
94:
95: PROCEDURE CANCEL_NOTIFICATION(p_auction_header_id number,

Line 227: -- wf_engine.CompleteActivity(l_item_type,r1.item_key,

223: begin
224: for r1 in List_of_Process(l_item_type,p_parent_item_key) loop
225: begin
226: WF_Notification.cancel(r1.notification_id);
227: -- wf_engine.CompleteActivity(l_item_type,r1.item_key,
228: -- r1.activity_label,'CLOSE');
229:
230: exception when others then null;
231: end;

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

240: resultout out nocopy varchar2) is
241:
242: l_auction_header_id NUMBER;
243: begin
244: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'AUCTION_HEADER_ID');
247: update pon_auction_headers_all
248: set auction_status = 'CANCELLED'

Line 356: wf_engine.createProcess ( itemType => l_itemType,

352: into l_seq from sys.dual;
353:
354: l_itemKey := to_char (p_auction_header_id)|| '-' || l_seq;
355:
356: wf_engine.createProcess ( itemType => l_itemType,
357: itemKey => l_itemKey,
358: process => 'SOURCINGAPPROVAL');
359:
360:

Line 380: wf_engine.SetItemAttrText (itemtype => l_itemType,

376:
377:
378: -- new item attribute to hold the redirect Function. Attribute value is going
379: -- to be used as a parameter to access Review and Submit page
380: wf_engine.SetItemAttrText (itemtype => l_itemType,
381: itemkey => l_itemKey,
382: aname => 'REVIEWPG_REDIRECTFUNC',
383: avalue => p_redirect_func);
384:

Line 385: wf_engine.SetItemAttrText (itemtype => l_itemType,

381: itemkey => l_itemKey,
382: aname => 'REVIEWPG_REDIRECTFUNC',
383: avalue => p_redirect_func);
384:
385: wf_engine.SetItemAttrText (itemtype => l_itemType,
386: itemkey => l_itemKey,
387: aname => 'REVIEW_CHANGES_URL',
388: avalue => l_review_changes_url);
389:

Line 390: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

386: itemkey => l_itemKey,
387: aname => 'REVIEW_CHANGES_URL',
388: avalue => l_review_changes_url);
389:
390: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
391: itemkey => l_itemKey,
392: aname => 'TRADING_PARTNER_CONTACT_ID',
393: avalue => l_auction_contact_id);
394:

Line 395: wf_engine.SetItemAttrDate (itemtype => l_itemType,

391: itemkey => l_itemKey,
392: aname => 'TRADING_PARTNER_CONTACT_ID',
393: avalue => l_auction_contact_id);
394:
395: wf_engine.SetItemAttrDate (itemtype => l_itemType,
396: itemkey => l_itemKey,
397: aname => 'AUCTION_START_DATE',
398: avalue => l_open_bidding_date);
399:

Line 400: wf_engine.SetItemAttrDate (itemtype => l_itemType,

396: itemkey => l_itemKey,
397: aname => 'AUCTION_START_DATE',
398: avalue => l_open_bidding_date);
399:
400: wf_engine.SetItemAttrDate (itemtype => l_itemType,
401: itemkey => l_itemKey,
402: aname => 'AUCTION_END_DATE',
403: avalue => l_close_bidding_date);
404:

Line 405: wf_engine.SetItemAttrText (itemtype => l_itemType,

401: itemkey => l_itemKey,
402: aname => 'AUCTION_END_DATE',
403: avalue => l_close_bidding_date);
404:
405: wf_engine.SetItemAttrText (itemtype => l_itemType,
406: itemkey => l_itemKey,
407: aname => 'TOP_PROCESS_ITEM_KEY',
408: avalue => l_itemKey);
409:

Line 410: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

406: itemkey => l_itemKey,
407: aname => 'TOP_PROCESS_ITEM_KEY',
408: avalue => l_itemKey);
409:
410: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
411: itemkey => l_itemKey,
412: aname => 'AUCTION_HEADER_ID',
413: avalue => p_auction_header_id);
414:

Line 415: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

411: itemkey => l_itemKey,
412: aname => 'AUCTION_HEADER_ID',
413: avalue => p_auction_header_id);
414:
415: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
416: itemkey => l_itemKey,
417: aname => 'DOC_ROUND_NUMBER',
418: avalue => l_round_number);
419:

Line 420: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

416: itemkey => l_itemKey,
417: aname => 'DOC_ROUND_NUMBER',
418: avalue => l_round_number);
419:
420: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
421: itemkey => l_itemKey,
422: aname => 'DOC_AMENDMENT_NUMBER',
423: avalue => l_amendment_number);
424:

Line 426: wf_engine.SetItemAttrDate (itemtype => l_itemType,

422: aname => 'DOC_AMENDMENT_NUMBER',
423: avalue => l_amendment_number);
424:
425:
426: wf_engine.SetItemAttrDate (itemtype => l_itemType,
427: itemkey => l_itemKey,
428: aname => 'TIMEOUT_MAINPROCESS',
429: avalue => l_close_bidding_date);
430:

Line 431: wf_engine.SetItemAttrText (itemtype => l_itemType,

427: itemkey => l_itemKey,
428: aname => 'TIMEOUT_MAINPROCESS',
429: avalue => l_close_bidding_date);
430:
431: wf_engine.SetItemAttrText (itemtype => l_itemType,
432: itemkey => l_itemKey,
433: aname => 'CREATOR_USER_NAME',
434: avalue => l_creator_user_name);
435:

Line 436: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

432: itemkey => l_itemKey,
433: aname => 'CREATOR_USER_NAME',
434: avalue => l_creator_user_name);
435:
436: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
437: itemkey => l_itemKey,
438: aname => 'CREATOR_USER_ID',
439: avalue => l_creator_user_id);
440:

Line 449: wf_engine.SetItemAttrText (itemtype => l_itemType,

445: and auh.doctype_id = dt.doctype_id;
446:
447: l_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (l_doctype_group_name);
448:
449: wf_engine.SetItemAttrText (itemtype => l_itemType,
450: itemkey => l_itemKey,
451: aname => 'MSG_SUFFIX',
452: avalue => l_msg_suffix);
453: -- Get the user's timezone

Line 476: wf_engine.SetItemAttrText (itemtype => l_itemType,

472: END IF;
473:
474: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
475:
476: wf_engine.SetItemAttrText (itemtype => l_itemType,
477: itemkey => l_itemKey,
478: aname => 'TIMEZONE',
479: avalue => l_timezone_disp);
480:

Line 484: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

480:
481: IF (l_preview_date IS NULL) THEN
482: l_timezone1_disp := null;
483:
484: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
485: itemkey => l_itemkey,
486: aname => 'PREVIEW_DATE',
487: avalue => null);
488:

Line 489: wf_engine.SetItemAttrText (itemtype => l_itemtype,

485: itemkey => l_itemkey,
486: aname => 'PREVIEW_DATE',
487: avalue => null);
488:
489: wf_engine.SetItemAttrText (itemtype => l_itemtype,
490: itemkey => l_itemkey,
491: aname => 'TP_TIME_ZONE1',
492: avalue => l_timezone1_disp);
493:

Line 494: wf_engine.SetItemAttrText (itemtype => l_itemtype,

490: itemkey => l_itemkey,
491: aname => 'TP_TIME_ZONE1',
492: avalue => l_timezone1_disp);
493:
494: wf_engine.SetItemAttrText (itemtype => l_itemtype,
495: itemkey => l_itemkey,
496: aname => 'PREVIEW_DATE_NOTSPECIFIED',
497: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix));
498: ELSE

Line 501: wf_engine.SetItemAttrDate (itemtype => l_itemtype,

497: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC',l_msg_suffix));
498: ELSE
499: l_timezone1_disp := l_timezone_disp;
500:
501: wf_engine.SetItemAttrDate (itemtype => l_itemtype,
502: itemkey => l_itemkey,
503: aname => 'PREVIEW_DATE',
504: avalue => l_preview_date_in_tz);
505:

Line 506: wf_engine.SetItemAttrText (itemtype => l_itemtype,

502: itemkey => l_itemkey,
503: aname => 'PREVIEW_DATE',
504: avalue => l_preview_date_in_tz);
505:
506: wf_engine.SetItemAttrText (itemtype => l_itemtype,
507: itemkey => l_itemkey,
508: aname => 'TP_TIME_ZONE1',
509: avalue => l_timezone1_disp);
510:

Line 511: wf_engine.SetItemAttrText (itemtype => l_itemtype,

507: itemkey => l_itemkey,
508: aname => 'TP_TIME_ZONE1',
509: avalue => l_timezone1_disp);
510:
511: wf_engine.SetItemAttrText (itemtype => l_itemtype,
512: itemkey => l_itemkey,
513: aname => 'PREVIEW_DATE_NOTSPECIFIED',
514: avalue => null);
515: END IF;

Line 518: wf_engine.SetItemAttrDate (itemtype => l_itemType,

514: avalue => null);
515: END IF;
516:
517:
518: wf_engine.SetItemAttrDate (itemtype => l_itemType,
519: itemkey => l_itemKey,
520: aname => 'AUCTION_START_DATE',
521: avalue => l_open_date_in_tz);
522: if (l_open_auction_now_flag = 'Y') then

Line 523: wf_engine.SetItemAttrText (itemtype => l_itemType,

519: itemkey => l_itemKey,
520: aname => 'AUCTION_START_DATE',
521: avalue => l_open_date_in_tz);
522: if (l_open_auction_now_flag = 'Y') then
523: wf_engine.SetItemAttrText (itemtype => l_itemType,
524: itemkey => l_itemKey,
525: aname => 'OPEN_IMMEDIATELY',
526: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
527:

Line 528: wf_engine.SetItemAttrText (itemtype => l_itemType,

524: itemkey => l_itemKey,
525: aname => 'OPEN_IMMEDIATELY',
526: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
527:
528: wf_engine.SetItemAttrText (itemtype => l_itemType,
529: itemkey => l_itemKey,
530: aname => 'O_TIMEZONE',
531: avalue => null);
532: else

Line 533: wf_engine.SetItemAttrText (itemtype => l_itemType,

529: itemkey => l_itemKey,
530: aname => 'O_TIMEZONE',
531: avalue => null);
532: else
533: wf_engine.SetItemAttrText (itemtype => l_itemType,
534: itemkey => l_itemKey,
535: aname => 'OPEN_IMMEDIATELY',
536: avalue =>null);
537: wf_engine.SetItemAttrText (itemtype => l_itemType,

Line 537: wf_engine.SetItemAttrText (itemtype => l_itemType,

533: wf_engine.SetItemAttrText (itemtype => l_itemType,
534: itemkey => l_itemKey,
535: aname => 'OPEN_IMMEDIATELY',
536: avalue =>null);
537: wf_engine.SetItemAttrText (itemtype => l_itemType,
538: itemkey => l_itemKey,
539: aname => 'O_TIMEZONE',
540: avalue => l_timezone_disp);
541: end if;

Line 543: wf_engine.SetItemAttrDate (itemtype => l_itemType,

539: aname => 'O_TIMEZONE',
540: avalue => l_timezone_disp);
541: end if;
542:
543: wf_engine.SetItemAttrDate (itemtype => l_itemType,
544: itemkey => l_itemKey,
545: aname => 'AUCTION_END_DATE',
546: avalue => l_close_date_in_tz);
547:

Line 549: wf_engine.SetItemAttrText (itemtype => l_itemType,

545: aname => 'AUCTION_END_DATE',
546: avalue => l_close_date_in_tz);
547:
548:
549: wf_engine.SetItemAttrText (itemtype => l_itemType,
550: itemkey => l_itemKey,
551: aname => 'NOTE_TO_APPROVERS',
552: avalue => p_note_to_approvers);
553: select document_number

Line 569: wf_engine.SetItemAttrText (itemtype => l_itemType,

565: where fnd.employee_id=emp.person_id and
566: fnd.user_id = l_creator_user_id and
567: trunc(sysdate) between emp.effective_start_date and emp.effective_end_date;
568:
569: wf_engine.SetItemAttrText (itemtype => l_itemType,
570: itemkey => l_itemKey,
571: aname => 'AUCTIONEER_NAME',
572: avalue => l_creator_full_name);
573:

Line 575: wf_engine.SetItemAttrText (itemtype => l_itemType,

571: aname => 'AUCTIONEER_NAME',
572: avalue => l_creator_full_name);
573:
574:
575: wf_engine.SetItemAttrText (itemtype => l_itemType,
576: itemkey => l_itemKey,
577: aname => 'ORIGIN_USER_NAME',
578: avalue => fnd_global.user_name);
579:

Line 593: wf_engine.SetItemOwner(itemtype => l_itemtype,

589: l_submit_user_id,'USER');
590:
591:
592: -- Bug 4295915: Set the workflow owner
593: wf_engine.SetItemOwner(itemtype => l_itemtype,
594: itemkey => l_itemkey,
595: owner => fnd_global.user_name);
596:
597: wf_engine.StartProcess (itemType => l_itemType,

Line 597: wf_engine.StartProcess (itemType => l_itemType,

593: wf_engine.SetItemOwner(itemtype => l_itemtype,
594: itemkey => l_itemkey,
595: owner => fnd_global.user_name);
596:
597: wf_engine.StartProcess (itemType => l_itemType,
598: itemKey => l_itemKey );
599:
600: /* Update Headers table */
601: UPDATE pon_auction_headers_all set

Line 682: l_preparer_tp_name := wf_engine.GetItemAttrText (itemtype => itemType,

678: if l_timeout_factor <= 0 or l_timeout_factor >=1 then
679: l_timeout_factor := .5;
680: end if;
681:
682: l_preparer_tp_name := wf_engine.GetItemAttrText (itemtype => itemType,
683: itemkey => itemKey,
684: aname => 'PREPARER_TP_NAME');
685:
686: l_auction_title := wf_engine.GetItemAttrText (itemtype => itemType,

Line 686: l_auction_title := wf_engine.GetItemAttrText (itemtype => itemType,

682: l_preparer_tp_name := wf_engine.GetItemAttrText (itemtype => itemType,
683: itemkey => itemKey,
684: aname => 'PREPARER_TP_NAME');
685:
686: l_auction_title := wf_engine.GetItemAttrText (itemtype => itemType,
687: itemkey => itemKey,
688: aname => 'AUCTION_TITLE');
689:
690: l_doc_number := wf_engine.GetItemAttrText (itemtype => itemType,

Line 690: l_doc_number := wf_engine.GetItemAttrText (itemtype => itemType,

686: l_auction_title := wf_engine.GetItemAttrText (itemtype => itemType,
687: itemkey => itemKey,
688: aname => 'AUCTION_TITLE');
689:
690: l_doc_number := wf_engine.GetItemAttrText (itemtype => itemType,
691: itemkey => itemKey,
692: aname => 'DOC_NUMBER');
693:
694: l_preparer_tp_contact_name := wf_engine.GetItemAttrText (itemtype => itemType,

Line 694: l_preparer_tp_contact_name := wf_engine.GetItemAttrText (itemtype => itemType,

690: l_doc_number := wf_engine.GetItemAttrText (itemtype => itemType,
691: itemkey => itemKey,
692: aname => 'DOC_NUMBER');
693:
694: l_preparer_tp_contact_name := wf_engine.GetItemAttrText (itemtype => itemType,
695: itemkey => itemKey,
696: aname => 'PREPARER_TP_CONTACT_NAME');
697:
698: l_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemType,

Line 698: l_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemType,

694: l_preparer_tp_contact_name := wf_engine.GetItemAttrText (itemtype => itemType,
695: itemkey => itemKey,
696: aname => 'PREPARER_TP_CONTACT_NAME');
697:
698: l_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemType,
699: itemkey => itemKey,
700: aname => 'AUCTION_START_DATE');
701:
702: l_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemType,

Line 702: l_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemType,

698: l_auction_start_date := wf_engine.GetItemAttrDate (itemtype => itemType,
699: itemkey => itemKey,
700: aname => 'AUCTION_START_DATE');
701:
702: l_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemType,
703: itemkey => itemKey,
704: aname => 'AUCTION_END_DATE');
705:
706: l_timezone_dsp := wf_engine.GetItemAttrText (itemtype => itemType,

Line 706: l_timezone_dsp := wf_engine.GetItemAttrText (itemtype => itemType,

702: l_auction_end_date := wf_engine.GetItemAttrDate (itemtype => itemType,
703: itemkey => itemKey,
704: aname => 'AUCTION_END_DATE');
705:
706: l_timezone_dsp := wf_engine.GetItemAttrText (itemtype => itemType,
707: itemkey => itemKey,
708: aname => 'TIMEZONE');
709:
710:

Line 712: l_note_to_approvers := wf_engine.GetItemAttrText (itemtype => itemType,

708: aname => 'TIMEZONE');
709:
710:
711:
712: l_note_to_approvers := wf_engine.GetItemAttrText (itemtype => itemType,
713: itemkey => itemKey,
714: aname => 'NOTE_TO_APPROVERS');
715:
716: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,

Line 716: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,

712: l_note_to_approvers := wf_engine.GetItemAttrText (itemtype => itemType,
713: itemkey => itemKey,
714: aname => 'NOTE_TO_APPROVERS');
715:
716: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
717: itemkey => itemKey,
718: aname => 'PREVIEW_DATE');
719: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
720: itemkey => itemKey,

Line 719: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,

715:
716: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
717: itemkey => itemKey,
718: aname => 'PREVIEW_DATE');
719: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
720: itemkey => itemKey,
721: aname => 'TP_TIME_ZONE1');
722:
723: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,

Line 723: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,

719: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
720: itemkey => itemKey,
721: aname => 'TP_TIME_ZONE1');
722:
723: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
724: itemkey => itemKey,
725: aname => 'PREVIEW_DATE_NOTSPECIFIED');
726: l_msg_suffix := wf_engine.GetItemAttrText (itemtype => itemType,
727: itemkey => itemKey,

Line 726: l_msg_suffix := wf_engine.GetItemAttrText (itemtype => itemType,

722:
723: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
724: itemkey => itemKey,
725: aname => 'PREVIEW_DATE_NOTSPECIFIED');
726: l_msg_suffix := wf_engine.GetItemAttrText (itemtype => itemType,
727: itemkey => itemKey,
728: aname => 'MSG_SUFFIX');
729:
730: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemType,

Line 730: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemType,

726: l_msg_suffix := wf_engine.GetItemAttrText (itemtype => itemType,
727: itemkey => itemKey,
728: aname => 'MSG_SUFFIX');
729:
730: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
731: itemkey => itemKey,
732: aname => 'AUCTION_HEADER_ID');
733:
734: l_round_number := wf_engine.GetItemAttrNumber (itemtype => itemType,

Line 734: l_round_number := wf_engine.GetItemAttrNumber (itemtype => itemType,

730: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
731: itemkey => itemKey,
732: aname => 'AUCTION_HEADER_ID');
733:
734: l_round_number := wf_engine.GetItemAttrNumber (itemtype => itemType,
735: itemkey => itemKey,
736: aname => 'DOC_ROUND_NUMBER');
737:
738:

Line 740: l_amendment_number := wf_engine.GetItemAttrNumber (itemtype => itemType,

736: aname => 'DOC_ROUND_NUMBER');
737:
738:
739:
740: l_amendment_number := wf_engine.GetItemAttrNumber (itemtype => itemType,
741: itemkey => itemKey,
742: aname => 'DOC_AMENDMENT_NUMBER');
743:
744: l_creator_full_name:= wf_engine.GetItemAttrText (itemtype => itemType,

Line 744: l_creator_full_name:= wf_engine.GetItemAttrText (itemtype => itemType,

740: l_amendment_number := wf_engine.GetItemAttrNumber (itemtype => itemType,
741: itemkey => itemKey,
742: aname => 'DOC_AMENDMENT_NUMBER');
743:
744: l_creator_full_name:= wf_engine.GetItemAttrText (itemtype => itemType,
745: itemkey => itemKey,
746: aname => 'AUCTIONEER_NAME');
747:
748: l_redirect_func:= wf_engine.GetItemAttrText (itemtype => itemType,

Line 748: l_redirect_func:= wf_engine.GetItemAttrText (itemtype => itemType,

744: l_creator_full_name:= wf_engine.GetItemAttrText (itemtype => itemType,
745: itemkey => itemKey,
746: aname => 'AUCTIONEER_NAME');
747:
748: l_redirect_func:= wf_engine.GetItemAttrText (itemtype => itemType,
749: itemkey => itemKey,
750: aname => 'REVIEWPG_REDIRECTFUNC');
751:
752: /* Preserve creator's session language */

Line 753: l_creator_user_name := wf_engine.GetItemAttrText (itemtype => itemType,

749: itemkey => itemKey,
750: aname => 'REVIEWPG_REDIRECTFUNC');
751:
752: /* Preserve creator's session language */
753: l_creator_user_name := wf_engine.GetItemAttrText (itemtype => itemType,
754: itemkey => itemKey,
755: aname => 'CREATOR_USER_NAME');
756:
757: l_creator_user_id := wf_engine.GetItemAttrNumber (itemtype => itemType,

Line 757: l_creator_user_id := wf_engine.GetItemAttrNumber (itemtype => itemType,

753: l_creator_user_name := wf_engine.GetItemAttrText (itemtype => itemType,
754: itemkey => itemKey,
755: aname => 'CREATOR_USER_NAME');
756:
757: l_creator_user_id := wf_engine.GetItemAttrNumber (itemtype => itemType,
758: itemkey => itemKey,
759: aname => 'CREATOR_USER_ID');
760:
761:

Line 797: wf_engine.createProcess ( itemType => l_itemType,

793:
794: l_itemKey := itemkey || '_' || r1.user_id;
795:
796:
797: wf_engine.createProcess ( itemType => l_itemType,
798: itemKey => l_itemKey,
799: process => 'USERAPPROVALS');
800:
801:

Line 814: wf_engine.SetItemAttrDate (itemtype => l_itemType,

810: select sysdate+((l_reminder_date - sysdate) * l_timeout_factor)
811: into l_reminder_date
812: from dual;
813:
814: wf_engine.SetItemAttrDate (itemtype => l_itemType,
815: itemkey => l_itemKey,
816: aname => 'TIMEOUT_USERPROCESS',
817: avalue => l_reminder_date);
818:

Line 819: wf_engine.SetItemAttrText (itemtype => l_itemType,

815: itemkey => l_itemKey,
816: aname => 'TIMEOUT_USERPROCESS',
817: avalue => l_reminder_date);
818:
819: wf_engine.SetItemAttrText (itemtype => l_itemType,
820: itemkey => l_itemKey,
821: aname => 'CREATOR_USER_NAME',
822: avalue => l_creator_user_name);
823:

Line 824: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

820: itemkey => l_itemKey,
821: aname => 'CREATOR_USER_NAME',
822: avalue => l_creator_user_name);
823:
824: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
825: itemkey => l_itemKey,
826: aname => 'CREATOR_USER_ID',
827: avalue => l_creator_user_id);
828:

Line 829: wf_engine.SetItemAttrText (itemtype => l_itemType,

825: itemkey => l_itemKey,
826: aname => 'CREATOR_USER_ID',
827: avalue => l_creator_user_id);
828:
829: wf_engine.SetItemAttrText (itemtype => l_itemType,
830: itemkey => l_itemKey,
831: aname => 'REVIEWPG_REDIRECTFUNC',
832: avalue => l_redirect_func);
833:

Line 834: wf_engine.SetItemAttrText (itemtype => l_itemType,

830: itemkey => l_itemKey,
831: aname => 'REVIEWPG_REDIRECTFUNC',
832: avalue => l_redirect_func);
833:
834: wf_engine.SetItemAttrText (itemtype => l_itemType,
835: itemkey => l_itemKey,
836: aname => 'PREPARER_TP_NAME',
837: avalue => l_preparer_tp_name);
838:

Line 839: wf_engine.SetItemAttrText (itemtype => l_itemType,

835: itemkey => l_itemKey,
836: aname => 'PREPARER_TP_NAME',
837: avalue => l_preparer_tp_name);
838:
839: wf_engine.SetItemAttrText (itemtype => l_itemType,
840: itemkey => l_itemKey,
841: aname => 'AUCTION_TITLE',
842: avalue => l_auction_title);
843:

Line 844: wf_engine.SetItemAttrText (itemtype => l_itemType,

840: itemkey => l_itemKey,
841: aname => 'AUCTION_TITLE',
842: avalue => l_auction_title);
843:
844: wf_engine.SetItemAttrText (itemtype => l_itemType,
845: itemkey => l_itemKey,
846: aname => 'DOC_NUMBER',
847: avalue => l_doc_number);
848:

Line 849: wf_engine.SetItemAttrText (itemtype => l_itemType,

845: itemkey => l_itemKey,
846: aname => 'DOC_NUMBER',
847: avalue => l_doc_number);
848:
849: wf_engine.SetItemAttrText (itemtype => l_itemType,
850: itemkey => l_itemKey,
851: aname => 'PREPARER_TP_CONTACT_NAME',
852: avalue => l_preparer_tp_contact_name);
853:

Line 854: wf_engine.SetItemAttrDate (itemtype => l_itemType,

850: itemkey => l_itemKey,
851: aname => 'PREPARER_TP_CONTACT_NAME',
852: avalue => l_preparer_tp_contact_name);
853:
854: wf_engine.SetItemAttrDate (itemtype => l_itemType,
855: itemkey => l_itemKey,
856: aname => 'AUCTION_START_DATE',
857: avalue => l_auction_start_date);
858:

Line 859: wf_engine.SetItemAttrDate (itemtype => l_itemType,

855: itemkey => l_itemKey,
856: aname => 'AUCTION_START_DATE',
857: avalue => l_auction_start_date);
858:
859: wf_engine.SetItemAttrDate (itemtype => l_itemType,
860: itemkey => l_itemKey,
861: aname => 'AUCTION_END_DATE',
862: avalue => l_auction_end_date);
863:

Line 864: wf_engine.SetItemAttrText (itemtype => l_itemType,

860: itemkey => l_itemKey,
861: aname => 'AUCTION_END_DATE',
862: avalue => l_auction_end_date);
863:
864: wf_engine.SetItemAttrText (itemtype => l_itemType,
865: itemkey => l_itemKey,
866: aname => 'TIMEZONE',
867: avalue => l_timezone_dsp);
868:

Line 869: wf_engine.SetItemAttrDate (itemtype => l_itemType,

865: itemkey => l_itemKey,
866: aname => 'TIMEZONE',
867: avalue => l_timezone_dsp);
868:
869: wf_engine.SetItemAttrDate (itemtype => l_itemType,
870: itemkey => l_itemKey,
871: aname => 'PREVIEW_DATE',
872: avalue => l_preview_date_in_tz);
873:

Line 874: wf_engine.SetItemAttrText (itemtype => l_itemType,

870: itemkey => l_itemKey,
871: aname => 'PREVIEW_DATE',
872: avalue => l_preview_date_in_tz);
873:
874: wf_engine.SetItemAttrText (itemtype => l_itemType,
875: itemkey => l_itemKey,
876: aname => 'TP_TIME_ZONE1',
877: avalue => l_timezone1_disp);
878:

Line 880: wf_engine.SetItemAttrText (itemtype => l_itemType,

876: aname => 'TP_TIME_ZONE1',
877: avalue => l_timezone1_disp);
878:
879:
880: wf_engine.SetItemAttrText (itemtype => l_itemType,
881: itemkey => l_itemKey,
882: aname => 'PREVIEW_DATE_NOTSPECIFIED',
883: avalue => l_preview_date_nspec);
884:

Line 885: wf_engine.SetItemAttrText (itemtype => l_itemType,

881: itemkey => l_itemKey,
882: aname => 'PREVIEW_DATE_NOTSPECIFIED',
883: avalue => l_preview_date_nspec);
884:
885: wf_engine.SetItemAttrText (itemtype => l_itemType,
886: itemkey => l_itemKey,
887: aname => 'NOTE_TO_APPROVERS',
888: avalue => l_note_to_approvers);
889:

Line 890: wf_engine.SetItemAttrText (itemtype => l_itemType,

886: itemkey => l_itemKey,
887: aname => 'NOTE_TO_APPROVERS',
888: avalue => l_note_to_approvers);
889:
890: wf_engine.SetItemAttrText (itemtype => l_itemType,
891: itemkey => l_itemKey,
892: aname => 'TOP_PROCESS_ITEM_KEY',
893: avalue =>
894: wf_engine.GetItemAttrText (itemtype => l_itemType,

Line 894: wf_engine.GetItemAttrText (itemtype => l_itemType,

890: wf_engine.SetItemAttrText (itemtype => l_itemType,
891: itemkey => l_itemKey,
892: aname => 'TOP_PROCESS_ITEM_KEY',
893: avalue =>
894: wf_engine.GetItemAttrText (itemtype => l_itemType,
895: itemkey => itemKey,
896: aname => 'TOP_PROCESS_ITEM_KEY')
897: );
898:

Line 899: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

895: itemkey => itemKey,
896: aname => 'TOP_PROCESS_ITEM_KEY')
897: );
898:
899: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
900: itemkey => l_itemKey,
901: aname => 'AUCTION_HEADER_ID',
902: avalue => l_auction_header_id);
903:

Line 904: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

900: itemkey => l_itemKey,
901: aname => 'AUCTION_HEADER_ID',
902: avalue => l_auction_header_id);
903:
904: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
905: itemkey => l_itemKey,
906: aname => 'DOC_ROUND_NUMBER',
907: avalue => l_round_number);
908:

Line 909: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

905: itemkey => l_itemKey,
906: aname => 'DOC_ROUND_NUMBER',
907: avalue => l_round_number);
908:
909: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
910: itemkey => l_itemKey,
911: aname => 'DOC_AMENDMENT_NUMBER',
912: avalue => l_amendment_number);
913:

Line 918: wf_engine.SetItemAttrText (itemtype => l_itemType,

914: l_review_changes_url := pon_wf_utl_pkg.get_dest_page_url (
915: p_dest_func => 'PON_NEG_CRT_HEADER'
916: ,p_notif_performer => 'BUYER');
917:
918: wf_engine.SetItemAttrText (itemtype => l_itemType,
919: itemkey => l_itemKey,
920: aname => 'REVIEW_CHANGES_URL',
921: avalue => l_review_changes_url);
922:

Line 924: wf_engine.SetItemAttrText (itemtype => l_itemType,

920: aname => 'REVIEW_CHANGES_URL',
921: avalue => l_review_changes_url);
922:
923:
924: wf_engine.SetItemAttrText (itemtype => l_itemType,
925: itemkey => l_itemKey,
926: aname => 'APPOVER',
927: avalue => r1.user_name);
928:

Line 929: wf_engine.SetItemAttrNumber (itemtype => l_itemType,

925: itemkey => l_itemKey,
926: aname => 'APPOVER',
927: avalue => r1.user_name);
928:
929: wf_engine.SetItemAttrNumber (itemtype => l_itemType,
930: itemkey => l_itemKey,
931: aname => 'APPOVER_ID',
932: avalue => r1.user_id);
933:

Line 935: wf_engine.SetItemAttrText (itemtype => l_itemType,

931: aname => 'APPOVER_ID',
932: avalue => r1.user_id);
933:
934:
935: wf_engine.SetItemAttrText (itemtype => l_itemType,
936: itemkey => l_itemKey,
937: aname => 'ORIGIN_USER_NAME',
938: avalue => fnd_global.user_name);
939:

Line 950: wf_engine.SetItemAttrText (itemtype => l_itemType,

946: end if;
947:
948: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
949:
950: wf_engine.SetItemAttrText (itemtype => l_itemType,
951: itemkey => l_itemKey,
952: aname => 'TIMEZONE',
953: avalue => l_timezone_disp);
954:

Line 958: wf_engine.SetItemAttrDate (itemtype => l_itemType,

954:
955: l_open_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.open_bidding_date,l_oex_timezone,l_timezone);
956: l_close_date_in_tz := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(r1.close_bidding_date,l_oex_timezone,l_timezone);
957:
958: wf_engine.SetItemAttrDate (itemtype => l_itemType,
959: itemkey => l_itemKey,
960: aname => 'AUCTION_START_DATE',
961: avalue => l_open_date_in_tz);
962: if (r1.open_auction_now_flag = 'Y') then

Line 963: wf_engine.SetItemAttrText (itemtype => l_itemType,

959: itemkey => l_itemKey,
960: aname => 'AUCTION_START_DATE',
961: avalue => l_open_date_in_tz);
962: if (r1.open_auction_now_flag = 'Y') then
963: wf_engine.SetItemAttrText (itemtype => l_itemType,
964: itemkey => l_itemKey,
965: aname => 'OPEN_IMMEDIATELY',
966: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
967:

Line 968: wf_engine.SetItemAttrText (itemtype => l_itemType,

964: itemkey => l_itemKey,
965: aname => 'OPEN_IMMEDIATELY',
966: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',l_msg_suffix));
967:
968: wf_engine.SetItemAttrText (itemtype => l_itemType,
969: itemkey => l_itemKey,
970: aname => 'O_TIMEZONE',
971: avalue => null);
972: else

Line 973: wf_engine.SetItemAttrText (itemtype => l_itemType,

969: itemkey => l_itemKey,
970: aname => 'O_TIMEZONE',
971: avalue => null);
972: else
973: wf_engine.SetItemAttrText (itemtype => l_itemType,
974: itemkey => l_itemKey,
975: aname => 'OPEN_IMMEDIATELY',
976: avalue =>null);
977:

Line 978: wf_engine.SetItemAttrText (itemtype => l_itemType,

974: itemkey => l_itemKey,
975: aname => 'OPEN_IMMEDIATELY',
976: avalue =>null);
977:
978: wf_engine.SetItemAttrText (itemtype => l_itemType,
979: itemkey => l_itemKey,
980: aname => 'O_TIMEZONE',
981: avalue => l_timezone_disp);
982: end if;

Line 984: wf_engine.SetItemAttrDate (itemtype => l_itemType,

980: aname => 'O_TIMEZONE',
981: avalue => l_timezone_disp);
982: end if;
983:
984: wf_engine.SetItemAttrDate (itemtype => l_itemType,
985: itemkey => l_itemKey,
986: aname => 'AUCTION_END_DATE',
987: avalue => l_close_date_in_tz);
988:

Line 990: wf_engine.SetItemAttrText (itemtype => l_itemType,

986: aname => 'AUCTION_END_DATE',
987: avalue => l_close_date_in_tz);
988:
989:
990: wf_engine.SetItemAttrText (itemtype => l_itemType,
991: itemkey => l_itemKey,
992: aname => 'NOTE_TO_APPROVERS',
993: avalue => l_note_to_approvers);
994:

Line 1004: wf_engine.SetItemOwner(itemtype => l_itemtype,

1000: -- set notification subjects
1001: set_notification_subject(l_itemType, l_itemKey, l_msg_suffix, l_doc_number, l_orig_document_number, l_amendment_number, l_auction_title);
1002:
1003: -- Bug 4295915: Set the workflow owner
1004: wf_engine.SetItemOwner(itemtype => l_itemtype,
1005: itemkey => l_itemkey,
1006: owner => fnd_global.user_name);
1007:
1008: wf_engine.StartProcess (itemType => l_itemType,

Line 1008: wf_engine.StartProcess (itemType => l_itemType,

1004: wf_engine.SetItemOwner(itemtype => l_itemtype,
1005: itemkey => l_itemkey,
1006: owner => fnd_global.user_name);
1007:
1008: wf_engine.StartProcess (itemType => l_itemType,
1009: itemKey => l_itemKey );
1010: end loop;
1011:
1012: /* Reset to creator's language */

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

1048: l_top_process_item_key Varchar2(240);
1049: l_result Varchar2(30) := 'APPROVED';
1050: begin
1051: /* Get auction header id from the workflow */
1052: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1053: itemkey => itemkey,
1054: aname => 'AUCTION_HEADER_ID');
1055:
1056: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1056: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,

1052: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1053: itemkey => itemkey,
1054: aname => 'AUCTION_HEADER_ID');
1055:
1056: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1057: itemkey => itemkey,
1058: aname => 'APPOVER');
1059:
1060: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1060: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1056: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1057: itemkey => itemkey,
1058: aname => 'APPOVER');
1059:
1060: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1061: itemkey => itemkey,
1062: aname => 'APPOVER_ID');
1063:
1064: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1064: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,

1060: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1061: itemkey => itemkey,
1062: aname => 'APPOVER_ID');
1063:
1064: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1065: itemkey => itemkey,
1066: aname => 'APPROVER_NOTES');
1067:
1068: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,

Line 1068: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,

1064: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1065: itemkey => itemkey,
1066: aname => 'APPROVER_NOTES');
1067:
1068: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,
1069: itemkey => itemKey,
1070: aname => 'TOP_PROCESS_ITEM_KEY');
1071:
1072: wf_engine.SetItemAttrNumber (itemtype => itemtype,

Line 1072: wf_engine.SetItemAttrNumber (itemtype => itemtype,

1068: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,
1069: itemkey => itemKey,
1070: aname => 'TOP_PROCESS_ITEM_KEY');
1071:
1072: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1073: itemkey => l_top_process_item_key,
1074: aname => 'APPOVER_ID',
1075: avalue => l_user_id);
1076:

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

1073: itemkey => l_top_process_item_key,
1074: aname => 'APPOVER_ID',
1075: avalue => l_user_id);
1076:
1077: wf_engine.SetItemAttrText (itemtype => itemtype,
1078: itemkey => l_top_process_item_key,
1079: aname => 'APPOVER',
1080: avalue => l_user_name);
1081:

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

1142: l_result Varchar2(30) := 'REJECTED';
1143: begin
1144:
1145: /* Get auction header id from the workflow */
1146: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1147: itemkey => itemkey,
1148: aname => 'AUCTION_HEADER_ID');
1149:
1150: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1150: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,

1146: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1147: itemkey => itemkey,
1148: aname => 'AUCTION_HEADER_ID');
1149:
1150: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1151: itemkey => itemkey,
1152: aname => 'APPOVER');
1153:
1154: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1154: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1150: l_user_name := wf_engine.GetItemAttrText (itemtype => itemtype,
1151: itemkey => itemkey,
1152: aname => 'APPOVER');
1153:
1154: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1155: itemkey => itemkey,
1156: aname => 'APPOVER_ID');
1157:
1158: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1158: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,

1154: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1155: itemkey => itemkey,
1156: aname => 'APPOVER_ID');
1157:
1158: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1159: itemkey => itemkey,
1160: aname => 'APPROVER_NOTES');
1161:
1162: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,

Line 1162: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,

1158: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1159: itemkey => itemkey,
1160: aname => 'APPROVER_NOTES');
1161:
1162: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,
1163: itemkey => itemKey,
1164: aname => 'TOP_PROCESS_ITEM_KEY');
1165:
1166: wf_engine.SetItemAttrText (itemtype => itemtype,

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

1162: l_top_process_item_key := wf_engine.GetItemAttrText (itemtype => itemType,
1163: itemkey => itemKey,
1164: aname => 'TOP_PROCESS_ITEM_KEY');
1165:
1166: wf_engine.SetItemAttrText (itemtype => itemtype,
1167: itemkey => l_top_process_item_key,
1168: aname => 'APPOVER',
1169: avalue => l_user_name);
1170:

Line 1171: wf_engine.SetItemAttrNumber (itemtype => itemtype,

1167: itemkey => l_top_process_item_key,
1168: aname => 'APPOVER',
1169: avalue => l_user_name);
1170:
1171: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1172: itemkey => l_top_process_item_key,
1173: aname => 'APPOVER_ID',
1174: avalue => l_user_id);
1175:

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

1177: if (Is_Valid_Response(l_auction_header_id,l_user_id) = 'N') then
1178: /* Responder is not a valid approver. Ignore this response */
1179: return;
1180: end if;
1181: wf_engine.SetItemAttrText (itemtype => itemtype,
1182: itemkey => l_top_process_item_key,
1183: aname => 'NOTE_TO_BUYER_ON_REJECT',
1184: avalue => l_notes);
1185:

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

1211: l_timezone1_disp varchar2(240);
1212: l_preview_date_nspec FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1213:
1214: Begin
1215: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1216: itemkey => itemkey,
1217: aname => 'AUCTION_HEADER_ID');
1218:
1219: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1219: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1215: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1216: itemkey => itemkey,
1217: aname => 'AUCTION_HEADER_ID');
1218:
1219: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1220: itemkey => itemkey,
1221: aname => 'CREATOR_USER_ID');
1222:
1223: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1223: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1219: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1220: itemkey => itemkey,
1221: aname => 'CREATOR_USER_ID');
1222:
1223: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1224: itemkey => itemkey,
1225: aname => 'TRADING_PARTNER_CONTACT_ID');
1226:
1227:

Line 1228: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,

1224: itemkey => itemkey,
1225: aname => 'TRADING_PARTNER_CONTACT_ID');
1226:
1227:
1228: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
1229: itemkey => itemKey,
1230: aname => 'PREVIEW_DATE');
1231: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1232: itemkey => itemKey,

Line 1231: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,

1227:
1228: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
1229: itemkey => itemKey,
1230: aname => 'PREVIEW_DATE');
1231: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1232: itemkey => itemKey,
1233: aname => 'TP_TIME_ZONE1');
1234:
1235: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,

Line 1235: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,

1231: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1232: itemkey => itemKey,
1233: aname => 'TP_TIME_ZONE1');
1234:
1235: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
1236: itemkey => itemKey,
1237: aname => 'PREVIEW_DATE_NOTSPECIFIED');
1238: SELECT max(action_date)
1239: INTO l_approve_date

Line 1268: wf_engine.SetItemAttrDate (itemtype => itemType,

1264:
1265: -- Set the dates based on the user's time zone
1266: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1267:
1268: wf_engine.SetItemAttrDate (itemtype => itemType,
1269: itemkey => itemKey,
1270: aname => 'APPROVE_DATE',
1271: avalue => l_approve_date_in_tz);
1272:

Line 1273: wf_engine.SetItemAttrText (itemtype => itemType,

1269: itemkey => itemKey,
1270: aname => 'APPROVE_DATE',
1271: avalue => l_approve_date_in_tz);
1272:
1273: wf_engine.SetItemAttrText (itemtype => itemType,
1274: itemkey => itemKey,
1275: aname => 'TIMEZONE',
1276: avalue => l_timezone_disp);
1277:

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

1303: l_timezone1_disp varchar2(240);
1304: l_preview_date_nspec FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1305:
1306: Begin
1307: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1308: itemkey => itemkey,
1309: aname => 'AUCTION_HEADER_ID');
1310:
1311: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1311: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1307: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1308: itemkey => itemkey,
1309: aname => 'AUCTION_HEADER_ID');
1310:
1311: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1312: itemkey => itemkey,
1313: aname => 'CREATOR_USER_ID');
1314:
1315: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1315: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,

1311: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1312: itemkey => itemkey,
1313: aname => 'CREATOR_USER_ID');
1314:
1315: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1316: itemkey => itemkey,
1317: aname => 'NOTE_TO_BUYER_ON_REJECT');
1318:
1319: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1319: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1315: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1316: itemkey => itemkey,
1317: aname => 'NOTE_TO_BUYER_ON_REJECT');
1318:
1319: l_auction_contact_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1320: itemkey => itemkey,
1321: aname => 'TRADING_PARTNER_CONTACT_ID');
1322:
1323:

Line 1324: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,

1320: itemkey => itemkey,
1321: aname => 'TRADING_PARTNER_CONTACT_ID');
1322:
1323:
1324: l_preview_date_in_tz := wf_engine.GetItemAttrDate (itemtype => itemType,
1325: itemkey => itemKey,
1326: aname => 'PREVIEW_DATE');
1327:
1328:

Line 1329: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,

1325: itemkey => itemKey,
1326: aname => 'PREVIEW_DATE');
1327:
1328:
1329: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1330: itemkey => itemKey,
1331: aname => 'TP_TIME_ZONE1');
1332:
1333: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,

Line 1333: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,

1329: l_timezone1_disp := wf_engine.GetItemAttrText (itemtype => itemType,
1330: itemkey => itemKey,
1331: aname => 'TP_TIME_ZONE1');
1332:
1333: l_preview_date_nspec := wf_engine.GetItemAttrText (itemtype => itemType,
1334: itemkey => itemKey,
1335: aname => 'PREVIEW_DATE_NOTSPECIFIED');
1336:
1337: SELECT max(action_date)

Line 1367: wf_engine.SetItemAttrDate (itemtype => itemType,

1363:
1364: -- Set the dates based on the user's time zone
1365: l_timezone_disp := PON_AUCTION_PKG.Get_TimeZone_Description(l_timezone, l_language_code);
1366:
1367: wf_engine.SetItemAttrDate (itemtype => itemType,
1368: itemkey => itemKey,
1369: aname => 'REJECT_DATE',
1370: avalue => l_reject_date_in_tz);
1371:

Line 1372: wf_engine.SetItemAttrText (itemtype => itemType,

1368: itemkey => itemKey,
1369: aname => 'REJECT_DATE',
1370: avalue => l_reject_date_in_tz);
1371:
1372: wf_engine.SetItemAttrText (itemtype => itemType,
1373: itemkey => itemKey,
1374: aname => 'TIMEZONE',
1375: avalue => l_timezone_disp);
1376:

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

1392: l_status Varchar2(30) := 'TIMEOUT';
1393: l_user_id Number;
1394: l_rejection_note Varchar2(2000);
1395: Begin
1396: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1397: itemkey => itemkey,
1398: aname => 'AUCTION_HEADER_ID');
1399:
1400: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1400: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1396: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1397: itemkey => itemkey,
1398: aname => 'AUCTION_HEADER_ID');
1399:
1400: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1401: itemkey => itemkey,
1402: aname => 'CREATOR_USER_ID');
1403:
1404: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 1404: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,

1400: l_user_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1401: itemkey => itemkey,
1402: aname => 'CREATOR_USER_ID');
1403:
1404: l_rejection_note := wf_engine.GetItemAttrText (itemtype => itemtype,
1405: itemkey => itemkey,
1406: aname => 'NOTE_TO_BUYER_ON_REJECT');
1407:
1408: UPD_AUCTION_STATUSHISTORY(l_auction_header_id,

Line 1483: wf_engine.SetItemAttrText (itemtype => p_itemType,

1479: BEGIN
1480:
1481:
1482: if (p_amendment_number is not null and p_amendment_number > 0) then
1483: wf_engine.SetItemAttrText (itemtype => p_itemType,
1484: itemkey => p_itemKey,
1485: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
1486: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
1487:

Line 1488: wf_engine.SetItemAttrText (itemtype => p_itemType,

1484: itemkey => p_itemKey,
1485: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
1486: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REQ_SUBJECT',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
1487:
1488: wf_engine.SetItemAttrText (itemtype => p_itemType,
1489: itemkey => p_itemKey,
1490: aname => 'PON_AUC_APPR_REMINDER_SUB',
1491: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));
1492:

Line 1493: wf_engine.SetItemAttrText (itemtype => p_itemType,

1489: itemkey => p_itemKey,
1490: aname => 'PON_AUC_APPR_REMINDER_SUB',
1491: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REMINDER_SUB',p_msg_suffix,'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER', p_orig_document_number));
1492:
1493: wf_engine.SetItemAttrText (itemtype => p_itemType,
1494: itemkey => p_itemKey,
1495: aname => 'DOC_APPROVED_MAIL_SUBJECT',
1496: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_APPRD_SUBJECT',p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
1497:

Line 1498: wf_engine.SetItemAttrText (itemtype => p_itemType,

1494: itemkey => p_itemKey,
1495: aname => 'DOC_APPROVED_MAIL_SUBJECT',
1496: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_APPRD_SUBJECT',p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
1497:
1498: wf_engine.SetItemAttrText (itemtype => p_itemType,
1499: itemkey => p_itemKey,
1500: aname => 'DOC_REJECTED_MAIL_SUBJECT',
1501: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REJ_SUBJECT', p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
1502:

Line 1504: wf_engine.SetItemAttrText (itemtype => p_itemType,

1500: aname => 'DOC_REJECTED_MAIL_SUBJECT',
1501: avalue => PON_AUCTION_PKG.getMessage('PON_AMEND_APPR_REJ_SUBJECT', p_msg_suffix, 'AMENDMENT_NUMBER', p_amendment_number, 'ORIG_NUMBER',p_orig_document_number, 'AUCTION_TITLE', p_auction_title));
1502:
1503: else
1504: wf_engine.SetItemAttrText (itemtype => p_itemType,
1505: itemkey => p_itemKey,
1506: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
1507: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));
1508:

Line 1510: wf_engine.SetItemAttrText (itemtype => p_itemType,

1506: aname => 'REQUEST_FOR_APPROVALS_SUBJECT',
1507: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REQ_SUBJECT',p_msg_suffix,'DOC_NUMBER', p_doc_number, 'AUCTION_TITLE', p_auction_title));
1508:
1509:
1510: wf_engine.SetItemAttrText (itemtype => p_itemType,
1511: itemkey => p_itemKey,
1512: aname => 'PON_AUC_APPR_REMINDER_SUB',
1513: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));
1514:

Line 1516: wf_engine.SetItemAttrText (itemtype => p_itemType,

1512: aname => 'PON_AUC_APPR_REMINDER_SUB',
1513: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REMINDER_SUB',p_msg_suffix,'DOC_NUMBER', p_doc_number));
1514:
1515:
1516: wf_engine.SetItemAttrText (itemtype => p_itemType,
1517: itemkey => p_itemKey,
1518: aname => 'DOC_APPROVED_MAIL_SUBJECT',
1519: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_APPRD_SUBJECT',p_msg_suffix, 'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
1520:

Line 1521: wf_engine.SetItemAttrText (itemtype => p_itemType,

1517: itemkey => p_itemKey,
1518: aname => 'DOC_APPROVED_MAIL_SUBJECT',
1519: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_APPRD_SUBJECT',p_msg_suffix, 'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
1520:
1521: wf_engine.SetItemAttrText (itemtype => p_itemType,
1522: itemkey => p_itemKey,
1523: aname => 'DOC_REJECTED_MAIL_SUBJECT',
1524: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_APPR_REJ_SUBJECT', p_msg_suffix,'DOC_NUMBER',p_doc_number, 'AUCTION_TITLE', p_auction_title));
1525: end if;