APPS.AHL_UC_APPROVALS_PVT SQL Statements

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

Line: 64

    SELECT unit_config_header_id, name, object_version_number,
       unit_config_status_code, active_uc_status_code, parent_uc_header_id
    FROM ahl_unit_config_headers
    WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
        AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
        AND unit_config_header_id = c_uc_header_id
        AND object_version_number = c_object_version_number;

Line: 163

             UPDATE  ahl_unit_config_headers
               SET unit_config_status_code='APPROVAL_PENDING',
               object_version_number=object_version_number+1
               WHERE unit_config_header_id=p_uc_header_id
               And object_version_number=p_object_version_number;

Line: 192

             UPDATE  ahl_unit_config_headers
               SET unit_config_status_code='APPROVAL_PENDING',
               object_version_number=object_version_number+1
               WHERE unit_config_header_id=p_uc_header_id
               And object_version_number=p_object_version_number;

Line: 248

            UPDATE  ahl_unit_config_headers
                SET active_uc_status_code='APPROVAL_PENDING',
                object_version_number=object_version_number+1
                WHERE unit_config_header_id=p_uc_header_id
                And object_version_number=p_object_version_number;

Line: 276

            UPDATE  ahl_unit_config_headers
                SET active_uc_status_code='APPROVAL_PENDING',
                object_version_number=object_version_number+1
                WHERE unit_config_header_id=p_uc_header_id
                And object_version_number=p_object_version_number;

Line: 421

    SELECT unit_config_header_id, name, object_version_number, unit_config_status_code, active_uc_status_code
    FROM ahl_unit_config_headers
    WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
        AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
        AND unit_config_header_id = c_uc_header_id;

Line: 522

        UPDATE ahl_unit_config_headers
        SET unit_config_status_code=l_status,
            active_uc_status_code='APPROVED',
            object_version_number=object_version_number+1
        WHERE unit_config_header_id=p_uc_header_id;

Line: 534

         UPDATE ahl_unit_config_headers
         SET unit_config_status_code=l_status,
             object_version_number=object_version_number+1
         WHERE unit_config_header_id=p_uc_header_id;

Line: 572

     UPDATE ahl_unit_config_headers
     SET active_uc_status_code=l_status
        ,unit_config_status_code = l_uc_status
     WHERE unit_config_header_id=p_uc_header_id;

Line: 690

     SELECT unit_config_header_id,
            name,
            object_version_number,
            unit_config_status_code,
            active_uc_status_code,
            parent_uc_header_id
       FROM ahl_unit_config_headers
      WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
        AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
        AND unit_config_header_id = c_uc_header_id
        AND object_version_number = c_object_version_number;

Line: 795

             UPDATE ahl_unit_config_headers
                SET active_uc_status_code='APPROVAL_PENDING',
                    unit_config_status_code='QUARANTINE',
                    object_version_number=object_version_number+1
              WHERE unit_config_header_id=p_uc_header_id
                AND object_version_number=p_object_version_number;

Line: 825

             UPDATE ahl_unit_config_headers
                SET active_uc_status_code = 'APPROVAL_PENDING',
                    unit_config_status_code='QUARANTINE',
                    object_version_number=object_version_number+1
              WHERE unit_config_header_id=p_uc_header_id
                And object_version_number=p_object_version_number;

Line: 960

     SELECT unit_config_header_id,
            name,
            object_version_number,
            unit_config_status_code,
            active_uc_status_code,
            parent_uc_header_id
       FROM ahl_unit_config_headers
      WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
        AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
        AND unit_config_header_id = c_uc_header_id
        AND object_version_number = c_object_version_number;

Line: 1060

             UPDATE ahl_unit_config_headers
                SET active_uc_status_code='APPROVAL_PENDING',
                    unit_config_status_code='DEACTIVATE_QUARANTINE',
                    object_version_number=object_version_number+1
              WHERE unit_config_header_id=p_uc_header_id
                AND object_version_number=p_object_version_number;

Line: 1090

             UPDATE ahl_unit_config_headers
                SET active_uc_status_code = 'APPROVAL_PENDING',
                    unit_config_status_code='DEACTIVATE_QUARANTINE',
                    object_version_number=object_version_number+1
              WHERE unit_config_header_id=p_uc_header_id
                And object_version_number=p_object_version_number;

Line: 1226

    SELECT unit_config_header_id,
           name,
           object_version_number,
           unit_config_status_code,
           active_uc_status_code
    FROM ahl_unit_config_headers
    WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
        AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
        AND unit_config_header_id = c_uc_header_id;

Line: 1357

           AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> Before Update');

Line: 1360

        UPDATE ahl_unit_config_headers
        SET unit_config_status_code=l_status,
            active_uc_status_code='APPROVED',
            object_version_number=object_version_number+1
        WHERE unit_config_header_id=p_uc_header_id;

Line: 1367

           AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> After Update');

Line: 1373

               AHL_DEBUG_PUB.debug('Unexpected Error during Update');