DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on INV_EBI_REF_DESG_OBJ

Line 792: p_new_ref_designator IN inv_ebi_ref_desg_obj

788: AND NVL(acd_type,1) = 1; --Only added components are taken
789:
790:
791: CURSOR c_merged_ref_designators (
792: p_new_ref_designator IN inv_ebi_ref_desg_obj
793: ,p_component_sequence_id IN NUMBER
794: ,p_ref_designator_name IN VARCHAR2
795: ) IS
796: SELECT

Line 903: l_component_item.reference_designator_tbl(l_component_item.reference_designator_tbl.COUNT) := inv_ebi_ref_desg_obj(

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(
904: l_component_item.start_effective_date
905: ,l_copied_ref_designator.reference_designator_name
906: ,l_merged_ref_designator.acd_type
907: ,l_merged_ref_designator.ref_designator_comment

Line 945: l_component_item.reference_designator_tbl(i) := inv_ebi_ref_desg_obj(

941: OPEN c_merged_ref_designators(p_new_ref_designator => l_component_item.reference_designator_tbl(i)
942: ,p_ref_designator_name => l_component_item.reference_designator_tbl(i).reference_designator_name
943: ,p_component_sequence_id => l_Component_Sequence_Id);
944: FETCH c_merged_ref_designators INTO l_merged_ref_designator;
945: l_component_item.reference_designator_tbl(i) := inv_ebi_ref_desg_obj(
946: l_merged_ref_designator.start_effective_date
947: ,l_component_item.reference_designator_tbl(i).reference_designator_name
948: ,l_merged_ref_designator.acd_type
949: ,l_merged_ref_designator.ref_designator_comment

Line 4123: l_reference_designator_obj inv_ebi_ref_desg_obj;

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;
4127: l_revised_item_obj inv_ebi_revised_item_obj;

Line 4707: l_reference_designator_obj := inv_ebi_ref_desg_obj(

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();
4707: l_reference_designator_obj := inv_ebi_ref_desg_obj(
4708: NULL
4709: ,rd.reference_designator_name
4710: ,rd.acd_type
4711: ,rd.ref_designator_comment