DBA Data[Home] [Help]

APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on WF_ENGINE

Line 456: wf_engine.CreateProcess(itemtype => l_itemtype,

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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.' ||

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

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:

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

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,

Line 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;

Line 669: l_auction_header_id := wf_engine.GetItemAttrText(itemtype => l_itemtype,

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,

Line 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,

Line 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,

Line 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

Line 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: );

Line 1020: wf_engine.CreateProcess(itemtype => l_itemtype,

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,

Line 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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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.' ||

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

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:

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

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,

Line 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;

Line 1134: l_team_member := wf_engine.GetItemAttrText(itemtype => l_itemtype,

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,

Line 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,

Line 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,

Line 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

Line 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: );

Line 1156: l_neg_summary_url := wf_engine.GetItemAttrText

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: );