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.ENG_FORM_ECO_PVT SQL Statements

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

Line: 54


        SELECT routing_sequence_id
             , lot_number
             , from_wip_entity_id
             , to_wip_entity_id
             , from_cum_qty
             , NVL(eco_for_production,2)
             , NVL(cfm_routing_flag,2)
         INTO  l_routing_sequence_id
             , l_lot_number
             , l_from_wip_entity_id
             , l_to_wip_entity_id
             , l_from_cum_qty
             , l_eco_for_production
             , l_cfm_routing_flag
         FROM eng_revised_items
         WHERE revised_item_sequence_id = p_revised_item_sequence_id ;

Line: 206


                IF l_rev_sub_resource_rec.transaction_type = 'DELETE'
                THEN
                        NULL;

Line: 209


                        /*Eng_Validate_Revised_Item.Check_Entity_Delete
                        (  p_rev_sub_resource_rec    => l_rev_sub_resource_rec
                        ,  p_rev_operation_unexp_rec => l_rev_operation_unexp_rec
                        ,  x_Mesg_Token_Tbl          => l_Mesg_Token_Tbl
                        ,  x_return_status           => l_Return_Status
                        );*/

Line: 265


                bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 266


                bom_rtg_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 267


                bom_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 268


                bom_rtg_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 515


                IF l_rev_op_resource_rec.transaction_type = 'DELETE'
                THEN
                        NULL;

Line: 518


                        /*Eng_Validate_Revised_Item.Check_Entity_Delete
                        (  p_rev_op_resource_rec     => l_rev_op_resource_rec
                        ,  p_rev_operation_unexp_rec => l_rev_operation_unexp_rec
                        ,  x_Mesg_Token_Tbl          => l_Mesg_Token_Tbl
                        ,  x_return_status           => l_Return_Status
                        );*/

Line: 573


                bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 574


                bom_rtg_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 575


                bom_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 576


                bom_rtg_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 895


           (l_rev_operation_rec.transaction_type='UPDATE'
            OR
           (l_rev_operation_rec.transaction_type = 'CREATE'
            AND l_rev_operation_rec.acd_type = 2)
            )
        THEN
                IF l_rev_operation_rec.transaction_type='UPDATE'
                THEN

                     -- Bug #1614911
                     -- Form does not have new operatin seq num.
                     -- and Form always passes the new operation seq num value
                     -- to operation_sequence_number and new_operation_sequence_number
                     -- in l_rev_operation_rec.
                     --
                     -- Hence theis logic get the original op seq num and
                     -- effective date using operation_sequence_id
                     -- Bug no:2770096 ,selecting routing_sequence_id also
                     BEGIN

                         SELECT operation_seq_num ,
                                effectivity_date ,
				routing_sequence_id
                         INTO   l_query_op_seq_num ,
                                l_query_effective_date,
				l_routing_sequence_id
                         FROM   BOM_OPERATION_SEQUENCES
                         WHERE  operation_sequence_id
                                  =  l_rev_op_unexp_rec.operation_sequence_id  ;

Line: 1089


                IF l_rev_operation_rec.transaction_type = 'DELETE'
                THEN
                        NULL;

Line: 1092


                        /*Eng_Validate_Revised_Item.Check_Entity_Delete
                        (  p_rev_operation_rec    => l_rev_operation_rec
                        ,  p_rev_item_unexp_rec   => l_rev_item_unexp_rec
                        ,  x_Mesg_Token_Tbl       => l_Mesg_Token_Tbl
                        ,  x_return_status        => l_Return_Status
                        );*/

Line: 1199


                bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 1200


                bom_rtg_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 1201


                bom_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 1202


                bom_rtg_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 1541


                IF l_sub_component_rec.transaction_type = 'DELETE'
                THEN
                        NULL;

Line: 1544


                        /*Eng_Validate_Revised_Item.Check_Entity_Delete
                        (  p_rev_component_rec     => l_rev_component_rec
                        ,  p_rev_item_unexp_rec   => l_rev_item_unexp_rec
                        ,  x_Mesg_Token_Tbl       => l_Mesg_Token_Tbl
                        ,  x_return_status        => l_Return_Status
                        );*/

Line: 1595


                bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 1596


                bom_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 1841


                bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 1842


                bom_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 2149


           (--l_rev_component_rec.transaction_type='UPDATE'
            --OR -- commented out validation on update as it not required --Bug 3864772
            (l_rev_component_rec.transaction_type = 'CREATE'
             AND l_rev_component_rec.acd_type = 2))
        THEN
                IF l_rev_component_rec.transaction_type='UPDATE'
                THEN
                        l_query_op_seq_num := l_rev_component_rec.new_operation_sequence_number;

Line: 2282


                IF l_rev_component_rec.transaction_type = 'DELETE'
                THEN
                        NULL;

Line: 2285


                        /*Eng_Validate_Revised_Item.Check_Entity_Delete
                        (  p_rev_component_rec     => l_rev_component_rec
                        ,  p_rev_item_unexp_rec   => l_rev_item_unexp_rec
                        ,  x_Mesg_Token_Tbl       => l_Mesg_Token_Tbl
                        ,  x_return_status        => l_Return_Status
                        );*/

Line: 2340


                bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 2341


                bom_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 2657


           l_revised_item_rec.transaction_type='UPDATE'
        THEN
                --dbms_output.put_line('querying row');

Line: 2757


                IF l_revised_item_rec.transaction_type = 'DELETE'
                THEN
                        Eng_Validate_Revised_Item.Check_Entity_Delete
                        (  p_revised_item_rec     => l_revised_item_rec
                        ,  p_rev_item_unexp_rec   => l_rev_item_unexp_rec
                        ,  x_Mesg_Token_Tbl       => l_Mesg_Token_Tbl
                        ,  x_return_status        => l_Return_Status
                        );

Line: 2825


                eng_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 2826


                eng_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 3119


                eng_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 3120


                eng_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 3553


                IF l_eco_rec.transaction_type = 'DELETE'
                THEN
                        ENG_Validate_ECO.Check_Delete
                        ( p_eco_rec             => l_eco_rec
                        , p_Unexp_ECO_rec       => l_ECO_Unexp_Rec
                        , x_return_status       => l_return_status
                        , x_Mesg_Token_Tbl      => l_Mesg_Token_Tbl
                        );

Line: 3635


                eng_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 3636


                eng_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 3938


    bom_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 3939


    bom_rtg_globals.set_user_id(p_user_id => g_control_rec.last_updated_by);

Line: 3940


    bom_globals.set_login_id(p_login_id => g_control_rec.last_update_login);

Line: 3941


    bom_rtg_globals.set_login_id(p_login_id => g_control_rec.last_update_login);