APPS.GMD_CUSTOMER_SPEC_VRS_PVT SQL Statements

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

Line: 26

FUNCTION insert_row (
  p_customer_spec_vrs IN  GMD_CUSTOMER_SPEC_VRS%ROWTYPE
, x_customer_spec_vrs OUT NOCOPY GMD_CUSTOMER_SPEC_VRS%ROWTYPE
)
RETURN BOOLEAN IS
BEGIN

    x_customer_spec_vrs := p_customer_spec_vrs;

Line: 35

    INSERT INTO GMD_CUSTOMER_SPEC_VRS
     (
      SPEC_VR_ID
     ,SPEC_ID
     ,ORGANIZATION_ID
     ,CUST_ID
     ,ORDER_ID
     ,ORDER_LINE
     ,ORDER_LINE_ID
     ,SHIP_TO_SITE_ID
     ,ORG_ID
     ,SPEC_VR_STATUS
     ,START_DATE
     ,END_DATE
     ,SAMPLING_PLAN_ID
     ,SAMPLE_INV_TRANS_IND
     ,LOT_OPTIONAL_ON_SAMPLE
     ,COA_TYPE
     ,COA_AT_SHIP_IND
     ,COA_AT_INVOICE_IND
     ,COA_REQ_FROM_SUPL_IND
     ,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_customer_spec_vrs.SPEC_ID
     ,x_customer_spec_vrs.ORGANIZATION_ID
     ,x_customer_spec_vrs.CUST_ID
     ,x_customer_spec_vrs.ORDER_ID
     ,x_customer_spec_vrs.ORDER_LINE
     ,x_customer_spec_vrs.ORDER_LINE_ID
     ,x_customer_spec_vrs.SHIP_TO_SITE_ID
     ,x_customer_spec_vrs.ORG_ID
     ,x_customer_spec_vrs.SPEC_VR_STATUS
     ,x_customer_spec_vrs.START_DATE
     ,x_customer_spec_vrs.END_DATE
     ,x_customer_spec_vrs.SAMPLING_PLAN_ID
     ,x_customer_spec_vrs.SAMPLE_INV_TRANS_IND
     ,x_customer_spec_vrs.LOT_OPTIONAL_ON_SAMPLE
     ,x_customer_spec_vrs.COA_TYPE
     ,x_customer_spec_vrs.COA_AT_SHIP_IND
     ,x_customer_spec_vrs.COA_AT_INVOICE_IND
     ,x_customer_spec_vrs.COA_REQ_FROM_SUPL_IND
     ,x_customer_spec_vrs.DELETE_MARK
     ,x_customer_spec_vrs.TEXT_CODE
     ,x_customer_spec_vrs.ATTRIBUTE_CATEGORY
     ,x_customer_spec_vrs.ATTRIBUTE1
     ,x_customer_spec_vrs.ATTRIBUTE2
     ,x_customer_spec_vrs.ATTRIBUTE3
     ,x_customer_spec_vrs.ATTRIBUTE4
     ,x_customer_spec_vrs.ATTRIBUTE5
     ,x_customer_spec_vrs.ATTRIBUTE6
     ,x_customer_spec_vrs.ATTRIBUTE7
     ,x_customer_spec_vrs.ATTRIBUTE8
     ,x_customer_spec_vrs.ATTRIBUTE9
     ,x_customer_spec_vrs.ATTRIBUTE10
     ,x_customer_spec_vrs.ATTRIBUTE11
     ,x_customer_spec_vrs.ATTRIBUTE12
     ,x_customer_spec_vrs.ATTRIBUTE13
     ,x_customer_spec_vrs.ATTRIBUTE14
     ,x_customer_spec_vrs.ATTRIBUTE15
     ,x_customer_spec_vrs.ATTRIBUTE16
     ,x_customer_spec_vrs.ATTRIBUTE17
     ,x_customer_spec_vrs.ATTRIBUTE18
     ,x_customer_spec_vrs.ATTRIBUTE19
     ,x_customer_spec_vrs.ATTRIBUTE20
     ,x_customer_spec_vrs.ATTRIBUTE21
     ,x_customer_spec_vrs.ATTRIBUTE22
     ,x_customer_spec_vrs.ATTRIBUTE23
     ,x_customer_spec_vrs.ATTRIBUTE24
     ,x_customer_spec_vrs.ATTRIBUTE25
     ,x_customer_spec_vrs.ATTRIBUTE26
     ,x_customer_spec_vrs.ATTRIBUTE27
     ,x_customer_spec_vrs.ATTRIBUTE28
     ,x_customer_spec_vrs.ATTRIBUTE29
     ,x_customer_spec_vrs.ATTRIBUTE30
     ,x_customer_spec_vrs.CREATION_DATE
     ,x_customer_spec_vrs.CREATED_BY
     ,x_customer_spec_vrs.LAST_UPDATED_BY
     ,x_customer_spec_vrs.LAST_UPDATE_DATE
     ,x_customer_spec_vrs.LAST_UPDATE_LOGIN
     ,0
     )
        RETURNING spec_vr_id INTO x_customer_spec_vrs.spec_vr_id
     ;

Line: 168

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

Line: 171

END insert_row;

Line: 177

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: 190

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

Line: 196

    UPDATE gmd_customer_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: 224

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

Line: 227

END delete_row;

Line: 242

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

Line: 263

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

Line: 279

    SELECT *
    INTO   x_customer_spec_vrs
    FROM   gmd_customer_spec_vrs
    WHERE  spec_vr_id = p_customer_spec_vrs.spec_vr_id
    ;