[Home] [Help]
1172:
1173: IF p_component_item.substitute_component_tbl IS NOT NULL THEN
1174: l_substitute_comp_tbl := inv_ebi_sub_comp_tbl();
1175: FOR i IN 1..p_component_item.substitute_component_tbl.COUNT LOOP
1176: IF p_component_item.substitute_component_tbl(i).transaction_type <> ENG_GLOBALS.g_opr_delete THEN
1177: l_substitute_comp_tbl.EXTEND(1);
1178: l_substitute_comp_tbl(l_sub_comp_count) := p_component_item.substitute_component_tbl(i);
1179: l_sub_comp_count := l_sub_comp_count + 1;
1180: END IF;
1234: ,l_merged_subst_comp.from_end_item_unit_number
1235: ,l_merged_subst_comp.new_routing_revision
1236: ,l_merged_subst_comp.enforce_int_requirements
1237: ,l_merged_subst_comp.return_status
1238: ,ENG_GLOBALS.g_opr_create
1239: ,l_merged_subst_comp.row_identifier
1240: ,l_merged_subst_comp.inverse_quantity
1241: ,l_Merged_Subst_Comp.program_id
1242: ,NULL);
1247:
1248:
1249: IF l_component_item.substitute_component_tbl IS NOT NULL THEN
1250: FOR i IN 1..l_component_item.substitute_component_tbl.COUNT LOOP
1251: IF l_component_item.substitute_component_tbl(i).transaction_type = ENG_GLOBALS.g_opr_update THEN
1252: OPEN c_merged_substitute_comp(p_new_substitute_comp => l_component_item.substitute_component_tbl(i)
1253: ,p_substitute_component_name => l_component_item.substitute_component_tbl(i).substitute_component_name
1254: ,p_Component_Sequence_Id => l_Component_Sequence_Id);
1255: FETCH c_merged_substitute_comp INTO l_Merged_Subst_Comp;
1280: ,l_merged_subst_comp.from_end_item_unit_number
1281: ,l_merged_subst_comp.new_routing_revision
1282: ,l_merged_subst_comp.enforce_int_requirements
1283: ,l_merged_subst_comp.return_status
1284: ,ENG_GLOBALS.g_opr_create
1285: ,l_merged_subst_comp.row_identifier
1286: ,l_merged_subst_comp.inverse_quantity
1287: ,l_merged_subst_comp.program_id
1288: ,NULL);
1441:
1442: IF p_component_item.reference_designator_tbl IS NOT NULL THEN
1443: l_ref_designator_tbl := inv_ebi_ref_desg_tbl();
1444: FOR i IN 1..p_component_item.reference_designator_tbl.COUNT LOOP
1445: IF p_component_item.reference_designator_tbl(i).transaction_type <> ENG_GLOBALS.g_opr_delete THEN
1446: l_ref_designator_tbl.EXTEND(1);
1447: l_ref_designator_tbl(l_ref_dsgn_count) := p_component_item.reference_designator_tbl(i);
1448: l_ref_dsgn_count := l_ref_dsgn_count + 1;
1449: END IF;
1500: ,l_merged_ref_designator.new_reference_designator
1501: ,l_merged_ref_designator.from_end_item_unit_number
1502: ,l_merged_ref_designator.new_routing_revision
1503: ,l_merged_ref_designator.return_status
1504: ,ENG_GLOBALS.g_opr_create
1505: ,l_merged_ref_designator.row_identifier
1506: ,NULL);
1507: CLOSE c_merged_ref_designators;
1508: END IF;
1511:
1512: IF l_component_item.reference_designator_tbl IS NOT NULL THEN
1513:
1514: FOR i IN 1..l_component_item.reference_designator_tbl.COUNT LOOP
1515: IF l_component_item.reference_designator_tbl(i).transaction_type = ENG_GLOBALS.g_opr_update THEN
1516: OPEN c_merged_ref_designators(p_new_ref_designator => l_component_item.reference_designator_tbl(i)
1517: ,p_ref_designator_name => l_component_item.reference_designator_tbl(i).reference_designator_name
1518: ,p_component_sequence_id => l_Component_Sequence_Id);
1519: FETCH c_merged_ref_designators INTO l_merged_ref_designator;
1542: ,l_merged_ref_designator.new_reference_designator
1543: ,l_merged_ref_designator.from_end_item_unit_number
1544: ,l_merged_ref_designator.new_routing_revision
1545: ,l_merged_ref_designator.return_status
1546: ,ENG_GLOBALS.g_opr_create
1547: ,l_merged_ref_designator.row_identifier
1548: ,NULL);
1549: CLOSE c_merged_ref_designators;
1550: END IF;
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);
1853: l_revised_comp_count := l_revised_comp_count + 1;
1854: END IF;
1947: ,l_merged_comp.suggested_vendor_name
1948: ,l_merged_comp.unit_price
1949: ,l_merged_comp.original_system_reference
1950: ,l_merged_comp.return_status
1951: ,ENG_GLOBALS.g_opr_create
1952: ,NULL
1953: ,NULL
1954: ,NULL
1955: ,NULL
1962: CLOSE c_copied_comps;
1963:
1964: IF l_revised_item.component_item_tbl IS NOT NULL THEN
1965: FOR i IN 1..l_revised_item.component_item_tbl.COUNT LOOP
1966: IF l_revised_item.component_item_tbl(i).transaction_type = ENG_GLOBALS.g_opr_update THEN
1967: OPEN c_merged_component(p_new_comp_item => l_revised_item.component_item_tbl(i)
1968: ,p_component_item_name => l_revised_item.component_item_tbl(i).component_item_name
1969: ,p_operation_sequence_number => l_revised_item.component_item_tbl(i).operation_sequence_number
1970: ,p_bill_sequence_id => p_from_sequence_id);
2030: ,l_merged_comp.suggested_vendor_name
2031: ,l_merged_comp.unit_price
2032: ,l_merged_comp.original_system_reference
2033: ,l_merged_comp.return_status
2034: ,ENG_GLOBALS.g_opr_create
2035: ,NULL
2036: ,l_revised_item.component_item_tbl(i).component_revision_uda
2037: ,NULL
2038: ,NULL