eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on INV_EBI_ECO_OUTPUT_OBJ

Line 46: l_uda_output_obj inv_ebi_eco_output_obj;

42: l_change_order_type_id NUMBER;
43: l_application_id NUMBER;
44: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
45: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
46: l_uda_output_obj inv_ebi_eco_output_obj;
47: l_output_status inv_ebi_output_status;
48:
49: CURSOR c_attr_group_id IS
50:

Line 60: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

56: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ');
57: INV_EBI_UTIL.debug_line('STEP 20: ECO NUMBER: '|| p_change_id);
58: x_return_status := FND_API.g_ret_sts_success;
59: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
60: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
61:
62: IF(p_change_id IS NOT NULL ) THEN
63:
64: IF c_attr_group_id%ISOPEN THEN

Line 164: l_uda_output_obj inv_ebi_eco_output_obj;

160:
161: l_application_id NUMBER;
162: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
163: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
164: l_uda_output_obj inv_ebi_eco_output_obj;
165: l_output_status inv_ebi_output_status;
166: l_structure_type_id NUMBER;
167: l_bill_sequence_id NUMBER;
168:

Line 195: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

191: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda');
192: INV_EBI_UTIL.debug_line('STEP 20: ASSY ITEM ID :' || p_assembly_item_id || 'ORG ID: '|| p_organization_id );
193: x_return_status := FND_API.g_ret_sts_success;
194: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
195: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
196:
197: IF( p_assembly_item_id IS NOT NULL AND
198: p_organization_id IS NOT NULL) THEN
199:

Line 319: l_uda_output_obj inv_ebi_eco_output_obj;

315: l_attr_group_count NUMBER :=0;
316: l_application_id NUMBER;
317: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
318: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
319: l_uda_output_obj inv_ebi_eco_output_obj;
320: l_output_status inv_ebi_output_status;
321: l_structure_type_id NUMBER;
322: l_bill_sequence_id NUMBER;
323: l_component_item_id NUMBER;

Line 364: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

360: INV_EBI_UTIL.debug_line('STEP 20: ECO NAME: '|| p_eco_name || 'REVISED ITEM ID: '|| p_revised_item_id ||
361: 'COMPONENT NAME: '|| p_component_item_name ||'ORG ID: ' || p_organization_id);
362: x_return_status := FND_API.g_ret_sts_success;
363: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
364: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
365:
366: IF( p_revised_item_id IS NOT NULL AND
367: p_organization_id IS NOT NULL) THEN
368:

Line 544: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

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;
548: l_component_item inv_ebi_rev_comp_obj;

Line 555: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

551:
552: BEGIN
553:
554: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
555: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
556:
557: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info');
558: l_component_item := p_component_item;
559: IF(p_sub_component_tbl IS NOT NULL AND p_sub_component_tbl.COUNT > 0 ) THEN

Line 612: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

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;
616: l_component_item inv_ebi_rev_comp_obj;

Line 621: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

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);
621: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
622: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg');
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

Line 678: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

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;
682: l_src_ref_desg_tbl inv_ebi_ref_desg_tbl;

Line 697: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

693: l_is_ref_desg_tbl_new BOOLEAN := FALSE;
694:
695: BEGIN
696: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
697: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
698:
699: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info');
700: l_dest_component_item := p_dest_component_item;
701: l_src_sub_comp_tbl := p_src_component_item.substitute_component_tbl;

Line 818: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

814: PROCEDURE transform_replicate_bom_info(
815: p_eco_obj_list IN inv_ebi_eco_obj_tbl
816: ,p_revised_item_obj IN inv_ebi_revised_item_obj
817: ,x_revised_item_obj OUT NOCOPY inv_ebi_revised_item_obj
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;

Line 838: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

834:
835: BEGIN
836:
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');

Line 1060: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

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
1064: IS

Line 1165: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

1161: l_sub_comp_count NUMBER := 1;
1162: l_output_status inv_ebi_output_status;
1163: BEGIN
1164: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1165: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1166: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components');
1167: OPEN c_comp_sequence_id;
1168: FETCH c_comp_sequence_id INTO l_component_sequence_id;
1169: CLOSE c_comp_sequence_id;

Line 1339: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

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
1343: IS

Line 1434: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

1430: l_output_status inv_ebi_output_status;
1431:
1432: BEGIN
1433: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1434: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1435: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators');
1436: OPEN c_comp_sequence_id;
1437: FETCH c_comp_sequence_id INTO l_component_sequence_id;
1438: CLOSE c_comp_sequence_id;

Line 1604: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

1600: ,p_view_scope IN VARCHAR2 := 'ALL'
1601: ,p_implementation_scope IN VARCHAR2 := 'ALL'
1602: ,p_as_of_date IN DATE
1603: ,x_revised_item OUT NOCOPY inv_ebi_revised_item_obj
1604: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1605: ) IS
1606: l_unit_assembly VARCHAR2(1);
1607: l_bom_item_type NUMBER;
1608: l_base_item_flag NUMBER;

Line 1814: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

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);
1814: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1815: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items');
1816: IF (bom_eamutil.enabled = 'Y'
1817: AND bom_eamutil.serial_effective_item (item_id => p_from_item_id,
1818: org_id => p_reference_org_id

Line 2300: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

2296: p_organization_code IN VARCHAR2
2297: ,p_revised_item_obj IN inv_ebi_revised_item_obj
2298: ,p_name_value_tbl IN inv_ebi_name_value_tbl
2299: ,x_revised_item_obj OUT NOCOPY inv_ebi_revised_item_obj
2300: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
2301: ) IS
2302: l_revised_item inv_ebi_revised_item_obj;
2303: l_revised_item1 inv_ebi_revised_item_obj;
2304: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;

Line 2331: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

2327:
2328: BEGIN
2329: SAVEPOINT process_replicate_bom_save_pnt;
2330: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2331: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
2332: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
2333: INV_EBI_UTIL.debug_line('STEP 20: ORG_CODE: '|| p_organization_code || ' REVISED ITEM NAME: '|| p_revised_item_obj.revised_item_name);
2334: l_context_org_code:= p_organization_code;
2335:

Line 2525: ,x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj

2521: ,p_object_name IN VARCHAR2
2522: ,p_data_level IN VARCHAR2
2523: ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2524: ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2525: ,x_uda_output_obj OUT NOCOPY inv_ebi_eco_output_obj
2526: )
2527: IS
2528: l_attributes_row_table ego_user_attr_row_table;
2529: l_attributes_data_table ego_user_attr_data_table;

Line 2539: x_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_uda_out);

2535: SAVEPOINT inv_ebi_process_uda_save_pnt;
2536: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2537: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
2538: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2539: x_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_uda_out);
2540: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_UTIL.transform_uda');
2541: --To convert inv_ebi uda objects to ego uda compatible objects
2542: INV_EBI_UTIL.transform_uda (
2543: p_uda_input_obj => p_uda_input_obj

Line 2652: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

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;
2655: l_pkcode ego_col_name_value_pair_array;
2656: l_bill_sequence_id NUMBER;

Line 2675: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

2671: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');
2672: INV_EBI_UTIL.debug_line('STEP 20: ORG CODE: '|| p_organization_code || ' ECO NAME: '|| p_eco_name || ' REVISED ITEM NAME: '|| p_revised_item_name);
2673: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
2674: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2675: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
2676:
2677: Error_Handler.initialize;
2678: IF(p_organization_code IS NOT NULL) THEN
2679:

Line 4037: x_out OUT NOCOPY inv_ebi_eco_output_obj

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;
4041: l_count NUMBER;

Line 4048: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

4044: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs');
4045: INV_EBI_UTIL.debug_line('STEP 20: ASSY ITEM NAME: '|| p_assembly_item_name || ' ORG CODE: '|| p_organization_code);
4046:
4047: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
4048: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
4049: l_common_orgs := inv_ebi_org_tbl();
4050:
4051: --Get the list of orgs to which particular bom is commoned
4052: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs');

Line 4148: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

4144: ,p_change_order IN inv_ebi_change_order_obj
4145: ,p_revision_type_tbl IN inv_ebi_eco_revision_tbl
4146: ,p_revised_item_type_tbl IN inv_ebi_revised_item_tbl
4147: ,p_name_val_list IN inv_ebi_name_value_list
4148: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
4149: ) IS
4150: l_eco_rec ENG_ECO_PUB.eco_rec_type;
4151: l_eco_revision_tbl ENG_ECO_PUB.eco_revision_tbl_type;
4152: l_revised_item_tbl ENG_ECO_PUB.revised_item_tbl_type;

Line 4204: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

4200: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');
4201: INV_EBI_UTIL.debug_line('STEP 20: ECO NUMBER: '|| p_change_order.eco_name || ' ORG CODE: '|| p_change_order.organization_code);
4202:
4203: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
4204: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
4205:
4206: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
4207: l_pk_col_name_val_pairs.EXTEND(1);
4208: l_pk_col_name_val_pairs(1).name := 'organization_code';

Line 4871: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

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
4874: l_bom_header_rec bom_bo_pub.bom_head_rec_type;
4875: l_bom_revision_tbl bom_bo_pub.bom_revision_tbl_type;

Line 4887: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

4883:
4884: BEGIN
4885: SAVEPOINT inv_ebi_proc_bom_save_pnt;
4886: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
4887: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
4888: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');
4889:
4890: l_is_bom_exists := is_bom_exists(
4891: p_item_number => p_assembly_item_name,