849: l_copied_ref_designator c_copied_ref_designators%ROWTYPE;
850: l_component_sequence_id NUMBER;
851: l_component_item inv_ebi_rev_comp_obj;
852: l_Found BOOLEAN;
853: l_ref_designator_tbl inv_ebi_ref_desg_tbl;
854: l_ref_dsgn_count NUMBER := 1;
855: l_output_status inv_ebi_output_status;
856:
857: BEGIN
864:
865: l_component_item := p_component_item;
866:
867: IF p_component_item.reference_designator_tbl IS NOT NULL THEN
868: l_ref_designator_tbl := inv_ebi_ref_desg_tbl();
869: FOR i IN 1..p_component_item.reference_designator_tbl.COUNT LOOP
870: IF p_component_item.reference_designator_tbl(i).transaction_type <> ENG_GLOBALS.g_opr_delete THEN
871: l_ref_designator_tbl.EXTEND(1);
872: l_ref_designator_tbl(l_ref_dsgn_count) := p_component_item.reference_designator_tbl(i);
895: ,p_component_sequence_id => l_component_sequence_id
896: );
897: FETCH c_merged_ref_designators INTO l_merged_ref_designator;
898: IF l_component_item.reference_designator_tbl IS NULL THEN
899: l_component_item.reference_designator_tbl := inv_ebi_ref_desg_tbl();
900: END IF;
901: l_component_item.reference_designator_tbl.EXTEND(1);
902:
903: l_component_item.reference_designator_tbl(l_component_item.reference_designator_tbl.COUNT) := inv_ebi_ref_desg_obj(
4118: l_eco_revision_tbl inv_ebi_eco_revision_tbl;
4119: l_eco_revision_obj inv_ebi_eco_revision_obj;
4120: l_substitute_component_tbl inv_ebi_sub_comp_tbl;
4121: l_substitute_component_obj inv_ebi_sub_comp_obj;
4122: l_reference_designator_tbl inv_ebi_ref_desg_tbl;
4123: l_reference_designator_obj inv_ebi_ref_desg_obj;
4124: l_revision_component_tbl inv_ebi_rev_comp_tbl;
4125: l_revision_component_obj inv_ebi_rev_comp_obj;
4126: l_revised_item_tbl inv_ebi_revised_item_tbl;
4698: IF (l_include_comp_items = fnd_api.g_true) THEN
4699: FOR rc IN c_revision_component(l_change_id,ri.revised_item_id)
4700: LOOP
4701: l_ref_index := 1;
4702: l_reference_designator_tbl := inv_ebi_ref_desg_tbl();
4703: IF (l_include_ref_designators = fnd_api.g_true) THEN
4704: FOR rd IN c_reference_designator(l_change_id,ri.revised_item_id,rc.component_item_id)
4705: LOOP
4706: l_reference_designator_tbl.extend();