APPS.QP_DEFAULT_SEG SQL Statements

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

Line: 109

    select qp_segments_s.nextval
    into l_segment_id
    from dual;

Line: 750

    IF g_SEG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_SEG_rec.last_updated_by := NULL;

Line: 756

    IF g_SEG_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_SEG_rec.last_update_date := NULL;

Line: 762

    IF g_SEG_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_SEG_rec.last_update_login := NULL;

Line: 780

    IF g_SEG_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_SEG_rec.program_update_date := NULL;

Line: 807

    OR  g_SEG_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_SEG_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_SEG_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_SEG_rec.prc_context_id = FND_API.G_MISS_NUM
    OR  g_SEG_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_SEG_rec.program_id = FND_API.G_MISS_NUM
    OR  g_SEG_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR
    OR  g_SEG_rec.seeded_format_type = FND_API.G_MISS_CHAR
    OR  g_SEG_rec.seeded_precedence = FND_API.G_MISS_NUM
    OR  g_SEG_rec.seeded_segment_name = FND_API.G_MISS_CHAR
    OR  g_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM
    OR  g_SEG_rec.segment_code = FND_API.G_MISS_CHAR
    OR  g_SEG_rec.segment_id = FND_API.G_MISS_NUM
    -- Added Application_Id by Abhijit
    OR  g_SEG_rec.application_id = FND_API.G_MISS_NUM
    OR  g_SEG_rec.segment_mapping_column = FND_API.G_MISS_CHAR
    OR  g_SEG_rec.user_format_type = FND_API.G_MISS_CHAR
    OR  g_SEG_rec.user_precedence = FND_API.G_MISS_NUM
    OR  g_SEG_rec.user_segment_name = FND_API.G_MISS_CHAR
    OR  g_SEG_rec.required_flag = FND_API.G_MISS_CHAR
    OR  g_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM
     -- Added for TCA
    OR  g_SEG_rec.party_hierarchy_enabled_flag = FND_API.G_MISS_CHAR
    THEN

        QP_Default_Seg.Attributes
        (   p_SEG_rec                     => g_SEG_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_SEG_rec                     => x_SEG_rec
        );