DBA Data[Home] [Help]

APPS.CUG_INCIDNT_ATTR_VALS_PVT dependencies on CS_WF_PROCESS_ID_S

Line 227: SELECT cs_wf_process_id_s.NEXTVAL INTO l_wf_process_id FROM DUAL;

223: FETCH l_servereq_csr INTO l_servereq_csr_rec;
224: -- EXIT WHEN l_servereq_csr%NOTFOUND;
225:
226: -- Construct the unique item key
227: SELECT cs_wf_process_id_s.NEXTVAL INTO l_wf_process_id FROM DUAL;
228: l_itemkey := l_servereq_csr_rec.incident_number || '-' || to_char(l_wf_process_id);
229:
230: -- Update the workflow process ID of the request
231: IF TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) IS NOT NULL THEN