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_ITEM_HELPER dependencies on INV_EBI_ITEM_OUTPUT_OBJ

Line 253: ,x_out OUT NOCOPY inv_ebi_item_output_obj

249: -- Function :
250: ************************************************************************************/
251: PROCEDURE populate_item_ids(
252: p_item IN inv_ebi_item_obj
253: ,x_out OUT NOCOPY inv_ebi_item_output_obj
254: ,x_item OUT NOCOPY inv_ebi_item_obj
255: ) IS
256: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
257: l_output_status inv_ebi_output_status;

Line 261: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);

257: l_output_status inv_ebi_output_status;
258: BEGIN
259: x_item := p_item;
260: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
261: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
262: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
263: IF ( (p_item.main_obj_type.organization_id IS NULL OR p_item.main_obj_type.organization_id = fnd_api.g_miss_num)
264: AND p_item.main_obj_type.organization_code IS NOT NULL ) THEN
265: l_pk_col_name_val_pairs.EXTEND(1);

Line 1169: ,x_out OUT NOCOPY inv_ebi_item_output_obj

1165: PROCEDURE process_item_pvt(
1166: p_commit IN VARCHAR2 := FND_API.g_false
1167: ,p_operation IN VARCHAR2
1168: ,p_item IN inv_ebi_item_obj
1169: ,x_out OUT NOCOPY inv_ebi_item_output_obj
1170: )
1171: IS
1172: l_transaction_type VARCHAR2(20);
1173: l_item_exits VARCHAR2(3);

Line 1203: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);

1199: SAVEPOINT inv_ebi_pvt_item_save_pnt;
1200: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');
1201: l_item := p_item;
1202: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1203: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
1204: l_item_number := l_item.main_obj_type.item_number;
1205: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
1206: IF(l_item_number IS NULL OR l_item_number = fnd_api.g_miss_char) THEN
1207: l_item_number := get_item_num(

Line 1951: ,x_uda_output_obj OUT NOCOPY inv_ebi_item_output_obj

1947: ,p_revision_id IN NUMBER DEFAULT NULL
1948: ,p_revision_code IN VARCHAR2 DEFAULT NULL
1949: ,p_uda_input_obj IN inv_ebi_uda_input_obj
1950: ,p_commit IN VARCHAR2 := fnd_api.g_false
1951: ,x_uda_output_obj OUT NOCOPY inv_ebi_item_output_obj
1952: )
1953: IS
1954: l_uda_out inv_ebi_uda_output_obj;
1955: l_attributes_row_table ego_user_attr_row_table;

Line 1966: x_uda_output_obj := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,l_uda_out,NULL,NULL,NULL,NULL);

1962: BEGIN
1963: SAVEPOINT inv_ebi_item_uda_save_pnt;
1964: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
1965: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1966: x_uda_output_obj := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,l_uda_out,NULL,NULL,NULL,NULL);
1967: INV_EBI_UTIL.transform_uda (
1968: p_uda_input_obj => p_uda_input_obj
1969: ,x_attributes_row_table => l_attributes_row_table
1970: ,x_attributes_data_table => l_attributes_data_table

Line 2095: ,x_out OUT NOCOPY inv_ebi_item_output_obj

2091: ,p_commit IN VARCHAR2 := fnd_api.g_false
2092: ,p_inventory_item_id IN NUMBER
2093: ,p_item_number IN VARCHAR2
2094: ,p_org_id_tbl IN inv_ebi_org_tbl
2095: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2096: )
2097: IS
2098: l_item_org_assignment_rec ego_item_pub.item_org_assignment_rec_type;
2099: l_item_org_assignment_tbl ego_item_pub.item_org_assignment_tbl_type;

Line 2107: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);

2103: BEGIN
2104: SAVEPOINT inv_ebi_org_id_save_pnt;
2105: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2106: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2107: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2108: IF p_org_id_tbl.COUNT > 0 THEN
2109: FOR i IN 1..p_org_id_tbl.COUNT LOOP
2110: l_item_org_assignment_rec.inventory_item_id := p_inventory_item_id;
2111: l_item_org_assignment_rec.item_number := p_item_number;

Line 2166: ,x_out OUT NOCOPY inv_ebi_item_output_obj

2162: ,p_commit IN VARCHAR2 := fnd_api.g_false
2163: ,p_inventory_item_id IN NUMBER
2164: ,p_organization_id IN NUMBER
2165: ,p_category_id_tbl IN inv_ebi_category_obj_tbl_type
2166: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2167: )
2168: IS
2169: l_transaction_type VARCHAR2(20):=ego_item_pub.g_ttype_create;
2170: l_category_output inv_ebi_category_output_obj;

Line 2177: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL);

2173: SAVEPOINT inv_ebi_cat_id_save_pnt;
2174: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2175: l_category_output := inv_ebi_category_output_obj(NULL);
2176: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2177: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL);
2178: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2179: FOR i IN 1..p_category_id_tbl.COUNT LOOP
2180: EGO_ITEM_PUB.process_item_cat_assignment(
2181: p_api_version => p_api_version

Line 2235: ,x_out OUT NOCOPY inv_ebi_item_output_obj

2231: p_commit IN VARCHAR2 := fnd_api.g_false
2232: ,p_organization_id IN NUMBER
2233: ,p_inventory_item_id IN NUMBER
2234: ,p_mfg_part_obj IN inv_ebi_manufacturer_part_obj
2235: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2236: )
2237: IS
2238: l_count NUMBER := 0;
2239: l_rowid VARCHAR2(100);

Line 2300: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);

2296: BEGIN
2297: SAVEPOINT inv_ebi_part_num_save_pnt;
2298: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');
2299: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2300: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2301: IF p_mfg_part_obj.mfg_part_num IS NOT NULL THEN
2302: OPEN c_mfg_part_num(
2303: p_manufacturer_id => p_mfg_part_obj.manufacturer_id
2304: ,p_mfg_part_num => p_mfg_part_obj.mfg_part_num

Line 2575: ,x_out OUT NOCOPY inv_ebi_item_output_obj

2571: Procedure sync_item (
2572: p_commit IN VARCHAR2 := FND_API.g_false
2573: ,p_operation IN VARCHAR2
2574: ,p_item IN inv_ebi_item_obj
2575: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2576: ) IS
2577: l_out inv_ebi_item_output_obj;
2578: l_api_version NUMBER:=1.0;
2579: l_inventory_item_id NUMBER;

Line 2577: l_out inv_ebi_item_output_obj;

2573: ,p_operation IN VARCHAR2
2574: ,p_item IN inv_ebi_item_obj
2575: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2576: ) IS
2577: l_out inv_ebi_item_output_obj;
2578: l_api_version NUMBER:=1.0;
2579: l_inventory_item_id NUMBER;
2580: l_organization_id NUMBER;
2581: l_organization_code VARCHAR2(3);

Line 2595: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);

2591: l_operating_unit_id NUMBER;
2592: BEGIN
2593: SAVEPOINT inv_ebi_sync_item_save_pnt;
2594: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2595: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2596: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
2597:
2598: --Create or update item
2599: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.sync_item '||

Line 2707: x_out := inv_ebi_item_output_obj(l_inventory_item_id,l_organization_id,l_organization_code,l_item_number,l_out.output_status,NULL,l_category_output,NULL,l_operating_unit,l_operating_unit_id);

2703: END LOOP;
2704: INV_EBI_UTIL.debug_line('STEP: 80 '||'END CALLING INV_EBI_ITEM_HELPER.process_part_num_association');
2705: END IF;
2706: END IF;
2707: x_out := inv_ebi_item_output_obj(l_inventory_item_id,l_organization_id,l_organization_code,l_item_number,l_out.output_status,NULL,l_category_output,NULL,l_operating_unit,l_operating_unit_id);
2708:
2709:
2710:
2711: IF fnd_api.to_boolean(p_commit) THEN