APPS.JTF_EC_WORKFLOW_PKG dependencies on DUAL

Line 1061: FROM dual;

1057: -- Generate the unique WF process itemkey
1058: -------------------------------------------------------------------------
1059: cursor c_wf_key is
1060: SELECT jtf_task_workflow_process_s.nextval
1061: FROM dual;
1062:
1063: -------------------------------------------------------------------------
1064: -- Get esc document details
1065: -------------------------------------------------------------------------

Line 2029: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;

2025:
2026: BEGIN
2027: --Get the item key
2028: l_list := NULL;
2029: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2030: wf_event.addparametertolist ('TASK_ID', to_char(l_task_id), l_list);
2031:
2032: -- Raise the create task event
2033: wf_event.raise3(

Line 2086: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;

2082:
2083: BEGIN
2084: --Get the item key
2085: l_list := NULL;
2086: SELECT l_event_name ||'-'|| jtf_ec_wf_events_s.nextval INTO l_key FROM DUAL;
2087:
2088: wf_event.addparametertolist ('TASK_ID', to_char(l_esc_rec.task_id), l_list);
2089: wf_event.addparametertolist ('DOC_CREATED', l_esc_rec.doc_created, l_list);
2090: wf_event.addparametertolist ('OWNER_CHANGED', l_esc_rec.owner_changed, l_list);