DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on INV_EBI_REF_DESG_TBL

Line 609: p_ref_desg_tbl IN inv_ebi_ref_desg_tbl

605: -- Added this API for Bug 8397083
606: ************************************************************************************/
607:
608: PROCEDURE transform_ref_desg(
609: p_ref_desg_tbl IN inv_ebi_ref_desg_tbl
610: ,p_component_item IN inv_ebi_rev_comp_obj
611: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
612: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
613: ) IS

Line 615: l_ref_desg_tbl inv_ebi_ref_desg_tbl;

611: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
612: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
613: ) IS
614: l_output_status inv_ebi_output_status;
615: l_ref_desg_tbl inv_ebi_ref_desg_tbl;
616: l_component_item inv_ebi_rev_comp_obj;
617: l_ref_desg_count NUMBER := 0;
618: BEGIN
619:

Line 627: l_ref_desg_tbl := inv_ebi_ref_desg_tbl();

623: l_component_item := p_component_item;
624:
625: IF(p_ref_desg_tbl IS NOT NULL AND p_ref_desg_tbl.COUNT > 0 ) THEN
626:
627: l_ref_desg_tbl := inv_ebi_ref_desg_tbl();
628:
629: FOR i IN 1..p_ref_desg_tbl.COUNT LOOP
630:
631: IF(p_ref_desg_tbl(i).acd_type = 1) THEN

Line 682: l_src_ref_desg_tbl inv_ebi_ref_desg_tbl;

678: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
679: ) IS
680:
681: l_output_status inv_ebi_output_status;
682: l_src_ref_desg_tbl inv_ebi_ref_desg_tbl;
683: l_dest_ref_desg_tbl inv_ebi_ref_desg_tbl;
684: l_dest_sub_comp_tbl inv_ebi_sub_comp_tbl;
685: l_src_sub_comp_tbl inv_ebi_sub_comp_tbl;
686: l_src_component_item inv_ebi_rev_comp_obj;

Line 683: l_dest_ref_desg_tbl inv_ebi_ref_desg_tbl;

679: ) IS
680:
681: l_output_status inv_ebi_output_status;
682: l_src_ref_desg_tbl inv_ebi_ref_desg_tbl;
683: l_dest_ref_desg_tbl inv_ebi_ref_desg_tbl;
684: l_dest_sub_comp_tbl inv_ebi_sub_comp_tbl;
685: l_src_sub_comp_tbl inv_ebi_sub_comp_tbl;
686: l_src_component_item inv_ebi_rev_comp_obj;
687: l_dest_component_item inv_ebi_rev_comp_obj;

Line 756: l_dest_ref_desg_tbl := inv_ebi_ref_desg_tbl();

752: FOR i IN 1..l_src_ref_desg_tbl.COUNT LOOP
753: IF(l_src_ref_desg_tbl(i).acd_type <> 3) THEN
754:
755: IF(l_dest_component_item.reference_designator_tbl IS NULL) THEN
756: l_dest_ref_desg_tbl := inv_ebi_ref_desg_tbl();
757: l_dest_ref_desg_tbl.EXTEND(1);
758: l_is_ref_desg_tbl_new := TRUE;
759: END IF;
760:

Line 1428: l_ref_designator_tbl inv_ebi_ref_desg_tbl;

1424: l_copied_ref_designator c_copied_ref_designators%ROWTYPE;
1425: l_component_sequence_id NUMBER;
1426: l_component_item inv_ebi_rev_comp_obj;
1427: l_Found BOOLEAN;
1428: l_ref_designator_tbl inv_ebi_ref_desg_tbl;
1429: l_ref_dsgn_count NUMBER := 1;
1430: l_output_status inv_ebi_output_status;
1431:
1432: BEGIN

Line 1443: l_ref_designator_tbl := inv_ebi_ref_desg_tbl();

1439:
1440: l_component_item := p_component_item;
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);

Line 1474: l_component_item.reference_designator_tbl := inv_ebi_ref_desg_tbl();

1470: ,p_component_sequence_id => l_component_sequence_id
1471: );
1472: FETCH c_merged_ref_designators INTO l_merged_ref_designator;
1473: IF l_component_item.reference_designator_tbl IS NULL THEN
1474: l_component_item.reference_designator_tbl := inv_ebi_ref_desg_tbl();
1475: END IF;
1476: l_component_item.reference_designator_tbl.EXTEND(1);
1477:
1478: l_component_item.reference_designator_tbl(l_component_item.reference_designator_tbl.COUNT) := inv_ebi_ref_desg_obj(

Line 5065: l_reference_designator_tbl inv_ebi_ref_desg_tbl;

5061: l_eco_revision_tbl inv_ebi_eco_revision_tbl;
5062: l_eco_revision_obj inv_ebi_eco_revision_obj;
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;

Line 5646: l_reference_designator_tbl := inv_ebi_ref_desg_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;
5646: l_reference_designator_tbl := inv_ebi_ref_desg_tbl();
5647: IF (l_include_ref_designators = fnd_api.g_true) THEN
5648: FOR rd IN c_reference_designator(l_change_id,ri.revised_item_id,rc.component_item_id)
5649: LOOP
5650: l_reference_designator_tbl.extend();