DBA Data[Home] [Help]

APPS.ZPB_WF_NTF dependencies on WF_NOTIFICATION

Line 1384: l_nid := wf_notification.send(ROLE => l_username,

1380: l_msg_name := 'FYIMSG';
1381:
1382: l_username := ID_to_FNDUser(p_userid);
1383:
1384: l_nid := wf_notification.send(ROLE => l_username,
1385: MSG_TYPE => l_item_type,
1386: MSG_NAME => l_msg_name,
1387: DUE_DATE => NULL,
1388: CALLBACK => NULL,

Line 1395: wf_notification.SETATTRTEXT(l_nid, 'SUBJECT', p_subject);

1391: PRIORITY => NULL);
1392:
1393:
1394: --DBMS_OUTPUT.PUT_LINE(l_nid);
1395: wf_notification.SETATTRTEXT(l_nid, 'SUBJECT', p_subject);
1396: wf_notification.SETATTRTEXT(l_nid, 'ISSUEMSG', p_message);
1397:
1398:
1399: return;

Line 1396: wf_notification.SETATTRTEXT(l_nid, 'ISSUEMSG', p_message);

1392:
1393:
1394: --DBMS_OUTPUT.PUT_LINE(l_nid);
1395: wf_notification.SETATTRTEXT(l_nid, 'SUBJECT', p_subject);
1396: wf_notification.SETATTRTEXT(l_nid, 'ISSUEMSG', p_message);
1397:
1398:
1399: return;
1400:

Line 1606: l_nid := wf_notification.send(ROLE => l_BPownerOrProxy,

1602: end if;
1603: l_msg_name := 'INACTIVEMSG';
1604:
1605:
1606: l_nid := wf_notification.send(ROLE => l_BPownerOrProxy,
1607: MSG_TYPE => l_item_type,
1608: MSG_NAME => l_msg_name,
1609: DUE_DATE => NULL,
1610: CALLBACK => NULL,

Line 1618: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKNAME', l_taskName);

1614:
1615: -- DBMS_OUTPUT.PUT_LINE('nid ' || l_nid);
1616:
1617:
1618: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKNAME', l_taskName);
1619: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_NAME', l_BA_name);
1620: wf_notification.SETATTRTEXT(l_nid, '#HDR_INSTANCEDESC', l_BP_runName);
1621: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_ID', l_BAID);
1622: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKID', l_taskID);

Line 1619: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_NAME', l_BA_name);

1615: -- DBMS_OUTPUT.PUT_LINE('nid ' || l_nid);
1616:
1617:
1618: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKNAME', l_taskName);
1619: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_NAME', l_BA_name);
1620: wf_notification.SETATTRTEXT(l_nid, '#HDR_INSTANCEDESC', l_BP_runName);
1621: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_ID', l_BAID);
1622: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKID', l_taskID);
1623:

Line 1620: wf_notification.SETATTRTEXT(l_nid, '#HDR_INSTANCEDESC', l_BP_runName);

1616:
1617:
1618: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKNAME', l_taskName);
1619: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_NAME', l_BA_name);
1620: wf_notification.SETATTRTEXT(l_nid, '#HDR_INSTANCEDESC', l_BP_runName);
1621: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_ID', l_BAID);
1622: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKID', l_taskID);
1623:
1624:

Line 1621: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_ID', l_BAID);

1617:
1618: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKNAME', l_taskName);
1619: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_NAME', l_BA_name);
1620: wf_notification.SETATTRTEXT(l_nid, '#HDR_INSTANCEDESC', l_BP_runName);
1621: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_ID', l_BAID);
1622: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKID', l_taskID);
1623:
1624:
1625:

Line 1622: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKID', l_taskID);

1618: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKNAME', l_taskName);
1619: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_NAME', l_BA_name);
1620: wf_notification.SETATTRTEXT(l_nid, '#HDR_INSTANCEDESC', l_BP_runName);
1621: wf_notification.SETATTRTEXT(l_nid, '#HDR_BUS_AREA_ID', l_BAID);
1622: wf_notification.SETATTRTEXT(l_nid, '#HDR_TASKID', l_taskID);
1623:
1624:
1625:
1626: --DBMS_OUTPUT.PUT_LINE('before build expired');

Line 1794: wf_notification.SETATTRTEXT(p_nid, 'REGISTER1', l_userlist);

1790: end if;
1791:
1792: end loop;
1793:
1794: wf_notification.SETATTRTEXT(p_nid, 'REGISTER1', l_userlist);
1795:
1796:
1797: -- loop over cursor
1798:

Line 1833: wf_notification.SETATTRTEXT(p_nid, 'REGISTER1', l_userlist);

1829:
1830: case l_register
1831:
1832: when 1 then
1833: wf_notification.SETATTRTEXT(p_nid, 'REGISTER1', l_userlist);
1834: l_userlist := NULL;
1835: when 2 then
1836: wf_notification.SETATTRTEXT(p_nid, 'REGISTER2', l_userlist);
1837: l_userlist := NULL;

Line 1836: wf_notification.SETATTRTEXT(p_nid, 'REGISTER2', l_userlist);

1832: when 1 then
1833: wf_notification.SETATTRTEXT(p_nid, 'REGISTER1', l_userlist);
1834: l_userlist := NULL;
1835: when 2 then
1836: wf_notification.SETATTRTEXT(p_nid, 'REGISTER2', l_userlist);
1837: l_userlist := NULL;
1838:
1839: when 3 then
1840: wf_notification.SETATTRTEXT(p_nid, 'REGISTER3', l_userlist);

Line 1840: wf_notification.SETATTRTEXT(p_nid, 'REGISTER3', l_userlist);

1836: wf_notification.SETATTRTEXT(p_nid, 'REGISTER2', l_userlist);
1837: l_userlist := NULL;
1838:
1839: when 3 then
1840: wf_notification.SETATTRTEXT(p_nid, 'REGISTER3', l_userlist);
1841: l_userlist := NULL;
1842:
1843: when 4 then
1844: wf_notification.SETATTRTEXT(p_nid, 'REGISTER4', l_userlist);

Line 1844: wf_notification.SETATTRTEXT(p_nid, 'REGISTER4', l_userlist);

1840: wf_notification.SETATTRTEXT(p_nid, 'REGISTER3', l_userlist);
1841: l_userlist := NULL;
1842:
1843: when 4 then
1844: wf_notification.SETATTRTEXT(p_nid, 'REGISTER4', l_userlist);
1845: l_userlist := NULL;
1846:
1847: when 5 then
1848: wf_notification.SETATTRTEXT(p_nid, 'REGISTER5', l_userlist);

Line 1848: wf_notification.SETATTRTEXT(p_nid, 'REGISTER5', l_userlist);

1844: wf_notification.SETATTRTEXT(p_nid, 'REGISTER4', l_userlist);
1845: l_userlist := NULL;
1846:
1847: when 5 then
1848: wf_notification.SETATTRTEXT(p_nid, 'REGISTER5', l_userlist);
1849: l_userlist := NULL;
1850:
1851: when 6 then
1852: wf_notification.SETATTRTEXT(p_nid, 'REGISTER6', l_userlist);

Line 1852: wf_notification.SETATTRTEXT(p_nid, 'REGISTER6', l_userlist);

1848: wf_notification.SETATTRTEXT(p_nid, 'REGISTER5', l_userlist);
1849: l_userlist := NULL;
1850:
1851: when 6 then
1852: wf_notification.SETATTRTEXT(p_nid, 'REGISTER6', l_userlist);
1853: l_userlist := NULL;
1854:
1855: end case;
1856: