APPS.WSH_DETAILS_VALIDATIONS dependencies on MTL_SYSTEM_ITEMS

Line 303: from mtl_system_items

299: RETURN BOOLEAN IS
300: serial_num_ctl_code number;
301: cursor c_serial_ctl_info is
302: select serial_number_control_code
303: from mtl_system_items
304: where inventory_item_id = p_inventory_item_id
305: and organization_id = p_org_id;
306: l_serial_ctl_info c_serial_ctl_info%ROWTYPE;
307: --

Line 4694: FROM mtl_system_items msi,wsh_delivery_details wdd

4690: ) IS
4691: --Added as a part of fix for bug # 6082324 and bug 7165744 added msi.primary_uom_code to cursor
4692: cursor get_MSI_details (p_inventory_item_id NUMBER,p_delivery_detail_id NUMBER) IS
4693: SELECT msi.container_type_code,msi.maximum_load_weight,msi.primary_uom_code
4694: FROM mtl_system_items msi,wsh_delivery_details wdd
4695: WHERE msi.inventory_item_id (+) = p_inventory_item_id
4696: AND msi.organization_id (+) = wdd.organization_id
4697: AND wdd.container_flag = 'Y'
4698: AND wdd.delivery_detail_id = p_delivery_detail_id;

Line 7014: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

7010: l_msg_data VARCHAR2(32767);
7011: l_return_status VARCHAR2(32767);
7012: --
7013: -- HW OPMCONV - New variables
7014: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
7015: INVALID_LOT EXCEPTION;
7016: e_end_of_api EXCEPTION;
7017: --}
7018: BEGIN

Line 7117: , x_mtl_system_items_rec => l_item_info

7113: WSH_DELIVERY_DETAILS_INV.Get_item_information
7114: (
7115: p_organization_id => l_line_rec.organization_id
7116: , p_inventory_item_id => l_line_rec.inventory_item_id
7117: , x_mtl_system_items_rec => l_item_info
7118: , x_return_status => l_return_status
7119: );
7120:
7121: --

Line 8681: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8677: p_released_status IN VARCHAR2)
8678: RETURN BOOLEAN
8679: IS
8680:
8681: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8682: l_released_status VARCHAR2(1);
8683: l_debug_on BOOLEAN;
8684: l_return_status VARCHAR2(1);
8685: l_number_of_errors NUMBER ;

Line 8726: x_mtl_system_items_rec => l_item_info,

8722: WSH_DELIVERY_DETAILS_INV.Get_item_information
8723: (
8724: p_organization_id => p_organization_id,
8725: p_inventory_item_id => p_inventory_item_id,
8726: x_mtl_system_items_rec => l_item_info,
8727: x_return_status => l_return_status
8728: );
8729: --
8730: wsh_util_core.api_post_call

Line 8816: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8812: p_cycle_qty IN NUMBER)
8813: RETURN BOOLEAN
8814: IS
8815:
8816: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8817: l_released_status VARCHAR2(1);
8818: l_debug_on BOOLEAN;
8819: l_return_status VARCHAR2(1);
8820: l_number_of_errors NUMBER ;

Line 8854: x_mtl_system_items_rec => l_item_info,

8850: WSH_DELIVERY_DETAILS_INV.Get_item_information
8851: (
8852: p_organization_id => p_organization_id,
8853: p_inventory_item_id => p_inventory_item_id,
8854: x_mtl_system_items_rec => l_item_info,
8855: x_return_status => l_return_status
8856: );
8857: --
8858: wsh_util_core.api_post_call