DBA Data[Home] [Help]

APPS.CUG_LAUNCH_WORKFLOW_PVT dependencies on DUAL

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

91: FETCH l_servereq_csr INTO l_servereq_csr_rec;
92: -- EXIT WHEN l_servereq_csr%NOTFOUND;
93:
94: -- Construct the unique item key
95: SELECT cs_wf_process_id_s.NEXTVAL INTO l_wf_process_id FROM DUAL;
96: l_itemkey := l_servereq_csr_rec.incident_number || '-' || to_char(l_wf_process_id);
97:
98: -- Update the workflow process ID of the request
99: IF TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) IS NOT NULL THEN