DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on INV_EBI_REV_COMP_OBJ

Line 542: ,p_component_item IN inv_ebi_rev_comp_obj

538: -- Added this API for Bug 8397083
539: ************************************************************************************/
540: PROCEDURE transform_substitute_comp_info(
541: p_sub_component_tbl IN inv_ebi_sub_comp_tbl
542: ,p_component_item IN inv_ebi_rev_comp_obj
543: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
544: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
545: ) IS
546:

Line 543: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj

539: ************************************************************************************/
540: PROCEDURE transform_substitute_comp_info(
541: p_sub_component_tbl IN inv_ebi_sub_comp_tbl
542: ,p_component_item IN inv_ebi_rev_comp_obj
543: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
544: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
545: ) IS
546:
547: l_sub_comp_tbl inv_ebi_sub_comp_tbl;

Line 548: l_component_item inv_ebi_rev_comp_obj;

544: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
545: ) IS
546:
547: l_sub_comp_tbl inv_ebi_sub_comp_tbl;
548: l_component_item inv_ebi_rev_comp_obj;
549: l_sub_comp_count NUMBER := 0;
550: l_output_status inv_ebi_output_status;
551:
552: BEGIN

Line 610: ,p_component_item IN inv_ebi_rev_comp_obj

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
614: l_output_status inv_ebi_output_status;

Line 611: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj

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
614: l_output_status inv_ebi_output_status;
615: l_ref_desg_tbl inv_ebi_ref_desg_tbl;

Line 616: l_component_item 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:
620: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

Line 675: p_src_component_item IN inv_ebi_rev_comp_obj

671: -- for Replicate bom
672: -- Added this API for Bug 8397083
673: ************************************************************************************/
674: PROCEDURE merge_subcomp_refdesg_info(
675: p_src_component_item IN inv_ebi_rev_comp_obj
676: ,p_dest_component_item IN inv_ebi_rev_comp_obj
677: ,x_dest_component_item OUT NOCOPY inv_ebi_rev_comp_obj
678: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
679: ) IS

Line 676: ,p_dest_component_item IN inv_ebi_rev_comp_obj

672: -- Added this API for Bug 8397083
673: ************************************************************************************/
674: PROCEDURE merge_subcomp_refdesg_info(
675: p_src_component_item IN inv_ebi_rev_comp_obj
676: ,p_dest_component_item IN inv_ebi_rev_comp_obj
677: ,x_dest_component_item OUT NOCOPY inv_ebi_rev_comp_obj
678: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
679: ) IS
680:

Line 677: ,x_dest_component_item OUT NOCOPY inv_ebi_rev_comp_obj

673: ************************************************************************************/
674: PROCEDURE merge_subcomp_refdesg_info(
675: p_src_component_item IN inv_ebi_rev_comp_obj
676: ,p_dest_component_item IN inv_ebi_rev_comp_obj
677: ,x_dest_component_item OUT NOCOPY inv_ebi_rev_comp_obj
678: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
679: ) IS
680:
681: l_output_status inv_ebi_output_status;

Line 686: l_src_component_item inv_ebi_rev_comp_obj;

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;
688: l_ref_desg_count NUMBER := 0;
689: l_sub_comp_exists BOOLEAN;
690: l_sub_comp_count NUMBER :=0;

Line 687: l_dest_component_item inv_ebi_rev_comp_obj;

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;
688: l_ref_desg_count NUMBER := 0;
689: l_sub_comp_exists BOOLEAN;
690: l_sub_comp_count NUMBER :=0;
691: l_ref_desg_exists BOOLEAN;

Line 1056: p_component_item IN inv_ebi_rev_comp_obj

1052: -- Type : Private
1053: -- Function : Prepare substitute components for Replicate bom
1054: ************************************************************************************/
1055: PROCEDURE prepare_substitute_components(
1056: p_component_item IN inv_ebi_rev_comp_obj
1057: ,p_from_sequence_id IN NUMBER
1058: ,p_reference_org_id IN NUMBER
1059: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
1060: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

Line 1059: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj

1055: PROCEDURE prepare_substitute_components(
1056: p_component_item IN inv_ebi_rev_comp_obj
1057: ,p_from_sequence_id IN NUMBER
1058: ,p_reference_org_id IN NUMBER
1059: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
1060: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1061: ) IS
1062:
1063: CURSOR c_comp_sequence_id

Line 1157: l_component_item inv_ebi_rev_comp_obj;

1153: sc.component_sequence_id = p_component_sequence_id;
1154:
1155: l_component_sequence_id NUMBER;
1156: i NUMBER := 0;
1157: l_component_item inv_ebi_rev_comp_obj;
1158: l_Found BOOLEAN;
1159: l_merged_subst_comp c_Merged_Substitute_Comp%ROWTYPE;
1160: l_substitute_comp_tbl inv_ebi_sub_comp_tbl;
1161: l_sub_comp_count NUMBER := 1;

Line 1335: p_component_item IN inv_ebi_rev_comp_obj

1331: -- Type : Private
1332: -- Function : Prepare reference_designators for Replicate bom
1333: ************************************************************************************/
1334: PROCEDURE prepare_reference_designators(
1335: p_component_item IN inv_ebi_rev_comp_obj
1336: ,p_from_sequence_id IN NUMBER
1337: ,p_reference_org_id IN NUMBER
1338: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
1339: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

Line 1338: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj

1334: PROCEDURE prepare_reference_designators(
1335: p_component_item IN inv_ebi_rev_comp_obj
1336: ,p_from_sequence_id IN NUMBER
1337: ,p_reference_org_id IN NUMBER
1338: ,x_component_item OUT NOCOPY inv_ebi_rev_comp_obj
1339: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1340: ) IS
1341:
1342: CURSOR c_comp_sequence_id

Line 1426: l_component_item inv_ebi_rev_comp_obj;

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

Line 1685: p_new_comp_item IN inv_ebi_rev_comp_obj

1681: (UPPER(p_implementation_scope) = G_IMPLEMENT_SCOPE_IMPLEMENT AND implementation_date IS NOT NULL) OR
1682: (UPPER(p_implementation_scope) = G_IMPLEMENT_SCOPE_UNIMPLEMENT AND implementation_date IS NULL));
1683:
1684: CURSOR c_merged_component (
1685: p_new_comp_item IN inv_ebi_rev_comp_obj
1686: ,p_component_item_name IN VARCHAR2
1687: ,p_operation_sequence_number IN NUMBER
1688: ,p_bill_sequence_id IN NUMBER
1689: ) IS

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

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(
1890: p_revised_item.start_effective_date
1891: ,p_revised_item.start_effective_date
1892: ,l_merged_comp.disable_date
1893: ,l_copied_comp.operation_seq_num

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

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);
1971: FETCH c_merged_component INTO l_Merged_Comp;
1972: l_revised_item.component_item_tbl(i) := inv_ebi_rev_comp_obj(
1973: l_merged_comp.start_effective_date
1974: ,l_merged_comp.new_effectivity_date
1975: ,l_merged_comp.disable_date
1976: ,l_revised_item.component_item_tbl(i).operation_sequence_number

Line 2308: l_component_item inv_ebi_rev_comp_obj;

2304: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;
2305: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
2306: l_context_org_code mtl_parameters.organization_code%TYPE;
2307: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
2308: l_component_item inv_ebi_rev_comp_obj;
2309: l_component_item1 inv_ebi_rev_comp_obj;
2310: l_eco_obj inv_ebi_eco_obj;
2311: l_from_item_id NUMBER;
2312: l_to_item_id NUMBER;

Line 2309: l_component_item1 inv_ebi_rev_comp_obj;

2305: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
2306: l_context_org_code mtl_parameters.organization_code%TYPE;
2307: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
2308: l_component_item inv_ebi_rev_comp_obj;
2309: l_component_item1 inv_ebi_rev_comp_obj;
2310: l_eco_obj inv_ebi_eco_obj;
2311: l_from_item_id NUMBER;
2312: l_to_item_id NUMBER;
2313: l_from_sequence_id NUMBER;

Line 5068: l_revision_component_obj inv_ebi_rev_comp_obj;

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;
5072: l_current_index NUMBER;

Line 5729: l_revision_component_obj := inv_ebi_rev_comp_obj(

5725: END LOOP;
5726: END IF; -- IF (l_include_sub_comp = fnd_api.g_true) THEN
5727:
5728: l_revision_component_tbl.extend();
5729: l_revision_component_obj := inv_ebi_rev_comp_obj(
5730: NULL
5731: ,NULL
5732: ,rc.disable_date
5733: ,rc.operation_seq_num