APPS.ENG_RIT_CONTROLLER SQL Statements

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

Line: 23

        x_RIT_tbl(1).updated_revised_item_revision := p_controller_RIT_rec.updated_revised_item_revision;

Line: 36

        x_RIT_tbl(1).update_wip                    := p_controller_RIT_rec.update_wip;

Line: 67

        x_RIT_tbl(1).Updated_Routing_Revision      := p_controller_RIT_rec.Updated_Routing_Revision;

Line: 108

        x_controller_RIT_rec.new_revised_item_revision     := NVL(p_RIT_tbl(1).updated_revised_item_revision,
                                                                  p_RIT_tbl(1).new_revised_item_revision);

Line: 111

        x_controller_RIT_rec.updated_revised_item_revision := p_RIT_tbl(1).updated_revised_item_revision ;

Line: 127

        x_controller_RIT_rec.update_wip                    := p_RIT_tbl(1).update_wip;

Line: 156

        x_controller_RIT_rec.New_Routing_Revision          := NVL(p_RIT_tbl(1).updated_routing_revision,
                                                                  p_RIT_tbl(1).new_routing_revision);

Line: 158

        x_controller_RIT_rec.updated_routing_revision      := p_RIT_tbl(1).updated_routing_revision ;

Line: 321

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

Line: 326

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

Line: 327

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

Line: 372

PROCEDURE Delete_Row
(   p_RIT_controller_rec        IN  ENG_RIT_Controller.Controller_Rit_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: 413

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

Line: 450

END Delete_Row;

Line: 513

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

Line: 518

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

Line: 519

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