APPS.BOM_DEFAULT_SUB_OP_RES SQL Statements

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

Line: 346

    * Procedure : Populate_Null_Columns used by Rtg BO(Update or Delete)
    * Parameters IN : Sub Operation Resource exposed column record
    *                 Sub Operation Resource unexposed column record
    *                 Old Sub Operation Resource exposed column record
    *                 Old Sub Operation Resource unexposed column record
    * Parameters out: Sub Op Resource exposed column record after
    *                 populating null columns
    *                 Sub Op Resource unexposed column record after
    *                 populating null columns
    * Purpose   : Convert Routing Sub Op Resource to ECO Sub Op Resource and
    *             Call Populate_Null_Columns for ECO BO.
    *             The procedure will populate the NULL columns from the
    *             record that is queried from the database.
    ********************************************************************/
    PROCEDURE Populate_Null_Columns
    (  p_sub_resource_rec          IN  Bom_Rtg_Pub.Sub_Resource_Rec_Type
     , p_sub_res_unexp_rec         IN  Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
     , p_old_sub_resource_rec      IN  Bom_Rtg_Pub.Sub_Resource_Rec_Type
     , p_old_sub_res_unexp_rec     IN  Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
     , x_sub_resource_rec          IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
     , x_sub_res_unexp_rec         IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
    )

    IS
        l_rev_sub_resource_rec      Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

Line: 425

    *            used by ECO BO(Update, Delete or Create with ACD_Type:2 Change)
    * Parameters IN : Revised Sub Op Resource exposed column record
    *                 Revised Sub Op Resource unexposed column record
    *                 Old Revised Sub Op Resource exposed column record
    *                 Old Revised Sub Op Resource unexposed column record
    * Parameters out: Revised Sub Op Resource exposed column record
    *                 after populating null columns
    *                 Revised Sub Op Resource unexposed column record
    *                 after populating null columns
    * Purpose   : Complete record will compare the database record with
    *             the user given record and will complete the user
    *             record with values from the database record, for all
    *             columns that the user has left NULL.
    ********************************************************************/
    PROCEDURE Populate_Null_Columns
    (  p_rev_sub_resource_rec      IN  Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
     , p_rev_sub_res_unexp_rec     IN  Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
     , p_old_rev_sub_resource_rec  IN  Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
     , p_old_rev_sub_res_unexp_rec IN  Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
     , x_rev_sub_resource_rec      IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
     , x_rev_sub_res_unexp_rec     IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
    )
    IS

       l_rev_sub_resource_rec      Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;