APPS.QP_DEFAULT_SOU SQL Statements

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

Line: 20

   select qp_attribute_sourcing_s.nextval
   into l_attribute_sourcing_id
   from dual;

Line: 499

    IF g_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_SOU_rec.last_updated_by := NULL;

Line: 505

    IF g_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_SOU_rec.last_update_date := NULL;

Line: 511

    IF g_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_SOU_rec.last_update_login := NULL;

Line: 529

    IF g_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_SOU_rec.program_update_date := NULL;

Line: 559

    OR  g_SOU_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_SOU_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_SOU_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_SOU_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_SOU_rec.program_id = FND_API.G_MISS_NUM
    OR  g_SOU_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_SOU_rec.request_type_code = FND_API.G_MISS_CHAR
    OR  g_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR
    OR  g_SOU_rec.seeded_sourcing_type = FND_API.G_MISS_CHAR
    OR  g_SOU_rec.seeded_value_string = FND_API.G_MISS_CHAR
    OR  g_SOU_rec.segment_id = FND_API.G_MISS_NUM
    OR  g_SOU_rec.user_sourcing_type = FND_API.G_MISS_CHAR
    OR  g_SOU_rec.user_value_string = FND_API.G_MISS_CHAR
    THEN

        QP_Default_Sou.Attributes
        (   p_SOU_rec                     => g_SOU_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_SOU_rec                     => x_SOU_rec
        );