[Home] [Help]
237:
238:
239: BEGIN
240: IF (funmode = 'RUN') THEN
241: l_event_name := WF_ENGINE.GetItemAttrText(
242: itemtype => itemtype,
243: itemkey => itemkey,
244: aname => 'EVENTNAME' );
245:
242: itemtype => itemtype,
243: itemkey => itemkey,
244: aname => 'EVENTNAME' );
245:
246: l_request_number := WF_ENGINE.GetItemAttrText(
247: itemtype => itemtype,
248: itemkey => itemkey,
249: aname => 'REQUEST_NUMBER' );
250:
247: itemtype => itemtype,
248: itemkey => itemkey,
249: aname => 'REQUEST_NUMBER' );
250:
251: l_wf_manual_launch := WF_ENGINE.GetItemAttrText(
252: itemtype => itemtype,
253: itemkey => itemkey,
254: aname => 'MANUAL_LAUNCH' );
255:
258: */
259: IF(l_event_name = 'oracle.apps.cs.sr.ServiceRequest.relationshipcreated' OR
260: l_event_name = 'oracle.apps.cs.sr.ServiceRequest.relationshipdeleted') THEN
261:
262: l_subject_type := WF_ENGINE.GetItemAttrText(
263: itemtype => itemtype,
264: itemkey => itemkey,
265: aname => 'LINK_SUBJECT_TYPE' );
266:
309: -- Knowledge Base says they are passing OBJECT_ID (incident_id) instead of number, so
310: -- make sure both are instantiated here.
311: IF (l_request_number IS NULL) THEN
312:
313: l_request_id := WF_ENGINE.GetItemAttrNumber(
314: itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'OBJECT_ID' );
317:
324: IF sel_incident_number_csr%ISOPEN THEN
325: CLOSE sel_incident_number_csr;
326: END IF;
327:
328: WF_ENGINE.SetItemAttrText(
329: itemtype => 'SERVEREQ',
330: itemkey => itemkey,
331: aname => 'REQUEST_NUMBER',
332: avalue => l_request_number);
367: If the query results exceeded the max allowable WF text length, then we
368: set an attribute to indicate that we need to re-query again to obtain
369: the remainder of the results which were not put in the initial list.
370: **********/
371: WF_ENGINE.SetItemAttrText(
372: itemtype => itemtype,
373: itemkey => itemkey,
374: aname => 'MORE_NTFY_ACTION_LIST',
375: avalue => 'Y' );
395: l_update_actions_list := l_update_actions_list || ' ' || sel_action_rec.action_code;
396: END IF;
397:
398: ELSE
399: WF_ENGINE.SetItemAttrText(
400: itemtype => itemtype,
401: itemkey => itemkey,
402: aname => 'MORE_UPDATE_ACTION_LIST',
403: avalue => 'Y' );
409:
410:
411: IF (l_update_conditions_list IS NOT NULL OR l_notify_conditions_list IS NOT NULL) THEN
412:
413: WF_ENGINE.SetItemAttrText(
414: itemtype => itemtype,
415: itemkey => itemkey,
416: aname => 'NTFY_CONDITION_LIST',
417: avalue => l_notify_conditions_list );
414: itemtype => itemtype,
415: itemkey => itemkey,
416: aname => 'NTFY_CONDITION_LIST',
417: avalue => l_notify_conditions_list );
418: WF_ENGINE.SetItemAttrText(
419: itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'NTFY_ACTION_LIST',
422: avalue => l_notify_actions_list );
419: itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'NTFY_ACTION_LIST',
422: avalue => l_notify_actions_list );
423: WF_ENGINE.SetItemAttrText(
424: itemtype => itemtype,
425: itemkey => itemkey,
426: aname => 'UPDATE_CONDITION_LIST',
427: avalue => l_update_conditions_list );
424: itemtype => itemtype,
425: itemkey => itemkey,
426: aname => 'UPDATE_CONDITION_LIST',
427: avalue => l_update_conditions_list );
428: WF_ENGINE.SetItemAttrText(
429: itemtype => itemtype,
430: itemkey => itemkey,
431: aname => 'UPDATE_ACTION_LIST',
432: avalue => l_update_actions_list );
431: aname => 'UPDATE_ACTION_LIST',
432: avalue => l_update_actions_list );
433:
434: /*** This will be used later when we convert our message text to PL/SQL docs.
435: WF_ENGINE.SetItemAttrText(
436: itemtype => itemtype,
437: itemkey => itemkey,
438: aname => 'REQUEST_DETAILS',
439: avalue => 'PL/SQL:RMM_TEST_WF_PKG.SR_PLSQL_DOC_ATTR1/'||
496: BEGIN
497:
498: IF (funmode = 'RUN') THEN
499:
500: l_notify_conditions_list := WF_ENGINE.GetItemAttrText(
501: itemtype => itemtype,
502: itemkey => itemkey,
503: aname => 'NTFY_CONDITION_LIST');
504: l_notify_actions_list := WF_ENGINE.GetItemAttrText(
500: l_notify_conditions_list := WF_ENGINE.GetItemAttrText(
501: itemtype => itemtype,
502: itemkey => itemkey,
503: aname => 'NTFY_CONDITION_LIST');
504: l_notify_actions_list := WF_ENGINE.GetItemAttrText(
505: itemtype => itemtype,
506: itemkey => itemkey,
507: aname => 'NTFY_ACTION_LIST');
508:
517: element => l_action_code);
518:
519: IF (l_event_condition_id IS NOT NULL AND l_action_code IS NOT NULL) THEN
520:
521: WF_ENGINE.SetItemAttrText(
522: itemtype => itemtype,
523: itemkey => itemkey,
524: aname => 'NTFY_CONDITION_LIST',
525: avalue => l_notify_conditions_list );
522: itemtype => itemtype,
523: itemkey => itemkey,
524: aname => 'NTFY_CONDITION_LIST',
525: avalue => l_notify_conditions_list );
526: WF_ENGINE.SetItemAttrText(
527: itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'NTFY_ACTION_LIST',
530: avalue => l_notify_actions_list );
527: itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'NTFY_ACTION_LIST',
530: avalue => l_notify_actions_list );
531: WF_ENGINE.SetItemAttrNumber(
532: itemtype => itemtype,
533: itemkey => itemkey,
534: aname => 'NTFY_EVENT_CONDITION_ID',
535: avalue => l_event_condition_id );
532: itemtype => itemtype,
533: itemkey => itemkey,
534: aname => 'NTFY_EVENT_CONDITION_ID',
535: avalue => l_event_condition_id );
536: WF_ENGINE.SetItemAttrText(
537: itemtype => itemtype,
538: itemkey => itemkey,
539: aname => 'NTFY_ACTION_CODE',
540: avalue => l_action_code );
713: BEGIN
714:
715: IF (funmode = 'RUN') THEN
716:
717: l_request_number := WF_ENGINE.GetItemAttrText(
718: itemtype => itemtype,
719: itemkey => itemkey,
720: aname => 'REQUEST_NUMBER' );
721:
719: itemkey => itemkey,
720: aname => 'REQUEST_NUMBER' );
721:
722:
723: l_event_name := WF_ENGINE.GetItemAttrText(
724: itemtype => itemtype,
725: itemkey => itemkey,
726: aname => 'EVENTNAME' );
727:
724: itemtype => itemtype,
725: itemkey => itemkey,
726: aname => 'EVENTNAME' );
727:
728: l_event_condition_id := WF_ENGINE.GetItemAttrNumber(
729: itemtype => itemtype,
730: itemkey => itemkey,
731: aname => 'NTFY_EVENT_CONDITION_ID' );
732:
729: itemtype => itemtype,
730: itemkey => itemkey,
731: aname => 'NTFY_EVENT_CONDITION_ID' );
732:
733: l_action_code := WF_ENGINE.GetItemAttrText(
734: itemtype => itemtype,
735: itemkey => itemkey,
736: aname => 'NTFY_ACTION_CODE' );
737:
743: FROM cs_incidents_all_b
744: WHERE INCIDENT_NUMBER = l_request_number;
745: *************/
746:
747: l_request_id := WF_ENGINE.GetItemAttrNumber(
748: itemtype => itemtype,
749: itemkey => itemkey,
750: aname => 'REQUEST_ID' );
751:
752:
753: /*
754: Roopa - begin - bug fix for 2788741
755: */
756: l_user_id := WF_ENGINE.GetItemAttrNumber(
757: itemtype => itemtype,
758: itemkey => itemkey,
759: aname => 'USER_ID' );
760: l_prev_owner_id := WF_ENGINE.GetItemAttrNumber(
756: l_user_id := WF_ENGINE.GetItemAttrNumber(
757: itemtype => itemtype,
758: itemkey => itemkey,
759: aname => 'USER_ID' );
760: l_prev_owner_id := WF_ENGINE.GetItemAttrNumber(
761: itemtype => itemtype,
762: itemkey => itemkey,
763: aname => 'PREV_OWNER_ID' );
764:
791: INTO sel_event_action_rec;
792: CLOSE sel_event_action_csr;
793:
794: -- Set the message template to be used for the notification
795: WF_ENGINE.SetItemAttrText(
796: itemtype => itemtype,
797: itemkey => itemkey,
798: aname => 'NTFY_MESSAGE_NAME',
799: avalue => sel_event_action_rec.notification_template_id );
806:
807: IF (sel_event_action_rec.from_to_status_code IS NOT NULL) THEN
808:
809: IF (sel_event_action_rec.from_to_status_code = 'STATUS_CHANGED_TO') THEN
810: l_request_status := WF_ENGINE.GetItemAttrText(
811: itemtype => itemtype,
812: itemkey => itemkey,
813: aname => 'REQUEST_STATUS_NEW' );--bug 11679421
814:
812: itemkey => itemkey,
813: aname => 'REQUEST_STATUS_NEW' );--bug 11679421
814:
815: ELSIF (sel_event_action_rec.from_to_status_code = 'STATUS_CHANGED_FROM') THEN
816: l_request_status := WF_ENGINE.GetItemAttrText(
817: itemtype => itemtype,
818: itemkey => itemkey,
819: aname => 'REQUEST_STATUS_OLD' );
820: END IF;
864: won't fit here. This flag will tell us later to
865: re-query the remainding subject IDs.
866: **************************************/
867:
868: WF_ENGINE.SetItemAttrText(
869: itemtype => itemtype,
870: itemkey => itemkey,
871: aname => 'MORE_NTFY_LINKED_SUBJECT_LIST',
872: avalue => 'Y' );
881: END IF;
882:
883: IF (l_linked_subject_list IS NOT NULL) THEN
884:
885: WF_ENGINE.SetItemAttrText(
886: itemtype => itemtype,
887: itemkey => itemkey,
888: aname => 'NTFY_LINKED_SUBJECT_LIST',
889: avalue => l_linked_subject_list );
934:
935: /********************
936: This section is for relationship created/deleted events
937: ********************/
938: l_trigger_link_type := WF_ENGINE.GetItemAttrText(
939: itemtype => itemtype,
940: itemkey => itemkey,
941: aname => 'NTFY_LINK_TYPE');
942:
947:
948: IF (sel_link_type_id_csr%FOUND) THEN
949: -- LINKED_INCIDENT_ID is mandatory for this rule since we can't get a
950: -- handle of the linked SR when the link has been deleted.
951: l_linked_incident_number := WF_ENGINE.GetItemAttrText(
952: itemtype => itemtype,
953: itemkey => itemkey,
954: aname => 'NTFY_LINKED_INCIDENT_NUMBER' );
955:
1681: IF (funmode = 'RUN') THEN
1682:
1683: l_temp_item_key := itemkey;
1684:
1685: l_action_code := WF_ENGINE.GetItemAttrText(
1686: itemtype => itemtype,
1687: itemkey => itemkey,
1688: aname => 'NTFY_ACTION_CODE' );
1689:
1686: itemtype => itemtype,
1687: itemkey => itemkey,
1688: aname => 'NTFY_ACTION_CODE' );
1689:
1690: l_event_condition_id := WF_ENGINE.GetItemAttrText(
1691: itemtype => itemtype,
1692: itemkey => itemkey,
1693: aname => 'NTFY_EVENT_CONDITION_ID' );
1694:
1691: itemtype => itemtype,
1692: itemkey => itemkey,
1693: aname => 'NTFY_EVENT_CONDITION_ID' );
1694:
1695: l_request_number := WF_ENGINE.GetItemAttrText(
1696: itemtype => itemtype,
1697: itemkey => itemkey,
1698: aname => 'REQUEST_NUMBER' );
1699:
1696: itemtype => itemtype,
1697: itemkey => itemkey,
1698: aname => 'REQUEST_NUMBER' );
1699:
1700: l_request_id := WF_ENGINE.GetItemAttrNumber(
1701: itemtype => itemtype,
1702: itemkey => itemkey,
1703: aname => 'REQUEST_ID' );
1704:
1708: OPEN l_sel_curr_sr_details_csr;
1709: FETCH l_sel_curr_sr_details_csr into l_sel_curr_sr_details_rec;
1710: CLOSE l_sel_curr_sr_details_csr;
1711:
1712: l_prev_type_id := WF_ENGINE.GetItemAttrText(
1713: itemtype => itemtype,
1714: itemkey => itemkey,
1715: aname => 'PREV_TYPE_ID' );
1716:
1713: itemtype => itemtype,
1714: itemkey => itemkey,
1715: aname => 'PREV_TYPE_ID' );
1716:
1717: l_prev_status_id := WF_ENGINE.GetItemAttrText(
1718: itemtype => itemtype,
1719: itemkey => itemkey,
1720: aname => 'PREV_STATUS_ID' );
1721:
1718: itemtype => itemtype,
1719: itemkey => itemkey,
1720: aname => 'PREV_STATUS_ID' );
1721:
1722: l_prev_severity_id := WF_ENGINE.GetItemAttrText(
1723: itemtype => itemtype,
1724: itemkey => itemkey,
1725: aname => 'PREV_SEVERITY_ID' );
1726: l_prev_urgency_id := WF_ENGINE.GetItemAttrText(
1722: l_prev_severity_id := WF_ENGINE.GetItemAttrText(
1723: itemtype => itemtype,
1724: itemkey => itemkey,
1725: aname => 'PREV_SEVERITY_ID' );
1726: l_prev_urgency_id := WF_ENGINE.GetItemAttrText(
1727: itemtype => itemtype,
1728: itemkey => itemkey,
1729: aname => 'PREV_URGENCY_ID' );
1730:
1728: itemkey => itemkey,
1729: aname => 'PREV_URGENCY_ID' );
1730:
1731:
1732: l_prev_summary := WF_ENGINE.GetItemAttrText(
1733: itemtype => itemtype,
1734: itemkey => itemkey,
1735: aname => 'PREV_SUMMARY' );
1736:
1788: END LOOP;
1789:
1790: IF(l_changed_field_list is not null) THEN
1791: l_changed_field_list := l_changed_field_list || ' of ';
1792: WF_ENGINE.SetItemAttrText(
1793: itemtype => itemtype,
1794: itemkey => itemkey,
1795: aname => 'CHANGED_LIST',
1796: avalue => l_changed_field_list );
1802:
1803: l_updated_by := l_get_resource_name_rec.source_first_name || ' '
1804: || l_get_resource_name_rec.source_last_name;
1805:
1806: WF_ENGINE.SetItemAttrText(
1807: itemtype => itemtype,
1808: itemkey => itemkey,
1809: aname => 'UPDATED_BY',
1810: avalue => l_updated_by );
1822:
1823: l_created_by := l_get_resource_name_rec.source_first_name || ' '
1824: || l_get_resource_name_rec.source_last_name;
1825:
1826: WF_ENGINE.SetItemAttrText(
1827: itemtype => itemtype,
1828: itemkey => itemkey,
1829: aname => 'CREATED_BY',
1830: avalue => l_created_by );
1835:
1836: /* Roopa - begin
1837: Fix for bug # 2804495
1838: */
1839: l_solution_number := WF_ENGINE.GetItemAttrText(
1840: itemtype => itemtype,
1841: itemkey => itemkey,
1842: aname => 'SOLUTION_NUMBER');
1843: IF (l_solution_number is not null) THEN
1845: FETCH l_getsoln_summary_csr INTO l_solution_summary;
1846: CLOSE l_getsoln_summary_csr;
1847:
1848: IF(l_solution_summary is not null) THEN
1849: WF_ENGINE.SetItemAttrText(
1850: itemtype => itemtype,
1851: itemkey => itemkey,
1852: aname => 'SOLUTION SUMMARY',
1853: avalue => l_solution_summary);
1861: */
1862:
1863:
1864: IF (l_action_code = 'NOTIFY_OWNER' OR l_action_code = 'NOTIFY_NEW_OWNER') THEN
1865: l_notify_recipient := WF_ENGINE.GetItemAttrText(
1866: itemtype => itemtype,
1867: itemkey => itemkey,
1868: aname => 'OWNER_ROLE');
1869:
1867: itemkey => itemkey,
1868: aname => 'OWNER_ROLE');
1869:
1870: ELSIF (l_action_code = 'NOTIFY_OLD_OWNER') THEN
1871: l_notify_recipient := WF_ENGINE.GetItemAttrText(
1872: itemtype => itemtype,
1873: itemkey => itemkey,
1874: aname => 'PREV_OWNER_ROLE');
1875:
1873: itemkey => itemkey,
1874: aname => 'PREV_OWNER_ROLE');
1875:
1876: ELSIF (l_action_code = 'NOTIFY_OWNER_OF_RELATED_SR') THEN
1877: l_linked_subject_list := WF_ENGINE.GetItemAttrText(
1878: itemtype => itemtype,
1879: itemkey => itemkey,
1880: aname => 'NTFY_LINKED_SUBJECT_LIST');
1881: IF (l_linked_subject_list IS NOT NULL) THEN
1883: element => l_element);
1884:
1885: l_notify_subject_id := TO_NUMBER(l_element);
1886:
1887: WF_ENGINE.SetItemAttrText(
1888: itemtype => itemtype,
1889: itemkey => itemkey,
1890: aname => 'NTFY_LINKED_SUBJECT_LIST',
1891: avalue => l_linked_subject_list );
1889: itemkey => itemkey,
1890: aname => 'NTFY_LINKED_SUBJECT_LIST',
1891: avalue => l_linked_subject_list );
1892:
1893: WF_ENGINE.SetItemAttrNumber(
1894: itemtype => itemtype,
1895: itemkey => itemkey,
1896: aname => 'NTFY_SUBJECT_ID',
1897: avalue => l_notify_subject_id );
1904: /*
1905: Roopa - begin - bug fix for 2788741
1906: */
1907:
1908: l_user_id := WF_ENGINE.GetItemAttrNumber(
1909: itemtype => itemtype,
1910: itemkey => itemkey,
1911: aname => 'USER_ID' );
1912: OPEN sel_resource_id;
1922: /*
1923: Roopa - end - bug fix for 2788741
1924: */
1925:
1926: WF_ENGINE.SetItemAttrText(
1927: itemtype => itemtype,
1928: itemkey => itemkey,
1929: aname => 'NTFY_LINKED_INCIDENT_NUMBER',
1930: avalue => sel_link_rec.incident_number );
1930: avalue => sel_link_rec.incident_number );
1931:
1932: -- Get link Type name from link_type_id
1933:
1934: WF_ENGINE.SetItemAttrText(
1935: itemtype => itemtype,
1936: itemkey => itemkey,
1937: aname => 'NTFY_LINK_TYPE',
1938: avalue => sel_link_rec.link_type_name );
1990: The following block handles notification rules defined for these 2 actions
1991: */
1992: ELSIF (l_action_code = 'NOTIFY_PRIM_CONTACT_OF_REL_SR') THEN
1993:
1994: l_linked_subject_list := WF_ENGINE.GetItemAttrText(
1995: itemtype => itemtype,
1996: itemkey => itemkey,
1997: aname => 'NTFY_LINKED_SUBJECT_LIST');
1998:
2010: element => l_element);
2011:
2012: l_notify_subject_id := TO_NUMBER(l_element);
2013:
2014: WF_ENGINE.SetItemAttrText(
2015: itemtype => itemtype,
2016: itemkey => itemkey,
2017: aname => 'NTFY_LINKED_SUBJECT_LIST',
2018: avalue => l_linked_subject_list );
2016: itemkey => itemkey,
2017: aname => 'NTFY_LINKED_SUBJECT_LIST',
2018: avalue => l_linked_subject_list );
2019:
2020: WF_ENGINE.SetItemAttrNumber(
2021: itemtype => itemtype,
2022: itemkey => itemkey,
2023: aname => 'NTFY_SUBJECT_ID',
2024: avalue => l_notify_subject_id );
2031: FETCH sel_linked_sr_type_csr INTO sel_linked_sr_type_rec;
2032: CLOSE sel_linked_sr_type_csr;
2033:
2034:
2035: l_user_id := WF_ENGINE.GetItemAttrNumber(
2036: itemtype => itemtype,
2037: itemkey => itemkey,
2038: aname => 'USER_ID' );
2039:
2036: itemtype => itemtype,
2037: itemkey => itemkey,
2038: aname => 'USER_ID' );
2039:
2040: WF_ENGINE.SetItemAttrText(
2041: itemtype => itemtype,
2042: itemkey => itemkey,
2043: aname => 'NTFY_LINKED_INCIDENT_NUMBER',
2044: avalue => sel_link_rec.incident_number );
2045:
2046:
2047: -- Get link Type name from link_type_id
2048:
2049: WF_ENGINE.SetItemAttrText(
2050: itemtype => itemtype,
2051: itemkey => itemkey,
2052: aname => 'NTFY_LINK_TYPE',
2053: avalue => sel_linked_sr_type_rec.link_type_name );
2058: OPEN sel_linked_sr_details_csr;
2059: FETCH sel_linked_sr_details_csr into sel_linked_sr_details_rec;
2060: CLOSE sel_linked_sr_details_csr;
2061:
2062: WF_ENGINE.SetItemAttrText(
2063: itemtype => itemtype,
2064: itemkey => itemkey,
2065: aname => 'NTFY_LINKED_SR_STATUS',
2066: avalue => sel_linked_sr_details_rec.name );
2064: itemkey => itemkey,
2065: aname => 'NTFY_LINKED_SR_STATUS',
2066: avalue => sel_linked_sr_details_rec.name );
2067:
2068: WF_ENGINE.SetItemAttrText(
2069: itemtype => itemtype,
2070: itemkey => itemkey,
2071: aname => 'NTFY_LINKED_SR_SUMMARY',
2072: avalue => sel_linked_sr_details_rec.summary );
2171:
2172: l_notify_contact_name := l_contact_first_name|| ' ' ||l_contact_last_name;
2173:
2174:
2175: WF_ENGINE.SetItemAttrText(
2176: itemtype => itemtype,
2177: itemkey => itemkey,
2178: aname => 'NTFY_LINKED_SR_CONTACT',
2179: avalue => l_notify_contact_name );
2185: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2186: || '?srID=' || sel_link_rec.incident_number;
2187:
2188: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || sel_link_rec.incident_number;
2189: WF_ENGINE.SetItemAttrText(
2190: itemtype => itemtype,
2191: itemkey => itemkey,
2192: aname => 'NTFY_REQUEST_NUMBER_URL',
2193: avalue => l_serviceRequest_URL);
2308:
2309: END LOOP;
2310: CLOSE get_primary_contact_info;
2311:
2312: l_request_id := WF_ENGINE.GetItemAttrNumber(
2313: itemtype => itemtype,
2314: itemkey => itemkey,
2315: aname => 'REQUEST_ID' );
2316:
2337:
2338:
2339: -- 11.5.10 enhancement to Create Interaction when email to contact sent.
2340: /* Roopa - begin bug 3360069 */
2341: /* Replacing the AddItemAttr() call with WF_Engine add, get and set calls
2342: to factor in the scenario where this attr already exists */
2343:
2344: IF (l_contact_party_id_list IS NOT NULL) THEN
2345:
2348:
2349:
2350: /****
2351: l_temp_contact_id_list := null;
2352: l_temp_contact_id_list := WF_ENGINE.GetItemAttrText( itemtype,
2353: itemkey,
2354: 'CONTACT_PARTY_ID_LIST',
2355: TRUE);
2356:
2358: IF(l_temp_contact_id_list is NULL) THEN
2359: *****/
2360:
2361: IF(check_if_item_attr_exists_csr%NOTFOUND) THEN
2362: WF_ENGINE.AddItemAttr( itemtype,
2363: itemkey,
2364: 'CONTACT_PARTY_ID_LIST',
2365: l_contact_party_id_list);
2366: ELSE
2364: 'CONTACT_PARTY_ID_LIST',
2365: l_contact_party_id_list);
2366: ELSE
2367:
2368: WF_ENGINE.SetItemAttrText(
2369: itemtype => itemtype,
2370: itemkey => itemkey,
2371: aname => 'CONTACT_PARTY_ID_LIST',
2372: avalue => l_contact_party_id_list);
2387:
2388: -- set the item attributes for html notification
2389:
2390: IF l_html_notification_flag = 'Y' THEN
2391: WF_ENGINE.SetItemAttrText(
2392: itemtype => itemtype,
2393: itemkey => itemkey,
2394: AName => 'ADHOC_USER_LIST',
2395: AValue => l_html_adhoc_user_list);
2393: itemkey => itemkey,
2394: AName => 'ADHOC_USER_LIST',
2395: AValue => l_html_adhoc_user_list);
2396:
2397: WF_ENGINE.SetItemAttrText(
2398: itemtype => itemtype,
2399: itemkey => itemkey,
2400: AName => 'CONTACT_ID_LIST',
2401: AValue => l_contact_id_list);
2399: itemkey => itemkey,
2400: AName => 'CONTACT_ID_LIST',
2401: AValue => l_contact_id_list);
2402:
2403: WF_ENGINE.SetItemAttrText(
2404: itemtype => itemtype,
2405: itemkey => itemkey,
2406: AName => 'CONTACT_EMAIL_LIST',
2407: AValue => l_html_contact_email_list);
2405: itemkey => itemkey,
2406: AName => 'CONTACT_EMAIL_LIST',
2407: AValue => l_html_contact_email_list);
2408:
2409: WF_ENGINE.SetItemAttrText(
2410: itemtype => itemtype,
2411: itemkey => itemkey,
2412: AName => 'CONTACT_TYPE_LIST',
2413: AValue => l_contact_type_list);
2411: itemkey => itemkey,
2412: AName => 'CONTACT_TYPE_LIST',
2413: AValue => l_contact_type_list);
2414:
2415: WF_ENGINE.SetItemAttrText(
2416: itemtype => itemtype,
2417: itemkey => itemkey,
2418: AName => 'NOTIFICATION_PREFERENCE_LIST',
2419: AValue => l_notification_pref_list);
2417: itemkey => itemkey,
2418: AName => 'NOTIFICATION_PREFERENCE_LIST',
2419: AValue => l_notification_pref_list);
2420:
2421: WF_ENGINE.SetItemAttrText(
2422: itemtype => itemtype,
2423: itemkey => itemkey,
2424: AName => 'LANGUAGE_LIST',
2425: AValue => l_language_list);
2430: OPEN c_check_html_notification;
2431: FETCH c_check_html_notification INTO l_html_notification_flag ;
2432: CLOSE c_check_html_notification;
2433:
2434: l_linked_subject_list := WF_ENGINE.GetItemAttrText(
2435: itemtype => itemtype,
2436: itemkey => itemkey,
2437: aname => 'NTFY_LINKED_SUBJECT_LIST');
2438:
2443: element => l_element);
2444:
2445: l_notify_subject_id := TO_NUMBER(l_element);
2446:
2447: WF_ENGINE.SetItemAttrText(
2448: itemtype => itemtype,
2449: itemkey => itemkey,
2450: aname => 'NTFY_LINKED_SUBJECT_LIST',
2451: avalue => l_linked_subject_list );
2449: itemkey => itemkey,
2450: aname => 'NTFY_LINKED_SUBJECT_LIST',
2451: avalue => l_linked_subject_list );
2452:
2453: WF_ENGINE.SetItemAttrNumber(
2454: itemtype => itemtype,
2455: itemkey => itemkey,
2456: aname => 'NTFY_SUBJECT_ID',
2457: avalue => l_notify_subject_id );
2463: OPEN sel_linked_sr_type_csr;
2464: FETCH sel_linked_sr_type_csr INTO sel_linked_sr_type_rec;
2465: CLOSE sel_linked_sr_type_csr;
2466:
2467: l_user_id := WF_ENGINE.GetItemAttrNumber(
2468: itemtype => itemtype,
2469: itemkey => itemkey,
2470: aname => 'USER_ID' );
2471:
2468: itemtype => itemtype,
2469: itemkey => itemkey,
2470: aname => 'USER_ID' );
2471:
2472: WF_ENGINE.SetItemAttrText(
2473: itemtype => itemtype,
2474: itemkey => itemkey,
2475: aname => 'NTFY_LINKED_INCIDENT_NUMBER',
2476: avalue => sel_link_rec.incident_number );
2476: avalue => sel_link_rec.incident_number );
2477:
2478: -- Get link Type name from link_type_id
2479:
2480: WF_ENGINE.SetItemAttrText(
2481: itemtype => itemtype,
2482: itemkey => itemkey,
2483: aname => 'NTFY_LINK_TYPE',
2484: avalue => sel_linked_sr_type_rec.link_type_name );
2501: FETCH sel_contact_name_csr INTO sel_contact_name_rec;
2502: CLOSE sel_contact_name_csr;
2503:
2504: l_notify_contact_name := sel_contact_name_rec.first_name || ' ' || sel_contact_name_rec.last_name;
2505: WF_ENGINE.SetItemAttrText(
2506: itemtype => itemtype,
2507: itemkey => itemkey,
2508: aname => 'NTFY_LINKED_SR_CONTACT',
2509: avalue => l_notify_contact_name );
2515: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2516: || '?srID=' || l_request_number;
2517:
2518: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || l_request_number;
2519: WF_ENGINE.SetItemAttrText(
2520: itemtype => itemtype,
2521: itemkey => itemkey,
2522: aname => 'NTFY_REQUEST_NUMBER_URL',
2523: avalue => l_serviceRequest_URL);
2654: END IF;
2655: END LOOP;
2656: CLOSE sel_all_contacts_csr;
2657:
2658: l_request_id := WF_ENGINE.GetItemAttrNumber(
2659: itemtype => itemtype,
2660: itemkey => itemkey,
2661: aname => 'REQUEST_ID' );
2662:
2684: END IF;
2685:
2686: -- 11.5.10 enhancement to Create Interaction when email to contact sent.
2687: /* Roopa - begin bug 3360069 */
2688: /* Replacing the AddItemAttr() call with WF_Engine add, get and set calls
2689: to factor in the scenario where this attr already exists */
2690:
2691: IF (l_contact_party_id_list IS NOT NULL) THEN
2692:
2694: FETCH check_if_item_attr_exists_csr into l_temp_contact_id_list;
2695:
2696: /****
2697: l_temp_contact_id_list := null;
2698: l_temp_contact_id_list := WF_ENGINE.GetItemAttrText( itemtype,
2699: itemkey,
2700: 'CONTACT_PARTY_ID_LIST',
2701: TRUE);
2702:
2703: IF(l_temp_contact_id_list is NULL) THEN
2704: *****/
2705:
2706: IF(check_if_item_attr_exists_csr%NOTFOUND) THEN
2707: WF_ENGINE.AddItemAttr( itemtype,
2708: itemkey,
2709: 'CONTACT_PARTY_ID_LIST',
2710: l_contact_party_id_list);
2711: ELSE
2708: itemkey,
2709: 'CONTACT_PARTY_ID_LIST',
2710: l_contact_party_id_list);
2711: ELSE
2712: WF_ENGINE.SetItemAttrText(
2713: itemtype => itemtype,
2714: itemkey => itemkey,
2715: aname => 'CONTACT_PARTY_ID_LIST',
2716: avalue => l_contact_party_id_list);
2730: -- set the item attributes for html notification
2731:
2732: IF l_html_notification_flag = 'Y' THEN
2733:
2734: WF_ENGINE.SetItemAttrText(
2735: itemtype => itemtype,
2736: itemkey => itemkey,
2737: AName => 'ADHOC_USER_LIST',
2738: AValue => l_html_adhoc_user_list);
2736: itemkey => itemkey,
2737: AName => 'ADHOC_USER_LIST',
2738: AValue => l_html_adhoc_user_list);
2739:
2740: WF_ENGINE.SetItemAttrText(
2741: itemtype => itemtype,
2742: itemkey => itemkey,
2743: AName => 'CONTACT_ID_LIST',
2744: AValue => l_contact_id_list);
2742: itemkey => itemkey,
2743: AName => 'CONTACT_ID_LIST',
2744: AValue => l_contact_id_list);
2745:
2746: WF_ENGINE.SetItemAttrText(
2747: itemtype => itemtype,
2748: itemkey => itemkey,
2749: AName => 'CONTACT_EMAIL_LIST',
2750: AValue => l_html_contact_email_list);
2748: itemkey => itemkey,
2749: AName => 'CONTACT_EMAIL_LIST',
2750: AValue => l_html_contact_email_list);
2751:
2752: WF_ENGINE.SetItemAttrText(
2753: itemtype => itemtype,
2754: itemkey => itemkey,
2755: AName => 'CONTACT_TYPE_LIST',
2756: AValue => l_contact_type_list);
2754: itemkey => itemkey,
2755: AName => 'CONTACT_TYPE_LIST',
2756: AValue => l_contact_type_list);
2757:
2758: WF_ENGINE.SetItemAttrText(
2759: itemtype => itemtype,
2760: itemkey => itemkey,
2761: AName => 'NOTIFICATION_PREFERENCE_LIST',
2762: AValue => l_notification_pref_list);
2760: itemkey => itemkey,
2761: AName => 'NOTIFICATION_PREFERENCE_LIST',
2762: AValue => l_notification_pref_list);
2763:
2764: WF_ENGINE.SetItemAttrText(
2765: itemtype => itemtype,
2766: itemkey => itemkey,
2767: AName => 'LANGUAGE_LIST',
2768: AValue => l_language_list);
2775:
2776: ELSIF (l_action_code = 'NOTIFY_ALL_ASSOCIATED_PARTIES') THEN
2777:
2778:
2779: l_linked_subject_list := WF_ENGINE.GetItemAttrText(
2780: itemtype => itemtype,
2781: itemkey => itemkey,
2782: aname => 'NTFY_LINKED_SUBJECT_LIST');
2783:
2780: itemtype => itemtype,
2781: itemkey => itemkey,
2782: aname => 'NTFY_LINKED_SUBJECT_LIST');
2783:
2784: l_notify_relsr_party_role_list := WF_ENGINE.GetItemAttrText(
2785: itemtype => itemtype,
2786: itemkey => itemkey,
2787: aname => 'NOTIFY_RELSR_PARTY_ROLE_LIST');
2788:
2802: ELSE
2803: RETURN;
2804: END IF;
2805:
2806: WF_ENGINE.SetItemAttrText(
2807: itemtype => itemtype,
2808: itemkey => itemkey,
2809: aname => 'PARTY_ROLE_NAME',
2810: avalue => l_party_role_name );
2808: itemkey => itemkey,
2809: aname => 'PARTY_ROLE_NAME',
2810: avalue => l_party_role_name );
2811:
2812: WF_ENGINE.SetItemAttrText(
2813: itemtype => itemtype,
2814: itemkey => itemkey,
2815: aname => 'NOTIFY_RELSR_PARTY_ROLE_LIST',
2816: avalue => l_notify_relsr_party_role_list);
2821: element => l_element);
2822:
2823: l_notify_subject_id := TO_NUMBER(l_element);
2824:
2825: WF_ENGINE.SetItemAttrText(
2826: itemtype => itemtype,
2827: itemkey => itemkey,
2828: aname => 'NTFY_LINKED_SUBJECT_LIST',
2829: avalue => l_linked_subject_list );
2827: itemkey => itemkey,
2828: aname => 'NTFY_LINKED_SUBJECT_LIST',
2829: avalue => l_linked_subject_list );
2830:
2831: WF_ENGINE.SetItemAttrNumber(
2832: itemtype => itemtype,
2833: itemkey => itemkey,
2834: aname => 'NTFY_SUBJECT_ID',
2835: avalue => l_notify_subject_id );
2841: OPEN sel_linked_sr_type_csr;
2842: FETCH sel_linked_sr_type_csr INTO sel_linked_sr_type_rec;
2843: CLOSE sel_linked_sr_type_csr;
2844:
2845: l_user_id := WF_ENGINE.GetItemAttrNumber(
2846: itemtype => itemtype,
2847: itemkey => itemkey,
2848: aname => 'USER_ID' );
2849:
2846: itemtype => itemtype,
2847: itemkey => itemkey,
2848: aname => 'USER_ID' );
2849:
2850: WF_ENGINE.SetItemAttrText(
2851: itemtype => itemtype,
2852: itemkey => itemkey,
2853: aname => 'NTFY_LINKED_INCIDENT_NUMBER',
2854: avalue => sel_link_rec.incident_number );
2854: avalue => sel_link_rec.incident_number );
2855:
2856: -- Get link Type name from link_type_id
2857:
2858: WF_ENGINE.SetItemAttrText(
2859: itemtype => itemtype,
2860: itemkey => itemkey,
2861: aname => 'NTFY_LINK_TYPE',
2862: avalue => sel_linked_sr_type_rec.link_type_name );
2866: OPEN sel_linked_sr_details_csr;
2867: FETCH sel_linked_sr_details_csr into sel_linked_sr_details_rec;
2868: CLOSE sel_linked_sr_details_csr;
2869:
2870: WF_ENGINE.SetItemAttrText(
2871: itemtype => itemtype,
2872: itemkey => itemkey,
2873: aname => 'NTFY_LINKED_SR_STATUS',
2874: avalue => sel_linked_sr_details_rec.name );
2874: avalue => sel_linked_sr_details_rec.name );
2875:
2876:
2877:
2878: WF_ENGINE.SetItemAttrText(
2879: itemtype => itemtype,
2880: itemkey => itemkey,
2881: aname => 'NTFY_LINKED_SR_SUMMARY',
2882: avalue => sel_linked_sr_details_rec.summary );
2896: FETCH sel_contact_name_csr INTO sel_contact_name_rec;
2897: CLOSE sel_contact_name_csr;
2898:
2899: l_notify_contact_name := sel_contact_name_rec.first_name || ' ' || sel_contact_name_rec.last_name;
2900: WF_ENGINE.SetItemAttrText(
2901: itemtype => itemtype,
2902: itemkey => itemkey,
2903: aname => 'NTFY_LINKED_SR_CONTACT',
2904: avalue => l_notify_contact_name );
2909:
2910: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2911: || '?srID=' || l_request_number;
2912:
2913: WF_ENGINE.SetItemAttrText(
2914: itemtype => itemtype,
2915: itemkey => itemkey,
2916: aname => 'NTFY_REQUEST_NUMBER_URL',
2917: avalue => l_serviceRequest_URL);
2977: END IF;
2978: END LOOP;
2979: CLOSE sel_party_role_contacts_csr;
2980:
2981: l_request_id := WF_ENGINE.GetItemAttrNumber(
2982: itemtype => itemtype,
2983: itemkey => itemkey,
2984: aname => 'REQUEST_ID' );
2985:
3180: -- set the item attributes for html notification
3181:
3182: IF l_html_notification_flag = 'Y' THEN
3183:
3184: WF_ENGINE.SetItemAttrText
3185: ( itemtype => itemtype,
3186: itemkey => itemkey,
3187: AName => 'ADHOC_USER_LIST',
3188: AValue => l_html_adhoc_user_list);
3186: itemkey => itemkey,
3187: AName => 'ADHOC_USER_LIST',
3188: AValue => l_html_adhoc_user_list);
3189:
3190: WF_ENGINE.SetItemAttrText
3191: ( itemtype => itemtype,
3192: itemkey => itemkey,
3193: AName => 'CONTACT_ID_LIST',
3194: AValue => l_contact_id_list);
3192: itemkey => itemkey,
3193: AName => 'CONTACT_ID_LIST',
3194: AValue => l_contact_id_list);
3195:
3196: WF_ENGINE.SetItemAttrText
3197: ( itemtype => itemtype,
3198: itemkey => itemkey,
3199: AName => 'CONTACT_EMAIL_LIST',
3200: AValue => l_html_contact_email_list);
3198: itemkey => itemkey,
3199: AName => 'CONTACT_EMAIL_LIST',
3200: AValue => l_html_contact_email_list);
3201:
3202: WF_ENGINE.SetItemAttrText
3203: ( itemtype => itemtype,
3204: itemkey => itemkey,
3205: AName => 'CONTACT_TYPE_LIST',
3206: AValue => l_contact_type_list);
3204: itemkey => itemkey,
3205: AName => 'CONTACT_TYPE_LIST',
3206: AValue => l_contact_type_list);
3207:
3208: WF_ENGINE.SetItemAttrText
3209: ( itemtype => itemtype,
3210: itemkey => itemkey,
3211: AName => 'NOTIFICATION_PREFERENCE_LIST',
3212: AValue => l_notification_pref_list);
3210: itemkey => itemkey,
3211: AName => 'NOTIFICATION_PREFERENCE_LIST',
3212: AValue => l_notification_pref_list);
3213:
3214: WF_ENGINE.SetItemAttrText
3215: ( itemtype => itemtype,
3216: itemkey => itemkey,
3217: AName => 'LANGUAGE_LIST',
3218: AValue => l_language_list);
3224: CLOSE sel_jsp_name_csr;
3225:
3226: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3227: || '?srID=' || l_request_number;
3228: WF_ENGINE.SetItemAttrText(
3229: itemtype => itemtype,
3230: itemkey => itemkey,
3231: aname => 'NTFY_REQUEST_NUMBER_URL',
3232: avalue => l_serviceRequest_URL);
3260:
3261:
3262: -- 11.5.10 enhancement to Create Interaction when email to contact sent.
3263: /* Roopa - begin bug 3360069 */
3264: /* Replacing the AddItemAttr() call with WF_Engine add, get and set calls
3265: to factor in the scenario where this attr already exists */
3266:
3267: IF (l_contact_party_id_list IS NOT NULL) THEN
3268:
3269: OPEN check_if_item_attr_exists_csr;
3270: FETCH check_if_item_attr_exists_csr into l_temp_contact_id_list;
3271:
3272: IF(check_if_item_attr_exists_csr%NOTFOUND) THEN
3273: WF_ENGINE.AddItemAttr( itemtype,
3274: itemkey,
3275: 'CONTACT_PARTY_ID_LIST',
3276: l_contact_party_id_list);
3277: ELSE
3274: itemkey,
3275: 'CONTACT_PARTY_ID_LIST',
3276: l_contact_party_id_list);
3277: ELSE
3278: WF_ENGINE.SetItemAttrText(
3279: itemtype => itemtype,
3280: itemkey => itemkey,
3281: aname => 'CONTACT_PARTY_ID_LIST',
3282: avalue => l_contact_party_id_list);
3289: -- Start of code for Associated Party Notification --
3290: ELSIF (l_action_code = 'NOTIFY_ASSOCIATED_PARTIES') THEN
3291:
3292:
3293: l_notify_party_role_list := WF_ENGINE.GetItemAttrText(
3294: itemtype => itemtype,
3295: itemkey => itemkey,
3296: aname => 'NOTIFY_PARTY_ROLE_LIST');
3297:
3311: ELSE
3312: RETURN;
3313: END IF;
3314:
3315: WF_ENGINE.SetItemAttrText(
3316: itemtype => itemtype,
3317: itemkey => itemkey,
3318: aname => 'PARTY_ROLE_NAME',
3319: avalue => l_party_role_name );
3317: itemkey => itemkey,
3318: aname => 'PARTY_ROLE_NAME',
3319: avalue => l_party_role_name );
3320:
3321: WF_ENGINE.SetItemAttrText(
3322: itemtype => itemtype,
3323: itemkey => itemkey,
3324: aname => 'NOTIFY_PARTY_ROLE_LIST',
3325: avalue => l_notify_party_role_list);
3406: CLOSE sel_jsp_name_csr;
3407:
3408: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3409: || '?srID=' || l_request_number;
3410: WF_ENGINE.SetItemAttrText(
3411: itemtype => itemtype,
3412: itemkey => itemkey,
3413: aname => 'NTFY_REQUEST_NUMBER_URL',
3414: avalue => l_serviceRequest_URL);
3611: END IF ; -- end if for l_html_notification_flag
3612:
3613: IF l_html_notification_flag = 'Y' THEN
3614:
3615: WF_ENGINE.SetItemAttrText(
3616: itemtype => itemtype,
3617: itemkey => itemkey,
3618: AName => 'ADHOC_USER_LIST',
3619: AValue => l_html_adhoc_user_list);
3617: itemkey => itemkey,
3618: AName => 'ADHOC_USER_LIST',
3619: AValue => l_html_adhoc_user_list);
3620:
3621: WF_ENGINE.SetItemAttrText(
3622: itemtype => itemtype,
3623: itemkey => itemkey,
3624: AName => 'CONTACT_ID_LIST',
3625: AValue => l_contact_id_list);
3623: itemkey => itemkey,
3624: AName => 'CONTACT_ID_LIST',
3625: AValue => l_contact_id_list);
3626:
3627: WF_ENGINE.SetItemAttrText(
3628: itemtype => itemtype,
3629: itemkey => itemkey,
3630: AName => 'CONTACT_EMAIL_LIST',
3631: AValue => l_html_contact_email_list);
3629: itemkey => itemkey,
3630: AName => 'CONTACT_EMAIL_LIST',
3631: AValue => l_html_contact_email_list);
3632:
3633: WF_ENGINE.SetItemAttrText(
3634: itemtype => itemtype,
3635: itemkey => itemkey,
3636: AName => 'CONTACT_TYPE_LIST',
3637: AValue => l_contact_type_list);
3635: itemkey => itemkey,
3636: AName => 'CONTACT_TYPE_LIST',
3637: AValue => l_contact_type_list);
3638:
3639: WF_ENGINE.SetItemAttrText(
3640: itemtype => itemtype,
3641: itemkey => itemkey,
3642: AName => 'NOTIFICATION_PREFERENCE_LIST',
3643: AValue => l_notification_pref_list);
3641: itemkey => itemkey,
3642: AName => 'NOTIFICATION_PREFERENCE_LIST',
3643: AValue => l_notification_pref_list);
3644:
3645: WF_ENGINE.SetItemAttrText(
3646: itemtype => itemtype,
3647: itemkey => itemkey,
3648: AName => 'LANGUAGE_LIST',
3649: AValue => l_language_list);
3654: l_notify_recipient := l_user;
3655:
3656: -- 11.5.10 enhancement to Create Interaction when email to contact sent.
3657: /* Roopa - begin bug 3360069 */
3658: /* Replacing the AddItemAttr() call with WF_Engine add, get and set calls
3659: to factor in the scenario where this attr already exists */
3660:
3661: IF ((l_contact_party_id IS NOT NULL) AND (l_contact_type <> 'EMPLOYEE')) THEN
3662:
3663: OPEN check_if_item_attr_exists_csr;
3664: FETCH check_if_item_attr_exists_csr into l_temp_contact_id_list;
3665:
3666: IF(check_if_item_attr_exists_csr%NOTFOUND) THEN
3667: WF_ENGINE.AddItemAttr( itemtype,
3668: itemkey,
3669: 'CONTACT_PARTY_ID_LIST',
3670: l_contact_party_id);
3671: ELSE
3668: itemkey,
3669: 'CONTACT_PARTY_ID_LIST',
3670: l_contact_party_id);
3671: ELSE
3672: WF_ENGINE.SetItemAttrText(
3673: itemtype => itemtype,
3674: itemkey => itemkey,
3675: aname => 'CONTACT_PARTY_ID_LIST',
3676: avalue => l_contact_party_id);
3684: CLOSE sel_jsp_name_csr;
3685:
3686: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3687: || '?srID=' || l_request_number;
3688: WF_ENGINE.SetItemAttrText(
3689: itemtype => itemtype,
3690: itemkey => itemkey,
3691: aname => 'NTFY_REQUEST_NUMBER_URL',
3692: avalue => l_serviceRequest_URL);
3704: OPEN c_check_html_notification;
3705: FETCH c_check_html_notification INTO l_html_notification_flag ;
3706: CLOSE c_check_html_notification;
3707:
3708: l_contact_point_id_list := WF_ENGINE.GetItemAttrText(
3709: itemtype => itemtype,
3710: itemkey => itemkey,
3711: aname => 'NEW_CONTACT_POINT_ID_LIST' );
3712:
3851: END IF ; -- end if for l_html_notification_flag
3852:
3853: IF l_html_notification_flag = 'Y' THEN
3854:
3855: WF_ENGINE.SetItemAttrText(
3856: itemtype => itemtype,
3857: itemkey => itemkey,
3858: AName => 'ADHOC_USER_LIST',
3859: AValue => l_html_adhoc_user_list);
3857: itemkey => itemkey,
3858: AName => 'ADHOC_USER_LIST',
3859: AValue => l_html_adhoc_user_list);
3860:
3861: WF_ENGINE.SetItemAttrText(
3862: itemtype => itemtype,
3863: itemkey => itemkey,
3864: AName => 'CONTACT_ID_LIST',
3865: AValue => l_contact_id_list);
3863: itemkey => itemkey,
3864: AName => 'CONTACT_ID_LIST',
3865: AValue => l_contact_id_list);
3866:
3867: WF_ENGINE.SetItemAttrText(
3868: itemtype => itemtype,
3869: itemkey => itemkey,
3870: AName => 'CONTACT_EMAIL_LIST',
3871: AValue => l_html_contact_email_list);
3869: itemkey => itemkey,
3870: AName => 'CONTACT_EMAIL_LIST',
3871: AValue => l_html_contact_email_list);
3872:
3873: WF_ENGINE.SetItemAttrText(
3874: itemtype => itemtype,
3875: itemkey => itemkey,
3876: AName => 'CONTACT_TYPE_LIST',
3877: AValue => l_contact_type_list);
3875: itemkey => itemkey,
3876: AName => 'CONTACT_TYPE_LIST',
3877: AValue => l_contact_type_list);
3878:
3879: WF_ENGINE.SetItemAttrText(
3880: itemtype => itemtype,
3881: itemkey => itemkey,
3882: AName => 'NOTIFICATION_PREFERENCE_LIST',
3883: AValue => l_notification_pref_list);
3881: itemkey => itemkey,
3882: AName => 'NOTIFICATION_PREFERENCE_LIST',
3883: AValue => l_notification_pref_list);
3884:
3885: WF_ENGINE.SetItemAttrText(
3886: itemtype => itemtype,
3887: itemkey => itemkey,
3888: AName => 'LANGUAGE_LIST',
3889: AValue => l_language_list);
3922: CLOSE sel_jsp_name_csr;
3923:
3924: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3925: || '?srID=' || l_request_number;
3926: WF_ENGINE.SetItemAttrText(
3927: itemtype => itemtype,
3928: itemkey => itemkey,
3929: aname => 'NTFY_REQUEST_NUMBER_URL',
3930: avalue => l_serviceRequest_URL);
3935:
3936:
3937: -- 11.5.10 enhancement to Create Interaction when email to contact sent.
3938: /* Roopa - begin bug 3360069 */
3939: /* Replacing the AddItemAttr() call with WF_Engine add, get and set calls
3940: to factor in the scenario where this attr already exists */
3941: IF (l_contact_party_id_list IS NOT NULL) THEN
3942:
3943: OPEN check_if_item_attr_exists_csr;
3943: OPEN check_if_item_attr_exists_csr;
3944: FETCH check_if_item_attr_exists_csr into l_temp_contact_id_list;
3945:
3946: IF(check_if_item_attr_exists_csr%NOTFOUND) THEN
3947: WF_ENGINE.AddItemAttr( itemtype,
3948: itemkey,
3949: 'CONTACT_PARTY_ID_LIST',
3950: l_contact_party_id_list);
3951: ELSE
3948: itemkey,
3949: 'CONTACT_PARTY_ID_LIST',
3950: l_contact_party_id_list);
3951: ELSE
3952: WF_ENGINE.SetItemAttrText(
3953: itemtype => itemtype,
3954: itemkey => itemkey,
3955: aname => 'CONTACT_PARTY_ID_LIST',
3956: avalue => l_contact_party_id_list);
3962:
3963: -- Start of code for Associated Party Notification -- Associated Party Added
3964: ELSIF (l_action_code = 'NOTIFY_NEW_ASSOCIATE_PARTY_ADD') THEN
3965:
3966: l_contact_point_id_list := WF_ENGINE.GetItemAttrText(
3967: itemtype => itemtype,
3968: itemkey => itemkey,
3969: aname => 'NEW_ASSOCIATED_PARTY_ID_LIST' );
3970:
3981: FETCH sel_new_party_role_contact_csr
3982: INTO l_contact_email, l_contact_party_id, l_person_id, l_contact_type, l_tmp_contact_point_id,
3983: l_party_role_name, l_party_role_code;
3984:
3985: WF_ENGINE.SetItemAttrText(
3986: itemtype => itemtype,
3987: itemkey => itemkey,
3988: aname => 'PARTY_ROLE_CODE',
3989: avalue => l_party_role_code);
3987: itemkey => itemkey,
3988: aname => 'PARTY_ROLE_CODE',
3989: avalue => l_party_role_code);
3990:
3991: WF_ENGINE.SetItemAttrText(
3992: itemtype => itemtype,
3993: itemkey => itemkey,
3994: aname => 'PARTY_ROLE_NAME',
3995: avalue => l_party_role_name);
4094: CLOSE sel_jsp_name_csr;
4095:
4096: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
4097: || '?srID=' || l_request_number;
4098: WF_ENGINE.SetItemAttrText(
4099: itemtype => itemtype,
4100: itemkey => itemkey,
4101: aname => 'NTFY_REQUEST_NUMBER_URL',
4102: avalue => l_serviceRequest_URL);
4109:
4110: END IF; -- IF (l_action_code = 'NOTIFY_OWNER' OR .......
4111:
4112: -- Get the message template to be used for the notification
4113: l_notification_template_id := WF_ENGINE.GetItemAttrText(
4114: itemtype => itemtype,
4115: itemkey => itemkey,
4116: aname => 'NTFY_MESSAGE_NAME');
4117:
4123: result := 'COMPLETE:SET';
4124: END IF;
4125:
4126: -- Set the recipient role for the notification
4127: WF_ENGINE.SetItemAttrText(
4128: itemtype => itemtype,
4129: itemkey => itemkey,
4130: aname => 'NTFY_RECIPIENT',
4131: avalue => l_notify_recipient);
4192: BEGIN
4193:
4194: IF (funmode = 'RUN') THEN
4195:
4196: l_contact_party_id_list := WF_ENGINE.GetItemAttrText(
4197: itemtype => itemtype,
4198: itemkey => itemkey,
4199: aname => 'CONTACT_PARTY_ID_LIST',
4200: ignore_notfound => TRUE);
4207:
4208: pull_from_list(itemlist => l_contact_party_id_list,
4209: element => l_element);
4210:
4211: WF_ENGINE.SetItemAttrText(
4212: itemtype => itemtype,
4213: itemkey => itemkey,
4214: aname => 'CONTACT_PARTY_ID_LIST',
4215: avalue => l_contact_party_id_list );
4215: avalue => l_contact_party_id_list );
4216:
4217: l_contact_party_id := TO_NUMBER(l_element);
4218:
4219: l_request_id := WF_ENGINE.GetItemAttrNumber(
4220: itemtype => itemtype,
4221: itemkey => itemkey,
4222: aname => 'REQUEST_ID' );
4223: l_request_number := WF_ENGINE.GetItemAttrText(
4219: l_request_id := WF_ENGINE.GetItemAttrNumber(
4220: itemtype => itemtype,
4221: itemkey => itemkey,
4222: aname => 'REQUEST_ID' );
4223: l_request_number := WF_ENGINE.GetItemAttrText(
4224: itemtype => itemtype,
4225: itemkey => itemkey,
4226: aname => 'REQUEST_NUMBER' );
4227: l_user_id := WF_ENGINE.GetItemAttrNumber(
4223: l_request_number := WF_ENGINE.GetItemAttrText(
4224: itemtype => itemtype,
4225: itemkey => itemkey,
4226: aname => 'REQUEST_NUMBER' );
4227: l_user_id := WF_ENGINE.GetItemAttrNumber(
4228: itemtype => itemtype,
4229: itemkey => itemkey,
4230: aname => 'USER_ID' );
4231: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(
4227: l_user_id := WF_ENGINE.GetItemAttrNumber(
4228: itemtype => itemtype,
4229: itemkey => itemkey,
4230: aname => 'USER_ID' );
4231: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(
4232: itemtype => itemtype,
4233: itemkey => itemkey,
4234: aname => 'RESP_APPL_ID' );
4235: l_resp_id := WF_ENGINE.GetItemAttrNumber(
4231: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(
4232: itemtype => itemtype,
4233: itemkey => itemkey,
4234: aname => 'RESP_APPL_ID' );
4235: l_resp_id := WF_ENGINE.GetItemAttrNumber(
4236: itemtype => itemtype,
4237: itemkey => itemkey,
4238: aname => 'RESP_ID' );
4239:
4236: itemtype => itemtype,
4237: itemkey => itemkey,
4238: aname => 'RESP_ID' );
4239:
4240: l_owner_role := WF_ENGINE.GetItemAttrText(
4241: itemtype => itemtype,
4242: itemkey => itemkey,
4243: aname => 'OWNER_ROLE' );
4244:
4279: l_error_text := l_error_text || x_msg_data ||NL;
4280: END LOOP;
4281: END IF;
4282:
4283: WF_ENGINE.SetItemAttrText(
4284: itemtype => itemtype,
4285: itemkey => itemkey,
4286: aname => 'INTERACTION_ERR_DATA',
4287: avalue => l_error_text );
4289: OPEN sel_contact_party_name_csr;
4290: FETCH sel_contact_party_name_csr INTO l_contact_party_name;
4291: CLOSE sel_contact_party_name_csr;
4292:
4293: WF_ENGINE.SetItemAttrText(
4294: itemtype => itemtype,
4295: itemkey => itemkey,
4296: aname => 'INTERACTION_PARTY_NAME',
4297: avalue => l_contact_party_name );
4301: l_error_role := l_owner_role;
4302: ELSE
4303: l_error_role := 'SYSADMIN';
4304: END IF;
4305: WF_ENGINE.SetItemAttrText(
4306: itemtype => itemtype,
4307: itemkey => itemkey,
4308: aname => 'INTERACTION_ERROR_ROLE',
4309: avalue => l_error_role );
4347: BEGIN
4348:
4349: IF (funmode = 'RUN') THEN
4350:
4351: l_contact_party_id_list := WF_ENGINE.GetItemAttrText(
4352: itemtype => itemtype,
4353: itemkey => itemkey,
4354: aname => 'CONTACT_PARTY_ID_LIST',
4355: ignore_notfound => TRUE);
4453: BEGIN
4454:
4455: IF (funmode = 'RUN') THEN
4456:
4457: l_action_code := WF_ENGINE.GetItemAttrText(
4458: itemtype => itemtype,
4459: itemkey => itemkey,
4460: aname => 'NTFY_ACTION_CODE' );
4461:
4462: IF (l_action_code = 'NOTIFY_OWNER_OF_RELATED_SR') OR
4463: (l_action_code = 'NOTIFY_PRIM_CONTACT_OF_REL_SR') OR
4464: (l_action_code = 'NOTIFY_ALL_CONTACTS_OF_REL_SR') THEN
4465:
4466: l_linked_subject_list := WF_ENGINE.GetItemAttrText(
4467: itemtype => itemtype,
4468: itemkey => itemkey,
4469: aname => 'NTFY_LINKED_SUBJECT_LIST');
4470:
4473: result := 'COMPLETE:N';
4474:
4475: ELSE
4476:
4477: l_overflow_flag := WF_ENGINE.GetItemAttrText(
4478: itemtype => itemtype,
4479: itemkey => itemkey,
4480: aname => 'MORE_NTFY_LINKED_SUBJECT_LIST');
4481:
4481:
4482: IF (l_overflow_flag = 'Y') THEN
4483:
4484: -- Reset the Overflow flag
4485: WF_ENGINE.SetItemAttrText(
4486: itemtype => itemtype,
4487: itemkey => itemkey,
4488: aname => 'MORE_NTFY_LINKED_SUBJECT_LIST',
4489: avalue => '' );
4487: itemkey => itemkey,
4488: aname => 'MORE_NTFY_LINKED_SUBJECT_LIST',
4489: avalue => '' );
4490:
4491: l_event_condition_id := WF_ENGINE.GetItemAttrNumber(
4492: itemtype => itemtype,
4493: itemkey => itemkey,
4494: aname => 'NTFY_EVENT_CONDITION_ID' );
4495:
4492: itemtype => itemtype,
4493: itemkey => itemkey,
4494: aname => 'NTFY_EVENT_CONDITION_ID' );
4495:
4496: l_subject_id := WF_ENGINE.GetItemAttrNumber(
4497: itemtype => itemtype,
4498: itemkey => itemkey,
4499: aname => 'NTFY_SUBJECT_ID');
4500:
4497: itemtype => itemtype,
4498: itemkey => itemkey,
4499: aname => 'NTFY_SUBJECT_ID');
4500:
4501: l_request_number := WF_ENGINE.GetItemAttrText(
4502: itemtype => itemtype,
4503: itemkey => itemkey,
4504: aname => 'REQUEST_NUMBER' );
4505:
4502: itemtype => itemtype,
4503: itemkey => itemkey,
4504: aname => 'REQUEST_NUMBER' );
4505:
4506: l_request_id := WF_ENGINE.GetItemAttrNumber(
4507: itemtype => itemtype,
4508: itemkey => itemkey,
4509: aname => 'REQUEST_ID' );
4510:
4533: ELSE
4534: l_linked_subject_list := l_linked_subject_list || ' ' || l_char_subject_id;
4535: END IF;
4536: ELSE /**** Will need to build another list later since it won't fit here ***/
4537: WF_ENGINE.SetItemAttrText(
4538: itemtype => itemtype,
4539: itemkey => itemkey,
4540: aname => 'MORE_NTFY_LINKED_SUBJECT_LIST',
4541: avalue => 'Y' );
4551: END IF;
4552:
4553: IF (l_linked_subject_list IS NOT NULL) THEN
4554:
4555: WF_ENGINE.SetItemAttrText(
4556: itemtype => itemtype,
4557: itemkey => itemkey,
4558: aname => 'NTFY_LINKED_SUBJECT_LIST',
4559: avalue => l_linked_subject_list );
4569: END IF; /*** IF (l_linked_subject_list IS NOT NULL) ***/
4570:
4571: ELSIF (l_action_code = 'NOTIFY_ALL_ASSOCIATED_PARTIES') THEN
4572:
4573: l_notify_relsr_party_role_list := WF_ENGINE.GetItemAttrText(
4574: itemtype => itemtype,
4575: itemkey => itemkey,
4576: aname => 'NOTIFY_RELSR_PARTY_ROLE_LIST');
4577:
4574: itemtype => itemtype,
4575: itemkey => itemkey,
4576: aname => 'NOTIFY_RELSR_PARTY_ROLE_LIST');
4577:
4578: l_linked_subject_list := WF_ENGINE.GetItemAttrText(
4579: itemtype => itemtype,
4580: itemkey => itemkey,
4581: aname => 'NTFY_LINKED_SUBJECT_LIST');
4582:
4585: result := 'COMPLETE:N';
4586:
4587: ELSE
4588:
4589: l_overflow_flag := WF_ENGINE.GetItemAttrText(
4590: itemtype => itemtype,
4591: itemkey => itemkey,
4592: aname => 'MORE_NTFY_LINKED_SUBJECT_LIST');
4593:
4593:
4594: IF (l_overflow_flag = 'Y') THEN
4595:
4596: -- Reset the Overflow flag
4597: WF_ENGINE.SetItemAttrText(
4598: itemtype => itemtype,
4599: itemkey => itemkey,
4600: aname => 'MORE_NTFY_LINKED_SUBJECT_LIST',
4601: avalue => '' );
4599: itemkey => itemkey,
4600: aname => 'MORE_NTFY_LINKED_SUBJECT_LIST',
4601: avalue => '' );
4602:
4603: l_event_condition_id := WF_ENGINE.GetItemAttrNumber(
4604: itemtype => itemtype,
4605: itemkey => itemkey,
4606: aname => 'NTFY_EVENT_CONDITION_ID' );
4607:
4604: itemtype => itemtype,
4605: itemkey => itemkey,
4606: aname => 'NTFY_EVENT_CONDITION_ID' );
4607:
4608: l_subject_id := WF_ENGINE.GetItemAttrNumber(
4609: itemtype => itemtype,
4610: itemkey => itemkey,
4611: aname => 'NTFY_SUBJECT_ID');
4612:
4609: itemtype => itemtype,
4610: itemkey => itemkey,
4611: aname => 'NTFY_SUBJECT_ID');
4612:
4613: l_request_number := WF_ENGINE.GetItemAttrText(
4614: itemtype => itemtype,
4615: itemkey => itemkey,
4616: aname => 'REQUEST_NUMBER' );
4617:
4614: itemtype => itemtype,
4615: itemkey => itemkey,
4616: aname => 'REQUEST_NUMBER' );
4617:
4618: l_request_id := WF_ENGINE.GetItemAttrNumber(
4619: itemtype => itemtype,
4620: itemkey => itemkey,
4621: aname => 'REQUEST_ID' );
4622:
4645: ELSE
4646: l_linked_subject_list := l_linked_subject_list || ' ' || l_char_subject_id;
4647: END IF;
4648: ELSE /**** Will need to build another list later since it won't fit here ***/
4649: WF_ENGINE.SetItemAttrText(
4650: itemtype => itemtype,
4651: itemkey => itemkey,
4652: aname => 'MORE_NTFY_LINKED_SUBJECT_LIST',
4653: avalue => 'Y' );
4663: END IF;
4664:
4665: IF (l_linked_subject_list IS NOT NULL) THEN
4666:
4667: WF_ENGINE.SetItemAttrText(
4668: itemtype => itemtype,
4669: itemkey => itemkey,
4670: aname => 'NTFY_LINKED_SUBJECT_LIST',
4671: avalue => l_linked_subject_list );
4680:
4681: END IF; /*** IF (l_linked_subject_list IS NOT NULL) ***/
4682:
4683: ELSIF (l_action_code = 'NOTIFY_ASSOCIATED_PARTIES') THEN
4684: l_notify_party_role_list := WF_ENGINE.GetItemAttrText(
4685: itemtype => itemtype,
4686: itemkey => itemkey,
4687: aname => 'NOTIFY_PARTY_ROLE_LIST');
4688:
4764: BEGIN
4765:
4766: IF (funmode = 'RUN') THEN
4767:
4768: l_notify_conditions_list := WF_ENGINE.GetItemAttrText(
4769: itemtype => itemtype,
4770: itemkey => itemkey,
4771: aname => 'NTFY_CONDITION_LIST' );
4772:
4769: itemtype => itemtype,
4770: itemkey => itemkey,
4771: aname => 'NTFY_CONDITION_LIST' );
4772:
4773: l_notify_actions_list := WF_ENGINE.GetItemAttrText(
4774: itemtype => itemtype,
4775: itemkey => itemkey,
4776: aname => 'NTFY_ACTION_LIST' );
4777:
4778: IF (l_notify_conditions_list IS NOT NULL AND l_notify_actions_list IS NOT NULL) THEN
4779: result := 'COMPLETE:N';
4780: ELSE
4781:
4782: l_overflow_flag := WF_ENGINE.GetItemAttrText(
4783: itemtype => itemtype,
4784: itemkey => itemkey,
4785: aname => 'MORE_NTFY_ACTION_LIST');
4786:
4786:
4787: IF (l_overflow_flag = 'Y') THEN
4788:
4789: -- Reset the Overflow flag
4790: WF_ENGINE.SetItemAttrText(
4791: itemtype => itemtype,
4792: itemkey => itemkey,
4793: aname => 'MORE_NTFY_ACTION_LIST',
4794: avalue => '' );
4792: itemkey => itemkey,
4793: aname => 'MORE_NTFY_ACTION_LIST',
4794: avalue => '' );
4795:
4796: l_event_condition_id := WF_ENGINE.GetItemAttrNumber(
4797: itemtype => itemtype,
4798: itemkey => itemkey,
4799: aname => 'NTFY_EVENT_CONDITION_ID');
4800: l_action_code := WF_ENGINE.GetItemAttrText(
4796: l_event_condition_id := WF_ENGINE.GetItemAttrNumber(
4797: itemtype => itemtype,
4798: itemkey => itemkey,
4799: aname => 'NTFY_EVENT_CONDITION_ID');
4800: l_action_code := WF_ENGINE.GetItemAttrText(
4801: itemtype => itemtype,
4802: itemkey => itemkey,
4803: aname => 'NTFY_ACTION_CODE');
4804: l_event_name := WF_ENGINE.GetItemAttrText(
4800: l_action_code := WF_ENGINE.GetItemAttrText(
4801: itemtype => itemtype,
4802: itemkey => itemkey,
4803: aname => 'NTFY_ACTION_CODE');
4804: l_event_name := WF_ENGINE.GetItemAttrText(
4805: itemtype => itemtype,
4806: itemkey => itemkey,
4807: aname => 'EVENTNAME' );
4808:
4825: l_notify_actions_list := l_notify_actions_list || ' ' || sel_action_rec.action_code;
4826: END IF;
4827: ELSE
4828:
4829: WF_ENGINE.SetItemAttrText(
4830: itemtype => itemtype,
4831: itemkey => itemkey,
4832: aname => 'MORE_NTFY_ACTION_LIST',
4833: avalue => 'Y' );
4838: CLOSE sel_action_csr;
4839:
4840: IF (l_notify_conditions_list IS NOT NULL AND l_notify_actions_list IS NOT NULL) THEN
4841:
4842: WF_ENGINE.SetItemAttrText(
4843: itemtype => itemtype,
4844: itemkey => itemkey,
4845: aname => 'NTFY_CONDITION_LIST',
4846: avalue => l_notify_conditions_list );
4843: itemtype => itemtype,
4844: itemkey => itemkey,
4845: aname => 'NTFY_CONDITION_LIST',
4846: avalue => l_notify_conditions_list );
4847: WF_ENGINE.SetItemAttrText(
4848: itemtype => itemtype,
4849: itemkey => itemkey,
4850: aname => 'NTFY_ACTION_LIST',
4851: avalue => l_notify_actions_list );
4916: BEGIN
4917:
4918: IF (funmode = 'RUN') THEN
4919:
4920: l_update_conditions_list := WF_ENGINE.GetItemAttrText(
4921: itemtype => itemtype,
4922: itemkey => itemkey,
4923: aname => 'UPDATE_CONDITION_LIST' );
4924:
4921: itemtype => itemtype,
4922: itemkey => itemkey,
4923: aname => 'UPDATE_CONDITION_LIST' );
4924:
4925: l_update_actions_list := WF_ENGINE.GetItemAttrText(
4926: itemtype => itemtype,
4927: itemkey => itemkey,
4928: aname => 'UPDATE_ACTION_LIST' );
4929:
4936: pull_from_list(itemlist => l_update_actions_list,
4937: element => l_action_code);
4938:
4939: IF (l_event_condition_id IS NOT NULL AND l_action_code IS NOT NULL) THEN
4940: WF_ENGINE.SetItemAttrText(
4941: itemtype => itemtype,
4942: itemkey => itemkey,
4943: aname => 'UPDATE_CONDITION_LIST',
4944: avalue => l_update_conditions_list );
4941: itemtype => itemtype,
4942: itemkey => itemkey,
4943: aname => 'UPDATE_CONDITION_LIST',
4944: avalue => l_update_conditions_list );
4945: WF_ENGINE.SetItemAttrText(
4946: itemtype => itemtype,
4947: itemkey => itemkey,
4948: aname => 'UPDATE_ACTION_LIST',
4949: avalue => l_update_actions_list );
4946: itemtype => itemtype,
4947: itemkey => itemkey,
4948: aname => 'UPDATE_ACTION_LIST',
4949: avalue => l_update_actions_list );
4950: WF_ENGINE.SetItemAttrNumber(
4951: itemtype => itemtype,
4952: itemkey => itemkey,
4953: aname => 'UPDATE_EVENT_CONDITION_ID',
4954: avalue => l_event_condition_id );
4951: itemtype => itemtype,
4952: itemkey => itemkey,
4953: aname => 'UPDATE_EVENT_CONDITION_ID',
4954: avalue => l_event_condition_id );
4955: WF_ENGINE.SetItemAttrText(
4956: itemtype => itemtype,
4957: itemkey => itemkey,
4958: aname => 'UPDATE_ACTION_CODE',
4959: avalue => l_action_code );
5068: BEGIN
5069:
5070: IF (funmode = 'RUN') THEN
5071:
5072: l_request_number := WF_ENGINE.GetItemAttrText(
5073: itemtype => itemtype,
5074: itemkey => itemkey,
5075: aname => 'REQUEST_NUMBER' );
5076:
5073: itemtype => itemtype,
5074: itemkey => itemkey,
5075: aname => 'REQUEST_NUMBER' );
5076:
5077: l_request_id := WF_ENGINE.GetItemAttrNumber(
5078: itemtype => itemtype,
5079: itemkey => itemkey,
5080: aname => 'REQUEST_ID' );
5081:
5078: itemtype => itemtype,
5079: itemkey => itemkey,
5080: aname => 'REQUEST_ID' );
5081:
5082: l_event_name := WF_ENGINE.GetItemAttrText(
5083: itemtype => itemtype,
5084: itemkey => itemkey,
5085: aname => 'EVENTNAME' );
5086:
5083: itemtype => itemtype,
5084: itemkey => itemkey,
5085: aname => 'EVENTNAME' );
5086:
5087: l_event_condition_id := WF_ENGINE.GetItemAttrNumber(
5088: itemtype => itemtype,
5089: itemkey => itemkey,
5090: aname => 'UPDATE_EVENT_CONDITION_ID' );
5091:
5088: itemtype => itemtype,
5089: itemkey => itemkey,
5090: aname => 'UPDATE_EVENT_CONDITION_ID' );
5091:
5092: l_action_code := WF_ENGINE.GetItemAttrText(
5093: itemtype => itemtype,
5094: itemkey => itemkey,
5095: aname => 'UPDATE_ACTION_CODE' );
5096:
5101: IF (sel_event_action_rec.from_to_status_code IS NOT NULL) THEN
5102: --bug 11679421
5103: --Replaced REQUEST_STATUS with REQUEST_STATUS_NEW
5104: IF (sel_event_action_rec.from_to_status_code = 'STATUS_CHANGED_TO') THEN
5105: l_request_status := WF_ENGINE.GetItemAttrText(
5106: itemtype => itemtype,
5107: itemkey => itemkey,
5108: aname => 'REQUEST_STATUS_NEW' );--bug 11679421
5109:
5107: itemkey => itemkey,
5108: aname => 'REQUEST_STATUS_NEW' );--bug 11679421
5109:
5110: ELSIF (sel_event_action_rec.from_to_status_code = 'STATUS_CHANGED_FROM') THEN
5111: l_request_status := WF_ENGINE.GetItemAttrText(
5112: itemtype => itemtype,
5113: itemkey => itemkey,
5114: aname => 'REQUEST_STATUS_OLD' );
5115: END IF;
5119: FROM CS_INCIDENT_STATUSES_VL
5120: WHERE INCIDENT_STATUS_ID = sel_event_action_rec.trigger_incident_status_id;
5121:
5122: IF (l_request_status = l_request_status_temp) THEN
5123: WF_ENGINE.SetItemAttrNumber(
5124: itemtype => itemtype,
5125: itemkey => itemkey,
5126: aname => 'SUBJECT_STATUS_ID',
5127: avalue => sel_event_action_rec.detail_incident_status_id );
5126: aname => 'SUBJECT_STATUS_ID',
5127: avalue => sel_event_action_rec.detail_incident_status_id );
5128:
5129: ELSE
5130: WF_ENGINE.SetItemAttrText(
5131: itemtype => itemtype,
5132: itemkey => itemkey,
5133: aname => 'SUBJECT_STATUS_ID',
5134: avalue => NULL);
5137: l_relationship_type_id := sel_event_action_rec.detail_link_type;
5138:
5139:
5140: ELSIF (sel_event_action_rec.trigger_link_type IS NOT NULL) THEN
5141: WF_ENGINE.SetItemAttrNumber(
5142: itemtype => itemtype,
5143: itemkey => itemkey,
5144: aname => 'SUBJECT_STATUS_ID',
5145: avalue => sel_event_action_rec.detail_incident_status_id );
5143: itemkey => itemkey,
5144: aname => 'SUBJECT_STATUS_ID',
5145: avalue => sel_event_action_rec.detail_incident_status_id );
5146:
5147: WF_ENGINE.SetItemAttrText(
5148: itemtype => itemtype,
5149: itemkey => itemkey,
5150: aname => 'SUBJECT_RESOLUTION_CODE',
5151: avalue => sel_event_action_rec.resolution_code );
5159: INTO l_relationship_type_name
5160: FROM CS_SR_LINK_TYPES_VL
5161: WHERE link_type_id = l_relationship_type_id;
5162:
5163: WF_ENGINE.SetItemAttrText(
5164: itemtype => itemtype,
5165: itemkey => itemkey,
5166: aname => 'UPDATE_RELATIONSHIP_TYPE',
5167: avalue => l_relationship_type_name);
5183: l_linked_subject_list := l_linked_subject_list || ' ' || l_subject_id;
5184: END IF;
5185: ELSE
5186:
5187: WF_ENGINE.SetItemAttrText(
5188: itemtype => itemtype,
5189: itemkey => itemkey,
5190: aname => 'MORE_UPDT_LINKED_SUBJECT_LIST',
5191: avalue => 'Y' );
5196: END LOOP;
5197: CLOSE sel_link_csr;
5198:
5199: IF (l_linked_subject_list IS NOT NULL) THEN
5200: WF_ENGINE.SetItemAttrText(
5201: itemtype => itemtype,
5202: itemkey => itemkey,
5203: aname => 'UPDATE_LINKED_SUBJECT_LIST',
5204: avalue => l_linked_subject_list );
5248: BEGIN
5249:
5250: IF (funmode = 'RUN') THEN
5251:
5252: l_linked_subject_list := WF_ENGINE.GetItemAttrText(
5253: itemtype => itemtype,
5254: itemkey => itemkey,
5255: aname => 'UPDATE_LINKED_SUBJECT_LIST' );
5256:
5256:
5257: pull_from_list(itemlist => l_linked_subject_list,
5258: element => l_element);
5259:
5260: WF_ENGINE.SetItemAttrNumber(
5261: itemtype => itemtype,
5262: itemkey => itemkey,
5263: aname => 'UPDATE_SUBJECT_ID',
5264: avalue => TO_NUMBER(l_element) );
5262: itemkey => itemkey,
5263: aname => 'UPDATE_SUBJECT_ID',
5264: avalue => TO_NUMBER(l_element) );
5265:
5266: WF_ENGINE.SetItemAttrText(
5267: itemtype => itemtype,
5268: itemkey => itemkey,
5269: aname => 'UPDATE_LINKED_SUBJECT_LIST',
5270: avalue => l_linked_subject_list );
5351:
5352: IF (funmode = 'RUN') THEN
5353:
5354: -- SUBJECT_STATUS_ID can be null when updating resolution code . Update Rule #3.
5355: l_subject_status_id := WF_ENGINE.GetItemAttrNumber(
5356: itemtype => itemtype,
5357: itemkey => itemkey,
5358: aname => 'SUBJECT_STATUS_ID' );
5359:
5358: aname => 'SUBJECT_STATUS_ID' );
5359:
5360: --l_err_txt := 'Valid1';
5361:
5362: l_resolution_code := WF_ENGINE.GetItemAttrText(
5363: itemtype => itemtype,
5364: itemkey => itemkey,
5365: aname => 'SUBJECT_RESOLUTION_CODE' );
5366:
5368: result := 'COMPLETE:N';
5369:
5370: ELSE
5371:
5372: l_subject_id := WF_ENGINE.GetItemAttrNumber(
5373: itemtype => itemtype,
5374: itemkey => itemkey,
5375: aname => 'UPDATE_SUBJECT_ID' );
5376:
5373: itemtype => itemtype,
5374: itemkey => itemkey,
5375: aname => 'UPDATE_SUBJECT_ID' );
5376:
5377: l_action_code := WF_ENGINE.GetItemAttrText(
5378: itemtype => itemtype,
5379: itemkey => itemkey,
5380: aname => 'UPDATE_ACTION_CODE' );
5381:
5379: itemkey => itemkey,
5380: aname => 'UPDATE_ACTION_CODE' );
5381:
5382: IF (l_action_code = 'CHANGE_SR_STATUS' OR l_action_code = 'CHANGE_SR_RESOLUTION') THEN
5383: l_sr_updated := WF_ENGINE.GetItemAttrNumber(
5384: itemtype => itemtype,
5385: itemkey => itemkey,
5386: aname => 'REQUEST_ID' );
5387: ELSIF (l_action_code = 'CHANGE_RELATED_SR_STATUS') THEN
5552:
5553:
5554: CS_ServiceRequest_PVT.initialize_rec(l_service_request_rec);
5555:
5556: l_action_code := WF_ENGINE.GetItemAttrText(
5557: itemtype => itemtype,
5558: itemkey => itemkey,
5559: aname => 'UPDATE_ACTION_CODE' );
5560:
5557: itemtype => itemtype,
5558: itemkey => itemkey,
5559: aname => 'UPDATE_ACTION_CODE' );
5560:
5561: l_request_number := WF_ENGINE.GetItemAttrText(
5562: itemtype => itemtype,
5563: itemkey => itemkey,
5564: aname => 'REQUEST_NUMBER' );
5565:
5562: itemtype => itemtype,
5563: itemkey => itemkey,
5564: aname => 'REQUEST_NUMBER' );
5565:
5566: l_user_id := WF_ENGINE.GetItemAttrNumber(
5567: itemtype => itemtype,
5568: itemkey => itemkey,
5569: aname => 'USER_ID' );
5570:
5567: itemtype => itemtype,
5568: itemkey => itemkey,
5569: aname => 'USER_ID' );
5570:
5571: l_subject_status_id := WF_ENGINE.GetItemAttrNumber(
5572: itemtype => itemtype,
5573: itemkey => itemkey,
5574: aname => 'SUBJECT_STATUS_ID' );
5575:
5572: itemtype => itemtype,
5573: itemkey => itemkey,
5574: aname => 'SUBJECT_STATUS_ID' );
5575:
5576: l_resolution_code := WF_ENGINE.GetItemAttrText(
5577: itemtype => itemtype,
5578: itemkey => itemkey,
5579: aname => 'SUBJECT_RESOLUTION_CODE' );
5580:
5577: itemtype => itemtype,
5578: itemkey => itemkey,
5579: aname => 'SUBJECT_RESOLUTION_CODE' );
5580:
5581: l_subject_id := WF_ENGINE.GetItemAttrNumber(
5582: itemtype => itemtype,
5583: itemkey => itemkey,
5584: aname => 'UPDATE_SUBJECT_ID' );
5585:
5624: l_service_request_rec.last_update_program_code := 'SUPPORT.WF';
5625:
5626: --l_wf_process_id := TO_NUMBER(substr(itemkey, instr(itemkey,'-')+1));
5627:
5628: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(
5629: itemtype => itemtype,
5630: itemkey => itemkey,
5631: aname => 'RESP_APPL_ID' );
5632: l_resp_id := WF_ENGINE.GetItemAttrNumber(
5628: l_resp_appl_id := WF_ENGINE.GetItemAttrNumber(
5629: itemtype => itemtype,
5630: itemkey => itemkey,
5631: aname => 'RESP_APPL_ID' );
5632: l_resp_id := WF_ENGINE.GetItemAttrNumber(
5633: itemtype => itemtype,
5634: itemkey => itemkey,
5635: aname => 'RESP_ID' );
5636:
5685: END LOOP;
5686: END IF;
5687:
5688:
5689: WF_ENGINE.SetItemAttrText(
5690: itemtype => itemtype,
5691: itemkey => itemkey,
5692: aname => 'UPDATE_ERROR_DATA',
5693: avalue => l_error_text );
5765: BEGIN
5766:
5767: IF (funmode = 'RUN') THEN
5768:
5769: l_action_code := WF_ENGINE.GetItemAttrText(
5770: itemtype => itemtype,
5771: itemkey => itemkey,
5772: aname => 'UPDATE_ACTION_CODE' );
5773:
5770: itemtype => itemtype,
5771: itemkey => itemkey,
5772: aname => 'UPDATE_ACTION_CODE' );
5773:
5774: l_request_number := WF_ENGINE.GetItemAttrText(
5775: itemtype => itemtype,
5776: itemkey => itemkey,
5777: aname => 'REQUEST_NUMBER' );
5778:
5775: itemtype => itemtype,
5776: itemkey => itemkey,
5777: aname => 'REQUEST_NUMBER' );
5778:
5779: l_subject_id := WF_ENGINE.GetItemAttrNumber(
5780: itemtype => itemtype,
5781: itemkey => itemkey,
5782: aname => 'UPDATE_SUBJECT_ID' );
5783:
5782: aname => 'UPDATE_SUBJECT_ID' );
5783:
5784: IF (l_action_code = 'CHANGE_SR_STATUS' OR l_action_code = 'CHANGE_SR_RESOLUTION') THEN
5785:
5786: l_owner_role := WF_ENGINE.GetItemAttrText(
5787: itemtype => itemtype,
5788: itemkey => itemkey,
5789: aname => 'OWNER_ROLE' );
5790:
5825: END IF;
5826:
5827: If (l_owner_role IS NOT NULL) THEN
5828:
5829: WF_ENGINE.SetItemAttrText(
5830: itemtype => itemtype,
5831: itemkey => itemkey,
5832: aname => 'UPDATE_REQUEST_ROLE',
5833: avalue => l_owner_role );
5831: itemkey => itemkey,
5832: aname => 'UPDATE_REQUEST_ROLE',
5833: avalue => l_owner_role );
5834:
5835: WF_ENGINE.SetItemAttrText(
5836: itemtype => itemtype,
5837: itemkey => itemkey,
5838: aname => 'UPDATE_REQUEST_NUMBER',
5839: avalue => l_request_number );
5910: BEGIN
5911:
5912: IF (funmode = 'RUN') THEN
5913:
5914: l_linked_subject_list := WF_ENGINE.GetItemAttrText(
5915: itemtype => itemtype,
5916: itemkey => itemkey,
5917: aname => 'UPDATE_LINKED_SUBJECT_LIST' );
5918:
5919: IF (l_linked_subject_list IS NOT NULL) THEN
5920: result := 'COMPLETE:N';
5921: ELSE
5922:
5923: l_overflow_flag := WF_ENGINE.GetItemAttrText(
5924: itemtype => itemtype,
5925: itemkey => itemkey,
5926: aname => 'MORE_UPDT_LINKED_SUBJECT_LIST');
5927:
5927:
5928: IF (l_overflow_flag = 'Y') THEN
5929:
5930: -- Reset the Overflow flag
5931: WF_ENGINE.SetItemAttrText(
5932: itemtype => itemtype,
5933: itemkey => itemkey,
5934: aname => 'MORE_UPDT_LINKED_SUBJECT_LIST',
5935: avalue => '' );
5933: itemkey => itemkey,
5934: aname => 'MORE_UPDT_LINKED_SUBJECT_LIST',
5935: avalue => '' );
5936:
5937: l_request_number := WF_ENGINE.GetItemAttrText(
5938: itemtype => itemtype,
5939: itemkey => itemkey,
5940: aname => 'REQUEST_NUMBER' );
5941: l_request_id := WF_ENGINE.GetItemAttrNumber(
5937: l_request_number := WF_ENGINE.GetItemAttrText(
5938: itemtype => itemtype,
5939: itemkey => itemkey,
5940: aname => 'REQUEST_NUMBER' );
5941: l_request_id := WF_ENGINE.GetItemAttrNumber(
5942: itemtype => itemtype,
5943: itemkey => itemkey,
5944: aname => 'REQUEST_ID' );
5945: l_relationship_type_name := WF_ENGINE.GetItemAttrText(
5941: l_request_id := WF_ENGINE.GetItemAttrNumber(
5942: itemtype => itemtype,
5943: itemkey => itemkey,
5944: aname => 'REQUEST_ID' );
5945: l_relationship_type_name := WF_ENGINE.GetItemAttrText(
5946: itemtype => itemtype,
5947: itemkey => itemkey,
5948: aname => 'UPDATE_RELATIONSHIP_TYPE');
5949: l_subject_id := WF_ENGINE.GetItemAttrNumber(
5945: l_relationship_type_name := WF_ENGINE.GetItemAttrText(
5946: itemtype => itemtype,
5947: itemkey => itemkey,
5948: aname => 'UPDATE_RELATIONSHIP_TYPE');
5949: l_subject_id := WF_ENGINE.GetItemAttrNumber(
5950: itemtype => itemtype,
5951: itemkey => itemkey,
5952: aname => 'UPDATE_SUBJECT_ID');
5953:
5965: ELSE
5966: l_linked_subject_list := l_linked_subject_list || ' ' || l_char_subject_id;
5967: END IF;
5968: ELSE
5969: WF_ENGINE.SetItemAttrText(
5970: itemtype => itemtype,
5971: itemkey => itemkey,
5972: aname => 'MORE_UPDT_LINKED_SUBJECT_LIST',
5973: avalue => 'Y' );
5978: END LOOP;
5979: CLOSE sel_link_csr;
5980:
5981: IF (l_linked_subject_list IS NOT NULL) THEN
5982: WF_ENGINE.SetItemAttrText(
5983: itemtype => itemtype,
5984: itemkey => itemkey,
5985: aname => 'UPDATE_LINKED_SUBJECT_LIST',
5986: avalue => l_linked_subject_list );
6099: BEGIN
6100:
6101: IF (funmode = 'RUN') THEN
6102:
6103: l_update_conditions_list := WF_ENGINE.GetItemAttrText(
6104: itemtype => itemtype,
6105: itemkey => itemkey,
6106: aname => 'UPDATE_CONDITION_LIST' );
6107:
6104: itemtype => itemtype,
6105: itemkey => itemkey,
6106: aname => 'UPDATE_CONDITION_LIST' );
6107:
6108: l_update_actions_list := WF_ENGINE.GetItemAttrText(
6109: itemtype => itemtype,
6110: itemkey => itemkey,
6111: aname => 'UPDATE_ACTION_LIST' );
6112:
6113: IF (l_update_conditions_list IS NOT NULL AND l_update_actions_list IS NOT NULL) THEN
6114: result := 'COMPLETE:N';
6115: ELSE
6116:
6117: l_overflow_flag := WF_ENGINE.GetItemAttrText(
6118: itemtype => itemtype,
6119: itemkey => itemkey,
6120: aname => 'MORE_UPDATE_ACTION_LIST');
6121:
6121:
6122: IF (l_overflow_flag = 'Y') THEN
6123:
6124: -- Reset the Overflow flag
6125: WF_ENGINE.SetItemAttrText(
6126: itemtype => itemtype,
6127: itemkey => itemkey,
6128: aname => 'MORE_UPDATE_ACTION_LIST',
6129: avalue => '' );
6127: itemkey => itemkey,
6128: aname => 'MORE_UPDATE_ACTION_LIST',
6129: avalue => '' );
6130:
6131: l_event_condition_id := WF_ENGINE.GetItemAttrNumber(
6132: itemtype => itemtype,
6133: itemkey => itemkey,
6134: aname => 'UPDATE_EVENT_CONDITION_ID');
6135: l_action_code := WF_ENGINE.GetItemAttrText(
6131: l_event_condition_id := WF_ENGINE.GetItemAttrNumber(
6132: itemtype => itemtype,
6133: itemkey => itemkey,
6134: aname => 'UPDATE_EVENT_CONDITION_ID');
6135: l_action_code := WF_ENGINE.GetItemAttrText(
6136: itemtype => itemtype,
6137: itemkey => itemkey,
6138: aname => 'UPDATE_ACTION_CODE');
6139: l_event_name := WF_ENGINE.GetItemAttrText(
6135: l_action_code := WF_ENGINE.GetItemAttrText(
6136: itemtype => itemtype,
6137: itemkey => itemkey,
6138: aname => 'UPDATE_ACTION_CODE');
6139: l_event_name := WF_ENGINE.GetItemAttrText(
6140: itemtype => itemtype,
6141: itemkey => itemkey,
6142: aname => 'EVENTNAME' );
6143: l_request_number := WF_ENGINE.GetItemAttrText(
6139: l_event_name := WF_ENGINE.GetItemAttrText(
6140: itemtype => itemtype,
6141: itemkey => itemkey,
6142: aname => 'EVENTNAME' );
6143: l_request_number := WF_ENGINE.GetItemAttrText(
6144: itemtype => itemtype,
6145: itemkey => itemkey,
6146: aname => 'REQUEST_NUMBER' );
6147: l_request_id := WF_ENGINE.GetItemAttrNumber(
6143: l_request_number := WF_ENGINE.GetItemAttrText(
6144: itemtype => itemtype,
6145: itemkey => itemkey,
6146: aname => 'REQUEST_NUMBER' );
6147: l_request_id := WF_ENGINE.GetItemAttrNumber(
6148: itemtype => itemtype,
6149: itemkey => itemkey,
6150: aname => 'REQUEST_ID' );
6151:
6168: l_update_actions_list := l_update_actions_list || ' ' || sel_action_rec.action_code;
6169: END IF;
6170: ELSE
6171:
6172: WF_ENGINE.SetItemAttrText(
6173: itemtype => itemtype,
6174: itemkey => itemkey,
6175: aname => 'MORE_UPDATE_ACTION_LIST',
6176: avalue => 'Y' );
6181: CLOSE sel_action_csr;
6182:
6183: IF (l_update_conditions_list IS NOT NULL AND l_update_actions_list IS NOT NULL) THEN
6184:
6185: WF_ENGINE.SetItemAttrText(
6186: itemtype => itemtype,
6187: itemkey => itemkey,
6188: aname => 'UPDATE_CONDITION_LIST',
6189: avalue => l_update_conditions_list );
6186: itemtype => itemtype,
6187: itemkey => itemkey,
6188: aname => 'UPDATE_CONDITION_LIST',
6189: avalue => l_update_conditions_list );
6190: WF_ENGINE.SetItemAttrText(
6191: itemtype => itemtype,
6192: itemkey => itemkey,
6193: aname => 'UPDATE_ACTION_LIST',
6194: avalue => l_update_actions_list );
6367: BEGIN
6368:
6369: IF (funmode = 'RUN') THEN
6370:
6371: l_request_number := WF_ENGINE.GetItemAttrText(
6372: itemtype => itemtype,
6373: itemkey => itemkey,
6374: aname => 'REQUEST_NUMBER' );
6375:
6438: number of parameters in an event is 100).
6439: *******/
6440:
6441: -- Initialize item attributes that will remain constant
6442: WF_ENGINE.SetItemAttrDate(
6443: itemtype => 'SERVEREQ',
6444: itemkey => itemkey,
6445: aname => 'REQUEST_DATE',
6446: avalue => l_ServiceRequest_rec.incident_date );
6444: itemkey => itemkey,
6445: aname => 'REQUEST_DATE',
6446: avalue => l_ServiceRequest_rec.incident_date );
6447:
6448: WF_ENGINE.SetItemAttrNumber(
6449: itemtype => 'SERVEREQ',
6450: itemkey => itemkey,
6451: aname => 'REQUEST_ID',
6452: avalue => l_ServiceRequest_rec.incident_id );
6451: aname => 'REQUEST_ID',
6452: avalue => l_ServiceRequest_rec.incident_id );
6453:
6454: /***** IF Request_id is given, request_number is derived in Check_Rules_For_Event()
6455: WF_ENGINE.SetItemAttrText(
6456: itemtype => 'SERVEREQ',
6457: itemkey => itemkey,
6458: aname => 'REQUEST_NUMBER',
6459: avalue => l_ServiceRequest_rec.incident_number );
6458: aname => 'REQUEST_NUMBER',
6459: avalue => l_ServiceRequest_rec.incident_number );
6460: *****/
6461:
6462: WF_ENGINE.SetItemAttrText(
6463: itemtype => 'SERVEREQ',
6464: itemkey => itemkey,
6465: aname => 'REQUEST_TYPE',
6466: avalue => l_ServiceRequest_rec.incident_type );
6466: avalue => l_ServiceRequest_rec.incident_type );
6467:
6468:
6469: -- Update service request item attributes
6470: WF_ENGINE.SetItemAttrNumber(
6471: itemtype => 'SERVEREQ',
6472: itemkey => itemkey,
6473: aname => 'OWNER_ID',
6474: avalue => l_ServiceRequest_rec.incident_owner_id );
6472: itemkey => itemkey,
6473: aname => 'OWNER_ID',
6474: avalue => l_ServiceRequest_rec.incident_owner_id );
6475:
6476: WF_ENGINE.SetItemAttrText(
6477: itemtype => 'SERVEREQ',
6478: itemkey => itemkey,
6479: aname => 'OWNER_ROLE',
6480: avalue => l_owner_role );
6478: itemkey => itemkey,
6479: aname => 'OWNER_ROLE',
6480: avalue => l_owner_role );
6481:
6482: WF_ENGINE.SetItemAttrText(
6483: itemtype => 'SERVEREQ',
6484: itemkey => itemkey,
6485: aname => 'OWNER_NAME',
6486: avalue => l_owner_name );
6484: itemkey => itemkey,
6485: aname => 'OWNER_NAME',
6486: avalue => l_owner_name );
6487:
6488: WF_ENGINE.SetItemAttrNumber(
6489: itemtype => 'SERVEREQ',
6490: itemkey => itemkey,
6491: aname => 'CUSTOMER_PRODUCT_ID',
6492: avalue => l_ServiceRequest_rec.customer_product_id );
6490: itemkey => itemkey,
6491: aname => 'CUSTOMER_PRODUCT_ID',
6492: avalue => l_ServiceRequest_rec.customer_product_id );
6493:
6494: WF_ENGINE.SetItemAttrDate(
6495: itemtype => 'SERVEREQ',
6496: itemkey => itemkey,
6497: aname => 'EXPECTED_RESOLUTION_DATE',
6498: avalue => l_ServiceRequest_rec.expected_resolution_date );
6496: itemkey => itemkey,
6497: aname => 'EXPECTED_RESOLUTION_DATE',
6498: avalue => l_ServiceRequest_rec.expected_resolution_date );
6499:
6500: WF_ENGINE.SetItemAttrNumber(
6501: itemtype => 'SERVEREQ',
6502: itemkey => itemkey,
6503: aname => 'INVENTORY_ITEM_ID',
6504: avalue => l_ServiceRequest_rec.inventory_item_id );
6502: itemkey => itemkey,
6503: aname => 'INVENTORY_ITEM_ID',
6504: avalue => l_ServiceRequest_rec.inventory_item_id );
6505:
6506: WF_ENGINE.SetItemAttrText(
6507: itemtype => 'SERVEREQ',
6508: itemkey => itemkey,
6509: aname => 'PROBLEM_DESCRIPTION',
6510: avalue => l_ServiceRequest_rec.problem_code_description );
6509: aname => 'PROBLEM_DESCRIPTION',
6510: avalue => l_ServiceRequest_rec.problem_code_description );
6511:
6512: -- 5245018_start
6513: WF_ENGINE.SetItemAttrText(
6514: itemtype => 'SERVEREQ',
6515: itemkey => itemkey,
6516: aname => 'PROBLEM_CODE',
6517: avalue => l_ServiceRequest_rec.problem_code );
6516: aname => 'PROBLEM_CODE',
6517: avalue => l_ServiceRequest_rec.problem_code );
6518: -- 5245018_eof
6519:
6520: WF_ENGINE.SetItemAttrText(
6521: itemtype => 'SERVEREQ',
6522: itemkey => itemkey,
6523: aname => 'PRODUCT_DESCRIPTION',
6524: avalue => l_ServiceRequest_rec.product_description );
6522: itemkey => itemkey,
6523: aname => 'PRODUCT_DESCRIPTION',
6524: avalue => l_ServiceRequest_rec.product_description );
6525:
6526: WF_ENGINE.SetItemAttrText(
6527: itemtype => 'SERVEREQ',
6528: itemkey => itemkey,
6529: aname => 'REQUEST_CUSTOMER',
6530: avalue => l_ServiceRequest_rec.customer_name );
6528: itemkey => itemkey,
6529: aname => 'REQUEST_CUSTOMER',
6530: avalue => l_ServiceRequest_rec.customer_name );
6531:
6532: WF_ENGINE.SetItemAttrText(
6533: itemtype => 'SERVEREQ',
6534: itemkey => itemkey,
6535: aname => 'REQUEST_SEVERITY',
6536: avalue => l_ServiceRequest_rec.severity );
6534: itemkey => itemkey,
6535: aname => 'REQUEST_SEVERITY',
6536: avalue => l_ServiceRequest_rec.severity );
6537:
6538: WF_ENGINE.SetItemAttrText(
6539: itemtype => 'SERVEREQ',
6540: itemkey => itemkey,
6541: aname => 'REQUEST_STATUS',
6542: avalue => l_ServiceRequest_rec.status_code );
6540: itemkey => itemkey,
6541: aname => 'REQUEST_STATUS',
6542: avalue => l_ServiceRequest_rec.status_code );
6543:
6544: WF_ENGINE.SetItemAttrText(
6545: itemtype => 'SERVEREQ',
6546: itemkey => itemkey,
6547: aname => 'REQUEST_SUMMARY',
6548: avalue => l_ServiceRequest_rec.summary );
6546: itemkey => itemkey,
6547: aname => 'REQUEST_SUMMARY',
6548: avalue => l_ServiceRequest_rec.summary );
6549:
6550: WF_ENGINE.SetItemAttrText(
6551: itemtype => 'SERVEREQ',
6552: itemkey => itemkey,
6553: aname => 'REQUEST_URGENCY',
6554: avalue => l_ServiceRequest_rec.urgency );
6554: avalue => l_ServiceRequest_rec.urgency );
6555:
6556:
6557: -- Get the old incident_owner role if old incident owner is given
6558: l_old_incident_owner_id := WF_ENGINE.GetItemAttrText(
6559: itemtype => itemtype,
6560: itemkey => itemkey,
6561: aname => 'PREV_OWNER_ID');
6562:
6571: p_role_name => l_owner_role,
6572: p_role_display_name => l_owner_name );
6573:
6574: IF (l_owner_role IS NOT NULL) THEN
6575: WF_ENGINE.SetItemAttrText(
6576: itemtype => itemtype,
6577: itemkey => itemkey,
6578: aname => 'PREV_OWNER_ROLE',
6579: avalue => l_owner_role );
6576: itemtype => itemtype,
6577: itemkey => itemkey,
6578: aname => 'PREV_OWNER_ROLE',
6579: avalue => l_owner_role );
6580: WF_ENGINE.SetItemAttrText(
6581: itemtype => itemtype,
6582: itemkey => itemkey,
6583: aname => 'PREV_OWNER_NAME',
6584: avalue => l_owner_name );
6587:
6588: END IF;
6589:
6590:
6591: l_role_name := WF_ENGINE.GetItemAttrText(
6592: itemtype => itemtype,
6593: itemkey => itemkey,
6594: aname => 'SENDER_ROLE' );
6595:
6636: IF l_get_source_id%ISOPEN THEN
6637: CLOSE l_get_source_id;
6638: END IF;
6639:
6640: WF_ENGINE.SetItemAttrText(
6641: itemtype => 'SERVEREQ',
6642: itemkey => itemkey,
6643: aname => 'SENDER_ROLE',
6644: avalue => l_role_name );
7351:
7352:
7353: IF (funmode = 'RUN') THEN
7354:
7355: l_request_id := WF_ENGINE.GetItemAttrText(
7356: itemtype => itemtype,
7357: itemkey => itemkey,
7358: aname => 'REQUEST_ID' );
7359:
7356: itemtype => itemtype,
7357: itemkey => itemkey,
7358: aname => 'REQUEST_ID' );
7359:
7360: l_request_number := WF_ENGINE.GetItemAttrText(
7361: itemtype => itemtype,
7362: itemkey => itemkey,
7363: aname => 'REQUEST_NUMBER' );
7364:
7361: itemtype => itemtype,
7362: itemkey => itemkey,
7363: aname => 'REQUEST_NUMBER' );
7364:
7365: l_sender := WF_ENGINE.GetItemAttrText(
7366: itemtype => itemtype,
7367: itemkey => itemkey,
7368: aname => 'SENDER_ROLE' );
7369:
7366: itemtype => itemtype,
7367: itemkey => itemkey,
7368: aname => 'SENDER_ROLE' );
7369:
7370: l_contact_id_list := WF_ENGINE.GetItemAttrText(
7371: itemtype => itemtype,
7372: itemkey => itemkey,
7373: aname => 'CONTACT_ID_LIST' );
7374:
7371: itemtype => itemtype,
7372: itemkey => itemkey,
7373: aname => 'CONTACT_ID_LIST' );
7374:
7375: l_contact_email_list := WF_ENGINE.GetItemAttrText(
7376: itemtype => itemtype,
7377: itemkey => itemkey,
7378: aname => 'CONTACT_EMAIL_LIST' );
7379:
7376: itemtype => itemtype,
7377: itemkey => itemkey,
7378: aname => 'CONTACT_EMAIL_LIST' );
7379:
7380: l_adhoc_user_list := WF_ENGINE.GetItemAttrText(
7381: itemtype => itemtype,
7382: itemkey => itemkey,
7383: aname => 'ADHOC_USER_LIST');
7384:
7381: itemtype => itemtype,
7382: itemkey => itemkey,
7383: aname => 'ADHOC_USER_LIST');
7384:
7385: l_contact_type_list := WF_ENGINE.GetItemAttrText(
7386: itemtype => itemtype,
7387: itemkey => itemkey,
7388: aname => 'CONTACT_TYPE_LIST');
7389:
7386: itemtype => itemtype,
7387: itemkey => itemkey,
7388: aname => 'CONTACT_TYPE_LIST');
7389:
7390: l_language_list := WF_ENGINE.GetItemAttrText(
7391: itemtype => itemtype,
7392: itemkey => itemkey,
7393: aname => 'LANGUAGE_LIST');
7394:
7391: itemtype => itemtype,
7392: itemkey => itemkey,
7393: aname => 'LANGUAGE_LIST');
7394:
7395: l_notification_pref_list := WF_ENGINE.GetItemAttrText(
7396: itemtype => itemtype,
7397: itemkey => itemkey,
7398: aname => 'NOTIFICATION_PREFERENCE_LIST');
7399:
7396: itemtype => itemtype,
7397: itemkey => itemkey,
7398: aname => 'NOTIFICATION_PREFERENCE_LIST');
7399:
7400: l_message_name := WF_ENGINE.GetItemAttrText(
7401: itemtype => itemtype,
7402: itemkey => itemkey,
7403: aname => 'NTFY_MESSAGE_NAME');
7404:
7460: END IF;
7461:
7462: IF l_message_name = 'CS_SR_IBU_EVT_STATUS_CHANGED' THEN
7463:
7464: l_from_status := WF_ENGINE.GetItemAttrText(
7465: itemtype => itemtype,
7466: itemkey => itemkey,
7467: aname => 'REQUEST_STATUS_OLD');
7468:
7465: itemtype => itemtype,
7466: itemkey => itemkey,
7467: aname => 'REQUEST_STATUS_OLD');
7468:
7469: l_to_status := WF_ENGINE.GetItemAttrText(
7470: itemtype => itemtype,
7471: itemkey => itemkey,
7472: aname => 'REQUEST_STATUS');
7473: END IF;
7495:
7496: pull_from_list(itemlist => l_notification_pref_list,
7497: element => l_notification_pref);
7498:
7499: WF_ENGINE.SetItemAttrText
7500: ( itemtype => itemtype,
7501: itemkey => itemkey,
7502: AName => 'ADHOC_USER_LIST',
7503: AValue => l_adhoc_user_list);
7501: itemkey => itemkey,
7502: AName => 'ADHOC_USER_LIST',
7503: AValue => l_adhoc_user_list);
7504:
7505: WF_ENGINE.SetItemAttrText
7506: ( itemtype => itemtype,
7507: itemkey => itemkey,
7508: AName => 'CONTACT_ID_LIST',
7509: AValue => l_contact_id_list);
7507: itemkey => itemkey,
7508: AName => 'CONTACT_ID_LIST',
7509: AValue => l_contact_id_list);
7510:
7511: WF_ENGINE.SetItemAttrText
7512: ( itemtype => itemtype,
7513: itemkey => itemkey,
7514: AName => 'CONTACT_EMAIL_LIST',
7515: AValue => l_contact_email_list);
7513: itemkey => itemkey,
7514: AName => 'CONTACT_EMAIL_LIST',
7515: AValue => l_contact_email_list);
7516:
7517: WF_ENGINE.SetItemAttrText
7518: ( itemtype => itemtype,
7519: itemkey => itemkey,
7520: AName => 'CONTACT_TYPE_LIST',
7521: AValue => l_contact_type_list);
7519: itemkey => itemkey,
7520: AName => 'CONTACT_TYPE_LIST',
7521: AValue => l_contact_type_list);
7522:
7523: WF_ENGINE.SetItemAttrText
7524: ( itemtype => itemtype,
7525: itemkey => itemkey,
7526: AName => 'NOTIFICATION_PREFERENCE_LIST',
7527: AValue => l_notification_pref_list);
7525: itemkey => itemkey,
7526: AName => 'NOTIFICATION_PREFERENCE_LIST',
7527: AValue => l_notification_pref_list);
7528:
7529: WF_ENGINE.SetItemAttrText
7530: ( itemtype => itemtype,
7531: itemkey => itemkey,
7532: AName => 'LANGUAGE_LIST',
7533: AValue => l_language_list);
7576: END IF;
7577:
7578: -- Set the recipient role for the notification
7579:
7580: WF_ENGINE.SetItemAttrText
7581: ( itemtype => itemtype,
7582: itemkey => itemkey,
7583: aname => 'NTFY_RECIPIENT',
7584: avalue => l_adhoc_user);
7780: END IF;
7781:
7782: IF l_count1 = 2 THEN
7783:
7784: WF_ENGINE.SetItemAttrText(
7785: itemtype => p_itemtype,
7786: itemkey => p_itemkey,
7787: aname => 'STYLESHEET',
7788: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7789:
7790:
7791: ELSIF l_count1 = 3 then
7792:
7793: WF_ENGINE.SetItemAttrText(
7794: itemtype => p_itemtype,
7795: itemkey => p_itemkey,
7796: aname => 'BRANDINGINFO',
7797: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7797: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7798:
7799: ELSIF l_count1 = 4 then
7800:
7801: WF_ENGINE.SetItemAttrText(
7802: itemtype => p_itemtype,
7803: itemkey => p_itemkey,
7804: aname => 'IBU_CONTENT1',
7805: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7805: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7806:
7807: ELSIF l_count1 = 5 then
7808:
7809: WF_ENGINE.SetItemAttrText(
7810: itemtype => p_itemtype,
7811: itemkey => p_itemkey,
7812: aname => 'IBU_CONTENT2',
7813: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7814:
7815:
7816: ELSIF l_count1 = 6 then
7817:
7818: WF_ENGINE.SetItemAttrText(
7819: itemtype => p_itemtype,
7820: itemkey => p_itemkey,
7821: aname => 'IBU_CONTENT3',
7822: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7823:
7824:
7825: ELSIF l_count1 = 7 then
7826:
7827: WF_ENGINE.SetItemAttrText(
7828: itemtype => p_itemtype,
7829: itemkey => p_itemkey,
7830: aname => 'IBU_CONTENT4',
7831: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7832:
7833:
7834: ELSIF l_count1 = 8 then
7835:
7836: WF_ENGINE.SetItemAttrText(
7837: itemtype => p_itemtype,
7838: itemkey => p_itemkey,
7839: aname => 'IBU_CONTENT5',
7840: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7842:
7843:
7844: ELSIF l_count1 = 9 then
7845:
7846: WF_ENGINE.SetItemAttrText(
7847: itemtype => p_itemtype,
7848: itemkey => p_itemkey,
7849: aname => 'IBU_CONTENT6',
7850: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7852:
7853:
7854: ELSIF l_count1 = 10 then
7855:
7856: WF_ENGINE.SetItemAttrText(
7857: itemtype => p_itemtype,
7858: itemkey => p_itemkey,
7859: aname => 'IBU_CONTENT7',
7860: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7862:
7863:
7864: ELSIF l_count1 = 11 then
7865:
7866: WF_ENGINE.SetItemAttrText(
7867: itemtype => p_itemtype,
7868: itemkey => p_itemkey,
7869: aname => 'IBU_CONTENT8',
7870: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7871:
7872:
7873: ELSIF l_count1 = 12 then
7874:
7875: WF_ENGINE.SetItemAttrText(
7876: itemtype => p_itemtype,
7877: itemkey => p_itemkey,
7878: aname => 'IBU_CONTENT9',
7879: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7880:
7881:
7882: ELSIF l_count1 = 13 then
7883:
7884: WF_ENGINE.SetItemAttrText(
7885: itemtype => p_itemtype,
7886: itemkey => p_itemkey,
7887: aname => 'IBU_CONTENT10',
7888: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7889:
7890:
7891: ELSIF l_count1 = 14 then
7892:
7893: WF_ENGINE.SetItemAttrText(
7894: itemtype => p_itemtype,
7895: itemkey => p_itemkey,
7896: aname => 'IBU_CONTENT11',
7897: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7898:
7899:
7900: ELSIF l_count1 = 15 then
7901:
7902: WF_ENGINE.SetItemAttrText(
7903: itemtype => p_itemtype,
7904: itemkey => p_itemkey,
7905: aname => 'IBU_CONTENT12',
7906: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7907:
7908:
7909: ELSIF l_count1 = 16 then
7910:
7911: WF_ENGINE.SetItemAttrText(
7912: itemtype => p_itemtype,
7913: itemkey => p_itemkey,
7914: aname => 'IBU_CONTENT13',
7915: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7916:
7917:
7918: ELSIF l_count1 = 17 then
7919:
7920: WF_ENGINE.SetItemAttrText(
7921: itemtype => p_itemtype,
7922: itemkey => p_itemkey,
7923: aname => 'IBU_CONTENT14',
7924: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7925:
7926:
7927: ELSIF l_count1 = 18 then
7928:
7929: WF_ENGINE.SetItemAttrText(
7930: itemtype => p_itemtype,
7931: itemkey => p_itemkey,
7932: aname => 'IBU_CONTENT15',
7933: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7938: NULL;
7939: ELSIF l_count1 = 20 then
7940:
7941: IF l_count1 IS NOT NULL THEN
7942: WF_ENGINE.SetItemAttrText(
7943: itemtype => p_itemtype,
7944: itemkey => p_itemkey,
7945: aname => 'URL_LINK',
7946: avalue => 'plsql:IBU_SUBS_DOC_PKG.set_msg_body_token/'||l_out_value );
7992: END IF;
7993: END IF;
7994: IF (funmode = 'RUN') THEN
7995:
7996: l_contact_id_list := WF_ENGINE.GetItemAttrText(
7997: itemtype => itemtype,
7998: itemkey => itemkey,
7999: aname => 'CONTACT_ID_LIST' );
8000:
8068: set an attribute to indicate that we need to re-query again to obtain
8069: the remainder of the results which were not put in the initial list.
8070: **********/
8071:
8072: WF_ENGINE.SetItemAttrText
8073: (itemtype => p_itemtype,
8074: itemkey => p_itemkey,
8075: aname => 'MORE_NTFY_ACTION_LIST',
8076: avalue => 'Y' );
8096: set an attribute to indicate that we need to re-query again to obtain
8097: the remainder of the results which were not put in the initial list.
8098: **********/
8099:
8100: WF_ENGINE.SetItemAttrText
8101: (itemtype => p_itemtype,
8102: itemkey => p_itemkey,
8103: aname => 'MORE_NTFY_ACTION_LIST',
8104: avalue => 'Y' );
8131: set an attribute to indicate that we need to re-query again to obtain
8132: the remainder of the results which were not put in the initial list.
8133: **********/
8134:
8135: WF_ENGINE.SetItemAttrText
8136: (itemtype => p_itemtype,
8137: itemkey => p_itemkey,
8138: aname => 'MORE_NTFY_ACTION_LIST',
8139: avalue => 'Y' );
8160: set an attribute to indicate that we need to re-query again to obtain
8161: the remainder of the results which were not put in the initial list.
8162: **********/
8163:
8164: WF_ENGINE.SetItemAttrText
8165: (itemtype => p_itemtype,
8166: itemkey => p_itemkey,
8167: aname => 'MORE_NTFY_ACTION_LIST',
8168: avalue => 'Y' );
8171: END IF; --(sel_action_rec.role_group_type = 'ROLEGROUP') THEN
8172:
8173: END IF;
8174:
8175: WF_ENGINE.SetItemAttrText
8176: (itemtype => p_itemtype,
8177: itemkey => p_itemkey,
8178: aname => 'NOTIFY_PARTY_ROLE_LIST',
8179: avalue => l_notify_party_role_list );
8177: itemkey => p_itemkey,
8178: aname => 'NOTIFY_PARTY_ROLE_LIST',
8179: avalue => l_notify_party_role_list );
8180:
8181: WF_ENGINE.SetItemAttrText
8182: (itemtype => p_itemtype,
8183: itemkey => p_itemkey,
8184: aname => 'NOTIFY_RELSR_PARTY_ROLE_LIST',
8185: avalue => l_notify_party_role_relsr_list );