eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_QUA_PVT SQL Statements

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

Line: 44


    SELECT
 	QUALIFIER_ID
 	,CREATION_DATE
 	,CREATED_BY
 	,LAST_UPDATE_DATE
 	,LAST_UPDATED_BY
 	,REQUEST_ID
 	,PROGRAM_APPLICATION_ID
 	,PROGRAM_ID
 	,PROGRAM_UPDATE_DATE
 	,LAST_UPDATE_LOGIN
 	,QUALIFIER_GROUPING_NO
 	,QUALIFIER_CONTEXT
 	,QUALIFIER_ATTRIBUTE
 	,QUALIFIER_ATTR_VALUE
 	,COMPARISON_OPERATOR_CODE
 	,EXCLUDER_FLAG
 	,QUALIFIER_RULE_ID
 	,START_DATE_ACTIVE
 	,END_DATE_ACTIVE
 	,CREATED_FROM_RULE_ID
 	,QUALIFIER_PRECEDENCE
 	,LIST_HEADER_ID
 	,LIST_LINE_ID
 	,QUALIFIER_DATATYPE
 	,QUALIFIER_ATTR_VALUE_TO
 	,CONTEXT
 	,ATTRIBUTE1
 	,ATTRIBUTE2
 	,ATTRIBUTE3
 	,ATTRIBUTE4
 	,ATTRIBUTE5
 	,ATTRIBUTE6
 	,ATTRIBUTE7
 	,ATTRIBUTE8
 	,ATTRIBUTE9
 	,ATTRIBUTE10
 	,ATTRIBUTE11
 	,ATTRIBUTE12
 	,ATTRIBUTE13
 	,ATTRIBUTE14
 	,ATTRIBUTE15
 	,ACTIVE_FLAG
 	,LIST_TYPE_CODE
 	,QUAL_ATTR_VALUE_FROM_NUMBER
 	,QUAL_ATTR_VALUE_TO_NUMBER
      FROM oks_qualifiers
     WHERE qualifier_id = p_id;

Line: 102


 	,l_qua_rec.LAST_UPDATE_DATE
 	,l_qua_rec.LAST_UPDATED_BY
 	,l_qua_rec.REQUEST_ID
 	,l_qua_rec.PROGRAM_APPLICATION_ID
 	,l_qua_rec.PROGRAM_ID
 	,l_qua_rec.PROGRAM_UPDATE_DATE
 	,l_qua_rec.LAST_UPDATE_LOGIN
 	,l_qua_rec.QUALIFIER_GROUPING_NO
 	,l_qua_rec.QUALIFIER_CONTEXT
 	,l_qua_rec.QUALIFIER_ATTRIBUTE
 	,l_qua_rec.QUALIFIER_ATTR_VALUE
 	,l_qua_rec.COMPARISON_OPERATOR_CODE
 	,l_qua_rec.EXCLUDER_FLAG
 	,l_qua_rec.QUALIFIER_RULE_ID
 	,l_qua_rec.START_DATE_ACTIVE
 	,l_qua_rec.END_DATE_ACTIVE
 	,l_qua_rec.CREATED_FROM_RULE_ID
 	,l_qua_rec.QUALIFIER_PRECEDENCE
 	,l_qua_rec.LIST_HEADER_ID
 	,l_qua_rec.LIST_LINE_ID
 	,l_qua_rec.QUALIFIER_DATATYPE
 	,l_qua_rec.QUALIFIER_ATTR_VALUE_TO
 	,l_qua_rec.CONTEXT
 	,l_qua_rec.ATTRIBUTE1
 	,l_qua_rec.ATTRIBUTE2
 	,l_qua_rec.ATTRIBUTE3
 	,l_qua_rec.ATTRIBUTE4
 	,l_qua_rec.ATTRIBUTE5
 	,l_qua_rec.ATTRIBUTE6
 	,l_qua_rec.ATTRIBUTE7
 	,l_qua_rec.ATTRIBUTE8
 	,l_qua_rec.ATTRIBUTE9
 	,l_qua_rec.ATTRIBUTE10
 	,l_qua_rec.ATTRIBUTE11
 	,l_qua_rec.ATTRIBUTE12
 	,l_qua_rec.ATTRIBUTE13
 	,l_qua_rec.ATTRIBUTE14
 	,l_qua_rec.ATTRIBUTE15
 	,l_qua_rec.ACTIVE_FLAG
 	,l_qua_rec.LIST_TYPE_CODE
 	,l_qua_rec.QUAL_ATTR_VALUE_FROM_NUMBER
 	,l_qua_rec.QUAL_ATTR_VALUE_TO_NUMBER            ;

Line: 165


    SELECT
 QUALIFIER_ID
 ,CREATION_DATE
 ,CREATED_BY
 ,LAST_UPDATE_DATE
 ,LAST_UPDATED_BY
 ,REQUEST_ID
 ,PROGRAM_APPLICATION_ID
 ,PROGRAM_ID
 ,PROGRAM_UPDATE_DATE
 ,LAST_UPDATE_LOGIN
 ,QUALIFIER_GROUPING_NO
 ,QUALIFIER_CONTEXT
 ,QUALIFIER_ATTRIBUTE
 ,QUALIFIER_ATTR_VALUE
 ,COMPARISON_OPERATOR_CODE
 ,EXCLUDER_FLAG
 ,QUALIFIER_RULE_ID
 ,START_DATE_ACTIVE
 ,END_DATE_ACTIVE
 ,CREATED_FROM_RULE_ID
 ,QUALIFIER_PRECEDENCE
 ,LIST_HEADER_ID
 ,LIST_LINE_ID
 ,QUALIFIER_DATATYPE
 ,QUALIFIER_ATTR_VALUE_TO
 ,CONTEXT
 ,ATTRIBUTE1
 ,ATTRIBUTE2
 ,ATTRIBUTE3
 ,ATTRIBUTE4
 ,ATTRIBUTE5
 ,ATTRIBUTE6
 ,ATTRIBUTE7
 ,ATTRIBUTE8
 ,ATTRIBUTE9
 ,ATTRIBUTE10
 ,ATTRIBUTE11
 ,ATTRIBUTE12
 ,ATTRIBUTE13
 ,ATTRIBUTE14
 ,ATTRIBUTE15
 ,ACTIVE_FLAG
 ,LIST_TYPE_CODE
 ,QUAL_ATTR_VALUE_FROM_NUMBER
 ,QUAL_ATTR_VALUE_TO_NUMBER
      FROM Oks_QUALIFIERS_V
     WHERE oks_qualifiers_v.qualifier_id = p_id;

Line: 223


 ,l_quav_rec.LAST_UPDATE_DATE
 ,l_quav_rec.LAST_UPDATED_BY
 ,l_quav_rec.REQUEST_ID
 ,l_quav_rec.PROGRAM_APPLICATION_ID
 ,l_quav_rec.PROGRAM_ID
 ,l_quav_rec.PROGRAM_UPDATE_DATE
 ,l_quav_rec.LAST_UPDATE_LOGIN
 ,l_quav_rec.QUALIFIER_GROUPING_NO
 ,l_quav_rec.QUALIFIER_CONTEXT
 ,l_quav_rec.QUALIFIER_ATTRIBUTE
 ,l_quav_rec.QUALIFIER_ATTR_VALUE
 ,l_quav_rec.COMPARISON_OPERATOR_CODE
 ,l_quav_rec.EXCLUDER_FLAG
 ,l_quav_rec.QUALIFIER_RULE_ID
 ,l_quav_rec.START_DATE_ACTIVE
 ,l_quav_rec.END_DATE_ACTIVE
 ,l_quav_rec.CREATED_FROM_RULE_ID
 ,l_quav_rec.QUALIFIER_PRECEDENCE
 ,l_quav_rec.LIST_HEADER_ID
 ,l_quav_rec.LIST_LINE_ID
 ,l_quav_rec.QUALIFIER_DATATYPE
 ,l_quav_rec.QUALIFIER_ATTR_VALUE_TO
 ,l_quav_rec.CONTEXT
 ,l_quav_rec.ATTRIBUTE1
 ,l_quav_rec.ATTRIBUTE2
 ,l_quav_rec.ATTRIBUTE3
 ,l_quav_rec.ATTRIBUTE4
 ,l_quav_rec.ATTRIBUTE5
 ,l_quav_rec.ATTRIBUTE6
 ,l_quav_rec.ATTRIBUTE7
 ,l_quav_rec.ATTRIBUTE8
 ,l_quav_rec.ATTRIBUTE9
 ,l_quav_rec.ATTRIBUTE10
 ,l_quav_rec.ATTRIBUTE11
 ,l_quav_rec.ATTRIBUTE12
 ,l_quav_rec.ATTRIBUTE13
 ,l_quav_rec.ATTRIBUTE14
 ,l_quav_rec.ATTRIBUTE15
 ,l_quav_rec.ACTIVE_FLAG
 ,l_quav_rec.LIST_TYPE_CODE
 ,l_quav_rec.QUAL_ATTR_VALUE_FROM_NUMBER
 ,l_quav_rec.QUAL_ATTR_VALUE_TO_NUMBER            ;

Line: 297


    IF (l_quav_rec.last_update_date  = OKC_API.G_MISS_DATE) THEN
      l_quav_rec.last_update_date := NULL;

Line: 300


    IF (l_quav_rec.last_updated_by  = OKC_API.G_MISS_NUM) THEN
      l_quav_rec.last_updated_by := NULL;

Line: 511


 PROCEDURE validate_last_update_by(x_return_status OUT NOCOPY varchar2,
                                p_id   IN  Number)
  Is
  l_return_status         VARCHAR2(1)  := OKC_API.G_RET_STS_SUCCESS;

Line: 522


      OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_by');

Line: 541


  End validate_last_update_by;

Line: 543


 PROCEDURE validate_last_update_date(x_return_status OUT NOCOPY varchar2,
                                p_date   IN  DATE)
  Is
  l_return_status         VARCHAR2(1)  := OKC_API.G_RET_STS_SUCCESS;

Line: 554


      OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');

Line: 573


  End validate_last_update_date;

Line: 1537


    validate_last_update_date(x_return_status, p_quav_rec.last_update_date);

Line: 1551


    validate_last_update_by(x_return_status, p_quav_rec.last_updated_by);

Line: 2102


      SELECT
 	QUALIFIER_RULE_ID  ,
 	CREATION_DATE      ,
 	CREATED_BY         ,
 	LAST_UPDATE_DATE       ,
 	LAST_UPDATED_BY        ,
 	PROGRAM_APPLICATION_ID ,
 	PROGRAM_ID             ,
 	PROGRAM_UPDATE_DATE    ,
 	REQUEST_ID             ,
 	LAST_UPDATE_LOGIN  ,
 	NAME               ,
 	DESCRIPTION        ,
 	CONTEXT            ,
 	ATTRIBUTE1         ,
 	ATTRIBUTE2         ,
 	ATTRIBUTE3         ,
 	ATTRIBUTE4         ,
 	ATTRIBUTE5         ,
 	ATTRIBUTE6         ,
 	ATTRIBUTE7         ,
 	ATTRIBUTE8         ,
 	ATTRIBUTE9         ,
 	ATTRIBUTE10        ,
 	ATTRIBUTE11        ,
 	ATTRIBUTE12        ,
 	ATTRIBUTE13        ,
 	ATTRIBUTE14        ,
 	ATTRIBUTE15
        FROM Oks_QUALIFIER_RULES_V
       WHERE OKS_QUALIFIER_RULES_V.qualifier_rule_id = p_id;

Line: 2175


 p_to.LAST_UPDATE_DATE  := p_from.LAST_UPDATE_DATE;

Line: 2176


 p_to.LAST_UPDATED_BY   := p_from.LAST_UPDATED_BY ;

Line: 2180


 p_to.PROGRAM_UPDATE_DATE     := p_from.PROGRAM_UPDATE_DATE    ;

Line: 2181


 p_to.LAST_UPDATE_LOGIN       := p_from.LAST_UPDATE_LOGIN     ;

Line: 2229


 p_to.LAST_UPDATE_DATE  := p_from.LAST_UPDATE_DATE;

Line: 2230


 p_to.LAST_UPDATED_BY   := p_from.LAST_UPDATED_BY ;

Line: 2234


 p_to.PROGRAM_UPDATE_DATE     := p_from.PROGRAM_UPDATE_DATE    ;

Line: 2235


 p_to.LAST_UPDATE_LOGIN       := p_from.LAST_UPDATE_LOGIN     ;

Line: 2423


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qua_rec                      IN qua_rec_type,
    x_qua_rec                      OUT NOCOPY qua_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2432


    l_api_name                     CONSTANT VARCHAR2(30) := 'LINES_insert_row';

Line: 2468


    INSERT INTO OKS_QUALIFIERS(
 QUALIFIER_ID
 ,CREATION_DATE
 ,CREATED_BY
 ,LAST_UPDATE_DATE
 ,LAST_UPDATED_BY
 ,REQUEST_ID
 ,PROGRAM_APPLICATION_ID
 ,PROGRAM_ID
 ,PROGRAM_UPDATE_DATE
 ,LAST_UPDATE_LOGIN
 ,QUALIFIER_GROUPING_NO
 ,QUALIFIER_CONTEXT
 ,QUALIFIER_ATTRIBUTE
 ,QUALIFIER_ATTR_VALUE
 ,COMPARISON_OPERATOR_CODE
 ,EXCLUDER_FLAG
 ,QUALIFIER_RULE_ID
 ,START_DATE_ACTIVE
 ,END_DATE_ACTIVE
 ,CREATED_FROM_RULE_ID
 ,QUALIFIER_PRECEDENCE
 ,LIST_HEADER_ID
 ,LIST_LINE_ID
 ,QUALIFIER_DATATYPE
 ,QUALIFIER_ATTR_VALUE_TO
 ,CONTEXT
 ,ATTRIBUTE1
 ,ATTRIBUTE2
 ,ATTRIBUTE3
 ,ATTRIBUTE4
 ,ATTRIBUTE5
 ,ATTRIBUTE6
 ,ATTRIBUTE7
 ,ATTRIBUTE8
 ,ATTRIBUTE9
 ,ATTRIBUTE10
 ,ATTRIBUTE11
 ,ATTRIBUTE12
 ,ATTRIBUTE13
 ,ATTRIBUTE14
 ,ATTRIBUTE15
 ,ACTIVE_FLAG
 ,LIST_TYPE_CODE
 ,QUAL_ATTR_VALUE_FROM_NUMBER
 ,QUAL_ATTR_VALUE_TO_NUMBER            )
      VALUES (
 l_qua_rec.QUALIFIER_ID
 ,l_qua_rec.CREATION_DATE
 ,l_qua_rec.CREATED_BY
 ,l_qua_rec.LAST_UPDATE_DATE
 ,l_qua_rec.LAST_UPDATED_BY
 ,l_qua_rec.REQUEST_ID
 ,l_qua_rec.PROGRAM_APPLICATION_ID
 ,l_qua_rec.PROGRAM_ID
 ,l_qua_rec.PROGRAM_UPDATE_DATE
 ,l_qua_rec.LAST_UPDATE_LOGIN
 ,l_qua_rec.QUALIFIER_GROUPING_NO
 ,l_qua_rec.QUALIFIER_CONTEXT
 ,l_qua_rec.QUALIFIER_ATTRIBUTE
 ,l_qua_rec.QUALIFIER_ATTR_VALUE
 ,l_qua_rec.COMPARISON_OPERATOR_CODE
 ,l_qua_rec.EXCLUDER_FLAG
 ,l_qua_rec.QUALIFIER_RULE_ID
 ,l_qua_rec.START_DATE_ACTIVE
 ,l_qua_rec.END_DATE_ACTIVE
 ,l_qua_rec.CREATED_FROM_RULE_ID
 ,l_qua_rec.QUALIFIER_PRECEDENCE
 ,l_qua_rec.LIST_HEADER_ID
 ,l_qua_rec.LIST_LINE_ID
 ,l_qua_rec.QUALIFIER_DATATYPE
 ,l_qua_rec.QUALIFIER_ATTR_VALUE_TO
 ,l_qua_rec.CONTEXT
 ,l_qua_rec.ATTRIBUTE1
 ,l_qua_rec.ATTRIBUTE2
 ,l_qua_rec.ATTRIBUTE3
 ,l_qua_rec.ATTRIBUTE4
 ,l_qua_rec.ATTRIBUTE5
 ,l_qua_rec.ATTRIBUTE6
 ,l_qua_rec.ATTRIBUTE7
 ,l_qua_rec.ATTRIBUTE8
 ,l_qua_rec.ATTRIBUTE9
 ,l_qua_rec.ATTRIBUTE10
 ,l_qua_rec.ATTRIBUTE11
 ,l_qua_rec.ATTRIBUTE12
 ,l_qua_rec.ATTRIBUTE13
 ,l_qua_rec.ATTRIBUTE14
 ,l_qua_rec.ATTRIBUTE15
 ,l_qua_rec.ACTIVE_FLAG
 ,l_qua_rec.LIST_TYPE_CODE
 ,l_qua_rec.QUAL_ATTR_VALUE_FROM_NUMBER
 ,l_qua_rec.QUAL_ATTR_VALUE_TO_NUMBER            );

Line: 2594


  END insert_row;

Line: 2598


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_quav_rec                     IN quav_rec_type,
    x_quav_rec                     OUT NOCOPY quav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2608


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 2624


      l_quav_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2625


      l_quav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2626


      l_quav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2690


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qua_rec,
      lx_qua_rec
    );

Line: 2738


  END insert_row;

Line: 2742


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_quav_tbl                     IN quav_tbl_type,
    x_quav_tbl                     OUT NOCOPY quav_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2752


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 2761


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_quav_rec                     => p_quav_tbl(i),
          x_quav_rec                     => x_quav_tbl(i));

Line: 2804


  END insert_row;

Line: 2823


    SELECT qualifier_id
      FROM OKS_QUALIFIERS
    WHERE QUALIFIER_ID = p_qua_rec.qualifier_id;

Line: 2849


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2855


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 3042


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qua_rec                      IN qua_rec_type,
    x_qua_rec                      OUT NOCOPY qua_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3051


    l_api_name                     CONSTANT VARCHAR2(30) := 'LINES_update_row';

Line: 3088


      IF (x_qua_rec.last_update_date = OKC_API.G_MISS_DATE)
        OR (x_qua_rec.last_update_date IS NULL)
      THEN
        x_qua_rec.last_update_date := l_qua_rec.last_update_date;

Line: 3093


      IF (x_qua_rec.last_updated_BY = OKC_API.G_MISS_NUM)
        OR (x_qua_rec.last_updated_by IS NULL)
      THEN
        x_qua_rec.last_updated_BY := l_qua_rec.last_updated_BY;

Line: 3315


    UPDATE  OKS_QUALIFIERS
    SET
 QUALIFIER_ID =                   l_def_qua_rec.QUALIFIER_ID   ,
 CREATION_DATE      =            l_def_qua_rec.CREATION_DATE   ,
 CREATED_BY         = l_def_qua_rec.CREATED_BY       ,
 LAST_UPDATE_DATE   = l_def_qua_rec.LAST_UPDATE_DATE ,
 LAST_UPDATED_BY    = l_def_qua_rec.LAST_UPDATED_BY   ,
 REQUEST_ID                  = l_def_qua_rec.REQUEST_ID        ,
 PROGRAM_APPLICATION_ID      = l_def_qua_rec.PROGRAM_APPLICATION_ID ,
 PROGRAM_ID                 = l_def_qua_rec.PROGRAM_ID              ,
 PROGRAM_UPDATE_DATE       = l_def_qua_rec.PROGRAM_UPDATE_DATE     ,
 LAST_UPDATE_LOGIN         = l_def_qua_rec.LAST_UPDATE_LOGIN       ,
 QUALIFIER_GROUPING_NO     = l_def_qua_rec.QUALIFIER_GROUPING_NO   ,
 QUALIFIER_CONTEXT         = l_def_qua_rec.QUALIFIER_CONTEXT  ,
 QUALIFIER_ATTRIBUTE       = l_def_qua_rec.QUALIFIER_ATTRIBUTE,
 QUALIFIER_ATTR_VALUE      = l_def_qua_rec.QUALIFIER_ATTR_VALUE,
 COMPARISON_OPERATOR_CODE  = l_def_qua_rec.COMPARISON_OPERATOR_CODE  ,
 EXCLUDER_FLAG             = l_def_qua_rec.EXCLUDER_FLAG             ,
 QUALIFIER_RULE_ID         = l_def_qua_rec.QUALIFIER_RULE_ID  ,
 START_DATE_ACTIVE        =  l_def_qua_rec.START_DATE_ACTIVE       ,
 END_DATE_ACTIVE          = l_def_qua_rec.END_DATE_ACTIVE         ,
 CREATED_FROM_RULE_ID     = l_def_qua_rec.CREATED_FROM_RULE_ID   ,
 QUALIFIER_PRECEDENCE     = l_def_qua_rec.QUALIFIER_PRECEDENCE   ,
 LIST_HEADER_ID           = l_def_qua_rec.LIST_HEADER_ID         ,
 LIST_LINE_ID             = l_def_qua_rec.LIST_LINE_ID           ,
 QUALIFIER_DATATYPE       = l_def_qua_rec.QUALIFIER_DATATYPE     ,
 QUALIFIER_ATTR_VALUE_TO  = l_def_qua_rec.QUALIFIER_ATTR_VALUE_TO ,
 CONTEXT                  =  l_def_qua_rec.CONTEXT     ,
 ATTRIBUTE1               = l_def_qua_rec.ATTRIBUTE1   ,
 ATTRIBUTE2               = l_def_qua_rec.ATTRIBUTE2    ,
 ATTRIBUTE3               = l_def_qua_rec.ATTRIBUTE3    ,
 ATTRIBUTE4               = l_def_qua_rec.ATTRIBUTE4    ,
 ATTRIBUTE5               = l_def_qua_rec.ATTRIBUTE5    ,
 ATTRIBUTE6               = l_def_qua_rec.ATTRIBUTE6       ,
 ATTRIBUTE7               = l_def_qua_rec.ATTRIBUTE7           ,
 ATTRIBUTE8               = l_def_qua_rec.ATTRIBUTE8           ,
 ATTRIBUTE9               = l_def_qua_rec.ATTRIBUTE9            ,
 ATTRIBUTE10              = l_def_qua_rec.ATTRIBUTE10           ,
 ATTRIBUTE11              = l_def_qua_rec.ATTRIBUTE11          ,
 ATTRIBUTE12                     = l_def_qua_rec.ATTRIBUTE12          ,
 ATTRIBUTE13                     = l_def_qua_rec.ATTRIBUTE13          ,
 ATTRIBUTE14              = l_def_qua_rec.ATTRIBUTE14                 ,
 ATTRIBUTE15             = l_def_qua_rec.ATTRIBUTE15                ,
 ACTIVE_FLAG             = l_def_qua_rec.ACTIVE_FLAG               ,
 LIST_TYPE_CODE          = l_def_qua_rec.LIST_TYPE_CODE           ,
 QUAL_ATTR_VALUE_FROM_NUMBER           = l_def_qua_rec.QUAL_ATTR_VALUE_FROM_NUMBER          ,
 QUAL_ATTR_VALUE_TO_NUMBER             = l_def_qua_rec.QUAL_ATTR_VALUE_TO_NUMBER
 WHere qualifier_id = l_def_qua_rec.qualifier_id;

Line: 3397


  END update_row;

Line: 3401


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_quav_rec                     IN quav_rec_type,
    x_quav_rec                     OUT NOCOPY quav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3411


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 3425


      l_quav_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3426


      l_quav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3427


      l_quav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3462


      IF (x_quav_rec.last_updated_by = OKC_API.G_MISS_NUM)
        OR (x_quav_rec.last_updated_by IS NULL)
      THEN
        x_quav_rec.last_updated_by := l_quav_rec.last_updated_by;

Line: 3467


      IF (x_quav_rec.last_update_date = OKC_API.G_MISS_DATE)
        OR (x_quav_rec.last_update_date IS NULL)
      THEN
        x_quav_rec.last_update_date := l_quav_rec.last_update_date;

Line: 3709


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qua_rec,
      lx_qua_rec
    );

Line: 3756


  END update_row;

Line: 3760


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_quav_tbl                     IN quav_tbl_type,
    x_quav_tbl                     OUT NOCOPY quav_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3770


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 3779


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_quav_rec                     => p_quav_tbl(i),
          x_quav_rec                     => x_quav_tbl(i));

Line: 3822


  END update_row;

Line: 3830


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_qua_rec                      IN qua_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3838


    l_api_name                     CONSTANT VARCHAR2(30) := 'LINES_delete_row';

Line: 3852


    DELETE FROM OKS_QUALIFIERS
     WHERE QUALIFIER_ID = l_qua_rec.qualifier_id;

Line: 3887


  END delete_row;

Line: 3891


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_quav_rec                     IN quav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3900


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 3924


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_qua_rec
    );

Line: 3968


  END delete_row;

Line: 3972


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_quav_tbl                     IN quav_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3981


    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 3990


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_quav_rec                     => p_quav_tbl(i));

Line: 4032


  END delete_row;