APPS.QP_QP_FORM_MODIFIER_LIST SQL Statements

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

Line: 566

        l_MODIFIER_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 1053

,   x_last_update_date              OUT NOCOPY /* file.sql.39 change */ DATE
,   x_last_updated_by               OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_last_update_login             OUT NOCOPY /* file.sql.39 change */ NUMBER
)
IS
l_MODIFIER_LIST_rec           QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line: 1102

        l_MODIFIER_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 1136

    x_last_update_date             := l_x_MODIFIER_LIST_rec.last_update_date;

Line: 1137

    x_last_updated_by              := l_x_MODIFIER_LIST_rec.last_updated_by;

Line: 1138

    x_last_update_login            := l_x_MODIFIER_LIST_rec.last_update_login;

Line: 1210

PROCEDURE Delete_Row
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_list_header_id                IN  NUMBER
)
IS
l_MODIFIER_LIST_rec           QP_Modifiers_PUB.Modifier_List_Rec_Type;

Line: 1229

    oe_debug_pub.add('BEGIN delete_row in QPXFMLHB');

Line: 1254

    l_MODIFIER_LIST_rec.operation := QP_GLOBALS.G_OPR_DELETE;

Line: 1327

            ,   'Delete_Row'
            );

Line: 1338

    oe_debug_pub.add('END delete_row in QPXFMLHB');

Line: 1339

END Delete_Row;

Line: 1631

	l_MODIFIER_LIST_rec.operation      		:= QP_GLOBALS.G_OPR_UPDATE;

Line: 1636

	l_MODIFIERS_rec.operation      		:= QP_GLOBALS.G_OPR_UPDATE;

Line: 1677

	select (nvl(max(qualifier_grouping_no),1)+1) into l_qualifier_grouping_no
			from qp_qualifiers where
			list_header_id = p_list_header_id and
			list_line_id = p_list_line_id;

Line: 1859

,   p_last_updated_by               IN  NUMBER
,   p_last_update_date              IN  DATE
,   p_last_update_login             IN  NUMBER
,   p_list_header_id                IN  NUMBER
,   p_list_type_code                IN  VARCHAR2
,   p_program_application_id        IN  NUMBER
,   p_program_id                    IN  NUMBER
,   p_program_update_date           IN  DATE
,   p_prorate_flag                  IN  VARCHAR2
,   p_request_id                    IN  NUMBER
,   p_rounding_factor               IN  NUMBER
,   p_ship_method_code              IN  VARCHAR2
,   p_start_date_active             IN  DATE
,   p_terms_id                      IN  NUMBER
,   p_source_system_code            IN VARCHAR2
,   p_pte_code                      IN VARCHAR2
,   p_active_flag                   IN VARCHAR2
,   p_parent_list_header_id         IN NUMBER
,   p_start_date_active_first       IN  DATE
,   p_end_date_active_first         IN  DATE
,   p_active_date_first_type        IN VARCHAR2
,   p_start_date_active_second      IN  DATE
,   p_global_flag                   IN  VARCHAR2
,   p_end_date_active_second        IN  DATE
,   p_active_date_second_type       IN VARCHAR2
,   p_ask_for_flag                  IN VARCHAR2
,   p_list_source_code              IN VARCHAR2 := NULL
,   p_orig_system_header_ref        IN VARCHAR2 := NULL
,   p_shareable_flag                IN VARCHAR2 := NULL
--added for MOAC
,   p_org_id                        IN NUMBER
)
IS
l_return_status               VARCHAR2(1);

Line: 1931

    l_MODIFIER_LIST_rec.last_updated_by := p_last_updated_by;

Line: 1932

    l_MODIFIER_LIST_rec.last_update_date := p_last_update_date;

Line: 1933

    l_MODIFIER_LIST_rec.last_update_login := p_last_update_login;

Line: 1938

    l_MODIFIER_LIST_rec.program_update_date := p_program_update_date;

Line: 2116

       QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
					p_entity_code  => QP_GLOBALS.G_ENTITY_MODIFIER_LIST
					,p_entity_id    => p_list_header_id
				     ,x_return_status => l_return_status);

Line: 2150

Procedure Delete_All_Requests
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)
IS
l_return_status                     Varchar2(30);

Line: 2169

            ,   'Delete_All_Requests'
            );

Line: 2179

END Delete_All_Requests;