APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on ENG_GLOBALS

Line 602: IF p_component_item.substitute_component_tbl(i).transaction_type <> ENG_GLOBALS.g_opr_delete THEN

598:
599: IF p_component_item.substitute_component_tbl IS NOT NULL THEN
600: l_substitute_comp_tbl := inv_ebi_sub_comp_tbl();
601: FOR i IN 1..p_component_item.substitute_component_tbl.COUNT LOOP
602: IF p_component_item.substitute_component_tbl(i).transaction_type <> ENG_GLOBALS.g_opr_delete THEN
603: l_substitute_comp_tbl.EXTEND(1);
604: l_substitute_comp_tbl(l_sub_comp_count) := p_component_item.substitute_component_tbl(i);
605: l_sub_comp_count := l_sub_comp_count + 1;
606: END IF;

Line 663: ,ENG_GLOBALS.g_opr_create

659: ,l_merged_subst_comp.from_end_item_unit_number
660: ,l_merged_subst_comp.new_routing_revision
661: ,l_merged_subst_comp.enforce_int_requirements
662: ,l_merged_subst_comp.return_status
663: ,ENG_GLOBALS.g_opr_create
664: ,l_merged_subst_comp.row_identifier
665: ,l_merged_subst_comp.inverse_quantity
666: ,l_Merged_Subst_Comp.program_id
667: ,NULL);

Line 676: IF l_component_item.substitute_component_tbl(i).transaction_type = ENG_GLOBALS.g_opr_update THEN

672:
673:
674: IF l_component_item.substitute_component_tbl IS NOT NULL THEN
675: FOR i IN 1..l_component_item.substitute_component_tbl.COUNT LOOP
676: IF l_component_item.substitute_component_tbl(i).transaction_type = ENG_GLOBALS.g_opr_update THEN
677: OPEN c_merged_substitute_comp(p_new_substitute_comp => l_component_item.substitute_component_tbl(i)
678: ,p_substitute_component_name => l_component_item.substitute_component_tbl(i).substitute_component_name
679: ,p_Component_Sequence_Id => l_Component_Sequence_Id);
680: FETCH c_merged_substitute_comp INTO l_Merged_Subst_Comp;

Line 709: ,ENG_GLOBALS.g_opr_create

705: ,l_merged_subst_comp.from_end_item_unit_number
706: ,l_merged_subst_comp.new_routing_revision
707: ,l_merged_subst_comp.enforce_int_requirements
708: ,l_merged_subst_comp.return_status
709: ,ENG_GLOBALS.g_opr_create
710: ,l_merged_subst_comp.row_identifier
711: ,l_merged_subst_comp.inverse_quantity
712: ,l_merged_subst_comp.program_id
713: ,NULL);

Line 870: IF p_component_item.reference_designator_tbl(i).transaction_type <> ENG_GLOBALS.g_opr_delete THEN

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);
873: l_ref_dsgn_count := l_ref_dsgn_count + 1;
874: END IF;

Line 929: ,ENG_GLOBALS.g_opr_create

925: ,l_merged_ref_designator.new_reference_designator
926: ,l_merged_ref_designator.from_end_item_unit_number
927: ,l_merged_ref_designator.new_routing_revision
928: ,l_merged_ref_designator.return_status
929: ,ENG_GLOBALS.g_opr_create
930: ,l_merged_ref_designator.row_identifier
931: ,NULL);
932: CLOSE c_merged_ref_designators;
933: END IF;

Line 940: IF l_component_item.reference_designator_tbl(i).transaction_type = ENG_GLOBALS.g_opr_update THEN

936:
937: IF l_component_item.reference_designator_tbl IS NOT NULL THEN
938:
939: FOR i IN 1..l_component_item.reference_designator_tbl.COUNT LOOP
940: IF l_component_item.reference_designator_tbl(i).transaction_type = ENG_GLOBALS.g_opr_update THEN
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;

Line 971: ,ENG_GLOBALS.g_opr_create

967: ,l_merged_ref_designator.new_reference_designator
968: ,l_merged_ref_designator.from_end_item_unit_number
969: ,l_merged_ref_designator.new_routing_revision
970: ,l_merged_ref_designator.return_status
971: ,ENG_GLOBALS.g_opr_create
972: ,l_merged_ref_designator.row_identifier
973: ,NULL);
974: CLOSE c_merged_ref_designators;
975: END IF;

Line 1275: IF p_revised_item.component_item_tbl(i).transaction_type <> ENG_GLOBALS.g_opr_delete THEN

1271: l_revised_item := p_revised_item;
1272: IF p_revised_item.component_item_tbl IS NOT NULL THEN
1273: l_revised_comp_tbl := inv_ebi_rev_comp_tbl();
1274: FOR i IN 1..p_revised_item.component_item_tbl.COUNT LOOP
1275: IF p_revised_item.component_item_tbl(i).transaction_type <> ENG_GLOBALS.g_opr_delete THEN
1276: l_revised_comp_tbl.EXTEND(1);
1277: l_revised_comp_tbl(l_revised_comp_count) := p_revised_item.component_item_tbl(i);
1278: l_revised_comp_count := l_revised_comp_count + 1;
1279: END IF;

Line 1375: ,ENG_GLOBALS.g_opr_create

1371: ,l_merged_comp.suggested_vendor_name
1372: ,l_merged_comp.unit_price
1373: ,l_merged_comp.original_system_reference
1374: ,l_merged_comp.return_status
1375: ,ENG_GLOBALS.g_opr_create
1376: ,NULL
1377: ,NULL
1378: ,NULL
1379: ,NULL

Line 1390: IF l_revised_item.component_item_tbl(i).transaction_type = ENG_GLOBALS.g_opr_update THEN

1386: CLOSE c_copied_comps;
1387:
1388: IF l_revised_item.component_item_tbl IS NOT NULL THEN
1389: FOR i IN 1..l_revised_item.component_item_tbl.COUNT LOOP
1390: IF l_revised_item.component_item_tbl(i).transaction_type = ENG_GLOBALS.g_opr_update THEN
1391: OPEN c_merged_component(p_new_comp_item => l_revised_item.component_item_tbl(i)
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);

Line 1458: ,ENG_GLOBALS.g_opr_create

1454: ,l_merged_comp.suggested_vendor_name
1455: ,l_merged_comp.unit_price
1456: ,l_merged_comp.original_system_reference
1457: ,l_merged_comp.return_status
1458: ,ENG_GLOBALS.g_opr_create
1459: ,NULL
1460: ,l_revised_item.component_item_tbl(i).component_revision_uda
1461: ,NULL
1462: ,NULL