APPS.AMS_WFTRIG_PVT dependencies on WF_ENGINE

Line 182: l_trigger_id := WF_ENGINE.GetItemAttrText(

178: BEGIN
179:
180: IF p_itemtype = 'AMS_CSCH'
181: THEN
182: l_trigger_id := WF_ENGINE.GetItemAttrText(
183: itemtype => p_itemtype,
184: itemkey => p_itemkey ,
185: aname => 'SCHEDULE_ID');
186: l_obj_type := 'CSCH';

Line 188: l_trigger_id := WF_ENGINE.GetItemAttrText(

184: itemkey => p_itemkey ,
185: aname => 'SCHEDULE_ID');
186: l_obj_type := 'CSCH';
187: ELSE
188: l_trigger_id := WF_ENGINE.GetItemAttrText(
189: itemtype => p_itemtype,
190: itemkey => p_itemkey ,
191: aname => 'AMS_TRIGGER_ID');
192: l_obj_type := 'TRIG';

Line 230: WF_ENGINE.SetItemAttrText(itemtype => p_itemtype,

226: );
227:
228: END LOOP ;
229:
230: WF_ENGINE.SetItemAttrText(itemtype => p_itemtype,
231: itemkey => p_itemkey ,
232: aname => p_attr_name,
233: avalue => l_final_data );
234:

Line 335: WF_ENGINE.CreateProcess (itemtype => 'AMS_TRIG', --itemtype,

331: Ams_Utility_pvt.debug_message('Item key : ' || itemkey);
332: END IF;
333:
334: -- dbms_output.put_line('Creating process');
335: WF_ENGINE.CreateProcess (itemtype => 'AMS_TRIG', --itemtype,
336: itemkey => itemkey ,
337: process => workflowprocess);
338: --dbms_output.put_line('Created process');
339: -- Call a Proc to Initialize the Variables

Line 348: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

344: p_itemkey => itemkey
345: ) ;
346: */
347: /*
348: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
349: itemkey => itemkey,
350: aname => 'AMS_USER_ID',
351: avalue => p_user_id );
352: */

Line 353: itemuserkey := WF_ENGINE.getItemAttrText(itemtype => itemtype,

349: itemkey => itemkey,
350: aname => 'AMS_USER_ID',
351: avalue => p_user_id );
352: */
353: itemuserkey := WF_ENGINE.getItemAttrText(itemtype => itemtype,
354: itemkey => itemkey ,
355: aname => 'AMS_TRIGGER_NAME');
356:
357: IF (AMS_DEBUG_HIGH_ON) THEN

Line 362: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

358: Ams_Utility_pvt.debug_message('After create desc wf_itemsItem key : ' || itemkey);
359:
360: END IF;
361:
362: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
363: itemkey => itemkey ,
364: userkey => itemuserkey);
365:
366: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 366: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

362: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
363: itemkey => itemkey ,
364: userkey => itemuserkey);
365:
366: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
367: itemkey => itemkey,
368: aname => 'MONITOR_URL',
369: avalue => wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), itemtype, itemkey, 'NO'));
370:

Line 371: --dbms_output.put_line('Calling WF_ENGINE to start process');

367: itemkey => itemkey,
368: aname => 'MONITOR_URL',
369: avalue => wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), itemtype, itemkey, 'NO'));
370:
371: --dbms_output.put_line('Calling WF_ENGINE to start process');
372: --dbms_output.put_line('itemtype: '||itemtype);
373: --dbms_output.put_line('itemkey: '||itemkey);
374: WF_ENGINE.StartProcess (itemtype => itemtype,
375: itemkey => itemkey);

Line 374: WF_ENGINE.StartProcess (itemtype => itemtype,

370:
371: --dbms_output.put_line('Calling WF_ENGINE to start process');
372: --dbms_output.put_line('itemtype: '||itemtype);
373: --dbms_output.put_line('itemkey: '||itemkey);
374: WF_ENGINE.StartProcess (itemtype => itemtype,
375: itemkey => itemkey);
376: --dbms_output.put_line('done');
377: -- Following lines of code is modified by ptendulk on 31-May-2001
378: -- As the trigger action table is no longer required.

Line 515: l_repeat_check := WF_ENGINE.GetItemAttrText(

511: -- dbms_output.put_line('Process Check_Repeat');
512: -- RUN mode - Normal Process Execution
513: IF (funcmode = 'RUN')
514: THEN
515: l_repeat_check := WF_ENGINE.GetItemAttrText(
516: itemtype => itemtype,
517: itemkey => itemkey ,
518: aname => 'AMS_REPEAT_FREQUENCY_TYPE' );
519:

Line 624: l_trigger_id := WF_ENGINE.GetItemAttrText (itemtype => itemtype,

620: l_trig_date c_sch_date%ROWTYPE;
621: */
622: BEGIN
623: /*
624: l_trigger_id := WF_ENGINE.GetItemAttrText (itemtype => itemtype,
625: itemkey => itemkey ,
626: aname => 'AMS_TRIGGER_ID');
627:
628: UPDATE ams_triggers SET next_run_date_time = (next_run_date_time+1/360) WHERE trigger_id = l_trigger_id;

Line 633: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

629: COMMIT;
630: OPEN c_sch_date(l_trigger_id);
631: FETCH c_sch_date INTO l_sch_date;
632: CLOSE c_sch_date;
633: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
634: itemkey => itemkey ,
635: aname => 'AMS_TRIGGER_SCHEDULE_DATE',
636: avalue => to_char(l_sch_date,'DD-MON-RRRR HH:MI:SS AM'));
637:

Line 646: l_trigger_id := WF_ENGINE.GetItemAttrText(

642: THEN
643:
644: FND_MSG_PUB.initialize;
645:
646: l_trigger_id := WF_ENGINE.GetItemAttrText(
647: itemtype => itemtype,
648: itemkey => itemkey ,
649: aname => 'AMS_TRIGGER_ID');
650:

Line 651: l_trigger_date := WF_ENGINE.GetItemAttrText(

647: itemtype => itemtype,
648: itemkey => itemkey ,
649: aname => 'AMS_TRIGGER_ID');
650:
651: l_trigger_date := WF_ENGINE.GetItemAttrText(
652: itemtype => itemtype,
653: itemkey => itemkey ,
654: aname => 'AMS_TRIGGER_SCHEDULE_DATE');
655:

Line 659: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

655:
656: -- dbms_output.put_line('l_trigger_date '|| l_trigger_date);
657: -- dbms_output.put_line('l_trigger_date '||to_char(l_trigger_date,'DD-MON-RRRR HH:MI:SS AM'));
658:
659: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
660: itemkey => itemkey ,
661: aname => 'AMS_TRIGGER_DATE',
662: avalue => l_trigger_date
663: );

Line 789: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

785:
786: -- dbms_OUTPUT.PUT_LINE('Next Scheduled Date is : '||to_char(l_sch_date,'DD-MON-RRRR:HH-MI-SS AM'));
787:
788: --IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
789: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
790: itemkey => itemkey ,
791: aname => 'AMS_TRIGGER_SCHEDULE_DATE',
792: avalue => to_char(l_sch_date,'DD-MON-RRRR HH:MI:SS AM'));
793:

Line 881: l_trigger_id := WF_ENGINE.GetItemAttrText(

877: -- dbms_output.put_line('Process Check_Trigger_Status');
878: -- RUN mode - Normal Process Execution
879: IF (funcmode = 'RUN') THEN
880:
881: l_trigger_id := WF_ENGINE.GetItemAttrText(
882: itemtype => itemtype,
883: itemkey => itemkey ,
884: aname => 'AMS_TRIGGER_ID');
885:

Line 890: /*l_end_date := WF_ENGINE.GetItemAttrText(

886: OPEN c_trig_end_dt(l_trigger_id);
887: FETCH c_trig_end_dt INTO l_end_date;
888: CLOSE c_trig_end_dt;
889:
890: /*l_end_date := WF_ENGINE.GetItemAttrText(
891: itemtype => itemtype,
892: itemkey => itemkey ,
893: aname => 'AMS_TRIGGER_REPEAT_END_DATE');*/
894:

Line 895: /*l_sch_date := WF_ENGINE.GetItemAttrText(

891: itemtype => itemtype,
892: itemkey => itemkey ,
893: aname => 'AMS_TRIGGER_REPEAT_END_DATE');*/
894:
895: /*l_sch_date := WF_ENGINE.GetItemAttrText(
896: itemtype => itemtype,
897: itemkey => itemkey ,
898: aname => 'AMS_TRIGGER_SCHEDULE_DATE');*/
899:

Line 1023: l_trigger_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

1019: IF (funcmode = 'RUN')
1020: THEN
1021:
1022: FND_MSG_PUB.initialize;
1023: l_trigger_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
1024: itemkey => itemkey ,
1025: aname => 'AMS_TRIGGER_ID'
1026: );
1027: /*

Line 1096: l_camp_name := WF_ENGINE.GetItemAttrText(

1092: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1093: IF l_chk_success = '0' THEN
1094: result := 'COMPLETE:FAILURE' ;
1095: ELSIF l_chk_success = '1' THEN
1096: l_camp_name := WF_ENGINE.GetItemAttrText(
1097: itemtype => itemtype,
1098: itemkey => itemkey ,
1099: aname => 'AMS_CAMPAIGN_NAME');
1100:

Line 1101: l_operator := WF_ENGINE.GetItemAttrText(

1097: itemtype => itemtype,
1098: itemkey => itemkey ,
1099: aname => 'AMS_CAMPAIGN_NAME');
1100:
1101: l_operator := WF_ENGINE.GetItemAttrText(
1102: itemtype => itemtype,
1103: itemkey => itemkey ,
1104: aname => 'AMS_OPERATOR');
1105:

Line 1122: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1118: END IF ;
1119:
1120: l_message := FND_MESSAGE.Get;
1121:
1122: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1123: itemkey => itemkey,
1124: aname => 'AMS_NTF_MESSAGE',
1125: avalue => l_message);
1126:

Line 1127: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1123: itemkey => itemkey,
1124: aname => 'AMS_NTF_MESSAGE',
1125: avalue => l_message);
1126:
1127: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1128: itemkey => itemkey,
1129: aname => 'AMS_TRIG_RESULT_ID',
1130: avalue => l_result_id);
1131:

Line 1209: l_notify_chk := WF_ENGINE.GetItemAttrText(

1205: l_trigger_id NUMBER;
1206: BEGIN
1207: IF (funcmode = 'RUN') THEN
1208:
1209: l_notify_chk := WF_ENGINE.GetItemAttrText(
1210: itemtype => itemtype,
1211: itemkey => itemkey ,
1212: aname => 'AMS_NOTIF_TO_USER_NAME');
1213:

Line 1281: l_req_approval := WF_ENGINE.GetItemAttrText(

1277: BEGIN
1278: -- dbms_output.put_line('Process Require Approval');
1279: IF (funcmode = 'RUN')
1280: THEN
1281: l_req_approval := WF_ENGINE.GetItemAttrText(
1282: itemtype => itemtype,
1283: itemkey => itemkey ,
1284: aname => 'AMS_APPROVER_NAME');
1285:

Line 1354: l_trigger_id := WF_ENGINE.GetItemAttrText(

1350: -- dbms_output.put_line('Process Record Result');
1351: -- RUN mode - Normal Process Execution
1352: IF (funcmode = 'RUN')
1353: THEN
1354: l_trigger_id := WF_ENGINE.GetItemAttrText(
1355: itemtype => itemtype,
1356: itemkey => itemkey ,
1357: aname => 'AMS_TRIGGER_ID');
1358: /*

Line 1359: l_action_taken := WF_ENGINE.GetItemAttrText(

1355: itemtype => itemtype,
1356: itemkey => itemkey ,
1357: aname => 'AMS_TRIGGER_ID');
1358: /*
1359: l_action_taken := WF_ENGINE.GetItemAttrText(
1360: itemtype => itemtype,
1361: itemkey => itemkey ,
1362: aname => 'AMS_ACTION_TAKEN');
1363: */

Line 1364: l_process_id := WF_ENGINE.GetItemAttrText(

1360: itemtype => itemtype,
1361: itemkey => itemkey ,
1362: aname => 'AMS_ACTION_TAKEN');
1363: */
1364: l_process_id := WF_ENGINE.GetItemAttrText(
1365: itemtype => itemtype,
1366: itemkey => itemkey ,
1367: aname => 'AMS_TRIG_RESULT_ID');
1368:

Line 1382: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1378: x_return_status => l_return_status,
1379: x_result_id => l_process_id
1380: );
1381:
1382: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1383: itemkey => itemkey,
1384: aname => 'AMS_TRIG_RESULT_ID',
1385: avalue => NULL
1386: );

Line 1484: l_sch_id := WF_ENGINE.GetItemAttrText(

1480: -- Pass the schedule id which is null by default for now.
1481:
1482:
1483:
1484: l_sch_id := WF_ENGINE.GetItemAttrText(
1485: itemtype => itemtype,
1486: itemkey => itemkey ,
1487: aname => 'AMS_SCHEDULE_ID');
1488:

Line 1519: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1515: p_msg_data => 'Item type is '||itemtype,
1516: p_msg_type => 'DEBUG'
1517: );
1518:
1519: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1520: itemkey => itemkey ,
1521: aname => 'AMS_NEW_LIST_NAME',
1522: avalue => l_tgrp_name);
1523: IF (l_tgrp_name is not NULL) THEN

Line 1560: /* WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1556: IF l_return_status = FND_API.g_ret_sts_success THEN
1557: result := 'COMPLETE:SUCCESS';
1558: ELSE
1559: result := 'COMPLETE:ERROR';
1560: /* WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1561: itemkey => itemkey,
1562: aname => 'AMS_LIST_ERROR_MSG',
1563: avalue => l_msg_data);*/
1564: Handle_Err

Line 1611: --WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1607: IF l_return_status = FND_API.g_ret_sts_success THEN
1608: result := 'COMPLETE:SUCCESS';
1609: ELSE
1610: result := 'COMPLETE:ERROR';
1611: --WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1612: -- itemkey => itemkey,
1613: -- aname => 'AMS_LIST_ERROR_MSG',
1614: -- avalue => l_msg_data);
1615: Handle_Err

Line 1728: l_trigger_id := WF_ENGINE.GetItemAttrText(

1724: BEGIN
1725:
1726: IF (funcmode = 'RUN')
1727: THEN
1728: l_trigger_id := WF_ENGINE.GetItemAttrText(
1729: itemtype => itemtype,
1730: itemkey => itemkey ,
1731: aname => 'AMS_TRIGGER_ID');
1732:

Line 1760: WF_ENGINE.CreateProcess (itemtype => itemtype, --itemtype,

1756: -- dbms_output.put_line('detail itemkey: ' || l_item_key);
1757:
1758:
1759: --dbms_output.put_line('Creating process');
1760: WF_ENGINE.CreateProcess (itemtype => itemtype, --itemtype,
1761: itemkey => l_item_key ,
1762: user_key => l_sch_det_rec.schedule_name,
1763: process => 'AMS_EXEC_ATTCH_SCH'); -- name of the process
1764:

Line 1774: WF_ENGINE.SetItemAttrText(itemtype => itemtype

1770: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1771: RAISE FND_API.G_EXC_ERROR;
1772: END IF;
1773:
1774: WF_ENGINE.SetItemAttrText(itemtype => itemtype
1775: ,itemkey => l_item_key
1776: ,aname => 'AMS_SCHEDULE_OWNER'
1777: ,avalue => l_owner);
1778:

Line 1779: WF_ENGINE.SetItemAttrText(itemtype => itemtype

1775: ,itemkey => l_item_key
1776: ,aname => 'AMS_SCHEDULE_OWNER'
1777: ,avalue => l_owner);
1778:
1779: WF_ENGINE.SetItemAttrText(itemtype => itemtype
1780: ,itemkey => l_item_key
1781: ,aname => 'AMS_REQUESTOR_USERNAME'
1782: ,avalue => l_owner);
1783:

Line 1785: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1781: ,aname => 'AMS_REQUESTOR_USERNAME'
1782: ,avalue => l_owner);
1783:
1784: -- set schedule id
1785: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1786: itemkey => l_item_key,
1787: aname => 'AMS_SCHEDULE_ID',
1788: avalue => l_sch_det_rec.schedule_id);
1789:

Line 1791: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1787: aname => 'AMS_SCHEDULE_ID',
1788: avalue => l_sch_det_rec.schedule_id);
1789:
1790: -- set schedule name
1791: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1792: itemkey => l_item_key,
1793: aname => 'AMS_SCHEDULE_NAME',
1794: avalue => l_sch_det_rec.schedule_name);
1795:

Line 1807: WF_ENGINE.SetItemAttrText(itemtype => itemtype

1803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1804: THEN
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807: WF_ENGINE.SetItemAttrText(itemtype => itemtype
1808: ,itemkey => l_item_key
1809: ,aname => 'AMS_NOTIF_TO_USER_NAME'
1810: ,avalue => l_notify);
1811: ELSE

Line 1812: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1808: ,itemkey => l_item_key
1809: ,aname => 'AMS_NOTIF_TO_USER_NAME'
1810: ,avalue => l_notify);
1811: ELSE
1812: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1813: itemkey => l_item_key,
1814: aname => 'AMS_NOTIF_TO_USER_NAME',
1815: avalue => '' );
1816: END IF;

Line 1828: WF_ENGINE.SetItemAttrText(itemtype => itemtype

1824: x_return_status => l_return_status);
1825: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1826: RAISE FND_API.G_EXC_ERROR;
1827: END IF;
1828: WF_ENGINE.SetItemAttrText(itemtype => itemtype
1829: ,itemkey => l_item_key
1830: ,aname => 'AMS_APPROVER_NAME'
1831: ,avalue => l_approver);
1832: ELSE

Line 1833: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1829: ,itemkey => l_item_key
1830: ,aname => 'AMS_APPROVER_NAME'
1831: ,avalue => l_approver);
1832: ELSE
1833: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1834: itemkey => l_item_key,
1835: aname => 'AMS_APPROVER_NAME',
1836: avalue => '' );
1837: END IF;

Line 1840: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

1836: avalue => '' );
1837: END IF;
1838:
1839: -- soagrawa added setting all the other values...
1840: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1841: itemkey => l_item_key,
1842: aname => 'AMS_TRIGGER_ID',
1843: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1844: itemkey => itemkey ,

Line 1843: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

1839: -- soagrawa added setting all the other values...
1840: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
1841: itemkey => l_item_key,
1842: aname => 'AMS_TRIGGER_ID',
1843: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1844: itemkey => itemkey ,
1845: aname => 'AMS_TRIGGER_ID') );
1846:
1847: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 1847: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1843: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1844: itemkey => itemkey ,
1845: aname => 'AMS_TRIGGER_ID') );
1846:
1847: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1848: itemkey => l_item_key,
1849: aname => 'AMS_TRIGGER_NAME',
1850: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1851: itemkey => itemkey ,

Line 1850: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

1846:
1847: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1848: itemkey => l_item_key,
1849: aname => 'AMS_TRIGGER_NAME',
1850: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1851: itemkey => itemkey ,
1852: aname => 'AMS_TRIGGER_NAME') );
1853:
1854:

Line 1855: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1851: itemkey => itemkey ,
1852: aname => 'AMS_TRIGGER_NAME') );
1853:
1854:
1855: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1856: itemkey => l_item_key,
1857: aname => 'AMS_TRIGGER_SCHEDULE_DATE',
1858: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1859: itemkey => itemkey ,

Line 1858: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

1854:
1855: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1856: itemkey => l_item_key,
1857: aname => 'AMS_TRIGGER_SCHEDULE_DATE',
1858: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1859: itemkey => itemkey ,
1860: aname => 'AMS_TRIGGER_SCHEDULE_DATE') );
1861:
1862:

Line 1863: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1859: itemkey => itemkey ,
1860: aname => 'AMS_TRIGGER_SCHEDULE_DATE') );
1861:
1862:
1863: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1864: itemkey => l_item_key,
1865: aname => 'AMS_TRIGGER_DATE',
1866: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1867: itemkey => itemkey ,

Line 1866: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

1862:
1863: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1864: itemkey => l_item_key,
1865: aname => 'AMS_TRIGGER_DATE',
1866: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1867: itemkey => itemkey ,
1868: aname => 'AMS_TRIGGER_DATE') );
1869:
1870:

Line 1871: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1867: itemkey => itemkey ,
1868: aname => 'AMS_TRIGGER_DATE') );
1869:
1870:
1871: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1872: itemkey => l_item_key,
1873: aname => 'AMS_REPEAT_FREQUENCY_TYPE',
1874: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1875: itemkey => itemkey ,

Line 1874: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

1870:
1871: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1872: itemkey => l_item_key,
1873: aname => 'AMS_REPEAT_FREQUENCY_TYPE',
1874: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1875: itemkey => itemkey ,
1876: aname => 'AMS_REPEAT_FREQUENCY_TYPE') );
1877:
1878:

Line 1879: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1875: itemkey => itemkey ,
1876: aname => 'AMS_REPEAT_FREQUENCY_TYPE') );
1877:
1878:
1879: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1880: itemkey => l_item_key,
1881: aname => 'AMS_TRIGGER_REPEAT_END_DATE',
1882: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1883: itemkey => itemkey ,

Line 1882: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

1878:
1879: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1880: itemkey => l_item_key,
1881: aname => 'AMS_TRIGGER_REPEAT_END_DATE',
1882: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1883: itemkey => itemkey ,
1884: aname => 'AMS_TRIGGER_REPEAT_END_DATE') );
1885:
1886:

Line 1887: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1883: itemkey => itemkey ,
1884: aname => 'AMS_TRIGGER_REPEAT_END_DATE') );
1885:
1886:
1887: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1888: itemkey => l_item_key,
1889: aname => 'AMS_CAMPAIGN_NAME',
1890: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1891: itemkey => itemkey ,

Line 1890: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

1886:
1887: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1888: itemkey => l_item_key,
1889: aname => 'AMS_CAMPAIGN_NAME',
1890: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1891: itemkey => itemkey ,
1892: aname => 'AMS_CAMPAIGN_NAME') );
1893:
1894: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 1894: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1890: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1891: itemkey => itemkey ,
1892: aname => 'AMS_CAMPAIGN_NAME') );
1893:
1894: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1895: -- itemkey => l_item_key,
1896: -- aname => 'AMS_CHK_MET_MSG',
1897: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1898: -- itemkey => itemkey ,

Line 1897: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

1893:
1894: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1895: -- itemkey => l_item_key,
1896: -- aname => 'AMS_CHK_MET_MSG',
1897: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1898: -- itemkey => itemkey ,
1899: -- aname => 'AMS_CHK_MET_MSG') );
1900:
1901:

Line 1902: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,

1898: -- itemkey => itemkey ,
1899: -- aname => 'AMS_CHK_MET_MSG') );
1900:
1901:
1902: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1903: -- itemkey => l_item_key,
1904: -- aname => 'AMS_NTF_MESSAGE',
1905: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1906: -- itemkey => itemkey ,

Line 1905: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

1901:
1902: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,
1903: -- itemkey => l_item_key,
1904: -- aname => 'AMS_NTF_MESSAGE',
1905: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
1906: -- itemkey => itemkey ,
1907: -- aname => 'AMS_NTF_MESSAGE') );
1908:
1909: -- end soagrawa setting values

Line 1912: WF_ENGINE.SetItemParent(itemtype => itemtype

1908:
1909: -- end soagrawa setting values
1910:
1911: -- set the parent process
1912: WF_ENGINE.SetItemParent(itemtype => itemtype
1913: ,itemkey => l_item_key
1914: ,parent_itemtype => itemtype
1915: ,parent_itemkey => itemkey
1916: ,parent_context => NULL

Line 1919: WF_ENGINE.StartProcess (itemtype => itemtype,

1915: ,parent_itemkey => itemkey
1916: ,parent_context => NULL
1917: );
1918:
1919: WF_ENGINE.StartProcess (itemtype => itemtype,
1920: itemkey => l_item_key);
1921:
1922: END LOOP;
1923: RETURN;

Line 1993: l_trigger_id := WF_ENGINE.GetItemAttrText(

1989: -- l_notify_id NUMBER;
1990: -- l_approver_id NUMBER;
1991:
1992: BEGIN
1993: l_trigger_id := WF_ENGINE.GetItemAttrText(
1994: itemtype => itemtype,
1995: itemkey => itemkey ,
1996: aname => 'AMS_TRIGGER_ID');
1997:

Line 2099: WF_ENGINE.ItemStatus(itemtype => l_itemtype,

2095: OPEN c_trig_det ;
2096: FETCH c_trig_det INTO l_itemkey;
2097: IF c_trig_det%FOUND THEN
2098:
2099: WF_ENGINE.ItemStatus(itemtype => l_itemtype,
2100: itemkey => l_itemkey,
2101: status => l_status,
2102: result => l_result);
2103:

Line 2107: WF_ENGINE.AbortProcess (itemtype => l_itemtype,

2103:
2104: --dbms_output.put_line('Item key: ' || l_itemkey);
2105: --dbms_output.put_line('Status: ' || l_status);
2106: IF l_status <> 'COMPLETE' THEN
2107: WF_ENGINE.AbortProcess (itemtype => l_itemtype,
2108: itemkey => l_itemkey ,
2109: process => l_process);
2110: END IF;
2111: END IF;

Line 2175: l_trigger_id := WF_ENGINE.GetItemAttrText(

2171: -- dbms_output.put_line('Process Trig_Type_Date');
2172: -- RUN mode - Normal Process Execution
2173: IF (funcmode = 'RUN')
2174: THEN
2175: l_trigger_id := WF_ENGINE.GetItemAttrText(
2176: itemtype => itemtype,
2177: itemkey => itemkey ,
2178: aname => 'AMS_TRIGGER_ID');
2179:

Line 2281: l_trigger_id := WF_ENGINE.GetItemAttrText(

2277: THEN
2278:
2279: -- soagrawa 28-apr-2003 modified retrieval of end date via database as
2280: -- end date can now be changed even if workflow process is there for the trigger
2281: l_trigger_id := WF_ENGINE.GetItemAttrText(
2282: itemtype => itemtype,
2283: itemkey => itemkey ,
2284: aname => 'AMS_TRIGGER_ID');
2285:

Line 2324: WF_ENGINE.SetItemAttrText(itemtype => itemtype

2320: THEN
2321: RAISE FND_API.G_EXC_ERROR;
2322: END IF;
2323:
2324: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2325: ,itemkey => itemkey
2326: ,aname => 'AMS_TRIG_NOTIFTIER'
2327: ,avalue => l_notify);
2328: result := 'COMPLETE:Y' ;

Line 2330: WF_ENGINE.SetItemAttrText(itemtype => itemtype

2326: ,aname => 'AMS_TRIG_NOTIFTIER'
2327: ,avalue => l_notify);
2328: result := 'COMPLETE:Y' ;
2329: ELSE
2330: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2331: ,itemkey => itemkey
2332: ,aname => 'AMS_TRIG_NOTIFTIER'
2333: ,avalue => '');
2334: result := 'COMPLETE:N' ;

Line 2430: l_trigger_id := WF_ENGINE.GetItemAttrText(

2426: THEN
2427:
2428: -- soagrawa 28-apr-2003 modified retrieval of end date via database as
2429: -- end date can now be changed even if workflow process is there for the trigger
2430: l_trigger_id := WF_ENGINE.GetItemAttrText(
2431: itemtype => itemtype,
2432: itemkey => itemkey ,
2433: aname => 'AMS_TRIGGER_ID');
2434:

Line 2635: l_trigger_id := WF_ENGINE.GetItemAttrText(

2631:
2632: BEGIN
2633: IF (funcmode = 'RUN')
2634: THEN
2635: l_trigger_id := WF_ENGINE.GetItemAttrText(
2636: itemtype => itemtype,
2637: itemkey => itemkey ,
2638: aname => 'AMS_TRIGGER_ID');
2639:

Line 2648: l_repeat_check := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

2644: p_msg_data => 'Get_Aval_Repeat_Sch : 1. Started '|| to_char(sysdate,'DD-MON-RRRR HH:MI:SS AM') ,
2645: p_msg_type => 'DEBUG'
2646: );
2647:
2648: l_repeat_check := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
2649: itemkey => itemkey ,
2650: aname => 'AMS_REPEAT_FREQUENCY_TYPE'
2651: );
2652: IF l_repeat_check <> 'NONE' THEN

Line 2655: l_trigger_sched_date := WF_ENGINE.getItemAttrDate(itemtype => itemtype,

2651: );
2652: IF l_repeat_check <> 'NONE' THEN
2653:
2654: --cgoyal - added following code on 06/may/03 for new instance creation for repeat schedules
2655: l_trigger_sched_date := WF_ENGINE.getItemAttrDate(itemtype => itemtype,
2656: itemkey => itemkey ,
2657: aname => 'AMS_TRIGGER_SCHEDULE_DATE') ;
2658:
2659: OPEN c_trigger_det(l_trigger_id);

Line 2695: l_trigger_end_date := WF_ENGINE.getItemAttrDate(itemtype => itemtype,

2691:
2692: -- End: anchaudh: commented out the above portion and instead calling api below.
2693:
2694:
2695: l_trigger_end_date := WF_ENGINE.getItemAttrDate(itemtype => itemtype,
2696: itemkey => itemkey ,
2697: aname => 'AMS_TRIGGER_REPEAT_END_DATE');
2698:
2699: AMS_Utility_PVT.Create_Log (

Line 2746: WF_ENGINE.CreateProcess (itemtype => itemtype, --itemtype,

2742: p_msg_data => 'Get_Aval_Repeat_Sch : 4.Creating Process',
2743: p_msg_type => 'DEBUG'
2744: );
2745:
2746: WF_ENGINE.CreateProcess (itemtype => itemtype, --itemtype,
2747: itemkey => l_item_key ,
2748: user_key => l_sch_det_rec.schedule_name,
2749: process => 'AMS_EXEC_ATTCH_SCH'); -- name of the process
2750:

Line 2773: p_msg_data => 'Get_Aval_Repeat_Sch : Setting WF Engine params',

2769: AMS_Utility_PVT.Create_Log (
2770: x_return_status => l_return_log_status,
2771: p_arc_log_used_by => 'TRIG',
2772: p_log_used_by_id => l_trigger_id,
2773: p_msg_data => 'Get_Aval_Repeat_Sch : Setting WF Engine params',
2774: p_msg_type => 'DEBUG'
2775: );
2776: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2777: ,itemkey => l_item_key

Line 2776: WF_ENGINE.SetItemAttrText(itemtype => itemtype

2772: p_log_used_by_id => l_trigger_id,
2773: p_msg_data => 'Get_Aval_Repeat_Sch : Setting WF Engine params',
2774: p_msg_type => 'DEBUG'
2775: );
2776: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2777: ,itemkey => l_item_key
2778: ,aname => 'AMS_SCHEDULE_OWNER'
2779: ,avalue => l_owner);
2780:

Line 2781: WF_ENGINE.SetItemAttrText(itemtype => itemtype

2777: ,itemkey => l_item_key
2778: ,aname => 'AMS_SCHEDULE_OWNER'
2779: ,avalue => l_owner);
2780:
2781: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2782: ,itemkey => l_item_key
2783: ,aname => 'AMS_REQUESTOR_USERNAME'
2784: ,avalue => l_owner);
2785:

Line 2788: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2784: ,avalue => l_owner);
2785:
2786:
2787: -- set schedule id
2788: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2789: itemkey => l_item_key,
2790: aname => 'AMS_SCHEDULE_ID',
2791: avalue => l_sch_det_rec.schedule_id);
2792:

Line 2794: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2790: aname => 'AMS_SCHEDULE_ID',
2791: avalue => l_sch_det_rec.schedule_id);
2792:
2793: -- set schedule name
2794: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2795: itemkey => l_item_key,
2796: aname => 'AMS_SCHEDULE_NAME',
2797: avalue => l_sch_det_rec.schedule_name);
2798:

Line 2811: WF_ENGINE.SetItemAttrText(itemtype => itemtype

2807: result := 'COMPLETE:ERROR';
2808: RETURN;
2809: END IF;
2810:
2811: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2812: ,itemkey => l_item_key
2813: ,aname => 'AMS_NOTIF_TO_USER_NAME'
2814: ,avalue => l_notify);
2815: ELSE

Line 2816: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2812: ,itemkey => l_item_key
2813: ,aname => 'AMS_NOTIF_TO_USER_NAME'
2814: ,avalue => l_notify);
2815: ELSE
2816: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2817: itemkey => l_item_key,
2818: aname => 'AMS_NOTIF_TO_USER_NAME',
2819: avalue => '' );
2820: END IF;

Line 2834: WF_ENGINE.SetItemAttrText(itemtype => itemtype

2830: result := 'COMPLETE:ERROR';
2831: RETURN;
2832: END IF;
2833:
2834: WF_ENGINE.SetItemAttrText(itemtype => itemtype
2835: ,itemkey => l_item_key
2836: ,aname => 'AMS_APPROVER_NAME'
2837: ,avalue => l_approver);
2838: ELSE

Line 2839: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2835: ,itemkey => l_item_key
2836: ,aname => 'AMS_APPROVER_NAME'
2837: ,avalue => l_approver);
2838: ELSE
2839: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2840: itemkey => l_item_key,
2841: aname => 'AMS_APPROVER_NAME',
2842: avalue => '' );
2843: END IF;

Line 2846: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,

2842: avalue => '' );
2843: END IF;
2844:
2845: -- soagrawa added setting all the other values...
2846: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2847: itemkey => l_item_key,
2848: aname => 'AMS_TRIGGER_ID',
2849: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2850: itemkey => itemkey ,

Line 2849: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

2845: -- soagrawa added setting all the other values...
2846: WF_ENGINE.SetItemAttrText(itemtype => itemtype ,
2847: itemkey => l_item_key,
2848: aname => 'AMS_TRIGGER_ID',
2849: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2850: itemkey => itemkey ,
2851: aname => 'AMS_TRIGGER_ID') );
2852:
2853: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 2853: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2849: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2850: itemkey => itemkey ,
2851: aname => 'AMS_TRIGGER_ID') );
2852:
2853: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2854: itemkey => l_item_key,
2855: aname => 'AMS_TRIGGER_NAME',
2856: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2857: itemkey => itemkey ,

Line 2856: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

2852:
2853: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2854: itemkey => l_item_key,
2855: aname => 'AMS_TRIGGER_NAME',
2856: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2857: itemkey => itemkey ,
2858: aname => 'AMS_TRIGGER_NAME') );
2859:
2860: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 2860: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2856: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2857: itemkey => itemkey ,
2858: aname => 'AMS_TRIGGER_NAME') );
2859:
2860: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2861: itemkey => l_item_key,
2862: aname => 'AMS_TRIGGER_SCHEDULE_DATE',
2863: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2864: itemkey => itemkey ,

Line 2863: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

2859:
2860: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2861: itemkey => l_item_key,
2862: aname => 'AMS_TRIGGER_SCHEDULE_DATE',
2863: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2864: itemkey => itemkey ,
2865: aname => 'AMS_TRIGGER_SCHEDULE_DATE') );
2866:
2867: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 2867: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2863: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2864: itemkey => itemkey ,
2865: aname => 'AMS_TRIGGER_SCHEDULE_DATE') );
2866:
2867: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2868: itemkey => l_item_key,
2869: aname => 'AMS_TRIGGER_DATE',
2870: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2871: itemkey => itemkey ,

Line 2870: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

2866:
2867: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2868: itemkey => l_item_key,
2869: aname => 'AMS_TRIGGER_DATE',
2870: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2871: itemkey => itemkey ,
2872: aname => 'AMS_TRIGGER_DATE') );
2873:
2874: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 2874: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2870: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2871: itemkey => itemkey ,
2872: aname => 'AMS_TRIGGER_DATE') );
2873:
2874: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2875: itemkey => l_item_key,
2876: aname => 'AMS_REPEAT_FREQUENCY_TYPE',
2877: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2878: itemkey => itemkey ,

Line 2877: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

2873:
2874: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2875: itemkey => l_item_key,
2876: aname => 'AMS_REPEAT_FREQUENCY_TYPE',
2877: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2878: itemkey => itemkey ,
2879: aname => 'AMS_REPEAT_FREQUENCY_TYPE') );
2880:
2881: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 2881: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2877: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2878: itemkey => itemkey ,
2879: aname => 'AMS_REPEAT_FREQUENCY_TYPE') );
2880:
2881: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2882: itemkey => l_item_key,
2883: aname => 'AMS_TRIGGER_REPEAT_END_DATE',
2884: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2885: itemkey => itemkey ,

Line 2884: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

2880:
2881: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2882: itemkey => l_item_key,
2883: aname => 'AMS_TRIGGER_REPEAT_END_DATE',
2884: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2885: itemkey => itemkey ,
2886: aname => 'AMS_TRIGGER_REPEAT_END_DATE') );
2887:
2888: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 2888: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2884: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2885: itemkey => itemkey ,
2886: aname => 'AMS_TRIGGER_REPEAT_END_DATE') );
2887:
2888: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2889: itemkey => l_item_key,
2890: aname => 'AMS_CAMPAIGN_NAME',
2891: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2892: itemkey => itemkey ,

Line 2891: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

2887:
2888: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2889: itemkey => l_item_key,
2890: aname => 'AMS_CAMPAIGN_NAME',
2891: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2892: itemkey => itemkey ,
2893: aname => 'AMS_CAMPAIGN_NAME') );
2894:
2895: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 2895: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2891: avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2892: itemkey => itemkey ,
2893: aname => 'AMS_CAMPAIGN_NAME') );
2894:
2895: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2896: -- itemkey => l_item_key,
2897: -- aname => 'AMS_CHK_MET_MSG',
2898: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2899: -- itemkey => itemkey ,

Line 2898: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

2894:
2895: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2896: -- itemkey => l_item_key,
2897: -- aname => 'AMS_CHK_MET_MSG',
2898: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2899: -- itemkey => itemkey ,
2900: -- aname => 'AMS_CHK_MET_MSG') );
2901:
2902:

Line 2903: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,

2899: -- itemkey => itemkey ,
2900: -- aname => 'AMS_CHK_MET_MSG') );
2901:
2902:
2903: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2904: -- itemkey => l_item_key,
2905: -- aname => 'AMS_NTF_MESSAGE',
2906: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2907: -- itemkey => itemkey ,

Line 2906: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,

2902:
2903: -- WF_ENGINE.SetItemAttrText(itemtype => itemtype,
2904: -- itemkey => l_item_key,
2905: -- aname => 'AMS_NTF_MESSAGE',
2906: -- avalue => WF_ENGINE.getItemAttrText(itemtype => itemtype,
2907: -- itemkey => itemkey ,
2908: -- aname => 'AMS_NTF_MESSAGE') );
2909:
2910: -- end soagrawa setting values

Line 2922: WF_ENGINE.SetItemParent(itemtype => itemtype

2918: );
2919:
2920:
2921: -- set the parent process
2922: WF_ENGINE.SetItemParent(itemtype => itemtype
2923: ,itemkey => l_item_key
2924: ,parent_itemtype => itemtype
2925: ,parent_itemkey => itemkey
2926: ,parent_context => NULL

Line 2929: WF_ENGINE.StartProcess (itemtype => itemtype,

2925: ,parent_itemkey => itemkey
2926: ,parent_context => NULL
2927: );
2928:
2929: WF_ENGINE.StartProcess (itemtype => itemtype,
2930: itemkey => l_item_key);
2931:
2932:
2933: AMS_Utility_PVT.Create_Log (

Line 3167: l_trigger_id := WF_ENGINE.GetItemAttrText(

3163:
3164: BEGIN
3165: IF (funcmode = 'RUN')
3166: THEN
3167: l_trigger_id := WF_ENGINE.GetItemAttrText(
3168: itemtype => itemtype,
3169: itemkey => itemkey ,
3170: aname => 'AMS_TRIGGER_ID');
3171:

Line 3252: l_trigger_id := WF_ENGINE.GetItemAttrText(

3248:
3249: BEGIN
3250: IF (funcmode = 'RUN')
3251: THEN
3252: l_trigger_id := WF_ENGINE.GetItemAttrText(
3253: itemtype => itemtype,
3254: itemkey => itemkey ,
3255: aname => 'AMS_TRIGGER_ID');
3256:

Line 3263: l_sch_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype,

3259: wf_event.AddParameterToList(p_name => 'AMS_TRIGGER_ID',
3260: p_value => l_trigger_id,
3261: p_parameterlist => l_parameter_list);
3262:
3263: l_sch_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype,
3264: itemkey => itemkey ,
3265: aname => 'AMS_TRIGGER_SCHEDULE_DATE'
3266: );
3267:

Line 3431: l_trigger_id := WF_ENGINE.GetItemAttrText(

3427: BEGIN
3428: IF (funcmode = 'RUN')
3429: THEN
3430:
3431: l_trigger_id := WF_ENGINE.GetItemAttrText(
3432: itemtype => itemtype,
3433: itemkey => itemkey ,
3434: aname => 'AMS_TRIGGER_ID');
3435:

Line 3477: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3473: CLOSE c_eveo_eone_det;
3474: END IF;
3475:
3476:
3477: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3478: itemkey => itemkey,
3479: aname => 'AMS_CAMPAIGN_NAME',
3480: avalue => l_monitor_obj_name );
3481:

Line 3497: Wf_Engine.SetItemOwner(itemtype => itemtype,

3493: p_name => l_user_name,
3494: p_display_name => l_disp_name );
3495:
3496: IF l_user_name IS NOT NULL THEN
3497: Wf_Engine.SetItemOwner(itemtype => itemtype,
3498: itemkey => itemkey,
3499: owner => l_user_name);
3500: END IF;
3501: END IF;

Line 3504: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3500: END IF;
3501: END IF;
3502: CLOSE c_emp_dtl;
3503:
3504: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3505: itemkey => itemkey,
3506: aname => 'AMS_TRIGGER_NAME',
3507: avalue => l_trig_rec.trigger_name );
3508:

Line 3509: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

3505: itemkey => itemkey,
3506: aname => 'AMS_TRIGGER_NAME',
3507: avalue => l_trig_rec.trigger_name );
3508:
3509: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
3510: itemkey => itemkey ,
3511: userkey => l_trig_rec.trigger_name);
3512:
3513: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 3513: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3509: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
3510: itemkey => itemkey ,
3511: userkey => l_trig_rec.trigger_name);
3512:
3513: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3514: itemkey => itemkey,
3515: aname => 'AMS_TRIGGER_SCHEDULE_DATE',
3516: avalue => to_char(l_trig_rec.start_date_time,'DD-MON-RRRR HH:MI:SS AM') );
3517:

Line 3519: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3515: aname => 'AMS_TRIGGER_SCHEDULE_DATE',
3516: avalue => to_char(l_trig_rec.start_date_time,'DD-MON-RRRR HH:MI:SS AM') );
3517:
3518: -- soagrawa set this value as other the first time around it would be empty
3519: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3520: itemkey => itemkey,
3521: aname => 'AMS_TRIGGER_DATE',
3522: avalue => to_char(l_trig_rec.start_date_time,'DD-MON-RRRR HH:MI:SS AM') );
3523:

Line 3524: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3520: itemkey => itemkey,
3521: aname => 'AMS_TRIGGER_DATE',
3522: avalue => to_char(l_trig_rec.start_date_time,'DD-MON-RRRR HH:MI:SS AM') );
3523:
3524: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3525: itemkey => itemkey,
3526: aname => 'AMS_REPEAT_FREQUENCY_TYPE',
3527: avalue => l_trig_rec.repeat_frequency_type );
3528:

Line 3529: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3525: itemkey => itemkey,
3526: aname => 'AMS_REPEAT_FREQUENCY_TYPE',
3527: avalue => l_trig_rec.repeat_frequency_type );
3528:
3529: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3530: itemkey => itemkey,
3531: aname => 'AMS_TRIGGER_REPEAT_END_DATE',
3532: avalue => to_char(l_trig_rec.repeat_stop_date_time,'DD-MON-RRRR HH:MI:SS AM') );
3533:

Line 3551: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3547: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3548: THEN
3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;
3551: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3552: itemkey => itemkey,
3553: aname => 'AMS_TRIG_NOTIFTIER',
3554: avalue => l_notify);
3555: ELSE

Line 3556: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3552: itemkey => itemkey,
3553: aname => 'AMS_TRIG_NOTIFTIER',
3554: avalue => l_notify);
3555: ELSE
3556: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3557: itemkey => itemkey,
3558: aname => 'AMS_TRIG_NOTIFTIER',
3559: avalue => '');
3560: END IF;

Line 3573: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3569: p_activity_type => l_trig_rec.arc_trigger_created_for,
3570: x_owner_user_name => l_username
3571: );
3572:
3573: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3574: itemkey => itemkey,
3575: aname => 'AMS_REQUESTOR_USERNAME',
3576: avalue => l_username );
3577:

Line 3587: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3583: OPEN c_metric_det(l_check_rec.chk1_source_code_metric_id);
3584: FETCH c_metric_det INTO l_metric_rec ;
3585: CLOSE c_metric_det;
3586:
3587: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3588: itemkey => itemkey,
3589: aname => 'AMS_OPERATOR',
3590: avalue => l_check_rec.chk1_to_chk2_operator_type);
3591: END IF;

Line 3616: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3612: l_priority := 50 ; -- standard
3613: END IF;
3614:
3615:
3616: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3617: itemkey => itemkey,
3618: aname => 'AMS_TIMEOUT',
3619: avalue => l_timeout_days );
3620:

Line 3676: l_trigger_id := WF_ENGINE.GetItemAttrText(

3672: BEGIN
3673: -- RUN mode - Normal Process Execution
3674: IF (funcmode = 'RUN')
3675: THEN
3676: l_trigger_id := WF_ENGINE.GetItemAttrText(
3677: itemtype => itemtype,
3678: itemkey => itemkey ,
3679: aname => 'AMS_TRIGGER_ID');
3680: