eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_DEFAULT_MODIFIER_LIST SQL Statements

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

Line: 54


   SELECT CURRENCY_CODE
   INTO l_currency_code
   FROM GL_SETS_OF_BOOKS
   WHERE SET_OF_BOOKS_ID = l_set_of_books_id;

Line: 127


    select QP_LIST_HEADERS_B_S.nextval
    into   l_list_header_id
    from   dual;

Line: 1290


    IF g_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_MODIFIER_LIST_rec.last_updated_by := NULL;

Line: 1296


    IF g_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_MODIFIER_LIST_rec.last_update_date := NULL;

Line: 1302


    IF g_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_MODIFIER_LIST_rec.last_update_login := NULL;

Line: 1320


    IF g_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_MODIFIER_LIST_rec.program_update_date := NULL;

Line: 1359


    OR  g_MODIFIER_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_MODIFIER_LIST_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_MODIFIER_LIST_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_MODIFIER_LIST_rec.list_header_id = FND_API.G_MISS_NUM
    OR  g_MODIFIER_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_MODIFIER_LIST_rec.program_id = FND_API.G_MISS_NUM
    OR  g_MODIFIER_LIST_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_MODIFIER_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.request_id = FND_API.G_MISS_NUM
    OR  g_MODIFIER_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
    OR  g_MODIFIER_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.start_date_active = FND_API.G_MISS_DATE
    OR  g_MODIFIER_LIST_rec.terms_id = FND_API.G_MISS_NUM
    OR  g_MODIFIER_LIST_rec.parent_list_header_id = FND_API.G_MISS_NUM
    OR  g_MODIFIER_LIST_rec.source_system_code = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.pte_code = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.active_flag = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.start_date_active_first = FND_API.G_MISS_DATE
    OR  g_MODIFIER_LIST_rec.end_date_active_first = FND_API.G_MISS_DATE
    OR  g_MODIFIER_LIST_rec.active_date_first_type = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.start_date_active_second = FND_API.G_MISS_DATE
    OR  g_MODIFIER_LIST_rec.global_flag = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.end_date_active_second = FND_API.G_MISS_DATE
    OR  g_MODIFIER_LIST_rec.active_date_second_type = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.ask_for_flag = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.name = FND_API.G_MISS_CHAR
    OR  g_MODIFIER_LIST_rec.description = FND_API.G_MISS_CHAR
    THEN

        QP_Default_Modifier_List.Attributes
        (   p_MODIFIER_LIST_rec           => g_MODIFIER_LIST_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_MODIFIER_LIST_rec           => x_MODIFIER_LIST_rec
        );