DBA Data[Home] [Help]

APPS.QP_DEFAULT_CON SQL Statements

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

Line: 37

    select qp_prc_contexts_s.nextval
    into l_prc_context_id
    from dual;
Line: 436

    IF g_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_CON_rec.last_updated_by := NULL;
Line: 442

    IF g_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_CON_rec.last_update_date := NULL;
Line: 448

    IF g_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_CON_rec.last_update_login := NULL;
Line: 466

    IF g_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_CON_rec.program_update_date := NULL;
Line: 493

    OR  g_CON_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_CON_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_CON_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_CON_rec.prc_context_code = FND_API.G_MISS_CHAR
    OR  g_CON_rec.prc_context_id = FND_API.G_MISS_NUM
    OR  g_CON_rec.prc_context_type = FND_API.G_MISS_CHAR
    OR  g_CON_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_CON_rec.program_id = FND_API.G_MISS_NUM
    OR  g_CON_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_CON_rec.seeded_description = FND_API.G_MISS_CHAR
    OR  g_CON_rec.seeded_flag = FND_API.G_MISS_CHAR
    OR  g_CON_rec.seeded_prc_context_name = FND_API.G_MISS_CHAR
    OR  g_CON_rec.user_description = FND_API.G_MISS_CHAR
    OR  g_CON_rec.user_prc_context_name = FND_API.G_MISS_CHAR
    THEN

        QP_Default_Con.Attributes
        (   p_CON_rec                     => g_CON_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_CON_rec                     => x_CON_rec
        );