DBA Data[Home] [Help]

APPS.CS_INCIDENTLINKS_PVT dependencies on DUAL

Line 298: from dual;

294: end if;
295: else
296: select cs_incident_links_s.nextval
297: into l_link_id
298: from dual;
299: end if;
300:
301: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
302: --

Line 590: from dual;

586: 1, 'PARENT',
587: 2, 'CHILD',
588: NULL)
589: into l_link_type
590: from dual;
591: if (l_link_type is not null) then
592: l_from_incident_id := p_link_rec.subject_id;
593: l_from_incident_number := lx_subject_number;
594: l_to_incident_id := p_link_rec.object_Id;

Line 781: from dual;

777: 1, 'PARENT',
778: 2, 'CHILD',
779: NULL)
780: into l_link_type
781: from dual;
782:
783: if (l_link_type is not null) then -- swap the subject and object info. of the main link
784: l_from_incident_id := p_link_rec.object_id;
785: l_from_incident_number := lx_object_number;