APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on INV_MATERIAL_STATUS_PUB

Line 26: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

22: l_wms_org BOOLEAN;
23: l_sub_type NUMBER;
24: l_locator_status NUMBER;
25: l_loc_type NUMBER;
26: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
27: l_picking_order NUMBER;
28: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
29: BEGIN
30: IF (l_debug = 1) THEN

Line 80: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;

76: l_status_rec.organization_id := p_org_id;
77: l_status_rec.inventory_item_id := NULL;
78: l_status_rec.lot_number := NULL;
79: l_status_rec.serial_number := NULL;
80: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;
81: l_status_rec.status_id := l_locator_status;
82: l_status_rec.zone_code := p_sub_code;
83: l_status_rec.locator_id := p_locator_id;
84: l_status_rec.creation_date := SYSDATE;

Line 859: l_status_rec inv_material_status_pub.mtl_status_update_rec_type; -- bug# 1695432

855: l_return_status VARCHAR2(10);
856: l_msg_count NUMBER;
857: l_msg_data VARCHAR2(20);
858: l_label_status VARCHAR2(20);
859: l_status_rec inv_material_status_pub.mtl_status_update_rec_type; -- bug# 1695432
860: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
861: BEGIN
862: x_result := 'S';
863: l_validity_check := 'passed';

Line 973: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;

969: l_status_rec.organization_id := p_org_id;
970: l_status_rec.inventory_item_id := NULL;
971: l_status_rec.lot_number := NULL;
972: l_status_rec.serial_number := NULL;
973: l_status_rec.update_method := inv_material_status_pub.g_update_method_manual;
974: l_status_rec.status_id := l_sub_default_status;
975: l_status_rec.zone_code := p_sub_code;
976: l_status_rec.locator_id := x_location_id;
977: l_status_rec.creation_date := SYSDATE;

Line 3465: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;

3461: l_return_status VARCHAR2(10);
3462: l_msg_count NUMBER;
3463: l_msg_data VARCHAR2(20);
3464: l_label_status VARCHAR2(20);
3465: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
3466: l_required VARCHAR2(1) := 'N';
3467: l_project_id NUMBER;
3468: l_task_id NUMBER;
3469: l_picking_order NUMBER;