APPS.ENG_SRS_CONTROLLER SQL Statements

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

Line: 265

        IF p_record_status IN ('NEW', 'INSERT')
        THEN
                l_rev_Sub_Resource_tbl(1).transaction_type := 'CREATE';

Line: 270

                l_rev_Sub_Resource_tbl(1).transaction_type := 'UPDATE';

Line: 271

        ELSIF p_record_status = 'DELETE'
        THEN
                l_rev_Sub_Resource_tbl(1).transaction_type := 'DELETE';

Line: 317

PROCEDURE Delete_Row
(   p_SRS_controller_rec        IN  Controller_SRS_Rec_Type
,   p_control_rec               IN  BOM_BO_PUB.Control_Rec_Type
,   x_Mesg_Token_Tbl            OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
,   x_return_status             OUT NOCOPY VARCHAR2
)
IS
l_control_rec           BOM_BO_PUB.Control_Rec_Type := p_control_rec;

Line: 356

        l_rev_Sub_Resource_tbl(1).transaction_type := 'DELETE';

Line: 393

END Delete_Row;

Line: 438

        IF p_record_status IN ('NEW', 'INSERT')
        THEN
                l_rev_Sub_Resource_tbl(1).transaction_type := 'CREATE';

Line: 443

                l_rev_Sub_Resource_tbl(1).transaction_type := 'UPDATE';

Line: 444

        ELSIF p_record_status = 'DELETE'
        THEN
                l_rev_Sub_Resource_tbl(1).transaction_type := 'DELETE';