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_ITEM_HELPER

Line 90: INV_EBI_ITEM_HELPER.get_uda_attributes(

86: FND_MSG_PUB.add;
87: RAISE FND_API.g_exc_error;
88: END IF;
89:
90: INV_EBI_ITEM_HELPER.get_uda_attributes(
91: p_classification_id => l_change_order_type_id,
92: p_attr_group_type => INV_EBI_UTIL.G_ENG_CHANGEMGMT_GROUP,
93: p_application_id => l_application_id,
94: p_attr_grp_id_tbl => l_attr_group_id_tbl,

Line 229: INV_EBI_ITEM_HELPER.get_uda_attributes(

225: FND_MSG_PUB.add;
226: RAISE FND_API.g_exc_error;
227: END IF;
228:
229: INV_EBI_ITEM_HELPER.get_uda_attributes(
230: p_classification_id => l_structure_type_id,
231: p_attr_group_type => INV_EBI_UTIL.G_BOM_STRUCTUREMGMT_GROUP,
232: p_application_id => l_application_id,
233: p_attr_grp_id_tbl => l_attr_group_id_tbl,

Line 370: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

366: FETCH c_bom_count INTO l_bill_sequence_id,l_structure_type_id;
367:
368: IF(c_bom_count % ROWCOUNT > 0) THEN
369:
370: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
371: p_organization_id => p_organization_id
372: ,p_item_number => p_component_item_name
373: );
374: IF c_comp_count%ISOPEN THEN

Line 408: INV_EBI_ITEM_HELPER.get_uda_attributes(

404: FND_MSG_PUB.add;
405: RAISE FND_API.g_exc_error;
406: END IF;
407:
408: INV_EBI_ITEM_HELPER.get_uda_attributes(
409: p_classification_id => l_structure_type_id,
410: p_attr_group_type => INV_EBI_UTIL.G_BOM_COMPONENTMGMT_GROUP,
411: p_application_id => l_application_id,
412: p_attr_grp_id_tbl => l_attr_group_id_tbl,

Line 1674: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

1670: l_revised_item1 inv_ebi_revised_item_obj;
1671: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1672: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
1673: l_context_org_code mtl_parameters.organization_code%TYPE;
1674: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
1675: l_component_item inv_ebi_rev_comp_obj;
1676: l_component_item1 inv_ebi_rev_comp_obj;
1677: l_eco_obj inv_ebi_eco_obj;
1678: l_from_item_id NUMBER;

Line 1723: l_from_org_id := INV_EBI_ITEM_HELPER.get_organization_id( p_organization_code => l_reference_org_code);

1719:
1720: l_from_org_id := l_revised_item.orignal_bom_reference.organization_id;
1721: l_reference_org_code := l_revised_item.orignal_bom_reference.organization_code;
1722: IF l_from_org_id IS NULL OR l_from_org_id = fnd_api.g_miss_num THEN
1723: l_from_org_id := INV_EBI_ITEM_HELPER.get_organization_id( p_organization_code => l_reference_org_code);
1724: ELSIF l_reference_org_code IS NULL OR l_reference_org_code = fnd_api.g_miss_char THEN
1725: SELECT
1726: organization_code
1727: INTO

Line 1752: l_from_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_from_org_id

1748: organization_id = l_from_org_id;
1749: END IF;
1750:
1751: IF l_from_item_id IS NULL THEN
1752: l_from_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_from_org_id
1753: ,p_item_number => l_reference_item_num);
1754: END IF;
1755:
1756: l_to_org_id := INV_EBI_ITEM_HELPER.get_organization_id ( p_organization_code => l_context_org_code);

Line 1756: l_to_org_id := INV_EBI_ITEM_HELPER.get_organization_id ( p_organization_code => l_context_org_code);

1752: l_from_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_from_org_id
1753: ,p_item_number => l_reference_item_num);
1754: END IF;
1755:
1756: l_to_org_id := INV_EBI_ITEM_HELPER.get_organization_id ( p_organization_code => l_context_org_code);
1757: l_to_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_to_org_id
1758: ,p_item_number => l_revised_item.revised_item_name) ;
1759: l_context_org_bom_exists := Is_BOM_Exists(
1760: p_item_number => l_revised_item.revised_item_name

Line 1757: l_to_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_to_org_id

1753: ,p_item_number => l_reference_item_num);
1754: END IF;
1755:
1756: l_to_org_id := INV_EBI_ITEM_HELPER.get_organization_id ( p_organization_code => l_context_org_code);
1757: l_to_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_to_org_id
1758: ,p_item_number => l_revised_item.revised_item_name) ;
1759: l_context_org_bom_exists := Is_BOM_Exists(
1760: p_item_number => l_revised_item.revised_item_name
1761: ,p_organization_code => l_context_org_code

Line 2038: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

2034:
2035: Error_Handler.initialize;
2036: IF(p_organization_code IS NOT NULL) THEN
2037:
2038: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
2039: p_organization_code => p_organization_code
2040: );
2041: END IF;
2042: IF (p_revised_item_name IS NOT NULL) THEN

Line 2043: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

2039: p_organization_code => p_organization_code
2040: );
2041: END IF;
2042: IF (p_revised_item_name IS NOT NULL) THEN
2043: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2044: p_organization_id => l_organization_id
2045: ,p_item_number => p_revised_item_name
2046: );
2047:

Line 2055: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

2051: LOOP
2052: IF(p_component_tbl(i).component_revision_uda IS NOT NULL AND p_component_tbl(i).component_revision_uda.attribute_group_tbl.COUNT > 0) THEN
2053: IF(p_component_tbl(i).component_item_name IS NOT NULL) THEN
2054:
2055: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2056: p_organization_id => l_organization_id
2057: ,p_item_number => p_component_tbl(i).component_item_name
2058: );
2059:

Line 2303: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id

2299: l_component_item_id NUMBER;
2300: BEGIN
2301:
2302: -- To Retrive revisied item id
2303: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id
2304: (p_organization_id => p_organization_id
2305: ,p_item_number => p_revised_item_name);
2306:
2307: -- Cursor to retrive the bill sequence id

Line 2314: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id

2310: EXIT;
2311: END LOOP;
2312:
2313: --To Retrive Component Item Id
2314: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id
2315: ( p_organization_id => p_organization_id
2316: ,p_item_number => p_component_item_name);
2317:
2318:

Line 2493: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(

2489:
2490: BEGIN
2491: SAVEPOINT inv_ebi_assign_item_save_pnt;
2492: x_return_status := FND_API.G_RET_STS_SUCCESS;
2493: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
2494: p_organization_id => p_organization_id
2495: ,p_item_number => p_item_name
2496: );
2497: IF (l_is_item_exists = FND_API.g_false) THEN

Line 2502: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(

2498:
2499: l_master_org := INV_EBI_UTIL.get_master_organization(
2500: p_organization_id => p_organization_id
2501: );
2502: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
2503: p_organization_id => l_master_org
2504: ,p_item_number => p_item_name
2505: );
2506:

Line 2519: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'

2515: INTO l_item_catalog_group_id, l_approval_status
2516: FROM mtl_system_items_kfv
2517: WHERE organization_id = l_master_org
2518: AND concatenated_segments = p_item_name;
2519: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'
2520: THEN
2521: FND_MSG_PUB.initialize();
2522: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');
2523: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);

Line 2542: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

2538: );
2539: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
2540: RAISE FND_API.g_exc_unexpected_error;
2541: END IF;
2542: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2543: p_organization_id => l_master_org
2544: ,p_item_number => p_item_name
2545: );
2546: --To get effectivity date of recently created revision in context org

Line 2766: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

2762: l_inventory_item_id NUMBER;
2763: l_organization_id NUMBER;
2764: l_component_item_name VARCHAR2(240);
2765: l_master_org NUMBER;
2766: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
2767: l_subst_comp_name mtl_system_items_kfv.concatenated_segments%TYPE;
2768: l_return_status VARCHAR2(10);
2769: l_msg_count NUMBER;
2770: l_output_status inv_ebi_output_status;

Line 2793: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

2789:
2790: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2791: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
2792:
2793: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
2794: l_pk_col_name_val_pairs.EXTEND(1);
2795: l_pk_col_name_val_pairs(1).name := 'organization_code';
2796: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
2797:

Line 2798: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(

2794: l_pk_col_name_val_pairs.EXTEND(1);
2795: l_pk_col_name_val_pairs(1).name := 'organization_code';
2796: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
2797:
2798: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
2799: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
2800: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
2801: );
2802: l_pk_col_name_val_pairs.TRIM(1);

Line 2800: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

2796: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
2797:
2798: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
2799: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
2800: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
2801: );
2802: l_pk_col_name_val_pairs.TRIM(1);
2803:
2804: IF (l_organization_id IS NULL) THEN

Line 2949: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

2945: END IF;
2946: IF(p_revised_item_type_tbl IS NOT NULL AND p_revised_item_type_tbl.COUNT > 0) THEN
2947: FOR i IN p_revised_item_type_tbl.FIRST..p_revised_item_type_tbl.LAST
2948: LOOP
2949: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2950: p_organization_id => l_organization_id
2951: ,p_item_number => p_revised_item_type_tbl(i).revised_item_name
2952: );
2953: -- To get effectivty date of recently created revision Bug 7197943

Line 3683: l_src_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

3679: BEGIN
3680: SAVEPOINT inv_ebi_comm_bom_save_pnt;
3681: x_return_status := FND_API.G_RET_STS_SUCCESS;
3682: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3683: l_src_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3684: p_organization_code => p_common_organization_code
3685: );
3686: l_src_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
3687: p_organization_id => l_src_organization_id

Line 3686: l_src_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

3682: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3683: l_src_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3684: p_organization_code => p_common_organization_code
3685: );
3686: l_src_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
3687: p_organization_id => l_src_organization_id
3688: ,p_item_number => p_common_assembly_item_name
3689: );
3690: l_src_bill_sequence_id := get_bill_sequence_id(

Line 3702: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

3698: FND_MSG_PUB.add;
3699: RAISE FND_API.g_exc_error;
3700: END IF;
3701:
3702: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3703: p_organization_code => p_organization_code
3704: );
3705:
3706: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

Line 3706: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

3702: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3703: p_organization_code => p_organization_code
3704: );
3705:
3706: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
3707: p_organization_id => l_organization_id
3708: ,p_item_number => p_assembly_item_name
3709: );
3710:

Line 3792: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

3788: common_organization_id = p_common_org_id;
3789:
3790: BEGIN
3791: x_return_status := FND_API.G_RET_STS_SUCCESS;
3792: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3793: p_organization_code => p_organization_code
3794: );
3795:
3796: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

Line 3796: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

3792: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3793: p_organization_code => p_organization_code
3794: );
3795:
3796: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
3797: p_organization_id => l_organization_id
3798: ,p_item_number => p_assembly_item_name);
3799:
3800: l_bill_sequence_id := get_bill_sequence_id(

Line 4892: INV_EBI_ITEM_HELPER.get_Operating_unit

4888: ,NULL
4889: ,NULL
4890: ,NULL
4891: );
4892: INV_EBI_ITEM_HELPER.get_Operating_unit
4893: (p_oranization_id => ri.organization_id
4894: ,x_operating_unit => l_item_obj.operating_unit
4895: ,x_ouid => l_item_obj.operating_unit_id
4896: );

Line 5093: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);

5089: x_return_status := FND_API.g_ret_sts_success;
5090: l_eco_output_tbl := inv_ebi_change_id_obj_tbl();
5091:
5092: IF p_org_codes IS NOT NULL THEN
5093: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);
5094: END IF;
5095:
5096: IF p_eco_tbl IS NOT NULL AND p_eco_tbl.COUNT>0 THEN
5097: FOR i in p_eco_tbl.FIRST..p_eco_tbl.LAST LOOP

Line 5121: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.filter_ecos_based_on_org';

5117:
5118: EXCEPTION
5119: WHEN OTHERS THEN
5120: x_return_status := FND_API.g_ret_sts_unexp_error;
5121: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.filter_ecos_based_on_org';
5122: END filter_ecos_based_on_org;
5123:
5124: /***************************************************************************************************
5125: -- API name : parse_and_get_eco

Line 5151: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;

5147: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5148: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
5149: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;
5150: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
5151: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
5152: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS
5153: SELECT change_id
5154: FROM eng_engineering_changes
5155: WHERE change_notice = p_chg_notice;

Line 5161: l_eco_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_eco_names);

5157: x_return_status := FND_API.g_ret_sts_success;
5158: l_eco_output_tbl :=inv_ebi_change_id_obj_tbl();
5159:
5160: IF p_eco_names IS NOT NULL THEN
5161: l_eco_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_eco_names);
5162: END IF;
5163:
5164: IF p_org_codes IS NOT NULL THEN
5165: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);

Line 5165: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);

5161: l_eco_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_eco_names);
5162: END IF;
5163:
5164: IF p_org_codes IS NOT NULL THEN
5165: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);
5166: END IF;
5167:
5168: IF l_eco_tbl IS NOT NULL AND l_eco_tbl.COUNT > 0 THEN
5169: l_valid_eco_tbl := FND_TABLE_OF_VARCHAR2_255();

Line 5243: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

5239: FND_MSG_PUB.initialize();
5240: l_count :=0;
5241: IF l_valid_org_tbl IS NOT NULL AND l_valid_org_tbl.COUNT > 0 THEN
5242: FOR j in l_valid_org_tbl.FIRST..l_valid_org_tbl.LAST LOOP
5243: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
5244: l_pk_col_name_val_pairs.EXTEND();
5245: l_pk_col_name_val_pairs(1).name := 'organization_code';
5246: l_pk_col_name_val_pairs(1).value := l_valid_org_tbl(j);
5247: l_org_id := INV_EBI_ITEM_HELPER.value_to_id( p_pk_col_name_val_pairs => l_pk_col_name_val_pairs

Line 5247: l_org_id := INV_EBI_ITEM_HELPER.value_to_id( p_pk_col_name_val_pairs => l_pk_col_name_val_pairs

5243: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
5244: l_pk_col_name_val_pairs.EXTEND();
5245: l_pk_col_name_val_pairs(1).name := 'organization_code';
5246: l_pk_col_name_val_pairs(1).value := l_valid_org_tbl(j);
5247: l_org_id := INV_EBI_ITEM_HELPER.value_to_id( p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
5248: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
5249: );
5250: l_pk_col_name_val_pairs.TRIM(1);
5251:

Line 5248: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

5244: l_pk_col_name_val_pairs.EXTEND();
5245: l_pk_col_name_val_pairs(1).name := 'organization_code';
5246: l_pk_col_name_val_pairs(1).value := l_valid_org_tbl(j);
5247: l_org_id := INV_EBI_ITEM_HELPER.value_to_id( p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
5248: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
5249: );
5250: l_pk_col_name_val_pairs.TRIM(1);
5251:
5252: l_chg_id := NULL;

Line 5389: l_from_date :=INV_EBI_ITEM_HELPER.get_last_run_date( p_conc_prog_id => p_prog_id

5385: END IF;
5386: END IF;
5387:
5388: IF (l_eco_string IS NULL AND l_from_date IS NULL AND l_to_date IS NULL AND l_last_x_hrs IS NULL) THEN
5389: l_from_date :=INV_EBI_ITEM_HELPER.get_last_run_date( p_conc_prog_id => p_prog_id
5390: ,p_appl_id => p_appl_id
5391: );
5392: l_to_date := SYSDATE;
5393: END IF;