APPS.BOM_BO_PUB SQL Statements

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

Line: 201

                x_rev_comp_unexp_rec.Delete_Group_Name :=
                                p_bom_component_rec.Delete_Group_Name ; -- Added in 1155

Line: 352

                x_bom_component_rec.Delete_Group_Name :=
                                p_rev_comp_unexp_rec.Delete_Group_Name ; -- Added in 1155

Line: 1538

           select decode(enable_unimplemented_boms,'Y',null, sysdate)
             into l_bom_header_rec.BOM_Implementation_Date
             from bom_structure_types_b stype,
                  bom_alternate_designators alt
            where alt.alternate_designator_code IS NULL
              and stype.structure_type_id = alt.structure_type_id;

Line: 1545

           select decode(enable_unimplemented_boms,'Y',null, sysdate)
             into l_bom_header_rec.BOM_Implementation_Date
             from bom_structure_types_b stype,
                  bom_alternate_designators alt
            where alt.alternate_designator_code = l_bom_header_rec.alternate_bom_code
              and organization_id = l_organization_id
              and stype.structure_type_id = alt.structure_type_id;

Line: 1560

           select decode(enable_unimplemented_boms,'Y',null, sysdate)
             into l_bom_header_rec.BOM_Implementation_Date
             from bom_structure_types_b stype
            where stype.structure_type_name = 'Asset BOM';

Line: 2016

              l_bom_header_rec.Delete_Group_Name      :=
          l_bomheaders_tbl(hdrRec).Delete_Group_Name;

Line: 2020

              l_bom_header_rec.Delete_Group_Name      :=
          l_bomheaders_tbl(hdrRec).Delete_Group_Name;

Line: 2025

        l_bomheaders_tbl.DELETE(hdrRec);

Line: 2121

          l_bomrevisions_tbl.DELETE(revRec);

Line: 2271

          l_bom_component_tbl(i).Delete_Group_Name     :=
          l_bomcomponents_tbl(compRec).Delete_Group_Name;

Line: 2280

          l_bomcomponents_tbl.DELETE(compRec);

Line: 2385

          l_bomsubcomponents_tbl.DELETE(scompRec);

Line: 2490

          l_bomrefdesignators_tbl.DELETE(rdesRec);

Line: 2591

          l_bomcompoperations_tbl.DELETE(copsRec);

Line: 2724

              x_bomheaders_tbl(l_phdrcount).Delete_Group_Name     :=
          l_bom_header_rec.Delete_Group_Name;

Line: 2728

              x_bomheaders_tbl(l_phdrcount).Delete_Group_Name     :=
          l_bom_header_rec.Delete_Group_Name;

Line: 2933

          x_bomcomponents_tbl(i).Delete_Group_Name     :=
          l_bom_component_tbl(compRec).Delete_Group_Name;

Line: 3315

            l_bom_revision_tbl.DELETE;

Line: 3327

            l_bom_component_tbl.DELETE;

Line: 3328

            l_bom_ref_designator_tbl.DELETE;

Line: 3329

            l_bom_sub_component_tbl.DELETE;

Line: 3330

            l_bom_comp_ops_tbl.DELETE;

Line: 3548

      select decode(enable_unimplemented_boms,'Y',null, sysdate)
      into l_bom_header_rec.BOM_Implementation_Date
      from bom_structure_types_b stype,
           bom_alternate_designators alt
     where alt.alternate_designator_code IS NULL
       and stype.structure_type_id = alt.structure_type_id;

Line: 3578

      select decode(enable_unimplemented_boms,'Y',null, sysdate)
        into l_bom_header_rec.BOM_Implementation_Date
        from bom_structure_types_b stype,
             bom_alternate_designators alt
       where
             alt.alternate_designator_code is NULL
         and alt.organization_id = -1
         and stype.structure_type_id = alt.structure_type_id;

Line: 3587

      select decode(enable_unimplemented_boms,'Y',null, sysdate)
        into l_bom_header_rec.BOM_Implementation_Date
        from bom_structure_types_b stype,
             bom_alternate_designators alt,
       org_organization_definitions org
       where alt.alternate_designator_code = p_Alternate_Bom_Code
         and alt.organization_id = org.organization_id
         and org.organization_code = p_Organization_Code
         and stype.structure_type_id = alt.structure_type_id;

Line: 3732

           l_bom_header_rec.Delete_Group_Name := l_input_bomheader_rec.Delete_Group_Name;

Line: 3737

  IF (l_bom_header_rec.Transaction_Type = BOM_Globals.G_OPR_UPDATE) Then
              l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';

Line: 3759

      Error_Handler.Write_Debug('Cannot have transaction type of UPDATE for product family Bills');

Line: 3851

                      l_bom_component_tbl(compRec).Delete_Group_Name     :=
                                        l_input_bomcomponents_tbl(compRec).Delete_Group_Name;