APPS.ENGPKIMP dependencies on BOM_REFERENCE_DESIGNATORS

Line 2015: from bom_reference_designators r

2011: o.program_update_date;
2012: old_comp_rec old_component%rowtype;
2013: Cursor count_ref_designators(comp_id number) is
2014: Select count(*)
2015: from bom_reference_designators r
2016: where r.component_sequence_id = comp_id
2017: and nvl(r.acd_type, acd_add) = acd_add;
2018: ref_designator_count number;
2019: X_GetInstallStatus boolean;

Line 7191: Insert into bom_reference_designators (

7187: from bom_substitute_components
7188: where component_sequence_id =
7189: component.component_sequence_id);
7190: -- Copy reference designators
7191: Insert into bom_reference_designators (
7192: component_reference_designator,
7193: last_update_date,
7194: last_updated_by,
7195: creation_date,

Line 7253: from bom_reference_designators

7249: attribute12,
7250: attribute13,
7251: attribute14,
7252: attribute15
7253: from bom_reference_designators
7254: where component_sequence_id =
7255: component.old_component_sequence_id
7256: and nvl(acd_type, acd_add) = acd_add -- adds only
7257: and component_reference_designator not in (

Line 7259: from bom_reference_designators

7255: component.old_component_sequence_id
7256: and nvl(acd_type, acd_add) = acd_add -- adds only
7257: and component_reference_designator not in (
7258: select component_reference_designator
7259: from bom_reference_designators
7260: where component_sequence_id =
7261: component.component_sequence_id);
7262: end if; -- Copy component's children
7263:

Line 8953: -- Delete the related bom_reference_designators records

8949:
8950: -- Reverse standard bom is called from ENCACN.opp,
8951: -- If bill sequence id is null, p_bill_sequence_id = -1
8952: IF p_bill_sequence_id <> -1 THEN
8953: -- Delete the related bom_reference_designators records
8954: -- those records are still expected to show on the window after implementation
8955: --
8956: /* DELETE FROM bom_reference_designators
8957: WHERE component_sequence_id IN

Line 8956: /* DELETE FROM bom_reference_designators

8952: IF p_bill_sequence_id <> -1 THEN
8953: -- Delete the related bom_reference_designators records
8954: -- those records are still expected to show on the window after implementation
8955: --
8956: /* DELETE FROM bom_reference_designators
8957: WHERE component_sequence_id IN
8958: ( SELECT component_sequence_id
8959: FROM bom_inventory_components
8960: WHERE