APPS.CS_SYSTEM_LINK_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

    SELECT party_id
    FROM CS_SYSTEM_PARTY_LINKS
    WHERE party_id = p_party_id
    AND system_id = p_system_id
    AND end_date is null;

Line: 46

        SELECT CS_SYSTEM_PARTY_LINKS_S1.NEXTVAL
		INTO   l_link_id
		FROM   dual;

Line: 50

        INSERT INTO CS_SYSTEM_PARTY_LINKS
        (
        party_id,
        system_id,
        start_date,
        last_update_date,
        last_updated_by,
        created_by,
        creation_date,
        system_party_link_id,
        object_version_number
        )
        VALUES
        (
        p_party_id,
        p_system_id,
        sysdate,
        sysdate,
        G_USER,
        G_USER,
        sysdate,
        l_link_id,
        1
        );

Line: 87

            FND_MESSAGE.SET_NAME('CS','CS_INSERT_UNEXP_ERR');

Line: 115

    SELECT party_id
    FROM CS_SYSTEM_PARTY_LINKS
    WHERE party_id = p_party_id
    AND system_id = p_system_id
    AND end_date is null;

Line: 143

       UPDATE CS_SYSTEM_PARTY_LINKS SET
       end_date = sysdate,
       last_update_date = sysdate,
       last_updated_by = G_USER,
       object_version_number = object_version_number + 1
       WHERE party_id = p_party_id AND system_id = p_system_id AND end_date is null;

Line: 162

          FND_MESSAGE.SET_NAME('CS','CS_UPDATE_UNEXP_ERR');

Line: 189

    SELECT system_id
    FROM CS_SYSTEMS_ALL_VL
    WHERE name = p_system_name;

Line: 259

    SELECT system_id
    FROM CS_SYSTEMS_ALL_VL
    WHERE name = p_system_name;

Line: 333

    SELECT 'x'
    FROM CS_SYSTEM_SR_LINKS
    WHERE incident_id = p_service_request_id
    AND system_id = p_system_id
    AND end_date is null;

Line: 352

        SELECT CS_SYSTEM_SR_LINKS_S1.NEXTVAL
		INTO   l_link_id
		FROM   dual;

Line: 356

        INSERT INTO CS_SYSTEM_SR_LINKS
        (
        incident_id,
        system_id,
        start_date,
        last_update_date,
        last_updated_by,
        created_by,
        creation_date,
        system_sr_link_id,
        object_version_number
        )
        VALUES
        (
        p_service_request_id,
        p_system_id,
        sysdate,
        sysdate,
        G_USER,
        G_USER,
        sysdate,
        l_link_id,
        1
        );

Line: 392

            FND_MESSAGE.SET_NAME('CS','CS_INSERT_UNEXP_ERR');

Line: 421

    SELECT 'x'
    FROM CS_SYSTEM_SR_LINKS
    WHERE incident_id = p_service_request_id
    AND system_id = p_system_id
    AND end_date is null;

Line: 450

        UPDATE CS_SYSTEM_SR_LINKS SET
        end_date = sysdate,
        last_update_date = sysdate,
        last_updated_by = G_USER,
        object_version_number = object_version_number + 1
        WHERE incident_id = p_service_request_id AND system_id = p_system_id AND end_date is null;

Line: 468

            FND_MESSAGE.SET_NAME('CS','CS_UPDATE_UNEXP_ERR');

Line: 495

    SELECT system_id
    FROM CS_SYSTEMS_ALL_VL
    WHERE name = p_system_name;

Line: 565

    SELECT system_id
    FROM CS_SYSTEMS_ALL_VL
    WHERE name = p_system_name;