APPS.CAC_VIEW_WF_PVT dependencies on DUAL

Line 326: FROM DUAL;

322: ** we need an itemkey
323: ***************************************************************************/
324:
325: SELECT to_char(cac_vws_itemkey_s.NEXTVAL) INTO l_item_key
326: FROM DUAL;
327:
328: /*****************************************************************************
329: ** Look up the Calendar Administrator from the Profile (this should be an
330: ** existing WF_ROLE)

Line 601: FROM DUAL;

597: ** we need an itemkey
598: ***************************************************************************/
599:
600: SELECT to_char(cac_vws_itemkey_s.NEXTVAL) INTO l_item_key
601: FROM DUAL;
602:
603: IF (p_assignment_status_id <> 3 AND p_assignment_status_id <>4) THEN
604: fnd_message.set_name ('JTF', 'JTF_CAL_INVALID_ASSIGNMENT');
605: fnd_message.set_token ('ASSIGNMENT_STATUS_ID', p_assignment_status_id);

Line 1004: FROM DUAL;

1000: /*****************************************************************************
1001: ** Get a WF itemkey
1002: *****************************************************************************/
1003: SELECT to_char(cac_vws_itemkey_s.NEXTVAL) INTO l_ItemKey
1004: FROM DUAL;
1005:
1006: /***************************************************************************
1007: ** Initialize the workflow
1008: ***************************************************************************/

Line 2322: FROM DUAL;

2318: /***************************************************************************
2319: ** we need an itemkey
2320: ***************************************************************************/
2321: SELECT to_char(cac_vws_itemkey_s.NEXTVAL) INTO l_ItemKey
2322: FROM DUAL;
2323: /***************************************************************************
2324: ** Initialize the workflow
2325: ***************************************************************************/
2326: wf_engine.CreateProcess( itemtype => l_ItemType