APPS.ENGPKIMP dependencies on BOM_REFERENCE_DESIGNATORS

Line 1919: from bom_reference_designators r

1915: o.program_update_date;
1916: old_comp_rec old_component%rowtype;
1917: Cursor count_ref_designators(comp_id number) is
1918: Select count(*)
1919: from bom_reference_designators r
1920: where r.component_sequence_id = comp_id
1921: and nvl(r.acd_type, acd_add) = acd_add;
1922: ref_designator_count number;
1923: X_GetInstallStatus boolean;

Line 6873: Insert into bom_reference_designators (

6869: from bom_substitute_components
6870: where component_sequence_id =
6871: component.component_sequence_id);
6872: -- Copy reference designators
6873: Insert into bom_reference_designators (
6874: component_reference_designator,
6875: last_update_date,
6876: last_updated_by,
6877: creation_date,

Line 6935: from bom_reference_designators

6931: attribute12,
6932: attribute13,
6933: attribute14,
6934: attribute15
6935: from bom_reference_designators
6936: where component_sequence_id =
6937: component.old_component_sequence_id
6938: and nvl(acd_type, acd_add) = acd_add -- adds only
6939: and component_reference_designator not in (

Line 6941: from bom_reference_designators

6937: component.old_component_sequence_id
6938: and nvl(acd_type, acd_add) = acd_add -- adds only
6939: and component_reference_designator not in (
6940: select component_reference_designator
6941: from bom_reference_designators
6942: where component_sequence_id =
6943: component.component_sequence_id);
6944: end if; -- Copy component's children
6945:

Line 8608: -- Delete the related bom_reference_designators records

8604:
8605: -- Reverse standard bom is called from ENCACN.opp,
8606: -- If bill sequence id is null, p_bill_sequence_id = -1
8607: IF p_bill_sequence_id <> -1 THEN
8608: -- Delete the related bom_reference_designators records
8609: -- those records are still expected to show on the window after implementation
8610: --
8611: /* DELETE FROM bom_reference_designators
8612: WHERE component_sequence_id IN

Line 8611: /* DELETE FROM bom_reference_designators

8607: IF p_bill_sequence_id <> -1 THEN
8608: -- Delete the related bom_reference_designators records
8609: -- those records are still expected to show on the window after implementation
8610: --
8611: /* DELETE FROM bom_reference_designators
8612: WHERE component_sequence_id IN
8613: ( SELECT component_sequence_id
8614: FROM bom_inventory_components
8615: WHERE