APPS.AML_MONITOR_WF dependencies on WF_ENGINE

Line 361: Wf_Engine.AbortProcess(itemtype => l_itemtype,

357: -- no need to stop earlier one
358: null;
359: else
360: -- abort existing process
361: Wf_Engine.AbortProcess(itemtype => l_itemtype,
362: itemkey => l_existing_itemkey) ;
363: end if;
364:
365: IF (AS_DEBUG_LOW_ON) THEN

Line 459: Wf_Engine.AbortProcess(itemtype => l_itemtype,

455: END IF;
456:
457: if l_existing_itemkey is not null then
458: -- abort existing process
459: Wf_Engine.AbortProcess(itemtype => l_itemtype,
460: itemkey => l_existing_itemkey) ;
461:
462: IF (AS_DEBUG_LOW_ON) THEN
463: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after aborting the old one:' || l_existing_itemkey);

Line 497: wf_engine.CreateProcess( ItemType => itemtype,

493: END IF;
494:
495: itemtype := AML_MONITOR_WF.g_item_type;
496:
497: wf_engine.CreateProcess( ItemType => itemtype,
498: ItemKey => itemkey,
499: process => Workflowprocess);
500:
501:

Line 502: wf_engine.SetItemUserKey( ItemType => itemtype,

498: ItemKey => itemkey,
499: process => Workflowprocess);
500:
501:
502: wf_engine.SetItemUserKey( ItemType => itemtype,
503: ItemKey => itemkey,
504: userkey => p_sales_lead_id);
505:
506:

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

512: -- Initialize workflow item attributes
513: -- l_process_rule_id, l_monitor_condition_id, l_time_lag_num, l_count
514: --
515:
516: wf_engine.SetItemAttrNumber(itemtype => itemtype,
517: itemkey => itemkey,
518: aname => 'PROCESS_RULE_ID',
519: avalue => l_process_rule_id);
520:

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

521: IF (AS_DEBUG_LOW_ON) THEN
522: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_process_rule_id:' || l_process_rule_id);
523: END IF;
524:
525: wf_engine.SetItemAttrNumber(itemtype => itemtype,
526: itemkey => itemkey,
527: aname => 'MONITOR_CONDITION_ID',
528: avalue => l_monitor_condition_id);
529:

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

527: aname => 'MONITOR_CONDITION_ID',
528: avalue => l_monitor_condition_id);
529:
530:
531: wf_engine.SetItemAttrNumber(itemtype => itemtype,
532: itemkey => itemkey,
533: aname => 'TIMELAG_NUM',
534: avalue => l_time_lag_num);
535:

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

532: itemkey => itemkey,
533: aname => 'TIMELAG_NUM',
534: avalue => l_time_lag_num);
535:
536: wf_engine.SetItemAttrNumber(itemtype => itemtype,
537: itemkey => itemkey,
538: aname => 'SALES_LEAD_ID',
539: avalue => p_sales_lead_id);
540:

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

541:
542: select to_date(to_char(sysdate,'MM/DD/YYYY HH:MI:SS AM'),'MM/DD/YYYY HH:MI:SS AM')
543: into l_monitor_launch_date from dual;
544:
545: wf_engine.SetItemAttrDate(itemtype => itemtype,
546: itemkey => itemkey,
547: aname => 'MONITOR_LAUNCH_DATE',
548: avalue => l_monitor_launch_date);
549:

Line 554: wf_engine.StartProcess(itemtype => ItemType,

550: IF (AS_DEBUG_LOW_ON) THEN
551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_time_lag_num:' || l_time_lag_num);
552: END IF;
553:
554: wf_engine.StartProcess(itemtype => ItemType,
555: itemkey => ItemKey );
556:
557: IF (AS_DEBUG_LOW_ON) THEN
558: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after start process:' );

Line 561: wf_engine.ItemStatus(itemtype => ItemType,

557: IF (AS_DEBUG_LOW_ON) THEN
558: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after start process:' );
559: END IF;
560:
561: wf_engine.ItemStatus(itemtype => ItemType,
562: itemkey => ItemKey,
563: status => l_status,
564: result => l_result);
565:

Line 808: l_monitor_condition_id := wf_engine.GetItemAttrText(

804: END IF;
805:
806: IF funcmode = 'RUN'
807: THEN
808: l_monitor_condition_id := wf_engine.GetItemAttrText(
809: itemtype => itemtype,
810: itemkey => itemkey,
811: aname => 'MONITOR_CONDITION_ID');
812:

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

812:
813: select to_date(to_char(sysdate,'MM/DD/YYYY HH:MI:SS AM'),'MM/DD/YYYY HH:MI:SS AM')
814: into l_monitor_launch_date from dual;
815:
816: wf_engine.SetItemAttrDate(itemtype => itemtype,
817: itemkey => itemkey,
818: aname => 'MONITOR_LAUNCH_DATE',
819: avalue => l_monitor_launch_date);
820:

Line 835: l_sales_lead_id := wf_engine.GetItemAttrNumber(

831:
832: IF (AS_DEBUG_LOW_ON) THEN
833: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after getting monitor details:' || l_time_lag_from_stage);
834: END IF;
835: l_sales_lead_id := wf_engine.GetItemAttrNumber(
836: itemtype => itemtype,
837: itemkey => itemkey,
838: aname => 'SALES_LEAD_ID');
839: -- Get Lead Details

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

846: IF (AS_DEBUG_LOW_ON) THEN
847: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'after getting lead details:' || l_creation_date);
848: END IF;
849:
850: wf_engine.SetItemAttrDate(itemtype => itemtype,
851: itemkey => itemkey,
852: aname => 'LEAD_CREATION_DATE',
853: avalue => l_creation_date);
854:

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

851: itemkey => itemkey,
852: aname => 'LEAD_CREATION_DATE',
853: avalue => l_creation_date);
854:
855: wf_engine.SetItemAttrDate(itemtype => itemtype,
856: itemkey => itemkey,
857: aname => 'EXPIRATION_DATE',
858: avalue => l_expiration_date);
859:

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

856: itemkey => itemkey,
857: aname => 'EXPIRATION_DATE',
858: avalue => l_expiration_date);
859:
860: wf_engine.SetItemAttrDate(itemtype => itemtype,
861: itemkey => itemkey,
862: aname => 'LEAD_UPDATED_DATE',
863: avalue => l_last_update_date);
864:

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

861: itemkey => itemkey,
862: aname => 'LEAD_UPDATED_DATE',
863: avalue => l_last_update_date);
864:
865: wf_engine.SetItemAttrDate(itemtype => itemtype,
866: itemkey => itemkey,
867: aname => 'LEAD_ASSIGNED_DATE',
868: avalue => l_assign_date);
869:

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

867: aname => 'LEAD_ASSIGNED_DATE',
868: avalue => l_assign_date);
869:
870:
871: wf_engine.SetItemAttrText(itemtype => itemtype,
872: itemkey => itemkey,
873: aname => 'LEAD_OWNER_REQD',
874: avalue => 'N');
875:

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

872: itemkey => itemkey,
873: aname => 'LEAD_OWNER_REQD',
874: avalue => 'N');
875:
876: wf_engine.SetItemAttrText(itemtype => itemtype,
877: itemkey => itemkey,
878: aname => 'LEAD_NAME',
879: avalue => l_description);
880:

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

877: itemkey => itemkey,
878: aname => 'LEAD_NAME',
879: avalue => l_description);
880:
881: wf_engine.SetItemAttrText(itemtype => itemtype,
882: itemkey => itemkey,
883: aname => 'LEAD_NUMBER',
884: avalue => l_lead_number);
885:

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

887: fetch c_get_customer_name into l_customer_name;
888: close c_get_customer_name;
889:
890:
891: wf_engine.SetItemAttrText(itemtype => itemtype,
892: itemkey => itemkey,
893: aname => 'LEAD_CUSTOMER_NAME',
894: avalue => l_customer_name);
895:

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

894: avalue => l_customer_name);
895:
896:
897:
898: wf_engine.SetItemAttrText(itemtype => itemtype,
899: itemkey => itemkey,
900: aname => 'TIMELAG_UOM_CODE',
901: avalue => l_time_lag_uom_code);
902:

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

900: aname => 'TIMELAG_UOM_CODE',
901: avalue => l_time_lag_uom_code);
902:
903:
904: wf_engine.SetItemAttrText(itemtype => itemtype,
905: itemkey => itemkey,
906: aname => 'TIMELAG_FROM_STAGE',
907: avalue => l_time_lag_from_stage);
908:

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

905: itemkey => itemkey,
906: aname => 'TIMELAG_FROM_STAGE',
907: avalue => l_time_lag_from_stage);
908:
909: wf_engine.SetItemAttrText(itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'TIMELAG_TO_STAGE',
912: avalue => l_time_lag_to_stage);
913:

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

915: fetch c_get_meaning into l_time_lag_to_stage_meaning;
916: close c_get_meaning;
917:
918:
919: wf_engine.SetItemAttrText(itemtype => itemtype,
920: itemkey => itemkey,
921: aname => 'TIMELAG_TO_STAGE_MEANING',
922: avalue => l_time_lag_to_stage_meaning);
923:

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

924: open c_get_lead_status_meaning (l_status_code);
925: fetch c_get_lead_status_meaning into l_status_code_meaning;
926: close c_get_lead_status_meaning;
927:
928: wf_engine.SetItemAttrText(itemtype => itemtype,
929: itemkey => itemkey,
930: aname => 'LEAD_STATUS_MEANING',
931: avalue => l_status_code_meaning);
932:

Line 935: l_process_rule_id := wf_engine.GetItemAttrNumber(

931: avalue => l_status_code_meaning);
932:
933:
934:
935: l_process_rule_id := wf_engine.GetItemAttrNumber(
936: itemtype => itemtype,
937: itemkey => itemkey,
938: aname => 'PROCESS_RULE_ID');
939:

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

936: itemtype => itemtype,
937: itemkey => itemkey,
938: aname => 'PROCESS_RULE_ID');
939:
940: wf_engine.SetItemAttrText(itemtype => itemtype,
941: itemkey => itemkey,
942: aname => 'EXPIRATION_RELATIVE',
943: avalue => l_expiration_relative);
944:

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

942: aname => 'EXPIRATION_RELATIVE',
943: avalue => l_expiration_relative);
944:
945:
946: wf_engine.SetItemAttrText(itemtype => itemtype,
947: itemkey => itemkey,
948: aname => 'REMINDER_DEFINED',
949: avalue => l_Reminder_defined);
950:

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

948: aname => 'REMINDER_DEFINED',
949: avalue => l_Reminder_defined);
950:
951: -- swkhanna 3/21
952: wf_engine.SetItemAttrNumber(itemtype => itemtype,
953: itemkey => itemkey,
954: aname => 'CURRENT_REMINDERS',
955: avalue => 1);
956:

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

953: itemkey => itemkey,
954: aname => 'CURRENT_REMINDERS',
955: avalue => 1);
956:
957: wf_engine.SetItemAttrNumber(itemtype => itemtype,
958: itemkey => itemkey,
959: aname => 'TOTAL_REMINDERS',
960: avalue => l_total_reminders);
961:

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

959: aname => 'TOTAL_REMINDERS',
960: avalue => l_total_reminders);
961:
962:
963: wf_engine.SetItemAttrNumber(itemtype => itemtype,
964: itemkey => itemkey,
965: aname => 'REMINDER_FREQUENCY',
966: avalue => l_reminder_frequency);
967:

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

965: aname => 'REMINDER_FREQUENCY',
966: avalue => l_reminder_frequency);
967:
968:
969: wf_engine.SetItemAttrText(itemtype => itemtype,
970: itemkey => itemkey,
971: aname => 'TIMEOUT_DEFINED',
972: avalue => l_timeout_defined);
973:

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

971: aname => 'TIMEOUT_DEFINED',
972: avalue => l_timeout_defined);
973:
974:
975: wf_engine.SetItemAttrNumber(itemtype => itemtype,
976: itemkey => itemkey,
977: aname => 'TIMEOUT_DURATION',
978: avalue => l_timeout_duration);
979:

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

976: itemkey => itemkey,
977: aname => 'TIMEOUT_DURATION',
978: avalue => l_timeout_duration);
979:
980: wf_engine.SetItemAttrText(itemtype => itemtype,
981: itemkey => itemkey,
982: aname => 'TIMEOUT_UOM_CODE',
983: avalue => l_timeout_uom_code);
984:

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

989:
990: if l_current_Reroutes is null then
991: l_current_reroutes := 0;
992: end if;
993: wf_engine.SetItemAttrNumber(itemtype => itemtype,
994: itemkey => itemkey,
995: aname => 'TIMEOUT_CURR_REROUTES',
996: avalue => l_current_reroutes);
997:

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

994: itemkey => itemkey,
995: aname => 'TIMEOUT_CURR_REROUTES',
996: avalue => l_current_reroutes);
997:
998: wf_engine.SetItemAttrText(itemtype => itemtype,
999: itemkey => itemkey,
1000: aname => 'NOTIFY_LEAD_OWNER',
1001: avalue => l_notify_owner);
1002:

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

1000: aname => 'NOTIFY_LEAD_OWNER',
1001: avalue => l_notify_owner);
1002:
1003:
1004: wf_engine.SetItemAttrText(itemtype => itemtype,
1005: itemkey => itemkey,
1006: aname => 'NOTIFY_LD_OWNR_MANAGER',
1007: avalue => l_notify_manager);
1008:

Line 1017: /* wf_engine.SetItemAttrText(itemtype => itemtype,

1013:
1014:
1015:
1016:
1017: /* wf_engine.SetItemAttrText(itemtype => itemtype,
1018: itemkey => itemkey,
1019: aname => 'LEAD_OWNER',
1020: avalue => l_lead_owner_fullname);*/
1021:

Line 1033: /* wf_engine.SetItemAttrNumber(itemtype => itemtype,

1029: l_notify_role_list := l_notify_role_list||','||l_lead_owner_username;
1030: end if;
1031:
1032:
1033: /* wf_engine.SetItemAttrNumber(itemtype => itemtype,
1034: itemkey => itemkey,
1035: aname => 'LEAD_OWNER_RESOURCE_ID',
1036: avalue => l_resource_id);
1037:

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

1034: itemkey => itemkey,
1035: aname => 'LEAD_OWNER_RESOURCE_ID',
1036: avalue => l_resource_id);
1037:
1038: wf_engine.SetItemAttrText(itemtype => itemtype,
1039: itemkey => itemkey,
1040: aname => 'LEAD_OWNER_USERNAME',
1041: avalue => l_lead_owner_username);*/
1042:

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

1057: close c_get_mgr_username;
1058: /*
1059: if l_mgr_resource_id is not null and l_mgr_resource_id <> 0 then
1060:
1061: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1062: itemkey => itemkey,
1063: aname => 'LEAD_OWNER_MGR_RESOURCE_ID',
1064: avalue => l_mgr_resource_id);
1065:

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

1063: aname => 'LEAD_OWNER_MGR_RESOURCE_ID',
1064: avalue => l_mgr_resource_id);
1065:
1066:
1067: wf_engine.SetItemAttrText(itemtype => itemtype,
1068: itemkey => itemkey,
1069: aname => 'LEAD_OWNER_MGR_USERNAME',
1070: avalue => l_manager_username);
1071:

Line 1118: wf_engine.SetItemAttrText ( ItemType => itemType,

1114: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1115: 'After createAdHocRole :');
1116: END IF;
1117:
1118: wf_engine.SetItemAttrText ( ItemType => itemType,
1119: ItemKey => itemKey,
1120: aname => 'NOTIFY_ROLE',
1121: avalue => l_notify_role);
1122:

Line 1191: l_lead_owner_reqd := wf_engine.GetItemAttrText(

1187: END IF;
1188:
1189: IF funcmode = 'RUN'
1190: THEN
1191: l_lead_owner_reqd := wf_engine.GetItemAttrText(
1192: itemtype => itemtype,
1193: itemkey => itemkey,
1194: aname => 'LEAD_OWNER_REQD');
1195:

Line 1260: l_timeout_defined := wf_engine.GetItemAttrText(

1256: IF funcmode = 'RUN'
1257: THEN
1258:
1259: -- Get item attributes -
1260: l_timeout_defined := wf_engine.GetItemAttrText(
1261: itemtype => itemtype,
1262: itemkey => itemkey,
1263: aname => 'TIMEOUT_DEFINED');
1264:

Line 1338: l_timelag_number := wf_engine.GetItemAttrNumber(

1334: 'SET_NOTIFY_ATTRIBUTES: Start');
1335: END IF;
1336:
1337:
1338: l_timelag_number := wf_engine.GetItemAttrNumber(
1339: itemtype => itemtype,
1340: itemkey => itemkey,
1341: aname => 'TIMELAG_NUM');
1342:

Line 1348: l_monitor_launch_date := wf_engine.GetItemAttrDate(

1344: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1345: ' l_timelag_number: '||l_timelag_number);
1346: END IF;
1347:
1348: l_monitor_launch_date := wf_engine.GetItemAttrDate(
1349: itemtype => itemtype,
1350: itemkey => itemkey,
1351: aname => 'MONITOR_LAUNCH_DATE');
1352:

Line 1358: l_relative_to_expiration:= wf_engine.GetItemAttrText(

1354: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1355: ' l_monitor_launch_date: '||l_monitor_launch_date);
1356: END IF;
1357:
1358: l_relative_to_expiration:= wf_engine.GetItemAttrText(
1359: itemtype => itemtype,
1360: itemkey => itemkey,
1361: aname => 'EXPIRATION_RELATIVE');
1362:

Line 1372: l_expiration_date:= wf_engine.GetItemAttrDate(

1368: if l_relative_to_expiration is null then
1369: l_relative_to_expiration := 'N' ;
1370: end if;
1371:
1372: l_expiration_date:= wf_engine.GetItemAttrDate(
1373: itemtype => itemtype,
1374: itemkey => itemkey,
1375: aname => 'EXPIRATION_DATE');
1376:

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

1412:
1413: end if;
1414:
1415:
1416: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1417: itemkey => itemkey,
1418: aname => 'TIMELAG_MINUTES',
1419: avalue => l_timelag_minutes);
1420:

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

1417: itemkey => itemkey,
1418: aname => 'TIMELAG_MINUTES',
1419: avalue => l_timelag_minutes);
1420:
1421: wf_engine.SetItemAttrDate(itemtype => itemtype,
1422: itemkey => itemkey,
1423: aname => 'TIMELAG_DUE_DATE',
1424: avalue => l_timelag_due_date);
1425:

Line 1441: l_timelag_minutes := wf_engine.GetItemAttrNumber(

1437: IF (AS_DEBUG_LOW_ON) THEN
1438: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1439: 'Result:' || l_resultout);
1440: END IF;
1441: l_timelag_minutes := wf_engine.GetItemAttrNumber(
1442: itemtype => itemtype,
1443: itemkey => itemkey,
1444: aname => 'TIMELAG_MINUTES');
1445:

Line 1505: l_monitor_condition_id:= wf_engine.GetItemAttrNumber(

1501: IF funcmode = 'RUN'
1502: THEN
1503:
1504:
1505: l_monitor_condition_id:= wf_engine.GetItemAttrNumber(
1506: itemtype => itemtype,
1507: itemkey => itemkey,
1508: aname => 'MONITOR_CONDITION_ID');
1509:

Line 1510: l_sales_lead_id:= wf_engine.GetItemAttrNumber(

1506: itemtype => itemtype,
1507: itemkey => itemkey,
1508: aname => 'MONITOR_CONDITION_ID');
1509:
1510: l_sales_lead_id:= wf_engine.GetItemAttrNumber(
1511: itemtype => itemtype,
1512: itemkey => itemkey,
1513: aname => 'SALES_LEAD_ID');
1514:

Line 1516: l_monitor_action:= wf_engine.GetActivityAttrText(itemtype => itemtype,

1512: itemkey => itemkey,
1513: aname => 'SALES_LEAD_ID');
1514:
1515:
1516: l_monitor_action:= wf_engine.GetActivityAttrText(itemtype => itemtype,
1517: itemkey => itemkey,
1518: actid => actid,
1519: aname => 'MONITOR_ACTION');
1520:

Line 1522: l_monitor_action:= wf_engine.GetItemAttrText(

1518: actid => actid,
1519: aname => 'MONITOR_ACTION');
1520:
1521: /*
1522: l_monitor_action:= wf_engine.GetItemAttrText(
1523: itemtype => itemtype,
1524: itemkey => itemkey,
1525: aname => 'MONITOR_ACTION');
1526: */

Line 1530: l_notify_owner:= wf_engine.GetItemAttrText(

1526: */
1527: -- l_monitor_action := 'NOTIFICATION';
1528:
1529:
1530: l_notify_owner:= wf_engine.GetItemAttrText(
1531: itemtype => itemtype,
1532: itemkey => itemkey,
1533: aname => 'NOTIFY_LEAD_OWNER');
1534:

Line 1535: l_lead_owner_resource_id:= wf_engine.GetItemAttrNumber(

1531: itemtype => itemtype,
1532: itemkey => itemkey,
1533: aname => 'NOTIFY_LEAD_OWNER');
1534:
1535: l_lead_owner_resource_id:= wf_engine.GetItemAttrNumber(
1536: itemtype => itemtype,
1537: itemkey => itemkey,
1538: aname => 'LEAD_OWNER_RESOURCE_ID');
1539:

Line 1541: l_notify_owner_manager:= wf_engine.GetItemAttrText(

1537: itemkey => itemkey,
1538: aname => 'LEAD_OWNER_RESOURCE_ID');
1539:
1540:
1541: l_notify_owner_manager:= wf_engine.GetItemAttrText(
1542: itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'NOTIFY_LD_OWNR_MANAGER');
1545:

Line 1546: l_lead_owner_mgr_resource_id:= wf_engine.GetItemAttrNumber(

1542: itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'NOTIFY_LD_OWNR_MANAGER');
1545:
1546: l_lead_owner_mgr_resource_id:= wf_engine.GetItemAttrNumber(
1547: itemtype => itemtype,
1548: itemkey => itemkey,
1549: aname => 'LEAD_OWNER_MGR_RESOURCE_ID');
1550:

Line 1693: l_reminder_defined := wf_engine.GetItemAttrText(

1689:
1690: IF funcmode = 'RUN'
1691: THEN
1692: -- Get item attributes -
1693: l_reminder_defined := wf_engine.GetItemAttrText(
1694: itemtype => itemtype,
1695: itemkey => itemkey,
1696: aname => 'REMINDER_DEFINED');
1697:

Line 1700: l_timeout_defined := wf_engine.GetItemAttrText(

1696: aname => 'REMINDER_DEFINED');
1697:
1698:
1699:
1700: l_timeout_defined := wf_engine.GetItemAttrText(
1701: itemtype => itemtype,
1702: itemkey => itemkey,
1703: aname => 'TIMEOUT_DEFINED');
1704:

Line 1708: l_total_reminders := wf_engine.GetItemAttrText(

1704:
1705:
1706: if l_reminder_defined = 'Y' then
1707:
1708: l_total_reminders := wf_engine.GetItemAttrText(
1709: itemtype => itemtype,
1710: itemkey => itemkey,
1711: aname => 'TOTAL_REMINDERS');
1712:

Line 1713: l_current_reminders := wf_engine.GetItemAttrText(

1709: itemtype => itemtype,
1710: itemkey => itemkey,
1711: aname => 'TOTAL_REMINDERS');
1712:
1713: l_current_reminders := wf_engine.GetItemAttrText(
1714: itemtype => itemtype,
1715: itemkey => itemkey,
1716: aname => 'CURRENT_REMINDERS');
1717: end if;

Line 1784: l_timelag_number := wf_engine.GetItemAttrNumber(

1780:
1781: IF funcmode = 'RUN'
1782: THEN
1783:
1784: l_timelag_number := wf_engine.GetItemAttrNumber(
1785: itemtype => itemtype,
1786: itemkey => itemkey,
1787: aname => 'TIMELAG_NUM');
1788:

Line 1794: l_current_reminder := wf_engine.GetItemAttrNumber(

1790: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1791: 'l_timelag_number:' || l_timelag_number);
1792: END IF;
1793:
1794: l_current_reminder := wf_engine.GetItemAttrNumber(
1795: itemtype => itemtype,
1796: itemkey => itemkey,
1797: aname => 'CURRENT_REMINDERS');
1798:

Line 1804: l_reminder_frequency := wf_engine.GetItemAttrNumber(

1800: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1801: 'l_current_reminder:' || l_current_reminder);
1802: END IF;
1803:
1804: l_reminder_frequency := wf_engine.GetItemAttrNumber(
1805: itemtype => itemtype,
1806: itemkey => itemkey,
1807: aname => 'REMINDER_FREQUENCY');
1808:

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

1826: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1827: 'l_reminder:' || l_reminder_timelag_minutes);
1828: END IF;
1829:
1830: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1831: itemkey => itemkey,
1832: aname => 'REMINDER_TIMELAG_MINUTES',
1833: avalue => l_reminder_timelag_minutes);
1834:

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

1832: aname => 'REMINDER_TIMELAG_MINUTES',
1833: avalue => l_reminder_timelag_minutes);
1834:
1835:
1836: wf_engine.SetItemAttrText(itemtype => itemtype,
1837: itemkey => itemkey,
1838: aname => 'MONITOR_ACTION',
1839: avalue => 'REMINDER');
1840:

Line 1900: l_current_reminder := wf_engine.GetItemAttrNumber(

1896: THEN
1897:
1898:
1899:
1900: l_current_reminder := wf_engine.GetItemAttrNumber(
1901: itemtype => itemtype,
1902: itemkey => itemkey,
1903: aname => 'CURRENT_REMINDERS');
1904:

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

1903: aname => 'CURRENT_REMINDERS');
1904:
1905: l_current_reminder := l_current_reminder + 1;
1906:
1907: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1908: itemkey => itemkey,
1909: aname => 'CURRENT_REMINDERS',
1910: avalue => l_current_reminder);
1911:

Line 1969: l_current_reroutes := wf_engine.GetItemAttrNumber(

1965: THEN
1966:
1967:
1968:
1969: l_current_reroutes := wf_engine.GetItemAttrNumber(
1970: itemtype => itemtype,
1971: itemkey => itemkey,
1972: aname => 'TIMEOUT_CURR_REROUTES');
1973:

Line 1974: l_sales_lead_id := wf_engine.GetItemAttrNumber(

1970: itemtype => itemtype,
1971: itemkey => itemkey,
1972: aname => 'TIMEOUT_CURR_REROUTES');
1973:
1974: l_sales_lead_id := wf_engine.GetItemAttrNumber(
1975: itemtype => itemtype,
1976: itemkey => itemkey,
1977: aname => 'SALES_LEAD_ID');
1978:

Line 2051: l_timeout_duration := wf_engine.GetItemAttrNumber(

2047:
2048: IF funcmode = 'RUN'
2049: THEN
2050:
2051: l_timeout_duration := wf_engine.GetItemAttrNumber(
2052: itemtype => itemtype,
2053: itemkey => itemkey,
2054: aname => 'TIMEOUT_DURATION');
2055:

Line 2061: l_monitor_launch_date := wf_engine.GetItemAttrDate(

2057: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2058: 'l_timeout_duration:' || l_timeout_duration);
2059: END IF;
2060:
2061: l_monitor_launch_date := wf_engine.GetItemAttrDate(
2062: itemtype => itemtype,
2063: itemkey => itemkey,
2064: aname => 'MONITOR_LAUNCH_DATE');
2065:

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

2078: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2079: ' l_timeout_duration_minutes:' || l_timeout_duration_minutes);
2080: END IF;
2081:
2082: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2083: itemkey => itemkey,
2084: aname => 'TIMEOUT_DURATION_MINUTES',
2085: avalue => l_timeout_duration_minutes);
2086:

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

2083: itemkey => itemkey,
2084: aname => 'TIMEOUT_DURATION_MINUTES',
2085: avalue => l_timeout_duration_minutes);
2086:
2087: wf_engine.SetItemAttrDate(itemtype => itemtype,
2088: itemkey => itemkey,
2089: aname => 'TIMEOUT_DUE_DATE',
2090: avalue => l_timeout_due_date);
2091:

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

2089: aname => 'TIMEOUT_DUE_DATE',
2090: avalue => l_timeout_due_date);
2091:
2092:
2093: wf_engine.SetItemAttrText(itemtype => itemtype,
2094: itemkey => itemkey,
2095: aname => 'MONITOR_ACTION',
2096: avalue => 'TIMEOUT');
2097:

Line 2160: l_curr_reroutes := wf_engine.GetItemAttrNumber(

2156:
2157: IF funcmode = 'RUN'
2158: THEN
2159: -- Get item attributes -
2160: l_curr_reroutes := wf_engine.GetItemAttrNumber(
2161: itemtype => itemtype,
2162: itemkey => itemkey,
2163: aname => 'TIMEOUT_CURR_REROUTES');
2164:

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

2174: CLOSE c_esc_username;
2175:
2176: if l_esc_username is not null then
2177:
2178: wf_engine.SetItemAttrText(itemtype => itemtype,
2179: itemkey => itemkey,
2180: aname => 'ESCALATION_MGR_USERNAME',
2181: avalue => l_esc_username);
2182:

Line 2276: l_timelag_to_stage := wf_engine.GetItemAttrText(

2272:
2273: IF funcmode = 'RUN'
2274: THEN
2275: -- Get item attributes -
2276: l_timelag_to_stage := wf_engine.GetItemAttrText(
2277: itemtype => itemtype,
2278: itemkey => itemkey,
2279: aname => 'TIMELAG_TO_STAGE');
2280:

Line 2282: l_sales_lead_id := wf_engine.GetItemAttrNumber(

2278: itemkey => itemkey,
2279: aname => 'TIMELAG_TO_STAGE');
2280:
2281:
2282: l_sales_lead_id := wf_engine.GetItemAttrNumber(
2283: itemtype => itemtype,
2284: itemkey => itemkey,
2285: aname => 'SALES_LEAD_ID');
2286:

Line 2287: l_relative_to_expiration:= wf_engine.GetItemAttrText(

2283: itemtype => itemtype,
2284: itemkey => itemkey,
2285: aname => 'SALES_LEAD_ID');
2286:
2287: l_relative_to_expiration:= wf_engine.GetItemAttrText(
2288: itemtype => itemtype,
2289: itemkey => itemkey,
2290: aname => 'EXPIRATION_RELATIVE');
2291:

Line 2296: l_expiration_date:= wf_engine.GetItemAttrDate(

2292: if l_relative_to_expiration is null then
2293: l_relative_to_expiration := 'N' ;
2294: end if;
2295:
2296: l_expiration_date:= wf_engine.GetItemAttrDate(
2297: itemtype => itemtype,
2298: itemkey => itemkey,
2299: aname => 'EXPIRATION_DATE');
2300:

Line 2343: l_orig_last_update_date := wf_engine.GetItemAttrDate(

2339: -- bugfix# 2808633. Need to get date by calling GetItemAttrDate.
2340:
2341: elsif l_timelag_to_stage = 'LAST_UPDATE_DATE' then
2342: -- chk to see if lead has been updated since the workflow started
2343: l_orig_last_update_date := wf_engine.GetItemAttrDate(
2344: itemtype => itemtype,
2345: itemkey => itemkey,
2346: aname => 'LEAD_UPDATED_DATE');
2347:

Line 2471: l_orig_last_update_date := wf_engine.GetItemAttrText(

2467: end if;
2468:
2469: elsif l_timelag_to_stage = 'LAST_UPDATE_DATE' then
2470: -- chk to see if lead has been updated since the workflow started
2471: l_orig_last_update_date := wf_engine.GetItemAttrText(
2472: itemtype => itemtype,
2473: itemkey => itemkey,
2474: aname => 'LEAD_UPDATED_DATE');
2475:

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

2490:
2491: end if; -- l_is_timelag_lead_status = 'Y'/'N'
2492:
2493: if l_condition_true = 'Y' then
2494: wf_engine.SetItemAttrText(itemtype => itemtype,
2495: itemkey => itemkey,
2496: aname => 'MONITOR_ACTION',
2497: avalue => 'NOTIFICATION');
2498: end if;

Line 2662: wf_engine.SetItemAttrNumber (

2658: */
2659:
2660: END IF; -- resource id from profile check
2661:
2662: wf_engine.SetItemAttrNumber (
2663: itemtype => itemtype,
2664: itemkey => itemkey,
2665: aname => 'RESOURCE_ID',
2666: avalue => l_rs_id);

Line 2668: wf_engine.SetItemAttrNumber (

2664: itemkey => itemkey,
2665: aname => 'RESOURCE_ID',
2666: avalue => l_rs_id);
2667:
2668: wf_engine.SetItemAttrNumber (
2669: itemtype => itemtype,
2670: itemkey => itemkey,
2671: aname => 'GROUP_ID',
2672: avalue => l_group_id);

Line 2674: wf_engine.SetItemAttrNumber (

2670: itemkey => itemkey,
2671: aname => 'GROUP_ID',
2672: avalue => l_group_id);
2673:
2674: wf_engine.SetItemAttrNumber (
2675: itemtype => itemtype,
2676: itemkey => itemkey,
2677: aname => 'PERSON_ID',
2678: avalue => l_person_id);

Line 2680: wf_engine.SetItemAttrText (

2676: itemkey => itemkey,
2677: aname => 'PERSON_ID',
2678: avalue => l_person_id);
2679:
2680: wf_engine.SetItemAttrText (
2681: itemtype => itemtype,
2682: itemkey => itemkey,
2683: aname => 'DEFAULT_RESOURCE_SET',
2684: avalue => 'Y');

Line 2739: l_timelag_from_stage := wf_engine.GetItemAttrText(

2735: IF funcmode = 'RUN'
2736: THEN
2737: -- 3/17/03 swkhanna
2738: -- Chk if this is Creation_date monitor, then don't restart
2739: l_timelag_from_stage := wf_engine.GetItemAttrText(
2740: itemtype => itemtype,
2741: itemkey => itemkey,
2742: aname => 'TIMELAG_FROM_STAGE' );
2743: if l_timelag_from_stage = 'CREATION_DATE' then

Line 2747: l_default_resource_set := wf_engine.GetItemAttrText(

2743: if l_timelag_from_stage = 'CREATION_DATE' then
2744: l_resultout := 'COMPLETE:N';
2745:
2746: else
2747: l_default_resource_set := wf_engine.GetItemAttrText(
2748: itemtype => itemtype,
2749: itemkey => itemkey,
2750: aname => 'DEFAULT_RESOURCE_SET' );
2751:

Line 2886: l_sales_lead_id := wf_engine.GetItemAttrText(

2882: -- ******************************************************************
2883: -- Get Lead Country and Rank
2884: -- ******************************************************************
2885:
2886: l_sales_lead_id := wf_engine.GetItemAttrText(
2887: itemtype => itemtype,
2888: itemkey => itemkey,
2889: aname => 'SALES_LEAD_ID' );
2890:

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

2932: -- Initialize workflow item attributes
2933: -- l_process_rule_id, l_monitor_condition_id, l_time_lag_num, l_count
2934: --
2935:
2936: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2937: itemkey => itemkey,
2938: aname => 'PROCESS_RULE_ID',
2939: avalue => l_process_rule_id);
2940:

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

2941: IF (AS_DEBUG_LOW_ON) THEN
2942: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_process_rule_id:' || l_process_rule_id);
2943: END IF;
2944:
2945: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2946: itemkey => itemkey,
2947: aname => 'MONITOR_CONDITION_ID',
2948: avalue => l_monitor_condition_id);
2949:

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

2947: aname => 'MONITOR_CONDITION_ID',
2948: avalue => l_monitor_condition_id);
2949:
2950:
2951: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2952: itemkey => itemkey,
2953: aname => 'TIMELAG_NUM',
2954: avalue => l_time_lag_num);
2955:

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

2952: itemkey => itemkey,
2953: aname => 'TIMELAG_NUM',
2954: avalue => l_time_lag_num);
2955:
2956: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2957: itemkey => itemkey,
2958: aname => 'SALES_LEAD_ID',
2959: avalue => l_sales_lead_id);
2960:

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

2961:
2962: select to_date(to_char(sysdate,'MM/DD/YYYY HH:MI:SS AM'),'MM/DD/YYYY HH:MI:SS AM')
2963: into l_monitor_launch_date from dual;
2964:
2965: wf_engine.SetItemAttrDate(itemtype => itemtype,
2966: itemkey => itemkey,
2967: aname => 'MONITOR_LAUNCH_DATE',
2968: avalue => l_monitor_launch_date);
2969:

Line 2971: l_reminder_defined := wf_engine.GetItemAttrText(

2967: aname => 'MONITOR_LAUNCH_DATE',
2968: avalue => l_monitor_launch_date);
2969:
2970: -- SOLIN, 02/25/2003, bug 2801660
2971: l_reminder_defined := wf_engine.GetItemAttrText(
2972: itemtype => itemtype,
2973: itemkey => itemkey,
2974: aname => 'REMINDER_DEFINED');
2975: /* 3/24/03 swkhanna commented out

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

2974: aname => 'REMINDER_DEFINED');
2975: /* 3/24/03 swkhanna commented out
2976: IF l_reminder_defined = 'Y'
2977: THEN
2978: wf_engine.SetItemAttrNumber(itemtype => itemtype,
2979: itemkey => itemkey,
2980: aname => 'CURRENT_REMINDERS',
2981: avalue => 1);
2982: END IF;

Line 3157: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,

3153: END IF;
3154:
3155:
3156:
3157: wf_engine.SetItemAttrNumber( itemtype => p_itemtype,
3158: itemkey => p_itemkey,
3159: aname => pv_workflow_pub.g_wf_attr_matched_timeout,
3160: avalue => l_timeout*60*24);
3161:

Line 3162: wf_engine.SetItemAttrText( itemtype => p_itemtype,

3158: itemkey => p_itemkey,
3159: aname => pv_workflow_pub.g_wf_attr_matched_timeout,
3160: avalue => l_timeout*60*24);
3161:
3162: wf_engine.SetItemAttrText( itemtype => p_itemtype,
3163: itemkey => p_itemkey,
3164: aname => pv_workflow_pub.g_wf_attr_matched_timeout_dt,
3165: avalue => l_matched_GMT_time);*/
3166: end set_timelag;

Line 3248: l_sales_lead_id := wf_engine.GetItemAttrNumber(

3244: where resource_id = c_resource_id;
3245:
3246: Begin
3247:
3248: l_sales_lead_id := wf_engine.GetItemAttrNumber(
3249: itemtype => itemtype,
3250: itemkey => itemkey,
3251: aname => 'SALES_LEAD_ID');
3252:

Line 3254: l_notify_owner := wf_engine.GetItemAttrText

3250: itemkey => itemkey,
3251: aname => 'SALES_LEAD_ID');
3252:
3253:
3254: l_notify_owner := wf_engine.GetItemAttrText
3255: (itemtype => itemtype,
3256: itemkey => itemkey,
3257: aname => 'NOTIFY_LEAD_OWNER');
3258:

Line 3260: l_notify_manager := wf_engine.GetItemAttrText(itemtype => itemtype,

3256: itemkey => itemkey,
3257: aname => 'NOTIFY_LEAD_OWNER');
3258:
3259:
3260: l_notify_manager := wf_engine.GetItemAttrText(itemtype => itemtype,
3261: itemkey => itemkey,
3262: aname => 'NOTIFY_LD_OWNR_MANAGER');
3263:
3264: IF (AS_DEBUG_LOW_ON) THEN

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

3275: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'l_group_id :' || l_group_id);
3276: END IF;
3277:
3278:
3279: wf_engine.SetItemAttrText(itemtype => itemtype,
3280: itemkey => itemkey,
3281: aname => 'NOTIFY_LEAD_OWNER',
3282: avalue => l_notify_owner);
3283:

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

3281: aname => 'NOTIFY_LEAD_OWNER',
3282: avalue => l_notify_owner);
3283:
3284:
3285: wf_engine.SetItemAttrText(itemtype => itemtype,
3286: itemkey => itemkey,
3287: aname => 'NOTIFY_LD_OWNR_MANAGER',
3288: avalue => l_notify_manager);
3289:

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

3291: FETCH c_lead_owner_fullname into l_lead_owner_fullname;
3292: CLOSE c_lead_owner_fullname;
3293:
3294:
3295: wf_engine.SetItemAttrText(itemtype => itemtype,
3296: itemkey => itemkey,
3297: aname => 'LEAD_OWNER',
3298: avalue => l_lead_owner_fullname);
3299:

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

3315:
3316: if l_lead_owner_username is not null then
3317: l_notify_role_list := l_notify_role_list||','||l_lead_owner_username;
3318:
3319: wf_engine.SetItemAttrText(itemtype => itemtype,
3320: itemkey => itemkey,
3321: aname => 'LEAD_OWNER_USERNAME',
3322: avalue => l_lead_owner_username);
3323:

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

3344:
3345:
3346: l_notify_role_list := l_notify_role_list||','||l_own_name;
3347:
3348: wf_engine.SetItemAttrText(itemtype => itemtype,
3349: itemkey => itemkey,
3350: aname => 'LEAD_OWNER_USERNAME',
3351: avalue => l_own_name);
3352:

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

3370:
3371: end if; -- if notify_owner
3372:
3373:
3374: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3375: itemkey => itemkey,
3376: aname => 'LEAD_OWNER_RESOURCE_ID',
3377: avalue => l_resource_id);
3378:

Line 3379: /* wf_engine.SetItemAttrText(itemtype => itemtype,

3375: itemkey => itemkey,
3376: aname => 'LEAD_OWNER_RESOURCE_ID',
3377: avalue => l_resource_id);
3378:
3379: /* wf_engine.SetItemAttrText(itemtype => itemtype,
3380: itemkey => itemkey,
3381: aname => 'LEAD_OWNER_USERNAME',
3382: --avalue => l_lead_owner_username);
3383: avalue => l_own_name);

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

3401: else
3402: null;
3403: end if;
3404:
3405: wf_engine.SetItemAttrText(itemtype => itemtype,
3406: itemkey => itemkey,
3407: aname => 'LEAD_OWNER_MGR_USERNAME',
3408: avalue => l_manager_username);
3409:

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

3434: else
3435: null;
3436: end if;
3437:
3438: wf_engine.SetItemAttrText(itemtype => itemtype,
3439: itemkey => itemkey,
3440: aname => 'LEAD_OWNER_MGR_USERNAME',
3441: avalue => l_mgr_name);
3442:

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

3446: close c_get_mgr_username;
3447:
3448: if l_mgr_resource_id is not null and l_mgr_resource_id <> 0 then
3449:
3450: wf_engine.SetItemAttrNumber(itemtype => itemtype,
3451: itemkey => itemkey,
3452: aname => 'LEAD_OWNER_MGR_RESOURCE_ID',
3453: avalue => l_mgr_resource_id);
3454:

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

3452: aname => 'LEAD_OWNER_MGR_RESOURCE_ID',
3453: avalue => l_mgr_resource_id);
3454:
3455: /*
3456: wf_engine.SetItemAttrText(itemtype => itemtype,
3457: itemkey => itemkey,
3458: aname => 'LEAD_OWNER_MGR_USERNAME',
3459: --avalue => l_manager_username);
3460: avalue => l_mgr_name);

Line 3491: wf_engine.SetItemAttrText ( ItemType => itemType,

3487: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'After calling adduserstoadhocrole :');
3488: END IF;
3489:
3490:
3491: wf_engine.SetItemAttrText ( ItemType => itemType,
3492: ItemKey => itemKey,
3493: aname => 'NOTIFY_ROLE',
3494: avalue => l_notify_role);
3495: