APPS.JTF_CAL_WF_PVT dependencies on DUAL

Line 326: FROM DUAL;

322: ** we need an itemkey
323: ***************************************************************************/
324:
325: SELECT to_char(jtf_cal_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(jtf_cal_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(jtf_cal_itemkey_s.NEXTVAL) INTO l_ItemKey
1004: FROM DUAL;
1005:
1006: /***************************************************************************
1007: ** Initialize the workflow
1008: ***************************************************************************/

Line 2319: FROM DUAL;

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