APPS.WSH_DETAILS_VALIDATIONS dependencies on MTL_SYSTEM_ITEMS

Line 309: from mtl_system_items

305: RETURN BOOLEAN IS
306: serial_num_ctl_code number;
307: cursor c_serial_ctl_info is
308: select serial_number_control_code
309: from mtl_system_items
310: where inventory_item_id = p_inventory_item_id
311: and organization_id = p_org_id;
312: l_serial_ctl_info c_serial_ctl_info%ROWTYPE;
313: --

Line 4869: FROM mtl_system_items msi,wsh_delivery_details wdd

4865: ) IS
4866: --Added as a part of fix for bug # 6082324 and bug 7165744 added msi.primary_uom_code to cursor
4867: cursor get_MSI_details (p_inventory_item_id NUMBER,p_delivery_detail_id NUMBER) IS
4868: SELECT msi.container_type_code,msi.maximum_load_weight,msi.primary_uom_code
4869: FROM mtl_system_items msi,wsh_delivery_details wdd
4870: WHERE msi.inventory_item_id (+) = p_inventory_item_id
4871: AND msi.organization_id (+) = wdd.organization_id
4872: AND wdd.container_flag = 'Y'
4873: AND wdd.delivery_detail_id = p_delivery_detail_id;

Line 7304: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

7300: l_msg_data VARCHAR2(32767);
7301: l_return_status VARCHAR2(32767);
7302: --
7303: -- HW OPMCONV - New variables
7304: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
7305: INVALID_LOT EXCEPTION;
7306: e_end_of_api EXCEPTION;
7307: --}
7308: BEGIN

Line 7407: , x_mtl_system_items_rec => l_item_info

7403: WSH_DELIVERY_DETAILS_INV.Get_item_information
7404: (
7405: p_organization_id => l_line_rec.organization_id
7406: , p_inventory_item_id => l_line_rec.inventory_item_id
7407: , x_mtl_system_items_rec => l_item_info
7408: , x_return_status => l_return_status
7409: );
7410:
7411: --

Line 8971: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8967: p_released_status IN VARCHAR2)
8968: RETURN BOOLEAN
8969: IS
8970:
8971: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8972: l_released_status VARCHAR2(1);
8973: l_debug_on BOOLEAN;
8974: l_return_status VARCHAR2(1);
8975: l_number_of_errors NUMBER ;

Line 9023: x_mtl_system_items_rec => l_item_info,

9019: WSH_DELIVERY_DETAILS_INV.Get_item_information
9020: (
9021: p_organization_id => p_organization_id,
9022: p_inventory_item_id => p_inventory_item_id,
9023: x_mtl_system_items_rec => l_item_info,
9024: x_return_status => l_return_status
9025: );
9026: --
9027: wsh_util_core.api_post_call

Line 9121: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

9117: p_cycle_qty IN NUMBER)
9118: RETURN BOOLEAN
9119: IS
9120:
9121: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
9122: l_released_status VARCHAR2(1);
9123: l_debug_on BOOLEAN;
9124: l_return_status VARCHAR2(1);
9125: l_number_of_errors NUMBER ;

Line 9159: x_mtl_system_items_rec => l_item_info,

9155: WSH_DELIVERY_DETAILS_INV.Get_item_information
9156: (
9157: p_organization_id => p_organization_id,
9158: p_inventory_item_id => p_inventory_item_id,
9159: x_mtl_system_items_rec => l_item_info,
9160: x_return_status => l_return_status
9161: );
9162: --
9163: wsh_util_core.api_post_call