DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on INV_EBI_REV_COMP_TBL

Line 822: l_comp_item_tbl inv_ebi_rev_comp_tbl;

818: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
819: ) IS
820:
821: l_output_status inv_ebi_output_status;
822: l_comp_item_tbl inv_ebi_rev_comp_tbl;
823: l_revised_item_obj inv_ebi_revised_item_obj;
824: l_comp_exists BOOLEAN;
825: l_comp_count NUMBER := 0;
826: l_config_view_scope VARCHAR2(30) := 'ALL';

Line 841: l_comp_item_tbl := inv_ebi_rev_comp_tbl();

837: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
838: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
839:
840: l_revised_item_obj := p_revised_item_obj;
841: l_comp_item_tbl := inv_ebi_rev_comp_tbl();
842: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info');
843: FOR i IN 1..p_eco_obj_list.COUNT LOOP
844: IF(p_eco_obj_list(i).eco_revised_item_type IS NOT NULL AND p_eco_obj_list(i).eco_revised_item_type.COUNT > 0) THEN
845:

Line 911: l_revised_item_obj.component_item_tbl := inv_ebi_rev_comp_tbl();

907: FOR i IN 1..l_comp_item_tbl.COUNT LOOP
908: IF(l_comp_item_tbl(i).acd_type <> 3) THEN
909:
910: IF(l_revised_item_obj.component_item_tbl IS NULL) THEN
911: l_revised_item_obj.component_item_tbl := inv_ebi_rev_comp_tbl();
912: l_revised_item_obj.component_item_tbl.EXTEND(1);
913: l_is_comp_tbl_new := TRUE;
914: END IF;
915:

Line 1809: l_revised_comp_tbl inv_ebi_rev_comp_tbl;

1805: l_merged_comp c_merged_component%ROWTYPE;
1806: l_copied_comp c_copied_comps%ROWTYPE;
1807: l_revised_item inv_ebi_revised_item_obj;
1808: l_found BOOLEAN;
1809: l_revised_comp_tbl inv_ebi_rev_comp_tbl;
1810: l_revised_comp_count NUMBER := 1;
1811: l_output_status inv_ebi_output_status;
1812: BEGIN
1813: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

Line 1848: l_revised_comp_tbl := inv_ebi_rev_comp_tbl();

1844: organization_id = p_reference_org_id;
1845:
1846: l_revised_item := p_revised_item;
1847: IF p_revised_item.component_item_tbl IS NOT NULL THEN
1848: l_revised_comp_tbl := inv_ebi_rev_comp_tbl();
1849: FOR i IN 1..p_revised_item.component_item_tbl.COUNT LOOP
1850: IF p_revised_item.component_item_tbl(i).transaction_type <> ENG_GLOBALS.g_opr_delete THEN
1851: l_revised_comp_tbl.EXTEND(1);
1852: l_revised_comp_tbl(l_revised_comp_count) := p_revised_item.component_item_tbl(i);

Line 1885: l_revised_item.component_item_tbl := inv_ebi_rev_comp_tbl();

1881: ,p_operation_sequence_number => l_copied_comp.operation_seq_num
1882: ,p_bill_sequence_id => p_from_sequence_id);
1883: FETCH c_merged_component INTO l_Merged_Comp;
1884: IF l_revised_item.component_item_tbl IS NULL THEN
1885: l_revised_item.component_item_tbl := inv_ebi_rev_comp_tbl();
1886: END IF;
1887: l_revised_item.component_item_tbl.EXTEND(1);
1888:
1889: l_revised_item.component_item_tbl(l_revised_item.component_item_tbl.COUNT) := inv_ebi_rev_comp_obj(

Line 2650: ,p_component_tbl IN inv_ebi_rev_comp_tbl

2646: ,p_organization_code IN VARCHAR2
2647: ,p_eco_name IN VARCHAR2
2648: ,p_alternate_bom_code IN VARCHAR2
2649: ,p_revised_item_name IN VARCHAR2
2650: ,p_component_tbl IN inv_ebi_rev_comp_tbl
2651: ,p_structure_header IN inv_ebi_structure_header_obj
2652: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
2653: )IS
2654: l_pkdata ego_col_name_value_pair_array;

Line 4036: p_component_item_tbl IN inv_ebi_rev_comp_tbl,

4032: PROCEDURE process_common_bom_orgs(
4033: p_assembly_item_name IN VARCHAR2,
4034: p_organization_code IN VARCHAR2,
4035: p_alternate_bom_code IN VARCHAR2,
4036: p_component_item_tbl IN inv_ebi_rev_comp_tbl,
4037: x_out OUT NOCOPY inv_ebi_eco_output_obj
4038: ) IS
4039: l_common_orgs inv_ebi_org_tbl;
4040: l_output_status inv_ebi_output_status;

Line 4869: ,p_component_item_tbl IN inv_ebi_rev_comp_tbl

4865: ,p_organization_code IN VARCHAR2
4866: ,p_assembly_item_name IN VARCHAR2
4867: ,p_alternate_bom_code IN VARCHAR2
4868: ,p_structure_header IN inv_ebi_structure_header_obj
4869: ,p_component_item_tbl IN inv_ebi_rev_comp_tbl
4870: ,p_name_val_list IN inv_ebi_name_value_list
4871: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
4872: )
4873: IS

Line 5067: l_revision_component_tbl inv_ebi_rev_comp_tbl;

5063: l_substitute_component_tbl inv_ebi_sub_comp_tbl;
5064: l_substitute_component_obj inv_ebi_sub_comp_obj;
5065: l_reference_designator_tbl inv_ebi_ref_desg_tbl;
5066: l_reference_designator_obj inv_ebi_ref_desg_obj;
5067: l_revision_component_tbl inv_ebi_rev_comp_tbl;
5068: l_revision_component_obj inv_ebi_rev_comp_obj;
5069: l_revised_item_tbl inv_ebi_revised_item_tbl;
5070: l_revised_item_obj inv_ebi_revised_item_obj;
5071: l_structure_header_obj inv_ebi_structure_header_obj;

Line 5641: l_revision_component_tbl := inv_ebi_rev_comp_tbl();

5637: ,NULL
5638: );
5639: CLOSE c_structure_header;
5640: l_comp_index := 1;
5641: l_revision_component_tbl := inv_ebi_rev_comp_tbl();
5642: IF (l_include_comp_items = fnd_api.g_true) THEN
5643: FOR rc IN c_revision_component(l_change_id,ri.revised_item_id)
5644: LOOP
5645: l_ref_index := 1;