APPS.CS_WF_EVENT_PKG dependencies on CS_WF_PROCESS_ID_S

Line 898: SELECT cs_wf_process_id_s.nextval

894:
895: -- Check for Status Update event.
896: IF (p_Old_SR_Rec.STATUS_ID <> p_New_SR_Rec.STATUS_ID) THEN
897:
898: SELECT cs_wf_process_id_s.nextval
899: INTO l_event_id
900: FROM dual;
901: -- Construct the unique event key
902: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';

Line 947: SELECT cs_wf_process_id_s.nextval

943: /* Roopa - end
944: Fix for bug 2799545
945: */
946:
947: SELECT cs_wf_process_id_s.nextval
948: INTO l_event_id
949: FROM dual;
950: -- Construct the unique event key
951: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';

Line 979: SELECT cs_wf_process_id_s.nextval

975: ***********************************************/
976:
977: IF (l_new_contact_point_name IS NOT NULL) THEN
978:
979: SELECT cs_wf_process_id_s.nextval
980: INTO l_event_id
981: FROM dual;
982: -- Construct the unique event key
983: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';

Line 996: SELECT cs_wf_process_id_s.nextval

992: -- To raise Associated Party Contact added business event
993: --
994: IF (l_new_associated_party_name IS NOT NULL) THEN
995:
996: SELECT cs_wf_process_id_s.nextval
997: INTO l_event_id
998: FROM dual;
999: -- Construct the unique event key
1000: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';

Line 1072: SELECT cs_wf_process_id_s.nextval

1068: RAISE l_INVALID_EVENT_CODE;
1069:
1070: END IF;
1071:
1072: SELECT cs_wf_process_id_s.nextval
1073: INTO l_event_id
1074: FROM dual;
1075:
1076: -- Construct the unique event key