APPS.CS_INCIDENTLINKS_UTIL dependencies on CS_INCIDENT_LINKS

Line 375: from cs_incident_links

371: -- Rule : Two linked objects cannot have more than one link pair between them.
372:
373: select count(*)
374: into l_dummy
375: from cs_incident_links
376: where subject_id = p_subject_id
377: and subject_type = p_subject_type
378: and object_id = p_object_id
379: and object_type = p_object_type

Line 439: from cs_incident_links

435: -- add link_type_id as a parameter.
436:
437: cursor c1 is
438: select object_id
439: from cs_incident_links
440: start with ( subject_id = p_object_id
441: and subject_type = p_object_type
442: and link_type_id = p_link_type_id
443: and SYSDATE between nvl(start_date_active, SYSDATE)

Line 560: from cs_incident_links

556: -- the new object, depending on which one has the existing dup of link.
557: cursor c1 (c_sub_obj_id NUMBER,
558: c_sub_obj_type VARCHAR2 ) is
559: select object_type, object_number
560: from cs_incident_links
561: where subject_id = c_sub_obj_id
562: and subject_type = c_sub_obj_type
563: and link_type_id = 3 -- Duplicate Of
564: and SYSDATE between nvl(start_date_active, SYSDATE)

Line 581: from cs_incident_links

577: -- In this case the new object_id and type are passed to the cursor.
578: cursor c2 (c_sub_obj_id NUMBER,
579: c_sub_obj_type VARCHAR2 ) is
580: select link_type_id
581: from cs_incident_links
582: where subject_id = c_sub_obj_id
583: and subject_type = c_sub_obj_type
584: and link_type_id in (1, 2, 3, 4) --causals and Orig/Dup link type ids.
585: and SYSDATE between nvl(start_date_active, SYSDATE)