APPS.QP_DEFAULT_FNA SQL Statements

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

Line: 37

    select QP_PTE_SS_FNAREA_ID_S.nextval
    into l_pte_ss_fn
    from dual;

Line: 312

    IF g_FNA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_FNA_rec.last_updated_by := NULL;

Line: 318

    IF g_FNA_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_FNA_rec.last_update_date := NULL;

Line: 324

    IF g_FNA_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_FNA_rec.last_update_login := NULL;

Line: 342

    IF g_FNA_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_FNA_rec.program_update_date := NULL;

Line: 376

    OR  g_FNA_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_FNA_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_FNA_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_FNA_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_FNA_rec.program_id = FND_API.G_MISS_NUM
    OR  g_FNA_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM
    OR  g_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM
    OR  g_FNA_rec.request_id = FND_API.G_MISS_NUM
    OR  g_FNA_rec.seeded_flag = FND_API.G_MISS_CHAR
    THEN

        QP_Default_Fna.Attributes
        (   p_FNA_rec                     => g_FNA_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_FNA_rec                     => x_FNA_rec
        );