APPS.CS_SYSTEM_LINK_UTIL dependencies on CS_SYSTEM_SR_LINKS

Line 334: FROM CS_SYSTEM_SR_LINKS

330: l_dummy VARCHAR2(1);
331:
332: CURSOR c1 IS
333: SELECT 'x'
334: FROM CS_SYSTEM_SR_LINKS
335: WHERE incident_id = p_service_request_id
336: AND system_id = p_system_id
337: AND end_date is null;
338:

Line 352: SELECT CS_SYSTEM_SR_LINKS_S1.NEXTVAL

348: OPEN c1;
349: FETCH c1 INTO l_dummy;
350: -- If there is no present link then insert.
351: IF c1%NOTFOUND THEN
352: SELECT CS_SYSTEM_SR_LINKS_S1.NEXTVAL
353: INTO l_link_id
354: FROM dual;
355:
356: INSERT INTO CS_SYSTEM_SR_LINKS

Line 356: INSERT INTO CS_SYSTEM_SR_LINKS

352: SELECT CS_SYSTEM_SR_LINKS_S1.NEXTVAL
353: INTO l_link_id
354: FROM dual;
355:
356: INSERT INTO CS_SYSTEM_SR_LINKS
357: (
358: incident_id,
359: system_id,
360: start_date,

Line 422: FROM CS_SYSTEM_SR_LINKS

418: l_dummy VARCHAR2(1);
419:
420: CURSOR c1 IS
421: SELECT 'x'
422: FROM CS_SYSTEM_SR_LINKS
423: WHERE incident_id = p_service_request_id
424: AND system_id = p_system_id
425: AND end_date is null;
426:

Line 450: UPDATE CS_SYSTEM_SR_LINKS SET

446: );
447: x_java_msg := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
448: ELSE
449: -- Will only update the end_date of the links that have end_date = null
450: UPDATE CS_SYSTEM_SR_LINKS SET
451: end_date = sysdate,
452: last_update_date = sysdate,
453: last_updated_by = G_USER,
454: object_version_number = object_version_number + 1