DBA Data[Home] [Help]

APPS.CS_WF_EVENT_PKG dependencies on DUAL

Line 1249: FROM dual;

1245: IF (p_Old_SR_Rec.STATUS_ID <> p_New_SR_Rec.STATUS_ID) THEN
1246:
1247: SELECT cs_wf_process_id_s.nextval
1248: INTO l_event_id
1249: FROM dual;
1250: -- Construct the unique event key
1251: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1252: --Commented the below code for bug 7580964
1253: -- Bug fix for 6069111.Added by bkanimoz on 12-Jun-2007

Line 1302: FROM dual;

1298: */
1299:
1300: SELECT cs_wf_process_id_s.nextval
1301: INTO l_event_id
1302: FROM dual;
1303: -- Construct the unique event key
1304: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1305:
1306: --RAISE the WF Business event.

Line 1334: FROM dual;

1330: IF (l_new_contact_point_name IS NOT NULL) THEN
1331:
1332: SELECT cs_wf_process_id_s.nextval
1333: INTO l_event_id
1334: FROM dual;
1335: -- Construct the unique event key
1336: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1337:
1338: --RAISE the WF Business event.

Line 1351: FROM dual;

1347: IF (l_new_associated_party_name IS NOT NULL) THEN
1348:
1349: SELECT cs_wf_process_id_s.nextval
1350: INTO l_event_id
1351: FROM dual;
1352: -- Construct the unique event key
1353: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1354:
1355: --RAISE the WF Business event.

Line 1427: FROM dual;

1423: END IF;
1424:
1425: SELECT cs_wf_process_id_s.nextval
1426: INTO l_event_id
1427: FROM dual;
1428:
1429: -- Construct the unique event key
1430: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1431: