APPS.GMD_MONITORING_SPEC_VRS_PVT SQL Statements

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

Line: 27

FUNCTION insert_row (
  p_monitoring_spec_vrs IN  GMD_MONITORING_SPEC_VRS%ROWTYPE
, x_monitoring_spec_vrs OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
)
RETURN BOOLEAN IS
BEGIN

    x_monitoring_spec_vrs := p_monitoring_spec_vrs;

Line: 36

    INSERT INTO GMD_MONITORING_SPEC_VRS
  (SPEC_VR_ID
  ,SPEC_ID
  ,RULE_TYPE
  ,LOCATOR_ORGANIZATION_ID
  ,SUBINVENTORY
  ,LOCATOR_ID
  ,RESOURCES
  ,RESOURCE_ORGANIZATION_ID
  ,RESOURCE_INSTANCE_ID
  ,SPEC_VR_STATUS
  ,START_DATE
  ,END_DATE
  ,SAMPLING_PLAN_ID
  ,DELETE_MARK
  ,TEXT_CODE
  ,ATTRIBUTE_CATEGORY
  ,ATTRIBUTE1
  ,ATTRIBUTE2
  ,ATTRIBUTE3
  ,ATTRIBUTE4
  ,ATTRIBUTE5
  ,ATTRIBUTE6
  ,ATTRIBUTE7
  ,ATTRIBUTE8
  ,ATTRIBUTE9
  ,ATTRIBUTE10
  ,ATTRIBUTE11
  ,ATTRIBUTE12
  ,ATTRIBUTE13
  ,ATTRIBUTE14
  ,ATTRIBUTE15
  ,ATTRIBUTE16
  ,ATTRIBUTE17
  ,ATTRIBUTE18
  ,ATTRIBUTE19
  ,ATTRIBUTE20
  ,ATTRIBUTE21
  ,ATTRIBUTE22
  ,ATTRIBUTE23
  ,ATTRIBUTE24
  ,ATTRIBUTE25
  ,ATTRIBUTE26
  ,ATTRIBUTE27
  ,ATTRIBUTE28
  ,ATTRIBUTE29
  ,ATTRIBUTE30
  ,CREATION_DATE
  ,CREATED_BY
  ,LAST_UPDATED_BY
  ,LAST_UPDATE_DATE
  ,LAST_UPDATE_LOGIN
  ,MIGRATED_IND  --To differentiate R12 data from previous data during migration
  )
 VALUES
  (gmd_qc_spec_vr_id_s.NEXTVAL
  ,x_monitoring_spec_vrs.SPEC_ID
  ,x_monitoring_spec_vrs.RULE_TYPE
  ,x_monitoring_spec_vrs.LOCATOR_ORGANIZATION_ID
  ,x_monitoring_spec_vrs.SUBINVENTORY
  ,x_monitoring_spec_vrs.LOCATOR_ID
  ,x_monitoring_spec_vrs.RESOURCES
  ,x_monitoring_spec_vrs.RESOURCE_ORGANIZATION_ID
  ,x_monitoring_spec_vrs.RESOURCE_INSTANCE_ID
  ,x_monitoring_spec_vrs.SPEC_VR_STATUS
  ,x_monitoring_spec_vrs.START_DATE
  ,x_monitoring_spec_vrs.END_DATE
  ,x_monitoring_spec_vrs.SAMPLING_PLAN_ID
  ,x_monitoring_spec_vrs.DELETE_MARK
  ,x_monitoring_spec_vrs.TEXT_CODE
  ,x_monitoring_spec_vrs.ATTRIBUTE_CATEGORY
  ,x_monitoring_spec_vrs.ATTRIBUTE1
  ,x_monitoring_spec_vrs.ATTRIBUTE2
  ,x_monitoring_spec_vrs.ATTRIBUTE3
  ,x_monitoring_spec_vrs.ATTRIBUTE4
  ,x_monitoring_spec_vrs.ATTRIBUTE5
  ,x_monitoring_spec_vrs.ATTRIBUTE6
  ,x_monitoring_spec_vrs.ATTRIBUTE7
  ,x_monitoring_spec_vrs.ATTRIBUTE8
  ,x_monitoring_spec_vrs.ATTRIBUTE9
  ,x_monitoring_spec_vrs.ATTRIBUTE10
  ,x_monitoring_spec_vrs.ATTRIBUTE11
  ,x_monitoring_spec_vrs.ATTRIBUTE12
  ,x_monitoring_spec_vrs.ATTRIBUTE13
  ,x_monitoring_spec_vrs.ATTRIBUTE14
  ,x_monitoring_spec_vrs.ATTRIBUTE15
  ,x_monitoring_spec_vrs.ATTRIBUTE16
  ,x_monitoring_spec_vrs.ATTRIBUTE17
  ,x_monitoring_spec_vrs.ATTRIBUTE18
  ,x_monitoring_spec_vrs.ATTRIBUTE19
  ,x_monitoring_spec_vrs.ATTRIBUTE20
  ,x_monitoring_spec_vrs.ATTRIBUTE21
  ,x_monitoring_spec_vrs.ATTRIBUTE22
  ,x_monitoring_spec_vrs.ATTRIBUTE23
  ,x_monitoring_spec_vrs.ATTRIBUTE24
  ,x_monitoring_spec_vrs.ATTRIBUTE25
  ,x_monitoring_spec_vrs.ATTRIBUTE26
  ,x_monitoring_spec_vrs.ATTRIBUTE27
  ,x_monitoring_spec_vrs.ATTRIBUTE28
  ,x_monitoring_spec_vrs.ATTRIBUTE29
  ,x_monitoring_spec_vrs.ATTRIBUTE30
  ,x_monitoring_spec_vrs.CREATION_DATE
  ,x_monitoring_spec_vrs.CREATED_BY
  ,x_monitoring_spec_vrs.LAST_UPDATED_BY
  ,x_monitoring_spec_vrs.LAST_UPDATE_DATE
  ,x_monitoring_spec_vrs.LAST_UPDATE_LOGIN
  ,0)
        RETURNING spec_vr_id INTO x_monitoring_spec_vrs.spec_vr_id
     ;

Line: 154

      fnd_msg_pub.add_exc_msg ('GMD_MONITORING_SPEC_VRS_PVT', 'INSERT_ROW');

Line: 157

END insert_row;

Line: 163

FUNCTION delete_row (p_spec_vr_id        IN  NUMBER,
                     p_last_update_date  IN  DATE  ,
                     p_last_updated_by   IN  NUMBER,
                     p_last_update_login IN  NUMBER)
RETURN BOOLEAN IS

  dummy       PLS_INTEGER;

Line: 176

    SELECT 1
    INTO   dummy
    FROM   gmd_monitoring_spec_vrs
    WHERE  spec_vr_id = p_spec_vr_id
    FOR UPDATE NOWAIT;

Line: 182

    UPDATE gmd_monitoring_spec_vrs
    SET  delete_mark = 1,
         last_update_date  = NVL(p_last_update_date,SYSDATE),
         last_updated_by   = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
         last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
    WHERE  spec_vr_id = p_spec_vr_id
    ;

Line: 210

     fnd_msg_pub.add_exc_msg ('GMD_MONITORING_SPEC_VRS_PVT', 'DELETE_ROW');

Line: 213

END delete_row;

Line: 228

    SELECT 1
    INTO   dummy
    FROM   gmd_monitoring_spec_vrs
    WHERE  spec_vr_id = p_spec_vr_id
    FOR UPDATE NOWAIT;

Line: 249

     fnd_msg_pub.add_exc_msg ('GMD_MONITORING_SPEC_VRS_PVT', 'DELETE_ROW');

Line: 265

    SELECT *
    INTO   x_monitoring_spec_vrs
    FROM   gmd_monitoring_spec_vrs
    WHERE  spec_vr_id = p_monitoring_spec_vrs.spec_vr_id
    ;