APPS.CS_WF_EVENT_PKG dependencies on CS_WF_PROCESS_ID_S

Line 1247: SELECT cs_wf_process_id_s.nextval

1243:
1244: -- Check for Status Update event.
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';

Line 1300: SELECT cs_wf_process_id_s.nextval

1296: /* Roopa - end
1297: Fix for bug 2799545
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';

Line 1332: SELECT cs_wf_process_id_s.nextval

1328: ***********************************************/
1329:
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';

Line 1349: SELECT cs_wf_process_id_s.nextval

1345: -- To raise Associated Party Contact added business event
1346: --
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';

Line 1425: SELECT cs_wf_process_id_s.nextval

1421: RAISE l_INVALID_EVENT_CODE;
1422:
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