APPS.AHL_REPAIR_CATEGORIES_PVT SQL Statements

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

Line: 40

    SELECT  name
    FROM    cs_incident_urgencies_vl
    WHERE   incident_urgency_id = sru_id AND
            trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) AND
            trunc(sysdate) < trunc(nvl(end_date_active, sysdate + 1));

Line: 51

    SELECT  incident_urgency_id
    FROM    cs_incident_urgencies_vl
    WHERE   name = sr_name AND
            trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) AND
            trunc(sysdate) < trunc(nvl(end_date_active, sysdate + 1));

Line: 62

    SELECT  'x'
    FROM    ahl_repair_categories
    WHERE   sr_urgency_id = srurg_id;

Line: 72

    SELECT  'x'
    FROM    ahl_repair_categories
    WHERE   nvl(repair_time, -1) = nvl(reptime, -1) AND
            (repcat_id is null or repcat_id <> repair_category_id);

Line: 82

    SELECT  'x'
    FROM    ahl_mel_cdl_ata_sequences
    WHERE   repair_category_id = rep_cat_id;

Line: 92

    SELECT  'x'
    FROM    ahl_repair_categories
    WHERE   repair_category_id = rep_cat_id AND
            sr_urgency_id = sr_id;

Line: 148

                    DELETE FROM ahl_repair_categories
                    WHERE repair_category_id = p_x_repair_category_tbl(i).repair_category_id;

Line: 151

                    SELECT  cssr.name
                    INTO    p_x_repair_category_tbl(i).incident_urgency_name
                    FROM    cs_incident_urgencies_vl cssr , ahl_repair_categories repcat
                    WHERE   repcat.sr_urgency_id = cssr.incident_urgency_id AND
                            repcat.repair_category_id = p_x_repair_category_tbl(i).repair_category_id;

Line: 256

                UPDATE  AHL_REPAIR_CATEGORIES
                SET     OBJECT_VERSION_NUMBER   = p_x_repair_category_tbl(i).object_version_number,
                        LAST_UPDATE_DATE        = G_SYSDATE,
                        LAST_UPDATED_BY         = G_USER_ID,
                        LAST_UPDATE_LOGIN       = G_LOGIN_ID,
                        REPAIR_TIME             = p_x_repair_category_tbl(i).repair_time,
                        SR_URGENCY_ID           = p_x_repair_category_tbl(i).incident_urgency_id,
                        ATTRIBUTE_CATEGORY      = p_x_repair_category_tbl(i).attribute_category,
                        ATTRIBUTE1              = p_x_repair_category_tbl(i).attribute1,
                        ATTRIBUTE2              = p_x_repair_category_tbl(i).attribute2,
                        ATTRIBUTE3              = p_x_repair_category_tbl(i).attribute3,
                        ATTRIBUTE4              = p_x_repair_category_tbl(i).attribute4,
                        ATTRIBUTE5              = p_x_repair_category_tbl(i).attribute5,
                        ATTRIBUTE6              = p_x_repair_category_tbl(i).attribute6,
                        ATTRIBUTE7              = p_x_repair_category_tbl(i).attribute7,
                        ATTRIBUTE8              = p_x_repair_category_tbl(i).attribute8,
                        ATTRIBUTE9              = p_x_repair_category_tbl(i).attribute9,
                        ATTRIBUTE10             = p_x_repair_category_tbl(i).attribute10,
                        ATTRIBUTE11             = p_x_repair_category_tbl(i).attribute11,
                        ATTRIBUTE12             = p_x_repair_category_tbl(i).attribute12,
                        ATTRIBUTE13             = p_x_repair_category_tbl(i).attribute13,
                        ATTRIBUTE14             = p_x_repair_category_tbl(i).attribute14,
                        ATTRIBUTE15             = p_x_repair_category_tbl(i).attribute15
                WHERE   REPAIR_CATEGORY_ID = p_x_repair_category_tbl(i).repair_category_id;

Line: 287

                        'Update repair category ' ||p_x_repair_category_tbl(i).repair_category_id
                    );

Line: 371

                    select ahl_repair_categories_s.nextval into p_x_repair_category_tbl(i).repair_category_id from dual;

Line: 375

                INSERT INTO AHL_REPAIR_CATEGORIES
                (
                    REPAIR_CATEGORY_ID,
                    OBJECT_VERSION_NUMBER,
                    LAST_UPDATE_DATE,
                    LAST_UPDATED_BY,
                    CREATION_DATE,
                    CREATED_BY,
                    LAST_UPDATE_LOGIN,
                    REPAIR_TIME,
                    SR_URGENCY_ID,
                    ATTRIBUTE_CATEGORY,
                    ATTRIBUTE1,
                    ATTRIBUTE2,
                    ATTRIBUTE3,
                    ATTRIBUTE4,
                    ATTRIBUTE5,
                    ATTRIBUTE6,
                    ATTRIBUTE7,
                    ATTRIBUTE8,
                    ATTRIBUTE9,
                    ATTRIBUTE10,
                    ATTRIBUTE11,
                    ATTRIBUTE12,
                    ATTRIBUTE13,
                    ATTRIBUTE14,
                    ATTRIBUTE15
                )
                VALUES
                (
                    p_x_repair_category_tbl(i).repair_category_id,
                    p_x_repair_category_tbl(i).object_version_number,
                    G_SYSDATE,
                    G_USER_ID,
                    G_SYSDATE,
                    G_USER_ID,
                    G_LOGIN_ID,
                    p_x_repair_category_tbl(i).repair_time,
                    p_x_repair_category_tbl(i).incident_urgency_id,
                    p_x_repair_category_tbl(i).attribute_category,
                    p_x_repair_category_tbl(i).attribute1,
                    p_x_repair_category_tbl(i).attribute2,
                    p_x_repair_category_tbl(i).attribute3,
                    p_x_repair_category_tbl(i).attribute4,
                    p_x_repair_category_tbl(i).attribute5,
                    p_x_repair_category_tbl(i).attribute6,
                    p_x_repair_category_tbl(i).attribute7,
                    p_x_repair_category_tbl(i).attribute8,
                    p_x_repair_category_tbl(i).attribute9,
                    p_x_repair_category_tbl(i).attribute10,
                    p_x_repair_category_tbl(i).attribute11,
                    p_x_repair_category_tbl(i).attribute12,
                    p_x_repair_category_tbl(i).attribute13,
                    p_x_repair_category_tbl(i).attribute14,
                    p_x_repair_category_tbl(i).attribute15
                );

Line: 522

    SELECT  object_version_number
    FROM    ahl_repair_categories
    WHERE   repair_category_id = p_rep_cat_id;