APPS.QP_DEFAULT_PSG SQL Statements

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

Line: 73

    select qp_pte_segments_s.nextval
    into l_segment_pte_id
    from dual;

Line: 466

    IF g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_PSG_rec.last_updated_by := NULL;

Line: 472

    IF g_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_PSG_rec.last_update_date := NULL;

Line: 478

    IF g_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_PSG_rec.last_update_login := NULL;

Line: 496

    IF g_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_PSG_rec.program_update_date := NULL;

Line: 522

    OR  g_PSG_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_PSG_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_PSG_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR
    OR  g_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR
    OR  g_PSG_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_PSG_rec.program_id = FND_API.G_MISS_NUM
    OR  g_PSG_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_PSG_rec.pte_code = FND_API.G_MISS_CHAR
    OR  g_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR
    OR  g_PSG_rec.segment_id = FND_API.G_MISS_NUM
    OR  g_PSG_rec.segment_level = FND_API.G_MISS_CHAR
    OR  g_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM
    OR  g_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR
    OR  g_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR
    OR  g_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR
    THEN

        QP_Default_Psg.Attributes
        (   p_PSG_rec                     => g_PSG_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_PSG_rec                     => x_PSG_rec
        );