452: FROM dual;
453:
454: l_itemkey := p_auction_header_id || '-' || l_sequence;
455:
456: wf_engine.CreateProcess(itemtype => l_itemtype,
457: itemkey => l_itemkey,
458: process => 'MNG_EVAL_TEAM_UPDATE');
459:
460:
457: itemkey => l_itemkey,
458: process => 'MNG_EVAL_TEAM_UPDATE');
459:
460:
461: wf_engine.SetItemAttrText(itemtype => l_itemtype,
462: itemkey => l_itemkey,
463: aname => 'AUCTION_ID',
464: avalue => p_auction_header_id);
465:
462: itemkey => l_itemkey,
463: aname => 'AUCTION_ID',
464: avalue => p_auction_header_id);
465:
466: wf_engine.SetItemAttrText(itemtype => l_itemtype,
467: itemkey => l_itemkey,
468: aname => 'MEMBER_USER_ID',
469: avalue => p_member_user_id);
470:
467: itemkey => l_itemkey,
468: aname => 'MEMBER_USER_ID',
469: avalue => p_member_user_id);
470:
471: wf_engine.SetItemAttrText(itemtype => l_itemtype,
472: itemkey => l_itemkey,
473: aname => 'DOC_TYPE',
474: avalue => l_doc_type);
475:
472: itemkey => l_itemkey,
473: aname => 'DOC_TYPE',
474: avalue => l_doc_type);
475:
476: wf_engine.SetItemAttrText(itemtype => l_itemtype,
477: itemkey => l_itemkey,
478: aname => 'DOC_NUMBER',
479: avalue => l_doc_number);
480:
477: itemkey => l_itemkey,
478: aname => 'DOC_NUMBER',
479: avalue => l_doc_number);
480:
481: wf_engine.SetItemAttrText(itemtype => l_itemtype,
482: itemkey => l_itemkey,
483: aname => 'AUCTION_TITLE',
484: avalue => l_auction_title);
485:
482: itemkey => l_itemkey,
483: aname => 'AUCTION_TITLE',
484: avalue => l_auction_title);
485:
486: wf_engine.SetItemAttrText(itemtype => l_itemtype,
487: itemkey => l_itemkey,
488: aname => 'PREPARER_TP_NAME',
489: avalue => l_preparer_tp_name);
490:
487: itemkey => l_itemkey,
488: aname => 'PREPARER_TP_NAME',
489: avalue => l_preparer_tp_name);
490:
491: wf_engine.SetItemAttrText(itemtype => l_itemtype,
492: itemkey => l_itemkey,
493: aname => 'ORIGIN_USER_NAME',
494: avalue => fnd_global.user_name);
495:
492: itemkey => l_itemkey,
493: aname => 'ORIGIN_USER_NAME',
494: avalue => fnd_global.user_name);
495:
496: wf_engine.SetItemAttrText(itemtype => l_itemtype,
497: itemkey => l_itemkey,
498: aname => 'RECIPIENT_ROLE',
499: avalue => l_member_user_name);
500:
497: itemkey => l_itemkey,
498: aname => 'RECIPIENT_ROLE',
499: avalue => l_member_user_name);
500:
501: wf_engine.SetItemAttrText(itemtype => l_itemtype,
502: itemkey => l_itemkey,
503: aname => 'MNG_EVAL_TEAM_UPDATE_SUBJECT',
504: avalue => l_et_update_subject);
505:
502: itemkey => l_itemkey,
503: aname => 'MNG_EVAL_TEAM_UPDATE_SUBJECT',
504: avalue => l_et_update_subject);
505:
506: wf_engine.SetItemAttrText(itemtype => l_itemtype,
507: itemkey => l_itemkey,
508: aname => 'MNG_EVAL_TEAM_UPDATE_BODY',
509: avalue => 'plsqlclob:' ||
510: 'pon_eval_team_util_pvt.' ||
511: 'gen_eval_team_update_body/' ||
512: l_itemtype || ':' ||
513: l_itemkey);
514:
515: wf_engine.SetItemAttrText(itemtype => l_itemtype,
516: itemkey => l_itemkey,
517: aname => 'NEG_SUMMARY_URL',
518: avalue => l_neg_summary_url);
519:
517: aname => 'NEG_SUMMARY_URL',
518: avalue => l_neg_summary_url);
519:
520:
521: wf_engine.SetItemOwner(itemtype => l_itemtype,
522: itemkey => l_itemkey,
523: owner => fnd_global.user_name);
524:
525: wf_engine.StartProcess(itemtype => l_itemtype,
521: wf_engine.SetItemOwner(itemtype => l_itemtype,
522: itemkey => l_itemkey,
523: owner => fnd_global.user_name);
524:
525: wf_engine.StartProcess(itemtype => l_itemtype,
526: itemkey => l_itemkey);
527:
528:
529: pon_auction_pkg.unset_session_language;
665: l_itemtype := SUBSTR(p_document_id, 1, INSTR(p_document_id, ':') - 1);
666: l_itemkey := SUBSTR(p_document_id, INSTR(p_document_id, ':') + 1,
667: LENGTH(p_document_id));
668:
669: l_auction_header_id := wf_engine.GetItemAttrText(itemtype => l_itemtype,
670: itemkey => l_itemkey,
671: aname => 'AUCTION_ID');
672:
673: l_member_user_id := wf_engine.GetItemAttrText(itemtype => l_itemtype,
669: l_auction_header_id := wf_engine.GetItemAttrText(itemtype => l_itemtype,
670: itemkey => l_itemkey,
671: aname => 'AUCTION_ID');
672:
673: l_member_user_id := wf_engine.GetItemAttrText(itemtype => l_itemtype,
674: itemkey => l_itemkey,
675: aname => 'MEMBER_USER_ID');
676:
677: l_doc_type := wf_engine.GetItemAttrText(itemtype => l_itemtype,
673: l_member_user_id := wf_engine.GetItemAttrText(itemtype => l_itemtype,
674: itemkey => l_itemkey,
675: aname => 'MEMBER_USER_ID');
676:
677: l_doc_type := wf_engine.GetItemAttrText(itemtype => l_itemtype,
678: itemkey => l_itemkey,
679: aname => 'DOC_TYPE');
680:
681: l_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemtype,
677: l_doc_type := wf_engine.GetItemAttrText(itemtype => l_itemtype,
678: itemkey => l_itemkey,
679: aname => 'DOC_TYPE');
680:
681: l_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemtype,
682: itemkey => l_itemkey,
683: aname => 'DOC_NUMBER');
684:
685: l_neg_summary_url := wf_engine.GetItemAttrText
681: l_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemtype,
682: itemkey => l_itemkey,
683: aname => 'DOC_NUMBER');
684:
685: l_neg_summary_url := wf_engine.GetItemAttrText
686: ( itemtype => l_itemtype,
687: itemkey => l_itemkey,
688: aname => 'NEG_SUMMARY_URL'
689: );
1016: FROM dual;
1017:
1018: l_itemkey := l_auction_header_id || '-' || l_sequence;
1019:
1020: wf_engine.CreateProcess(itemtype => l_itemtype,
1021: itemkey => l_itemkey,
1022: process => 'NOTIFY_SCORER_EVAL_UPDATE');
1023:
1024: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1020: wf_engine.CreateProcess(itemtype => l_itemtype,
1021: itemkey => l_itemkey,
1022: process => 'NOTIFY_SCORER_EVAL_UPDATE');
1023:
1024: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1025: itemkey => l_itemkey,
1026: aname => 'AUCTION_ID',
1027: avalue => l_auction_header_id);
1028:
1025: itemkey => l_itemkey,
1026: aname => 'AUCTION_ID',
1027: avalue => l_auction_header_id);
1028:
1029: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1030: itemkey => l_itemkey,
1031: aname => 'DOC_TYPE',
1032: avalue => l_doc_type);
1033:
1030: itemkey => l_itemkey,
1031: aname => 'DOC_TYPE',
1032: avalue => l_doc_type);
1033:
1034: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1035: itemkey => l_itemkey,
1036: aname => 'DOC_NUMBER',
1037: avalue => l_doc_number);
1038:
1035: itemkey => l_itemkey,
1036: aname => 'DOC_NUMBER',
1037: avalue => l_doc_number);
1038:
1039: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1040: itemkey => l_itemkey,
1041: aname => 'AUCTION_TITLE',
1042: avalue => l_auction_title);
1043:
1040: itemkey => l_itemkey,
1041: aname => 'AUCTION_TITLE',
1042: avalue => l_auction_title);
1043:
1044: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1045: itemkey => l_itemkey,
1046: aname => 'PREPARER_TP_NAME',
1047: avalue => l_preparer_tp_name);
1048:
1045: itemkey => l_itemkey,
1046: aname => 'PREPARER_TP_NAME',
1047: avalue => l_preparer_tp_name);
1048:
1049: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1050: itemkey => l_itemkey,
1051: aname => 'ORIGIN_USER_NAME',
1052: avalue => fnd_global.user_name);
1053:
1050: itemkey => l_itemkey,
1051: aname => 'ORIGIN_USER_NAME',
1052: avalue => fnd_global.user_name);
1053:
1054: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1055: itemkey => l_itemkey,
1056: aname => 'RECIPIENT_ROLE',
1057: avalue => l_notify_tbl(i).scorer_user_name);
1058:
1055: itemkey => l_itemkey,
1056: aname => 'RECIPIENT_ROLE',
1057: avalue => l_notify_tbl(i).scorer_user_name);
1058:
1059: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1060: itemkey => l_itemkey,
1061: aname => 'TEAM_MEMBER',
1062: avalue => l_notify_tbl(i).evaluator_name);
1063:
1060: itemkey => l_itemkey,
1061: aname => 'TEAM_MEMBER',
1062: avalue => l_notify_tbl(i).evaluator_name);
1063:
1064: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1065: itemkey => l_itemkey,
1066: aname => 'EVAL_UPDATE_SCORER_SUBJECT',
1067: avalue => l_eval_update_sub);
1068:
1065: itemkey => l_itemkey,
1066: aname => 'EVAL_UPDATE_SCORER_SUBJECT',
1067: avalue => l_eval_update_sub);
1068:
1069: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1070: itemkey => l_itemkey,
1071: aname => 'EVAL_UPDATE_SCORER_BODY',
1072: avalue => 'plsqlclob:' ||
1073: 'pon_eval_team_util_pvt.' ||
1074: 'gen_eval_update_scorer_body/' ||
1075: l_itemtype || ':' ||
1076: l_itemkey);
1077:
1078: wf_engine.SetItemAttrText(itemtype => l_itemtype,
1079: itemkey => l_itemkey,
1080: aname => 'NEG_SUMMARY_URL',
1081: avalue => l_neg_summary_url);
1082:
1080: aname => 'NEG_SUMMARY_URL',
1081: avalue => l_neg_summary_url);
1082:
1083:
1084: wf_engine.SetItemOwner(itemtype => l_itemtype,
1085: itemkey => l_itemkey,
1086: owner => fnd_global.user_name);
1087:
1088: wf_engine.StartProcess(itemtype => l_itemtype,
1084: wf_engine.SetItemOwner(itemtype => l_itemtype,
1085: itemkey => l_itemkey,
1086: owner => fnd_global.user_name);
1087:
1088: wf_engine.StartProcess(itemtype => l_itemtype,
1089: itemkey => l_itemkey);
1090:
1091:
1092: pon_auction_pkg.unset_session_language;
1130: l_itemtype := SUBSTR(p_document_id, 1, INSTR(p_document_id, ':') - 1);
1131: l_itemkey := SUBSTR(p_document_id, INSTR(p_document_id, ':') + 1,
1132: LENGTH(p_document_id));
1133:
1134: l_team_member := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1135: itemkey => l_itemkey,
1136: aname => 'TEAM_MEMBER');
1137:
1138: l_doc_type := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1134: l_team_member := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1135: itemkey => l_itemkey,
1136: aname => 'TEAM_MEMBER');
1137:
1138: l_doc_type := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1139: itemkey => l_itemkey,
1140: aname => 'DOC_TYPE');
1141:
1142: l_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1138: l_doc_type := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1139: itemkey => l_itemkey,
1140: aname => 'DOC_TYPE');
1141:
1142: l_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1143: itemkey => l_itemkey,
1144: aname => 'DOC_NUMBER');
1145:
1146: l_auction_title := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1142: l_doc_number := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1143: itemkey => l_itemkey,
1144: aname => 'DOC_NUMBER');
1145:
1146: l_auction_title := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1147: itemkey => l_itemkey,
1148: aname => 'AUCTION_TITLE');
1149:
1150: l_scorer_user_name := wf_engine.GetItemAttrText
1146: l_auction_title := wf_engine.GetItemAttrText(itemtype => l_itemtype,
1147: itemkey => l_itemkey,
1148: aname => 'AUCTION_TITLE');
1149:
1150: l_scorer_user_name := wf_engine.GetItemAttrText
1151: ( itemtype => l_itemtype,
1152: itemkey => l_itemkey,
1153: aname => 'RECIPIENT_ROLE'
1154: );
1152: itemkey => l_itemkey,
1153: aname => 'RECIPIENT_ROLE'
1154: );
1155:
1156: l_neg_summary_url := wf_engine.GetItemAttrText
1157: ( itemtype => l_itemtype,
1158: itemkey => l_itemkey,
1159: aname => 'NEG_SUMMARY_URL'
1160: );