APPS.QP_DEFAULT_QUALIFIERS SQL Statements

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

Line: 168

   SELECT QP_QUALIFIERS_S.NEXTVAL
   INTO   l_qualifier_id
   FROM  DUAL;

Line: 833

    IF g_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_QUALIFIERS_rec.last_updated_by := NULL;

Line: 839

    IF g_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_QUALIFIERS_rec.last_update_date := NULL;

Line: 845

    IF g_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_QUALIFIERS_rec.last_update_login := NULL;

Line: 863

    IF g_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_QUALIFIERS_rec.program_update_date := NULL;

Line: 899

    OR  g_QUALIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_QUALIFIERS_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.list_line_id = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.program_id = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_QUALIFIERS_rec.qualifier_attribute = FND_API.G_MISS_CHAR
    OR  g_QUALIFIERS_rec.qualifier_attr_value = FND_API.G_MISS_CHAR
    OR  g_QUALIFIERS_rec.qualifier_attr_value_to = FND_API.G_MISS_CHAR
    OR  g_QUALIFIERS_rec.qualifier_context = FND_API.G_MISS_CHAR
    OR  g_QUALIFIERS_rec.qualifier_datatype = FND_API.G_MISS_CHAR
    --OR  g_QUALIFIERS_rec.qualifier_date_format = FND_API.G_MISS_CHAR
    OR  g_QUALIFIERS_rec.qualifier_grouping_no = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM
    --OR  g_QUALIFIERS_rec.qualifier_number_format = FND_API.G_MISS_CHAR
    OR  g_QUALIFIERS_rec.qualifier_precedence = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.qualifier_rule_id = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.request_id = FND_API.G_MISS_NUM
    OR  g_QUALIFIERS_rec.start_date_active = FND_API.G_MISS_DATE
    -- Added for TCA
    OR  g_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR
    THEN

        QP_Default_Qualifiers.Attributes
        (   p_QUALIFIERS_rec              => g_QUALIFIERS_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_QUALIFIERS_rec              => x_QUALIFIERS_rec
        );