APPS.CS_WF_EVENT_PKG dependencies on DUAL

Line 900: FROM dual;

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';
903:
904: -- Bug fix for 6069111.Added by bkanimoz on 12-Jun-2007

Line 949: FROM dual;

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';
952:
953: --RAISE the WF Business event.

Line 981: FROM dual;

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';
984:
985: --RAISE the WF Business event.

Line 998: FROM dual;

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';
1001:
1002: --RAISE the WF Business event.

Line 1074: FROM dual;

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
1077: l_event_key := p_Incident_Number ||'-'||to_char(l_event_id) || '-EVT';
1078: