DBA Data[Home] [Help]

APPS.QP_CON_UTIL SQL Statements

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

Line: 146

        IF NOT QP_GLOBALS.Equal(p_CON_rec.last_updated_by,p_old_CON_rec.last_updated_by)
        THEN
            l_index := l_index + 1;
Line: 149

            l_src_attr_tbl(l_index) := QP_CON_UTIL.G_LAST_UPDATED_BY;
Line: 152

        IF NOT QP_GLOBALS.Equal(p_CON_rec.last_update_date,p_old_CON_rec.last_update_date)
        THEN
            l_index := l_index + 1;
Line: 155

            l_src_attr_tbl(l_index) := QP_CON_UTIL.G_LAST_UPDATE_DATE;
Line: 158

        IF NOT QP_GLOBALS.Equal(p_CON_rec.last_update_login,p_old_CON_rec.last_update_login)
        THEN
            l_index := l_index + 1;
Line: 161

            l_src_attr_tbl(l_index) := QP_CON_UTIL.G_LAST_UPDATE_LOGIN;
Line: 194

        IF NOT QP_GLOBALS.Equal(p_CON_rec.program_update_date,p_old_CON_rec.program_update_date)
        THEN
            l_index := l_index + 1;
Line: 197

            l_src_attr_tbl(l_index) := QP_CON_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 287

    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        l_index := l_index + 1;
Line: 289

        l_src_attr_tbl(l_index) := QP_CON_UTIL.G_LAST_UPDATED_BY;
Line: 290

    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        l_index := l_index + 1;
Line: 292

        l_src_attr_tbl(l_index) := QP_CON_UTIL.G_LAST_UPDATE_DATE;
Line: 293

    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        l_index := l_index + 1;
Line: 295

        l_src_attr_tbl(l_index) := QP_CON_UTIL.G_LAST_UPDATE_LOGIN;
Line: 311

    ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
        l_index := l_index + 1;
Line: 313

        l_src_attr_tbl(l_index) := QP_CON_UTIL.G_PROGRAM_UPDATE_DATE;
Line: 443

    IF NOT QP_GLOBALS.Equal(p_CON_rec.last_updated_by,p_old_CON_rec.last_updated_by)
    THEN
        NULL;
Line: 448

    IF NOT QP_GLOBALS.Equal(p_CON_rec.last_update_date,p_old_CON_rec.last_update_date)
    THEN
        NULL;
Line: 453

    IF NOT QP_GLOBALS.Equal(p_CON_rec.last_update_login,p_old_CON_rec.last_update_login)
    THEN
        NULL;
Line: 483

    IF NOT QP_GLOBALS.Equal(p_CON_rec.program_update_date,p_old_CON_rec.program_update_date)
    THEN
        NULL;
Line: 601

    IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_CON_rec.last_updated_by := p_old_CON_rec.last_updated_by;
Line: 605

    IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_CON_rec.last_update_date := p_old_CON_rec.last_update_date;
Line: 609

    IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_CON_rec.last_update_login := p_old_CON_rec.last_update_login;
Line: 633

    IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_CON_rec.program_update_date := p_old_CON_rec.program_update_date;
Line: 746

    IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_CON_rec.last_updated_by := NULL;
Line: 750

    IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_CON_rec.last_update_date := NULL;
Line: 754

    IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_CON_rec.last_update_login := NULL;
Line: 778

    IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_CON_rec.program_update_date := NULL;
Line: 808

PROCEDURE Update_Row
(   p_CON_rec                       IN  QP_Attributes_PUB.Con_Rec_Type
)
IS
BEGIN

    UPDATE  QP_PRC_CONTEXTS_b
    SET     ATTRIBUTE1                     = p_CON_rec.attribute1
    ,       ATTRIBUTE10                    = p_CON_rec.attribute10
    ,       ATTRIBUTE11                    = p_CON_rec.attribute11
    ,       ATTRIBUTE12                    = p_CON_rec.attribute12
    ,       ATTRIBUTE13                    = p_CON_rec.attribute13
    ,       ATTRIBUTE14                    = p_CON_rec.attribute14
    ,       ATTRIBUTE15                    = p_CON_rec.attribute15
    ,       ATTRIBUTE2                     = p_CON_rec.attribute2
    ,       ATTRIBUTE3                     = p_CON_rec.attribute3
    ,       ATTRIBUTE4                     = p_CON_rec.attribute4
    ,       ATTRIBUTE5                     = p_CON_rec.attribute5
    ,       ATTRIBUTE6                     = p_CON_rec.attribute6
    ,       ATTRIBUTE7                     = p_CON_rec.attribute7
    ,       ATTRIBUTE8                     = p_CON_rec.attribute8
    ,       ATTRIBUTE9                     = p_CON_rec.attribute9
    ,       CONTEXT                        = p_CON_rec.context
    ,       CREATED_BY                     = p_CON_rec.created_by
    ,       CREATION_DATE                  = p_CON_rec.creation_date
    ,       ENABLED_FLAG                   = p_CON_rec.enabled_flag
    ,       LAST_UPDATED_BY                = p_CON_rec.last_updated_by
    ,       LAST_UPDATE_DATE               = p_CON_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_CON_rec.last_update_login
    ,       PRC_CONTEXT_CODE               = p_CON_rec.prc_context_code
    ,       PRC_CONTEXT_ID                 = p_CON_rec.prc_context_id
    ,       PRC_CONTEXT_TYPE               = p_CON_rec.prc_context_type
    ,       PROGRAM_APPLICATION_ID         = p_CON_rec.program_application_id
    ,       PROGRAM_ID                     = p_CON_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_CON_rec.program_update_date
    ,       SEEDED_FLAG                    = p_CON_rec.seeded_flag
    WHERE   PRC_CONTEXT_ID = p_CON_rec.prc_context_id ;
Line: 846

  update  qp_prc_contexts_tl
      set     created_by                     = p_con_rec.created_by
      ,       creation_date                  = p_con_rec.creation_date
      ,       last_updated_by                = p_con_rec.last_updated_by
      ,       last_update_date               = p_con_rec.last_update_date
      ,       last_update_login              = p_con_rec.last_update_login
      ,       seeded_prc_context_name        = p_con_rec.seeded_prc_context_name
      ,       user_prc_context_name          = p_con_rec.user_prc_context_name
      ,       seeded_description             = p_con_rec.seeded_description
      ,       user_description               = p_con_rec.user_description
      ,       source_lang                    = userenv('LANG')
      where   prc_context_id = p_con_rec.prc_context_id and
              source_lang = userenv('LANG');
Line: 863

      FND_DESCR_FLEX_CONTEXTS_PKG.UPDATE_ROW(
         X_APPLICATION_ID => 661, --:CONTEXT.APPLICATION_ID,
         X_DESCRIPTIVE_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_PRICING',
         X_DESCRIPTIVE_FLEX_CONTEXT_COD => p_CON_rec.prc_context_code,
         X_ENABLED_FLAG => p_CON_rec.ENABLED_FLAG,
         X_GLOBAL_FLAG => 'N',
         X_DESCRIPTION => substr(p_CON_rec.user_description,1,240),
         X_DESCRIPTIVE_FLEX_CONTEXT_NAM => substr(p_CON_rec.user_prc_context_name,1,80),
         X_LAST_UPDATE_DATE => p_CON_rec.LAST_UPDATE_DATE,
         X_LAST_UPDATED_BY => p_CON_rec.LAST_UPDATED_BY,
         X_LAST_UPDATE_LOGIN => p_CON_rec.LAST_UPDATE_LOGIN);
Line: 884

            ,   'Update_Row'
            );
Line: 890

END Update_Row;
Line: 894

PROCEDURE Insert_Row
(   p_CON_rec                       IN  QP_Attributes_PUB.Con_Rec_Type
)
IS
   l_row_id    varchar2(25);
Line: 910

    oe_debug_pub.add('last_update_date=' || p_CON_rec.last_update_date);
Line: 911

    oe_debug_pub.add('last_updated_by=' || p_CON_rec.last_updated_by);
Line: 914

    INSERT  INTO QP_PRC_CONTEXTS_b
    (       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PRC_CONTEXT_code
    ,       PRC_CONTEXT_ID
    ,       PRC_CONTEXT_TYPE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       SEEDED_FLAG
    )
    VALUES
    (       p_CON_rec.attribute1
    ,       p_CON_rec.attribute10
    ,       p_CON_rec.attribute11
    ,       p_CON_rec.attribute12
    ,       p_CON_rec.attribute13
    ,       p_CON_rec.attribute14
    ,       p_CON_rec.attribute15
    ,       p_CON_rec.attribute2
    ,       p_CON_rec.attribute3
    ,       p_CON_rec.attribute4
    ,       p_CON_rec.attribute5
    ,       p_CON_rec.attribute6
    ,       p_CON_rec.attribute7
    ,       p_CON_rec.attribute8
    ,       p_CON_rec.attribute9
    ,       p_CON_rec.context
    ,       p_CON_rec.created_by
    ,       p_CON_rec.creation_date
    ,       p_CON_rec.enabled_flag
    ,       p_CON_rec.last_updated_by
    ,       p_CON_rec.last_update_date
    ,       p_CON_rec.last_update_login
    ,       p_CON_rec.prc_context_code
    ,       p_CON_rec.prc_context_id
    ,       p_CON_rec.prc_context_type
    ,       p_CON_rec.program_application_id
    ,       p_CON_rec.program_id
    ,       p_CON_rec.program_update_date
    ,       p_CON_rec.seeded_flag
    );
Line: 977

    INSERT  INTO qp_prc_contexts_tl
    (       CREATED_BY
    ,       CREATION_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       prc_context_id
    ,       seeded_prc_context_name
    ,       user_prc_context_name
    ,       seeded_description
    ,       user_description
    ,       language
    ,       source_lang
    )
    SELECT  p_CON_rec.created_by
    ,       p_CON_rec.creation_date
    ,       p_CON_rec.last_updated_by
    ,       p_CON_rec.last_update_date
    ,       p_CON_rec.last_update_login
    ,       p_CON_rec.prc_context_id
    ,       p_CON_rec.seeded_prc_context_name
    ,       p_CON_rec.user_prc_context_name
    ,       p_CON_rec.seeded_description
    ,       p_CON_rec.user_description
    ,       L.language_code
    ,       userenv('LANG')
    from  FND_LANGUAGES  L
    where  L.INSTALLED_FLAG in ('I', 'B')
    and    not exists
           ( select NULL
             from  qp_prc_contexts_tl T
             where  T.prc_context_id = p_CON_rec.prc_context_id
             and  T.LANGUAGE = L.LANGUAGE_CODE );
Line: 1013

      FND_DESCR_FLEX_CONTEXTS_PKG.INSERT_ROW(
          X_ROWID => l_row_id,
          X_APPLICATION_ID => 661, --:CONTEXT.APPLICATION_ID,
          X_DESCRIPTIVE_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_PRICING',
          X_DESCRIPTIVE_FLEX_CONTEXT_COD => p_CON_rec.prc_context_code,
          X_ENABLED_FLAG => p_CON_rec.ENABLED_FLAG,
          X_GLOBAL_FLAG => 'N',
          X_DESCRIPTION => substr(p_CON_rec.user_description,1,240),
          X_DESCRIPTIVE_FLEX_CONTEXT_NAM => substr(p_CON_rec.user_prc_context_name,1,80),
          X_CREATION_DATE => p_CON_rec.CREATION_DATE,
          X_CREATED_BY => p_CON_rec.CREATED_BY,
          X_LAST_UPDATE_DATE => p_CON_rec.LAST_UPDATE_DATE,
          X_LAST_UPDATED_BY => p_CON_rec.LAST_UPDATED_BY,
          X_LAST_UPDATE_LOGIN => p_CON_rec.LAST_UPDATE_LOGIN);
Line: 1037

            ,   'Insert_Row'
            );
Line: 1043

END Insert_Row;
Line: 1047

PROCEDURE Delete_Row
(   p_prc_context_id                IN  NUMBER
)
IS
   l_qp_prc_contexts_rec     qp_prc_contexts_b%rowtype;
Line: 1053

      select *
      into l_qp_prc_contexts_rec
      from qp_prc_contexts_b
      where prc_context_id =  p_prc_context_id;
Line: 1058

    DELETE  FROM QP_PRC_CONTEXTS_tl
    WHERE   PRC_CONTEXT_ID = p_prc_context_id ;
Line: 1060

    DELETE  FROM QP_PRC_CONTEXTS_b
    WHERE   PRC_CONTEXT_ID = p_prc_context_id ;
Line: 1069

        FND_DESCR_FLEX_CONTEXTS_PKG.DELETE_ROW(
          X_APPLICATION_ID => 661, --:CONTEXT.APPLICATION_ID,
          X_DESCRIPTIVE_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_PRICING',
          X_DESCRIPTIVE_FLEX_CONTEXT_COD => l_qp_prc_contexts_rec.prc_context_code);
Line: 1087

            ,   'Delete_Row'
            );
Line: 1093

END Delete_Row;
Line: 1104

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PRC_CONTEXT_code
    ,       PRC_CONTEXT_ID
    ,       PRC_CONTEXT_TYPE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       SEEDED_DESCRIPTION
    ,       SEEDED_FLAG
    ,       SEEDED_PRC_CONTEXT_NAME
    ,       USER_DESCRIPTION
    ,       USER_PRC_CONTEXT_NAME
    INTO    l_CON_rec.attribute1
    ,       l_CON_rec.attribute10
    ,       l_CON_rec.attribute11
    ,       l_CON_rec.attribute12
    ,       l_CON_rec.attribute13
    ,       l_CON_rec.attribute14
    ,       l_CON_rec.attribute15
    ,       l_CON_rec.attribute2
    ,       l_CON_rec.attribute3
    ,       l_CON_rec.attribute4
    ,       l_CON_rec.attribute5
    ,       l_CON_rec.attribute6
    ,       l_CON_rec.attribute7
    ,       l_CON_rec.attribute8
    ,       l_CON_rec.attribute9
    ,       l_CON_rec.context
    ,       l_CON_rec.created_by
    ,       l_CON_rec.creation_date
    ,       l_CON_rec.enabled_flag
    ,       l_CON_rec.last_updated_by
    ,       l_CON_rec.last_update_date
    ,       l_CON_rec.last_update_login
    ,       l_CON_rec.prc_context_code
    ,       l_CON_rec.prc_context_id
    ,       l_CON_rec.prc_context_type
    ,       l_CON_rec.program_application_id
    ,       l_CON_rec.program_id
    ,       l_CON_rec.program_update_date
    ,       l_CON_rec.seeded_description
    ,       l_CON_rec.seeded_flag
    ,       l_CON_rec.seeded_prc_context_name
    ,       l_CON_rec.user_description
    ,       l_CON_rec.user_prc_context_name
    FROM    QP_PRC_CONTEXTS_V
    WHERE   PRC_CONTEXT_ID = p_prc_context_id
    ;
Line: 1204

    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       ENABLED_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       PRC_CONTEXT_code
    ,       PRC_CONTEXT_ID
    ,       PRC_CONTEXT_TYPE
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       SEEDED_DESCRIPTION
    ,       SEEDED_FLAG
    ,       SEEDED_PRC_CONTEXT_NAME
    ,       USER_DESCRIPTION
    ,       USER_PRC_CONTEXT_NAME
    INTO    l_CON_rec.attribute1
    ,       l_CON_rec.attribute10
    ,       l_CON_rec.attribute11
    ,       l_CON_rec.attribute12
    ,       l_CON_rec.attribute13
    ,       l_CON_rec.attribute14
    ,       l_CON_rec.attribute15
    ,       l_CON_rec.attribute2
    ,       l_CON_rec.attribute3
    ,       l_CON_rec.attribute4
    ,       l_CON_rec.attribute5
    ,       l_CON_rec.attribute6
    ,       l_CON_rec.attribute7
    ,       l_CON_rec.attribute8
    ,       l_CON_rec.attribute9
    ,       l_CON_rec.context
    ,       l_CON_rec.created_by
    ,       l_CON_rec.creation_date
    ,       l_CON_rec.enabled_flag
    ,       l_CON_rec.last_updated_by
    ,       l_CON_rec.last_update_date
    ,       l_CON_rec.last_update_login
    ,       l_CON_rec.prc_context_code
    ,       l_CON_rec.prc_context_id
    ,       l_CON_rec.prc_context_type
    ,       l_CON_rec.program_application_id
    ,       l_CON_rec.program_id
    ,       l_CON_rec.program_update_date
    ,       l_CON_rec.seeded_description
    ,       l_CON_rec.seeded_flag
    ,       l_CON_rec.seeded_prc_context_name
    ,       l_CON_rec.user_description
    ,       l_CON_rec.user_prc_context_name
    FROM    QP_PRC_CONTEXTS_V
    WHERE   PRC_CONTEXT_ID = p_CON_rec.prc_context_id
        FOR UPDATE NOWAIT;
Line: 1314

    AND QP_GLOBALS.Equal(p_CON_rec.last_updated_by,
                         l_CON_rec.last_updated_by)
    AND QP_GLOBALS.Equal(p_CON_rec.last_update_date,
                         l_CON_rec.last_update_date)
    AND QP_GLOBALS.Equal(p_CON_rec.last_update_login,
                         l_CON_rec.last_update_login)
    AND QP_GLOBALS.Equal(p_CON_rec.prc_context_code,
                         l_CON_rec.prc_context_code)
    AND QP_GLOBALS.Equal(p_CON_rec.prc_context_id,
                         l_CON_rec.prc_context_id)
    AND QP_GLOBALS.Equal(p_CON_rec.prc_context_type,
                         l_CON_rec.prc_context_type)
    AND QP_GLOBALS.Equal(p_CON_rec.program_application_id,
                         l_CON_rec.program_application_id)
    AND QP_GLOBALS.Equal(p_CON_rec.program_id,
                         l_CON_rec.program_id)
    AND QP_GLOBALS.Equal(p_CON_rec.program_update_date,
                         l_CON_rec.program_update_date)
    AND QP_GLOBALS.Equal(p_CON_rec.seeded_description,
                         l_CON_rec.seeded_description)
    AND QP_GLOBALS.Equal(p_CON_rec.seeded_flag,
                         l_CON_rec.seeded_flag)
    AND QP_GLOBALS.Equal(p_CON_rec.seeded_prc_context_name,
                         l_CON_rec.seeded_prc_context_name)
    AND QP_GLOBALS.Equal(p_CON_rec.user_description,
                         l_CON_rec.user_description)
    AND QP_GLOBALS.Equal(p_CON_rec.user_prc_context_name,
                         l_CON_rec.user_prc_context_name)
    THEN

        --  Row has not changed. Set out parameter.

        x_CON_rec                      := l_CON_rec;
Line: 1380

            FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');