[Home] [Help]
545: -- Retrieve the current object version number of the link record so it may be passed to the private API
546: Begin
547: Select object_version_number
548: Into l_object_version_number
549: From cs_incident_links
550: Where link_id = p_link_id;
551: Exception
552: When OTHERS Then
553: Rollback to UPDATE_INCIDENTLINK_PUB;
1119: -- First retrieve the internal link attributes with which to search for the external link in the external link table
1120: Begin
1121: Select subject_id, object_id, object_number
1122: Into l_from_incident_id, l_to_object_id, l_to_object_number
1123: From cs_incident_links
1124: Where link_id = lx_link_id;
1125:
1126: Exception
1127: When Others Then
1131: -- Now query the external link table to retrieve the external link ID based on the retrieved attributes
1132: Begin
1133: Select link_id
1134: Into lx_link_id
1135: From cs_incident_links_ext
1136: Where from_incident_id = l_from_incident_id
1137: And to_object_id = l_to_object_id
1138: And to_object_number = l_to_object_number;
1139: Exception
1212:
1213: -- Cursor to fetch details of the external link to be updated
1214: cursor c_ext_link is
1215: select *
1216: from cs_incident_links_ext
1217: where link_id = p_link_id;
1218:
1219: -- Cursor variable to store data fetched from the cursor
1220: l_ext_link_rec c_ext_link%ROWTYPE;
1269: -- Also retrieve the object_version_number for the link record in the same query
1270: Begin
1271: Select link_id, object_version_number
1272: Into l_derived_internal_link_id, l_object_version_number
1273: From Cs_Incident_Links
1274: Where subject_id = l_ext_link_rec.from_incident_id
1275: And subject_type = 'SR'
1276: And object_id = l_ext_link_rec.to_object_id
1277: And object_type = l_ext_link_rec.to_object_type
1282: -- In case the external link was created with object type as 'SR' '
1283: Begin
1284: Select link_id, object_version_number
1285: Into l_derived_internal_link_id, l_object_version_number
1286: From Cs_Incident_Links
1287: Where object_id = l_ext_link_rec.from_incident_id
1288: And object_type = 'SR'
1289: And subject_id = l_ext_link_rec.to_object_id
1290: And subject_type = l_ext_link_rec.to_object_type
1483: l_derived_internal_link_id NUMBER;
1484:
1485: -- Cursor to fetch the details of the external link to be deleted
1486: cursor c_ext_link is
1487: select * from cs_incident_links_ext
1488: where link_id = p_link_id;
1489:
1490: -- Cursor variable to store the external link details
1491: l_ext_link_rec c_ext_link%ROWTYPE;
1532: -- Derive the internal link ID corresponding to the passed external link ID
1533: Begin
1534: Select link_id
1535: Into l_derived_internal_link_id
1536: From Cs_Incident_Links
1537: Where subject_id = l_ext_link_rec.from_incident_id
1538: And subject_type = 'SR'
1539: And object_id = l_ext_link_rec.to_object_id
1540: And object_type = l_ext_link_rec.to_object_type
1544: -- In case the external link was created with object type as 'SR'
1545: Begin
1546: Select link_id
1547: Into l_derived_internal_link_id
1548: From Cs_Incident_Links
1549: Where object_id = l_ext_link_rec.from_incident_id
1550: And object_type = 'SR'
1551: And subject_id = l_ext_link_rec.to_object_id
1552: And subject_type = l_ext_link_rec.to_object_type