DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on INV_EBI_REV_COMP_OBJ

Line 482: p_component_item IN inv_ebi_rev_comp_obj

478: -- Type : Private
479: -- Function : Prepare substitute components for Replicate bom
480: ************************************************************************************/
481: PROCEDURE prepare_substitute_components(
482: p_component_item IN inv_ebi_rev_comp_obj
483: ,p_from_sequence_id IN NUMBER
484: ,p_reference_org_id IN NUMBER
485: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
486: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

Line 485: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj

481: PROCEDURE prepare_substitute_components(
482: p_component_item IN inv_ebi_rev_comp_obj
483: ,p_from_sequence_id IN NUMBER
484: ,p_reference_org_id IN NUMBER
485: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
486: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
487: ) IS
488:
489: CURSOR c_comp_sequence_id

Line 583: l_component_item inv_ebi_rev_comp_obj;

579: sc.component_sequence_id = p_component_sequence_id;
580:
581: l_component_sequence_id NUMBER;
582: i NUMBER := 0;
583: l_component_item inv_ebi_rev_comp_obj;
584: l_Found BOOLEAN;
585: l_merged_subst_comp c_Merged_Substitute_Comp%ROWTYPE;
586: l_substitute_comp_tbl inv_ebi_sub_comp_tbl;
587: l_sub_comp_count NUMBER := 1;

Line 760: p_component_item IN inv_ebi_rev_comp_obj

756: -- Type : Private
757: -- Function : Prepare reference_designators for Replicate bom
758: ************************************************************************************/
759: PROCEDURE prepare_reference_designators(
760: p_component_item IN inv_ebi_rev_comp_obj
761: ,p_from_sequence_id IN NUMBER
762: ,p_reference_org_id IN NUMBER
763: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
764: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

Line 763: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj

759: PROCEDURE prepare_reference_designators(
760: p_component_item IN inv_ebi_rev_comp_obj
761: ,p_from_sequence_id IN NUMBER
762: ,p_reference_org_id IN NUMBER
763: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
764: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
765: ) IS
766:
767: CURSOR c_comp_sequence_id

Line 851: l_component_item inv_ebi_rev_comp_obj;

847: i NUMBER := 0;
848: l_merged_ref_designator c_merged_ref_designators%ROWTYPE;
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;

Line 1110: p_new_comp_item IN inv_ebi_rev_comp_obj

1106: (UPPER(p_implementation_scope) = G_IMPLEMENT_SCOPE_IMPLEMENT AND implementation_date IS NOT NULL) OR
1107: (UPPER(p_implementation_scope) = G_IMPLEMENT_SCOPE_UNIMPLEMENT AND implementation_date IS NULL));
1108:
1109: CURSOR c_merged_component (
1110: p_new_comp_item IN inv_ebi_rev_comp_obj
1111: ,p_component_item_name IN VARCHAR2
1112: ,p_operation_sequence_number IN NUMBER
1113: ,p_bill_sequence_id IN NUMBER
1114: ) IS

Line 1313: l_revised_item.component_item_tbl(l_revised_item.component_item_tbl.COUNT) := inv_ebi_rev_comp_obj(

1309: l_revised_item.component_item_tbl := inv_ebi_rev_comp_tbl();
1310: END IF;
1311: l_revised_item.component_item_tbl.EXTEND(1);
1312:
1313: l_revised_item.component_item_tbl(l_revised_item.component_item_tbl.COUNT) := inv_ebi_rev_comp_obj(
1314: p_revised_item.start_effective_date
1315: ,p_revised_item.start_effective_date
1316: ,l_merged_comp.disable_date
1317: ,l_copied_comp.operation_seq_num

Line 1396: l_revised_item.component_item_tbl(i) := inv_ebi_rev_comp_obj(

1392: ,p_component_item_name => l_revised_item.component_item_tbl(i).component_item_name
1393: ,p_operation_sequence_number => l_revised_item.component_item_tbl(i).operation_sequence_number
1394: ,p_bill_sequence_id => p_from_sequence_id);
1395: FETCH c_merged_component INTO l_Merged_Comp;
1396: l_revised_item.component_item_tbl(i) := inv_ebi_rev_comp_obj(
1397: l_merged_comp.start_effective_date
1398: ,l_merged_comp.new_effectivity_date
1399: ,l_merged_comp.disable_date
1400: ,l_revised_item.component_item_tbl(i).operation_sequence_number

Line 1675: l_component_item inv_ebi_rev_comp_obj;

1671: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1672: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1673: l_context_org_code mtl_parameters.organization_code%TYPE;
1674: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
1675: l_component_item inv_ebi_rev_comp_obj;
1676: l_component_item1 inv_ebi_rev_comp_obj;
1677: l_eco_obj inv_ebi_eco_obj;
1678: l_from_item_id NUMBER;
1679: l_to_item_id NUMBER;

Line 1676: l_component_item1 inv_ebi_rev_comp_obj;

1672: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1673: l_context_org_code mtl_parameters.organization_code%TYPE;
1674: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
1675: l_component_item inv_ebi_rev_comp_obj;
1676: l_component_item1 inv_ebi_rev_comp_obj;
1677: l_eco_obj inv_ebi_eco_obj;
1678: l_from_item_id NUMBER;
1679: l_to_item_id NUMBER;
1680: l_from_sequence_id NUMBER;

Line 4125: l_revision_component_obj inv_ebi_rev_comp_obj;

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;
4128: l_structure_header_obj inv_ebi_structure_header_obj;
4129: l_current_index NUMBER;

Line 4785: l_revision_component_obj := inv_ebi_rev_comp_obj(

4781: END LOOP;
4782: END IF; -- IF (l_include_sub_comp = fnd_api.g_true) THEN
4783:
4784: l_revision_component_tbl.extend();
4785: l_revision_component_obj := inv_ebi_rev_comp_obj(
4786: NULL
4787: ,NULL
4788: ,rc.disable_date
4789: ,rc.operation_seq_num